pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: José Soares <jose@sferacarta.com>
To: leif@danmos.dk
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Bug in psql?
Date: Tue, 11 May 1999 17:13:17 +0200
Message-ID: <3738490D.AE934DD9@sferacarta.com> (raw)
References: <199905111321.PAA18600@crysberg.dk>

leif@danmos.dk ha scritto:

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

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'





view thread (10+ messages)  latest in thread

Message-ID: <3738490D.AE934DD9@sferacarta.com>
Permalink:  ../3738490D.AE934DD9@sferacarta.com/
Also on:    postgresql.org/message-id/3738490D.AE934DD9@sferacarta.com

 · 

reply
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: jose@sferacarta.com, leif@danmos.dk
  Subject: Re: [INTERFACES] Bug in psql?
  In-Reply-To: <3738490D.AE934DD9@sferacarta.com>

* 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