Dear all, i want to create partitions table :
*create table advertisements_otomotif (CHECK (select * from advertisements where category_id in (select id from categories where name='Otomotif'))) INHERITS (advertisements)
* but i have error like this: *ERROR: syntax error at or near "select" LINE 1: create table advertisements_otomotif (CHECK (select * from a... ^ ********** Error ********** ERROR: syntax error at or near "select" SQL state: 42601 Character: 46 *any have sollutions? thanks -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin