Thread: mysql to pgsql migration

Hello,

I have a database application with Java and PHP clients. I used mysql
with 64 tables. Now, we have decided to use pgsql. Please suggest the
migration procedure.

Thanks.


Suresh

We are upgrading from pg 7.1 to 7.3.3.
The following which works on 7.1 gives error on 7.3.3.

select time (timestamp '2003-08-30 20:30');

What changed on 7.3.3 ?

Thanks

Udhe


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Uday Walia <waliau@yahoo.com> writes:
> We are upgrading from pg 7.1 to 7.3.3.
> The following which works on 7.1 gives error on 7.3.3.
> select time (timestamp '2003-08-30 20:30');

time(x) is a datatype name, and has been for a couple releases now.
Suggest using cast notation instead.

            regards, tom lane