> > 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'),'[EMAIL > PROTECTED]','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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general