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

Re: Need help with currval and nextvall...

From: Dan Jewett <danjewett(at)mac(dot)com>
To: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Need help with currval and nextvall...
Date: 2002-11-22 19:27:42
Message-ID: p05200f0bba04345c3c3c@[162.84.132.56] (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-novice
>You need to quote (single quotes) the name of the sequence... and you need
>to use nextval('album_album_id_seq') before calling currval().
>
>At least I think so.

Thanks Phillip,

I know I'm supposed to have the quotes but I keep getting : 
PostgreSQL said: ERROR: parser: parse error at or near 
"album_album_id_seq"  unless I take them out.

I also tried nextval() with the same error returned: ERROR: Attribute 
'album_album_id_seq' not found.

Dunnoh,

Dan

In response to

Responses

pgsql-novice by date

Next:From: Philip HallstromDate: 2002-11-22 19:36:54
Subject: Re: Need help with currval and nextvall...
Previous:From: Philip HallstromDate: 2002-11-22 19:05:08
Subject: Re: Need help with currval and nextvall...

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