Re: [GENERAL] error while generating and EXECUTEing a query dynamically
Hi all, Sorry for following up to my own mail. I went over the function again and realized I was exceeding the size I had allocated for the query string. Never realised I was exceeding the varchar(1000) that I had declared as the string. Apologies for my last follow-up to my query, I sent it 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 machine I am sending this mail from does not have postgres, but I > did this just this morning so am typing from memory: > -- Sleep: A completely inadequate substitute for caffeine. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] error while generating and EXECUTEing a query dynamically
Your function worked fine for me (I copied and pasted). What PostgeSQL version are you running? EXECUTE is a new feature for version 7.1. - Original Message - From: "Gaurav Priyolkar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 12, 2001 1:15 PM Subject: [GENERAL] error while generating and EXECUTEing a query dynamically > 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 sql; > > RETURN 1; > > END; > ' LANGUAGE 'plpgsql'; > > > > > > Now when I try to execute this function I get an error message saying > > > parse error at or near "" > > > > I will get the exact function and error output from other machine > tomorrow (the actual query I am generating is more complex) but in the > meantime if anyone can help with this example, I would be most > grateful. Where am I going wrong? > > TIA > > Gaurav > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > > ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] error while generating and EXECUTEing a query dynamically
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 sql; RETURN 1; END; ' LANGUAGE 'plpgsql'; Now when I try to execute this function I get an error message saying parse error at or near "" I will get the exact function and error output from other machine tomorrow (the actual query I am generating is more complex) but in the meantime if anyone can help with this example, I would be most grateful. Where am I going wrong? TIA Gaurav ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html