Re: PostgreSQL compilation with custom table name length

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL compilation with custom table name length
Date: 2002-11-21 22:04:31
Message-ID: 029501c291aa$7f9452d0$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Or you could move to 7.3rc1 --- NAMEDATALEN is 64 by default in 7.3.

Does this mean that serial sequence names will change?

For example, instead of:

test=# create table reallylongtablename (reallylongserialname serial);
NOTICE: CREATE TABLE will create implicit sequence
'reallylongtab_reallylongser_seq' for SERIAL column
'reallylongtablename.reallylongserialname'

It will be:

test=# create table reallylongtablename (reallylongserialname serial);
NOTICE: CREATE TABLE will create implicit sequence
'reallylongtablename_reallylongserialname_seq' for SERIAL column
'reallylongtablename.reallylongserialname'

Greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-11-21 22:09:14 Re: Request assistance connecting with Pg::connectdb
Previous Message Gregory Wood 2002-11-21 21:52:30 Re: Rép. : [GENERAL] double quotes around table and column names