[ic] Postgresql problem (pg newbe)

Jon Jensen jon at endpoint.com
Wed Aug 27 12:01:41 UTC 2008


On Tue, 26 Aug 2008, Rick Bragg wrote:

> I will follow this from your earlier post
> http://people.planetpostgresql.org/peter/uploads/pg83-implicit-casts.sqlx
>
> Should I run all these functions and cast statements?

Yes. Back up your database first. Or be prepared to blow it away and 
recreate if something goes wrong and you don't have anything important in 
it yet.

> What is pg_catalog.text in there??? Should that my database name?

No, that's the schema name and function name. You don't need to customize 
anything in that SQL file -- just run it as the "postgres" superuser while 
connected to your database. (Not "template1" or "postgres"!)

Jon

-- 
Jon Jensen
End Point Corporation
http://www.endpoint.com/



More information about the interchange-users mailing list