From: Jose' Soares <jose@sferacarta.com>
To: Constantin Teodorescu <teo@flex.ro>
Cc: PostgreSQL general <pgsql-general@postgresql.org>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Does "constraint" and "check" work in 6.3.2 ?
Date: Thu, 29 Oct 1998 11:30:27 +0100
Message-ID: <363843C3.D50853FF@sferacarta.com> (raw)
References: <36376670.E573456E@flex.ro>
Hi Constantin,
This is a syntax problem, there are two kinds of constraints (table and
column constraints)
and both of them must be defined inside ( ) not outside:
create table emppay (
name text not null check (name <> ''), --column
constraint definition
wage float4 default 10.00,
constraint empcon check (wage > 5.30 and wage <= 30.00) --table
constraint definition
);
CREATE
Jose'
Constantin Teodorescu wrote:
>
> 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"
>
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: jose@sferacarta.com, teo@flex.ro, pgsql-general@postgresql.org
Subject: Re: [INTERFACES] Does "constraint" and "check" work in 6.3.2 ?
In-Reply-To: <363843C3.D50853FF@sferacarta.com>
* 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