search

sqlectron / sqlectron-core

https://sqlectron.github.io/
MIT License
221 stars 69 forks source link

fix wrong column order for createTableQuery for pg12 #85

Closed MasterOdin closed 4 years ago

MasterOdin commented 4 years ago

Moving from pg9 to pg12, the column order for the createTableQuery is now in the wrong order. This is probably due to the fact that array_agg does not actually guarantee an order unless you use an inner ORDER BY, where if you use an ORDER BY outside of it, the docs just say that it'll probably work.

Fixes #79

MasterOdin commented 4 years ago

Tested working in sqlectron-gui (and that master had a bug).