AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

reviewing-oracle-to-postgres-migration

Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting/collations, UNION ALL planner risks, materialized-view refresh requirements, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.

Original source
github
License
MIT
Pinned revision
5269f7ea2d6c3a9bfda5ed878b6726cf509121fd

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

Ask your assistant

Use Agentic Memory skills to read github--reviewing-oracle-to-postgres-migration at revision 5269f7ea2d6c3a9bfda5ed878b6726cf509121fd, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 16

references/REFERENCE.md

Reference Index

| File | Brief description | | --- | --- | | empty-strings-handling.md | Oracle treats '' as NULL; PostgreSQL keeps empty strings distinct—patterns to align behavior in code, tests, and migrations. | | no-data-found-exceptions.md | Oracle SELECT INTO raises "no data found"; PostgreSQL doesn’t—add explicit NOT FOUND handling to mirror Oracle behavior. | | oracle-nvl-decode-functions.md | Oracle NVL/NVL2/DECODE have no direct equivalents—replace with COALESCE, CASE WHEN, and NULL-safe comparisons. | | oracle-parentheses-from-clause.md | Oracle allows FROM(TABLE_NAME) syntax; PostgreSQL requires FROM TABLE_NAME—remove unnecessary parentheses around table names. | | oracle-rownum-pagination.md | Oracle ROWNUM is assigned before ORDER BY; replace top-N and pagination patterns with LIMIT/OFFSET. | | oracle-sysdate-sequences-dual.md | Replace SYSDATE/SYSTIMESTAMP with NOW(), sequence .NEXTVAL with nextval('seq'), and remove FROM DUAL. | | oracle-to-postgres-sorting.md | How to preserve Oracle-like ordering in PostgreSQL using COLLATE "C" and DISTINCT wrapper patterns. | | oracle-to-postgres-to-char-numeric.md | Oracle allows TO_CHAR(numeric) without format; PostgreSQL requires format string—use CAST(numeric AS TEXT) instead. | | oracle-to-postgres-type-coercion.md | PostgreSQL strict type checks vs. Oracle implicit coercion—fix comparison errors by quoting or casting literals. | | postgres-union-all-planner.md | UNION ALL branches can produce poor plans when predicate pushdown is limited—review plans and split or reshape queries when needed. | | postgres-materialized-view-refresh.md | Materialized views are not auto-refreshed after base-table changes—application or jobs must explicitly refresh them. | | postgres-concurrent-transactions.md | PostgreSQL allows only one active command per connection—materialize results or use separate connections to avoid concurrent operation errors. | | postgres-refcursor-handling.md | Differences in refcursor handling; PostgreSQL requires fetching by cursor name—C# patterns to unwrap and read results. | | oracle-to-postgres-timestamp-timezone.md | CURRENT_TIMESTAMP / NOW() return UTC-normalised timestamptz in PostgreSQL; Npgsql surfaces DateTime.Kind=Unspecified—force UTC at connection open and in application code. |