Re: Need help with currval and nextvall...

> >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.

Huh... well, what happens if you just run:

SELECT NEXTVAL('album_album_id_seq');

directly in psql?

-philip