-
Notifications
You must be signed in to change notification settings - Fork 8
/
CHANGELOG
162 lines (137 loc) · 6.11 KB
/
CHANGELOG
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
Revision history for firebird_fdw
1.4.0 2024-05-11
- Support for PostgreSQL 17 added
- Basic support for UUID datatype added
- Proper support for Firebird TIME/TIMESTAMP datatypes added
- Support for Firebird TIME WITH TIME ZONE / TIMESTAMP WITH TIME ZONE
datatypes added
- Support for importing Firebird INT128 datatype added
- Import Firebird FLOAT as PostgreSQL REAL
- Fix generated columns support
1.3.1 2023-06-22
- Support for PostgreSQL 16 added
1.3.0 2022-12-28
- Support for PostgreSQL 15 added
- Support for PostgreSQL 9.3/9.4 removed
- Basic support for TRUNCATE (PostgreSQL 14 )
- Support for batch inserts via COPY added (PostgreSQL 14 )
- Map some PostgreSQL server encodings to the Firebird equivalent
where no Firebird encoding alias exists
- Various fixes and improvements for IMPORT FOREIGN SCHEMA
1.2.3 2022-02-11
- Fix bug in rescan handling
- Adapt TAP tests to support PostgreSQL 15
1.2.2 2021-09-15
- Invalid Firebird server port numbers will be rejected
- Enable provision of custom Firebird port for TAP tests
- Support PostgreSQL 14
- Adapt for API changes introduced in PostgreSQL 11
- Support for versions earlier than PostgreSQL 9.3 removed
- Ensure non-superusers can execute firebird_version()
1.2.1 2020-10-21
- Fix builds for recent Fedora versions
1.2.0 2020-10-17
- Add support for PostgreSQL 13
- Add support for generated columns (PostgreSQL 12 and later)
- Add support for COPY and partition tuple routing (PostgreSQL 11 and later)
- Add table/column option "quote_identifier"
- Add server option "quote_identifiers"
- Have IMPORT FOREIGN SCHEMA add "quote_identifier" where appropriate
- Add support for implicit boolean columns
- Push down boolean tests in WHERE clauses where possible
- Add function firebird_fdw_server_options()
- Add function firebird_version()
- When analyzing a foreign table, only retrieve the columns defined in
that table
- Have EXPLAIN for a remote modify show the Firebird query used
- If a remote query fails, log the query as CONTEXT
- Explicitly reject INSERT with ON CONFLICT clause
- Fix UPDATE statements where a BEFORE ROW UPDATE trigger is present
- Apply CREATE SERVER's "port" option, if provided
- Prevent tables defined as queries from being set as "updatable = 'true'"
1.1.0 2019-05-31
- Add utility function "firebird_fdw_close_connections()"
- Add utility function "firebird_fdw_diag()"
- Adapt code to deal with tuple-level OID removal in PostgreSQL 12
- Support for heap access method changes in PostgreSQL 12
1.0.0 2018-11-09
- Support Firebird BOOLEAN datatype (Firebird 3.0 and later)
- Improve "IMPORT FOREIGN SCHEMA" implementation
- Add table option "estimated_row_count"
- Improve handling of foreign tables defined as Firebird queries
- Support PostgreSQL 11
- Adapt code to compile against current PostgreSQL HEAD
- Avoid segfault if not all expected Firebird connection parameters
were supplied
0.5.0 2018-10-12
- Support triggers on foreign tables (PostgreSQL 9.4 and later)
- Support Firebird BLOB datatype (TEXT subtype only)
0.4.0 2018-10-02
- Add function firebird_fdw_version()
- Add TAP tests
- Fix bug in INSERT ... RETURNING ...
- Miscellaneous minor bug fixes and code cleanup
0.3.0 2018-04-22
- Support PostgreSQL 9.6 and 10
- Add support for IMPORT FOREIGN SCHEMA (PostgreSQL 9.5 and later)
- Ensure tables defined with the 'query' option actually work
- Automatically reconnect if Firebird goes away
- Update function calls for changes in libfq 0.2.0
- Improve SIGINT handling
- Improve error message handling
- Fix memory error when generating connection string
- Fix crash when multibyte string overflows (GitHub #5)
- Report transaction errors as actual errors; log harmless
unhandled transaction types as DEBUG rather than as WARNING
- General code cleanup
0.2.5 2014-02-11
- Add RPM spec files for openSUSE and Red Hat
0.2.4 2014-02-06
- libfq now supports a "client_encoding" connection parameter,
which enables us to cover most reasonably common encoding
combinations by passing the value provided by
GetDatabaseEncodingName() to Firebird. See caveat in code
regarding compatibility between PostgreSQL and Firebird encoding
names.
0.2.3 2014-02-02
- Default to PostgreSQL table name if no 'table_name' option
explicitly provided
0.2.2 2014-01-25
- Implement basic transaction support
0.2.1 2014-01-23
- Make extension compatible with PostgreSQL 9.2
- Fix some regressions
0.2.0 2014-01-23
- Implement basic connection caching
- Fix implicit cast handling
0.1.6 2014-01-21
- Push down bitwise operators << and >> (FB 2.1 and later)
- Push down two-argument form of SUBSTRING()
- Push down CONCAT()
- Push down POSITION() / STRPOS()
- Don't check for mutable functions - we are explicitly
whitelisting functions which can be pushed down
(need to double-check if that's a valid approach)
0.1.5 2014-01-20
- Add basic Firebird version detection to ensure that only
functions available on the remote Firebird server are actually
pushed down
- Push down functions COALESCE(), NULLIF()
- Only push down SUBSTRING() if 2nd and 3rd arguments are INTs
0.1.4 2014-01-13
- Prevent implicit casts from being pushed down to Firebird
0.1.3 2014-01-13
- Partial pushdown of functions in WHERE clauses to Firebird
- Ensure parameter "disable_pushdowns" is treated as a boolean
- Add CREATE FOREIGN SERVER/CREATE FOREIGN TABLE parameter
"updatable", matching the postgres_fdw parameter
0.1.2 2014-01-11
- Partial pushdown of WHERE clauses to Firebird
- new CREATE FOREIGN SERVER parameter "disable_pushdowns"
- CREATE FOREIGN TABLE parameter "table" renamed to "table_name"
(matching the postgres_fdw parameter and for consistency with the
column option "column_name")
0.1.1 2014-01-01
- Add support for column aliases (column option "column_name")
0.1.0 2014-01-01
- Initial public release