[GENERAL] pain of postgres upgrade with extensions
This is not a flame about current or previous release of Postgres. I have just gone through the awful experience of upgrading from Postgres 8.2 to 8.3 with a database that had one of the many Postgres extensions included. The problem comes down to the way that Postgres extensions are packaged up, each extension tends to define some extension specific functions, when you do a dump of the database these functions get include. If upgrade from one version of Postgres to another, you take a dump of the database, which then needs to be upgrade if there have been any changes in the extension. The problem being that there doesn’t seem to be a way of dumping the database with out including extension specific information. There is a possible solution to this problem, move all the extension specific functions to an extension specific schema. That way the contents of the database are kept separate from extensions. For example the postgis function area would change to postgis.area assuming the the schema for postgis extension was call postgis, this would also avoid the problem if two extensions happen to have a function with the same name. D. -- Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Pinan Software -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Postgres data/form entry tool
> David Potts wrote: Any platform ! ie Web ,X, , L/Unix console, Mac or even Weandozz >> >> Can any body recommend a generic opensource data entry tool that can be >> used to make some simple forms for entering data in to postgres? > > For the web? *nix console? GTK? Mac? > > -- >Richard Huxton >Archonet Ltd > > ---(end of broadcast)--- > TIP 9: In versions below 8.0, the planner will ignore your desire to >choose an index scan if your joining column's datatypes do not >match > ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] Postgres data/form entry tool
Can any body recommend a generic opensource data entry tool that can be used to make some simple forms for entering data in to postgres? ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] Invoking java in a trigger
Is it possible to invoke a computer language other than postgres sql as the result of a trigger firing, eg something like Java. Dave. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] postgress gnuplot and Geometric
Postgress seems to include all this support for geometric types, lseg,box, etc. Is there any software for actual printing or displaying database which has lsex, point types enumerated in it. I did'nt mange to find any reference to this type of thing on the current maillist. regards David Potts. -- -- email [EMAIL PROTECTED] -- web www.pinan.co.uk --The opinions expressed in this article are personal and do not --represent the views of Pinan Software. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings