On 8/13/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> "Loredana Curugiu" <[EMAIL PROTECTED]> writes:
> > For installing I am running the "configure" script as follows:
>
> > ./configure --prefix=/usr/local/pgsql-7.4.5 --with-java
> --with-pgport=6947
>
> > Although I specify a different port than th
Judith wrote:
> Hello everybody!!
>
> I'm trying in SUSE to connect to a postgres db and this is the error:
>
> Ident Authentification failed for user <>
>
> I'm already created the user with createuser root, but the error
> persist, I would aprecciate some help, thanks in advanced
...or just
Connecting as root may be ill advised (doing stuff as root is a bad
idea unless one HAS to).
All that notwithstanding, you need to setup the correct permissions to
allow the connections you want in pg_hba.conf, usually is
/var/lib/pgsql/data/pg_hba.conf
Terry
Terry Fielder
[EMAIL PROTECTED
De: hubert depesz lubaczewski [mailto:[EMAIL PROTECTED]
>>On Fri, Aug 10, 2007 at 04:40:34PM -0300, Fernando Hevia wrote:
>> Found your query is shorter and clearer, problem is I couldn't have it
use
>> an index. Thought it was a locale issue but adding a 2nd index with
>> varchar_pattern_ops ma
I have a shared library loaded into postgresql using
CREATE FUNCTION medbevent() RETURNS trigger as
'/usr/lib/pgsql/libmedbevent.so' language 'C';
I'm randomly having issues with my triggers not firing (it turns out
they are getting removed) and when i turned INFO logs on i saw the
following
200
"Jon Horsman" <[EMAIL PROTECTED]> writes:
> I'm randomly having issues with my triggers not firing (it turns out
> they are getting removed) and when i turned INFO logs on i saw the
> following
> 2007-08-14 13:41:44.740305500 LOCATION: _fini, medbevent_init.c:129
> 2007-08-14 13:41:45.790850500 I
I believe they are standard PostgreSQL functions not sure what version
they appeared in though.
I learnt about them by RTM
Cheers,
~p
-Original Message-
From: Ronald Rojas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 14 August 2007 18:00
To: Phillip Smith
Subject: Re: [SQL] populate value
