a few requests based on developing plpgsql_lint - maybe ToDo points

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: a few requests based on developing plpgsql_lint - maybe ToDo points
Date: 2011-07-21 04:47:41
Message-ID: CAFj8pRB+uNLsdLfw7SdEbX0JefH3-3wWA163t=jB1qYgyrUWrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

the basic issue is deployment of plpgsql plugins - they needs to
include "plpgsql.h", but this include file is not public. Next
significant issue is impossibility to serialize plpgsql plugins. Only
one should be supported. A limit is a access to persistent data via
estate->plugin_info. Others issues are not too significant - but can
to simplify a plugin development

1. move plpgsql.h to shared "include" directory
2. allow more active plpgsql plugins in one time
3. allow access to function's result or statement's result - minimum
is access to rc
4. allow to create a temporary copy of plpgsql's statements and
execute this copy - not original
5. a hooks for execution handler's calls - is not possible to handle a
situation, when function ends with exception
6. a hook for validation
7. publish exec_prepare_plan with possibility to add hook to this function

Regards

Pavel Stehule

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-07-21 04:48:38 Re: isolation test deadlocking on buildfarm member coypu
Previous Message Josh Kupershmidt 2011-07-21 03:38:03 Re: patch: Allow \dd to show constraint comments