Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] data type "serial"

From: Teodor Cimpoesu <teo(at)digiro(dot)net>
To:
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] data type "serial"
Date: 1999-09-23 00:08:25
Message-ID: 37E96F79.57C2CE6B@digiro.net (view raw or flat)
Thread:
Lists: pgsql-general
Michael wrote:
> 
> > >
> > > So how do you store something in data type serial?
> > > I've created the column but everytime I attempt to do an update I get
> > > back the error message that I can't store a duplicate key.
> > >
> > > table_col_seq.last_value = 1
> > > increment = 1
> > > maxvalue = 2billion something
> > >
> > > I've tried storing 1,2,some other number in "serial" in the main
> > > table to no avail. What is the magic to get this to work. There
> > > appears to be no documentation anywhere on the necessary SQL commands
> > > to cycle the generator. I've tried the method used for Oracle SQL but
> > > that does not work. I'm a bit of a newbie at this.
> > >
> > > Michael
> > > Michael(at)bizsystems(dot)com
> >
> > You cant insert into a serial as far as I know.
> >
> > The serial is simply incrimented automatically whenever a new INSERT
> > is done on the table.
> 
> Hmmm.... that's a real problem when adding it to an existing table.
? you can create another serial, starting @ max(serial attr)+1
> The values I get back on a select indicate all blanks. I've got
> several hundred records in the table at the moment. There must be a
> way to update the darn things.
it should not, how do you make that select 7 what's the table
definition?
> 
> Michael
> Michael(at)bizsystems(dot)com
> 
> ************

-- 
CIMPOESU Teodor, Web Programmer (h)
@ DIGICOM S.A. Bucharest, Romania
@ Internet, site development
@ teo(at)digiro(dot)net, +(401)-330.47.28

official home page ~ http://www.digiro.net/
Internet web  page ~ http://internet.digiro.net/


In response to

pgsql-general by date

Next:From: MichaelDate: 1999-09-23 00:17:31
Subject: data type "serial"
Previous:From: Michael SimmsDate: 1999-09-22 23:36:58
Subject: Re: [GENERAL] data type "serial"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group