Re: [BUGS] distance operator dont work

2006-08-13 Thread Tom Lane
bernard snyers <[EMAIL PROTECTED]> writes: > I patch the line > DATA(insert OID = 613 ( "<->" PGNSP PGUID b f 600 628 701 > 0 00 0 0 0 dist_pl - - )); > replacing 628 by 604 , > compiling and reinstalling everything including the database > and It works (I didnt verify the

Re: [BUGS] distance operator dont work

2006-08-13 Thread Michael Fuhr
On Sat, Aug 12, 2006 at 08:52:48AM +0200, bernard snyers wrote: > I have a table containing polygon and I try a distance operator which > fails. (select * from mytable order by point(10,10) <-> mycol) > > Postgres responds that the operator <-> between a point and a polygon is > unknown. > > I

Re: [BUGS] BUG #2572: ALTER TABLE ADD COLUMN

2006-08-13 Thread Michael Fuhr
On Sat, Aug 12, 2006 at 11:53:08AM +, Emil J. wrote: > I create some function (PLPGSQL): > > . > BEGIN > ALTER TABLE sch.table ADD COLUMN abc INTEGER; > RETURN NULL; > END; > > After i called it, nothing happend. No Error, No Exception, No effect - no > column added. Works here

[BUGS] distance operator dont work

2006-08-13 Thread bernard snyers
Dear all, I have a table containing polygon and I try a distance operator which fails. (select * from mytable order by point(10,10) <-> mycol) Postgres responds that the operator <-> between a point and a polygon is unknown. I look in the pg_operator.h (in src/include/catalog) where I think

[BUGS] BUG #2572: ALTER TABLE ADD COLUMN

2006-08-13 Thread Emil J.
The following bug has been logged online: Bug reference: 2572 Logged by: Emil J. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Description:ALTER TABLE ADD COLUMN Details: I create some function (PLPGSQL): . BEGIN A