Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1010308 ] Updatability regression after 08020200

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010308 ] Updatability regression after 08020200
Date: 2008-03-03 17:56:24
Message-ID: 20080303175624.44ACC17ADCC4@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2008-03-04 02:36:42
Subject: Re: Symbol files
Previous:From: Son OsirisDate: 2008-03-03 17:12:14
Subject: Symbol files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group