Re: serial column

[Bob Pawley <rjpawley(at)shaw(dot)ca>]

Yes

But the only way of insuring that the serial starts at 1 and is sequential 
is to recreate the table.

I've tried creating and dropping the table but this generates other issues 
which I haven't been able to resolve.

Bob

----- Original Message ----- 
From: "Gevik Babakhani" <pgdev(at)xs4all(dot)nl>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, September 24, 2006 2:00 PM
Subject: Re: [GENERAL] serial column


> On Sun, 2006-09-24 at 13:50 -0700, Bob Pawley wrote:
> > I need to develop a serial column that always starts at 1 and is
> > sequential even after deletes.
> >  
> > Any ideas???
> >  
>
> Did you try the:
>
> create table tbl
> (
> id SERIAL
> );
>
> or even with primary key...
>
> create table tbl
> (
> id SERIAL primary key
> );
>
>
> --
> Regards,
> Gevik Babakhani
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq