On Fri, Apr 23, 2010 at 6:43 PM, Dave Page <[email protected]>wrote:
> On Fri, Apr 23, 2010 at 1:07 PM, Ashesh Vashi
> <[email protected]> wrote:
> > Hi,
> > Please find the attached patch for the DEFERRABLE / INITIALLY DEFERRED
> > keywords for the unique and primary key constraints.
>
> Hi,
>
> These constraints are implemented using triggers it seems. We need to
> filter them out of the reverse engineered SQL and not include them in
> the treeview (as we do for Foreign Key triggers).
>
> I was expecting to just apply that one too :-(
>
Please find the patch for the same.
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise Postgres Company
>
Index: schema/pgTrigger.cpp
===================================================================
--- schema/pgTrigger.cpp (revision 8294)
+++ schema/pgTrigger.cpp (working copy)
@@ -297,8 +297,8 @@
wxT(" LEFT OUTER JOIN pg_proc p ON p.oid=t.tgfoid\n")
wxT(" LEFT OUTER JOIN pg_language l ON l.oid=p.prolang\n")
wxT(" WHERE ");
- if (collection->GetDatabase()->connection()->BackendMinimumVersion(8, 5))
- trig_sql += wxT("tgconstraint <> 0\n");
+ if (collection->GetDatabase()->connection()->BackendMinimumVersion(9, 0))
+ trig_sql += wxT("NOT tgisinternal\n");
else
trig_sql += wxT("NOT tgisconstraint\n");
if (restriction.IsEmpty())
--
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
