summaryrefslogtreecommitdiff
path: root/src/backend/utils/misc
AgeCommit message (Collapse)Author
2004-01-19Repair problem identified by Olivier Prenant: ALTER DATABASE SET search_pathTom Lane
should not be too eager to reject paths involving unknown schemas, since it can't really tell whether the schemas exist in the target database. (Also, when reading pg_dumpall output, it could be that the schemas don't exist yet, but eventually will.) ALTER USER SET has a similar issue. So, reduce the normal ERROR to a NOTICE when checking search_path values for these commands. Supporting this requires changing the API for GUC assign_hook functions, which causes the patch to touch a lot of places, but the changes are conceptually trivial.
2004-01-06Make the 'wal_debug' GUC variable a boolean (rather than an integer), andNeil Conway
hide it behind #ifdef WAL_DEBUG blocks.
2003-12-03Added new group of read-only GUC variables to allow simple accessJoe Conway
to certain compile-time options (FUNC_MAX_ARGS, INDEX_MAX_KEYS, NAMEDATALEN, BLCKSZ, HAVE_INT64_TIMESTAMP). Also added "category", "short_desc", and "extra_desc" to the pg_settings view. Per recent discussion here: http://archives.postgresql.org/pgsql-patches/2003-11/msg00363.php
2003-12-01This patch adds a new GUC var, "default_with_oids", which follows theBruce Momjian
proposal for eventually deprecating OIDs on user tables that I posted earlier to pgsql-hackers. pg_dump now always specifies WITH OIDS or WITHOUT OIDS when dumping a table. The documentation has been updated. Neil Conway
2003-12-01Seems there are three GUC variables that are defined as "Shows ..."Bruce Momjian
while you can actually set them with SET. This applied patch changes the wording from "Show" to "Set".
2003-11-29$Header: -> $PostgreSQL Changes ...PostgreSQL Daemon
2003-11-19Background writer processJan Wieck
This first part of the background writer does no syncing at all. It's only purpose is to keep the LRU heads clean so that regular backends seldom to never have to call write(). Jan
2003-11-16Changed parameter name for shared cache status report interval toJan Wieck
debug_shared_buffers = <seconds> as per previous discussion. Jan
2003-11-132nd try for the ARC strategy.Jan Wieck
I added a couple more Assertions while tracking down the exact cause of the former bug. All 93 regression tests pass now. Jan
2003-11-13ARC strategy backed out ... sorryJan Wieck
Jan
2003-11-13Replacement of the buffer replacement strategy with an ARCJan Wieck
algorithm adopted for PostgreSQL. Jan
2003-11-08Fix process-status handling for OS X 10.3.Tom Lane
2003-11-07zero_damaged_pages must absolutely NOT be marked GUC_DISALLOW_IN_FILE,Tom Lane
else it cannot be used to handle failures detected during WAL replay. Fortunately this flag isn't actually enforced yet, but get it right.
2003-11-06Implement isolation levels read uncommitted and repeatable read as actingPeter Eisentraut
like the next higher one.
2003-10-18Cleanup on --help-config: Now called --describe-config, no further options,Peter Eisentraut
machine readable, without headers, not sorted. Parameter descriptions adjusted to fit first sentence + rest convention.
2003-10-08Have log_min_duration_statement = 0 always print duration/statement.Bruce Momjian
Change log line to be "duration: ms query:" Indent multi-line queries with a tab in the server logs.
2003-10-03Add GUC parameter check_function_bodies to control whether validationTom Lane
of function bodies is done at CREATE FUNCTION time. This is normally true but can be set false to avoid problems with forward references, wrong schema search path, etc. This is just the backend patch, still need to adjust pg_dump to make use of it.
2003-09-29More message editing, some suggested by Alvaro HerreraPeter Eisentraut
2003-09-27You can't NLS-enable a program component by just putting gettext() aroundPeter Eisentraut
every string, especially if some of the output should be fixed-format machine-readable. This needs to be more carefully sorted out. Also, make the help message generated by --help-config -h be more similar in style to the others.
2003-09-26Various message fixes, among those fixes for the previous round of fixesPeter Eisentraut
2003-09-25Message editing: remove gratuitous variations in message wording, standardizePeter Eisentraut
terms, add some clarifications, fix some untranslatable attempts at dynamic message building.
2003-09-15Improve a couple of error messages per suggestions from Alvaro Herrera.Tom Lane
2003-09-11Consistenly lowercase GUC variable names, in docs and error messages.Bruce Momjian
2003-09-07Remove geqo_random_seed parameter. Having geqo reset the global random()Tom Lane
sequence every time it's called is bogus --- it interferes with user control over the seed, and actually decreases randomness overall (because a seed based on time(NULL) is pretty predictable). If you really want a reproducible result from geqo, do 'set seed = 0' before planning a query.
2003-09-04Allow non-super users to set log_duration to true, then false, when theBruce Momjian
administrator has not turned it on, and fix other PGC_USERLIMIT variables.
2003-09-03Pass session_authorization to the client and make psql update its promptPeter Eisentraut
accordingly.
2003-09-01Do not pass server_encoding to the client.Peter Eisentraut
libpq, talking to an old server, should assume SQL_ASCII as the default client encoding, because that is what the server will actually use (not the server encoding).
2003-09-01Rename DoIt to changeVar, for clarity.Bruce Momjian
2003-08-26Mop-up for previous change to determine default shared_buffers andTom Lane
max_connections at initdb time. Get rid of DEF_NBUFFERS and DEF_MAXBACKENDS macros, which aren't doing anything useful anymore, and put more likely defaults into postgresql.conf.sample.
2003-08-17Somebody forgot to include any actual documentation for ADD_MISSING_FROM.Tom Lane
2003-08-17(I always forget what the magic numbers 0 through 2 means for theBruce Momjian
"syslog" option.) By the way: The "virtual_host" parameter is a bad name for that particular option, I think. "Virtual host" signals that PostgreSQL will behave differently according to which IP address it's contacted (like Apache's virtual host support which makes the web-server serve different sites according to different criteria). A better word for the options would be "tcpip_listen_addr" or something like that. Troels Arvin
2003-08-11Rewriter and planner should use only resno, not resname, to identifyTom Lane
target columns in INSERT and UPDATE targetlists. Don't rely on resname to be accurate in ruleutils, either. This fixes bug reported by Donald Fraser, in which renaming a column referenced in a rule did not work very well.
2003-08-08Another pgindent run with updated typedefs.Bruce Momjian
2003-08-04Fix some copyright notices that weren't updated. Improve copyright toolTom Lane
so it won't miss 'em again.
2003-08-04Update copyrights to 2003.Bruce Momjian
2003-08-04pgindent run.Bruce Momjian
2003-08-01Fix my own mistake in GUC variable annotation.Tom Lane
2003-08-01Adjust 'permission denied' messages to be more useful and consistent.Tom Lane
2003-07-29Apply (a somewhat revised version of) Greg Mullane's patch to eliminateTom Lane
heuristic determination of day vs month in date/time input. Add the ability to specify that input is interpreted as yy-mm-dd order (which formerly worked, but only for yy greater than 31). DateStyle's input component now has the preferred spellings DMY, MDY, or YMD; the older keywords European and US are now aliases for the first two of these. Per recent discussions on pgsql-general.
2003-07-28Code review for recent GUC changes --- try to make it less obvious thatTom Lane
these things were added at different times by different people ;-). Includes Aizaz Ahmed's patch to remove duplicate array in help_config.c.
2003-07-28There was enough code drift since this patch, that a couple of bugsBruce Momjian
materialized. New items have been added to GucContext and GucSource enums, but of course they were not added to the corresponding GucContextName[] and GucSourceName[] arrays in the patch. Here's a new patch to fix the resulting bugs. Joe Conway
2003-07-28A visit from the message-style police ...Tom Lane
2003-07-27> Joe Conway <mail@joeconway.com> writes:Bruce Momjian
>>ISTM that "source" is worth knowing. > > Hm, possibly. Any other opinions? This version has the seven fields I proposed, including "source". Here's an example that shows why I think it's valuable: regression=# \x Expanded display is on. regression=# select * from pg_settings where name = 'enable_seqscan'; -[ RECORD 1 ]----------- name | enable_seqscan setting | on context | user vartype | bool source | default min_val | max_val | regression=# update pg_settings set setting = 'off' where name = 'enable_seqscan'; -[ RECORD 1 ]--- set_config | off regression=# select * from pg_settings where name = 'enable_seqscan'; -[ RECORD 1 ]----------- name | enable_seqscan setting | off context | user vartype | bool source | session min_val | max_val | regression=# alter user postgres set enable_seqscan to 'off'; ALTER USER (log out and then back in again) regression=# \x Expanded display is on. regression=# select * from pg_settings where name = 'enable_seqscan'; -[ RECORD 1 ]----------- name | enable_seqscan setting | off context | user vartype | bool source | user min_val | max_val | In the first case, enable_seqscan is set to its default value. After setting it to off, it is obvious that the value has been changed for the session only. In the third case, you can see that the value has been set specifically for the user. Joe Conway
2003-07-25Error message editing in backend/utils (except /adt).Tom Lane
2003-07-22Add GUC parameter to control rendezvous name.Bruce Momjian
2003-07-18Add cleaner formatting to config file.Bruce Momjian
2003-07-15Cause SHOW DATESTYLE to produce a string that will be accepted by SETTom Lane
DATESTYLE, for instance 'SQL, European' instead of 'SQL with European conventions'. Per gripe a month or two back from Barry Lind.
2003-07-14The default values for shared_buffers and max_connections are now 1000Tom Lane
and 100 respectively, if the platform will allow it. initdb selects values that are not too large to allow the postmaster to start, and places these values in the installed postgresql.conf file. This allows us to continue to start up out-of-the-box on platforms with small SHMMAX, while having somewhat-realistic default settings on platforms with reasonable SHMMAX. Per recent pghackers discussion.
2003-07-09Add description for new GUC context.Bruce Momjian
Aizaz Ahmed
2003-07-09Add special checks for non-super-user setting LOG_MIN_DURATION_STATEMENTBruce Momjian
to zero.
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-23 15:09:23 +0000