Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Domains are not created #109

Closed
KES777 opened this issue Jul 19, 2018 · 3 comments
Closed

Domains are not created #109

KES777 opened this issue Jul 19, 2018 · 3 comments

Comments

@KES777
Copy link
Contributor

KES777 commented Jul 19, 2018

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
Copy link
Contributor

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
Copy link
Contributor Author

KES777 commented Mar 3, 2022

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
Copy link
Contributor

okay, so closed in favor of #136

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants