Re: [HACKERS] WebSphere Application Server support for postgres

2012-10-16 Thread Florent Guillaume
Can you provide a link or > info that doesn't require login please? The relevant content of the ticket is basically just: Description: WebSphere Application Server support for JDBC access to PosgreSQL databases. Use case: In WAS, be able to define and use JDBC providers and datasources p

[HACKERS] phrase search

2010-09-14 Thread Florent Guillaume
with commercial vendors. I'd love to tell my customers that we can support this natively with Postgres! And by the way THANK YOU for the amazing tsearch, it's a beautiful piece of software and very useful to us. Thanks, Florent -- Florent Guillaume, Director of R&D, Nuxeo Open Sour

[HACKERS] Re: [SQL] PL/PGSQL function with parameters

2001-02-06 Thread Florent Guillaume
> > SQL = ''SELECT * INTO temp1 FROM '' || $1; > > I tried this, and it seems that "SELECT ... INTO foo" is not executed > correctly by EXECUTE --- the INTO is handled as an ordinary select-into- > table construct rather than plpgsql's select-into-variable. > > While I have not looked closel

[HACKERS] Re: [PATCHES] A Sparc/Linux patch (for 7.1), and a Linux rc.d/init.d script....

2001-02-06 Thread Florent Guillaume
> > > su - postgres sh -c "$DAEMON stop >& /dev/null" > > > > Hmm... What is wrong here, besides the '>&'? The '>&' can be > > replaced with '2>&1 >' if that is more standard. It won't do what you want. You want '>/dev/null 2>&1'. > Change made. Hmmm, I don't see this change in cvsweb. F

[HACKERS] Re: Sure enough, the lock file is gone

2001-01-27 Thread Florent Guillaume
> It would probably be better if the socket files weren't in /tmp but in > a postgres-owned directory. However, at this point we have a huge > backwards compatibility problem to overcome if we want to move the > socket files. The location of the socket files is essentially a core > part of the f

[HACKERS] Re: Sure enough, the lock file is gone

2001-01-27 Thread Florent Guillaume
/tmp is for *temporary* files. Such a lock is not a temporary file, it should go somewhere in /var, why not in /var/lib/pgsql/data ? > The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock > file after the server has run 6 days. This will be a problem. > > We could touch (o