Skip site navigation (1) Skip section navigation (2)

Re: I'm very confused.

From: Brant Fitzsimmons <brant(at)bfcomputerconsulting(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org, Jasbinder Singh Bali <jsbali(at)gmail(dot)com>
Subject: Re: I'm very confused.
Date: 2007-01-17 15:10:47
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
Hash: SHA1

Sean Davis wrote:
> On Wednesday 17 January 2007 09:54, Brant Fitzsimmons wrote:
>> Sean Davis wrote:
>>> On Wednesday 17 January 2007 03:06, Brant Fitzsimmons wrote:
>>>> Jasbinder Singh Bali wrote:
>>>>> Please attach a snippet of your python script and lets see
>>>>> what are you doing there. That might make things easy. Jas
>>>> Here is the entire test script:
>>>> #!/usr/bin/python
>>>> # import pgdb module import pgdb
>>>> # connect to the db db = pgdb.connect(host="localhost",
>>>> database="test", user="postgres", password="**********")
>>>> # instantiate cursor cursor = db.cursor()
>>>> # insert 10 records for x in range(10):
>>>> cursor.execute("INSERT INTO users (username, firstname,
>>>> lastname, email, age) VALUES ('brant', 'Brant',
>>>> 'Fitzsimmons', 'brant(at)bfcomputerconsulting(dot)com', 31)")
>>> Put in a db.commit() statement here.  Does that fix your
>>> problem?
>> It sure does.  Any idea why it would drive up the serial column
>> even though nothing was committed?
> Great to hear....
> A serial column is a macro to make a sequence and then to fill the
> column with the default "next_val" from the sequence.  The mere
> selection of next_val increases the sequence, which is necessary to
> ensure that all connections get a unique value when selecting from
> the same sequence.
> Sean

I see.

Thanks for your help and thanks to everyone who contributed ideas.
The quick response was unexpected and very encouraging.

- --
Brant Fitzsimmons
- -------------------------------------------------------------------
"Strange times are these in which we live when the old and the
young are taught falsehoods in the schools of learning. And the one
man that dares to tell the truth is called at once a lunatic and
a fool."
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla -


In response to


pgsql-novice by date

Next:From: Ray StellDate: 2007-01-17 15:53:02
Subject: Re: I'm very confused.
Previous:From: Sean DavisDate: 2007-01-17 14:57:56
Subject: Re: I'm very confused.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group