Re: Moving sequences to another schema

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: Moving sequences to another schema
Дата
Msg-id 2DF000A0E60B0FD258FD75A7@sparkey.oopsware.intra
обсуждение исходный текст
Ответ на Moving sequences to another schema  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: Moving sequences to another schema  (Michael Glaesemann <grzm@myrealbox.com>)
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: contrib/rtree_gist into core system?
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: [PATCHES] Users/Groups -> Roles