Re: Bug #711: Automatic created indexes can in some cases not be referenced to

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug #711: Automatic created indexes can in some cases not be referenced to
Дата
Msg-id 9705.1026485844@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bug #711: Automatic created indexes can in some cases not be referenced to  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
pgsql-bugs@postgresql.org writes:
> # CREATE TABLE WHOIS_BLOCK_TABLE_DATE (
> #         BLOCK           SERIAL     UNIQUE,
> #         CREATE          INT,            -- Timestamp
> #         UPDATE          INT             -- Timestamp
> # );
> NOTICE:  CREATE TABLE will create implicit sequence 'whois_block_table_dat_block_seq' for SERIAL column
'whois_block_table_date.block'
                                                                         ^^^
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'whois_block_table_dat_block_key' for table
'whois_block_table_date'
> CREATE
> # GRANT ALL ON WHOIS_BLOCK_TABLE_DATE_BLOCK_SEQ TO freeipdb;
                                   ^^^^
> NOTICE:  identifier "whois_block_table_date_block_seq" will be truncated to "whois_block_table_date_block_se"
> ERROR:  relation "whois_block_table_date_block_se" not found

I don't see a bug here.  The system told you how it would truncate the name...

            regards, tom lane

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

Предыдущее
От: "praveen vejandla"
Дата:
Сообщение: getting only date
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres.h MACRO issues