| From: | Roomi <roomi(at)RASANEH(dot)safineh(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | dbi-users(at)isc(dot)org |
| Subject: | permanent deleting |
| Date: | 1999-11-16 07:26:43 |
| Message-ID: | Pine.LNX.4.10.9911161047360.3763-100000@RASANEH.safineh.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
suppose there is a DataBase named "mydb" and a table of it "log" ,
when i list dir "/var/lib/pgsql/base/mydb/", the size of "log" is
"45678901" . then i run this query "DELETE from log where ..... ;" and get
message "1000 rows deleted successfully".
then i see the size of log WITHOUT any changes "45678901" !!!
i think that postgresql DELETE command don't delete rows permanently.
so let me know how to DELETE some things from a TABLE permanently. and
increase my DAtaBase's size.
thanks alot.
M.Roomi
roomi(at)safineh(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jose soares | 1999-11-16 13:37:05 | Re: [SQL] NULL |
| Previous Message | D'Arcy J.M. Cain | 1999-11-16 03:19:13 | Re: [SQL] how can tell if a column is a primary key? |