Re: Query Problem - Mailing list pgsql-general

From Dave Page
Subject Re: Query Problem
Date
Msg-id 937d27e10807060356t6175aa18w44584f7fb3c42a0a@mail.gmail.com
Whole thread Raw
In response to Query Problem  (Sheikh Salman Ahmed <salman_sheikh@hotmail.com>)
List pgsql-general
On Sun, Jul 6, 2008 at 12:04 AM, Sheikh Salman Ahmed
<salman_sheikh@hotmail.com> wrote:

> res = PQexec(conn, "INSERT INTO public.Person VALUES

Without quotes around Person, it will be shifted to lower case to
match a table called person. I suspect you need to do:

res = PQexec(conn, "INSERT INTO public.\"Person\" VALUES

It's almost always easier to use lower case names in Postgres.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

pgsql-general by date:

Previous
From: "Matt Magoffin"
Date:
Subject: Re: Memory use in 8.3 plpgsql with heavy use of xpath()
Next
From: "Dave Page"
Date:
Subject: Re: Installation problem -- another installation is in progress