User Profile

Collapse

Profile Sidebar

Collapse
indikamaligaspe
indikamaligaspe
Last Activity: Jul 18 '10, 06:18 PM
Joined: Jul 6 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • indikamaligaspe
    replied to PL/TCL trigger error "can't read "tgname": no such variable"
    in PostgreSQL
    PL/TCL trigger error "can't read "tgname&qu ot;: no such variable" Reply to Thread

    Guys,
    I found the solution to this, sorry was now able to post s reply till now.
    The issue is in the following code

    spi_exec "SELECT c.relname AS tgname,n.nspnam e AS schema_name
    FROM pg_class c , pg_namespace n
    WHERE n.oid = c.relnamespace
    AND relfilenode = $TG_relid"...
    See more | Go to post

      Leave a comment:

    • indikamaligaspe
      started a topic PL/TCL trigger error "can't read "tgname": no such variable"
      in PostgreSQL

      PL/TCL trigger error "can't read "tgname": no such variable"

      Hi all,
      I am trying to get a PL/TCL trigger to update an audit table working. The problem is when I create the trigger on an exiting table, I get the following error

      "ERROR: can't read "tgname": no such variable
      CONTEXT: can't read "tgname": no such variable
      while executing ....."

      If I drop the table and then recreate the table and add the rigger, the trigger...
      See more | Go to post
      No activity results to display
      Show More
      Working...