Bugs item #1010308, was opened at 2008-03-03 18:56
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010308&group_id=1000125
Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Pedro Gimeno (pgimeno)
Assigned to: Nobody (None)
Summary: Updatability regression after 08020200
Initial Comment:
In version 08_02_0200, the following query was updatable:
SELECT tbl1.pk, tbl1.data FROM tbl1
INNER JOIN tbl2 ON tbl1.fk = tbl2.pk
;
In public releases 08_02_0300 and above, that query is no longer
updatable.
Incidentally, the same happens with this query:
SELECT tbl1.pk, tbl1.data FROM tbl1
-- INNER JOIN tbl2 ON tbl1.fk = tbl2.pk
;
even if the join is commented out as denoted by the "--".
We need those kinds of queries (the first kind, not the commented out one)
to be updatable because that way we can restrict the query using fields
from tbl2 by means of a WHERE clause. We've had to downgrade the version
to 08_02_0200.
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010308&group_id=1000125
--
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc
