Dump serials as serial -- not a sequence - Mailing list pgsql-patches

From Rod Taylor
Subject Dump serials as serial -- not a sequence
Date
Msg-id 1029115167.239.22.camel@jester
Whole thread Raw
Responses Re: Dump serials as serial -- not a sequence  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Dump serials as serial -- not a sequence  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
- Fix an issue indexing domains.  Ensure we look for the operator class
of the base type, not the domain type.
- Add an is_serial boolean attribute to sequence tables.
- Add serial4 and serial8 domains with respective serial and bigserial
aliases (similar to int4 and int8 to integer and bigint)
- Jump through hoops to deal with a primary key'd serial column, alter
table add primary key doesn't work for these.
- Fix type sanity checks to account for domains.

End result, pg_dump no longer uses sequences for serials and psql shows
serials rather than integer columns.

Attachment

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PGPASSWORDFILE env var for libpq
Next
From: Bruce Momjian
Date:
Subject: Re: stand-alone composite types patch (was [HACKERS] Proposal: