[GENERAL] Feature request dblink: Security issue - dblink user+password parameters must be optional

When creating a view via DBLINK, the user=... and password=... parameters shall be optional. If they are left out, then the current user accessing the view shall be impersonated implicitely to the "dblinked" database as well. Forcing anybody to hardcode a password readable within the view defin

[GENERAL] dblink can't query a password with a space

I'm using the following dblink query to connect to another database on the server. Query itself works fine, however I have the problem that if the password contains a space character like in "hello world", then dblink can't connect to that database. Is there any possibility to get that working

Re: [GENERAL] Connection to second database on server

Bill Moran wrote: In response to Hermann Muster <[EMAIL PROTECTED]>: Hello everyone, I already asked about that a couple of days ago, but didn't get an satisfying solution for my problem which is following: I need to create a view that does a query on a second database o

[GENERAL] Connection to second database on server

Hello everyone, I already asked about that a couple of days ago, but didn't get an satisfying solution for my problem which is following: I need to create a view that does a query on a second database on the same PostgreSQL server. dblink seems to be the only (???) solution for doing so. The

[GENERAL] Re: Accessing other databases with DBLink when leaving user/password empty

Tommy Gildseth wrote: Hermann Muster wrote: Hi Adrian, I tried what you suggested, but still get the following Error: "Error connecting to the server: fe_sendauth: no password supplied" What is it I'm doing wrong? Isn't it possible to leave the password empty so that Pos

[GENERAL] Re: Accessing other databases with DBLink when leaving user/password empty

account? Thank you. Adrian Klaver wrote: On Friday 06 June 2008 2:32 am, Hermann Muster wrote: Does no one have any idea about that? Regards. Hermann Muster wrote: Hi, I have the following problem when trying to access other PostgreSQL databases with DBLink. I followed the

[GENERAL] Re: Accessing other databases with DBLink when leaving user/password empty

Does no one have any idea about that? Regards. Hermann Muster wrote: Hi, I have the following problem when trying to access other PostgreSQL databases with DBLink. I followed the instructions on http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other

[GENERAL] Accessing other databases with DBLink when leaving user/password empty

Hi, I have the following problem when trying to access other PostgreSQL databases with DBLink. I followed the instructions on http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html. My query to get access to another da

[GENERAL] dbi_link and dbi:ODBC

I have the following problem getting to connect a remote database (MS SQL Server in my case) to PostgreSQL. I'm using SQL Server 2005 Express Edition. I tried it with the following: SELECT dbi_link.make_accessor_functions( 'dbi:ODBC:DRIVER=SQL Native Client;Server=192.168.10.175;Database=Test;

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Dave Page schrieb: On Feb 18, 2008 10:05 AM, Hermann Muster <[EMAIL PROTECTED]> wrote: Hi Dave, after testing several combinations I can tell you following, because maybe I couldn't make clear what my problem is. The msvcr80.dll is correctly installed in the C:\WIN

Re: [GENERAL] Order of SUBSTR and UPPER in statement

Michael Fuhr schrieb: On Thu, Feb 14, 2008 at 04:48:33PM +0100, Hermann Muster wrote: Michael Fuhr schrieb: COALESCE(UPPER(SUBSTR("X"."Firma",1,7)) = I haven't examined the entire query but the above line appears to be the problem. Did you me

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Dave Page schrieb: On Feb 13, 2008 3:05 PM, Hermann Muster <[EMAIL PROTECTED]> wrote: Dave Page schrieb: On Feb 5, 2008 7:52 AM, Hermann Muster <[EMAIL PROTECTED]> wrote: I also checked the folder C:\Program Files\Common Files\Merge Modules Microsoft_VC80_CRT_x86.

Re: [GENERAL] Order of SUBSTR and UPPER in statement

Michael Fuhr schrieb: [Please copy the mailing list on replies so others can contribute to and learn from the discussion.] On Thu, Feb 14, 2008 at 09:56:36AM +0100, Hermann Muster wrote: The statement I'm using is the following: SELECT "FIRMEN"."Firma","FIR

[GENERAL] Order of SUBSTR and UPPER in statement

Hi, I encountered something I can't really explain. I use the following statement in my application: COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'') This returns "ERROR: syntax error at end of input" However, using the following statement is fine: COALESCE(SUBSTR(UPPER("X"."Firma"), 1, 7), ''

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Dave Page schrieb: On Feb 4, 2008 6:37 PM, Hiroshi Saito <[EMAIL PROTECTED]> wrote: Hi. MSVCR80.dll which the binary of 8.3 refers to is this. C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\MSVCR80.dll I tried again in the beautiful environment which does

Re: [GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

of Installer may be necessity. It must consider many situations. However, The solution method was not found even in MSDNIt seems that what is used in the middle of install can't be execute. to Dave. Did you already find the solution method? Regards, Hiroshi Saito - Original Message ---

[GENERAL] msvcr80.dll and PostgreSQL 8.3 under Windows XP

Hi, I installed today's release setup of PostgreSQL 8.3. Unfortunately Libpq.dll has a dependancy to msvcr80.dll, which can't be found on my system. I checked the msi installer file and found that this dll will not be installed under Windows XP. Does anyone has any suggestions concerning t