<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16440"></HEAD>
<BODY>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>As discussed this
ticket:</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial><A
href="https://trac.osgeo.org/postgis/ticket/1426#comment:5">https://trac.osgeo.org/postgis/ticket/1426#comment:5</A></FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>I would like to add
to the legacy_compatibility_layer.sql </FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>(which would mean it
will get added to legacy.sql)</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>A rule for pre 9.1
users against the geometry_columns view that will just ignore any attempts to
insert to the view.</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial></FONT></SPAN><SPAN
class=816513020-02012012><FONT size=2 face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>For 9.1 we could
make it a bit better by putting in a trigger instead that gives a notice that
its a view and what the hell are they up to.</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>For the delete case
where people have tried to delete from geometry_columns to clear dropped tables
etc., I'm debating if there is any harm if we
just</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>always silently
ignore. Since the view clears itself automagically there in theory would
not be any harm in ignoring this.</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2 face=Arial>Do people have
thoughts on the matter, anything I missed in my assumptions?</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=816513020-02012012><FONT size=2
face=Arial>Regina</FONT></SPAN></DIV></BODY></HTML>