Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA19420
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 11 May 1999 10:03:07 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA13272;
	Tue, 11 May 1999 10:01:08 -0400 (EDT)
To: leif@danmos.dk
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in psql? 
In-reply-to: Your message of Tue, 11 May 1999 01:44:12 +0200
	<199905102344.BAA16427@crysberg.dk>
Date: Tue, 11 May 1999 10:01:08 -0400
Message-ID: <13270.926431268@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

leif@danmos.dk writes:
>  I tried to create the table below using psql, but it bombed out
> with a message about loosing the backend, though the backend was
> still running nicely. It seems to be a problem with the long
> field name of the serial (and primary key) column.

You didn't say which version you are using, but 6.5-current returns a
more helpful error message:

ERROR:  CREATE TABLE/SERIAL implicit sequence name must be less than 32 characters
        Sum of lengths of 'globalafvigelse' and 'globalafvigelse' must be less than 27

This is forced by the naming conventions for the underlying sequence and
index objects, which look like "TABLE_FIELD_seq" and so forth.

			regards, tom lane