Re: sequence... my nightmare :-(
| От | Alain Roger |
|---|---|
| Тема | Re: sequence... my nightmare :-( |
| Дата | |
| Msg-id | 75645bbb0809270921w4e69f1emf8608b62fa5d886f@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: sequence... my nightmare :-( (Glyn Astill <glynastill@yahoo.co.uk>) |
| Ответы |
Re: sequence... my nightmare :-(
Re: sequence... my nightmare :-( |
| Список | pgsql-general |
if i double-quote it, postgre tells me that the column accounts_id_seq does not exist.
--
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
On Sat, Sep 27, 2008 at 5:59 PM, Glyn Astill <glynastill@yahoo.co.uk> wrote:
>It's lowercasing the relation name, note "accounts_id_seq" not "accounts_ID_seq". Try double quoting it.
> 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 ?
>
--
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
В списке pgsql-general по дате отправления: