Does "constraint" and "check" work in 6.3.2 ?

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL general <pgsql-general(at)postgreSQL(dot)org>, PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Does "constraint" and "check" work in 6.3.2 ?
Date: 1998-10-28 18:46:08
Message-ID: 36376670.E573456E@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael A. Koerber SR 1998-10-28 19:14:09 RE: [GENERAL] Creating web images from postgres data
Previous Message Jackson, DeJuan 1998-10-28 17:22:18 RE: [GENERAL] Creating web images from postgres data

Browse pgsql-interfaces by date

  From Date Subject
Next Message Matthew 1998-10-28 19:21:52 PgAccess Problem
Previous Message Peter T Mount 1998-10-28 18:44:47 Re: [INTERFACES] applet don't go