Re: [HACKERS] 7.3 gotchas for applications and client libraries

2002-12-02 Thread Lee Kindness
Tom/Hackers, Going back a bit, but relevant with 7.3's release... Tom Lane writes on 03 Sep 2002: Lee Kindness [EMAIL PROTECTED] writes: [ original post was regarding the mileage in adding utility functions to PostgreSQL to cut-out common catalog lookups, thus making apps less

Re: [HACKERS] 7.3 gotchas for applications and client libraries

2002-09-17 Thread Bruce Momjian
I have copied Tom's fine email to: http://www.ca.postgresql.org/docs/momjian/upgrade_7.3 and have added a mention of it in the HISTORY file: A dump/restore using pg_dump is required for those wishing to migrate data from any previous release. A summary of changes needed in

Re: [HACKERS] 7.3 gotchas for applications and client libraries

2002-09-05 Thread Christopher Kings-Lynne
Was this going to make it into the release notes or something? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Tuesday, 3 September 2002 9:54 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [HACKERS] 7.3 gotchas

[HACKERS] 7.3 gotchas for applications and client libraries

2002-09-03 Thread Lee Kindness
Tom, do you think there is millage in adding functions (at least to contrib) to PostgreSQL to avoid some of the common tasks applications look into pg_* for? For example I recently audited our code here for pg_* access, and managed to create two plpgsql functions to replace all occurrences. They

Re: [HACKERS] 7.3 gotchas for applications and client libraries

2002-09-03 Thread Tom Lane
Lee Kindness [EMAIL PROTECTED] writes: CREATE OR REPLACE FUNCTION column_exists(NAME, NAME) RETURNS BOOLEAN AS ' CREATE OR REPLACE FUNCTION table_exists(NAME) RETURNS BOOLEAN AS ' Obviously these need attention when our application targets 7.3 (and thanks for the heads-up), but all

[HACKERS] 7.3 gotchas for applications and client libraries

2002-09-02 Thread Tom Lane
Bruce suggested that we need a porting guide to help people look for application and client-library code that will be broken by the changes in PG 7.3. Here is a first cut at documenting the issues. Comments welcome --- in particular, what have I missed? regards, tom lane