Dynamically created tables [WAS Re: [GENERAL] "Relation x does not exist" ...

2001-10-17 Thread Gaurav Priyolkar
On Tue, Oct 16, 2001 at 01:22:45AM -0700, Randal L. Schwartz wrote: > >>>>> "Gaurav" == Gaurav Priyolkar <[EMAIL PROTECTED]> writes: > > Gaurav> Not feasible, because some functions have dynamically created > Gaurav> tables so I need to re-creat

Re: [GENERAL] error while generating and EXECUTEing a query dynamically

2001-09-15 Thread Gaurav Priyolkar
from the wrong id and it seems as if the text of my message got stripped out and only quoted part got through.(In fact I remember having snipped most of my original mail while sending too :( -Gaurav On Wed, Sep 12, 2001 at 11:45:16PM +0530, Gaurav Priyolkar wrote: > Hi all, > > The mac

[GENERAL] error while generating and EXECUTEing a query dynamically

2001-09-12 Thread Gaurav Priyolkar
Hi all, The machine I am sending this mail from does not have postgres, but I did this just this morning so am typing from memory: CREATE FUNCTION footable() RETURNS INTEGER AS ' DECLARE sql VARCHAR(1000); BEGIN sql := ''CREATE TABLE foo (x INT, y CHAR) ''; EXECUTE sq