Re: [GENERAL] sequences not restoring properly

2006-01-20 Thread Brian Dimeler
ust have chucked garments_garmentid_seq and its value in favor of the one that appeared to match the table and column. The other tables had their values restored correctly, it's just that their *names* are now a little *too* 'correct'. Brian Joshua D. Drake wrote: Bria

Re: [GENERAL] sequences not restoring properly

2006-01-20 Thread Brian Dimeler
Doing it that way doesn't produce any errors, but it still produces incorrect sequence names and values. Doug McNaught wrote: Brian Dimeler <[EMAIL PROTECTED]> writes: I'm trying to transition a database from one server to another, the old one running Postgres 7.4.1 an

[GENERAL] sequences not restoring properly

2006-01-20 Thread Brian Dimeler
I'm trying to transition a database from one server to another, the old one running Postgres 7.4.1 and the new, 8.1.1. When I try to restore using a pg_dump plaintext sql file from a nightly backup via the usual psql thedb < backup.sql It works for the most part, but encounters several errors