| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | DaVinci <bombadil(at)wanadoo(dot)es> |
| Cc: | Lista PostgreSql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: OID and joins |
| Date: | 2000-10-18 16:18:07 |
| Message-ID: | Pine.LNX.4.21.0010181815580.3228-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
DaVinci writes:
> Can I use OIDs for joins between tables without losing functionality?
Sure.
> The problems I am afraid of are:
>
> - pg_dump/psql: Can I recover OIDs from security copies?.
pg_dump -o
> - Indexes: joins between tables linked with OIDs use indexes from
> OIDs?, should I have to make that indexes or they are automatic?.
You have to make one.
> - Any other limitation I don't achieve to view?.
Nope, this is really a relatively standard thing. The oid column isn't
special as compared to other columns, aside from the fact that it is
automatically created.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jack V Chung | 2000-10-18 16:48:55 | A couple of pgsql questions |
| Previous Message | Peter Eisentraut | 2000-10-18 16:14:36 | Re: too many clients? |