orafce - orafce: [dbms_output] - Fix enable(NULL) to enable the module

From: itagaki(at)pgfoundry(dot)org (User Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: orafce - orafce: [dbms_output] - Fix enable(NULL) to enable the module
Date: 2008-09-26 00:59:08
Message-ID: 20080926005908.1BCD617ADDED@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------

[dbms_output]
- Fix enable(NULL) to enable the module with 1MB buffer.
- Fix put_line() to be restricted by only buffer size, not 2kB.
- Fix get_line() to return 0 as status when succeeded.
- Add a regression test for dbms_output.

[utl_file]
- Fix fclose() and fclose_all() to invalidate file descriptors.
- Fix get_line() to return readable buffers instead of error
when buffer is not enough.
- Add a variation of get_line() with length.
- Add multi-byte verification for input file.
- Supports 50 files (compatible with Oracle10g)

[date functions]
- Fix add_months() for ends of months
- Fix months_between() for ends of months
- Fix next_day(date, text) for short day of the week (like 'sun').
- Add next_day(date, integer), that is undocumented in oracle.
- Add ENABLE_INTERNATIONALIZED_WEEKDAY option to next_day().
Supports weekday-names in English and in Japanese for now.

[others functions]
- Fix concat() for non-text arguments.
- Fix instr() for minus offset.
- Fix nvl2(). It is not an alias of coalesce().
- Add decode() functions.

[infrastructure improvements]
- Add an uninstaller script
- Add some PGDLLIMPORT for Windows build.
- Add some macros and functions for version compatibility.
Now it can be built on 8.2, 8.3 and 8.4dev(2008-09-24).
- Replace \' to '' to avoid warnings of insecure strings.
- Use GET_ARG_TEXT_PP() to avoid unpacking of short text in 8.3.

Modified Files:
--------------
orafce:
Makefile (r1.26 -> r1.27)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/Makefile.diff?r1=1.26&r2=1.27)
README.orafunc (r1.26 -> r1.27)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/README.orafunc.diff?r1=1.26&r2=1.27)
alert.c (r1.13 -> r1.14)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/alert.c.diff?r1=1.13&r2=1.14)
assert.c (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/assert.c.diff?r1=1.2&r2=1.3)
convert.c (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/convert.c.diff?r1=1.2&r2=1.3)
datefce.c (r1.12 -> r1.13)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/datefce.c.diff?r1=1.12&r2=1.13)
file.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/file.c.diff?r1=1.8&r2=1.9)
orafunc.h (r1.11 -> r1.12)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/orafunc.h.diff?r1=1.11&r2=1.12)
orafunc.sql.in (r1.42 -> r1.43)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/orafunc.sql.in.diff?r1=1.42&r2=1.43)
others.c (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/others.c.diff?r1=1.10&r2=1.11)
pipe.c (r1.17 -> r1.18)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/pipe.c.diff?r1=1.17&r2=1.18)
plunit.c (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/plunit.c.diff?r1=1.5&r2=1.6)
plvdate.c (r1.9 -> r1.10)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/plvdate.c.diff?r1=1.9&r2=1.10)
plvstr.c (r1.12 -> r1.13)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/plvstr.c.diff?r1=1.12&r2=1.13)
plvsubst.c (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/plvsubst.c.diff?r1=1.5&r2=1.6)
putline.c (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/putline.c.diff?r1=1.10&r2=1.11)
shmmc.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/shmmc.c.diff?r1=1.8&r2=1.9)
orafce/expected:
files.out (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/expected/files.out.diff?r1=1.2&r2=1.3)
orafunc.out (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/expected/orafunc.out.diff?r1=1.10&r2=1.11)
orafce/sql:
files.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/sql/files.sql.diff?r1=1.2&r2=1.3)
orafunc.sql (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/sql/orafunc.sql.diff?r1=1.10&r2=1.11)

Browse pgsql-committers by date

  From Date Subject
Next Message User Itagaki 2008-09-26 01:11:24 orafce - orafce: Added regression test for dbms_output
Previous Message User Mkz 2008-09-25 10:30:09 pgbouncer - pgbouncer: log changes in 1.2