About oids
От | Philip Bierhoff |
---|---|
Тема | About oids |
Дата | |
Msg-id | 199805231222.OAA01363@svstud.win.tue.nl обсуждение исходный текст |
Ответы |
Re: [GENERAL] About oids
|
Список | pgsql-general |
Hello, I can't find any documentation on this in manuals and FAQ. I store some files in a database, which I access through JDBC from a Java application. Now I want to delete some of these entries. Issuing DELETE FROM files does only remove the oids from the table, but the file still remains on my disk (I checked the data/base/ dir and the "xinv" and "xinx" files are still there.). I did some research and found out that the function lo_unlink removes the files. However, the parameter of lo_unlink is an int4, and not an oid. There is no function to convert oid to int4. So, can someone tell me how I should implement a (non working) query like this: SELECT lo_unlink(f) FROM files WHERE title = 'test.txt' Thanks in advance Philip
В списке pgsql-general по дате отправления: