Re: another trigger problem - Mailing list pgsql-general

From Luca Ferrari
Subject Re: another trigger problem
Date
Msg-id CAKoxK+4iHmCROAi3LODbU6ka-Supq1KzQak9hJQS-6QVc_6dFg@mail.gmail.com
Whole thread Raw
In response to Re: another trigger problem  (Susan Cassidy <susan.cassidy@decisionsciencescorp.com>)
List pgsql-general
On Sat, Mar 8, 2014 at 12:36 AM, Susan Cassidy
<susan.cassidy@decisionsciencescorp.com> wrote:
> You would think that postgres could have output a more helpful error
> message, though.


I believe that is the correct message: you were concatenating a null
string to something, and so nullifying the string you were using for
execute. In other words, it is not a wrong error message, or it could
not have been better since the instruction before the execute was
doing what you asked for. I believe in such cases it is better to
check against the query string and execute it only if valid.

Luca


pgsql-general by date:

Previous
From: Jarosław Błąd
Date:
Subject: DB GUI design tool?
Next
From: Jeff Janes
Date:
Subject: Re: log_statement per table