Re: Moving sequences to another schema

--On Dienstag, Juni 28, 2005 01:43:27 +0200 Bernd Helmle 
<mailings@oopsware.de> 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