From: Richard Huxton <dev@archonet.com>
To: gayathri jayapal <jgayathrisen@yahoo.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] clarififcation
Date: Thu, 15 Feb 2007 17:49:46 +0000
Message-ID: <45D49D3A.9090808@archonet.com> (raw)
In-Reply-To: <133614.25377.qm@web35815.mail.mud.yahoo.com>
References: <133614.25377.qm@web35815.mail.mud.yahoo.com>
gayathri jayapal wrote:
> Hai,
>
> I started working on postgresql, I want to know how to write the "
> connect by" clause of oracle. My problem is i have a table with id,
> parent id. In same table i will insert the record with parent id as
> previous row id. I want fetch the records in the hierarchy. how do i
> do it.
If you installed from source, look in .../contrib/tablefunc/ for an
installable connectby() function. If you installed by package, there is
usually one or more additional packages containing the contrib stuff.
> Pls help me. I want to get in touch with developers and then i need
> to try multi master replication also.
There are no pre-packaged multi-master replication solutions at the
moment. The first thing you'll have to do in building such a solution is
decide on how you want to deal with conflicting updates.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dev@archonet.com, jgayathrisen@yahoo.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] clarififcation
In-Reply-To: <45D49D3A.9090808@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox