On Thu, Dec 10, 2009 at 11:57 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Andrew Gierth <and...@tao11.riddles.org.uk> writes: >> There's another possible solution (albeit a somewhat nontrivial one) >> which came up when a bunch of us were talking about this one on IRC; >> which is to handle the problem in the view deparse: if a column used >> in a USING clause has been renamed, add an alias to the query that >> renames it back, e.g. >> select ... from table1 as table1(v,a) join ... using (v) > > Hmm. Cute, but I wonder why we shouldn't just be throwing an error. > As I said last night, the only thing I see wrong with the current > behavior is that the error message isn't phrased in a way that makes > it obvious it's the user's fault.
I think the problem we're trying to solve is that the view works but it isn't dumpable. ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs