Re: [INTERFACES] Bug in psql?

leif(at)danmos(dot)dk ha scritto:

> Hello Bruce,
>
> On: Tue, 11 May 1999 08:50:07 -0400 (EDT)
> Bruce Tong <zztong(at)laxmi(dot)ev(dot)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
>

SERIAL is a very usefull data type but it is not standard. :)

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

______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'