Re: [GENERAL] Many temporal schemas appearred on my DB

2008-12-25 Thread Angel Alvarez
El Jueves, 25 de Diciembre de 2008 Martijn van Oosterhout escribió: > On Thu, Dec 25, 2008 at 04:57:10PM +0100, Angel Alvarez wrote: > > Hi > > > > up to 5 chemas... pg_temp_n for (n=1..5) appearred on my pg 8.3 DB. > > > > pgadmin3 refuses to drop them so i

[GENERAL] Many temporal schemas appearred on my DB

2008-12-25 Thread Angel Alvarez
Hi up to 5 chemas... pg_temp_n for (n=1..5) appearred on my pg 8.3 DB. pgadmin3 refuses to drop them so i have to open a sql editor and run "drop schema pg_tem...". Also some pg_toast_temp schemas got created... ¿Why are created and how con i get rid of them without resorting to doing DROPS

[GENERAL] schema or catalog? what's the diference?

2008-12-11 Thread Angel Alvarez
Hi all pgagent.sql creates a new schema for pgagent stuff but it shows it as catalog whats the diference? as it seems they are created almost equal.. for pgagent 'catalog' CREATE SCHEMA pgagent AUTHORIZATION postgres; COMMENT ON CATALOG pgagent IS 'pgAgent system tables'; for public schema

Re: [GENERAL] nearest neighbor search from xyz coordinates

2008-10-27 Thread Angel Alvarez
El Lunes 27 Octubre 2008 Andreas Jochem escribió: > Hello, > > I have a table containing x y z coordinates. But I have no geometry column? > Is it possible to find the k nearest neighbors of any point. Is there > something like a kd-tree Index in postgres??? > > I know, if i had a geometry colum

Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Angel Alvarez
. Regards, Angel El Jueves 23 Octubre 2008 Collin Kidder escribió: > Angel Alvarez wrote: > > What's such most advanced mail reader?? > > > > No one, ive seen, seems to be perfect nor thunderbird. > > By the way kmail has 4 options (reply, reply to all, reply to autho

Re: [GENERAL] Annoying Reply-To

2008-10-23 Thread Angel Alvarez
El Jueves 23 Octubre 2008 Collin Kidder escribió: > >> horse.  Since I use the most advanced e-mail client on the market I just > >> work around that the settings here are weird, it does annoy me a bit > >> anytime I stop to think about it though. What's such most advanced mail reader?? No one