BUG #2307: Buckup and sequences in DEFAULT part

Поиск
Список
Период
Сортировка
От Giza Kamil
Тема BUG #2307: Buckup and sequences in DEFAULT part
Дата
Msg-id 20060308102720.1B546F0B08@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2307: Buckup and sequences in DEFAULT part  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2307
Logged by:          Giza Kamil
Email address:      kamilg@zeto.olsztyn.pl
PostgreSQL version: 8.1.3
Operating system:   Windows,Linux
Description:        Buckup and sequences in DEFAULT part
Details:

Hi!
My script is:
CREATE SEQUENCE schema.seq_taid;
CREATE TABLE schema.tab1(ID integer DEFAULT nextval('schema.seq_taid'));

After runing on server I have:

CREATE TABLE schema.tab1(ID integer DEFAULT
nextval('schema.seq_taid'::regclass));

but on 8.0 version was

CREATE TABLE schema.tab1(ID integer DEFAULT
nextval(('schema.seq_taid'::text)::regclass));

Buckups on 8.0 were OK, but on 8.1 I'm getting samething like that:
CREATE TABLE schema.tab1(ID integer DEFAULT nextval('seq_taid'::regclass));
Buckup cat schema name from sequence name in function nextval in DEFAULT
part.

Problem exists in buckups in PgAdmin and pg_buckup from command line on
server.

Is there any kind of solution for that or I have to wait for next version.
It's a very important for me to resolve this problem as quickly as
possible.

Best regards,
Kamil Giza

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Matthew George"
Дата:
Сообщение: BUG #2308: pg_dump -a does not respect referential dependencies
Следующее
От: "Alexander Pivovarov"
Дата:
Сообщение: BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03'