Versions Compared

Old Version 10

changes.mady.by.user Amy Smith

Saved on

compared with

New Version 11

changes.mady.by.user Amber Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

Use the specified folder for listed PostgreSQL database operations. 

Operation and Object Type

Packaging Folders (fixed folders)

Package Methods (flexible folders)

Archived

Notes

CREATE/ALTER/DROP DATABASE LINK

sql_direct

direct

Yes

CREATE/ALTER/DROP FUNCTION

sql_direct

direct

Yes

CREATE/ALTER/DROP INDEX

ddl, ddl_direct, sql_direct,

convert, ddl_direct, direct

Yes

CREATE/ALTER/DROP PROCEDURE

procedure

storedlogic

No

CREATE/ALTER/DROP QUEUE

sql_direct

direct

Yes

CREATE/ALTER/DROP SEQUENCE

ddl, ddl_direct, sql_direct

convert, ddl_direct, direct

Yes

CREATE/ALTER/DROP SYNONYM

ddl, ddl_direct, sql_direct

convert, ddl_direct, direct

Yes

For ALTER and CREATE OR REPLACE synonym use ddl_direct or sql_direct/direct. (Do not use ddl/convert with ALTER and CREATE OR REPLACE synonym.)

CREATE/ALTER/DROP TABLE

ddl, ddl_direct, sql_direct

convert, ddl_direct, direct

Yes

For PARTITIONED TABLE changes, use sql_direct folder

CREATE/ALTER/DROP TRIGGER

trigger

storedlogic

No

CREATE/ALTER/DROP TYPE

sql_direct

direct

Yes

CREATE/ALTER/DROP VIEW

view

storedlogic

No

CREATE/ALTER/DROP VIEW INDEX

ddl, ddl_direct, sql_direct

convert, ddl_direct, direct

Yes

RENAME <DB_OBJECT>

sql_direct

direct

Yes

Operation

Packaging Folder (fixed folders)

Package Method (flexible folders)

Archived

INSERT, UPDATE, DELETE, SELECT

data_dml

data_dml

Yes

GRANT, REVOKE

sql_direct

direct

Yes

Error Handling

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

...