Re: [HACKERS] troubleshooting pointers

2002-05-11 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Tom Lane wrote: It's not unlikely that those issues are exactly due to not having rescan handled properly. What misbehavior are you seeing? Hmm, that might just be it. When I select from a view based on a function which returns a base type, I only

Re: [HACKERS] Native Win32, How about this?

2002-05-11 Thread cbbrowne
A binary version of PostgreSQL for Windows should not use the cygwin dll. I know and understand there is some disagreement with this position, but in this I'm sure about this. That may ultimately be desirable. In the short term, it is likely preferable to use cygwin. It is only necessary to

Re: [HACKERS] Nested transactions RFC

2002-05-11 Thread Tom Lane
Manfred Koizar [EMAIL PROTECTED] writes: TransactionId GetParentXact(TransactionId xnum) uses pg_subtrans to find the parent transaction of xnum. This is not only extremely expensive, but in practice would cause infinite recursion: any attempt to validate the commit state of a row in

Re: [HACKERS] Set Returning Functions (SRF) - request for patch review and comment

2002-05-11 Thread Ian Barwick
On Monday 06 May 2002 18:51, Joe Conway wrote: (...) Request for help: - So far I've tested with SQL and C functions. (...) Can you post an example of a function in C? (I'm trying out your patch from Friday). Thanks, Ian Barwick ---(end of

Re: [HACKERS] bug? in current cvs with bigint datatype

2002-05-11 Thread Tom Lane
Barry Lind [EMAIL PROTECTED] writes: create table test (cola bigint); update test set cola = 100; ERROR: column cola is of type 'bigint' but expression is of type 'double precision' You will need to rewrite or cast the expression dtoi8 is currently marked not proimplicit.

Re: [HACKERS] internal voting

2002-05-11 Thread Nigel J. Andrews
[Note, I've changed the headers so everyone on the original distribution list is getting a copy via Bcc, including -hackers. It was the simplest way I could think of making certain the discussion moved to -interfaces as Marc requested.] On Sat, 11 May 2002, Bartus Levente wrote: ... I think,

Re: [HACKERS] Nested transactions RFC

2002-05-11 Thread Manfred Koizar
Tom, reading my message again and your response, I see, that some points were a bit unclear. On Fri, 10 May 2002 13:12:21 +0200, I wrote: |if it is acceptable for subtransactions to use up transaction numbers, Of course, use up is nonsense, as it sounds like use all available; this should have

Re: [HACKERS] Set Returning Functions (SRF) - request for patch review

2002-05-11 Thread Joe Conway
Ian Barwick wrote: On Monday 06 May 2002 18:51, Joe Conway wrote: (...) Request for help: - So far I've tested with SQL and C functions. (...) Can you post an example of a function in C? (I'm trying out your patch from Friday). Thanks, Ian Barwick See

Re: [HACKERS] troubleshooting pointers

2002-05-11 Thread Joe Conway
Tom Lane wrote: Um, that's probably not it then. Rescan would only come into play for a plan node that's being used as the inside of a join, or some other contexts more complicated than this. A simple view ought to make no difference at all in the generated plan --- perhaps there's some bit