From: | "Sean Cardus" <postgres(at)cardus(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problems upgrading to 7.4.8 from 7.2.4 |
Date: | 2005-06-22 13:56:28 |
Message-ID: | 20050622135519.9A7F752971@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 Postgres
7.4.8. I've followed all the advice I can find with regard to dumping the
existing data and re-importing it to the new server. All goes well except
for a few of the SQL statements during the import fail.
For example, one of the CREATE VIEW statements contains:
WHERE (u.username = "varchar"(u.customer_id))
Another starts with:
CREATE VIEW "sub_domains_view" as
SELECT (a.domain_name || evalstring(
(SELECT (' => '::"varchar" || da.domain_name) FROM account da WHERE....
These result in the following type of error:
ERROR: function varchar(integer) does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
I've tried creating a cast using...
CREATE CAST (int4 AS varchar) WITH FUNCTION varchar(int4);
...but this fails - According to my Googling it appears the varchar()
function has been removed from Postgres sometime around version 7.3.
I've asked this question elsewhere and have been given a suggestion to
modify these statements to use a cast, eg: WHERE (u.username =
cast(u.customer_id as string))
Unfortunately I don't have access to the application source, so I'm not sure
if this type of change will have any impact on the application itself.
I was hoping I might be able to re-create the varchar() cast function(s) but
googling has only come up with examples of failed attempts.
Does anyone have any advice/ideas?
TIA,
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-06-22 14:19:36 | Re: Problems upgrading to 7.4.8 from 7.2.4 |
Previous Message | Sven Willenberger | 2005-06-22 13:23:43 | Re: Postfix/Maildrop and too many connections issues |