Re: [BUGS] BUG #5230: Limit operator slows down

2009-12-03 Thread Robert Haas
On Thu, Dec 3, 2009 at 10:45 AM, aftab khan akha...@hotmail.co.uk wrote: This is not exactly the same what I posted yesterday, What I have posted today also include EXPLAIN ANALYZE OUTPUT . [ adding the list back to the CC line ] It looks like you have a problem very similar to one Laurence

Re: [BUGS] BUG #5233: delete wrong doing with subquery where condition

2009-12-03 Thread Robert Haas
On Thu, Dec 3, 2009 at 8:21 PM, Fred Wei w...@niwa.co.nz wrote: The following bug has been logged online: Bug reference:      5233 Logged by:          Fred Wei Email address:      w...@niwa.co.nz PostgreSQL version: 8.1.11 Operating system:   SUSE Linux Enterprise Server 10 SP2 (x86_64)

Re: [BUGS] BUG #5217: (new) error with VB 6.0 SP 6 and psqlODBC 8.4.1

2009-12-03 Thread Robert Haas
On Fri, Nov 27, 2009 at 8:09 AM, Martin searepo...@aol.at wrote: The following bug has been logged online: Bug reference:      5217 Logged by:          Martin Email address:      searepo...@aol.at PostgreSQL version: 8.4.1 Operating system:   M$ Vista (but does not matter) same on XP, ...

Re: [BUGS] BUG #5226: Limit operator slows down

2009-12-02 Thread Robert Haas
On Wed, Dec 2, 2009 at 11:42 AM, Craig Ringer cr...@postnewspapers.com.au wrote: On 2/12/2009 10:35 PM, aftab wrote: The following bug has been logged online: Bug reference:      5226 Logged by:          aftab Email address:      akha...@hotmail.co.uk PostgreSQL version: 8.3.8 Operating

Re: [BUGS] BUG #5215: Error in PgAdmin

2009-12-02 Thread Robert Haas
On Thu, Nov 26, 2009 at 5:41 AM, Walter Willmertinger will...@gmail.com wrote: The following bug has been logged online: Bug reference:      5215 Logged by:          Walter Willmertinger Email address:      will...@gmail.com PostgreSQL version: 8.4.1 Operating system:   Windows XP Prof.

Re: [BUGS] BUG #5218: Easy strategic feature requests

2009-11-30 Thread Robert Haas
On Sat, Nov 28, 2009 at 5:34 PM, Russell Wallace russell.wall...@gmail.com wrote: The following bug has been logged online: Bug reference:      5218 Logged by:          Russell Wallace Email address:      russell.wall...@gmail.com PostgreSQL version: 8.4.1 Operating system:   Windows

Re: [BUGS] BUG #5218: Easy strategic feature requests

2009-11-30 Thread Robert Haas
On Mon, Nov 30, 2009 at 12:28 PM, Pavel Stehule pavel.steh...@gmail.com wrote: Rather than trying to be compatible with MySQL directly, I think we might be better off adding a chapter to our documentation explaining to ex-MySQL users how to accomplish the same things in PostgreSQL.  We might

Re: [BUGS] BUG #5218: Easy strategic feature requests

2009-11-30 Thread Robert Haas
On Mon, Nov 30, 2009 at 1:42 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 2009/11/30 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: I thing so ex-MySQL needs exact DESCRIBE, exact SHOW statement. It is some, what they used long time and then they missing it.

Re: [BUGS] psql -1 -f - busted

2009-11-27 Thread Robert Haas
On Fri, Nov 27, 2009 at 1:42 AM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2009-11-26 at 22:59 -0500, Robert Haas wrote: ISTM that if you run psql with -f -, you shouldn't expect to get an interactive shell.  Rather, you should expect psql to do whatever it normally does when given -f

Re: [BUGS] BUG #5207: unable to start postgresql server services

2009-11-27 Thread Robert Haas
On Fri, Nov 27, 2009 at 3:42 AM, Denny Saviant Mohammad konohabluefl...@gmail.com wrote: Well, i changed nothing in my postgresql.conf before the accident. Well, someone or something did, because stdmsg isn't ever a legal value, and it didn't put itself into that file. . But, after i try

Re: [BUGS] psql -1 -f - busted

2009-11-26 Thread Robert Haas
On Thu, Oct 22, 2009 at 2:42 PM, Stephen Frost sfr...@snowman.net wrote:  -1 appears to be ignored when '-f -' is set. I've been bitten by this, too. It appears that -f - is in general equivalent to not specifying -f at all. In startup.c we have a test for: options.action == ACT_FILE

Re: [BUGS] BUG #5207: unable to start postgresql server services

