[HACKERS] Procedures returning row sources

2002-03-27 Thread Christopher Kings-Lynne
Jan wrote: > There is a way to return anything. The problem in PostgreSQL > is to actually USE it. > > Our idea originally was to extend the capabilities of a > rangetable entry. Currently, rangetable entries can only > hold a relation, which is a table or a view.

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > imho we should disable *any* special handling of posts to the mailing > lists. It would be interesting to try that for awhile and see if the cure is worse than the disease or not. How many clueless "uns*bscr*be" requests will hit the lists if there a

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Thomas Lockhart
> > > The fact this is done silently is clearly unacceptable. > > Agreed. Curiously, though, I've always gotten notifications whenever > > any of my messages got held up for moderator approval. Seems like there > > are two questions for Marc here: > > 1. Why is the system failing to notify some

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Christopher Kings-Lynne
> > The fact this is done silently is clearly unacceptable. > > Agreed. Curiously, though, I've always gotten notifications whenever > any of my messages got held up for moderator approval. Seems like there > are two questions for Marc here: > > 1. Why is the system failing to notify some peopl

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Christopher Kings-Lynne wrote: >> I've always has this suspicion that every time I send an email with 'SET >> NULL' in the subject it doesn't get through!!! I've even commented on that >> on the list before! > The fact this is done silently is clearly

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Bruce Momjian
Christopher Kings-Lynne wrote: > > checking the moderator-to-approve listing for you, here are the reason(s): > > > > Reason: GLOBAL ADMIN HEADER: /^subject:\s*set\b/i matched "Subject: SET" > > OH MY GOD!!! > > I've always has this suspicion that every time I send an email with 'SET > NULL' in

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Christopher Kings-Lynne
> checking the moderator-to-approve listing for you, here are the reason(s): > > Reason: GLOBAL ADMIN HEADER: /^subject:\s*set\b/i matched "Subject: SET" OH MY GOD!!! I've always has this suspicion that every time I send an email with 'SET NULL' in the subject it doesn't get through!!! I've eve

Re: [HACKERS] compile bug in HEAD?

2002-03-27 Thread Peter Eisentraut
Neil Conway writes: > I'm curious; why is this "not the right fix"? According to the manpage: > > -lturns on maximum compatibility with the original > AT&T lex implementation. Note that this does not > mean full compatibility. Use of this option > costs a considerable a

Re: [HACKERS] compile bug in HEAD?

2002-03-27 Thread Neil Conway
On Wed, 2002-03-27 at 11:06, Peter Eisentraut wrote: > If someone is really bored out of their mind, at least one of these > warnings can be gotten rid of by not using the -l option to flex. That > might be desirable for other reasons, too, one of which is improved speed. > > No, just removing -

[HACKERS] Always the same ecpg bug - please (re)apply patch

2002-03-27 Thread Nicolas Bazin
Here is the description:   When a macro is replaced by the preprocessor, pgc.l reaches a end of file, which is not the actual end of the file. One side effect of that is that if you are in a ifdef block, you get a wrong error telling you that a endif is missing.   This patch corrects pgc.l an

Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1

2002-03-27 Thread Nicolas Bazin
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Bruce Momjian" <[EMAIL PROTECTED]> Cc: "Nicolas Bazin" <[EMAIL PROTECTED]>; "PostgreSQL-development" <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 2:30 AM Subject: Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixwa

Re: [HACKERS] Problem with do_quote_ident()

2002-03-27 Thread Jan Wieck
Bruce Momjian wrote: > I see in quote.c::do_quote_ident(): > >*cp2++ = '"'; >while (len-- > 0) >{ > if (*cp1 == '"') > *cp2++ = '"'; > if (*cp1 == '\\') > *cp2++ = '\\'; > *cp2++ = *cp1++; >} >*cp2++ = '"'; > > I am confused by

[HACKERS] Problem with do_quote_ident()

2002-03-27 Thread Bruce Momjian
I see in quote.c::do_quote_ident(): *cp2++ = '"'; while (len-- > 0) { if (*cp1 == '"') *cp2++ = '"'; if (*cp1 == '\\') *cp2++ = '\\'; *cp2++ = *cp1++; } *cp2++ =

Re: [HACKERS] RI triggers and schemas

2002-03-27 Thread Stephan Szabo
On Wed, 27 Mar 2002, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > The advantage that I see is that we get more control over the time > > qualifications used for tuples which may come into play for match > > partial. I'm not sure that it's worth the effort to try doing it > > t

[HACKERS] escape sequence conflicting w/ backup (i.e. pg_dump)

2002-03-27 Thread Matias Klein
I have a postgresql DB that contains a lot of HTML code. As you know, HTML contains numerous backslash( \ ) characters. When I use pg_dump to backup the DB I get a "CopyReadAttribute: end of record marker corrupted" error. Is there any way to circumvent this problem so that I can backup a DB

Re: [HACKERS] Rough sketch for locale by default

2002-03-27 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > [ good stuff snipped ] > ... Also, it prevents accidentally changing the locale when you > (or someone else) fiddle with your environment variables. If I follow this correctly, the behavior would be that PG would not pay attention to *any* LC_xxx en

[HACKERS] Rough sketch for locale by default

2002-03-27 Thread Peter Eisentraut
I've mentioned a while ago that I wanted to make the --enable-locale switch the default (and remove the switch), and make the choice of locale-awareness a run-time choice. Here is how that might work. I've already explained how I plan to get around the performance problems, so this will just focu

