From: leif@danmos.dk
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Bug in psql?
Date: Tue, 11 May 1999 15:21:33 +0200
Message-ID: <199905111321.PAA18600@crysberg.dk> (raw)
Hello Bruce,
On: Tue, 11 May 1999 08:50:07 -0400 (EDT)
Bruce Tong <zztong@laxmi.ev.net> 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.
>
>
> Have you tried putting the following into a file and using...
>
> # psql -f foo.sql
I actually did from a file, but with the \i command.
>
> ... 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.
>
The data type serial is a standard data type, which is also included in
PostgreSQL ;-). M$Access calls it 'Autonumber' and is simply an integer (I
think it is most common to be an int4) that is automatically incremented for
each insert. I think that it is implemented in PostgreSQL using a sequenser.
I tried to change the name of the serial field: globalafvigelse -> id,
and then it works. I think it is because postgresql automatically creates a
sequence called <table name>_<field name>_seq, which is limited in size.
Greetings,
Leif
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: <199905111321.PAA18600@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