Re: [BUGS] BUG #8288: 9.3.0Beta2 - Windows Installer bug #7738 still open

2013-07-10 Thread Dave Page
On Tue, Jul 9, 2013 at 1:44 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 8288 > Logged by: Thomas Gauss > Email address: tga...@wolfsysteme.de > PostgreSQL version: Unsupported/Unknown > Operating system: Windows 7 64bit > Description: > >

Re: [BUGS] BUG #8290: broken/unexpected locking behavior

2013-07-10 Thread Alvaro Herrera
pg noob escribió: > Alvaro, > > Is there a PostgreSQL bug number that I could refer to for this problem? #8290 ? -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.

Re: [BUGS] BUG #8290: broken/unexpected locking behavior

2013-07-10 Thread pg noob
Alvaro, Is there a PostgreSQL bug number that I could refer to for this problem? Thank you. On Tue, Jul 9, 2013 at 4:53 PM, Alvaro Herrera wrote: > Jamey Poirier escribió: > > > > Thank you Alvaro. Yes, this explains it. > > It doesn't help to fix it but at least I know now that it's a known

[BUGS] BUG #8292: Error en Una Función llamada desde NetBeans

2013-07-10 Thread renzo_gch
The following bug has been logged on the website: Bug reference: 8292 Logged by: Renzo Carranza Email address: renzo_...@hotmail.com PostgreSQL version: 9.2.3 Operating system: Windows Description: Este es mi error "malformed function or procedure escape syntax at off

[BUGS] BUG #8293: There are no methods to convert json scalar text to text in v9.3 beta2

2013-07-10 Thread jaroslav . potapov
The following bug has been logged on the website: Bug reference: 8293 Logged by: Yaroslav Potapov Email address: jaroslav.pota...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: All Description: SELECT '"a\"b"'::json::text returns text: '"a\"b"'

[BUGS] Unable to handle error in plperl

2013-07-10 Thread Alex Lai
Dear all, I have a situation. I am unable to pass control back to the function once it hit the "undefined_column" error code. I am not sure there's a way to return '123' instead exit from the function. Here is my code CREATE OR REPLACE FUNCTION foo() RETURNS text as $$ my $sql = ""; my $

Re: [BUGS] BUG #8291: postgres_fdw does not re-read USER MAPING after change.

2013-07-10 Thread Bernd Helmle
--On 9. Juli 2013 22:05:20 + lal...@fhcrc.org wrote: I have found that if you change the password in the USER MAPPING, that postgres_fdw will not use it unless the current password fails or you close and re-open your postgres connection. I found this while testing to see if the USER MAPPIN

Re: [BUGS] BUG #8291: postgres_fdw does not re-read USER MAPING after change.

2013-07-10 Thread Albin, Lloyd P
I realized that postgres_fdw is caching the connection, but when you have existing items that use the same USER MAPPING and do not cache it such as dblink you get inconsistency in implementation and this should be avoided. Lloyd -Original Message- From: Bernd Helmle [mailto:maili...@oop