I have PG SQL 8.1 running on a RHEL 4 system (64 bit).
I have numerous tables, all of which were created with
CREATE TABLE someTable (myID SERIAL, someField varchar . . .etc
Postgres created numerous sequences for me and it all seemed to work great. Elsewhere I have lots of java code that gets the values of the sequences out like:
"SELECT last_value FROM simulation_probability_of_occ_simulation_probability_of_occ_seq"
Which also seems to work great.
Now I did a dump/restore to send it to a client and I have the following problem:
In the first DB (the one that works) I have this in the table def for the table (from PGAdmin III):
simulation_probability_of_occurence_id integer NOT NULL DEFAULT nextval('simulation_probability_of_occ_simulation_probability_of_oc_seq4'::regclass),
And in the restored DB I have this:
simulation_probability_of_occurence_id integer NOT NULL DEFAULT nextval('simulation_probability_of_occ_simulation_probability_of_oc_seq3'::regclass),
This is wreaking all kinds of havoc with my Java code. I’ve tried exporting with and without OIDs (from PGADMIN III) with no apparent change.
Is there something I can do to keep those sequences in the right places?
Thanks
Aaron Parks