Skip site navigation (1) Skip section navigation (2)

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

From: David Wetzel <dave(at)turbocat(dot)de>
To: Helmar Spangenberg <hspangenberg(at)frey(dot)de>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Port Bug Report: Problem concerns copy command with bigoids
Date: 1999-03-14 20:35:00
Message-ID: 199903142035.VAA00237@cat.turbocat.de (view raw or flat)
Thread:
Lists: pgsql-ports
> Date: Sun, 14 Mar 1999 13:58:01 -0500 (EST)
> From: Unprivileged user <nobody(at)hub(dot)org>
> To: pgsql-ports(at)postgreSQL(dot)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(at)turbocat(dot)de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION
           WATCH OUT FOR TURBOFAX for OPENSTEP!

In response to

pgsql-ports by date

Next:From: Unprivileged userDate: 1999-03-15 19:34:11
Subject: Port Bug Report: The compiler bombs at pgc.l and fails to finish compiling
Previous:From: Unprivileged userDate: 1999-03-14 18:58:01
Subject: Port Bug Report: Problem concerns copy command with big oids

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group