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

Deleting large objects from database.

From: Czarny Marcin <Marcin(dot)Czarny(at)plock(dot)petrochemia(dot)pl>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Deleting large objects from database.
Date: 1999-12-14 11:53:48
Message-ID: DA70131D22E4D211B02C006097483734025010@TIEX1 (view raw or flat)
Thread:
Lists: pgsql-sql
I have column with large objects in table named my_table.
After SQL command:
   delete from my_table;
they are still files xinv* and xinx* in directory ./data/base/my_db.
Have I delete this files from operating system?
What is wrong? I hope thats is only my ignorance?

Best regards,
 Marcin Czarny


Responses

pgsql-sql by date

Next:From: Lendvary GyorgyDate: 1999-12-14 14:11:02
Subject: SQLDA or UPDATE WHERE CURRENT OF
Previous:From: Stoyan GenovDate: 1999-12-14 10:49:58
Subject: SQL'92 web resources

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