pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <45D49D3A.9090808@archonet.com>
Permalink:  ../45D49D3A.9090808@archonet.com/
Also on:    postgresql.org/message-id/45D49D3A.9090808@archonet.com

 · 

reply

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