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
http://en.opensuse.org/Mirrors_Released_V
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:
http://www.postgresql
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 attemptin
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 y
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 exist
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 duplicat
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 fi
[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
one
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 attempting to do possibl
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.
Thanks in
advance
Re
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 ab
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
'E:\\pgsource\\postgresql-8.0.7\\contrib\\atom
On 3/19/06, Alex bahdushka <[EMAIL PROTECTED]> wrote:
> On 3/19/06, Martijn van Oosterhout 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 y
On 3/19/06, Martijn van Oosterhout 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
> you're
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 FA
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 a
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
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.
18 matches
Mail list logo
