Postgres Pro
Downloads
Home   >   mailing lists

Partitions Table - Mailing list pgsql-admin

From idris khanafi
Subject Partitions Table
Date
Msg-id 4A94FBDF.1060600@detik.com
Whole thread Raw
Responses Re: Partitions Table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Jan-Peter Seifert
Date:
Subject: Re: Trouble with postgres user's password on Windows
Next
From: Pablo Alonso-Villaverde Roza
Date:
Subject: Re: Avoid duplicated rows when restoring data from pg_dumpall ??