Update of /cvsroot/monetdb/sql/src/test/pg_regress
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv30061
Modified Files:
postgresql2sql99.sh
Log Message:
don't trow away INHERITS one-liners, they are tables too
U postgresql2sql99.sh
Index: postgresql2sql99.sh
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/pg_regress/postgresql2sql99.sh,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -d -r1.12 -r1.13
--- postgresql2sql99.sh 1 Aug 2009 14:58:09 -0000 1.12
+++ postgresql2sql99.sh 1 Aug 2009 17:14:28 -0000 1.13
@@ -36,7 +36,7 @@
-e 's/BEGIN;/START TRANSACTION;/ig' \
-e 's/END;/COMMIT;/ig' \
-e 's/COMMENT.*;//ig' \
- -e 's/CREATE TABLE.*INHERITS.*;//ig' \
+ -e '/CREATE TABLE.*INHERITS.*;/s/INHERITS (.*)//' \
-e 's/\) INHERITS.*;/\);/ig' \
-e 's/\s+([^\s]+)::float[248]\b/ cast(\1 as double)/ig' \
-e 's/\s+([^\s]+)::int2\b/ cast(\1 as smallint)/ig' \
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
