[BUGS] Bug in the information_schema.referential_constraints view

2003-10-14 Thread malerba
If PostgreSQL failed to compile on your computer or you found a bug that is likely to be specific to one platform then please fill out this form and e-mail it to [EMAIL PROTECTED] To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the problem

[BUGS] Wrong uppler lower for national characters.

2003-10-14 Thread Viacheslav N Tararin
Hi. Next code: select upper(field1) from table1; Convert all latin symbols <128 in to UPPER case but all not latin >128 in lower case locale consistent. Function lower work vicevesa upper(), wrong too. ilake() function work wrong too. Environment: ASPLinux 7.2. gcc 2.96 kernel 2.4.9-13.smp Po

[BUGS]

2003-10-14 Thread Igor Shevchenko
Your name : Igor Shevchenko Your email address : [EMAIL PROTECTED] System Configuration - Architecture: Intel Pentium 4 Operating System: 2.4.20-8 ELF PostgreSQL version: PostgreSQL-7.4beta4 Compiler used: gcc version 3.2.2 20030222 (Red Hat

[BUGS] ECPG - Keywords as variable names (7.4 regression)

2003-10-14 Thread Gavin Scott
POSTGRESQL BUG REPORT TEMPLATE Your name : Gavin Scott Your email address : [EMAIL PROTE

[BUGS] 'pg_class_aclcheck: relation not found' with temp tables in plpgsql

2003-10-14 Thread Reece Hart
Cheers- I'm getting warnings like this in a pl/pgsql function: ERROR: pg_class_aclcheck: relation 32523241 not found The function is (this is, obviously, just to demonstrate the problem): create or replace function temptest() returns void language plpgsql as ' DEC

Re: [BUGS]

2003-10-14 Thread Tom Lane
Igor Shevchenko <[EMAIL PROTECTED]> writes: > The problem is repeatable when I run my program, especially if the postgresql > server and the sserv are on the same server, and the debugging is off. > Please let me know if you need more details, I'll try to narrow the conditions > to make a simple r

Re: [BUGS] Wrong uppler lower for national characters.

2003-10-14 Thread Peter Eisentraut
Viacheslav N Tararin writes: > select upper(field1) from table1; > > Convert all latin symbols <128 in to UPPER case but all not latin >128 > in lower case locale consistent. Function lower work vicevesa upper(), > wrong too. > > ilake() function work wrong too. "Right" and "wrong" are defined b

Re: [BUGS] Bug in the information_schema.referential_constraints view

2003-10-14 Thread Tom Lane
[EMAIL PROTECTED] writes: > The information_schema.referential_constraints retuns wrong data because > there is an incomplete joining condition in the WHERE clause. > [ these two conditions need to be added: ] > AND con.contype = 'f' > AND con.confrelid = pkc.conrelid I think t

Re: [BUGS] [GENERAL] Partial indices...

2003-10-14 Thread Martijn van Oosterhout
That's very strange. However, since the tables in question are empty you could get strange results like this. How many rows does your real app have. Can you show the explain for each index on your real app? Hope this helps, On Fri, Oct 10, 2003 at 03:26:13PM -0400, Dmitry Tkach wrote: > Hi, every