Re: [HACKERS] Patch for collation using ICU

2005-03-29 Thread Palle Girgensohn
--On söndag, mars 27, 2005 04.34.03 +0300 Hannu Krosing <[EMAIL PROTECTED]> wrote: On L, 2005-03-26 at 03:09 +0100, Palle Girgensohn wrote: Hi! ... I've noticed a couple of things about using the ICU patch vs. pristine pg-8.0.1: - ORDER BY is case insensitive when using ICU. This might break the

Re: [HACKERS] rewriter in updateable views

2005-03-29 Thread Bernd Helmle
--On Montag, März 28, 2005 09:51:52 +0100 Simon Riggs <[EMAIL PROTECTED]> wrote: [...] If you have everything else working, it might be worth submitting a patch for review? There may be other things required also. Best Regards, Simon Riggs Well, the patch is far away from being ready for -patches

Re: [HACKERS] minor windows & cygwin regression failures on stable

2005-03-29 Thread Tom Lane
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > I'm not quite sure what question I should be asking of the Cygwin people. > Tom, Can you suggest something? It sounds to me like the problem is that the backend executing the test script is in a tight loop (due to the half-baked implementation of slee

Re: [HACKERS] minor windows & cygwin regression failures on stable

2005-03-29 Thread Andrew Dunstan
Reini Urban said: >> Tom Lane wrote: >>>Andrew Dunstan <[EMAIL PROTECTED]> writes: >>> What has changed in the last 3 weeks is that I refreshed my Cygwin installation, I think when I was wrestling with the NLS thing. If nothing in postgres has changed in this area I assume that platf

Re: [HACKERS] Patch for collation using ICU

2005-03-29 Thread Hannu Krosing
On L, 2005-03-26 at 03:09 +0100, Palle Girgensohn wrote: > Hi! > ... > I've noticed a couple of things about using the ICU patch vs. pristine > pg-8.0.1: > > - ORDER BY is case insensitive when using ICU. This might break the SQL > standard (?), but sure is nice :) How does your patch interac

Re: [HACKERS] minor windows & cygwin regression failures on stable

2005-03-29 Thread Reini Urban
> Tom Lane wrote: >>Andrew Dunstan <[EMAIL PROTECTED]> writes: >> >>>What has changed in the last 3 weeks is that I refreshed my Cygwin >>> installation, I think when I was wrestling with the NLS thing. If >>> nothing in postgres has changed in this area I assume that platform >>> changes account

Re: [HACKERS] Executing Anonymous Blocks

2005-03-29 Thread Andrew Dunstan
Neil Conway said: > Alvaro Herrera wrote: >> On Mon, Mar 28, 2005 at 12:27:18PM +0500, imad wrote: >>>I want to know is there any way to execute an anonymous PL/pgSQL block >>>in PostgreSQL. >> >> No, there isn't. > > It might be possible to implement at least some of this functionality > entirely

[HACKERS] when using a bound cursor, error found..

2005-03-29 Thread 윤동수
I 'll use a bound cursor with parameters. But when I use such a cursor, I found a error. I don't know error message. How can I use a bound cursor. in following sample,  near a 'for loop' , error found. -- CREA

Re: [HACKERS] Executing Anonymous Blocks

2005-03-29 Thread Neil Conway
Alvaro Herrera wrote: On Mon, Mar 28, 2005 at 12:27:18PM +0500, imad wrote: I want to know is there any way to execute an anonymous PL/pgSQL block in PostgreSQL. No, there isn't. It might be possible to implement at least some of this functionality entirely in the client. So: BLOCK; /* your pl/pg