Received: from mailer.nupes.cefetpr.br (nat-nupes.cpdtt.cefetpr.br [200.134.9.250]) by hub.org (8.10.1/8.10.1) with ESMTP id e5HCx5M83974 for ; Sat, 17 Jun 2000 08:59:06 -0400 (EDT) Received: from nupes.cefetpr.br (morse [172.16.4.13]) by mailer.nupes.cefetpr.br (8.8.7/8.8.8) with ESMTP id JAA13641 for ; Sat, 17 Jun 2000 09:56:12 -0300 (EST) Message-ID: <39722F9D.62A0D9C5@nupes.cefetpr.br> Date: Sun, 16 Jul 2000 18:56:46 -0300 From: Igor Gavriloff X-Mailer: Mozilla 4.72 [pt_BR] (X11; U; Linux 2.2.14-14cl i686) X-Accept-Language: pt-BR, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: OID on triggers Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/76 Hello everyone, I'm trying to execute a trigger (for each row) in a table that inherits another one and trying to "see" the value of the OID field of that row in the OLD record passed to the function, but the backend returns the following: ERROR: record old has no field oid Is there anyway to implement this with pgplsql in 6.5.3? I couldn't figure out if this is a bug in this version because I couldn't try 7.0.2 (compiled ok, but didn't install properly) on my Solaris machine. Thanks in advance, Igor. -- Is your job running? You'd better go catch it!