From: Alex Hochberger <alex@dsgi.us>
To: pgsql-sql@postgresql.org
Subject: pl/pgsql and error handling
Date: Thu, 28 Feb 2008 14:10:47 -0500
Message-ID: <650E1D02-A244-44F4-81A4-5977F8D879E8@dsgi.us> (raw)
Is it possible to grab access to the actually user-friendly error
message? I have a bunch of files that come into my database, each
slightly different. The submitter fills out a form that records the
info, and sticks it into a table.
If the file is malformed (wrong number of columns in a row) from a
missing comma or something, I want to record the result to store in
the database. I assume that I should exception handle the COPY FROM
line, and store the results, but I can't for the life of me figure out
how to get the text like "invalid line on line 470352" or whatever
psql shows. Is that possible to obtain in plpgsql?
I've done extensive plpgsql programming before, but this is the first
time I need it to validate the external data in question.
Alex
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alex@dsgi.us
Subject: Re: pl/pgsql and error handling
In-Reply-To: <650E1D02-A244-44F4-81A4-5977F8D879E8@dsgi.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox