Re: [SQL] cast lo to oid

2002-11-08 Thread Nekta Katz
I didn't realize there was a contrib/lo, I only created the lo type as described in the psqlodbc faq. I have now installed the contrib/lo and everything is working fine. I am using PG version 7.2 thanks. From: Tom Lane <[EMAIL PROTECTED]> To: "Nekta Katz" <[EMAI

Re: [SQL] cast lo to oid

2002-11-07 Thread Nekta Katz
I didn't realize there was a contrib/lo, I only created the lo type as described in the psqlodbc faq. I have now installed the contrib/lo and everything is working fine. I am using PG version 7.2 thanks. From: Tom Lane <[EMAIL PROTECTED]> To: "Nekta Katz" <[EMAI

[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: