Re: pg_dump + serial + sequence problem

Hi, Tom
Thanks for reply

I understood, that this isn't so critical, but may causes surprises, so
I reported for someone pay atention that this can occur.
By the way I try to drop the sequence, but I can't because they still
owned by the column. So I can't be able to remove this
reference without drop de column and recreate it.


Tom Lane wrote:
> "Luiz K. Matsumura" <luiz@planit.com.br> writes:
>
>> CREATE TABLE teste
>> (
>>    id serial,
>>    ...
>> ALTER TABLE teste  ALTER COLUMN id DROP DEFAULT;
>>
>
> This isn't supported before 8.2, since as you found out pg_dump is
> unable to reproduce the situation in the database --- the sequence is
> still marked as "owned by" the column even though there's no default
> anymore.  We aren't going to try to fix that behavior in the older
> branches.
>
>             regards, tom lane
>
>
>

--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.