Re: [HACKERS] *sigh*

2003-12-02 Thread Christopher Browne
Martha Stewart called it a Good Thing when Randolf Richardson <[EMAIL PROTECTED]> wrote: >>> The count(*) information can be revisioned too, am I wrong ? I'm able >>> to create a trigger that store the count(*) information in a special >>> table, why not implement the same in a way "builded in" ?

Re: [HACKERS] fork/exec problem: DynaHashCxt

2003-12-02 Thread Claudio Natoli
> Claudio Natoli <[EMAIL PROTECTED]> writes: > > So this means we'll have to pull relHash out of the shared FreeSpaceMap > > structure and make it a variable in it's own right? > > Hm. The freespace.c code is relatively new and might not be jumping > through all of the hoops it should be jumping

Re: [HACKERS] fork/exec problem: DynaHashCxt

2003-12-02 Thread Tom Lane
Claudio Natoli <[EMAIL PROTECTED]> writes: > So this means we'll have to pull relHash out of the shared FreeSpaceMap > structure and make it a variable in it's own right? Hm. The freespace.c code is relatively new and might not be jumping through all of the hoops it should be jumping through. My

Re: [HACKERS] fork/exec problem: DynaHashCxt

2003-12-02 Thread Claudio Natoli
> I'm not sure if you're confusing backend-local hashes with shared > hashes, or hash control headers with the actual shared data. But > the above is a false statement. DynaHashCxt is not shared. No, wasn't confused over that. Was confused over something else though :-) > Shared hashes are a

[HACKERS] 7.3.5 bundled ...

2003-12-02 Thread Marc G. Fournier
Please take a quick peak at it ... ftp://ftp.postgresql.org/pub/source/v7.3.5 Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-02 Thread Lamar Owen
On Tuesday 02 December 2003 06:29 pm, Gaetano Mendola wrote: > Lamar Owen wrote: > > You need to specify that you are building for Red Hat 9 on the command > I'll try. Ok. > PS: the 7.4 will be remembered as the longest release to be developed > and for the longest period needed in order to have

Re: [HACKERS] fork/exec problem: DynaHashCxt

2003-12-02 Thread Tom Lane
Claudio Natoli <[EMAIL PROTECTED]> writes: > All the ShmemInitHash structures are allocated using DynaHashCxt. I'm not sure if you're confusing backend-local hashes with shared hashes, or hash control headers with the actual shared data. But the above is a false statement. DynaHashCxt is not sha

Re: [HACKERS] Inside the Regex Engine

2003-12-02 Thread Tom Lane
[EMAIL PROTECTED] (David Fetter) writes: > While PL/Perl is great, it's not available everywhere, and I'd like to > be able to grab atoms from a regex match in, say, a SELECT. Is there > some way to get access to them? There's a three-parameter variant of substring() that allows extraction of a p

Re: [HACKERS] Inside the Regex Engine

2003-12-02 Thread Alvaro Herrera
On Tue, Dec 02, 2003 at 07:52:57PM -0600, David Fetter wrote: > As a perl weenie, I'm used to being able to do things with regexes > like > > $text =~ s/(foo|bar|baz)/NO UNIX WEENIES HERE/; > $got_it = $1; > > While PL/Perl is great, it's not available everywhere, and I'd like to > be able to gr

Re: [HACKERS] ALTER SEQUENCE enchancement

