RI Constraint display

Referential integrity constraints are displayed as $n.
Is this a bug or a feature?  I first ran into the issue
with the RI error message and I thought it was just a message
bug.  But I can also see the $n as a name with \d via psql.
Looking at pg_trigger, though, makes me think that there
might be some confusion between tgname and tgconstrname
(what is tgconstrname??) and tgargs.

Or is this how it is supposed to be?  I really expected the
trigger name to be displayed where it is displaying $1 and $2
in the error message and in psql.

postgresql 7.3.1
SuSe 7.3

--elein



create table rr_reports (
        r_name          text not null,
        rt_type         text not null,
        ag_name         text,
        r_title         text,
        r_sdesc         text,
        r_ldesc         text,
        PRIMARY KEY (r_name)
        , FOREIGN KEY (rt_type) references rr_types
        , FOREIGN KEY (ag_name) references rr_appgroups
);

From log after bad INSERTS:

ERROR:  $2 referential integrity violation - key referenced from rr_reports
not found in rr_appgroups
ERROR:  $1 referential integrity violation - key referenced from rr_rprompts
not found in rr_reports

But I also see it using \d:
\d rr_reports
 Table "public.rr_reports"
 Column  | Type | Modifiers
---------+------+-----------
 r_name  | text | not null
 rt_type | text | not null
 ag_name | text |
 r_title | text |
 r_sdesc | text |
 r_ldesc | text |
Indexes: rr_reports_pkey primary key btree (r_name)
Foreign Key constraints: $1 FOREIGN KEY (rt_type) REFERENCES
rr_types(rt_type) ON UPDATE NO
ACTION ON DELETE NO ACTION,
                         $2 FOREIGN KEY (ag_name) REFERENCES
rr_appgroups(ag_name) ON UPDATE NO ACTION ON DELETE NO ACTION

select * from pg_trigger;
 tgrelid |           tgname            | tgfoid | tgtype | tgenabled |
tgisconstraint | tgconstrname | tgconstrrelid | tgdeferrable | tginitdeferred
| tgnargs | tgattr |
                   tgargs

---------+-----------------------------+--------+--------+-----------+----------------+--------------+---------------+--------------+----------------+---------+--------+---------------------------------------------------------------------------
  437264 | RI_ConstraintTrigger_437272 |   1644 |     21 | t         | t
        | $1
         |        437254 | f            | f              |       6 |        |
$1\000rr_reports\000rr_types\000UNSPECIFIED\000rt_type\000rt_type\000
  437254 | RI_ConstraintTrigger_437273 |   1654 |      9 | t         | t
        | $1
         |        437264 | f            | f              |       6 |        |
$1\000rr_reports\000rr_types\000UNSPECIFIED\000rt_type\000rt_type\000
  437254 | RI_ConstraintTrigger_437274 |   1655 |     17 | t         | t
        | $1
         |        437264 | f            | f              |       6 |        |
$1\000rr_reports\000rr_types\000UNSPECIFIED\000rt_type\000rt_type\000
  437264 | RI_ConstraintTrigger_437276 |   1644 |     21 | t         | t
        | $2
         |        437244 | f            | f              |       6 |        |
$2\000rr_reports\000rr_appgroups\000UNSPECIFIED\000ag_name\000ag_name\000
  437244 | RI_ConstraintTrigger_437277 |   1654 |      9 | t         | t
        | $2
         |        437264 | f            | f              |       6 |        |
$2\000rr_reports\000rr_appgroups\000UNSPECIFIED\000ag_name\000ag_name\000
  437244 | RI_ConstraintTrigger_437278 |   1655 |     17 | t         | t
        | $2
         |        437264 | f            | f              |       6 |        |
$2\000rr_reports\000rr_appgroups\000UNSPECIFIED\000ag_name\000ag_name\000

--
----------------------------------------------------------------------------------------
elein@varlena.com     Database Consulting     www.varlena.com
              I have always depended on the [QA] of strangers.