Re: [ADMIN] Partitions Table

2009-08-27 Thread Tom Lane
idris khanafi writes: > 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) > * This is completely confused. I'm not sure what yo

[ADMIN] Partitions Table

2009-08-26 Thread idris khanafi
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"