| Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
| Name: postgresql14-orafce | Distribution: openSUSE Tumbleweed |
| Version: 4.14.1+git0.48e67e7 | Vendor: openSUSE |
| Release: 2.1 | Build date: Fri Feb 14 13:06:20 2025 |
| Group: Productivity/Databases/Tools | Build host: reproducible |
| Size: 552338 | Source RPM: postgresql14-orafce-4.14.1+git0.48e67e7-2.1.src.rpm |
| Packager: http://bugs.opensuse.org | |
| Url: https://github.com/orafce/orafce | |
| Summary: Implementation of some Oracle functions into PostgreSQL | |
The goal of this project is implementation some functions from Oracle database. Some date functions (next_day, last_day, trunc, round, ...) are implemented now. Functionality was verified on Oracle 10g and module is useful for production work.
MIT
* Fri Feb 14 2025 Reinhard Max <max@suse.com>
- Stop building for EOL postgresql12.
* Fri Dec 20 2024 emiliano.langella@suse.com
- Update to version 4.14.1+git0.48e67e7:
* prepare for 4.14.1
* introduce new github workflows
* Update README.asciidoc
* fix regress tests on msvc
* DiffUtils from gnuwin32 are necessary for ninja test on msvc
* info about using meson
* fix meson.build for msvc
* support for meson
* Tue Nov 26 2024 emiliano.langella@suse.com
- Update to version 4.14.0+git0.f0ecbd3:
* prepare for 4.14.0
* prepare for 4.13.6
* remove invalid alternative results of dbms_random test
* fix dbms_random test for pg 12
* fix error when orafce's triggers was executed on table with dropped columns
* update year in info comment
* fix white chars
* Oracle does switch of low, high when low is higher than high arg of dbms_random.value. Do this in orafce too. Some cleaning in related regress tests. Attention: this change breaks alternative expected results.
* regress test for new nvl function
* fix Makefile and return type previously added nvl function
* Add support to nvl(double precision, integer) and to_date(integer, text).
* Tue Oct 22 2024 emiliano.langella@suse.com
- Update to version 4.13.5+git0.ab95f82:
* prepare for 4.13.5
* export orafce_sys_extract_utc and orafce_sys_extract_utc_oracle_date for win build
* With Oracle passing en empty string to the to_date(txt, fmt) function returns NULL whereas PostgreSQL returns '0001-01-01 BC'. This true whatever is the format passed as second argument. Change the behavior of function to_date(txt, fmt) to mimic Oracle.
* Tue Oct 15 2024 emiliano.langella@suse.com
- Update to version 4.13.4+git0.8f3f211:
* prepare for 4.13.4
* fix update script from 4.12 to 4.13
* prepare for 4.13.3
* umask is usually entered as octec number, then read it as octec number
* Tue Oct 15 2024 mrueckert@suse.de
- Update to version 4.13.4+git0.8f3f211:
* prepare for 4.13.4
* fix update script from 4.12 to 4.13
* Tue Oct 15 2024 mrueckert@suse.de
- Update to version 4.13.3+git0.0bf0f15:
* prepare for 4.13.3
* umask is usually entered as octec number, then read it as octec number
* Sat Sep 28 2024 Marcus Rueckert <mrueckert@suse.de>
- enable pg17
* Sat Sep 28 2024 mrueckert@suse.de
- Update to version 4.13.2+git0.f8f8700:
* prepare for 4.13.2
* fix missing update of control file and regress tests
* Wed Sep 25 2024 emiliano.langella@suse.com
- Update to version 4.13.0+git3.25d74aa:
* Fix description of GUC orafce.varchar2_null_safe_concat
* Fix description of GUC orafce.varchar2_null_safe_concat
* fix regress tests
* Update README.asciidoc
* Fix documentation formatting.
* Add description of to_date(text,text) function and the error reported due to Oracle bug.
* Update regression test result with error message change.
* Raise an error when Oracle's to_date() bugs are reached. This concern dates before 1582-10-05 ('J2299159') usinf the 'J' format and dates before 1100-03-01 that cannot be verified due to a bug in Oracle.
* remove obsolete sql signature of dbms_alert.defered_signal
* update NEWS
* Remove the BC part of the Oracle like Julian Day date
* Fix wrong number of days add to julian day in to_char(text, text) function and add pg_catalog FQDN to the to_date() builtin function called. Add regression test.
* remove obsolete file
* Fix TO_DATE(text, text) function with the 'J' (Julian day) formatting. For Oracle this is the number of days since January 1, 4712 BC whereas for PostgreSQL this is the number of days since November 24, 4714 BC.
* Mon Sep 09 2024 Marcus Rueckert <mrueckert@suse.de>
- disable pg11 builds as we will remove the EOL package soon
* Wed Aug 28 2024 emiliano.langella@suse.com
- Update to version 4.11.0+git0.72e1417:
* - refresh sql parser - fix warning: no previous declaration for ‘orafce_sql_yynerrs’ [-Wmissing-variable-declarations]
* fix format doc
* fix format doc
* fix format doc
* fix sys_extract_utc calculation for pg12
* regress tests for sys_extract_utc
* fix another warnings related to master - after drop support for pg12, the code for pipe and alert needs refactoring
* fix warnings related to master build
* fix build pg12
* support of sys_extract_utc function
* Mon Jun 03 2024 emiliano.langella@suse.com
- Update to version 4.10.3+git0.e050dd6:
* prepare for 4.10.3
* security check can be ignored when the value is configured by ALTER SYSTEM, and in reload the system is not in transactional state. fix #270
* Thu May 23 2024 emiliano.langella@suse.com
- Update to version 4.10.2+git0.8d10ace:
* prepare for 4.10.2
* When load of orafce was triggered by using some orafce's function by nonprivileged user, then the check orafce_umask_check_hook fails and breaks loading of Orafce. This fix disable check in initialization time when orafce_umask is set to default value (so the check can be disabled).
* prepare for 4.10.1
* regress tests for issues #266 and #267
* fix obsolete (and broken) implementation of dbms_assert.qualified_sql_name
* fix not correct test of identifier validity in dbms_assert.simple_sql_name
* Add an alternative output for test dbms_random (Illumos)
* Mon Apr 29 2024 emiliano.langella@suse.com
- Update to version 4.10.0+git0.cfdcdf2:
* remove whitechar
* Allow to set umask for utl_file.fopen by setting orafce.umask. This setting is allowed only for user with rights of role orafce_set_umask.
* Thu Apr 11 2024 emiliano.langella@suse.com
- Update to version 4.9.4+git0.6f3b83a:
* prepare for 4.9.4
* after any fclose call, the pointer FILE should not be used ever
* after any fclose call, the pointer FILE should not be used ever
* Thu Mar 07 2024 emiliano.langella@suse.com
- Update to version 4.9.3+git0.6adbd66:
* prepare for 4.9.3
* fix regress tests
* fix broken handling null in dbms_sql.column_value
* fix build for master (pg17+)
* possibility to raise error inside trigger functions
* fix regress test on fc40
* Thu Feb 08 2024 emiliano.langella@suse.com
- Update to version 4.9.2+git0.17c9ce4:
* prepare for 4.9.2
* Update the usage example for DBMS_OUTPUT package.
* fix memory issues in plvlex.token function
* fix sqlscanner typecast has not assigned yylval.val.str field
* should not to crash, when we try to read column without data
* fix regress tests
* dont't try to free byref null variable
* result_cxt schema can be used only after successfull execution #254 (second part)
* fix crash of dbms_sql.execute when bound array variable is NULL #254
* added an alternative output for test dbms_random (Windows)
* Mon Jan 29 2024 emiliano.langella@suse.com
- Update to version 4.9.1+git0.1071eb6:
* prepare for 4.9.1
* fix white spaces in regress tests
* fix formatting issues from previous commit
* dbms_random.string Enhancement #252
* Tue Jan 02 2024 emiliano.langella@suse.com
- Update to version 4.9.0+git0.18d82db:
* prepare for 4.9.0
* Fix REGEXP_COUNT and REGEXP_SUBSTR function to have the same behavior than Oracle with newline characters and the use of dot in the pattern.
* Added a test case about dbms_sql.debug_cursor
* don't try to show content of variable when it is null. fix issue #247
* mark some func parallel safe
* When third argument of substr function is zero, then oracle returns null, but orafce returns empty string. This commit forces oracle's behaviour by default, but allows (by compatibility option orafce.using_substring_zero_width_in_substr set original orafce's behaviour. fix issue #240
* copy to_char(text) from orafce--4.7--4.8.sql to orafce--4.8.sql
* mark some func parallel safe; fix makefile
* add orafce--4.8.sql (rename orafce--4.7.sql)
* add func: to_char(text)
* mark lpad, rpad, to_char, to_number parallel safe
* mark btrim,ltrim,rtrim parallel(because not support postgres version < 9.6, so directly change it)
* doesn't support postgresql extensions
* Create c-cpp.yml
* Fri Oct 13 2023 emiliano.langella@suse.com
- Update to version 4.7.0+git1.fca4108:
* changes related to msvc 2019 build
* remainder function should be marked STRICT (#225)
* Thu Sep 28 2023 Marcus Rueckert <mrueckert@suse.de>
- enable pg 16
* Mon Sep 25 2023 emiliano.langella@suse.com
- Update to version 4.6.1+git0.8785767:
* prepare for 4.6.1
* return back dbms_alert_defered_signal header necessary for upgrade - #231
* Fri Sep 08 2023 emiliano.langella@suse.com
- Update to version 4.6.0+git0.6020b1e:
* fix the comment error
* Fix a condition to make code reachable
* fix regress tests on mswin
* remove white chars
* describe changes in dbms_alert
* Mon Aug 07 2023 emiliano.langella@suse.com
- Update to version 4.5.0+git8.b3ad258:
* better comment
* fix issue reported by cppcheck, all tests passed
* test passed except pg 17
* fix
* code cleaning
* formatting
* use condition variable for synchronization of dbms_alert waiting on signal
* formatting
* typo
* prepare for 4.5.0
* detect different identity of pipe after wakeup
* fix issues reported by cppcheck
* decrease timeout as protection against deadlocks
* using ConditionVariables for synchronization dbms_pipe writer and dbms_pipe reader
* fix isses reported by cppcheck
* fix issues reported by cppcheck
* Mon Jul 10 2023 emiliano.langella@suse.com
- Update to version 4.4.0+git0.eb5513d:
* update version info and year
* regexp_x functions should be immutable
* Thu Jun 01 2023 emiliano.langella@suse.com
- Update to version VERSION_4.3.0+git0.fac8b9c:
* fix regress test for dbms_random.string
* add chars '\' and '~' to list of printable chars for function dbms_random.string
* fix dbms_random should not be immutable (Issue #222)
* Mon May 01 2023 emiliano.langella@suse.com
- Update to version 4.2.6+git0.86d7f4c:
* prepare for 4.2.6
* fix corner case of instr function (be fully compatible with Oracle) see #221
* prepare for 4.2.5
* fix copy/paste bug
* use MoveFileEx function instead replace function on win32
* Sun Apr 02 2023 emiliano.langella@suse.com
- Update to version 4.2.4+git0.2499240:
* prepare for 4.2.4
* fix issue #218
* prepare for 4.2.3
* completation of support unicode API for IO operation on WIN32
* use wide char file API for win
* prepare for 4.2.2
* win win32 build
* Tue Mar 14 2023 emiliano.langella@suse.com
- Update to version 4.2.1+git0.82ab40c:
* prepare for 4.2.1
* fix build Postgres 15
* update copyright year
* formmatting, removing white spaces
* typo
* update copyright year
* Use function _wfopen on WIN32 platform instead fopen. It should to work with file names where are used not ANSI chars.
* fix PostgreSQL 15 build
* fix build for PostgreSQL 16
* Update README.asciidoc
* possibility to use gen_random_uuid for making result in sys_guid function
* fix build for all supported pg releases
* implementation of oracle.sys_guid() based on uuid-ossp
* Tue Mar 14 2023 Martin Pluskal <mpluskal@suse.com>
- Update to version 4.2.1+git0.82ab40c:
* prepare for 4.2.1
* fix build Postgres 15
* update copyright year
* formmatting, removing white spaces
* typo
* update copyright year
* Use function _wfopen on WIN32 platform instead fopen. It should to work with file names where are used not ANSI chars.
* fix PostgreSQL 15 build
* fix build for PostgreSQL 16
* Update README.asciidoc
* possibility to use gen_random_uuid for making result in sys_guid function
* fix build for all supported pg releases
* implementation of oracle.sys_guid() based on uuid-ossp
* Fri Feb 10 2023 Emiliano Langella <emiliano.langella@suse.com>
- Added "Name:" tag.
* Tue Jan 31 2023 Marcus Rueckert <mrueckert@suse.de>
- remove pg 10 support
* Tue Jan 31 2023 Marcus Rueckert <mrueckert@suse.de>
- enable pg 15
* Tue Jan 31 2023 mrueckert@suse.de
- Update to version 4.1.1+git0.519b5b5:
* prepare for 4.1.1
* build on master (16) branch
* use adv lock to synchronize start of pipe and alert tests
* add connect by level < num in migration docs
* Hierarchical Query identifys the leaves
* Update the connect_by_root example, for better semantics
* fix: CONNECT_BY_ROOT in hierarchical query is converted to WITH RECURSIVE syntax
* the table [200~utl_file.utl_file_dir is dumpable
* fix compilation against pg master
* prepare for 4.0.2
* fix -wextra warnings
* fix shadowed variable varning
* fix msvc build for PostgreSQL 14
* fix build for pg16
* fix META file and prepare for 4.0.1
* to_multi_byte and to_single_byte support euc_cn(gb2312)
* add oracle sql migration : CONNECT_BY_ROOT
* fix oracle connect by
* prepare for 4.0.0 release
* remove obsolete ref on orafce_sql
* rename shadow variable
* initial merge of dbms_sql from orafce_sql
* other cleaning after removing support for unsupported pg releases
* increase version
* remove support for PostgreSQL 10 and older
* Fix database creation during installchecks for ICU cluster
* fix dbms_output.serveroutput(true) clear the buffer.It conforms to the features of oracle.
* prepare for 3.25.1
* fix calculation of plvstr.is_prefix for negative numeric values - see issue #198
* fix for pre 14 releases
* doc and regress tests
* remove useless func decl
* support for older releases
* initial implementation
* initial
* fix build against master (16) branch
* wrap possible unsupported DDL to dynamic SQL
* specify schema inside definition function tanh
* only set editorconfig
* prepare for 3.24.4
* remove redundant ALTER FUNCTION #191
* prepare for 3.24.3
* PostgreSQL older than 12 doesn't allow ALTER FUNCTION pg_catalog.x SET SCHEMA oracle. Only dirty way by direct modification of system catalogue is possible. see issue #190
* prepare for 3.24.2
* fix missing oracle.mod functions in update scripts
* prepare for 3.24.1
* fix regress nlssort test for PostgreSQL 9.5 without \if command
* Fix race condition during initialization in ora_lock_shmem.
* nlssort: Add a missing call to PG_RE_THROW.
* Limit nlssort test to Linux/glibc systems with en_US.utf8 installed.
* NEWS
* set storage for varchar2 and nvarchar2 to extended strategy
* prepare for 3.23
* fix broken calculation in plvdate_isleapyear function #184
* fix support for pg9.5, fix regress tests for older releases
* prepare for 3.22.1
* Fix read past the end of string in to_sigle_byte().
* Fix dbms_utility.get_time() to use the full range of int32.
* fix readme
* prepare for 3.22.0
* move dbobjects from public and pg_catalog schemas to oracle schema
* moving objects from public and pg_catalog to oracle schema
* move RequestAddinShmemSpace to shmem_request_hook for PostgreSQL 15
* Update sql_migration06.md
* Restore sqlparse.c and sqlparse.h
* Undo comment
* Add comment
* Add Parallel safe to mod function
* Bug fix
* Add mod function for Oracle compatibility
* Fix typos and spelling in docs and error messages
* prepare for 3.21.1
* fix mswin build - regexp functions was not really marked as dllexport due missing include of builtins.h
* remove empty line
* fix of some compatibility issues
* REG_NOSUB is working only on PostgreSQL 15
* workable release for PostgreSQL 15
* modification for compotibility with orafce.regexp_instr
* backport regexp_instr from PostgreSQL 15, use C version instead PLpgSQL for better possibilities of usage regexp API
* prepare for 3.20.0
* Fix regexp_instr() function with occurrence when the same value matching a pattern is found at several place in the string.
* signature of nvl2 function is enhanced to "any", anyelement, anyelement. After this change, the behavior is more close to Oracle. Unfortunatelly - this change can break extension update for some customers that uses nvl2 in views.
* support negative start argument for function substrb. Originally orafce used buildin bytea substr function. Now it recalculate start argument. see issue #172
* prepare for 3.19
* Allow empty string on input of functions to_number and to_date. In this case returns NULL.
* remove white spaces
* replace obsolete CSTRING macro by text_to_csring function
* prepare for 3.18.1
* fix - badly handled fn_extra in oracle.greatest(least) function
* prepare for 3.18.0
* Update README.asciidoc
* Update README.asciidoc
* use older API for iteration over an array. Now, oracle.greatest and oracle.least are working on all supported releases
* remove negative tests related to orafce.greatest because: a) error message is different on supported pg versions, b) the coverage and benefit of these tests is low
* remove two lines from regress tests of greatest due dependency on used collate
* Add documentation for greatest and least functions.
* Update upgrade extension file with the smallint addition.
* Add greatest/least SQL redefinition for smallint Add regression tests fot the two functions.
* Oracle functions LEAST and GREATEST return NULL if at least one of the parameters is NULL. This is not the case for the PostgreSQL equivalent functions which only return NULL when all the parameters are NULL. This patch creates the two functions in the oracle schema to have the same behavior than in Oracle.
* Minor grammatical fix to README.asciidoc
* fix typo in charpad.c
* fix typo in orafce--3.17.sql
* Update Orafce_Documentation_05.md
* Catch dbms_random.string() output variation on Windows
/usr/lib/postgresql14/lib /usr/lib/postgresql14/lib/orafce.so /usr/share/doc/packages/postgresql14-orafce /usr/share/doc/packages/postgresql14-orafce/COPYRIGHT.orafce /usr/share/doc/packages/postgresql14-orafce/INSTALL.orafce /usr/share/doc/packages/postgresql14-orafce/NEWS /usr/share/doc/packages/postgresql14-orafce/README.asciidoc /usr/share/postgresql14 /usr/share/postgresql14/extension /usr/share/postgresql14/extension/orafce--3.10--3.11.sql /usr/share/postgresql14/extension/orafce--3.11--3.12.sql /usr/share/postgresql14/extension/orafce--3.12--3.13.sql /usr/share/postgresql14/extension/orafce--3.13--3.14.sql /usr/share/postgresql14/extension/orafce--3.14--3.15.sql /usr/share/postgresql14/extension/orafce--3.15--3.16.sql /usr/share/postgresql14/extension/orafce--3.16--3.17.sql /usr/share/postgresql14/extension/orafce--3.17--3.18.sql /usr/share/postgresql14/extension/orafce--3.18--3.19.sql /usr/share/postgresql14/extension/orafce--3.19--3.20.sql /usr/share/postgresql14/extension/orafce--3.2--3.3.sql /usr/share/postgresql14/extension/orafce--3.20--3.21.sql /usr/share/postgresql14/extension/orafce--3.21--3.22.sql /usr/share/postgresql14/extension/orafce--3.22--3.23.sql /usr/share/postgresql14/extension/orafce--3.23--3.24.sql /usr/share/postgresql14/extension/orafce--3.24--3.25.sql /usr/share/postgresql14/extension/orafce--3.25--4.0.sql /usr/share/postgresql14/extension/orafce--3.3--3.4.sql /usr/share/postgresql14/extension/orafce--3.4--3.5.sql /usr/share/postgresql14/extension/orafce--3.5--3.6.sql /usr/share/postgresql14/extension/orafce--3.6--3.7.sql /usr/share/postgresql14/extension/orafce--3.7--3.8.sql /usr/share/postgresql14/extension/orafce--3.8--3.9.sql /usr/share/postgresql14/extension/orafce--3.9--3.10.sql /usr/share/postgresql14/extension/orafce--4.0--4.1.sql /usr/share/postgresql14/extension/orafce--4.1--4.2.sql /usr/share/postgresql14/extension/orafce--4.10--4.11.sql /usr/share/postgresql14/extension/orafce--4.11--4.12.sql /usr/share/postgresql14/extension/orafce--4.12--4.13.sql /usr/share/postgresql14/extension/orafce--4.13--4.14.sql /usr/share/postgresql14/extension/orafce--4.14.sql /usr/share/postgresql14/extension/orafce--4.2--4.3.sql /usr/share/postgresql14/extension/orafce--4.3--4.4.sql /usr/share/postgresql14/extension/orafce--4.4--4.5.sql /usr/share/postgresql14/extension/orafce--4.5--4.6.sql /usr/share/postgresql14/extension/orafce--4.6--4.7.sql /usr/share/postgresql14/extension/orafce--4.7--4.8.sql /usr/share/postgresql14/extension/orafce--4.8--4.9.sql /usr/share/postgresql14/extension/orafce--4.9--4.10.sql /usr/share/postgresql14/extension/orafce.control
Generated by rpm2html 1.8.1
Fabrice Bellet, Fri Feb 21 02:22:00 2025