Re: frustrated by plpgsql procedure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dino Vliet <dino_vliet(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: frustrated by plpgsql procedure
Date: 2006-03-27 19:28:05
Message-ID: 16520.1143487685@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dino Vliet <dino_vliet(at)yahoo(dot)com> writes:
> I trying for days to get this simple plpgsql procedure
> to run but I keep getting this error:

You can't ordinarily use a variable to supply a table (or field) name
in a plpgsql query; that doesn't work because plpgsql wants to cache a
plan for the query. A workaround is to build the query as a string
value, then use EXECUTE.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2006-03-27 19:43:07 Re: frustrated by plpgsql procedure
Previous Message Bricklen Anderson 2006-03-27 19:27:45 Re: frustrated by plpgsql procedure