Skip site navigation (1) Skip section navigation (2)

Re: sequence... my nightmare :-(

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sequence... my nightmare :-(
Date: 2008-09-27 16:21:26
Message-ID: 75645bbb0809270921w4e69f1emf8608b62fa5d886f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
if i double-quote it, postgre tells me that the column accounts_id_seq does
not exist.

On Sat, Sep 27, 2008 at 5:59 PM, Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> wrote:

> >
> > 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(at)test(dot)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

In response to

Responses

pgsql-general by date

Next:From: Douglas McNaughtDate: 2008-09-27 16:37:31
Subject: Re: PostgreSQL future ideas
Previous:From: Mark MielkeDate: 2008-09-27 16:13:24
Subject: Re: PostgreSQL future ideas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group