Re: Moving sequences to another schema

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: PostgreSQL-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Moving sequences to another schema
Date: 2005-06-30 11:13:37
Message-ID: 2DF000A0E60B0FD258FD75A7@sparkey.oopsware.intra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On Dienstag, Juni 28, 2005 01:43:27 +0200 Bernd Helmle
<mailings(at)oopsware(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2005-06-30 11:39:09 Re: [PATCHES] Users/Groups -> Roles
Previous Message Oleg Bartunov 2005-06-30 10:59:21 Re: contrib/rtree_gist into core system?