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

Moving sequences to another schema

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: PostgreSQL-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Moving sequences to another schema
Date: 2005-06-27 23:43:27
Message-ID: 7C497D6E6EE1BE19A3D28337@sparkey.oopsware.intra (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
I'm still playing around with the ALTER OBJECT SET SCHEMA stuff. I managed 
to alter indexes and constraints as well for tables, but with SERIAL 
sequences there is one little problem:

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). Is there an API to do that, or do i have to 
recreate the executable expression tree from scratch? Or am i missing 
something completely...





pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-06-27 23:58:29
Subject: Re: For review: dbsize patch
Previous:From: Hiroshi SaitoDate: 2005-06-27 22:01:43
Subject: Re: tsearch2 vs core?

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