Received: from ns.infoset.cz (ns.infoset.cz [194.213.32.210]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA58495; Wed, 13 Oct 1999 12:51:32 -0400 (EDT) (envelope-from dpeder@infoset.cz) Received: from WinProxy.anywhere ([62.168.15.178]) by ns.infoset.cz (8.8.7/8.8.7) with SMTP id SAA31426; Wed, 13 Oct 1999 18:51:37 +0200 Received: from 192.168.1.1 by 192.168.1.3 (WinProxy); Wed, 13 Oct 1999 18:53:47 +0100 Received: by Dan with Microsoft Mail id <01BF15AB.D9AF52C0@Dan>; Wed, 13 Oct 1999 18:50:42 +0100 Message-ID: <01BF15AB.D9AF52C0@Dan> From: =?iso-8859-2?Q?Daniel_P=E9der?= To: "'pgsql-hackers@postgresql.org'" , "'pgsql-sql@postgresql.org'" Subject: the oid is uknown during execution of rule..insert ? (psql ver 6.5.2) Date: Wed, 13 Oct 1999 18:50:40 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit mydb=> create table roid (roid oid, rtext text); CREATE mydb=> create table rtext ( rtext text ); CREATE mydb=> create rule roidset as on insert to rtext do insert into roid values ( new.oid, new.rtext ); CREATE mydb=> insert into rtext values('text1'); INSERT 17681 1 mydb=> insert into rtext values('text2'); INSERT 17683 1 mydb=> insert into rtext values('text3'); INSERT 17685 1 mydb=> select oid,* from rtext; oid|rtext -----+----- 17681|text1 17683|text2 17685|text3 (3 rows) mydb=> select oid,* from roid; oid|roid|rtext -----+----+----- 17680| |text1 17682| |text2 17684| |text3 (3 rows)