Skip site navigation (1) Skip section navigation (2)

ToDo: plpgsql plugin for query and expression verification

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ToDo: plpgsql plugin for query and expression verification
Date: 2010-02-16 08:05:55
Message-ID: 162867791002160005q44d5362eo2db235a83736fa96@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello

I thinking about more restrictive query and expression checking than
now. Used parser checking isn't enough - so some possible bugs can be
detected in production stage. Other problem is  using any expression
as SELECT expr.  The request on validation can be different and it is
probably for more advanced users - so it could be wrapped to some
plugin. So users can exactly set an level for checking that is the
best for they.

postgres=# set check_function_bodies to on;SET
postgres=#
create or replace function foo(a varchar, b varchar)
returns varchar as $$
begin
  a = current_date; -- result type is different then target type
  return a || b || c;    -- simple expression has unknown symbol
end;
$$ language plpgsql;
CREATE FUNCTION

I think, so these problem have to be identified in compile stage - but
it can be too strict for all (and can slow down production) - it is
reason for plugin.

What do you think about this idea?

Regards
Pavel Stehule

Responses

pgsql-hackers by date

Next:From: Boszormenyi ZoltanDate: 2010-02-16 08:08:21
Subject: Re: [GENERAL] libecpg versions and libecpg_compat
Previous:From: Greg SmithDate: 2010-02-16 07:41:40
Subject: Re: psycopg2 license changed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group