| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vijay Deval | 2001-10-13 11:57:40 | Re: installation problem -please help |
| Previous Message | Josh Berkus | 2001-10-12 22:57:04 | Re: installation problem -please help |