BUG #8260: problem with sequence and tablename - Mailing list pgsql-bugs

From daniel.degasperi@r3-gis.com
Subject BUG #8260: problem with sequence and tablename
Date
Msg-id E1UsE64-0000eC-MR@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8260: problem with sequence and tablename
Re: BUG #8260: problem with sequence and tablename
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8260
Logged by:          Daniel Degasperi
Email address:      daniel.degasperi@r3-gis.com
PostgreSQL version: 9.1.7
Operating system:   Centos 6.4
Description:

I've created a table:


CREATE TABLE t23456789012345678901234567890123456789012345678901
(
  t1234_id serial,
  PRIMARY KEY (t1234_id)
)
WITH (
  OIDS=FALSE
);


This generated the sequence:


CREATE SEQUENCE
t2345678901234567890123456789012345678901234567890_t1234_id_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;


The table-part in the sequence name was truncated.


Best regards,
Daniel

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #8257: Multi-Core Restore fails when containing index comments
Next
From: Christopher Browne
Date:
Subject: Re: BUG #8260: problem with sequence and tablename