You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sqoop.apache.org by ja...@apache.org on 2015/01/10 21:07:56 UTC

sqoop git commit: SQOOP-1985: Sqoop2: On job delete cascade to submission

Repository: sqoop
Updated Branches:
  refs/heads/sqoop2 3325a950d -> f4beb543e


SQOOP-1985: Sqoop2: On job delete cascade to submission

(Abraham Elmahrek via Jarek Jarcec Cecho)


Project: http://git-wip-us.apache.org/repos/asf/sqoop/repo
Commit: http://git-wip-us.apache.org/repos/asf/sqoop/commit/f4beb543
Tree: http://git-wip-us.apache.org/repos/asf/sqoop/tree/f4beb543
Diff: http://git-wip-us.apache.org/repos/asf/sqoop/diff/f4beb543

Branch: refs/heads/sqoop2
Commit: f4beb543ee3f4f20f47585bafc7c11fa5f3d0338
Parents: 3325a95
Author: Jarek Jarcec Cecho <ja...@apache.org>
Authored: Sat Jan 10 12:07:35 2015 -0800
Committer: Jarek Jarcec Cecho <ja...@apache.org>
Committed: Sat Jan 10 12:07:35 2015 -0800

----------------------------------------------------------------------
 .../sqoop/repository/postgresql/PostgresqlSchemaCreateQuery.java   | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/sqoop/blob/f4beb543/repository/repository-postgresql/src/main/java/org/apache/sqoop/repository/postgresql/PostgresqlSchemaCreateQuery.java
----------------------------------------------------------------------
diff --git a/repository/repository-postgresql/src/main/java/org/apache/sqoop/repository/postgresql/PostgresqlSchemaCreateQuery.java b/repository/repository-postgresql/src/main/java/org/apache/sqoop/repository/postgresql/PostgresqlSchemaCreateQuery.java
index a4ce5b8..39abb2d 100644
--- a/repository/repository-postgresql/src/main/java/org/apache/sqoop/repository/postgresql/PostgresqlSchemaCreateQuery.java
+++ b/repository/repository-postgresql/src/main/java/org/apache/sqoop/repository/postgresql/PostgresqlSchemaCreateQuery.java
@@ -337,7 +337,7 @@ public class PostgresqlSchemaCreateQuery {
   public static final String QUERY_CREATE_TABLE_SQ_SUBMISSION =
       "CREATE TABLE " + TABLE_SQ_SUBMISSION + " ("
           + COLUMN_SQS_ID + " BIGSERIAL PRIMARY KEY NOT NULL, "
-          + COLUMN_SQS_JOB + " BIGINT REFERENCES " + TABLE_SQ_JOB + "("  + COLUMN_SQB_ID + ")" + ", "
+          + COLUMN_SQS_JOB + " BIGINT REFERENCES " + TABLE_SQ_JOB + "("  + COLUMN_SQB_ID + ") ON DELETE CASCADE, "
           + COLUMN_SQS_STATUS + " VARCHAR(20), "
           + COLUMN_SQS_CREATION_DATE + " TIMESTAMP, "
           + COLUMN_SQS_CREATION_USER + " VARCHAR(32) DEFAULT NULL, "