2009-11-25 Thread Robert Haas
On Sat, Nov 21, 2009 at 9:13 AM, denny saviant konohabluefl...@gmail.com wrote: The following bug has been logged online: Bug reference:      5207 Logged by:          denny saviant Email address:      konohabluefl...@gmail.com PostgreSQL version: 8.4.1 Operating system:   windows xp pro

Re: [BUGS] BUG #5211: invalid password

2009-11-25 Thread Robert Haas
On Tue, Nov 24, 2009 at 6:04 AM, lee brown lee_bro...@msn.com wrote: The following bug has been logged online: Bug reference:      5211 Logged by:          lee brown Email address:      lee_bro...@msn.com PostgreSQL version: 8.3 Operating system:   vista Description:        invalid

Re: [BUGS] BUG #5210: error in intidb process when installing on japanese

2009-11-25 Thread Robert Haas
On Mon, Nov 23, 2009 at 4:21 AM, Maithili maithili.manur...@gmail.com wrote: The following bug has been logged online: Bug reference:      5210 Logged by:          Maithili Email address:      maithili.manur...@gmail.com PostgreSQL version: 8.2 Operating system:   Windows 2003

Re: [BUGS] BUG #5206: wal_sync_method in stock postgresql.conf may be wrong

2009-11-23 Thread Robert Haas
On Fri, Nov 20, 2009 at 6:56 PM, Alvaro Herrera alvhe...@postgresql.org wrote: The following bug has been logged online: Bug reference:      5206 Logged by:          Alvaro Herrera Email address:      alvhe...@postgresql.org PostgreSQL version: any Operating system:   any Description:    

Re: [BUGS] BUG #5203: Rule affecting more than one row is only fired once, when there is no reference to the row.

2009-11-22 Thread Robert Haas
On Fri, Nov 20, 2009 at 10:11 AM, Marcel Wieland marcel.wiel...@fondsnet.de wrote: The following bug has been logged online: Bug reference:      5203 Logged by:          Marcel Wieland Email address:      marcel.wiel...@fondsnet.de PostgreSQL version: 8.2 Operating system:   Linux

Re: [BUGS] BUG #5202: Rule affecting more than one row is only fired once with LIMIT 1

2009-11-22 Thread Robert Haas
On Fri, Nov 20, 2009 at 9:58 AM, Marcel Wieland marcel.wiel...@fondsnet.de wrote: The following bug has been logged online: Bug reference:      5202 Logged by:          Marcel Wieland Email address:      marcel.wiel...@fondsnet.de PostgreSQL version: 8.2 Operating system:   Linux

Re: [BUGS] BUG #5205: Cannot ADD CONSTRAINT ... FOREIGN KEY...

2009-11-22 Thread Robert Haas
On Fri, Nov 20, 2009 at 6:44 PM, Alain Baeckeroot alain.baecker...@laposte.net wrote: The following bug has been logged online: Bug reference:      5205 Logged by:          Alain Baeckeroot Email address:      alain.baecker...@laposte.net PostgreSQL version: 8.4.1 Operating system:   Linux

Re: [BUGS] BUG #5197: JDBC: selecting oid results in Exception

2009-11-20 Thread Robert Haas
On Wed, Nov 18, 2009 at 11:26 PM, Joseph Shraibman j...@selectacast.net wrote: The following bug has been logged online: Bug reference:      5197 Logged by:          Joseph Shraibman Email address:      ...@selectacast.net PostgreSQL version: 8.2.14 Operating system:   Linux Description:  

Re: [BUGS] BUG #5175: Unable to configure psqlodbc-08.04.0100

2009-11-18 Thread Robert Haas
On Mon, Nov 9, 2009 at 7:21 PM, Vijaya Krishna Cherukuri krisveejay...@gmail.com wrote: The following bug has been logged online: Bug reference:      5175 Logged by:          Vijaya Krishna Cherukuri Email address:      krisveejay...@gmail.com PostgreSQL version: 8.3.8 Operating system:  

[BUGS] pgsql-jdbc/pgsql-odbc

2009-11-18 Thread Robert Haas
I see that there's been no response to bugs #5194, #5187, #5051. Should we consider adding a message to the bug reporting page that suggests emailing the relevant list directly for JDBC/ODBC bugs? We seem to get a lot of those here. The other frequent one that seems to come up is the one-click

Re: [BUGS] BUG #5191: now() returns same value from Perl.

2009-11-16 Thread Robert Haas
On Mon, Nov 16, 2009 at 12:59 PM, Clark Pearson cloink_frigg...@ntlworld.com wrote: The following bug has been logged online: Bug reference:      5191 Logged by:          Clark Pearson Email address:      cloink_frigg...@ntlworld.com PostgreSQL version: 8.3.7 Operating system:   Windows

Re: [BUGS] BUG #5184: default tablespace owner is not dumped

