From: | "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com> |
---|---|
To: | "Brant Fitzsimmons" <brant(at)bfcomputerconsulting(dot)com> |
Subject: | Re: I'm very confused. |
Date: | 2007-01-17 12:32:56 |
Message-ID: | a47902760701170432u551f2300r1a93b4a43fa757fb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
This is what your table creation script is like for table 'users' that
doesn't have any field named 'age'
>I created a table from the prompt using: create table users (userID
>serial, userName varchar(32), firstName varchar(32), lastName
>varchar(64), email varchar(128));
Now when you are inserting the values in this table using your python
script, it says something like
> cursor.execute("INSERT INTO users (username, firstname, lastname,
>email, age) VALUES ('brant', 'Brant', 'Fitzsimmons',
>'brant(at)bfcomputerconsulting(dot)com', 31)")
Field 'age' doesn't exist atall in table 'users' and hence the
transaction would not commit.
Thanks,
~Jas
On 1/17/07, Brant Fitzsimmons <brant(at)bfcomputerconsulting(dot)com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> 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)")
>
> # retrieve the data
> cursor.execute("SELECT * FROM users")
> result = cursor.fetchall()
>
> # print data to the screen
> for line in result:
> print line
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.3 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFFrc/TDpzwx2t8E5gRAu2UAJ9/xlk6EaSPAWyE5XRp50qftb3xRQCeKwtS
> HwNXoc2k91/hlxVHnexm05U=
> =vm0M
> -----END PGP SIGNATURE-----
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brant Fitzsimmons | 2007-01-17 14:54:22 | Re: I'm very confused. |
Previous Message | Sean Davis | 2007-01-17 11:25:01 | Re: I'm very confused. |