phinx icon indicating copy to clipboard operation
phinx copied to clipboard

Missing Postgres types

Open Bilge opened this issue 5 years ago • 2 comments

The Postgres adapter supports some DBMS specific types, such as interval, but not all. For example, timestamp with time zone and its shorthand, timestamptz are missing.

Bilge avatar Jul 03 '20 19:07 Bilge

Do you want to make a PR to add them? The prio so far was usually the ones that are agnostic across the DBs, but that doesn't mean we couldn't add also more specific ones.

dereuromark avatar Oct 18 '20 12:10 dereuromark

No, I completely gave up using the API methods. All migrations are just execute() statements in up() and down() configurations. Phinx will never support the full feature set of Postgres, and simply adding a few types doesn't even begin to bring it closer to that lofty goal. Moreover, there are some highly questionable defaults when using the API, such as assuming everything should have an autonumber column, which is actually an anti-pattern of database design. I don't need to go on, I'm sure you get my point.

Bilge avatar Oct 18 '20 12:10 Bilge