When it is an expression, it will be evaluated with each input document and one SQL statement per each input document will be executed.
The SQL statement property now can be set as an expression property.Dynamic DB queries now supported in the Execute Snap.A - otd:6828 Postgres Snap shows wrong data type in preview for timestamp withtime zone data type.JSON paths in WHERE clauses should be processed as bind values after the expression is evaluated.PostgreSQL Snaps did not properly handle when a table name was created in mixed case.
PostgreSQL Insert Snap: resolved an issue where it inserts a negative value when the input data was out of range. #Psql update drivers
This Snap Pack is now compatible with the PostgreSQL drivers available in 4.3 Patch mrc222.
Note: The fix for this issue required updating libraries that impacted all database Snaps except those for MongoDB. Resolved an issue with PostgreSQL Select Snap not parsing JSON data type correctly. Resolved an issue in the PostgreSQL Snaps that resulting from restrictions on the 'with' operator in conjunction with the RECURSIVE keyword. Resolved an issue in the PostgreSQL - Execute Snap that resulted from restrictions on the 'with' operator in conjunction with an 'insert' statement. SnapLogic anticipates that the Snap will execute up to 3 times faster than the previous version for enterprise workloads. Updated the label for Delete Condition to Delete Condition (Truncates Table if empty) in the PostgreSQL Delete Snap.įixed an issue with PostgreSQL - Execute Snap, where the Snap failed when using Delete query with the RETURNING function.Įnhanced the PostgreSQL - Execute Snap to invoke stored procedures.Įnhanced the performance of PostgreSQL - Bulk Load Snap significantly. The PostgreSQL - Bulk Load Snap can now process the records with more than 16KB in the document without encountering BufferOverflowException because the default value of 16KB for byte buffer size is now removed.Įnhanced the PostgreSQL Account and PostgreSQL Dynamic Account with SSH Tunneling configurations to encrypt the network connection between the client and the PostgreSQL Database server, thereby ensuring the secure network connection.Įnhanced the PostgreSQL Account and PostgreSQL Dynamic Account with SSH Tunneling configurations to encrypt the network connection between the client and the PostgreSQL Database server, thereby ensuring a secure network connection. The PostgreSQL Select Snap now works as expected when the table name is dependent on an upstream input. The PostgreSQL Select and PostgresSQL Execute Snaps now read NaN values in Numeric columns when used with a PostgreSQL Account configured with the latest postgresql-42.5.0.jar driver. The table metadata is provided in the second input view. The Create table if not present checkbox is selected. The PostgreSQL - Insert Snap now creates the target table only from the table metadata of the second input view when the following conditions are met: The PostgreSQL - Bulk Load Snap can now process records with more than 16 KB in the document without encountering the BufferOverflowException because the default value of 16 KB for byte buffer size is now removed. The PostgreSQL Snap Pack supports geospatial data types. This issue occurred when metadata from the second input view document contained columns of the bytea data type. The PostgreSQL - Bulk Load and PostgreSQL - Insert Snaps no longer fail with the message ERROR: type modifier is not allowed for type 'bytea' when creating a new table if Create table if not present is selected and the target table does not exist. Upgraded with the latest SnapLogic Platform release. 
When Auto is selected, the Snap tries to determine the query type automatically.įixed an issue with the PostgreSQL Insert Snap that inconsistently inserted some columns and missed the remaining columns(especially the Time fields), when the data was passed in the JSON format from an upstream Snap. The PostgreSQL - Execute Snap now includes a new Query type field.
0 kommentar(er)
