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

Re: next integer in serial key

From: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
To: <terry(at)ashtonwoodshomes(dot)com>,"Postgresql Sql Group (E-mail)" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: next integer in serial key
Date: 2004-07-22 11:40:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
On Thursday 22 July 2004 05:18 pm, terry(at)ashtonwoodshomes(dot)com wrote:

> Alternatively, you can do:
> INSERT  (accepting the default)
> then SELECT currval(the_sequence_object);
> then <extra inserts of related foreign key records>

did this. barf: foreign key not in original table
kg - hotel bookings reservations in over 4600 
hotels in India

In response to

pgsql-sql by date

Next:From: terryDate: 2004-07-22 11:48:22
Subject: Re: next integer in serial key
Previous:From: OelnDate: 2004-07-22 10:17:14
Subject: Issue with plpgsql trigger

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