contrib catalogs

From: Kevin Neufeld <kneufeld(at)refractions(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: contrib catalogs
Date: 2008-07-23 22:47:37
Message-ID: 4887B509.9030704@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This might seem like a silly question, but what are the implications of
PostgreSQL allowing developers to create custom catalogs?

For example, PostgreSQL currently uses the pg_catalog schema to store
system catalogs / relations / functions / etc. Has thought gone into
extending the scope to allow contrib modules to create their own
catalogs (ie. a PostGIS catalog, cube, tsearch2, etc.)?

The largest advantage I see is significantly easier upgrades. Having
contrib tables/functions flagged as a catalog, pg_dump won't include
them in a dump - restoring into an upgraded database becomes painless.

Cheers,
Kevin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sushma Sagaram 2008-07-23 23:32:19 Problem running script
Previous Message Alex Vinogradovs 2008-07-23 22:37:29 cast affects use of indexes ?