[GENERAL] Start automatically a function at startup of postgresql server

2009-07-04 Thread d...@dfx.it
Dear Sirs, Is it possible to start a function (a my function) when the server postgres is started? and how I can do? Best regards. Domenico Formenton -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL] Group by on %like%

2009-07-04 Thread Jennifer Trey
Sorry for taking so long to respond. The prefix thingy is definetly attractive for future development and I had already discovered them to be a challenge. However, i have noticed all kinds of ways people tend to write their number, including omitting the + or 00 .. so at this time, for this task, I

Re: [GENERAL] REINDEX "is not a btree"

2009-07-04 Thread Craig Ringer
On Fri, 2009-07-03 at 15:00 +0100, Vanessa Lopez wrote: > I don't know much about postgre, I have no clue what else I can do. > Please, please any help is very very much appreciated I have lots of > databases and months of work in postgre (also lots of backups for the > data in /data) When you s

[GENERAL] about pg_stat_get_db_xact_commit

2009-07-04 Thread abdelhak benmohamed
Hellow I like to track the number of committed transaction for my database So I use the following command Select pg_stat_get_db_xact_commit(16384)   (16384 is the oid of my database)   It gives me 35   But if I execute the same command another time, it gives me more than 35.   Between the first se

Re: [GENERAL] Start automatically a function at startup of postgresql server

2009-07-04 Thread Gurjeet Singh
On Sat, Jul 4, 2009 at 2:21 PM, d...@dfx.it wrote: > Dear Sirs, > > Is it possible to start a function (a my function) when the > server postgres is started? and how I can do? > > No.. There's no way that can be done in Postgres. Although you can add something to your startup scripts that connect

Re: [GENERAL] Installing plpython on 8.4

2009-07-04 Thread Peter Eisentraut
On Saturday 04 July 2009 02:57:35 Scott Bailey wrote: > On ubuntu from command line: > > createlang -h localhost -p 5433 plpythonu template1 > > createlang: language installation failed: ERROR: could not load library > "/opt/postgres/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0: > cannot

[GENERAL] Function Issue and casting

2009-07-04 Thread Juan Pablo Cook
Hi friends, It's my first time I'm writing to the list. All days I enjoy the list! I declare a function, and when I want to call this, it fails. My function: CREATE OR REPLACE FUNCTION alta_docente(integer,varchar,varchar,varchar,bigint,varchar,integer) RETURNS VOID AS $body$ declare codigo in

Re: [GENERAL] Function Issue and casting

2009-07-04 Thread Adrian Klaver
On Saturday 04 July 2009 10:47:34 am Juan Pablo Cook wrote: > Hi friends, It's my first time I'm writing to the list. All days I enjoy > the list! > I declare a function, and when I want to call this, it fails. > > My function: > CREATE OR REPLACE FUNCTION > alta_docente(integer,varchar,varchar,var

[GENERAL] Function Issue and casting

2009-07-04 Thread Juan Pablo Cook
Adrian, thanks a lot!!! for your quicky reply. Thats the error!, my casting was ok, but my schema path was wrong. I didn't realize that. Thanks a lot! Bye! On Sat, Jul 4, 2009 at 3:25 PM, Adrian Klaver wrote: > On Saturday 04 July 2009 10:47:34 am Juan Pablo Cook wrote: > > Hi friends, It's my

[GENERAL] Documentation - PgAdmin

2009-07-04 Thread db . subscriptions
Hi, Congratulations on the release of version 8.4. 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. This implies that anytime one needs help on a simple syntax, one must connect to the inte

[GENERAL] Will there be an official pg_migrator release?

2009-07-04 Thread Thomas Kellerer
Hi, the project page of pg_migrator still shows it as a release candidate. Will there be an official release of it, now that 8.4 is out of the door? Including Windows binaries? Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subsc

Re: [GENERAL] Pls help

2009-07-04 Thread justin
Scott Marlowe wrote: On Fri, Jul 3, 2009 at 10:02 PM, Roseller A. Romanos wrote: Note that this could be a permissions problem. All the files need to belong to whatever user postgres runs as. If the destination PG install successfully started before there will be no permission problem

Re: [GENERAL] Documentation - PgAdmin

2009-07-04 Thread justin
db.subscripti...@shepherdhill.biz wrote: Hi, Congratulations on the release of version 8.4. 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. This implies that anytime one needs h

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

2009-07-04 Thread Bruce Momjian
Thomas Kellerer wrote: > Hi, > > the project page of pg_migrator still shows it as a release candidate. > > 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. -- Bruce Momjian http://

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

2009-07-04 Thread Shad Keene
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 through july. multiple different ke