Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version 6

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Qualifying Object Names

  • Do not qualify objects with the database name as PostgreSQL connections represent one database at a time.

  • For a Single-Schema project, you don’t need to qualify object names with the schema name. If they are not qualified, Datical DB uses the default schema if it is specified.

  • For a Multi-Schema project, you must qualify object names with the schema name so they get deployed to the correct schema during packaging.

  • You can use the schemaName attribute in the metadata.properties file to specify the default schema. See Using the metadata.properties file.

PostgreSQL SCM Packaging Patterns

Datical DB packages non-transient files differently from transient files. Place scripts for PostgreSQL objects in packaging folders as follows:

...

Info

PostgreSQL packaging doesn't support ssis/ssis_project, package, packagebody, and sqlplus folders.

Packager requires that stored logic scripts (procedure, view, trigger) have only one object or statement per file with nothing preceding or following the object definition. No additional statements.

Objects and Packaging Folders

Use the specified folder for listed PostgreSQL database operations. 

...

Operation

Packaging Folder

Archived

INSERT, UPDATE, DELETE, SELECT

data_dml

Yes

GRANT, REVOKE

sql_direct

Yes

Error Handling

Do not put error-handling statements in the SQL scripts.

...