projects
/
dbsrgits/SQL-Translator.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
Added patch from wreis, view support for pg producer
[dbsrgits/SQL-Translator.git]
/
t
/
46xml-to-pg.t
diff --git
a/t/46xml-to-pg.t
b/t/46xml-to-pg.t
index
ced163f
..
e3b3540
100644
(file)
--- a/
t/46xml-to-pg.t
+++ b/
t/46xml-to-pg.t
@@
-57,6
+57,12
@@
CREATE TABLE "Another" (
PRIMARY KEY ("id")
);
+
+
+CREATE OR REPLACE VIEW "email_list" ( "email" ) AS (
+ SELECT email FROM Basic WHERE email IS NOT NULL
+ );
+
ALTER TABLE "Basic" ADD FOREIGN KEY ("another_id")
REFERENCES "Another" ("id") DEFERRABLE;
SQL