Re: [HACKERS] Non-C locale and LIKE

> However, I am wondering if we should create a character > lookup during initdb that has the characters ordered so we can do: > > col LIKE 'ha%' AND col >= "ha" and col <= "hb" > > Could we do this easily for single-character encodings? We > could have: > > A 1 > B

[HACKERS] Non-C locale and LIKE

I know we can't currently use an index with non-C locales and LIKE except when we create a sepcial type of index for LIKE indexing (text_pattern_ops). However, I am wondering if we should create a character lookup during initdb that has the characters ordered so we can do: col LIKE 'ha%'

Re: [HACKERS] psql and schemas

Is there a TODO here? Or a few? --- Neil Conway wrote: > On Sun, 2004-10-31 at 05:32, Tom Lane wrote: > > The behaviors you mention were written at different times by different > > people, and mostly have nothing to do with

Re: [HACKERS] Suggestion: additional system views

This has been saved for the 8.1 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- David Fetter wrote: > On Mon, Nov 01, 2004 at 12:49:47AM +0100, Gaetano Mendola wrote: > > Josh Berkus wrote: > > >Neil, >

Re: [HACKERS] Problems using pgxs on Win32

I assume all the pgxs changes have been applied by Tom. --- Fabien COELHO wrote: > > Dear Thomas, > > > I'm trying to change the Makefile system for PL/Java so that it uses PGXS > > instead of compiling using a complete Po

[HACKERS] Fix for NLS in pgport

I saw Peter's commit to allow NLS lookups from libpgport functions. Here is the change to pg_ctl/nls.mk: < GETTEXT_FILES := pg_ctl.c > GETTEXT_FILES := pg_ctl.c ../../port/exec.c Peter, do you have to know the C file used by pg_ctl to make these adjustments? Thi

Re: [HACKERS] VACUUM FULL FREEZE is unsafe

"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes: > So why not have VACUUM FULL FREEZE just do what you propose: VACUUM > FULL then VACUUM FREEZE. The objective is to make it more safe, not less so. Doing that would require rewriting a whole bunch of code, which I am not up for at this stage of t

Re: [HACKERS] VACUUM FULL FREEZE is unsafe

So why not have VACUUM FULL FREEZE just do what you propose: VACUUM FULL then VACUUM FREEZE. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Nov 27, 20

Re: [HACKERS] how to enable syslog in windows

Tom Lane wrote: Ganesan S <[EMAIL PROTECTED]> writes: how can i enable syslog in postgresql8.0.0beta4 on windows Has Windows got syslog? I thought not. No, Windows in itself doesn't. The preferred way on windows is to use the event logger. There are of course a number of freeware syslog impleme

Re: [HACKERS] [pgsql-hackers-win32] [BUGS] pg_autovacuum in 8beta-dev3 small bug

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Bruce Momjian > Sent: 27 November 2004 04:33 > To: [EMAIL PROTECTED] > Cc: PostgreSQL Win32 port list; PostgreSQL-development > Subject: Re: [pgsql-hackers-win32] [BUGS] pg_autovacuum in > 8beta-

[HACKERS] VACUUM FULL FREEZE is unsafe

The point of VACUUM FREEZE is to ensure that there are no tuples present in the database whose commit status depends on "normal" XIDs. Without this guarantee, cloning template0 might stop working once the relevant part of pg_clog has been pruned. If one combines freezing with moving tuples across

Re: [HACKERS] Bitmap index

On Nov 22, 2004, at 2:57 AM, Pawe Niewiadomski wrote: Hello, I saw discussion about bitmap indexes few weeks ago. I wonder if any of you is working on it (in secret)? I will be chosing subject of my master thesis and thougth about implementing bitmap indexes. -- **PaweŠNiewiadomski**, new()foo-ba

Re: [HACKERS] PostgreSQL testresults

Philippe Rigault said: > Hello, > > I have not seen any PostgreSQL mailing-list for posting results of > compilation/testing on different platforms/configurations (something > similar to gcc-testresults for gcc). > > Are you guys interested in getting results like this ? It could provide > develo

Re: [HACKERS] New member says hello

In <[EMAIL PROTECTED]>, on 11/27/04 at 01:05 PM, Tom Lane <[EMAIL PROTECTED]> said: >[EMAIL PROTECTED] writes: >>at 09:50 PM, Tom Lane <[EMAIL PROTECTED]> said: >>> If you're hoping to get this into 8.0, it had better arrive soon and be a >>> very small patch ... >> It may have to be for

Re: [HACKERS] how to enable syslog in windows

Ganesan S <[EMAIL PROTECTED]> writes: > how can i enable syslog in postgresql8.0.0beta4 on windows Has Windows got syslog? I thought not. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [HACKERS] New member says hello

[EMAIL PROTECTED] writes: >at 09:50 PM, Tom Lane <[EMAIL PROTECTED]> said: >> If you're hoping to get this into 8.0, it had better arrive soon and be a >> very small patch ... > It may have to be for 8.0.1 there are a lot of changes to the makefiles to > accomodate the if(($portname), ibmos2)

[HACKERS] PostgreSQL testresults

Hello, I have not seen any PostgreSQL mailing-list for posting results of compilation/testing on different platforms/configurations (something similar to gcc-testresults for gcc). Are you guys interested in getting results like this ? It could provide developers with lots of interesting inform

[HACKERS] how to enable syslog in windows

how can i enable syslog in postgresql8.0.0beta4 on windows   if syslog_indent,syslog_facility are commented only postgres service is starting if i remove the comment(#) service is not starting can anyone help me out   Regards Ganesan SReini Urban <[EMAIL PROTECTED]> wrote: postgresql-cygwin is

Re: [HACKERS] src/timezone/pgtz __imp__my_exec_path

postgresql-cygwin is working fine. See the testfarm. Just cygwin itself, cygserver - the IPC daemon - has problems. On msgctl(IPC_INFO) the internal msg buffer struct msqid_ds *buf is allocated at a non-writable area, IsBadWritePtr() fails. I suspect it's a new gcc-3.4 feature, but haven't found