issue with select currval - Mailing list pgsql-general

Hi,

I have a table "photo" where my primary key is name "photo_id" (only serial value is stored there).

when i type :
select currval('photo_photo_id_seq');

the answer is :
ERROR:  relation "photo_photo_id_seq" does not exist

whereas the "relation photo_photo_id_seq" exists

So where is the problem ? should i specify the schema ? (schema is : immense)

if i type :
SELECT photo_id FROM immense.photo ORDER BY photo_id DESC LIMIT 1
i get what i want (the last serial/index value used by my table)

thanks for help.

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5