From: Constantin Teodorescu <teo@flex.ro>
To: PostgreSQL general <pgsql-general@postgreSQL.org>
To: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Does "constraint" and "check" work in 6.3.2 ?
Date: Wed, 28 Oct 1998 18:46:08 +0000
Message-ID: <36376670.E573456E@flex.ro> (raw)
I am planning a new release to PgAccess (mainly bug fixes) and I'm
wondering if "constraint" and "check" are working !
I am using PostgreSQL 6.3.2 and this example from man create_table is
not working for me !
Please reply as soon as possible, so I could release this version prior
to 6.4 Pg release.
testdb=> create table emppay (name text not null, wage float4 default
10.00) constraint empcon check (wage > 5.30 and wage <= 30.00), check
(name <> '');
ERROR: parser: parse error at or near "constraint"
???!????
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.ro, pgsql-general@postgreSQL.org
Subject: Re: Does "constraint" and "check" work in 6.3.2 ?
In-Reply-To: <36376670.E573456E@flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox