Index: openacs-4/packages/layout-manager/sql/postgresql/pages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/layout-manager/sql/postgresql/pages-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/layout-manager/sql/postgresql/pages-create.sql 19 Jan 2010 22:52:47 -0000 1.2 +++ openacs-4/packages/layout-manager/sql/postgresql/pages-create.sql 4 Feb 2010 22:28:42 -0000 1.3 @@ -34,8 +34,10 @@ not null, constraint l_pages_pageset_id_sort_key_un unique (pageset_id, sort_key), + constraint l_pages_pageset_id_url_name_un + unique (url_name, pageset_id), constraint l_pages_pageset_id_name_un - unique (url_name, name, pageset_id) + unique (name, pageset_id) ); create index layout_pages_page_idx on layout_pages (pageset_id, page_id);