On Wed, Apr 11, 2012 at 3:01 PM, Ken Benson <ken@infowerks.com> wrote:
> UPDATE tmp_rxpurge as t SET dt_lastfill = rf.dt_lastfill FROM (SELECT
> "RXNUM" AS rxnum, Max("DATE") as dt_lastfill FROM transactions GROUP BY
> "RXNUM") as rf WHERE rf.rxnum=t.rxnum
> There is no error generated.
> I have enabled 'logging' in the ODBC connector - and I don't see anything
> out of the ordinary in the short-log. (The long-log - I have no idea what
> all that stuff means.)
You'll find that reading the logs produced by the PostgreSQL server to
be much more informative about the miss behavior your experiencing.
Can you post the logs generated by PostgreSQL, when you attempt this
UPDATE statement?
--
Regards,
Richard Broersma Jr.