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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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