Re: [BUGS] BUG #2758: missing quotes in SQL sentence

2006-11-15 Thread Dave Page
Peter Eisentraut wrote: Dave Page wrote: No, it's the intended behaviour. pgAdmin doesn't have any idea how you want to quote SET values, so it leaves it to you to add them. Just quote them all. Doesn't work: scratch=# set search_path = '"MyNameSpace1", "MyNameSpace2"'; ERROR: schema ""MyN

Re: [BUGS] 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio

2006-11-15 Thread Zdenek Kotala
Andreas Lange wrote: Zdenek Kotala wrote: Main problem is -fast switch. It modifies behavior of floating point operation (it is reason why It is not good option for postgres) and use another floating point libraries and some function are inlined. It is reason why pow test passed with -fast swit

[BUGS] BUG #2759: \df doesn't show functions with no args

2006-11-15 Thread Leon Miller-Out
The following bug has been logged online: Bug reference: 2759 Logged by: Leon Miller-Out Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: CentOS 4.4 x64 Description:\df doesn't show functions with no args Details: \df doesn't show functio

[BUGS] How to crash postgres using savepoints

2006-11-15 Thread Joseph Shraibman
See example below. At the very least the documentation needs to tell users that savepoints use shared memory, and the cofusing HINT string needs to be changed to something more useful. When run on a machine running 8.2b3 version: PostgreSQL 8.2beta3 on i686-pc-linux-gnu, compiled by GCC gcc

[BUGS] Postgresql out-of-memory error

2006-11-15 Thread Joe Malicki
I have a query that is aborting because of out of memory, and am wondering what I can do to prevent this from *ever* happening (shouldn't it be able to use disk)? =# explain INSERT INTO term_doc_rel3 (term, docid) -# select w.termid, t.docid from -# (select (stat('select idxfti from sampledocs3