Re: [HACKERS] Rolling v7.2.1 ...

2002-03-27 Thread Peter Eisentraut
Alvaro Herrera writes: > I've been trying to generate HTML from the SGML source here in Mandrake > Linux 8.1, and it needs some patching (Mdk Linux puts collateindex.pl in > /usr/bin rather that $DOCBOOKSTYLE/bin). I'll look at your patches soon. I've had some other ideas that I'd like to weave

Re: [HACKERS] Problem with reloading groups in pg_hba.conf

2002-03-27 Thread Bruce Momjian
Peter Eisentraut wrote: > Tom Lane writes: > > > I don't think GRANT CONNECT fits into our setup at all. I also doubt > > that it will be needed very much once we have schemas. > > People have many times asked for a way to alter the connection settings > from within the database. For instance,

Re: [HACKERS] compile bug in HEAD?

2002-03-27 Thread Peter Eisentraut
Bruce Momjian writes: > Christopher Kings-Lynne wrote: > > I don't think this is me... > > > > gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error -I > > ./../include -I. -I../../../../src/include -DMAJOR_VERSION=2 -DMINOR_VERSIO > > N=10 -DPATCHLEVEL=0 -DINCLUDE_PATH=\"/ho

Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1

2002-03-27 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Yes, the patch replaces pow(8,*) with a lookup table of 4 8^X values. > So SCO provides a library you can't link to? Or you can't mix *.so > libraries and static *.a libraries? I am inclined ot add this patch to > the doc/FAQ_SCO file. We really try

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Thomas Lockhart
Vince Vielhaber wrote: > > On Wed, 27 Mar 2002, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > > > > checking the moderator-to-approve listing for you, here are the reason(s): > > > > > > Reason: GLOBAL ADMIN HEADER: /^subject:\s*set\b/i matched "Subject: SET" > > OK, but should poster

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Vince Vielhaber
On Wed, 27 Mar 2002, Bruce Momjian wrote: > Marc G. Fournier wrote: > > > > checking the moderator-to-approve listing for you, here are the reason(s): > > > > Reason: GLOBAL ADMIN HEADER: /^subject:\s*set\b/i matched "Subject: SET" > > > > OK, but should posters get email stating it is in the app

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Bruce Momjian
Marc G. Fournier wrote: > > checking the moderator-to-approve listing for you, here are the reason(s): > > Reason: GLOBAL ADMIN HEADER: /^subject:\s*set\b/i matched "Subject: SET" > OK, but should posters get email stating it is in the approval queue? He clearly didn't, and I don't either, but

Re: [HACKERS] RI triggers and schemas

2002-03-27 Thread Alex Hayward
On Tue, 26 Mar 2002, Stephan Szabo wrote: > > On Tue, 26 Mar 2002, Jan Wieck wrote: > > > Tom Lane wrote: > > > I think the existing scheme of generating the plan during first use > > > in a particular backend is fine. At least as long as we're sticking > > > with standard plans at all ... IIRC

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Marc G. Fournier
checking the moderator-to-approve listing for you, here are the reason(s): Reason: GLOBAL ADMIN HEADER: /^subject:\s*set\b/i matched "Subject: SET" On Wed, 27 Mar 2002, Christopher Kings-Lynne wrote: > I just sent in this email and it will appear immediately in the list. > > Somewhat earlier,

Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1

2002-03-27 Thread Nicolas Bazin
- Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Nicolas Bazin" <[EMAIL PROTECTED]> Cc: "PostgreSQL-development" <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 10:21 PM Subject: Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1 > > Thanks. This i

Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware 7.1.1

2002-03-27 Thread Bruce Momjian
Thanks. This is exactly the detail I needed. Let me comment on each item. Nicolas Bazin wrote: > Bruce, > > The reason to move the socket library is that during configuration script > execution, the binary created core dumps if not in the order I gave. You can > check in the port list, some

Re: [HACKERS] Mailing List Question

2002-03-27 Thread Bruce Momjian
Christopher Kings-Lynne wrote: > I just sent in this email and it will appear immediately in the list. > > Somewhat earlier, I have submitted a 25kb patch and then a 5kb gzipped > version of that patch to -hackers and -patches - it has not yet appeared on > the list. > > What's going on? Do pos

Re: [HACKERS] initdb dies during IpcSemaphoreCreate under BSD jail

2002-03-27 Thread Alex Hayward
On Wed, 27 Mar 2002, Tom Lane wrote: > "Joel Burton" <[EMAIL PROTECTED]> writes: > >> This will allow you to run a single postgres in a single jail only one > >> user would have access to it. If you try to run more then one it will > >> try to use the same shared memory and crash. > > > Is this,

[HACKERS] Linux/mips compile: [Fwd: Bug#139003: a little bit more isneeded...]

2002-03-27 Thread Oliver Elphick
-Forwarded Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Bug#139003: a little bit more is needed... Date: 27 Mar 2002 00:21:18 -0800 reopen 139003 thanks Looks like a small patch is needed as well to do the right thing on Linux. The patch enables

Re: [HACKERS] contrib/tree/README.tree

2002-03-27 Thread Christopher Kings-Lynne
> I don't rememeber we have submitted this module :-) Doh - sorry!!! I just extracted it from your tar.gz into my contrib - it's NOT in CVS! Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command