[DBIx-Class-Devel] [dbsrgits/sql-translator] Implement EXCLUDE constraint for PostgreSQL (#98)

[Eugen Konkov]

This pull request will allow to generate next statement

    ALTER TABLE subnets ADD CONSTRAINT subnets_subnet_udx  EXCLUDE USING gist ( subnet inet_ops with && ) WHERE state = 0;


with next syntax:

	$sqlt_table->add_constraint(
		name       =>  'subnets_subnet_udx',
		type       =>  'exclude',
		fields     =>  'subnet',
		expression =>  'subnet inet_ops with &&',
		options    =>  { using => 'gist', where => 'state = 0' },
	);

You can view, comment on, or merge this pull request online at:

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

-- Commit Summary --

  * Implement EXCLUDE constraint for PostgreSQL

-- File Changes --

    M lib/SQL/Translator/Producer/PostgreSQL.pm (9)
    M lib/SQL/Translator/Schema/Constants.pm (5)
    M lib/SQL/Translator/Schema/Constraint.pm (1)

-- Patch Links --

https://github.com/dbsrgits/sql-translator/pull/98.patch
https://github.com/dbsrgits/sql-translator/pull/98.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/98
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20171021/76efe9e2/attachment.htm>