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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-interfaces by date

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

pgsql-general by date

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

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