Re: [INTERFACES] Bug in psql?

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)