Re: [BUGS] BUG #6667: diplom on english language on your site

2012-05-30 Thread Robert Haas
On Mon, May 28, 2012 at 11:12 AM, dmitrytu...@narod.ru wrote: The following bug has been logged on the website: Bug reference:      6667 Logged by:          Dmitry Turin Email address:      dmitrytu...@narod.ru PostgreSQL version: Unsupported/Unknown Operating system:   windows

Re: [BUGS] BUG #6667: diplom on english language on your site

2012-05-30 Thread Tomas Vondra
On 30 Květen 2012, 14:37, Robert Haas wrote: On Mon, May 28, 2012 at 11:12 AM, dmitrytu...@narod.ru wrote: The following bug has been logged on the website: Bug reference:      6667 Logged by:          Dmitry Turin Email address:      dmitrytu...@narod.ru PostgreSQL version:

[BUGS] overwriting an existing .so while being used crashes the server process

2012-05-30 Thread Tomas Vondra
Hi, whenever I run a C-function (part of an .so file) and the file is overwritten, the connection crashes. Tested on 9.1.3 and 9.2-beta1. It's 100% reproducible: 1) compile the attached file and copy the .so to pkglibdir $ gcc -I/home/tomas/tmp/postgresql-9.1.2/src/include testcomp.c

Re: [BUGS] overwriting an existing .so while being used crashes the server process

2012-05-30 Thread Tom Lane
Tomas Vondra t...@fuzzy.cz writes: whenever I run a C-function (part of an .so file) and the file is overwritten, the connection crashes. Tested on 9.1.3 and 9.2-beta1. Doctor, it hurts when I do this. So don't do that. What exactly would you expect Postgres to do about such a thing, anyway?

Re: [BUGS] overwriting an existing .so while being used crashes the server process

2012-05-30 Thread Tomas Vondra
On 30.5.2012 22:35, Tom Lane wrote: Tomas Vondra t...@fuzzy.cz writes: whenever I run a C-function (part of an .so file) and the file is overwritten, the connection crashes. Tested on 9.1.3 and 9.2-beta1. Doctor, it hurts when I do this. So don't do that. What exactly would you expect

[BUGS] pg_dump/pg_restore with time zone displacement out of range

2012-05-30 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have the following strange effect, maybe someone has an idea on wether this is 'normal' or a bug: My platform: Ubuntu 12.04, PostgreSQL 9.2beta1, tried it with 9.1 with same result. postgresql.conf is stock, except for timezone, which is set

Re: [BUGS] overwriting an existing .so while being used crashes the server process

2012-05-30 Thread Tom Lane
Tomas Vondra t...@fuzzy.cz writes: On 30.5.2012 22:35, Tom Lane wrote: Tomas Vondra t...@fuzzy.cz writes: whenever I run a C-function (part of an .so file) and the file is overwritten, the connection crashes. Tested on 9.1.3 and 9.2-beta1. What exactly would you expect Postgres to do about

Re: [BUGS] pg_dump/pg_restore with time zone displacement out of range

2012-05-30 Thread Tom Lane
Patric Bechtel patric.bech...@gmail.com writes: My platform: Ubuntu 12.04, PostgreSQL 9.2beta1, tried it with 9.1 with same result. postgresql.conf is stock, except for timezone, which is set to Asia/Manila. $ createdb -U postgres tztest $ psql tztest postgres tztest=# create table foo

Re: [BUGS] overwriting an existing .so while being used crashes the server process

2012-05-30 Thread Tomas Vondra
On 30.5.2012 23:19, Tom Lane wrote: I suspect it depends on how you install the new version of the library, too. I would somewhat expect it to work as you're thinking if the install consists of rename old file out of the way, copy new file into place, unlink old file or equivalent. If you

[BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-05-30 Thread Edmund Horner
Hello, apologies if this is already in your radar. I can successfully install the PostgreSQL 9.2 beta1 binaries on Windows XP and successfully perform most queries. However I've run into some trouble with the XML support. From a very cursory search I did not see anything changed since 9.1.3

[BUGS] BUG #6668: hashjoin cost problem

2012-05-30 Thread postgresuser
The following bug has been logged on the website: Bug reference: 6668 Logged by: Postgres User Email address: postgresu...@yahoo.com PostgreSQL version: 9.1.3 Operating system: Ubuntu Description: work_mem 1MB create table small(i) as select (g/1000) * 1000 from

Re: [BUGS] BUG #6668: hashjoin cost problem

2012-05-30 Thread Tom Lane
postgresu...@yahoo.com writes: create table small(i) as select (g/1000) * 1000 from generate_series(1,1) g; create table large(i) as select generate_series(1,1); It doesn't matter how big the big table is... for this distribution large table is hashed. I don't think that's