On 5/9/04 1:58 PM, Tom Lane [EMAIL PROTECTED] wrote:
I am not sure how either of these techniques map into ecpg though.
If you want to use ecpg then I'd suggest bringing up the question on
pgsql-interfaces --- the ecpg gurus are more likely to be paying
attention over there.
I got some
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
version 10)
I'd like to add here, that I recently tried 2.6.5 / Postgres
[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
[= ] 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
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
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 take,
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
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
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 as
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 do
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
version 10)
I'd
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 way
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
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
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
15 matches
Mail list logo