Kris,
Thanks for the response. I have been using Sun's JDBC.
Do I take it that I need to create and use the Postgres
JDBC to get the ability to do NOTIFY/LISTEN?
Glenn
Kris Jurka wrote:
On Tue, 11 May 2004, Glenn Sullivan wrote:
Hi,
I have been trying to get LISTEN/NOTIFY working in with JDBC
Whoops, disregard please.
I shoulda noticed that the headers were identical before I went
whining to the list. Sorry everybody.
Turns out to have been a hammered chain of filters.
Thanks for the nudge, Tom.
Andy
On Wed, 2004-05-12 at 13:03, Andrew Kelly wrote:
> Sorry if this has already been
Hi,
Below is a email from Andrew Kopciuch who tested the patch and wrote
some instruction. sql file is available from
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql
Andrew, could you help Andre with his problem ?
Oleg
---
On Wed, 12 May 2004, Peter Eisentraut wrote:
> Am Montag, 9. Februar 2004 06:06 schrieb David Garamond:
> > SQL Server only allow one NULL in a unique constraint column (it's the
> > unique index that does that, so the unique constraint behaves like that
> > too). The question is, what is the best
On Wed, 12 May 2004, Dirk Försterling wrote:
> Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes:
> >
> >>Do people think linux 2.6.5 is stable enough yet for a production
> >>PostgreSQL server?
> >
> > i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux
> > versi
Hello,
> Recently, we discover how to avoid problem with OIDs backup/restore
> in tsearch2. Check
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ for
> a little patch (regprocedure_7.4.patch.gz). It won't work on
> existed tsearch2
> installation, though, but will help in future.
I d
On Mon, May 10, 2004 at 07:49:42PM -0400, Tom Lane wrote:
>
> Hmm, I would expect that behavior for an overwrite-in-place REINDEX,
> but 7.2 only seems to use overwrite-in-place for critical system
> catalogs. What were you reindexing exactly? Were you running a
> standalone backend?
Not as far
Sorry if this has already been covered...
Suddenly I'm receiving every post to the pgsql-general list twice; been
happening for a couple days now. I even unsubscribed for a bit and then
resubscribed, but it continues.
Is this just me, or is this a global thing?
FWIW, I'm only getting single post
Am Montag, 9. Februar 2004 06:06 schrieb David Garamond:
> SQL Server only allow one NULL in a unique constraint column (it's the
> unique index that does that, so the unique constraint behaves like that
> too). The question is, what is the best way to simulate that behaviour
> in Postgres? Can a C
On Mon, 9 Feb 2004, David Garamond wrote:
> [=> ] 56% ETA ...
>
> I know there is no such thing in Postgres right now (though there is
> pg_stat_activity). But is there database product that can do this?
>
When pg is processing a query it doesn't know how long it will t
Daniel Fitzgerald wrote:
Hi all, I need some pointers. I want to optimize my pgsql databases
hardware-wise. I can do this in Sybase, Oracle, SQL Server, etc. by
putting let's say, indexes on one device, the trasaction logs on
another, data on another drive, etc. Can I do this in Postgresql ? I
[=> ] 56% ETA ...
I know there is no such thing in Postgres right now (though there is
pg_stat_activity). But is there database product that can do this?
--
dave
---(end of broadcast)---
TIP 8: explain analyze is your friend
[EMAIL PROTECTED] wrote:
Dias Bantekas wrote:
does any one know how to get an md5()-like hash function using
pgcrypto for postgresql 7.3 ? without upgrading to 7.4
Thanks for any input.
SELECT encode(digest(v_password, 'md5'), 'hex');
BTW,
/usr/share/pgsql/contrib/pgcrypto.sql
is the script t
13 matches
Mail list logo
