> > when i write the following query i get the error :ERROR: > relation > "accounts_id_seq" does not exist > SET search_path = test_survey; > insert into accounts values > (nextval('accounts_ID_seq'),'test@test.com','ab4ef51934f2d3f02f1a','11/19/2007 > 15:46:09'); > > why ? >
It's lowercasing the relation name, note "accounts_id_seq" not "accounts_ID_seq". Try double quoting it.
-- Alain ------------------------------------ Windows XP SP3 PostgreSQL 8.2.4 / MS SQL server 2005 Apache 2.2.4 PHP 5.2.4 C# 2005-2008