Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Guillaume Lelarge
Le lundi 6 juillet 2009 à 05:49:24, db.subscripti...@shepherdhill.biz a écrit : > Quoting Guillaume Lelarge : > > If I remember well, the reason was the installer would be much bigger if > > we still included it. And we would also have to carry the pgAdmin CHM, > > and the Slony one, and the Enter

Re: [GENERAL] LIKE problem

2009-07-05 Thread A. Kretschmer
In response to Juan Pablo Cook : > Hi Everybody!  > I'm asking you, because recently I have some problems with the LIKE so I test > with an easy and simple query but doesn't work: > > SELECT * > FROM employee > WHERE id like 'h%'; > > The error says: > "ERROR:  operator does not exist: integer ~~

Re: [GENERAL] LIKE problem

2009-07-05 Thread Pavel Stehule
2009/7/6 Juan Pablo Cook : > Hi Everybody! > I'm asking you, because recently I have some problems with the LIKE so I > test with an easy and simple query but doesn't work: > SELECT * > FROM employee > WHERE id like 'h%'; > The error says: > "ERROR:  operator does not exist: integer ~~ unknown SEL

[GENERAL] Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index

2009-07-05 Thread CM J
Hi, I am running Postgres 8.3.7 on Windows 2003 with my java application.Off late, the server crashes with the following trace: *2009-07-01 14:47:07.250 ISTPANIC: failed to add item to the right sibling in index "mevservices2_ndx"* *2009-07-01 14:47:07.250 ISTSTATEMENT: insert into MEVS

[GENERAL] LIKE problem

2009-07-05 Thread Juan Pablo Cook
Hi Everybody! I'm asking you, because recently I have some problems with the LIKE so I test with an easy and simple query but doesn't work: SELECT * FROM employee WHERE id like 'h%'; The error says: "ERROR: operator does not exist: integer ~~ unknown LINE 5: WHERE id like 'h%';

[GENERAL] GISVM Server pre-release available

2009-07-05 Thread Ricardo Pinho
Dear all, The first public pre-release version of “GIS Virtual Machine Server” is available at: http://gisvm.com GISVM Server is another product based on the GISVM new concept for a Free Open Source GIS Software distribution. With it you get a full feature Free (dom) GIS Server, ready for yo

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Guillaume Lelarge
Le dimanche 5 juillet 2009 à 19:39:09, Raymond O'Donnell a écrit : > On 05/07/2009 18:14, Justin Graf wrote: > > but the the pgAdmin installer from here > > http://www.postgresql.org/ftp/pgadmin3/release/v1.10.0/win32/ > > As far I can think back this installer never included CHM. I found it > > a

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Sachin Srivastava
On 07/05/2009 10:44 PM, Justin Graf wrote: over the last 3 years i can't recall it being included in the msi installer Now the MSI installers from Enterprise DB is a One Click installer i'm not sure whats all included. I have it installed on one or 2 machines but never really dug into what's

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Raymond O'Donnell
On 05/07/2009 18:14, Justin Graf wrote: > but the the pgAdmin installer from here > http://www.postgresql.org/ftp/pgadmin3/release/v1.10.0/win32/ > As far I can think back this installer never included CHM. I found it > annoying but given this supports multiple versions of PG which CHM file > does

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Justin Graf
over the last 3 years i can't recall it being included in the msi installer Now the MSI installers from Enterprise DB is a One Click installer i'm not sure whats all included. I have it installed on one or 2 machines but never really dug into what's all included to tell you what all in the new i

Re: [GENERAL] Will there be an official pg_migrator release?

2009-07-05 Thread Thomas Kellerer
Bruce Momjian wrote on 05.07.2009 02:13: Will there be an official release of it, now that 8.4 is out of the door? Including Windows binaries? Yes, I expect sometime in the next five days. Great, thanks for the info. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] How to use RETURN TABLE in Postgres 8.4

2009-07-05 Thread Michal Szymanski
> Michal Szymanski writes: > > CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8, > > test VARCHAR) > >     AS $$ > > BEGIN > >     -- @todo hide password > >     RETURN QUERY > >         SELECT id  ,test > >         FROM bug_table > >     ; > > END; > > $$ > >     LANGUAGE plpgs

[GENERAL] Example of full text search ranking function somewhere?

2009-07-05 Thread Joost Kraaijeveld
Hi, Is there an example /howto available that I can use to start developing mij own ranking function for full text search? I have looked at the ts_rank source code in src/backend/utils/adt/tsrank.c but that is rather complex an not easy to start learning from. Preferably a minimal boilerplate exa

[GENERAL] Postgres Plus Advanced Server and general Postgres compatibility?

2009-07-05 Thread Andre Lopes
Hi, I have installed "Postgres Plus Advanced Server" in a developement machine. TAt this time I don't know the production server envoirement. It is problematic to use "Postgres Plus Advanced Server" as developement server? Could I have some compatibility problems? Best Regards, André.

Re: [GENERAL] multiple rows by date using count(*)

2009-07-05 Thread Alban Hertroys
On Jul 5, 2009, at 5:20 AM, Shad Keene wrote: PRB | RBL | SAC | SFO | June 1 2 | 4 | 5| 2| June 2 1 | 3 | 4| 0| June 3 0 | 2 | 1| 2| So far, here's the query I'm using to display one row of all items with certain keywords, b

Re: [GENERAL] multiple rows by date using count(*)

2009-07-05 Thread Andreas Kretschmer
Shad Keene wrote: > Hi, > I have data that I'd like to organize spatially by date. So far, I'm only > succeeding in displaying the number of times something occurs out of the whole > dataset. > > Here's an example of what I want to do. > 343 items that occurred at different times from june thro

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Raymond O'Donnell
On 04/07/2009 23:58, justin wrote: > db.subscripti...@shepherdhill.biz wrote: >> I am surprised that pgAdmin's help link is now directed to the >> documentation website of postgresql. The embedded help CHM was not >> packaged with it. [snip] > CHM has not been packaged for as long as i know of wit