- 27 5月, 2006 4 次提交
-
-
由 Tom Lane 提交于
during COPY OUT. Andreas Pflug, some editorialization by moi.
-
由 Bruce Momjian 提交于
Chris Browne
-
由 Andrew Dunstan 提交于
Add table_name and table_schema to plpython trigger data, plus docs and regression test.
-
由 Andrew Dunstan 提交于
Add table_name and table_schema to plperl trigger data. relname is kept but now deprecated. Patch from Adam Sjøgren. Add regression test to show plperl trigger data (Andrew). TBD: apply similar changes to plpgsql, plpython and pltcl.
-
- 26 5月, 2006 2 次提交
-
-
由 Teodor Sigaev 提交于
By Andreas Seltenreich <andreas+pg@gate450.dyndns.org>
-
由 Tom Lane 提交于
CopySendData.
-
- 25 5月, 2006 2 次提交
-
-
由 Tom Lane 提交于
really tables and shouldn't get DISABLE TRIGGER processing. Per bug #2452 from Robert Treat.
-
由 Bruce Momjian 提交于
< pg_attribute.attislocal has to be set to 'false' for ADD, and < pg_attribute.attinhcount adjusted appropriately > See http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php.
-
- 24 5月, 2006 8 次提交
-
-
由 Teodor Sigaev 提交于
* some refactoring and simplify code int gistutil.c and gist.c * now in some cases it can be called used-defined picksplit method for non-first column in index, but here is a place to do more. * small fix of docs related to support NULL.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
the thread-safety status of the library.
-
由 Tom Lane 提交于
and transaction visibility fields of tuples being sorted. These are always uninteresting in a tuple being sorted (if the fields were actually selected, they'd have been pulled out into user columns beforehand). This saves about 24 bytes per row being sorted, which is a useful savings for any but the widest of sort rows. Per recent discussion.
-
由 Bruce Momjian 提交于
> This allows tables to be added/removed from an inheritance > hierarchy. This is particularly useful for table partitioning.
-
由 Bruce Momjian 提交于
> o Add ALTER TABLE tab ADD/DROP INHERITS parent > > pg_attribute.attislocal has to be set to 'false' for ADD, and > pg_attribute.attinhcount adjusted appropriately >
-
由 Bruce Momjian 提交于
Fix for OS/X Bonjour on x86 systems (Ashley Clark)
-
由 Bruce Momjian 提交于
in port/pg_config_paths.h.
-
- 23 5月, 2006 5 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
any use in the past many years, we'd have made some effort to include them in all executor node types; but in fact they were only in nodeAppend.c and nodeIndexscan.c, up until I copied nodeIndexscan.c's occurrence into the new bitmap node types. Remove some other unused macros in execdebug.h, too. Some day the whole header probably ought to go away in favor of better-designed facilities.
-
由 Bruce Momjian 提交于
> * Referential Integrity > > o Add MATCH PARTIAL referential integrity > o Change foreign key constraint for array -> element to mean element > in array? > o Enforce referential integrity for system tables > > < Referential Integrity < ===================== < < * Add MATCH PARTIAL referential integrity > Triggers > ======== < * Change foreign key constraint for array -> element to mean element < in array? 801d804 < * Enforce referential integrity for system tables
-
- 22 5月, 2006 9 次提交
-
-
由 Bruce Momjian 提交于
J.Kuwamura
-
由 Bruce Momjian 提交于
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
session key to be selected by pgp_sym_encrypt() in some cases. This only affects non-OpenSSL-using builds. Marko Kreen
-
由 Tom Lane 提交于
and standard_conforming_strings. The encoding changes are needed for proper escaping in multibyte encodings, as per the SQL-injection vulnerabilities noted in CVE-2006-2313 and CVE-2006-2314. Concurrent fixes are being applied to the server to ensure that it rejects queries that may have been corrupted by attempted SQL injection, but this merely guarantees that unpatched clients will fail rather than allow injection. An actual fix requires changing the client-side code. While at it we have also fixed these routines to understand about standard_conforming_strings, so that the upcoming changeover to SQL-spec string syntax can be somewhat transparent to client code. Since the existing API of PQescapeString and PQescapeBytea provides no way to inform them which settings are in use, these functions are now deprecated in favor of new functions PQescapeStringConn and PQescapeByteaConn. The new functions take the PGconn to which the string will be sent as an additional parameter, and look inside the connection structure to determine what to do. So as to provide some functionality for clients using the old functions, libpq stores the latest encoding and standard_conforming_strings values received from the backend in static variables, and the old functions consult these variables. This will work reliably in clients using only one Postgres connection at a time, or even multiple connections if they all use the same encoding and string syntax settings; which should cover many practical scenarios. Clients that use homebrew escaping methods, such as PHP's addslashes() function or even hardwired regexp substitution, will require extra effort to fix :-(. It is strongly recommended that such code be replaced by use of PQescapeStringConn/PQescapeByteaConn if at all feasible.
-
由 Tom Lane 提交于
parser will allow "\'" to be used to represent a literal quote mark. The "\'" representation has been deprecated for some time in favor of the SQL-standard representation "''" (two single quote marks), but it has been used often enough that just disallowing it immediately won't do. Hence backslash_quote allows the settings "on", "off", and "safe_encoding", the last meaning to allow "\'" only if client_encoding is a valid server encoding. That is now the default, and the reason is that in encodings such as SJIS that allow 0x5c (ASCII backslash) to be the last byte of a multibyte character, accepting "\'" allows SQL-injection attacks as per CVE-2006-2314 (further details will be published after release). The "on" setting is available for backward compatibility, but it must not be used with clients that are exposed to untrusted input. Thanks to Akio Ishida and Yasuo Ohgaki for identifying this security issue.
-
由 Tom Lane 提交于
characters in all cases. Formerly we mostly just threw warnings for invalid input, and failed to detect it at all if no encoding conversion was required. The tighter check is needed to defend against SQL-injection attacks as per CVE-2006-2313 (further details will be published after release). Embedded zero (null) bytes will be rejected as well. The checks are applied during input to the backend (receipt from client or COPY IN), so it no longer seems necessary to check in textin() and related routines; any string arriving at those functions will already have been validated. Conversion failure reporting (for characters with no equivalent in the destination encoding) has been cleaned up and made consistent while at it. Also, fix a few longstanding errors in little-used encoding conversion routines: win1251_to_iso, win866_to_iso, euc_tw_to_big5, euc_tw_to_mic, mic_to_euc_tw were all broken to varying extents. Patches by Tatsuo Ishii and Tom Lane. Thanks to Akio Ishida and Yasuo Ohgaki for identifying the security issues.
-
- 20 5月, 2006 3 次提交
-
-
由 Alvaro Herrera 提交于
issued by autovacuum. Add accessor functions to them, and use those in the pg_stat_*_tables system views. Catalog version bumped due to changes in the pgstat views and the pgstat file. Patch from Larry Rosenman, minor improvements by me.
-
由 Teodor Sigaev 提交于
-
由 Teodor Sigaev 提交于
-
- 19 5月, 2006 7 次提交
-
-
由 Alvaro Herrera 提交于
-
由 Alvaro Herrera 提交于
-
由 Bruce Momjian 提交于
-
由 Teodor Sigaev 提交于
WAL log during inserts.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-