470,581 Members | 2,357 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

nextval problem

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:

select nextval('public."ADDRESS_addressid_seq"')

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?
Jul 19 '05 #1
0 2621

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

117 posts views Thread by Peter Olcott | last post: by
7 posts views Thread by pfa | last post: by
28 posts views Thread by Jon Davis | last post: by
7 posts views Thread by Rahul B | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.