Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2M96jt25173 for ; Thu, 22 Mar 2001 04:06:52 -0500 (EST) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f2M95Rv17759 for ; Thu, 22 Mar 2001 20:05:27 +1100 Received: from bri2-56k-046.tpgi.com.au(203.29.144.46), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdTlqiYN; Thu Mar 22 20:05:20 2001 Message-ID: <002a01c0b2ae$be87d340$2400a8c0@hnjack> From: "datactrl" To: Subject: database log Date: Thu, 22 Mar 2001 19:00:50 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/436 X-Sequence-Number: 2104 Since "raise exception" in pl/pgSQL will write error message to database log, how can I read database log. If I do "select * from pg_log;", it will show an error message as "pg_log can not be accessed by user". JACK