Tom, > Josh, you don't know what you're talking about. The backend's > capabilities for this have not moved an inch since 8.1 (transient bugs > in its error checking do not represent an advance in capability),
Hmmm ... was this an unapplied patch? We certainly had it working on the benchmark machine. Researching ... > and furthermore I'm not seeing anyplace in the SQL spec that suggests > the nullable side of an outer join should be updatable. Oh, no, what should happen is that the outer join portion of the query doesn't get locked, rather than a fatal exception. That behavior is expected by the J2EE certification, so it's at least somewhat industry-standard. -- Josh Berkus PostgreSQL @ Sun San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq