[BUGS] Encounter shared memory error when running createlang command!

2009-09-23 Thread Yaming Gu
Hi, List Because I need to use pl/perl language, then I decided to run “createlang” to create PL/Perl language. I have checked all dependencies and all is ok. Next I run: D:\Program Files\Postgresql\bin>createlang �CU postgres plperl example (example is my dbname) Then it failed telling m

Re: [BUGS] BUG #4991: problem with ODBC driver 8.4

2009-09-23 Thread Hiroshi Saito
Hi Annita-san. Thank you for many information. Version 08.04.0100 had some problems. CVS-HEAD was corrected by inoue-san. http://archives.postgresql.org/pgsql-committers/2009-08/msg00287.php Could you please try the drivers on testing for 8.4.0101 at http://www.geocities.jp/inocchichichi/psqlod

[BUGS] BUG #5074: segmentation fault in autovacuum

2009-09-23 Thread Nic
The following bug has been logged online: Bug reference: 5074 Logged by: Nic Email address: nicw...@yandex.ru PostgreSQL version: 8.4.1 Operating system: Red Hat 5 Description:segmentation fault in autovacuum Details: I try to create test db and fill it by our objec

[BUGS] BUG #5075: Text Search parser does not identify xml tag when attribute name's contains underscore

2009-09-23 Thread Marek Lewczuk
The following bug has been logged online: Bug reference: 5075 Logged by: Marek Lewczuk Email address: ma...@lewczuk.com PostgreSQL version: 8.4.0 Operating system: All Description:Text Search parser does not identify xml tag when attribute name's contains underscore D

Re: [BUGS] BUG #5074: segmentation fault in autovacuum

2009-09-23 Thread Tom Lane
"Nic" writes: > I try to create test db and fill it by our objects. When this filling is > working, postgres crashes with logs: > LOG: server process (PID 11699) was terminated by signal 11: Segmentation > fault Can you extract a reproducible test case for this? > Also i have coredump (100 mb)

Re: [BUGS] BUG #5075: Text Search parser does not identify xml tag when attribute name's contains underscore

2009-09-23 Thread Euler Taveira de Oliveira
Marek Lewczuk escreveu: > Please execute following example: > select * from ts_debug('english', ' align="right" style="margin: 0px 0px 5px 5px;" test_aa="26461"/>') > > As the result you will see, that is not identified as XML tag, but > rather splitted as words, blank spaces etc. The reason for

[BUGS] BUG #5076: LEFT OUTER JOIN and WHERE madness

2009-09-23 Thread Mauro Infantino
The following bug has been logged online: Bug reference: 5076 Logged by: Mauro Infantino Email address: mauro.infant...@latincontrol-soft.com PostgreSQL version: 8.3.8 Operating system: Windows Description:LEFT OUTER JOIN and WHERE madness Details: I'm just experien

[BUGS] BUG #5077: Corrupted Table

2009-09-23 Thread Bryan McLemore
The following bug has been logged online: Bug reference: 5077 Logged by: Bryan McLemore Email address: kael...@gmail.com PostgreSQL version: 8.4.0 Operating system: Ubuntu 64 bit Description:Corrupted Table Details: Today a table corrupted and I started getting: "i

Re: [BUGS] Encounter shared memory error when running createlang command!

2009-09-23 Thread Robert Haas
2009/9/23 Yaming Gu > > > Hi, List > > Because I need to use pl/perl language, then I decided to run “createlang” > to create PL/Perl language. I have checked all dependencies and all is ok. > > Next I run: D:\Program Files\Postgresql\bin>createlang �CU postgres plperl > example (example is my

Re: [BUGS] BUG #5077: Corrupted Table

2009-09-23 Thread Andrew Gierth
> "Bryan" == "Bryan McLemore" writes: Bryan> "invalid page header in block 900 of relation pg_tblspc/32041/138911/187737" Bryan> http://pgsql.privatepaste.com/83JfmQGtS5 Privatepaste urls do expire, so for the record here is the relevant part of the data in question: 82 00 00

Re: [BUGS] BUG #5077: Corrupted Table

2009-09-23 Thread Kaelten
I do have said copies and would be glad to help in whatever ways I am able too. Bryan McLemore Kaelten On Wed, Sep 23, 2009 at 9:38 PM, Andrew Gierth wrote: >> "Bryan" == "Bryan McLemore" writes: > >  Bryan> "invalid page header in block 900 of relation > pg_tblspc/32041/138911/187737" >

[BUGS] Encounter shared memory error when running createlang command!

2009-09-23 Thread Yaming Gu
Hi, List, Because my previous mail contains some Chinese character, now I modified it, the whole problem is described as below: I need to create language Pl/Perl. I have checked all dependencies of plperl.dll and all is ok. Next: D:\Program Files\Postgresql\bin>createlang -U postgres -e

Re: [BUGS] Encounter shared memory error when running createlang command!

2009-09-23 Thread John R Pierce
Yaming Gu wrote: Hi, List, Because my previous mail contains some Chinese character, now I modified it, the whole problem is described as below: I need to create language Pl/Perl. I have checked all dependencies of plperl.dll and all is ok. have you installed perl? I believe the p

[BUGS] Postgresql 8.4.1 segfault, backtrace

2009-09-23 Thread Richard Neill
Dear All, I've just upgraded from 8.4.0 to 8.4.1 because of a segfault in 8.4, and we've found that this is still happening repeatedly in 8.4.1. We're in a bit of a bind, as this is a production system, and we get segfaults every few hours. [It's a testament to how good the postgres crash r

[BUGS] 答复: [BUGS] Encounter shared memory err or when running createlang command!

2009-09-23 Thread Yaming Gu
Thank you for your reminding. Before running createlang script, ActivePerl 5.8.9 has been installed because of the dependency of plperl.dll on perl58.dll. -邮件原件- 发件人: John R Pierce [mailto:pie...@hogranch.com] 发送时间: 2009年9月24日 12:48 收件人: Yaming Gu 抄送: pgsql-bugs@postgresql.org 主题: Re: [B