Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    23

    Unanswered: Trigger Problem 2

    Hi

    Finally getting this trigger ro work have one last problem, im trying to use Trigger variables

    sample code

    UPDATE wip.resource
    set "name" = datarecord.borname
    where wip.resource."primary" = OLD."primary";


    get the following error

    Error: record "old" is not yet assigned

    would be greatful for any help thx

  2. #2
    Join Date
    Dec 2004
    Location
    Kharkov, Ukraine
    Posts
    40
    See PostgreSQL 7.4 Documentation, Chapter 35.1. Overview of Trigger Behavior
    Your trigger is "before\after insert", probably. And OLD row have not values, yet.

Posting Permissions

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