Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread snpe
Hello, is it planed cursor out of a transaction in 7.4 ? Thanks Haris Peco On Monday 18 November 2002 12:30 am, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Let's just fix it and roll an RC2 with the fix. If not, we can just fix it in 7.3.1 but I see little problem in rolling an

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Tom Lane
snpe [EMAIL PROTECTED] writes: is it planed cursor out of a transaction in 7.4 ? I do not think we will allow cross-transaction cursors ever. What would it mean to have a cross-transaction cursor, anyway? Does it show a frozen snapshot as of the time it was opened? The usefulness of that

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
Haris Peco wrote: On Monday 18 November 2002 02:38 pm, Tom Lane wrote: snpe [EMAIL PROTECTED] writes: is it planed cursor out of a transaction in 7.4 ? I do not think we will allow cross-transaction cursors ever. What would it mean to have a cross-transaction cursor, anyway? Does

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote: Haris Peco wrote: On Monday 18 November 2002 02:38 pm, Tom Lane wrote: snpe [EMAIL PROTECTED] writes: is it planed cursor out of a transaction in 7.4 ? I do not think we will allow cross-transaction cursors ever. What

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Zeugswetter Andreas SB SD
is it planed cursor out of a transaction in 7.4 ? I do not think we will allow cross-transaction cursors ever. What would it mean to have a cross-transaction cursor, anyway? Does it show a frozen snapshot as of the time it was opened? The usefulness of that seems awfully low in

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
On Monday 18 November 2002 05:46 pm, Bruce Momjian wrote: Haris Peco wrote: great. Is it possible with savepoints next : when am I in transaction and any command is error - only this command is lost and I continue normal ? Yes, that will be part of it. I am working on my

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
Haris Peco wrote: On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote: Haris Peco wrote: On Monday 18 November 2002 02:38 pm, Tom Lane wrote: snpe [EMAIL PROTECTED] writes: is it planed cursor out of a transaction in 7.4 ? I do not think we will allow

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Haris Peco
On Monday 18 November 2002 05:38 pm, Bruce Momjian wrote: Haris Peco wrote: On Monday 18 November 2002 03:45 pm, Bruce Momjian wrote: Haris Peco wrote: On Monday 18 November 2002 02:38 pm, Tom Lane wrote: snpe [EMAIL PROTECTED] writes: is it planed cursor out of a

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
Haris Peco wrote: great. Is it possible with savepoints next : when am I in transaction and any command is error - only this command is lost and I continue normal ? Yes, that will be part of it. I am working on my proposal today. Fine.What about cursor out of a transaction ?

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-18 Thread Bruce Momjian
Haris Peco wrote: On Monday 18 November 2002 05:46 pm, Bruce Momjian wrote: Haris Peco wrote: great. Is it possible with savepoints next : when am I in transaction and any command is error - only this command is lost and I continue normal ? Yes, that will be part of

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-17 Thread Tom Lane
snpe [EMAIL PROTECTED] writes: When I call DECLARE CURSOR out of transaction command success, but cursor is not created Reference manual say that this get error : ERROR: DECLARE CURSOR may only be used in begin/end transaction blocks Oops. I removed that test on 21-Oct as part of this

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-17 Thread Bruce Momjian
Let's just fix it and roll an RC2 with the fix. If not, we can just fix it in 7.3.1 but I see little problem in rolling an RC2. --- Tom Lane wrote: snpe [EMAIL PROTECTED] writes: When I call DECLARE CURSOR out of

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-17 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Let's just fix it and roll an RC2 with the fix. If not, we can just fix it in 7.3.1 but I see little problem in rolling an RC2. Since Marc hasn't yet announced RC1, I think we could get away with just a quick fix and re-roll of RC1 ...

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-17 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Let's just fix it and roll an RC2 with the fix. If not, we can just fix it in 7.3.1 but I see little problem in rolling an RC2. Here is the patch I am testing (in current sources; I don't think it needs any adjustments for REL7_3, but haven't tried to

Re: [HACKERS] [GENERAL] DECLARE CURSOR

2002-11-17 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Let's just fix it and roll an RC2 with the fix. If not, we can just fix it in 7.3.1 but I see little problem in rolling an RC2. Since Marc hasn't yet announced RC1, I think we could get away with just a quick fix and re-roll of RC1