Hi,
I am using DBLink contrib module.
I cannot catch the dblink_exec error messages.
On the other hand, the pgadmin gui shows the error message under
"DETAIL" section:
The test function :
CREATE OR REPLACE FUNCTION test_func1()
RETURNS integer AS
$$
DECLARE
stmt text;
conn
Hi,
I am trying to get server parameters (pg_settings) using a cursor and
insert them to one column table.
A stored procedure parameter holds the long string.
The insert of this parameter does not fail.
The problem is that the string (the parameter value) is not inserted to
the tabl
Hi,
I need to drop database.
"drop database" does not always work, since user connections to the
database still exist
(I get : ERROR: database "yuval" is being accessed by other users , SQL
state: 55006)
How can I force the drop ? or is there a way to kill database
connection and then to
Hi,
I am trying to use postgres odbc driver on windows Japanese machine, to
test connection to a remote postgres database. The database has latin1
encoding.
Connection tests to databases with latin1 encoding fail with this error
message:
fatal: conversion between SJIS and LATIN1 is n
Hi
I need to get PGDATA location when I logged in as non-postgres user.
I cannot see data_directory from pg_setting table as non-postgres user.
Any work around? Any other way to retrieve that information?
If not, what is the quickest way to enable non-postgres user to have
PGDATA l
Hi
I need to extract table DDL (create script) from database connection
(using sql, by retrieving system table info or by activating some pg
function)
Is this possible in postgres?
Please help
Thanks
Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
[EMAI
Hello,
postgres version: 8.2.0.4
platform windows: server 2008
I check connections using:
SELECT pg_stat_get_backend_idset()
Now, I take the output and try to get the ip addresses using
select pg_stat_get_backend_client_addr();
but for a local connection (simple login us
Hi,
I have compiled 8.3.7 on HP-Itanium
After the build I have continued to the tests (gmake check)
One of the tests failed (division by zero error test)
The regression.diffs file shows the diff regarding of the expected result and
the actual result:
*** ./expected/errors.out Sat Nov 10 1
Hi,
Postgres server crashed on windows vista.
From the log:
2010-04-07 07:00:35.694 LOG: could not receive data from client: Unknown
winsock error 10061
2010-04-07 07:00:35.694 LOG: could not receive data from client: Unknown
winsock error 10061
2010-04-07 07:00:35.694 LOG: unexpected EOF o
Hi
Postgres crashes with -
PG "FATAL: could not reattach to shared memory (key=5432001, addr=0210):
Invalid argument.
The version is 8.2.4, the platform is win32
Does someone know the reason/workaround ?
Thanks,
Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
yuv
Hi,
-We are using Postgres 8.3.7 on Windows
-We cannot start the Postgres service. The windows OS error message is:
"The PostgreSQL Server 8.3 service on Local Computer started then stopped.
Some services stop automatically if they have no work to do, for example,
the Performance Logs and Alerts
Hi,
I am using Postgres DB with stand by database, configured with streaming in
synchronized mode (each commit on primary DB waits for commit on secondary DB).
Sometimes we suffer from network issues and as consequences, secondary machine
is not available.
In these situations, our applic
12 matches
Mail list logo