Mija Lee <mija(at)scharp(dot)org> writes:
> - I can create another table with a field that matches the datname in
> pg_database and try to write a trigger that inserts into my table when
> a record is inserted into pg_database, but I have the feeling that may
> also be a dead end.
Yup, because we don't support firing triggers on system catalogs.
There are conceptual, security, and implementation reasons why not;
troll the pghackers archives for discussions.
> On a related note, I'm also trying to find the system table that links
> database oids with table or schema oids, but I can't seem to find
> it. I know it's there somewhere, but don't see it in the doc.
You don't see it because it's not there. pg_class and so forth live
within a database, that is, there's a physically separate version in
each database; so the database ID is implicit. There are actually only
a few system catalogs that don't work that way --- they are the ones we
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Michael Glaesemann||Date: 2007-08-29 19:58:05|
|Subject: Re: using system catalogs|
|Previous:||From: Mija Lee||Date: 2007-08-29 18:26:16|
|Subject: using system catalogs|