Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Stored Procedures

    Hello everybody,

    I am a postgresql newbie and I have serious problems with stored procedures. Is it possible to use a stored procedure which writes a row in a log table while updating another table and store the old values of the fields changed?

    Best wishes, Trendman

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

    stored procedure

    Maybe it will be better you look for a trigger solution for this problem
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Jun 2004
    Posts
    31
    This sounds like a terrific candidate for a rule -- a.k.a a query rewrite.

Posting Permissions

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