Vote On A New Newsgroup Proposal

Jul 23, 2005

Vote for or against a new newsgroup proposal.

To summarize what you need to do, just send an empty e-mail to
Join Bytes!

You'll receive a ballot by e-mail. Follow the instructions and vote.

__________________________________________________ _____________________

FIRST CALL FOR VOTES (of 2)
unmoderated group comp.databases.postgresql

Newsgroups line:
comp.databases.postgresql PGSQL Relational Database Management System.

Votes must be received by 23:59:59 UTC, 9 Apr 2005.

This vote is being conducted by a neutral third party. Questions about
the proposed group should be directed to the proponent.

Proponent: Mike Cox <mikecoxlinux@yahoo.com>
Votetaker: Bill Aten <bill@netagw.com>

RATIONALE: comp.databases.postgresql

To provide a Big-Eight usenet group for users of the PostgreSQL
Relational Database Management System. Currently there are mailing
lists gated to the public pgsql.* hierarchy. Issues with mailing
list gateways, and the much larger distribution of the Big-Eight
hierarchy make it extremely desirable to have a PostgreSQL group
in the Big Eight.

CHARTER: comp.databases.postgresql

The newsgroup comp.databases.postgresql is a usenet discussion group
for the PostgreSQL Relational Database Management System. Topics
of discussion may include:

GENERAL
* General discussions of PostgreSQL.
* Assisting beginners in using the PostgreSQL Relational Database
Management system.
* Help answer basic questions.

ADMINISTRATION
* Discussions pertaining to the administration, compilation
and installation of PostgreSQL.
* Announcements of new versions of PostgreSQL, PostgreSQL
related software, and documentation.
* Administration of PostgreSQL interfaces, including JDBC and ODBC.
* Administration and installation of the Contrib packages.
* Using PostgreSQL Point in Time Recovery.
* Startup scripts, or scripts that automate PostgreSQL related tasks.

DEVELOPING WITH POSTGRESQL
* Programming using PostgreSQL.
* Developing with PostgreSQL interfaces, including JDBC and ODBC.

SCALABILITY
* PostgreSQL performance, benchmarking and related topics.
* How to use Replication in PostgreSQL.
* Hardware, Software configurations and recommendations for optimal
PostgreSQL operation. Examples are x86-64, NUMA, etc.

SECURITY
* Announcements of patches that fix vulnerabilities.
* PostgreSQL Best practices to design and keep PostgreSQL secure.
* SSH, SSL, and the Crypto Contrib packages.

SQL
* Normalization and theory as it applies to PostgreSQL.
* Transactions, Indices, Cursors, Triggers, and Nested Transactions.
* PostgreSQL specific topics such as Objects.

END CHARTER.

HOW TO VOTE:

In order to vote on this proposal you will first need to request a
registered ballot. This is accomplished by sending an email to the
address specified below from the email account that you intend to use
when you submit the ballot for processing. The Subject: and body of
the message does not matter. They can both be blank (preferred) if
your software will allow that.

PLEASE, do not send this entire message back to me as this mail is
archived.

Mail your ballot request to: <postgresql-ballot@netagw.com>
Just "replying" to this message should work, but check the "To:" line.

When your email message is received, a reply message will be sent to
you with further instructions regarding how to vote. You will also
receive a copy of the CFV which will contain a ballot that is
registered for use only for this CFV, and only when submitted from the
exact same address that originally requested it.

IMPORTANT VOTING PROCEDURE NOTES:

Standard Guidelines for voting apply. Only one vote per person, no
more than one vote per account. Votes must be mailed directly from
the voter to the votetaker. Anonymous, forwarded, or proxy votes
are not valid. Votes mailed by WWW/HTML/CGI forms are considered
to be anonymous votes.

Vote counting is automated. Failure to follow these directions may
mean that your vote does not get counted. If you do not receive an
acknowledgment of your vote within three days, contact the votetaker
about the problem. It's your responsibility to make sure your vote
is registered correctly. Duplicate votes are resolved in favor of
the most recent valid vote. Names, addresses, and votes of all voters
will be published in the final voting RESULT posting.

DO NOT redistribute this CFV in any manner whatsoever. The purpose of
a Usenet vote is to determine the genuine interest of persons who would
read a proposed newsgroup. Soliciting votes from disinterested parties
defeats this purpose. Only the votetaker, the news.announce.newgroups
moderator, and the proponent (if specifically authorized by the
votetaker) are permitted to distribute copies of this CFV.

Distribution of pre-marked or otherwise modified copies of this CFV is
generally considered voting fraud and should be reported immediately to
the votetaker or the UVV <contact@uvv.org>. In cases where voting fraud
is determined to have occurred, it is standard operating procedure to
delete ALL votes submitted by the violator. When in doubt, ask the
votetaker.

DISTRIBUTION:

The only official sources for copies of this CFV are the locations
listed below, the UVV web site at http://www.uvv.org/, and the
votetaker's e-mail CFV server which can be reached at
<postgresql-cfv-request@netagw.com>.

This CFV has been posted to the following newsgroups:

news.announce.newgroups
news.groups
comp.databases
comp.os.linux.misc
comp.unix.bsd.freebsd.misc

View 14 Replies


ADVERTISEMENT

Help With DDL Trigger. Moved From Other Newsgroup.

Mar 26, 2008

I haven't gotten a response yet, so I moved this from another group. Ihave been working on this for 2 days so if anyone has any ideas, Iwould be grateful.I have a 3rd party program that creates and populates tables in mySQLServer 2005 database.The program fails on the inserts on "tblB" because the field itcreates is too small for the data that it is trying to put in it(stupid).I wrote a DDL trigger that attempts to alter the table as soon as itcreated, allowing all the data to be loaded.However, something about this trigger causes a prior table "tblA" tofail.Here is the error message that I get on inserting into tblA with thetrigger for tblB in place:Execution of this SQL statement failed: Create table tblA(STATUSCHAR(1) NOT NULL DEFAULT'', SCHOOLNUM[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT failed becausethe following SET options have incorrect settings:'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify thatSET options are correct for use with indexed views and/or indexes o(yes, it truncates the error message)My trigger is basically:USE [IGPLINK]GO/****** Object: DdlTrigger [NO_SOUP_FOR_YOU] Script Date:03/24/2008 16:04:42 ******/SET ARITHABORT ONGOSET CONCAT_NULL_YIELDS_NULL ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOSET ANSI_PADDING ONGOSET ANSI_WARNINGS ONGOSET NUMERIC_ROUNDABORT OFFGOCREATE TRIGGER [NO_SOUP_FOR_YOU] ON DATABASEFOR CREATE_TABLEASSET NOCOUNT ONDECLARE @xmlEventData XML,@tableName VARCHAR(50)SET @xmlEventData = eventdata()SET @tableName = CONVERT(VARCHAR(25), @xmlEventData.query('data(/EVENT_INSTANCE/ObjectName)'))IF @tableName ='tblB'BEGINALTER TABLE dbo.tblB ALTER COLUMN STULINK Numeric(16,0)ENDHowever, when I have enterprise manager script my trigger, it looksaltered. I think these ON/OFF settings at the end are screwing thingsup. Any suggestions?USE [IGPLINK]GO/****** Object: DdlTrigger [NO_SOUP_FOR_YOU] Script Date:03/25/2008 11:10:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TRIGGER [NO_SOUP_FOR_YOU] ON DATABASEFOR CREATE_TABLEASSET NOCOUNT ONDECLARE @xmlEventData XML,@tableName VARCHAR(50)SET @xmlEventData = eventdata()SET @tableName = CONVERT(VARCHAR(25), @xmlEventData.query('data(/EVENT_INSTANCE/ObjectName)'))IF @tableName ='tblB'BEGINALTER TABLE dbo.tblB ALTER COLUMN STULINK Numeric(16,0)ENDGOSET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER OFFGOENABLE TRIGGER [NO_SOUP_FOR_YOU] ON DATABASE

View 7 Replies View Related

Vote For The Select All Issue Of SP2

Mar 16, 2007

Anyone who has installed SP2 will notice that RS now adds in the auto "Select All" on multi-value parameters. This was removed with SP1 but its back, and its causing me and other developers a lot of trouble as we have created custom "Select All" option in multi-value paramters to address the removal of it in SP1.

Why dont MS make this auto "Select All" configurable, it should be an option, but its not.

If this is a problem for you then vote for the issue here....maybe if MS sees thats it is a big issue they may include a fix in a hotfix.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249227

View 1 Replies View Related

Vote Query Logic Selection

Jun 3, 2006

Hello,
I have a requirement to select millions of rows from table and need do some parsing each row. I have identity column on each table.
Here is the query logic I'm following.
Logic A:Uisng While loop processing data row by row
Logic B: Using Cursor Processing row by row

Here is the perormance on the above ran against .5 millions rows of data.

Logic A: Logic B:
CPU usage 564254 464511
Duration 18 15

The above result after completion of the data
The below is from query analyser
Estimated query Cost 21% 79%

Can we trust Estimated query cost? and Which logic you will choose use?.

View 1 Replies View Related

Can Not Find This Newgroup On Outlook Newsgroup...Help

Dec 3, 2006

Hi Seir,

I'm new to SQL and want to learn beginning SQL..

But onlye microsoft.pulic.hk.microsoftsql appear on the newsgroup in

the Outlook. So how to subscribe this news group (or the anoter for beginner)

in the Outlook for me to read it OFFLINE...

thank so much for the help.

Johan

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved