From 34bbe94a6a57724877dbab080f4296f75c6289bc Mon Sep 17 00:00:00 2001
From: Marko Kreen
Date: Sun, 12 Aug 2007 11:36:09 +0000
Subject: Support for automatic handling of fkeys.

By Eric Jones, plus some hacking by me.
---
 python/skytools/dbstruct.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'python/skytools/dbstruct.py')

diff --git a/python/skytools/dbstruct.py b/python/skytools/dbstruct.py
index ece0ea54..39e3b838 100644
--- a/python/skytools/dbstruct.py
+++ b/python/skytools/dbstruct.py
@@ -74,7 +74,7 @@ class TConstraint(TElem):
     type = T_CONSTRAINT
     SQL = """
         SELECT conname as name, pg_get_constraintdef(oid) as def, contype
-          FROM pg_constraint WHERE conrelid = %(oid)s
+          FROM pg_constraint WHERE conrelid = %(oid)s AND contype != 'f'
     """
     def __init__(self, table_name, row):
         self.table_name = table_name
-- 
cgit v1.2.3