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

Bug report CHECK CONSTRAINTS

From: "Pavel Veretennikov" <vermut(at)kid(dot)lv>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug report CHECK CONSTRAINTS
Date: 2004-07-12 09:18:46
Message-ID: opsa0phkhtuo8gh7@developer3 (view raw or flat)
Thread:
Lists: pgadmin-support
Windows 2000
Russian language
Binary snapshot from Jun 23

When viewing table creation script, it produces following code (example):
   stakecreditliminusd numeric(11,2) NOT NULL DEFAULT 0.00,
   CONSTRAINT gs_players_pkey PRIMARY KEY (userid),
   CONSTRAINT "$1" CHECK sex >= 0,
   CONSTRAINT "$2" CHECK "type" >= 0
)
WITH OIDS;

When trying to copy-paste-run it, it complains about CHECK contstraints,  
cause they should be written like
   CONSTRAINT "$1" CHECK (sex >= 0),
   CONSTRAINT "$2" CHECK ("type" >= 0)

according to documentation. PostgreSQL 7.4.3


-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

Responses

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-07-12 13:16:12
Subject: Re: Bug report CHECK CONSTRAINTS
Previous:From: Bruno Wolff IIIDate: 2004-07-09 15:27:22
Subject: Re: [PHP] Secure DB Systems - How to

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