Re: [pgadmin-support] Bug report CHECK CONSTRAINTS

2004-07-12 Thread Andreas Pflug
Pavel Veretennikov wrote: 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) Yo

[pgadmin-support] Bug report CHECK CONSTRAINTS

2004-07-12 Thread Pavel Veretennikov
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