Received: from mail.crysberg.dk (root@square.crysberg.dk [194.192.196.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA22166
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 13 May 1999 05:39:39 -0400 (EDT) (envelope-from leif@danmos.dk)
From: leif@danmos.dk
Received: from crysberg.dk (root@samba.crysberg.dk [194.192.196.12])
	by mail.crysberg.dk (8.8.5/8.8.5) with ESMTP id LAA19958
	for <pgsql-interfaces@postgreSQL.org>; Thu, 13 May 1999 11:44:51 +0200
Received: from danmos.dk (cdslj.crysberg.dk [194.192.196.20])
	by crysberg.dk (8.8.7/8.8.7) with SMTP id LAA24156
	for <pgsql-interfaces@postgreSQL.org>; Thu, 13 May 1999 11:39:34 +0200
Date: Thu, 13 May 1999 11:39:34 +0200
Message-Id: <199905130939.LAA24156@crysberg.dk>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in psql?
Content-Type: text


   Hi again,

    Thanks to all of you who responded to this one. It was a great
help. I think I got the picture: don't let the length of <table name>
plus <field name> exceed 26/27 characters for the serial type. I guess
this goes for primary key as well.


Earlier, I wrote:

>  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.

    I am using v6.4.2. I am glad to learn it has been fixed (with
an error message in stead of crashing.)

> 
> create table globalafvigelse 
>   (
>     globalafvigelse serial ,
>     startdato date,
>     slutdato date,
>     dagskema varchar(50),
>     primary key (globalafvigelse) 
>   );


    Greetings,

  Leif
  (leif@danmos.dk)