Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Bug report CHECK CONSTRAINTS

Bug report CHECK CONSTRAINTS



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/



Home | Main Index | Thread Index

top