Skip to content

pgrecon 0.2.1

Choose a tag to compare

@Muzzammil242 Muzzammil242 released this 19 Aug 08:46
· 30 commits to main since this release

Code-lane refinements, all proven on a live PostgreSQL 16 before tagging.

  • Bare procedure-call statements become CALL statements with the
    parentheses CALL requires, resolved against the extracted
    procedures.
  • EXIT WHEN cursor%NOTFOUND directly after a FETCH of the same cursor
    becomes EXIT WHEN NOT FOUND, which is what plpgsql's FOUND reports
    at that point. This converts the classic OPEN/FETCH/EXIT/CLOSE
    cursor loop mechanically.
  • :name bind placeholders inside EXECUTE IMMEDIATE literals fold to
    numbered parameters when their count matches the USING arity;
    Oracle binds them by position exactly as PostgreSQL numbers them.
    OUT bind arguments refuse; mismatched counts stay verbatim under
    the standing verify-by-hand note.
  • Sized character declarations in code (VARCHAR2(200) and friends)
    now map; the size pattern never matched type names containing a
    digit, so they were refused as unsupported.

See CHANGELOG.md for details.