2009-11-13 Thread Robert Haas
On Fri, Nov 13, 2009 at 1:13 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: The following command does not change the output of pg_dumpall: alter tablespace pg_default owner to bob; I don't think this is a bug.  It's one specific aspect of a general

Re: [BUGS] BUG #5184: default tablespace owner is not dumped

2009-11-13 Thread Robert Haas
On Fri, Nov 13, 2009 at 10:39 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: I think it would be over the top to suggest that pg_dump has to cope with modifications that can only occur through manual updates

Re: [BUGS] BUG #5186: Not install daemon

2009-11-13 Thread Robert Haas
On Fri, Nov 13, 2009 at 8:52 PM, obelich obel...@gmail.com wrote: The following bug has been logged online: Bug reference:      5186 Logged by:          obelich Email address:      obel...@gmail.com PostgreSQL version: 8.4.1 Operating system:   Opensuse 11.2 Description:        Not

[BUGS] BUG #5184: default tablespace owner is not dumped

2009-11-12 Thread Robert Haas
The following bug has been logged online: Bug reference: 5184 Logged by: Robert Haas Email address: robertmh...@gmail.com PostgreSQL version: CVS HEAD Operating system: Linux Description:default tablespace owner is not dumped Details: The following command does

Re: [BUGS] BUG #5128: Returning nested composite types in plpython

2009-11-09 Thread Robert Haas
On Tue, Oct 20, 2009 at 12:19 PM, landrevi...@deadtreepages.com wrote: The following bug has been logged online: Bug reference:      5128 Logged by: Email address:      landrevi...@deadtreepages.com PostgreSQL version: 8.4 Operating system:   FreeBSD Description:        Returning nested

Re: [BUGS] BUG #5171: Composite type with array does not translate in plpythonu

2009-11-08 Thread Robert Haas
On Sat, Nov 7, 2009 at 5:23 AM, Peter Eisentraut pete...@gmx.net wrote: On fre, 2009-11-06 at 17:29 +, Jason wrote: When I have a plpythonu function returning a composite type that has an array column, the function does not work when I try to return a list for that column. There is a

Re: [BUGS] BUG #5165: Poor performance with Left-join where right side does not exist

2009-11-04 Thread Robert Haas
On Wed, Nov 4, 2009 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: assaf assaf_l...@yahoo.com writes: PostgreSQL version: 8.37 Description:        Poor performance with Left-join where right side does not exist 8.4 might be smarter about this case for you.  It's hard to tell for sure with

Re: [BUGS] BUG #5147: DBA can not access view

2009-11-02 Thread Robert Haas
2009/11/2 donniehan donnie...@126.com: Hi Tom, I agree with Hxli. It may be a good way to add permissions check when create the view. I also find 2 pieces of words in the document about the owner of the object. By default, only the owner of an object can do anything with the object.

Re: [BUGS] BUG #5140: initdb crashes

2009-10-31 Thread Robert Haas
On Tue, Oct 27, 2009 at 10:47 AM, Marcus Lundblad marcus.lundb...@mogul.com wrote: The following bug has been logged online: Bug reference:      5140 Logged by:          Marcus Lundblad Email address:      marcus.lundb...@mogul.com PostgreSQL version: 8.3.8 Operating system:   Solaris 10

Re: [BUGS] BUG #5149: Can't untar the src code file

2009-10-30 Thread Robert Haas
On Thu, Oct 29, 2009 at 6:14 PM, Don Fox donf...@mac.com wrote: The following bug has been logged online: Bug reference:      5149 Logged by:          Don Fox Email address:      donf...@mac.com PostgreSQL version: 8.4.1 Operating system:   Mac X Snowleopard Description:        Can't

Re: [BUGS] BUG #5150: math bug

2009-10-30 Thread Robert Haas
On Fri, Oct 30, 2009 at 1:39 AM, Gray g...@ms-irk.ru wrote: The following bug has been logged online: Bug reference:      5150 Logged by:          Gray Email address:      g...@ms-irk.ru PostgreSQL version: 8.2.6 Operating system:   i686-pc-linux-gnu Description:        math bug Details:

Re: [BUGS] BUG #5131: The pgsql will lost

2009-10-22 Thread Robert Haas
On Wed, Oct 21, 2009 at 11:23 PM, aihongwei ufo008...@163.com wrote: The following bug has been logged online: Bug reference:      5131 Logged by:          aihongwei Email address:      ufo008...@163.com PostgreSQL version: 8.0.0 Operating system:   linux x86_64 Description:        The

Re: [BUGS] BUG #5130: Failed to run initdb:1

2009-10-22 Thread Robert Haas
On Wed, Oct 21, 2009 at 12:51 PM, flamindrag...@gmail.com wrote: The following bug has been logged online: Bug reference:      5130 Logged by: Email address:      flamindrag...@gmail.com PostgreSQL version: any Operating system:   Win XP Pro SP2 Description:        Failed to run initdb:1

Re: [BUGS] BUG #5132: Invalid Function

2009-10-22 Thread Robert Haas
On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap geokhua8...@yahoo.com.sg wrote: The following bug has been logged online: Bug reference:      5132 Logged by:          Geok Hua Yap Email address:      geokhua8...@yahoo.com.sg PostgreSQL version: 8.3.1 Operating system:   CentOS 5.2

[BUGS] Re: 答复: 答复: [BUGS] Encounter shared memory e rror when running createlang command!

2009-10-22 Thread Robert Haas
2009/9/29 Yaming Gu yaming...@w-oasis.com: Hi, Robert,  According to your recommendations, I tried to load plperu, almost the same error messages have shown: D:\Program Files\Postgresql\8.3\bincreatelang -U postgres plperlu example Password: createlang: language installation failed:

Re: [BUGS] BUG #5039: 'i' flag i in regexp_replace ignored for polish letters

2009-10-22 Thread Robert Haas
On Sat, Sep 5, 2009 at 5:42 AM, Kamil Roman kamil.lech.ro...@gmail.com wrote: The following bug has been logged online: Bug reference:      5039 Logged by:          Kamil Roman Email address:      kamil.lech.ro...@gmail.com PostgreSQL version: 8.3.7 Operating system:   Windows XP

Re: [BUGS] BUG #5130: Failed to run initdb:1

2009-10-22 Thread Robert Haas
On Thu, Oct 22, 2009 at 10:47 AM, flamin dragon flamindrag...@gmail.com wrote: 2009/10/22 Robert Haas robertmh...@gmail.com On Wed, Oct 21, 2009 at 12:51 PM,  flamindrag...@gmail.com wrote: The following bug has been logged online: Bug reference:      5130 Logged by: Email address

Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2009-10-22 Thread Robert Haas
On Fri, Aug 28, 2009 at 9:59 AM, Dan O'Hara danarasoftw...@gmail.com wrote: The following bug has been logged online: Bug reference:      5021 Logged by:          Dan O'Hara Email address:      danarasoftw...@gmail.com PostgreSQL version: 8.3.7 Operating system:   win32 Description:      

Re: [BUGS] BUG #5124: visualizacion de registros

2009-10-17 Thread Robert Haas
2009/10/16 malu maluulam_l...@yahoo.com.mx: The following bug has been logged online: Bug reference:      5124 Logged by:          malu Email address:      maluulam_l...@yahoo.com.mx PostgreSQL version: 8.3 Operating system:   windows xp proffeional Description:        visualizacion de

Re: [BUGS] BUG #5114: database initialization

2009-10-17 Thread Robert Haas
On Wed, Oct 14, 2009 at 9:56 AM, flamindrag...@gmail.com wrote: The following bug has been logged online: Bug reference:      5114 Logged by: Email address:      flamindrag...@gmail.com PostgreSQL version: any Operating system:   Win XP Pro SP2 Description:        database initialization

Re: [BUGS] BUG #5098: Levenshtein with costs is broken

