Re: [GENERAL] glitch installing xml support in 9.1.beta2

2011-06-25 Thread Guillaume Lelarge
On Fri, 2011-06-24 at 11:22 -0600, Rob Sargent wrote: > OpenSuse 11.4 x86-64 > > gmake install builds and places the requisite pieces as expected. > > Running > psql --username postgres -d postgres -f xml2--1.0,sql > results in > psql:xml2--1.0.sql:8: ERROR: function "xml_valid" a

Re: [GENERAL] glitch installing xml support in 9.1.beta2

2011-06-25 Thread Rob Sargent
Guillaume Lelarge wrote: On Fri, 2011-06-24 at 11:22 -0600, Rob Sargent wrote: OpenSuse 11.4 x86-64 gmake install builds and places the requisite pieces as expected. Running psql --username postgres -d postgres -f xml2--1.0,sql results in psql:xml2--1.0.sql:8: ERROR: funct

Re: [GENERAL] blks_read/blks_hit stats

2011-06-25 Thread Nigel Heron
On 11-06-15 12:38 PM, Nigel Heron wrote: Hi everyone, I'm playing with the stats views and functions to graph them in cacti.. Adding up *_blks_hit (heap, idx, toast and tidx) from pg_statio doesn't match blks_hit in pg_stat_database. Sometimes the sum is higher, sometimes lower. Do they have si

[GENERAL] An amusing MySQL weakness--not!

2011-06-25 Thread Michael Nolan
Earlier today I was working on a MySQL database (not by choice, I assure you), and I typed a statement like this: Update tablexyz set field1 = '15' where field2 - 20; The '-' was supposed to be an equal sign, but MySQL executed it anyway. (Field2 is an integer.) I was not amused. PostgreSQL rep

Re: [GENERAL] An amusing MySQL weakness--not!

2011-06-25 Thread Randal L. Schwartz
> "Michael" == Michael Nolan writes: Michael> Earlier today I was working on a MySQL database (not by choice, I assure Michael> you), Friends don't let friends use MySQL. -- Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095 http://www.stonehenge.com/merlyn/> Sma