[PATCHES] CONNECT BY for 8.3 ...

2007-12-27 Thread Hans-Juergen Schoenig
good morning everybody,this is a working version of evgen potemkin's patch implementing CONNECT BY. it has been ported to 8.3 and it seems to work flawlessly with CVS head.it is not supposed to be included into 8.4 but i guess it might be useful for some people.there are still some limitations and

[PATCHES] Fix ecpg SQL CONNECT with variable user name

2007-12-27 Thread ITAGAKI Takahiro
Here is a fix for ecpg in 8.3 when the user name is specified by variables on SQL CONNECT. When we compile the following statement in ecpg: EXEC SQL CONNECT TO :dbname USER :usrname IDENTIFIED BY :usrpass; ecpg in 8.2 compiles it correctly. { ECPGconnect(__LINE__, 0, dbname , usrname ,

Re: [PATCHES] [HACKERS] Unworkable column delimiter characters for COPY

2007-12-27 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: I think at minimum we need to forbid b, f, n, r, t, v, which are the control character representations currently recognized by COPY. But I'm tempted to make it reject all 26 lower-case ASCII letters, as a form

Re: [PATCHES] [HACKERS] Unworkable column delimiter characters for COPY

2007-12-27 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: It seems we ought to forbid delimiter from matching CSV quote or escape characters. I'll let you clean up that case though... This should do the trick - I'll apply it tomorrow. A couple thoughts: * This test needs to appear further