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
--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
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 $
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"'
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
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
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.
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:
>
>