On Mar 22, 2005, at 10:04 PM, Tony Caduto wrote:
Ok, here is a example
CREATE OR REPLACE FUNCTION mytest();
RETURNS VOID as
$$
DECLARE
mytestvar varchar;
mytestvar2 integer;
BEGIN
mytestvarr = 'bla';
select testfield from nonexistanttable where testfield = 2 INTO mytestvar2;
--The table does not exits, yet postgresql does not complain.
END;
$$
LANGUAGE 'plpgsql' VOLATILE;
I also seem to remember that one of the 8.0 betas actually did better checking, but then it was gone in the next beta. I could be wrong on that though.
Also if you happen to use PLperl or any of the other ones, do they actually do better checking than PLpgsql? Last time I used a PLperl function it didn't do any checking at creation either.
I think (from experience rather than knowledge) that that is still the case as of 8.0.1. I know Tom Lane and I had a brief discussion on one of the lists on the subject a month or two ago, but I can't seem to find the emails.
Sean
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
