Re: [PORTS] Port Bug Report: Problem concerns copy command with big oids

Поиск
Список
Период
Сортировка
От David Wetzel
Тема Re: [PORTS] Port Bug Report: Problem concerns copy command with big oids
Дата
Msg-id 199903142035.VAA00237@cat.turbocat.de
обсуждение исходный текст
Ответ на Port Bug Report: Problem concerns copy command with big oids  (Unprivileged user <nobody>)
Список pgsql-ports
> Date: Sun, 14 Mar 1999 13:58:01 -0500 (EST)
> From: Unprivileged user <nobody@hub.org>
> To: pgsql-ports@postgreSQL.org

> Not a fix, but maybe a hint:
> It seems to me that the internal representation of the oids
> is not consistent (long int - unsigned long int). I
> realized that the oid of ONE dataset sometimes was printed
> as a negative number and in other cases as a positive
> number (when big enough).

I guess that psql does not "recycle" oid numbers when you delete 1 oid and
create a oid (BLOB) again.

Another problem is that PSQL should delete the oid file when you delete the
row that references it.

---
   _  _
 _(_)(_)_  David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
  _/  \_   Fax +49 33056 82835 NeXTmail dave@turbocat.de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION
           WATCH OUT FOR TURBOFAX for OPENSTEP!

В списке pgsql-ports по дате отправления:

Предыдущее
От: Unprivileged user
Дата:
Сообщение: Port Bug Report: Problem concerns copy command with big oids
Следующее
От: Unprivileged user
Дата:
Сообщение: Port Bug Report: The compiler bombs at pgc.l and fails to finish compiling