Re: [SQL] cast lo to oid

2002-11-08 Thread Nekta Katz
L PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [SQL] cast lo to oid Date: Thu, 07 Nov 2002 10:16:21 -0500 "Nekta Katz" <[EMAIL PROTECTED]> writes: > I have the following table > create table scan_docs ( > docid serial, > shipno numeric(10), > sc

Re: [SQL] cast lo to oid

2002-11-07 Thread Nekta Katz
L PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [SQL] cast lo to oid Date: Thu, 07 Nov 2002 10:16:21 -0500 "Nekta Katz" <[EMAIL PROTECTED]> writes: > I have the following table > create table scan_docs ( > docid serial, > shipno numeric(10), > scanlo,

Re: [SQL] cast lo to oid

2002-11-07 Thread Tom Lane
"Nekta Katz" <[EMAIL PROTECTED]> writes: > I have the following table > create table scan_docs ( > docid serial, > shipno numeric(10), > scanlo, > type text > ); > when I try to create the following rule > create rule "delete_scan_docs_lo" as > on delete to "scan_docs" > do

[SQL] cast lo to oid

2002-11-07 Thread Nekta Katz
Hi, I have the following table create table scan_docs ( docid serial, shipno numeric(10), scanlo, type text ); when I try to create the following rule create rule "delete_scan_docs_lo" as on delete to "scan_docs" do select lo_unlink (old.scan); I get the error message "psql: