New feature for posgreSQL 7.3 & later -- sequences are automatically dropped
when the owning table is dropped -- you need to recreate the sequence
The easiest way is in your CREATE TABLE tblName (
id serial PRIMARY KEY,
blah...,
blah...,
) WITH OIDS;
--
Greg Patnude / The Digit
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
