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: (view raw or whole 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


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-2015 The PostgreSQL Global Development Group