Re: [SQL] Please help to wite the constraint.

2005-11-21 Thread Samer Abukhait
I can't understand why you are doing this big cycle.. but certainly when constraints can't help you.. you can use triggers to enforce integrity.. On 11/20/05, Grigory O. Ptashko <[EMAIL PROTECTED]> wrote: > Hello, everybody! > > I don't whether it is possible to do the following but anyway I can't

Re: [SQL] migratation of database from oracle9i to postgreSQL8.0.3

2005-11-10 Thread Samer Abukhait
There are some tools.. search about Ora2PG or so One other way to go is to have the Oracle DB dumped out as text and change/review the statements to suit your new structure and PG differences You definitely need mass changing tools with regular expressions. On 11/9/05, zenith Das <[EMAIL PROTECT