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

Re: I'm very confused.

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Brant Fitzsimmons <brant(at)bfcomputerconsulting(dot)com>
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 14:57:56
Message-ID: 200701170957.56400.sdavis2@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Brant FitzsimmonsDate: 2007-01-17 15:10:47
Subject: Re: I'm very confused.
Previous:From: Brant FitzsimmonsDate: 2007-01-17 14:54:22
Subject: Re: I'm very confused.

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