| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Another quick question... |
| Date: | 2002-08-01 04:52:58 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOIEHHCDAA.chriskl@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> > If you have RelationGetRelationName(rel) to get the name of a
> relation, how
> > do you get it's fully qualified schema name? Or how do I get the schema
> > name for the relation?
>
> Well, you can do get_namespace_name(rel->rd_rel->relnamespace), but
> I don't really agree with changing error messages to *always* quote
> the schema name. I think that'd be overly verbose. An appropriate
> solution is to mention the schema name only when it's necessary to
> identify the relation (ie, the rel would not be found in your current
> search path).
The problem I see is that imagine you're browsing your logs. If you see an
error message (or a notice) that refers just to a table, you have no idea
which schema the table is in...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-08-01 04:56:55 | Re: Rules and Views |
| Previous Message | Tom Lane | 2002-08-01 04:44:16 | Re: Rules and Views |