2009-10-17 Thread Robert Haas
On Tue, Oct 6, 2009 at 9:38 PM, Matthew Byrne matt...@hairybrain.co.uk wrote: The following bug has been logged online: Bug reference:      5098 Logged by:          Matthew Byrne Email address:      matt...@hairybrain.co.uk PostgreSQL version: 8.4.1 Operating system:   Linux x86_64 (Ubuntu

Re: [BUGS] vacuumdb error

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 6:39 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Thom Brown wrote: This is either a bug in vacuumdb with it not using the correct order, or postgres shouldn't be paying attention to the order of the keywords.  In any case, it doesn't work.  I've

Re: [BUGS] BUG #5118: start-status-insert-fatal

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 10:33 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Pedro Gimeno pgsql-...@personal.formauri.es wrote: Tom Lane wrote: This could be addressed by having the postmaster report its $PGDATA value in the pg_ping response, but I would be against that on security

Re: [BUGS] BUG #5118: start-status-insert-fatal

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 11:08 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: Well, then Tom's idea of using a random number seems pretty solid no matter how you slice it.  Maybe a UUID. A random number is looking like the best option.  I'm

Re: [BUGS] BUG #5118: start-status-insert-fatal

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 2:04 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: UUIDs throw away 6 bits? http://en.wikipedia.org/wiki/Universally_Unique_Identifier#Version_4_.28random.29 How about that. You learn something new every day

Re: [BUGS] BUG #5083: Problem create account.

2009-10-03 Thread Robert Haas
On Sun, Sep 27, 2009 at 5:29 PM, Jesper sol...@hotmail.com wrote: The following bug has been logged online: Bug reference:      5083 Logged by:          Jesper Email address:      sol...@hotmail.com PostgreSQL version: 8,3 Operating system:   Vista Description:        Problem create

Re: [BUGS] BUG #5090: erro

2009-10-02 Thread Robert Haas
On Wed, Sep 30, 2009 at 7:11 AM, Edinei edi...@guaporepecuaria.com.br wrote: The following bug has been logged online: Bug reference:      5090 Logged by:          Edinei Email address:      edi...@guaporepecuaria.com.br PostgreSQL version: 8.4 Operating system:   Windows XP Description:  

Re: [BUGS] BUG #5089: not supported plpsql

2009-10-02 Thread Robert Haas
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex defa...@smart-soft.ru wrote: The following bug has been logged online: Bug reference:      5089 Logged by:          Yamashkin Alex Email address:      defa...@smart-soft.ru PostgreSQL version: 8.4.0.1 Operating system:   windows XP Embeded

[SPAM?]Re: [BUGS] BUG #5089: not supported plpsql

2009-10-02 Thread Robert Haas
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex defa...@smart-soft.ru wrote: The following bug has been logged online: Bug reference:      5089 Logged by:          Yamashkin Alex Email address:      defa...@smart-soft.ru PostgreSQL version: 8.4.0.1 Operating system:   windows XP Embeded

Re: [BUGS] BUG #5088: community account not working

2009-09-30 Thread Robert Haas
On Tue, Sep 29, 2009 at 11:15 PM, Ian Small i...@omniconnect.com.au wrote: The following bug has been logged online: Bug reference:      5088 Logged by:          Ian Small Email address:      i...@omniconnect.com.au PostgreSQL version: any Operating system:   any Description:        

Re: Re[BUGS] g: 25P02, current transaction is aborted, commands ignored until end of transaction block

2009-09-30 Thread Robert Haas
On Wed, Sep 30, 2009 at 5:23 AM, ajay labade ajaylab...@gmail.com wrote:     I am trying to port my application from Oracle to PostGREs. I have a problem while doing so. In my application i need to update record if the delete on the respective record is failed due to Constraint Violation. But

Re: [BUGS] BUG #5081: ON INSERT rule does not work correctly

2009-09-28 Thread Robert Haas
On Mon, Sep 28, 2009 at 10:12 AM, Jacques Caron j...@oxado.com wrote: Hi, You can use a trigger before insert and a pl/pgsql function that goes: BEGIN  UPDATE table SET ... WHERE pk=NEW.pk  IF FOUND THEN  RETURN NULL;  ELSE  RETURN NEW;  END IF; END; Jacques. That seems about right.

[BUGS] Re: 答复: [BUGS] Encounter shared memory error whe n running createlang command!

2009-09-28 Thread Robert Haas
On Mon, Sep 28, 2009 at 2:51 AM, Yaming Gu yaming...@w-oasis.com wrote: Thank you so much for your kind reply. Your analysis sounds very reasonable. I checked my Perl version, it is Perl 5.8.9 Build 826 which is the latest version in the series of 5.8.*. The whole process of installation of

Re: [BUGS] BUG #5081: ON INSERT rule does not work correctly

2009-09-27 Thread Robert Haas
On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: Stefan s...@drbott.de writes: The problem is that if it is no record in the table, it seems that first the INSERT command is issued and after that the UPDATE command is issued, too. Well, yeah.  That's exactly how it's

Re: [BUGS] BUG #5081: ON INSERT rule does not work correctly

2009-09-27 Thread Robert Haas
On Sun, Sep 27, 2009 at 11:36 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: Well, yeah.  That's exactly how it's documented to work: an ON INSERT rule is executed after the INSERT proper

Re: [BUGS] BUG #5082: I can't get logfile( achive )

2009-09-27 Thread Robert Haas
On Fri, Sep 25, 2009 at 11:50 AM, smuffy vday1...@gmail.com wrote: The following bug has been logged online: Bug reference:      5082 Logged by:          smuffy Email address:      vday1...@gmail.com PostgreSQL version: 8.4.0 Operating system:   opensuse 10.2 Description:        I can't

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

2009-09-27 Thread Robert Haas
On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu yaming...@w-oasis.com wrote: 2009-09-24 10:50:55 HKT LOG:  loaded library $libdir/plugins/plugin_debugger.dll 2009-09-24 10:50:59 HKT LOG:  loaded library $libdir/plugins/plugin_debugger.dll Substitution pattern not terminated at line 1. I'm very

Re: [BUGS] BUG #5071: abbrev() bug with IPv6

2009-09-27 Thread Robert Haas
On Tue, Sep 22, 2009 at 12:54 AM, alexander.o...@koeln.de wrote: The following bug has been logged online: Bug reference:      5071 Logged by: Email address:      alexander.o...@koeln.de PostgreSQL version: 8.3.7 Operating system:   Debian Lenny 64Bit Description:        abbrev() bug

Re: [BUGS] Databse installation problem

2009-09-27 Thread Robert Haas
On Mon, Sep 21, 2009 at 1:53 AM, Bhushan Verma verma.bhus...@gmail.com wrote: I have tried to install postgres version 8.3.7 as follows rm -rf /var/lib/pgsql mkdir /var/lib/pgsql ./configure --prefix /var/lib/pgsql gmake su gmake install adduser postgres mkdir /var/lib/pgsql/data chown

Re: [BUGS] PROBLEMA AL INSTALAR POSTSGRESQL

2009-09-27 Thread Robert Haas
2009/9/17 Paola R. griffindor_2...@hotmail.com buenas tardes  estoy tratando de instalar postgresql 8.2 pero en la parte initialise databasecluster cuando ingreso un el password al dar next  me sale el siguiente mensaje: the secondary logon service is not running. this service is

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

2009-09-27 Thread Robert Haas
On Wed, Sep 23, 2009 at 7:31 PM, Euler Taveira de Oliveira eu...@timbira.com wrote: Marek Lewczuk escreveu: Please execute following example: select * from ts_debug('english', 'img width=182 height=120 align=right style=margin: 0px 0px 5px 5px; test_aa=26461/') As the result you will see,

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

2009-09-23 Thread Robert Haas
2009/9/23 Yaming Gu yaming...@w-oasis.com 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\bincreatelang �CU postgres plperl example

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-22 Thread Robert Haas
On Mon, Sep 21, 2009 at 7:30 PM, Tom Lane t...@sss.pgh.pa.us wrote: David Fetter da...@fetter.org writes: On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote: With connection poolers, backends can last quite awhile.  Is it OK for the END block to run hours after the rest of the

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-22 Thread Robert Haas
On Tue, Sep 22, 2009 at 10:13 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: If the changes are simple, as Tim seems to believe, exactly what do we lose by doing this? It's not simple.  There are any number of issues that Tim has not addressed.  The most

Re: [BUGS] Problem installing Postgres 8.4.1

2009-09-22 Thread Robert Haas
On Mon, Sep 21, 2009 at 3:23 PM, Christine Penner christ...@ingenioussoftware.com wrote: At 11:57 AM 21/09/2009, you wrote: What error you get when you run initdb?? (Also what exact command you run?) The first time I just double clicked on the file initdb.exe. Just now I tried to run it

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 12:06 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: David Fetter escribió: Taken literally, that would mean, the last action before the backend exits, but at least to me, that sounds troubling for the same reasons that end of transaction triggers do.  What

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 12:31 PM, Bruce Momjian br...@momjian.us wrote: Sam Mason wrote: On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote: Sam Mason s...@samason.me.uk wrote: the deeper problem seems to be that the table was created as:   create table test (a tstdom);

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 2:17 PM, David Fetter da...@fetter.org wrote: On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote: David Fetter escribió: On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote: David Fetter escribió: Taken literally, that would mean, the

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 3:08 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: David Fetter escribió: On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote: The fine manual saith     You may have multiple END blocks within a file--they will     execute in reverse order of

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-19 Thread Robert Haas
On Sat, Sep 19, 2009 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: Tim Bunce tim.bu...@pobox.com writes: The plperl implementation doesn't call perl_destruct() during server shutdown. Who cares?  The process is going away anyway. END {} blocks can execute arbitrary code. Perl users will

Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL

2009-09-18 Thread Robert Haas
On Fri, Sep 18, 2009 at 5:45 AM, Annita annita.ven...@qs-unisolution.com wrote: The following bug has been logged online: Bug reference:      5063 Logged by:          Annita Email address:      annita.ven...@qs-unisolution.com PostgreSQL version: 8 Operating system:   Windows Description:

Re: [BUGS] Wrong default values of columns

2009-09-17 Thread Robert Haas
On Thu, Sep 17, 2009 at 8:15 AM, Andre Rothe pho...@gmx.de wrote: Hi, I have installed Postgres 8.3.8 on Fedora Linux. If I create a table, the default values will be set by the database to NULL::timestamp without time zone for a timezone column and to NULL::character varying for a

Re: [BUGS] Wrong default values of columns

2009-09-17 Thread Robert Haas
On Thu, Sep 17, 2009 at 10:44 AM, Andre Rothe pho...@gmx.de wrote: The problem is, that I get the default values from a metadata query with JDBC, so I have to parse every return value for such an annotation before I can use them. That sounds annoying, but it's not a PostgreSQL bug. So it

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

2009-09-16 Thread Robert Haas
On Tue, Sep 15, 2009 at 11:35 PM, Kenaniah Cerny kenan...@gmail.com wrote: The following bug has been logged online: Bug reference:      5059 Logged by:          Kenaniah Cerny Email address:      kenan...@gmail.com PostgreSQL version: 8.4.1 Operating system:   Centos5.2 Description:      

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

2009-09-16 Thread Robert Haas
On Wed, Sep 16, 2009 at 6:39 PM, Kenaniah Cerny kenan...@gmail.com wrote: I can provide the output of statistics queries if you would like. Just let me know which statistics you want and I'll pastebin them. As far as selectivity goes, the selectivity estimate for the

Re: [BUGS] error: message type 0x5a arrived from server while idle

2009-09-15 Thread Robert Haas
On Tue, Sep 8, 2009 at 11:38 PM, vyou zhi vyou...@gmail.com wrote: hi all: i use Python and PyGreSQL to link  PostgreSQL but the Python give me the error the error here : ... 95 93 95 97 94 96 94 message type 0x43 arrived from server

Re: [BUGS] GIN needs tonic

2009-09-15 Thread Robert Haas
On Tue, Sep 15, 2009 at 4:41 PM, Simon Riggs si...@2ndquadrant.com wrote: I guess if you or another committer spends some time writing a test framework that is useful and that you can trust, I'm sure many people will add to it. That'll be true for any of the major/complex areas not covered by

Re: [BUGS] BUG #5058: [jdbc] Silent failure with executeUpdate()

2009-09-15 Thread Robert Haas
On Tue, Sep 15, 2009 at 3:26 PM, Joseph Shraibman j...@selectacast.net wrote: The following bug has been logged online: Bug reference:      5058 Logged by:          Joseph Shraibman Email address:      ...@selectacast.net PostgreSQL version: 8.2.14 Operating system:   Linux Description:  

Re: [BUGS] BUG #5042: Update numeric within a rule

2009-09-15 Thread Robert Haas
On Sun, Sep 6, 2009 at 4:48 PM, Ilian Georgiev georgiev.il...@gmail.com wrote: The following bug has been logged online: Bug reference:      5042 Logged by:          Ilian Georgiev Email address:      georgiev.il...@gmail.com PostgreSQL version: 8.1.10 Operating system:   Windows XP

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-14 Thread Robert Haas
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane t...@sss.pgh.pa.us wrote: Andrew Gierth and...@tao11.riddles.org.uk writes: Domain NOT NULL constraints (and probably other constraints too) aren't being enforced in some code paths. e.g. The example you give seems to tie really closely into the

Re: [BUGS] BUG #5046: java developer

2009-09-14 Thread Robert Haas
On Wed, Sep 9, 2009 at 5:42 AM, mahmoud badr alien_...@yahoo.com wrote: The following bug has been logged online: Bug reference:      5046 Logged by:          mahmoud badr Email address:      alien_...@yahoo.com PostgreSQL version: 8.4 Operating system:   windows Description:        java

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-14 Thread Robert Haas
On Mon, Sep 14, 2009 at 10:22 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: It seems like regardless of this discussion you oughtn't to be able to store a NULL into that table column.  But maybe I'm just confused. The system is relying

Re: [BUGS] BUG #5047: Not able to connect from Informatica

2009-09-14 Thread Robert Haas
On Thu, Sep 10, 2009 at 7:17 AM, Rohan jamadagni rohan.jamada...@tcs.com wrote: The following bug has been logged online: Bug reference:      5047 Logged by:          Rohan jamadagni Email address:      rohan.jamada...@tcs.com PostgreSQL version: 8.3.7 Operating system:   Linux Rhel 5.0

Re: [BUGS] BUG #5056: SQLDescribeColW for function returning a result set incorrectly setting sql_nullable

2009-09-14 Thread Robert Haas
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells the6campbe...@gmail.com wrote: The following bug has been logged online: Bug reference:      5056 Logged by:          the6campbells Email address:      the6campbe...@gmail.com PostgreSQL version: 8.4.1 Operating system:   windows

Re: [BUGS] need higher extra_float_digits value (3)

2009-09-09 Thread Robert Haas
On Wed, Sep 9, 2009 at 6:04 PM, Tom Lanet...@sss.pgh.pa.us wrote: Keh-Cheng Chu kehch...@solar2.stanford.edu writes: While 17 decimal digits are sufficient to guarantee the complete recovery of all 64-bit double values, some 32-bit reals actually require NINE significant figures. Hm,

Re: [BUGS] BUG #5034: plperlu problem with gethostbyname

2009-09-06 Thread Robert Haas
On Sep 5, 2009, at 6:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Sep 3, 2009 at 5:21 PM, Diego de Limadiego_de_l...@hotmail.com wrote: Using Fedora 10 default rpm packages, all updated last month via yum. I can't reproduce this on a clean

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type is char

2009-09-04 Thread Robert Haas
On Fri, Sep 4, 2009 at 11:15 AM, Tom Lanet...@sss.pgh.pa.us wrote: I certainly don't want to have char emulate the misbegotten decision to have explicit and implicit coercions behave differently.  So it looks to me like the argument to make char work like char(1) doesn't actually help us much

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type is char

2009-09-04 Thread Robert Haas
On Fri, Sep 4, 2009 at 11:59 AM, Kevin Grittnerkevin.gritt...@wicourts.gov wrote: Tom Lane t...@sss.pgh.pa.us wrote: I certainly don't want to have char emulate the misbegotten decision to have explicit and implicit coercions behave differently. So it looks to me like the argument to make

Re: [BUGS] BUG #5034: plperlu problem with gethostbyname

2009-09-04 Thread Robert Haas
On Thu, Sep 3, 2009 at 5:21 PM, Diego de Limadiego_de_l...@hotmail.com wrote: The following bug has been logged online: Bug reference:      5034 Logged by:          Diego de Lima Email address:      diego_de_l...@hotmail.com PostgreSQL version: 8.3.7 Operating system:   Linux Fedora 10

Re: [BUGS] BUG #5010: perl iconv function returns ? character

2009-09-04 Thread Robert Haas
On Tue, Aug 25, 2009 at 8:15 AM, Lampalamp...@gmail.com wrote: The following bug has been logged online: Bug reference:      5010 Logged by:          Lampa Email address:      lamp...@gmail.com PostgreSQL version: 8.4.0 Operating system:   Debian testing/unstable Description:        perl

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Robert Haas
On Sep 2, 2009, at 11:27 PM, Pavel Stehule pavel.steh...@gmail.com wrote: Hello it's not bug - PostgreSQL doesn't support parameter placeholder on this position. Use dynamic query instead - plpgsql statement EXECUTE. It may not be a bug exactly, but it sure isn't a feature. ...Robert --

Re: [BUGS] BUG #5027: SQL query error?

2009-09-02 Thread Robert Haas
On Tue, Sep 1, 2009 at 9:51 AM, Dmitrymas...@hsdesign.ru wrote: The following bug has been logged online: Bug reference:      5027 Logged by:          Dmitry Email address:      mas...@hsdesign.ru PostgreSQL version: 8.3.5 Operating system:   ALT Linux Description:        SQL query error?

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type ischar

2009-09-02 Thread Robert Haas
On Wed, Sep 2, 2009 at 11:55 AM, Sam Masons...@samason.me.uk wrote: In fact it doesn't seem to want to play ball at all.  Even given the apparently unambiguous:  SELECT 1+add(1,2); or  SELECT 'hi'||add(1,2); It doesn't get anywhere.  No need for text 'hi' in the second one because ||

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type ischar

2009-09-02 Thread Robert Haas
On Wed, Sep 2, 2009 at 3:34 PM, Sam Masons...@samason.me.uk wrote: On Wed, Sep 02, 2009 at 12:54:03PM -0500, Kevin Grittner wrote: Sam Mason s...@samason.me.uk wrote: If we did follow Kevin's request directly, should we also be specifying the type of NULL? I don't *think* the SQL standard

Re: [BUGS] BUG #5013: Error in psqlodbc configuration

2009-08-28 Thread Robert Haas
On Wed, Aug 26, 2009 at 5:55 AM, Isharaishara...@gmail.com wrote: The following bug has been logged online: Bug reference:      5013 Logged by:          Ishara Email address:      ishara...@gmail.com PostgreSQL version: 8.4 Operating system:   Solaris x86 Description:        Error in

Re: [BUGS] BUG #5003: setup error

2009-08-28 Thread Robert Haas
On Fri, Aug 21, 2009 at 9:35 AM, Pramodpramodchoudhar...@yahoo.com wrote: The following bug has been logged online: Bug reference:      5003 Logged by:          Pramod Email address:      pramodchoudhar...@yahoo.com PostgreSQL version: 8.4.0-1 Operating system:   Windows XP Description:  

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Robert Haas
On Thu, Aug 27, 2009 at 12:49 PM, Eduardoedua...@vip10.com.br wrote: The following bug has been logged online: Bug reference:      5019 Logged by:          Eduardo Email address:      edua...@vip10.com.br PostgreSQL version: 8.3 Operating system:   Vista 64 bits Description:        Nao

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Robert Haas
2009/8/27 Alvaro Herrera alvhe...@commandprompt.com: Robert Haas escribió: Para obtener ayuda en espan~ol, tal vez puede Ud. tratar pgsql-es-ay...@postgresql.org.  Creo que no tenemos una list de correo en Portugue's. It lives in another list server: https://listas.postgresql.org.br/cgi

<    2   3   4   5   6   7   8   >