2003-12-02 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > The above is an operation that would not help me a lot, but a way of > performing currval() without knowing the sequence name would be good. You could do this with a function. Here is a quick one in SQL: CREATE OR REPLACE FUNCTION seqname(NAM

[HACKERS] Inside the Regex Engine

2003-12-02 Thread David Fetter
Kind people, As a perl weenie, I'm used to being able to do things with regexes like $text =~ s/(foo|bar|baz)/NO UNIX WEENIES HERE/; $got_it = $1; While PL/Perl is great, it's not available everywhere, and I'd like to be able to grab atoms from a regex match in, say, a SELECT. Is there some way

[HACKERS] fork/exec problem: DynaHashCxt

2003-12-02 Thread Claudio Natoli
Hi all, I'm working on getting BackendFork converted to a fork/exec model, and have hit the following wall. All the ShmemInitHash structures are allocated using DynaHashCxt. Clearly, this context is going to have to be shared across backends in the fork/exec case, but I can't see a non-trivial w

Re: [HACKERS] request for feedback - read-only GUC variables,

2003-12-02 Thread Marc G. Fournier
On Tue, 2 Dec 2003, Joe Conway wrote: > We (mostly Bruce, Tom, Peter, and I) have been having a discussion on > the PATCHES list regarding some new functionality related to read-only > GUC variables. The net result is pasted at the bottom of this post. Here > is a link to the discussion: > http://

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-02 Thread Gaetano Mendola
Lamar Owen wrote: On Monday 01 December 2003 08:53 pm, Gaetano Mendola wrote: Hi all, I'm still experiencing problem trying to rebuild the rpm from the file: postgresql-7.4-0.5PGDG.src.rpm I seen that the configure is done with: --with-krb5=/usr. You need to specify that you are building for

[HACKERS] request for feedback - read-only GUC variables, pg_settings changes

2003-12-02 Thread Joe Conway
We (mostly Bruce, Tom, Peter, and I) have been having a discussion on the PATCHES list regarding some new functionality related to read-only GUC variables. The net result is pasted at the bottom of this post. Here is a link to the discussion: http://archives.postgresql.org/pgsql-patches/2003-11/

Re: [HACKERS] [pgsql-hackers-win32] What packages from Mingw and MSys are needed?

2003-12-02 Thread Andrew Dunstan
Tony and Bryn Reina wrote: 1. Which parts of MSYS and Mingw are needed for the building a Win32 version of PostgreSQL? There are several packages listed on the Mingw website: MingGW-3.1.0-1.exe mingw-utils-0.2 mingw-runtime-3.2 msys-1.0.9.exe msysDTK-1.0.1.exe binutils gcc win32api-2.4 mingw32-

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-02 Thread Lamar Owen
On Monday 01 December 2003 08:53 pm, Gaetano Mendola wrote: > Hi all, > I'm still experiencing problem trying to > rebuild the rpm from the file: > postgresql-7.4-0.5PGDG.src.rpm > I seen that the configure is done with: > --with-krb5=/usr. You need to specify that you are building for Red Hat 9

Re: [HACKERS] porting from 7.2 -> 7.4

2003-12-02 Thread darren
> > I'm trying to port some replication code from 7.2 -> 7.4 and am running > into a block. > > In the file: > /src/backend/tcop/postgres.c > Sorry I'm not answering your question, but I didn't have a chance to look last night. Did you start a new tree for 7.4? Darren > --

[HACKERS] porting from 7.2 -> 7.4

2003-12-02 Thread bpalmer
I'm trying to port some replication code from 7.2 -> 7.4 and am running into a block. In the file: /src/backend/tcop/postgres.c My diff was for: void pg_exec_query(char *query_string) { pg_exec_query_string(query_string, whereToSendOutput, QueryContext); } But the pg

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-02 Thread Gaetano Mendola
Joshua D. Drake wrote: I seen that the configure is done with: --with-krb5=/usr. make sure that you have krb5-devel installed. Unfortunately yes: # rpm -qa | grep krb5 krb5-devel-1.2.7-14 krb5-server-1.2.7-14 krb5-server-1.2.7-10 pam_krb5-1.60-1 krb5-workstation-1.2.7-10 krb5-libs-1.2.7-10 kr

Re: [HACKERS] Copyright (C) 1996-2002

2003-12-02 Thread Jean-Michel POURE
Le Mardi 25 Novembre 2003 07:32, Randolf Richardson a Ãcrit : > I'm curious, has anyone consulted with a lawyer on this? Yes, the lawyer concluded that the number "2003" had been both registered as a trademark and a patented invention. Therefore, it is very likely that Humanity will be able to j

Re: [PATCHES] [HACKERS] Index creation takes for ever

2003-12-02 Thread Manfred Koizar
On Mon, 01 Dec 2003 13:32:10 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: >Manfred Koizar <[EMAIL PROTECTED]> writes: >> comparetup_index() compares two IndexTuples. The structure >> IndexTupleData consists basically of not much more than an ItemPointer, >> and the patch is not much more than adding