Re: [GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Rick Schumeyer
Steve Crawford wrote: BTW, why not upgrade to the latest version? Cheers, Steve Mostly because its not my server :-) I've suggested that, we'll see. I appreciate the comments regarding type casting. I'll be sure to look out for that. ---(end of broadcast)

Re: [GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Steve Crawford
Rick Schumeyer wrote: Tom Lane wrote: Rick Schumeyer <[EMAIL PROTECTED]> writes: I'm working with someone who is about to upgrade from (I believe) pg 7.4 to pg 8.1. What would be the best resource to read to look for "gotchas"? Release notes? At the moment, we don't care about per

Re: [GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Tom Lane
Vivek Khera <[EMAIL PROTECTED]> writes: > On Jan 23, 2008, at 10:26 AM, Tom Lane wrote: >> Reading the release notes is good, but you really really should test >> the >> application(s) against a test 8.1 installation before you go live ... > be sure to run *every* query your system uses through

Re: [GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Vivek Khera
On Jan 23, 2008, at 10:26 AM, Tom Lane wrote: Reading the release notes is good, but you really really should test the application(s) against a test 8.1 installation before you go live ... be sure to run *every* query your system uses through 8.1. the most common problems you will run in

Re: [GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Rick Schumeyer
Tom Lane wrote: Rick Schumeyer <[EMAIL PROTECTED]> writes: I'm working with someone who is about to upgrade from (I believe) pg 7.4 to pg 8.1. What would be the best resource to read to look for "gotchas"? Release notes? At the moment, we don't care about performance problems, on

Re: [GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Tom Lane
Rick Schumeyer <[EMAIL PROTECTED]> writes: > I'm working with someone who is about to upgrade from (I believe) pg 7.4 > to pg 8.1. > What would be the best resource to read to look for "gotchas"? Release > notes? At the moment, we don't care about performance problems, only > things that migh

[GENERAL] Tips for upgrading from 7.4

2008-01-23 Thread Rick Schumeyer
I'm working with someone who is about to upgrade from (I believe) pg 7.4 to pg 8.1. What would be the best resource to read to look for "gotchas"? Release notes? At the moment, we don't care about performance problems, only things that might break. ---(end of broa