Re: [ADMIN] Recursive use

2006-10-04 Thread Adam Radlowski
I think it is not administration thing, but SQL language problem. PostgreSQL is SQL92 compatible and has many very good and useful addons. Generally, PostgreSQL gives You tools to analyze all, what You want, when You hava data in tables. You've explained in to short way You problem. The best is

[ADMIN] Unsubscribe

2006-10-04 Thread K Prakash
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.

Re: [ADMIN] postgres in HA constellation

2006-10-04 Thread Sebastian Reitenbach
Hi, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Wed, Oct 04, 2006 at 11:23:45 -, > Sebastian Reitenbach <[EMAIL PROTECTED]> wrote: > > > > something I thought that might work: > > is there sth. that will repair an inconsisten postgresql datastore? e.g. the > > master database died, t

[ADMIN] non-standard 'CREATE INDEX' problem

2006-10-04 Thread n0g0013
got a vendor application that's pretty much designed for MSSQL but it's using 'CREATE INDEX ... [ ASC | DESC ]' syntax. it appears that the ODBC driver is rejecting that as invalid. testing on the database reveals the same. and reference to the docs indicate it's not postgresql syntax. is there

Re: [ADMIN] postgres in HA constellation

2006-10-04 Thread Brad Nicholson
On Wed, 2006-10-04 at 10:43 -0500, Bruno Wolff III wrote: > On Wed, Oct 04, 2006 at 11:23:45 -, > Sebastian Reitenbach <[EMAIL PROTECTED]> wrote: > If you have multiple data centers to protect against disaster, then you might > look at SLONY which you can use to replicate to a slave system.

Re: [ADMIN] Recursive use

2006-10-04 Thread Bruno Wolff III
On Wed, Oct 04, 2006 at 10:08:10 -0300, Alexander Burbello <[EMAIL PROTECTED]> wrote: > > I need to know if Postgres do recursive search and how can I do! There is a contrib module (tablefunc I think) that allows recursive queries. However in your example below, you don't actuall need recursion

Re: [ADMIN] postgres in HA constellation

2006-10-04 Thread Bruno Wolff III
On Wed, Oct 04, 2006 at 11:23:45 -, Sebastian Reitenbach <[EMAIL PROTECTED]> wrote: > > something I thought that might work: > is there sth. that will repair an inconsisten postgresql datastore? e.g. the > master database died, the slave will mount the storage, then repair it in a > reason

[ADMIN] Recursive use

2006-10-04 Thread Alexander Burbello
Hi people, I need to know if Postgres do recursive search and how can I do! I will explain my problem. table COOPERATIVE code_cooperative int code_coo_father int I can have 3 level by business rules 1 - Father - 2 - Children - 3 - Grandchildren I would like to have a query ask

[ADMIN] postgres in HA constellation

2006-10-04 Thread Sebastian Reitenbach
Hi all, I want to use postgres, combined with postgis, in a high available configuration to store spatial data. I will have tens of millions, or even more, of datasets in the database. so the database will be fairly large and consume a lot of disk space. Therefore I thought to have a shared sto

[ADMIN] Navicat PostgreSQL Manager for Mac OS X (ver. 6.3.1) is now available

2006-10-04 Thread navicat
Navicat PostgreSQL GUI 6.3.1 supports HTTP Tunneling and contains bug fixes for Import/Export feature.This PostgreSQL Client tool features an intuitive interface and provides a set of useful tool to manage, backup/ restore, import/ export data, Synchronize database and connect to remote MySQL serv

Re: [ADMIN] Unsubscribe

2006-10-04 Thread lst_hoe01
Zitat von Srinivas Lakshmi Sistla <[EMAIL PROTECTED]>: [ADMIN] Unsubscribe me List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe:

[ADMIN] Unsubscribe

2006-10-04 Thread Srinivas Lakshmi Sistla
[ADMIN] Unsubscribe me Regards, Srinivas Sistla Managed Computing Services Computer Sciences Corporation India Private Limited, Ph: 91 -40 39824100 Extn 4329 India        - +91 -40  39824100   Extn 4329 US           - +1     302 781 1020   Extn 4329 UK   -          +44  08706000180     Extn 4329