Re: [GENERAL] current_user in seucurity DEFINER functions

2010-05-13 Thread strk
On Thu, May 13, 2010 at 09:21:46AM +0200, Pavel Stehule wrote: > 2010/5/13 strk : > > In a security definer function current_user yelds the > > name of the function definer rather than invoker. > > Is it possible to fetch the invoker name instead ? How ? > > > > T

[GENERAL] current_user in seucurity DEFINER functions

2010-05-12 Thread strk
In a security definer function current_user yelds the name of the function definer rather than invoker. Is it possible to fetch the invoker name instead ? How ? Thanks in advance. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html -- Sent

Re: [GENERAL] Large index operation crashes postgres

2010-05-02 Thread strk
S 3.2.2 ? A leak was fixed there. You should need no action on the postgis side to get the fix. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] [postgis-users] postgresql8.0 and postgis1.0.0

2005-02-20 Thread strk
ould you send a list of other uncought obsoleted functions ? Be aware (if you're going to patch postgis_restore.pl yourself) that some failures are due to different output from different versions of pg_restore. Note finally that the errors you're getting won't hurt unless the restore cal

Re: [GENERAL] [postgis-users] postgresql8.0 and postgis1.0.0

2005-02-16 Thread strk
tions that might have been obsoleted by newer postgis. I suggest you try the postgis_upgrade.pl and report any problem with it. --strk; On Wed, Feb 16, 2005 at 02:09:11AM -0700, Pritesh Shah wrote: > hi, > > I'm trying to backup a server and restore it on a different machine

[GENERAL] with(isstrict) vs ISSTRICT

2003-11-19 Thread strk
Does with(isStrict) still work ? If not when did postgres drop its support ? TIA --strk; ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] [postgis-users] Union as an aggregate

2003-09-30 Thread strk
tgl wrote: > strk <[EMAIL PROTECTED]> writes: > > If I run that again, *exactly the same query*: > > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND > > 566 pgsql 14 0 126M 126M 3396 S 0.0 16.8 7:13 postmaster > > > It

Re: [GENERAL] [postgis-users] Union as an aggregate

2003-09-30 Thread strk
dblasby wrote: > strk wrote: > > Dave, I made no special 'unite' code, just sql create command: > > CREATE AGGREGATE unite ( > > sfunc = GeomUnion, > > basetype = geometry, > > stype = geometry > > ); > > Hum - this shouldnt do

[GENERAL] SPI portals and memory usage

2003-07-07 Thread strk
Do I save memory using a cursor from a SPI-connected procedure ? I'm working on a table containing geometric objects and I'd like to keep a geometry in memory just for the time it is needed, and one at time, otherwise my machine is in permanent swapping. --strk; -