Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2002
    Posts
    19

    Question Unanswered: dependences between function

    Suppose that the function (plpgsql) f1 use f2 and I do some modification to f2 how I can avoid to rebuild f1 also ?


    Ciao.

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    plpgsql

    if the function f2 doesnot have other arguments then it's no problem
    to deop the f2 and create the new one
    without creating the f1
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Jan 2002
    Posts
    19

    Re: plpgsql

    Originally posted by eperich
    if the function f2 doesnot have other arguments then it's no problem
    to deop the f2 and create the new one
    without creating the f1
    Of course but this is not the case!!!

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    objectid

    maybe the problem is
    that one must drop the function and
    create it new
    internally the oid change
    I think thats the problem
    the core developers are working on a CREATE or REPLACE FUNCTION
    But It's planned in the v7.3
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  5. #5
    Join Date
    Jan 2002
    Posts
    19

    Re: objectid

    Originally posted by eperich
    maybe the problem is
    that one must drop the function and
    create it new
    internally the oid change
    I think thats the problem
    the core developers are working on a CREATE or REPLACE FUNCTION
    But It's planned in the v7.3
    Ok.
    I know that a function is compiled the first time that the function is used, indeed some times if you forget a ";" you obtain a compile error not a create error. Is enough, I think, say to Postgresql: "assume from now that all function are not yet compiled", doesn't exist a way to invalidate
    "the flag: already compiled" ?

  6. #6
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    compile

    I don't think so
    but these thigns are deeper in the system
    I will look in the docs
    maybe I find something that could help
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •