[postgis-devel] 1.5.0rc2 - FAST TURNAROUND

[Kevin Neufeld]

It's unfortunate that IF EXISTS raises notices.

If it's intentional to have the DROP FUNCTIONs there to remove any old stuff (even on new installs), it's possible to 
query the system tables directly and remove the unneeded functions programatically ... and quietly.

-- Kevin

On 2/1/2010 12:24 PM, Kevin Neufeld wrote:
> Regression tests pass for me as well on centos 5.2, geos 3.2.0, proj
> 4.6.1, psql 8.3 and 8.4.2.
>
> However, when I try to create a new database myself, I get a whole lot
> of DROP FUNCTION NOTICES after the final COMMIT in postgis.sql
>
> It's like an upgrade script was accidently appended to the usual postgis
> function install. This is going to cause a lot of confusion.
>
> ...
> CREATE FUNCTION
> CREATE FUNCTION
> COMMIT
> psql:/var/home/buildbot/opt/pgsql/8.4/share/contrib/postgis-1.5/postgis.sql:7744:
> NOTICE: aggregate geomunion(geometry) does not exist, skipping
> DROP AGGREGATE
> psql:/var/home/buildbot/opt/pgsql/8.4/share/contrib/postgis-1.5/postgis.sql:7745:
> NOTICE: aggregate st_geomunion(geometry) does not exist, skipping
> DROP AGGREGATE
> psql:/var/home/buildbot/opt/pgsql/8.4/share/contrib/postgis-1.5/postgis.sql:7746:
> NOTICE: aggregate accum_old(geometry) does not exist, skipping
> DROP AGGREGATE
> psql:/var/home/buildbot/opt/pgsql/8.4/share/contrib/postgis-1.5/postgis.sql:7747:
> NOTICE: aggregate st_accum_old(geometry) does not exist, skipping
> DROP AGGREGATE
> psql:/var/home/buildbot/opt/pgsql/8.4/share/contrib/postgis-1.5/postgis.sql:7750:
> NOTICE: function box2d_overleft(box2d,box2d) does not exist, skipping
>
>
> -- Kevin
>
>
> On 2/1/2010 11:31 AM, Paul Ramsey wrote:
>> Regression on OpenSolaris passes.
>>
>> On Mon, Feb 1, 2010 at 10:27 AM, Paul Ramsey<pramsey at opengeo.org> wrote:
>>> Regression test on OS/X 10.6.2 passes.
>>>
>>> On Mon, Feb 1, 2010 at 10:27 AM, Paul Ramsey<pramsey at opengeo.org> wrote:
>>>> Regression test on Centos 5.4 passes.
>>>>
>>>> On Mon, Feb 1, 2010 at 9:48 AM, Paul Ramsey<pramsey at opengeo.org> wrote:
>>>>> OK, I have run astyle and placed the current tarball at
>>>>>
>>>>> http://postgis.refractions.net/download/postgis-1.5.0rc2.tar.gz
>>>>>
>>>>> Please download and run make check on this source ASAP on your
>>>>> systems. If there have been no critical bug reports by Wednesday
>>>>> morning my time, I am going to drop 1.5.0.
>>>>>
>>>>> Go go go go go!
>>>>>
>>>>> Paul
>>>>>
>>>>
>>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel