Postgres Pro
Downloads
Home   >   mailing lists

Re: elegant way to fill a table with serial - Mailing list pgsql-general

From Tom Lane
Subject Re: elegant way to fill a table with serial
Date
Msg-id 3754.1196918163@sss.pgh.pa.us
Whole thread Raw
In response to elegant way to fill a table with serial  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view 
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> ... BTW I saw there is no OWNED BY in 8.1, is there any other way to
> auto-drop sequences when columns get dropped?

In previous versions, a sequence object that was auto-created as a
result of a SERIAL column declaration will be auto-dropped when that
column is dropped.  8.2's OWNED BY syntax is just a way of exposing
that mechanism more formally, and letting you tweak the state.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4 end of life
Next
From: "Chris Velevitch"
Date:
Subject: Understanding how partial indexes work?