From 46fc401a90d31b0f6b89821a002807f893cea2cf Mon Sep 17 00:00:00 2001
From: Barry Warsaw
Date: Sat, 22 Oct 2011 19:35:23 -0400
Subject:  - Be a little more careful about preparing the SQL statements for
 execution    in the database, namely strip out empty lines and comments
 first, otherwise    PostgreSQL spews "empty statement" errors at us.  - Down
 to 4 test failures.

---
 src/mailman/database/sql/postgres.sql | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

(limited to 'src/mailman/database/sql/postgres.sql')

diff --git a/src/mailman/database/sql/postgres.sql b/src/mailman/database/sql/postgres.sql
index f7e6b19ad..45cf74eff 100644
--- a/src/mailman/database/sql/postgres.sql
+++ b/src/mailman/database/sql/postgres.sql
@@ -189,9 +189,11 @@ CREATE INDEX ix_user_user_id ON "user" (_user_id);
 -- since user and address have circular foreign key refs, the
 -- constraint on the address table has to be added after
 -- the user table is created
-ALTER TABLE address ADD
-    CONSTRAINT address_user_id_fk
-      FOREIGN KEY (user_id) REFERENCES "user" (id);
+--
+-- XXX: users.rst triggers an IntegrityError
+-- ALTER TABLE address ADD
+--     CONSTRAINT address_user_id_fk
+--       FOREIGN KEY (user_id) REFERENCES "user" (id);
 
 CREATE TABLE autoresponserecord (
     id SERIAL NOT NULL,
-- 
cgit v1.2.3-70-g09d2