Re: [GENERAL] Feature enhancement request : use of libgda

Jean-Michel POURE wrote:
>
> CREATE OR REPLACE VIEW / TRIGGER and ALTER TABLE DROP COLUMN are real
> priorities for us at pgAdmin team (http://pgadmin.postgresql.org). I don't
> know PostgreSQL internals, but it should take a few days/weeks to an
> experienced hacker to add these features.

Jean-Michel,

    I think you underestimate the problem a little.

    Doing  CREATE OR REPLACE is not that trivial as you appear to
    think.  The existing PL handlers (for PL/Tcl and PL/pgSQL  at
    least)   identify   functions  by  their  pg_proc  OID.   The
    functions body text is parsed only on the first call to  that
    function during the entire session. So changing the functions
    prosrc attribute after having called it already wouldn't take
    effect until the next "session". But changing the OID as well
    corrupts existing SPI plans in other functions plus rules.

    Now it might be possible to tell  your  function  handler  to
    recompile that function at the next call without changing the
    OID, but how do you tell the function  handlers  in  all  the
    other  concurrently running backends to do so after finishing
    their current transaction?

    The reason for this feature not beeing implemented yet is not
    "that just noone is in the mood for".  It is that the general
    multiuser support structures aren't in  place  and  a  little
    local sandbox-hack just wouldn't cut it.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com