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