Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group