Re: [HACKERS] Re: unanswered: Schema Issue

On Thu, 26 Apr 2001, V. M. wrote:

(moving this conversation back to pgsql-general, followups to there)

> perhaps adding  t.tgargs to your view enable me to extract parameters
> that are the related fields

At SCW, we use a naming convention for RI triggers, to allow
us to easily extract that, and deal with error messages.

We use:

CREATE TABLE p (id INT);

CREATE TABLE c (id INT CONSTRAINT c__ref_id REFERENCES p);

This allows us at a glance to see in error messages what field of what
table we were referencing. In an Access front end, we can trap this
error message to a nice statement like "You're trying to change a value in
the table "c", using information in table "p", "id", but...")

If you don't have this, yes, you can look at in
the tgargs, but, given that its a bytea field, it's hard to
programmatically dig anything out of it.

HTH,
--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington