search

dbsrgits / sql-translator

SQL::Translator (SQLFairy)
http://sqlfairy.sourceforge.net/
82 stars 91 forks source link

Domains are not created #109

Closed KES777 closed 2 years ago

KES777 commented 6 years ago

My PostgreSQL database has domains:

CREATE DOMAIN tkol AS NUMERIC(10,3)

The domains are not created when I run:

$(which dbic-migration) --force --schema_class App::Schema --database PostgreSQL -Ilib prepare

Currently I manually copy 001-a_domains.sql between deployment migrations after each prepare

rabbiveesh commented 2 years ago

Hi, are you sure this is an issue in SQLT? Could you share the perl code that you used to create the domain?

It's important to see the code, b/c DBICM has a few layers of indirection, so we'd have to trace down fully where this may or may not be an issue.

KES777 commented 2 years ago

Sorry, from today point of view I do not remember. Probably SQL::Translator::Producer::PostgreSQL should have something: sub create_domain and/or CREATE DOMAIN ...

rabbiveesh commented 2 years ago

okay, so closed in favor of #136