Skip site navigation (1) Skip section navigation (2)

Partitions Table

From: idris khanafi <idris(dot)khanafi(at)detik(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Partitions Table
Date: 2009-08-26 09:09:51
Message-ID: 4A94FBDF.1060600@detik.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: OliveirosDate: 2009-08-26 15:22:07
Subject: Re: Trouble with postgres user's password on Windows
Previous:From: Pablo Alonso-Villaverde RozaDate: 2009-08-26 07:01:38
Subject: Re: Avoid duplicated rows when restoring data from pg_dumpall ??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group