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
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
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 on the
same
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.
.
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 instructions on
http
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 PostgreSQL can retrieve
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
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
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
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.msm which
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 mean to write the following
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:\WINDOWS\WinSxS
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,FIRMEN.Firma2,FIRMEN.Firma3,FIRMEN.Such
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), '')
The
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
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
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 - From: Hermann Muster
17 matches
Mail list logo