>
> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
