| From: | "Dave Page" <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | "Sheikh Salman Ahmed" <salman_sheikh(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Query Problem |
| Date: | 2008-07-06 10:56:14 |
| Message-ID: | 937d27e10807060356t6175aa18w44584f7fb3c42a0a@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Jul 6, 2008 at 12:04 AM, Sheikh Salman Ahmed
<salman_sheikh(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2008-07-06 10:59:14 | Re: Installation problem -- another installation is in progress |
| Previous Message | Matt Magoffin | 2008-07-06 08:02:18 | Re: Memory use in 8.3 plpgsql with heavy use of xpath() |