Re: [GENERAL] Pls help

2009-07-04 Thread Scott Marlowe
On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Roseller A. Romanos don2_...@yahoo.com:  Hi, I really have a serious problem with this.  I hope you could give me some insights on how to possibly solve this problem. I have installed a new copy of postgres

Re: [GENERAL] Pls help

2009-07-04 Thread Pavel Stehule
2009/7/4 Scott Marlowe scott.marl...@gmail.com: On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Roseller A. Romanos don2_...@yahoo.com:  Hi, I really have a serious problem with this.  I hope you could give me some insights on how to possibly solve this

Re: [GENERAL] Pls help

2009-07-04 Thread Scott Marlowe
On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Scott Marlowe scott.marl...@gmail.com: On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Roseller A. Romanos don2_...@yahoo.com:  Hi, I really have a serious problem

Re: [GENERAL] Pls help

2009-07-04 Thread Pavel Stehule
2009/7/4 Scott Marlowe scott.marl...@gmail.com: On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Scott Marlowe scott.marl...@gmail.com: On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Roseller A. Romanos

Re: [GENERAL] Pls help

2009-07-04 Thread Scott Marlowe
On Sat, Jul 4, 2009 at 12:22 AM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Scott Marlowe scott.marl...@gmail.com: On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/7/4 Scott Marlowe scott.marl...@gmail.com: On Fri, Jul 3, 2009 at 10:40 PM, Pavel

Re: [GENERAL] Pls help

2009-07-04 Thread Scott Marlowe
On Fri, Jul 3, 2009 at 10:02 PM, Roseller A. Romanosdon2_...@yahoo.com wrote:  Hi, I really have a serious problem with this.  I hope you could give me some insights on how to possibly solve this problem. I have installed a new copy of postgres in my PC using Windows XP OS and I have copy the

[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:

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,

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 say

[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

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 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

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 open

[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

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

[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 akla...@comcast.net wrote: On Saturday 04 July 2009 10:47:34 am Juan Pablo Cook wrote: Hi

[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

[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

Re: [GENERAL] Pls help

2009-07-04 Thread justin
Scott Marlowe wrote: On Fri, Jul 3, 2009 at 10:02 PM, Roseller A. Romanosdon2_...@yahoo.com 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

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

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 br...@momjian.us

[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