Re: Moving sequences to another schema - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Moving sequences to another schema
Date
Msg-id 2DF000A0E60B0FD258FD75A7@sparkey.oopsware.intra
Whole thread Raw
In response to Moving sequences to another schema  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: Moving sequences to another schema
List pgsql-hackers
--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


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: contrib/rtree_gist into core system?
Next
From: Fabien COELHO
Date:
Subject: Re: [PATCHES] Users/Groups -> Roles