summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2008-05-10Update alternative output regression files for new float8 test of power().Bruce Momjian
2008-05-09Change the rules for inherited CHECK constraints to be essentially the sameTom Lane
as those for inherited columns; that is, it's no longer allowed for a child table to not have a check constraint matching one that exists on a parent. This satisfies the principle of least surprise (rows selected from the parent will always appear to meet its check constraints) and eliminates some longstanding bogosity in pg_dump, which formerly had to guess about whether check constraints were really inherited or not. The implementation involves adding conislocal and coninhcount columns to pg_constraint (paralleling attislocal and attinhcount in pg_attribute) and refactoring various ALTER TABLE actions to be more like those for columns. Alex Hunsaker, Nikhil Sontakke, Tom Lane
2008-05-09Adjust power() error messages to be more descriptive.Bruce Momjian
2008-05-09Improve logic for finding object files on OBJS lines in contrib Makefiles. ↵Andrew Dunstan
If this unbreaks buildfarm mastodon, apply everywhere.
2008-05-09Add "%option noinput" to the scanners to avoid compiler warnings. GCC 4.3Peter Eisentraut
began to realize that the input() function isn't used and printed warnings.
2008-05-09Update C comments to mention SQL:2003 handling of power return values.Bruce Momjian
2008-05-09Fix Assert introduced in previous patch.Heikki Linnakangas
2008-05-09Fix incorrect archive truncation point calculation in the %r recovery_commandHeikki Linnakangas
parameter. This fixes bug 4137 reported by Wojciech Strzalka, where a WAL file is deleted too early when starting the recovery of a warm standby server. Also add a sanity check in pg_standby so that it will refuse to delete anything earlier than the file being restored, and improve the debug message in case nothing is deleted. Simon Riggs. Backpatch to 8.3, which is where %r was introduced.
2008-05-09Fix bogus expected output that should have made it quite clear thatTom Lane
something was wrong with that tab patch.
2008-05-09Fix memory stomp that's turning the whole buildfarm pink: you can't hack upTom Lane
pg_wcsformat without changing pg_wcssize to match. Add some comments to try to make that clearer, and make a couple other minor editorializations.
2008-05-08Add regression test for various power expressions with a zero base, andBruce Momjian
adjust source code to be more modular.
2008-05-08Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0Bruce Momjian
return 1, rather than error. This was already the float8 behavior.
2008-05-08Have psql output tab as the proper number of spaces, rather than \x09.Bruce Momjian
2008-05-08Add psql '\pset format wrapped' mode to wrap output to screen width, orBruce Momjian
file/pipe output too if \pset columns' is set. Bryce Nesbitt
2008-05-08Fix rules regression test for recent pg_stat_activity change.Tom Lane
2008-05-08Make the new pg_stat_get_activity use OUT parameters, so you don't have toMagnus Hagander
specify the column names and types. Also simplifies the view. Per comments from Tom.
2008-05-07Make the pg_stat_activity view call a SRF (pg_stat_get_activity())Magnus Hagander
instead of calling a bunch of individual functions. This function can also be called directly, taking a PID as an argument, to return only the data for a single PID.
2008-05-07Have boolean pset values checked against typical boolean values, ratherBruce Momjian
than only 'off'.
2008-05-07The CONSTROID syscache should show conrelid as a relation OID column.Tom Lane
Not clear that there's any observable bug at present from this omission, but it seems like something to fix going forward.
2008-05-07Convert the list of syscache names from a series of #define's into an enum,Tom Lane
to avoid the pain of manually renumbering them anytime we insert another name in alphabetical order. An excellent idea from Alex Hunsaker and NikhilS' inherited-constraints patch --- whether or not the rest of that gets in, this should. Dunno why we never thought of it before.
2008-05-05Add more dependencies from libpgport required byMagnus Hagander
standalone msvc build of libpq. Hiroshi Saito
2008-05-05Display ACLS using multiple lines for psql's \z. Brendan Jurd.Andrew Dunstan
2008-05-05Show enum values in psql's \dt+. David Fetter.Andrew Dunstan
2008-05-04Add timestamp and timestamptz versions of generate_series().Tom Lane
Hitoshi Harada
2008-05-04Add pg_conf_load_time() function to report when the Postgres configurationTom Lane
files were last loaded. George Gensure
2008-05-04Use new cstring/text conversion functions in some additional places.Tom Lane
These changes assume that the varchar and xml data types are represented the same as text. (I did not, however, accept the portions of the proposed patch that wanted to assume bytea is the same as text --- tgl.) Brendan Jurd
2008-05-04add ; missing due to my carelessnessAndrew Dunstan
2008-05-04Place statement timeout more appropriately, per gripe from Tom.Andrew Dunstan
2008-05-03Disable statement timeouts while making or restoring dumps.Andrew Dunstan
Joshua Drake.
2008-05-03The 8.2 patch that added support for an alias on the target table ofTom Lane
UPDATE/DELETE forgot to teach ruleutils.c to display the alias. Per bug #4141 from Mathias Seiler.
2008-05-03Fix plpython to not get totally confused by OUT arguments. (It still doesn'tTom Lane
support multiple OUT arguments, though.) Hannu Krosing
2008-05-03Provide for MSVC config equivalents of recently added configure options. RemoveAndrew Dunstan
any hardcoding of those options. Along the way, reorder the expression used to calculate RELSEG_SIZE to make it slightly clearer. For now wal_segsize is only allowed to have a value of 1 on Windows - we can relax that when we get full large file support in the backend.
2008-05-03Support RETURN QUERY EXECUTE in plpgsql.Tom Lane
Pavel Stehule
2008-05-02Allow the planner's estimate of the fraction of a cursor's rows that will beTom Lane
retrieved to be controlled through a GUC variable. Robert Hell
2008-05-02Extend yesterday's patch making BLCKSZ and RELSEG_SIZE configurable to alsoTom Lane
let XLOG_BLCKSZ and XLOG_SEG_SIZE be set via configure. Per a proposal by Mark Wong, though I thought it better to call the switches after "wal" rather than "xlog".
2008-05-02Make the AWK default value also take effect if $AWK is an empty string.Peter Eisentraut
2008-05-02Show relation size in verbose (e.g. \d+) output.Heikki Linnakangas
Dickson S. Guedes
2008-05-02One-letter backslash commands now need a space before the first argument.Peter Eisentraut
This has been the only documented and encouraged syntax for a long time, and with extension facilities such as aliases being proposed, it is a good time to clean up the legacy syntax a bit. Author: Bernd Helmle <mailings@oopsware.de>
2008-05-02Sigh ... pg_config.h.win32 needs to define BLCKSZ and RELSEG_SIZE now.Tom Lane
2008-05-02Remove the recently added USE_SEGMENTED_FILES option, and indeed remove allTom Lane
support for a nonsegmented mode from md.c. Per recent discussions, there doesn't seem to be much value in a "never segment" option as opposed to segmenting with a suitably large segment size. So instead provide a configure-time switch to set the desired segment size in units of gigabytes. While at it, expose a configure switch for BLCKSZ as well. Zdenek Kotala
2008-05-01Add SGT (Singapore time) to the default list of known timezoneTom Lane
abbreviations. It doesn't conflict with any other abbreviation so there seems no reason not to include it. Per a recent gripe.
2008-05-01Make the minimum allowed value of work_mem be 64KB always, rather than havingTom Lane
it vary with BLCKSZ as before. This agrees with what the documentation says, and avoids a regression test problem when BLCKSZ is larger than default. Per recent discussion.
2008-04-30Fix nodeTidscan.c to not trigger an error if the block number portion ofTom Lane
a user-supplied TID is out of range for the relation. This is needed to preserve compatibility with our pre-8.3 behavior, and it is sensible anyway since if the query were implemented by brute force rather than optimized into a TidScan, the behavior for a non-existent TID would be zero rows out, never an error. Per gripe from Gurjeet Singh.
2008-04-29Some minor further cleanup around A_Const. Don't attach a typecast inTom Lane
makeFloatConst, and avoid "manual" construction of A_Const nodes in grammar productions, in favor of using makeXXXConst subroutines.
2008-04-29Fix REASSIGN OWNED so that it works on procedural languages too.Alvaro Herrera
The capability for changing language owners is new in 8.3, so that's how far back this needs to be backpatched. Per bug #4132 by Kirill Simonov.
2008-04-29Remove typename from A_Const.Alvaro Herrera
Brendan Jurd, minor editorialization by me.
2008-04-29Fix volatility marking for the generate_series and generate_subscripts familiesAlvaro Herrera
of functions.
2008-04-28Increase the statement_timeout value used in the prepared_xacts regressionTom Lane
test. We have seen some buildfarm failures that seem to be due to this limit being unexpectedly exceeded when the machine is under load.
2008-04-28Bump the catversion for the previous patch.Alvaro Herrera
2008-04-28Add generate_subscripts, a series-generation function which generates anAlvaro Herrera
array's subscripts. Pavel Stehule, some editorialization by me.