[Mapserver-users] RE: [postgis-users] RE: gone are my queryresults
Paul Ramsey
pramsey at refractions.net
Mon May 3 14:14:03 PDT 2004
Charlton Purvis wrote:
> Let's hear it for the Canadians!!! Talk about premature graying.
> That was an unpleasant couple of days, but it was solved by binding
> the UNIQUE to a home-grown column, and now everything is golden.
No problem Charlton. You are one of the few PostGIS users to have a busy
enough database to wrap the oids over the signed integer maximum. Note
that this is not a number-of-records limitation, but a number of events
limitation, as the oid increments with inserts, updates, all sorts of
things. Using a real unique key is preferred anyways -- more visibility
and control. Also the PgSQL developers threaten to deprecate oid with
each release.
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
\_
More information about the postgis-users
mailing list