Re: [GENERAL] Problems upgrading to 7.4.8 from 7.2.4

2005-06-22 Thread Sean Cardus
Tom Lane <> wrote the following on 22 June 2005 15:20: > "Sean Cardus" <[EMAIL PROTECTED]> writes: >> For example, one of the CREATE VIEW statements contains: >>WHERE (u.username = "varchar"(u.customer_id)) > > If you can change "varchar" to "text" it should still work. Thanks for the advice

Re: [GENERAL] Problems upgrading to 7.4.8 from 7.2.4

2005-06-22 Thread Tom Lane
"Sean Cardus" <[EMAIL PROTECTED]> writes: > For example, one of the CREATE VIEW statements contains: >WHERE (u.username = "varchar"(u.customer_id)) If you can change "varchar" to "text" it should still work. regards, tom lane ---(end of broadca

[GENERAL] Problems upgrading to 7.4.8 from 7.2.4

2005-06-22 Thread Sean Cardus
Hi Everyone, I've inherited an ancient Redhat 7.3 machine hosting the data for one of our applications in a Postgres 7.2.4 database. I must confess, I come from a MySQL/MS-SQL background so I'm a bit of a Postgres newbie :) I've setup a brand-new server running RHEL4 which is supplied with Postg