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

Re: sequence last_value

From: Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in>
To: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: sequence last_value
Date: 2001-10-13 11:51:21
Message-ID: 3BC82AB9.47FBE8FC@giaspn01.vsnl.net.in (view raw or flat)
Thread:
Lists: pgsql-novice
The syntax for insertion could be like

insert into loc (bulding_key,floor,ref) values (1,1 'help');

If you have dropped table, it would be necessary to drop
key_location_seq explicitly.

Vijay

"Duncan Adams (DNS)" wrote:
> 
> Hi
> 
> I really need help on this one. can any one please explain to me how
> "SERIAL PRIMARY KEY "
>
> wireman=# insert into loc values (1,1,'HELP');
> ERROR:  Cannot insert a duplicate key into unique index loc_pkey



In response to

pgsql-novice by date

Next:From: Vijay DevalDate: 2001-10-13 11:57:40
Subject: Re: installation problem -please help
Previous:From: Josh BerkusDate: 2001-10-12 22:57:04
Subject: Re: installation problem -please help

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