Re: [SQL] Postgresql FK to MS SQL triggers

2005-03-05 Thread Josh Berkus
Igor, > For interested people I wrote a PHP script which: > 1) Extracts all underlying triggers from pg_trigger table in Postgres used > to support FK (3 triggers for each FK) > 2) Generates a MSSQL script file which recreates all triggers in MSSQL How about a script which goes the other way? -

[SQL] Postgresql FK to MS SQL triggers

2005-03-01 Thread Igor Kryltsov
Hi, If you are moving from Postgres to MS SQL you will most likely will find that you can not recreate your PostgreSQL FK to MSSQL FK because this enterprise class database will NOT allow you to create all 3 FK which are exist in your PGSQL: table users(user_id PK) table journal(created_by, mod