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 14:54:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hash: SHA1

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?

- --
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: Sean DavisDate: 2007-01-17 14:57:56
Subject: Re: I'm very confused.
Previous:From: Jasbinder Singh BaliDate: 2007-01-17 12:32:56
Subject: Re: I'm very confused.

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