From: | Bruce Tong <zztong(at)laxmi(dot)ev(dot)net> |
---|---|
To: | leif(at)danmos(dot)dk |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] Bug in psql? |
Date: | 1999-05-11 12:50:07 |
Message-ID: | Pine.LNX.4.04.9905110846330.30630-100000@laxmi.ev.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> 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.
Have you tried putting the following into a file and using...
# psql -f foo.sql
... to run it? I _think_ this sometimes gives different messages than
entering it directly on the psql command line, although I'm not sure why.
I could be way off here, but its worth a try.
> create table globalafvigelse
> (
> globalafvigelse serial ,
> startdato date,
> slutdato date,
> dagskema varchar(50),
> primary key (globalafvigelse)
> );
What is type "serial"? It probably not incorrect, but I've not heard of it
before.
Bruce Tong | Got me an office; I'm there late at night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century
From | Date | Subject | |
---|---|---|---|
Next Message | leif | 1999-05-11 13:21:33 | Re: [INTERFACES] Bug in psql? |
Previous Message | Peter Mount | 1999-05-11 10:11:42 | RE: [INTERFACES] Java and PGSQL date question |