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 w

[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 gen

[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 tha

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 y

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

2012-05-30 Thread Tom Lane
Patric Bechtel 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 (bar int, baz timestam

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

2012-05-30 Thread Tom Lane
Tomas Vondra writes: > On 30.5.2012 22:35, Tom Lane wrote: >> Tomas Vondra 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 such a thing, any

[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 Tomas Vondra
On 30.5.2012 22:35, Tom Lane wrote: > Tomas Vondra 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 Po

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

2012-05-30 Thread Tom Lane
Tomas Vondra 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? It has no

[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] 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, 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 >>

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, 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 > Description: > > Excuse