[GENERAL] Replicator

2005-09-18 Thread ShepherdHill DB Subscriptions
Hi, Does anyone know of any open source PostgreSQL replicator that can replicate data from Fedora Core4 to Windows Server? Can Slony do that? Thanks for your advice. Best regards. Chris. ---(end of broadcast)--- TIP 1: if posting/reading through

[GENERAL] How to modify a tuple returned by SPI_copytuple?

2005-09-18 Thread Mario Weilguni
I checked the documentation, and still do not get it. I can use SPI_copytuple to return a modified version of a tuple, but how do I modify a structure of type HeapTuple. In my case, I just want to modify a INT32 column for sorting. Any ideas? Regards, Mario Weilguni -

Re: [GENERAL] BIG installations of PostgresQL?

2005-09-18 Thread hubert depesz lubaczewski
On 9/16/05, Logan Bowers <[EMAIL PROTECTED]> wrote: I'm looking for examples of large installations of Postgres with huge data sets, high traffic volumes, high update rates, etc, particularly large, recognizable names. can you tell us/me what do you mean by huge? i heard people sayin

Re: [GENERAL] ltree and ordering - what index?

2005-09-18 Thread hubert depesz lubaczewski
On 9/18/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote: ltree is part of contrib, right? yes.  You probably need to define a functional index of some kind. How are youquerying now? IIRC you'll be doing something like region IN (ltree)? i didn't thought about functional indices, but this might be a so

[GENERAL] help me pls

2005-09-18 Thread suresh ramasamy
thanks for the info Devrim, by the way i'm newbie, i have followed the steps in the documentation for compiling and installation.  I'm using FC4.  ./cofigure completes immediately but the gmake running for nearly the whole day.  so decide to terminate. (my system configuration is p-III, 733 with

Re: [GENERAL] Implementing a change log

2005-09-18 Thread Michael Schuerig
On Monday 19 September 2005 01:29, Mike Rylander wrote: > On 9/18/05, Michael Schuerig <[EMAIL PROTECTED]> wrote: > > In my current project I have a customer requirement for > > implementing a change log. This is not just for auditing purposes, > > rather it is meant to be accessible by users so th

Re: [GENERAL] Implementing a change log

2005-09-18 Thread Mike Rylander
On 9/18/05, Michael Schuerig <[EMAIL PROTECTED]> wrote: > > In my current project I have a customer requirement for implementing a > change log. This is not just for auditing purposes, rather it is meant > to be accessible by users so they can get an overview of the change > history of an object.

[GENERAL] Implementing a change log

2005-09-18 Thread Michael Schuerig
In my current project I have a customer requirement for implementing a change log. This is not just for auditing purposes, rather it is meant to be accessible by users so they can get an overview of the change history of an object. The entire data set is not big, I'm expecting considerably les

Re: [GENERAL] Query Cost

2005-09-18 Thread Jim C. Nasby
On Sun, Sep 18, 2005 at 07:40:26PM +0100, ShepherdHill DB Subscriptions wrote: > Hi, > > I have a table with this schema: > > CREATE TABLE billing.bill > ( > sno serial NOT NULL, > billno int4, > det date NOT NULL, > . > . > . > CONSTRAINT bill_pkey PRIMARY KEY (sno) > ) > > I want to

[GENERAL] 8.1 beta2 RPMs

2005-09-18 Thread Devrim GUNDUZ
Hi, PostgreSQL RPM Building Project (http://pgfoundry.org/projects/pgsqlrpms) has built RPMs for Red Hat Enterprise Linux 3.0 and 4. More will come later tomorrow: http://developer.postgresql.org/~devrim/rpms/8.1/beta2/ We hope these RPMs will help more people to test this new great release

Re: [GENERAL] Asychronous database replication

2005-09-18 Thread Scott Ribe
> But I find a surprisingly high fraction of applications are very amenable to > being handled as insert-only. A medical application strikes me as something > someone is all the more likely to be happy with an insert-only model. Yes, I work in the medical field, and use my own home-grown (predates

[GENERAL] Query Cost

2005-09-18 Thread ShepherdHill DB Subscriptions
Hi, I have a table with this schema: CREATE TABLE billing.bill ( sno serial NOT NULL, billno int4, det date NOT NULL, . . . CONSTRAINT bill_pkey PRIMARY KEY (sno) ) I want to execute a query that will not return any record. Which of these queries is cheaper please? 1. Select * from

Re: [GENERAL] ltree and ordering - what index?

2005-09-18 Thread Jim C. Nasby
ltree is part of contrib, right? You probably need to define a functional index of some kind. How are you querying now? IIRC you'll be doing something like region IN (ltree)? On Sat, Sep 17, 2005 at 01:31:21PM +0200, hubert depesz lubaczewski wrote: > hi > i have a table with more or less this st

Re: [GENERAL] BIG installations of PostgresQL?

2005-09-18 Thread Jim C. Nasby
Take a look at http://www.postgresql.org/about/casestudies/ for some examples of use. Looking through the pgsql-advocacy mailing list might provide some more cases as well. Of the top of my head, I believe there's at least one national banking system running on PostgreSQL, as well as all of the .or

Re: [GENERAL] How to check is the table system

2005-09-18 Thread Jim C. Nasby
On Thu, Sep 15, 2005 at 09:12:44PM +0300, wrote: > Hello! > >In what way can I determine is the table system? ODBC driver does it > by checking table name's prefix: if it begins with 'pg_' - driver > desides that the table is system, but that's a bad idea. I can create > table

Re: [GENERAL] Asychronous database replication

2005-09-18 Thread Neil Dugan
On Friday 16 September 2005 07:28 am, John DeSoi wrote: > On Sep 15, 2005, at 9:54 PM, Greg Stark wrote: > > If you need data to propagate from the clients back to the server > > then things > > get more complicated. Even then you could side step a lot of > > headaches if you > > can structure the