From: | jan(at)evation(dot)com (Jan Branbergen) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | BLOB question + MS Access ODBC issue |
Date: | 2002-01-14 20:48:18 |
Message-ID: | 40a154ce.0201141248.25edb6a7@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
i have ported a lot of my applications to PostgreSQL in the last
months.
in the proces of porting the data, i have created a lot of BLOBs, and
in the next import run, i truncated the table which was referencing
the BLOB ( so i did not do a pg_lounlink for the object ).
this has happened numerous times, so i a worried about the following:
have the BLOBs become "zombie"-BLOBs ( that is: are they still
residing in my database ), or are they deleted with a VACUUM for
example? i could not find this is in the manual.
--
for something completely different: i have been tweaking the
odbc-driver for postgres to better support MS Access ( let's not
discuss why i need this, i need this ). for VB, DAO users: i
experienced that:
"
rs.AddNew
rs.("Name") = "balbalklflkjsdlkfs"
rs.Update
rs.Bookmark = rs.Lastmodified
debug.print rs("id") // autonumber, serial
"
was not working: i could not retrieve the assigned serial/autonumber.
i have implemented a dirty fix for this. i do not consider this as a
major contribution which needs to propagated, just wanted to make
people aware of problem/solution.
regards,
Jan Branbergen
Evation.com
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Ferguson | 2002-01-14 20:50:35 | Re: SELECT help (fwd) |
Previous Message | Jan Wieck | 2002-01-14 20:30:54 | Re: Commercial: New Book!! PostgreSQL book is released into |