Revision: 5023
          http://sourceforge.net/p/jump-pilot/code/5023
Author:   michaudm
Date:     2016-09-20 20:45:17 +0000 (Tue, 20 Sep 2016)
Log Message:
-----------
Postgis writer : create the sequence in the same schema as the table

Modified Paths:
--------------
    core/trunk/ChangeLog
    
core/trunk/src/org/openjump/core/ui/plugin/datastore/postgis/SaveToPostGISDataSource.java

Modified: core/trunk/ChangeLog
===================================================================
--- core/trunk/ChangeLog        2016-09-20 11:47:26 UTC (rev 5022)
+++ core/trunk/ChangeLog        2016-09-20 20:45:17 UTC (rev 5023)
@@ -3,6 +3,9 @@
 # 2. make sure that lines break at 80 chars for constricted display situations
 #<-------------------------------- 80 chars 
---------------------------------->#
 
+2016-09-21 mmichaud <m.michael.mich...@orange.fr>
+  * Postgis writer : create the sequence in the same schema as the table
+
 2016-09-17 mmichaud <m.michael.mich...@orange.fr>
   * FR #235 : Improved ExtractLayersByGeometryPlugIn
   * Fix bug happening when modifying schema two times with InfoPanel opened

Modified: 
core/trunk/src/org/openjump/core/ui/plugin/datastore/postgis/SaveToPostGISDataSource.java
===================================================================
--- 
core/trunk/src/org/openjump/core/ui/plugin/datastore/postgis/SaveToPostGISDataSource.java
   2016-09-20 11:47:26 UTC (rev 5022)
+++ 
core/trunk/src/org/openjump/core/ui/plugin/datastore/postgis/SaveToPostGISDataSource.java
   2016-09-20 20:45:17 UTC (rev 5023)
@@ -387,10 +387,10 @@
                                String dbTable, String primaryKey) throws 
SQLException {
         String tableFullName = SQLUtil.compose(dbSchema, dbTable);
         String sql_test_seq = "SELECT * FROM information_schema.sequences\n" +
-                "    WHERE sequence_schema = 'public' AND sequence_name = 
'openjump_dbid_sequence';";
-        String sql_create_seq = "CREATE SEQUENCE openjump_dbid_sequence;";
+                "    WHERE sequence_schema = '" + dbSchema + "' AND 
sequence_name = 'openjump_dbid_sequence';";
+        String sql_create_seq = "CREATE SEQUENCE \"" + dbSchema + 
"\".openjump_dbid_sequence;";
         String sql_create_dbid = "ALTER TABLE " + tableFullName + " ADD COLUMN 
\"" +
-                primaryKey + "\" BIGINT DEFAULT 
nextval('openjump_dbid_sequence') PRIMARY KEY;";
+                primaryKey + "\" BIGINT DEFAULT nextval('\"" + dbSchema + 
"\".openjump_dbid_sequence') PRIMARY KEY;";
         boolean sequence_already_exists;
         // check if openjump_dbid_sequence already exists
         try {


------------------------------------------------------------------------------
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to