From: | Ian Barwick <barwick(at)gmx(dot)net> |
---|---|
To: | "jack" <datactrl(at)tpg(dot)com(dot)au>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: EXECUTE problem on schema |
Date: | 2003-03-28 08:34:59 |
Message-ID: | 200303280934.59317.barwick@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Friday 28 March 2003 01:59, jack wrote:
(...)
> And the following are the example.
Aha, the problem is not EXECUTE but QUOTE_IDENT:
test=# SELECT quote_ident('public.test_j2');
quote_ident
------------------
"public.test_j2"
(1 row)
test=# SELECT * FROM "public.test_j2";
ERROR: Relation "public.test_j2" does not exist
which is correct, because schema and relation names can contain periods.
To quote a schema-qualified relation name you need something like
"public"."test_j2" (or "public"."table.with_period_in_name") which
quote_indent can't handle because it doesn't know whether the
period is a schema / relation name divider or part of the relation name.
This has come up before, see:
http://archives.postgresql.org/pgsql-hackers/2002-11/msg00892.php
It would probably be easiest to leave out the quote_ident from your
function definition and do the quoting manually in the function call,
if necessary, which mostly isn't.
Ian Barwick
barwick(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Childs | 2003-03-28 10:15:31 | field defaults |
Previous Message | Popeanga Marian | 2003-03-28 05:43:27 | Re: How to configure two netcard for PostgreSQL? |