I'm new to postgresql and I'm having problems with the 'nextval' function
(or whatever it is called in postgresql).
I created a table (called ADDRESS) using 'pgadmin' which has a serial field
(called addressid). When I tried the sql statement:
everything seemed to be working fine.
I then used the create table statement (displayed in pgadmin when the table
'ADDRESS' is selected) to create the same table (of course after first
dropping 'ADDRESS'). When I try the same select-statement I suddenly got an
error message saying:
ERROR: Relation "public"."ADDRESS_addressid_seq" does not exist
Can anybody help me with this problem?
pgsql-novice by date
|Next:||From: beyaNet Consultancy||Date: 2004-02-13 09:23:41|
|Previous:||From: Lynn.Tilby||Date: 2004-02-12 23:55:44|
|Subject: Re: "NULL value without indicator"|
pgsql-sql by date
|Next:||From: David Witham||Date: 2004-02-13 02:30:10|
|Subject: Index question|
|Previous:||From: ow||Date: 2004-02-13 01:22:53|
|Subject: Re: 7.4 - FK constraint performance |