From: leif@danmos.dk
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in psql?
Date: Thu, 13 May 1999 11:39:34 +0200
Message-ID: <199905130939.LAA24156@crysberg.dk> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: leif@danmos.dk
Subject: Re: [INTERFACES] Bug in psql?
In-Reply-To: <199905130939.LAA24156@crysberg.dk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox