Am 27.06.2013 19:10, schrieb Tom Lane:
daniel.degasp...@r3-gis.com writes:
CREATE TABLE t23456789012345678901234567890123456789012345678901
(
t1234_id serial,
PRIMARY KEY (t1234_id)
)
WITH (
OIDS=FALSE
);
This generated the sequence:
CREATE SEQUENCE
t234567890123456789012345678901234567
daniel.degasp...@r3-gis.com writes:
> CREATE TABLE t23456789012345678901234567890123456789012345678901
> (
> t1234_id serial,
> PRIMARY KEY (t1234_id)
> )
> WITH (
> OIDS=FALSE
> );
> This generated the sequence:
> CREATE SEQUENCE
> t2345678901234567890123456789012345678901234567890_t1234_i
Object names are limited to a length of NAMEDATALEN-1, which defaults to
63, and are documented to be truncated.
http://www.postgresql.org/docs/9.2/static/sql-syntax-lexical.html
The behaviour you are observing appears to conform to the documentation,
and seems reasonable, so I wouldn't think thi
The following bug has been logged on the website:
Bug reference: 8260
Logged by: Daniel Degasperi
Email address: daniel.degasp...@r3-gis.com
PostgreSQL version: 9.1.7
Operating system: Centos 6.4
Description:
I've created a table:
CREATE TABLE t234567890123456789012
