Re: Sequences/defaults and pg_dump - Mailing list pgsql-general

From Tom Lane
Subject Re: Sequences/defaults and pg_dump
Date
Msg-id 7236.1139326560@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sequences/defaults and pg_dump  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
List pgsql-general
Nikolay Samokhvalov <samokhvalov@gmail.com> writes:
> Forget about SERIAL. I have INTEGER column with some expression as
> DEFAULT in it.

No, you have a SERIAL column that you've improperly mucked with the
implementation of.  If you'd declared it as INTEGER to start with,
you could do whatever you wanted to its default expression.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Sequences/defaults and pg_dump
Next
From: "John D. Burger"
Date:
Subject: Re: Sequences/defaults and pg_dump