From: Neil T. <nt...@us...> - 2006-08-30 21:26:57
|
Update of /cvsroot/pgsqlformac/pgCocoaDB/UnitTest In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15828/UnitTest Modified Files: pgCocoaDBSchemaTest.m Log Message: Fix constraints, columns, triggers. Index: pgCocoaDBSchemaTest.m =================================================================== RCS file: /cvsroot/pgsqlformac/pgCocoaDB/UnitTest/pgCocoaDBSchemaTest.m,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** pgCocoaDBSchemaTest.m 30 Aug 2006 15:48:49 -0000 1.16 --- pgCocoaDBSchemaTest.m 30 Aug 2006 21:26:54 -0000 1.17 *************** *** 134,137 **** --- 134,141 ---- STAssertTrue([conn errorDescription] == nil, @"Error executing SQL: %@. %@", sql, [conn errorDescription]); + sql = [NSString stringWithFormat:@"ALTER TABLE %@.name ADD CONSTRAINT name_age_check CHECK ((0 < age) AND (age < 150));", PGCocoaTestSchema]; + [conn execQuery:sql]; + STAssertTrue([conn errorDescription] == nil, @"Error executing SQL: %@. %@", sql, [conn errorDescription]); + sql = [NSString stringWithFormat:@"%s%@.%@.%s", "CREATE or REPLACE FUNCTION ", PGCocoaTestDatabase, PGCocoaTestSchema, "create_time_stamp() RETURNS trigger AS $time_stamp$\n\ |