Hello Group,
I have the following problem. We have a very old server on BSDI. We buy
a new one and install FreeBSD6.2 on it.
The PG version on the old server is:
version
-------------------------------------------------------------
PostgreSQL 7.4.6 on i386-pc-bsdi4.2, compiled by GCC 2.95.2
(1 row)
We migrate to:
version
-------------------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on amd64-portbld-freebsd6.2, compiled by GCC cc (GCC)
3.4.6 [FreeBSD] 20060305
(1 row)
After we migrate one function that previously doesn't make any problem
now starts to throw error.
I think the problem is in the DBI/DBD::Pg because I write a simple
program and run it upon the new and the old database and the result was
the same - ERROR.
The problem is that there is TRIGGER that executes something on insert
into one table. The function is on "plpgsql" and it uses "RAISE NOTICE"
to trace/log some message.
The query that inserts the row is into eval block and the reulst was
error from the eval block.
What could be the problem. Why NOTICE is accepted as error? I try to
"set client_min_messages TO log" during runtime but this didn't help.
I know this is more Perl problem but if someone could help because I
didn't find anyting in the net.
Thanks in advance.
Kaloyan Iliev
kaloyan@xxxx$ perl
use CLIB::LDBI;
my $dbh = CLIB::LDBI->connect_transact({ host => "xxxxxx.xxxxxxx.xx",
name => "xxxxxxxxxxx",
user => "xxxxxxxxxx"});
my $sth = $dbh->sql("INSERT INTO
ius_doc_ppp(sender_repr_id,receiver_mol_id,ppp_no,confirmed,sender_mol_id,create_action_id,receiver_repr_id,ppp_notice,ppp_date,completed)VALUES
('30053','31102','1233','0','30053','14','31102',NULL,'2007-07-23','0')");
-------------------
-- - [Wed Jul 25 19:26:56 2007 816], 'kaloyan'
Connect Caller ,CLIB::LDBI,572
122.5
NOTICE: INSERT ON ius_doc_ppp->ius_doc_ppp_full_view ppp_id=6857
CONTEXT: PL/pgSQL function "mview_sync_ius_doc_ppp" line 11 at perform
SQL CATCH ERROR: System ERROR! <pre><font color=red>[ NOTICE: INSERT ON
ius_doc_ppp->ius_doc_ppp_full_view ppp_id=6857
CONTEXT: PL/pgSQL function "mview_sync_ius_doc_ppp" line 11 at perform
]</font></pre>
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
