Re: eXtreme PostgreSQL using system catalogs (was Turning off triggers ?) - Mailing list pgsql-general

From Tom Lane
Subject Re: eXtreme PostgreSQL using system catalogs (was Turning off triggers ?)
Date
Msg-id 14176.1038372435@sss.pgh.pa.us
Whole thread Raw
In response to eXtreme PostgreSQL using system catalogs (was Turning off triggers ?)  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-general
Chris Gamache <cgg007@yahoo.com> writes:
> There seems to be a TON of functionality accessable by querying and updating
> the system catalogs directly...

Querying, sure ... updating, well, it's pretty easy to shoot yourself in
the foot.  I have been seen to recommend solutions that involve manual
catalog updates, but I always ask what version you're running first ;-)
The catalogs get revised for every version, to a greater or lesser
extent.

> Is this a skill reserved only for the eXtreme postgresql hackers, or can
> (should!) mere mortals be given the understanding to push postgresql to its
> limits?

If you're willing to commit to keeping the document updated across multiple
PG versions, go for it.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.3RC2 install woes
Next
From: Tom Lane
Date:
Subject: Re: order by in for loop in plpgsql does not work