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]
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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