From: Michael Fuhr <mike@fuhr.org>
To: Greg Wittel <gwittel@proofpoint.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
Date: Thu, 8 Feb 2007 04:23:31 -0700
Message-ID: <20070208112331.GA75899@winnie.fuhr.org> (raw)
In-Reply-To: <45CA5601.1090007@proofpoint.com>
References: <45CA5601.1090007@proofpoint.com>
On Wed, Feb 07, 2007 at 02:43:13PM -0800, Greg Wittel wrote:
> I'm having a strange problem with a PL/PGSQL query that executes some
> dynamic SQL code. The code basically creates a dynamically named table,
> some indexes, etc.
>
> The problem seems to be the an index expression. If I remove it and do a
> plain index on the column, all works correctly. If I keep it, I get a
> "relation does not exist" error.
The error appears to happen for anything that uses SPI. A C function
that executes the following fails with the same error:
SPI_exec("CREATE TABLE foo (t text); CREATE INDEX foo_idx ON foo (lower(t))", 0);
In 8.2.3 the error location is:
LOCATION: RangeVarGetRelid, namespace.c:200
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, gwittel@proofpoint.com
Subject: Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression
In-Reply-To: <20070208112331.GA75899@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox