| From: | Peter Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Nelson Ferreira Jr <nelson(at)radix(dot)com(dot)br> |
| Cc: | Alejandro Alberola Arias <alberola(at)bio(dot)es>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: OIDs and JDBC |
| Date: | 2000-10-09 11:39:33 |
| Message-ID: | Pine.LNX.4.21.0010091236520.772-100000@maidast.demon.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 6 Oct 2000, Nelson Ferreira Jr wrote:
> You have to remove the LOs manually and after this delete the
> row that contains the OID...
> By the way, How can I remove the orphans LOs of a database ? Is
> there a vaccum command that works for LOs ?
No, as it would be database/application specific.
Ie: a large object is only called an orphan because it's not actually
refered to by anything in the database (other than in the system
tables). You can still use it if you know it's oid, which you can get by a
simple query on the system tables.
Peter
--
Peter T Mount peter(at)retep(dot)org(dot)uk http://www.retep.org.uk
PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
Java PDF Generator http://www.retep.org.uk/pdf/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Mount | 2000-10-09 11:41:38 | Re: image storing |
| Previous Message | Peter Mount | 2000-10-09 11:36:28 | Re: OID use |