[DBIx-Class-Devel] [dbsrgits/sql-translator] Support for removing NOT NULL constraints in PostgreSQL. (#133)

[Yoshiyuki Uehara]

Fix a problem in PostgreSQL that caused incorrect ALTER TABLE output when NOT NULL constraints were removed.

For example,
```
ALTER TABLE "customer" DROP CONSTRAINT ;
ALTER TABLE "customer" ALTER COLUMN "customername" DROP NOT NULL;
```

The first line is trying to remove an unnamed NOT NULL constraint, which is unnecessary.
You can view, comment on, or merge this pull request online at:

  https://github.com/dbsrgits/sql-translator/pull/133

-- Commit Summary --

  * Fixed a bug in PostgreSQL when dropping NOT NULL constraints.

-- File Changes --

    M lib/SQL/Translator/Producer/PostgreSQL.pm (5)
    M t/30sqlt-new-diff-pgsql.t (4)
    M t/data/diff/pgsql/create1.yml (14)

-- Patch Links --

https://github.com/dbsrgits/sql-translator/pull/133.patch
https://github.com/dbsrgits/sql-translator/pull/133.diff

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/pull/133
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20210407/6abcb70f/attachment.htm>