Hello!
I want to disable autocommit, my psqlrc:
SET client_min_messages = 'WARNING';
SET add_missing_from = false;
\set AUTOCOMMIT off
it has no effect:
echo show AUTOCOMMIT | psql
SET
SET
autocommit
on
(1 row)
How can I disable autocommit in psqlrc?
Thanks,
Axel.
On Sat, Mar 18, 2006 at 11:55:35PM -0700, Alex bahdushka wrote:
Hi.
Upon rebooting one of our main production database servers, we were
greeted with this:
To help you at all, we *really* need to know what version and platform
you're running. In particular, are you running the most recent
Axel Straschil writes:
I want to disable autocommit, my psqlrc:
SET client_min_messages = 'WARNING';
SET add_missing_from = false;
\set AUTOCOMMIT off
it has no effect:
echo show AUTOCOMMIT | psql
SET
SET
autocommit
on
(1 row)
How can I disable autocommit in
Hallo!
It is. You're just looking at the no-op GUC variable instead of the
psql one. Try
\echo :AUTOCOMMIT
instead.
Oh, your right, just tested, it is ;-)
Thanks,
AXEL.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On 3/19/06, Martijn van Oosterhout kleptog@svana.org wrote:
On Sat, Mar 18, 2006 at 11:55:35PM -0700, Alex bahdushka wrote:
Hi.
Upon rebooting one of our main production database servers, we were
greeted with this:
To help you at all, we *really* need to know what version and platform
On 3/19/06, Alex bahdushka [EMAIL PROTECTED] wrote:
On 3/19/06, Martijn van Oosterhout kleptog@svana.org wrote:
On Sat, Mar 18, 2006 at 11:55:35PM -0700, Alex bahdushka wrote:
Hi.
Upon rebooting one of our main production database servers, we were
greeted with this:
To help you
Hi, I'm trying to implement my own access method. Now I've implemented
and compiled it but I've problems when I try to use it.
I got folowing AM function definitions:
CREATE OR REPLACE FUNCTION atomrtgettuple (INTERNAL ,INT4) RETURNS BOOL
AS
Alain BAUDHUIN wrote:
I'm surprised, though not to find any pg_dump switch to produce a
v7.x compatible dump. Did I look at the wrong place ? Does anybody
know about the right way to dump a database in a cross-version
compatible form ?
Downgrades are generally not supported. You may be able
Can anybody assist
with this problem I have a table that has some duplicated rows of data, I
want to place aunique constraint on the columns userid and procno to
eliminate this problem in the future but how do I identify and get rid of the
existing duplication.
Thanks in
advance
Regards
I'm appealing for help from this list as the ODBC list has
few people andno answers.
I have built a database in Postgresql version 8.0. I want
to connect it to Delphi version 4.
I have attempted to connect using the Postgresql ODBC with
no success.
Is what I am attempting to do possible
[EMAIL PROTECTED] writes:
Hi, I'm trying to implement my own access method. Now I've implemented
and compiled it but I've problems when I try to use it.
Wild guess: did you mark all your functions as V1 call convention?
The internal functions don't need to be marked, but dynamically loaded
ones
David Inglis wrote:
Can anybody assist with this problem I have a table that has some
duplicated rows of data, I want to place a unique constraint on the
columns userid and procno to eliminate this problem in the future but
how do I identify and get rid of the existing duplication.
To find
As for deleting all but one row in a duplicated group, you're going tohave to get at them by the oid or ctid columns perhaps.
The other idea is to run CREATE TABLE newtable AS SELECT DISTINCT * FROMoldtable;.
I believe getting oid and/or ctid is not possible since it would not display/get
Peter Eisentraut wrote:
David Inglis wrote:
Can anybody assist with this problem I have a table that has some
duplicated rows of data, I want to place a unique constraint on the
columns userid and procno to eliminate this problem in the future but
how do I identify and get rid of the
Rushabh Doshi wrote:
I'm facing an issue with PostgreSQL .. The server seems to drop the
connection to my script after a couple of hours (sometimes, not always).
DBD::Pg::db selectrow_array failed: could not receive data from server:
:server closed the connection unexpectedly.
Do
Bob Pawley wrote:
I'm appealing for help from this list as the ODBC list has few people
and no answers.
I have built a database in Postgresql version 8.0. I want to connect it
to Delphi version 4.
I have attempted to connect using the Postgresql ODBC with no success.
Is what I am
Where can i download the postgresql-7.4-3 release for ppc64 ?. What
postgresql release is compatible for this kind of arquitecture ?.
If you don't receive an immediate response, you don't need to repost
your question.
You'll need to download it and compile it yourself:
On 3/19/06, Hrishikesh Deshmukh [EMAIL PROTECTED] wrote:
Can somebody please tell me where i can find rpms for postgesql on OpenSuse
10.0?
opensuse10 comes with PostgreSQL 8.0.1, installable once you configure
the installation sources correctly. (See
18 matches
Mail list logo