pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
System catalogs
3+ messages / 3 participants
[nested] [flat]

* System catalogs
@ 2001-11-18 18:43  Aasmund Midttun Godal <postgresql@envisity.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Aasmund Midttun Godal @ 2001-11-18 18:43 UTC (permalink / raw)
  To: pgsql-sql

I saw in the docs that you are not supposed to edit them manually... However is it considered appropriate to do other things such as:

referencing them (adding foreign keys on them)
adding triggers to them (e.g. delete all this stuff if this table is dropped). This would include adding cascade clauses to the referring.

Regards,

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: System catalogs
@ 2001-11-18 19:15  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  parent: Aasmund Midttun Godal <postgresql@envisity.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Stephan Szabo @ 2001-11-18 19:15 UTC (permalink / raw)
  To: Aasmund Midttun Godal <postgresql@envisity.com>; +Cc: pgsql-sql

On Sun, 18 Nov 2001, Aasmund Midttun Godal wrote:

> I saw in the docs that you are not supposed to edit them manually...
> However is it considered appropriate to do other things such as:
>
> referencing them (adding foreign keys on them)
> adding triggers to them (e.g. delete all this stuff if this table is
> dropped). This would include adding cascade clauses to the referring.

Generally I don't think so.  What were you trying to like with foreign
keys?





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: System catalogs
@ 2001-11-18 19:26  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Aasmund Midttun Godal <postgresql@envisity.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2001-11-18 19:26 UTC (permalink / raw)
  To: Aasmund Midttun Godal <postgresql@envisity.com>; +Cc: pgsql-sql

"Aasmund Midttun Godal" <postgresql@envisity.com> writes:
> I saw in the docs that you are not supposed to edit them manually... However is it considered appropriate to do other things such as:
> referencing them (adding foreign keys on them)
> adding triggers to them (e.g. delete all this stuff if this table is dropped). This would include adding cascade clauses to the referring.

By and large, triggers on system catalogs will not work, because most
of the internal manipulations of the catalogs do not bother to fire
triggers.  This implies that foreign key constraints won't work either,
since those are implemented by triggers.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-11-18 19:26 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-18 18:43 System catalogs Aasmund Midttun Godal <postgresql@envisity.com>
2001-11-18 19:15 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-18 19:26 ` Tom Lane <tgl@sss.pgh.pa.us>

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