summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2006-05-31Fix example of how to escape data in psql backslash commands.Tom Lane
2006-05-31Fix seriously broken patch for psql '' ... per its comment, emit() isTom Lane
NOT the thing to use here.
2006-05-31Make PG_MODULE_MAGIC required in shared libraries that are loaded intoTom Lane
the server. Per discussion, there seems no point in a waiting period before making this required.
2006-05-31fix comparison with SPI_processedTeodor Sigaev
2006-05-31Add thesaurus dictionary which can replace N>0 lexemes by M>0 lexemes.Teodor Sigaev
It required some changes in lexize algorithm, but interface with dictionaries stays compatible with old dictionaries. Funded by Georgia Public Library Service and LibLime, Inc.
2006-05-31Recommend '' for literal ', rather than \', in psql documentation.Bruce Momjian
2006-05-31Support '' for literal ' in psql single-quote strings, documentation update.Bruce Momjian
2006-05-31Escape processing patch:Bruce Momjian
o turns off escape_string_warning in pg_dumpall.c o optionally use E'' for \password (undocumented option?) o honor standard_conforming-strings for \copy (but not support literal E'' strings) o optionally use E'' for \d commands o turn off escape_string_warning for createdb, createuser, droplang
2006-05-31Update cvs command example to show diff -rBASE.Bruce Momjian
2006-05-31Somehow a ";" got lost which changed the logic. This btw is the first fix ↵Michael Meskes
resulting from SoC.
2006-05-30Magic blocks don't do us any good unless we use 'em ... so install oneTom Lane
in every shared library.
2006-05-30Un-DOS-ify newly added files.Tom Lane
2006-05-30Code review for magic-block patch. Remove separate header file pgmagic.h,Tom Lane
as this seems only likely to create headaches for module developers. Put the macro in the pre-existing fmgr.h file instead. Avoid being too cute about how many fields we can cram into a word, and avoid trying to fetch from a library we've already unlinked. Along the way, it occurred to me that the magic block really ought to be 'const' so it can be stored in the program text area. Do the same for the existing data blocks for PG_FUNCTION_INFO_V1 functions.
2006-05-30Code review for EXPLAIN patch. Fix some typos, make it behave sanelyTom Lane
across multiple loops, get rid of the shaky assumption that exactly one tuple is returned per node iteration.
2006-05-30PostmasterIsAlive test really ought to be in the inner loop for safety.Tom Lane
2006-05-30Remove pqsignalinquire(), which is unused and has portability issues.Tom Lane
2006-05-30Update ppport.h to not cause warnings with newest Perl versions.Tom Lane
This is just the minimal necessary change; we might want to adopt later PPPort output instead.
2006-05-30Add pgmagic header block to store compile-time constants:Bruce Momjian
It now only checks four things: Major version number (7.4 or 8.1 for example) NAMEDATALEN FUNC_MAX_ARGS INDEX_MAX_KEYS The three constants were chosen because: 1. We document them in the config page in the docs 2. We mark them as changable in pg_config_manual.h 3. Changing any of these will break some of the more popular modules: FUNC_MAX_ARGS changes fmgr interface, every module uses this NAMEDATALEN changes syscache interface, every PL as well as tsearch uses this INDEX_MAX_KEYS breaks tsearch and anything using GiST. Martijn van Oosterhout
2006-05-30Make EXPLAIN sampling smarter, to avoid excessive sampling delay.Bruce Momjian
Martijn van Oosterhout
2006-05-30Clarify the HINT for 'checkpoint request failed', per recent complaintTom Lane
demonstrating that its intent wasn't obvious.
2006-05-30Emit warnings for unknown configure options.Bruce Momjian
Martijn van Oosterhout
2006-05-30Revert patch, needs more work:Bruce Momjian
--------------------------------------------------------------------------- Add dynamic record inspection to PL/PgSQL, useful for generic triggers: tval2 := r.(cname); or columns := r.(*); Titus von Boxberg
2006-05-30Move conversion dependency patch to the proper branch, out of 8.1.X,Bruce Momjian
into HEAD.
2006-05-30Prevent multiple archivers from starting. Backpatch to 8.1.X.Bruce Momjian
Simon Riggs
2006-05-30Add /contrib/adminpack to contrib/Makefile, do case-folding change.Bruce Momjian
2006-05-30Fix printf mask for SizeVfdCacheBruce Momjian
Qingqing Zhou
2006-05-30Re-defines SHA2 symbols so that they would not conflict with certainBruce Momjian
versions of OpenSSL. If your OpenSSL does not contain SHA2, then there should be no conflict. But ofcourse, if someone upgrades OpenSSL, server starts crashing. Backpatched to 8.1.X. Marko Kreen
2006-05-30Add "inline" compile fix for MSVC/BCC:Bruce Momjian
#define inline __inline Backpatch to 8.1.X. Hiroshi Saito
2006-05-30Re-add btree_gist description.Bruce Momjian
2006-05-30Add Pgadmin administration functions to /contrib/adminpack.Bruce Momjian
Dave Page
2006-05-30Add dynamic record inspection to PL/PgSQL, useful for generic triggers:Bruce Momjian
tval2 := r.(cname); or columns := r.(*); Titus von Boxberg
2006-05-30Back out patch, wrong previous commit message.Bruce Momjian
2006-05-30Add regexp_replace() to string functions section.Bruce Momjian
Joachim Wieland
2006-05-30Update PL documentation:Bruce Momjian
An article at WebProNews quoted from the PG docs as to the merits of stored procedures. I have added a bit more material on their merits, as well as making a few changes to improve the introductions to PL/Perl and PL/Tcl. Chris Browne
2006-05-30Update Japanese FAQ.Bruce Momjian
J.Kuwamura
2006-05-30Add item:Bruce Momjian
> * Consider GnuTLS if OpenSSL license becomes a problem > > See http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php.
2006-05-30Fix ancient misdescription of namegt/namege in comment. Greg StarkTom Lane
2006-05-30Patch reverted because of random buildfarm failures:Bruce Momjian
--------------------------------------------------------------------------- Delay write of pg_stats file to once every five minutes, during shutdown, or when requested by a backend: It changes so the file is only written once every 5 minutes (changeable of course, I just picked something) instead of once every half second. It's still written when the stats collector shuts down, just as before. And it is now also written on backend request. A backend requests a rewrite by simply sending a special stats message. It operates on the assumption that the backends aren't actually going to read the statistics file very often, compared to how frequent it's written today. Magnus Hagander
2006-05-29Add:Bruce Momjian
> o Allow timezone names in SQL strings, '2006-05-24 21:11 > Americas/New_York'::timestamptz
2006-05-29Add PQclear() calls, for completeness (exits shortly anyway).Bruce Momjian
2006-05-29Make plperl's $_TD trigger data a global rather than a lexical variable,Andrew Dunstan
with a fresh local value for each invocation, to avoid unexpected sharing violations. Per recent -hackers discussion.
2006-05-29Som improve page split in multicolumn GiST index.Teodor Sigaev
If user picksplit on n-th column generate equals left and right unions then it calls picksplit on n+1-th column.
2006-05-29Correct cheking in findParents(). iTeodor Sigaev
From Andreas Seltenreich <andreas+pg@gate450.dyndns.org>
2006-05-28enlargePQExpBuffer, alone among the functions exported by pqexpbuffer.h,Tom Lane
wasn't exported by exports.txt. Ooops. Per buildfarm results.
2006-05-28Fix up pg_dump to do string escaping fully correctly for client encodingTom Lane
and standard_conforming_strings; likewise for the other client programs that need it. As per previous discussion, a pg_dump dump now conforms to the standard_conforming_strings setting of the source database. We don't use E'' syntax in the dump, thereby improving portability of the SQL. I added a SET escape_strings_warning = off command to keep the dumps from getting a lot of back-chatter from that.
2006-05-28Don't call PQclear until the struct is really no longer going to be used.Alvaro Herrera
Per Coverity bug #304. Thanks to Martijn van Oosterhout for reporting it. Zero out the pointer fields of PGresult so that these mistakes are more easily catched, per discussion.
2006-05-28 fix typoAndrew Dunstan
2006-05-28TG_table_name and TG_table_schema for plpgsql, plus docs and regression.Andrew Dunstan
2006-05-28Remove traces of otherwise unused RELKIND_SPECIAL symbol. Leave the psql bitsAlvaro Herrera
in place though, so that it plays nicely with older servers. Per discussion.
2006-05-27TG_table_name and TG_table_schema for pl/tcl, plus regression test and docs.Andrew Dunstan