From f58579139c1bf358eca1982628c63a5d609dfada Mon Sep 17 00:00:00 2001
From: Michael Wallner <mike@php.net>
Date: Wed, 11 Dec 2013 22:28:01 +0100
Subject: [PATCH] sanitize id computation

---
 lib/pq/Gateway/Table/Relations.php | 14 +++++++++-----
 1 file changed, 9 insertions(+), 5 deletions(-)

diff --git a/lib/pq/Gateway/Table/Relations.php b/lib/pq/Gateway/Table/Relations.php
index 7ad5326..3e4d7fb 100644
--- a/lib/pq/Gateway/Table/Relations.php
+++ b/lib/pq/Gateway/Table/Relations.php
@@ -6,11 +6,15 @@ use \pq\Gateway\Table;
 
 const RELATION_SQL = <<<SQL
 select
-	 substring(att1.attname from '^.*(?=_'||att2.attname||'$)') as "id"
-	,cl1.relname                                                as "foreignTable"
-    ,att1.attname                                               as "foreignColumn"
-	,cl2.relname                                                as "referencedTable"
-    ,att2.attname                                               as "referencedColumn"
+	 case att1.attname
+	 when att2.attname
+		then att1.attname
+		else substring(att1.attname from '^.*(?=_'||att2.attname||'$)')
+	 end          as "id"
+	,cl1.relname  as "foreignTable"
+	,att1.attname as "foreignColumn"
+	,cl2.relname  as "referencedTable"
+	,att2.attname as "referencedColumn"
 from
      pg_constraint co
     ,pg_class      cl1
-- 
2.30.2