--On Dienstag, Juni 28, 2005 01:43:27 +0200 Bernd Helmle <[EMAIL PROTECTED]> wrote:

When altering a sequence created by a SERIAL column type (i do this by
examining pg_depend to avoid moving any other sequences that are
'foreign'), i need to recreate the default expression for the SERIAL
column (stored in pg_attrdef.adbin).

I currently recognized that a SERIAL column doesn't only create an implicit sequence, it creates an implicit composite type with the same name, too. I think this is the same for CREATE SEQUENCE?

--


 Bernd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to