Re: [GENERAL] [postgis-users] ST_AsJpeg

2012-02-15 Thread Sandro Santilli
On Wed, Feb 15, 2012 at 10:37:08PM +0100, Stefan Keller wrote: > Hi Regina > > 2012/2/14 Paragon Corporation wrote: > > Here it is in the docs now: > > > > http://postgis.refractions.net/documentation/manual-svn/using_raster.xml.html#RasterOutput_PSQL > > Citation from there: "Sadly PSQL doesn't

Re: [GENERAL] [postgis-users] Query slow down, never completes

2011-10-11 Thread Sandro Santilli
On Tue, Oct 11, 2011 at 02:25:20PM +0200, Andreas Forø Tollefsen wrote: > I also tried to close the db1 connection for each year in the loop, and > reopen the connection for the next year in the loop. Same problem. > I have tried both with insert into ... select .. and select into annual > tables

Re: [GENERAL] [postgis-users] Query slow down, never completes

2011-10-11 Thread Sandro Santilli
On Tue, Oct 11, 2011 at 05:12:24PM +0200, Andreas Forø Tollefsen wrote: > Hi Sandro, > > What i find strange is that it stops processing at different years on my > desktop and my laptop. While my desktop stops processing at 1980, my slower > laptop goes on to 1991 before halting. > I also tried wi

[GENERAL] Triggers NOT running as table owner

2013-06-27 Thread Sandro Santilli
According to release notes of 8.3.18 (yeah, old docs) a trigger runs with the the table owner permission. This is the only document I found about this matter: http://www.postgresql.org/docs/8.3/static/release-8-3-18.html Require execute permission on the trigger function for CREATE TRIGGER (Rob