errors while rescanPorts after upgrading to 3.4

[Dmitry Morozovsky]

On Tue, 6 Dec 2011, Joe Marcus Clarke wrote:

> > 
> > but this query pair succeeds:
> > 
> > tb=# alter table port_dependencies drop CONSTRAINT 
> > port_dependencies_dependency_type_check;
> > ALTER TABLE
> > 
> > tb=# ALTER TABLE port_dependencies add check (
> > dependency_type IN ('UNKNOWN', 'EXTRACT_DEPENDS', 'PATCH_DEPENDS',
> > 'FETCH_DEPENDS', 'BUILD_DEPENDS', 'LIB_DEPENDS', 'RUN_DEPENDS',
> > 'TEST_DEPENDS')) ;
> > ALTER TABLE
> 
> Lovely.  My pgsql ignorance shines through again.  So the only way to
> update this check is to first remove it then re-add it again?

It seems so, according to

http://www.postgresql.org/docs/8.4/static/sql-altertable.html
http://www.postgresql.org/docs/9.0/static/sql-altertable.html

-- 
Sincerely,
D.Marck                                     [DM5020, MCK-RIPE, DM3-RIPN]
[ FreeBSD committer:                                 marck at FreeBSD.org ]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck at rinet.ru ***
------------------------------------------------------------------------