RE: rserv - Mailing list pgsql-general

From Mikheev, Vadim
Subject RE: rserv
Date
Msg-id 3705826352029646A3E91C53F7189E320165E3@sectorbase2.sectorbase.com
Whole thread Raw
In response to rserv  (Alvaro Herrera <alvherre@atentus.com>)
Responses RE: rserv  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-general
> I'm currently creating a new field of type bigint, where I store a
> combination of the primary key, that I can assure will be unique --
> until I get lots of entries in the main tables, that is.
>
> What is the "right" approach for this?

"Right" way would be implement support for multi-column keys in Rserv,
so even for tables without natural PK one could add OID to some existent
key to get uniq identifier for all rows in tables. No one had that
ability so far.
You can use OID as key for Rserv. Unfortunately, you probably will have
to create index on table.oid for better replication performance, but
most likely that index will be useful for replication only, not for
queries.

Vadim

pgsql-general by date:

Previous
From: Viacheslav N Tararin
Date:
Subject: Pl/PgSQL improvements
Next
From: Fran Fabrizio
Date:
Subject: Re: select off of a view going slowly