Pgsql errors, DBI and CGI::Carp

From: Toomas Vendelin <pg(at)vendelin(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Pgsql errors, DBI and CGI::Carp
Date: 2009-04-29 05:06:46
Message-ID: 9AC4C112-183A-433C-8ADE-4676CA301747@vendelin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm writing CGI scripts in Perl using Postgresql via DBI interface.
RAISE_ERROR is on.

For some reason (unlike with MySQL), when a Perl script dies from
Postgresql error, the line number of Perl script where the error
occurred is not reported, just the SQL statement line number is given.
In a longer script looking it may become a tedious task to guess the
line in script that caused the problem. Is that an expected behavior
or am I missing something?

Toomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-04-29 05:24:36 Re: triggers and execute...
Previous Message David Fetter 2009-04-29 04:46:57 Re: triggers and execute...