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
