Re: pg_dump incorrect sequence value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua L(dot) San Juan" <josh(dot)sanjuan(at)q-linux(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump incorrect sequence value
Date: 2003-09-03 16:05:58
Message-ID: 21890.1062605158@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Joshua L. San Juan" <josh(dot)sanjuan(at)q-linux(dot)com> writes:
> but in the second table - the sequence was incorrect:
> SELECT pg_catalog.setval ('table2_id_seq', 1, true);

It seems fairly hard to believe that what pg_dump emitted was not the
actual state of the sequence object. Why do you think this is incorrect?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message psql-mail 2003-09-03 16:06:09 postmaster crashing
Previous Message Dennis Gearon 2003-09-03 15:50:18 Re: What is the good equivalent for ENUM ?