-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> I renamed a couple tables, and the names of their
> corresponding sequences remained the same. This causes
> a problem because when importing - the create table
> statements create sequences with different names, then
> the setval() statements use the old names. Any way to
> automatically avoid this "gotcha"?
Don't rely on the create table to make the sequences for
you: declare them yourself. Instead of this:
CREATE TABLE foobar (
id SERIAL
);
Try this:
CREATE SEQUENCE barbell_seq;
CREATE TABLE foobar (
id INTEGER NOT NULL DEFAULT nextval('barbell_seq')
);
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200312172134
-----BEGIN PGP SIGNATURE-----
iD8DBQE/4RJjvJuQZxSWSsgRAgEdAJ9y4eDaQENuRWVRETJdLu/vKO5PggCeKLjs
dkPyceUBRMkTbvcqMBAgLr4=
=5b5j
-----END PGP SIGNATURE-----
