[BUGS] replace_vars_with_subplan_refs

2002-04-16 Thread Michal Schwarz
SELECT emaily.email, emaily.jmeno, ''::text, 'emaily' FROM ONLY emaily WHERE (emaily.akce = 'add') ) vsichni WHERE (vsichni.email ~ '@'::text) ORDER BY lower(vsichni.email); When this schema exists, tr

[BUGS] Case sensitivity in psql/pg_dump

2002-04-16 Thread Michal Schwarz
7;, which is incorrect, because user name 'BLBEC' should be enclosed by quotes. Psql 7.1 worked even withoud quotes and connected as user 'BLBEC', while psql 7.2 fails with error: FATAL 1: user "blbec" does not exist Previous connection kept Ie. p

[BUGS] BUG #2974: broken CHECK constraint with varchar

2007-02-08 Thread Michal Schwarz
The following bug has been logged online: Bug reference: 2974 Logged by: Michal Schwarz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.7 Operating system: Fedora Core 6 Description:broken CHECK constraint with varchar Details: CREATE TABLE t (c VARCHAR(20