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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lassejohnsen(at)bulldogcommunications(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #711: Automatic created indexes can in some cases not be referenced to
Date: 2002-07-12 14:57:24
Message-ID: 9705.1026485844@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-07-12 15:11:06
Subject: Re: postgres.h MACRO issues
Previous:From: praveen vejandlaDate: 2002-07-12 13:23:50
Subject: getting only date

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