git.postgresql.org Git - postgresql.git/log
Information schema fixes:
Use pg_get_constraintdef instead of pg_constraint.consrc
Use UNION ALL instread of UNION
Make use of regclass type for getting OID of system catalogs
Add schema qualifications where necessary
Fix typos
Tom Lane [2003年10月18日 05:02:06 +0000 (05:02 +0000)]
Must free the pgParameterStatus chain in freePGconn(). My fault,
well spotted by Neil Conway.
Tom Lane [2003年10月17日 22:38:20 +0000 (22:38 +0000)]
Document all the system views created by initdb (several of these were
never documented anywhere, sigh). Centralize the detailed documentation
of system views into catalogs.sgml, and provide cross-references.
Tom Lane [2003年10月17日 18:57:01 +0000 (18:57 +0000)]
Add a listing of our SQLSTATE error codes to the documentation.
Link to it from some appropriate places.
Tom Lane [2003年10月17日 18:29:55 +0000 (18:29 +0000)]
Fix busted markup.
Tom Lane [2003年10月17日 16:49:03 +0000 (16:49 +0000)]
Fix elog tab-insertion code to insert tabs only where wanted.
Remove automatic '()' in other branch of UNION as well.
Tom Lane [2003年10月17日 01:14:26 +0000 (01:14 +0000)]
Adjust display of actual runtimes in EXPLAIN output to use three fractional
digits, and label it 'ms' not 'msec', for consistency with psql's \timing
display. Per recent discussions.
Tom Lane [2003年10月17日 00:57:04 +0000 (00:57 +0000)]
Use pg_get_constraintdef() rather than pg_constraint.consrc; this is
a portion of a patch recently submitted by Christopher Kings-Lynne.
Applied by agreement that this is a bug fix.
Tom Lane [2003年10月17日 00:55:17 +0000 (00:55 +0000)]
Add note deprecating use of consrc.
Fix bugs in referential_constraints view.
There should not be an automatic '()' after a function name when
tab-completing.
Tom Lane [2003年10月16日 22:52:22 +0000 (22:52 +0000)]
Set attstattarget to -1 for all system catalog columns. All but a few
of the entries used to be zero, which I think I had deliberately done in
the name of saving cycles during ANALYZE, but it was really a rather
foolish decision. Some of the more complex views in information_schema
were getting really bad plans for lack of statistics on the columns they
were joining over.
I'm not forcing an initdb for this, but I think there will be one soon
anyway to repair some bugs in the information_schema views.
Tom Lane [2003年10月16日 21:37:54 +0000 (21:37 +0000)]
Avoid division by zero in estimate_num_groups() when table has no rows.
Tom Lane [2003年10月16日 20:59:35 +0000 (20:59 +0000)]
Ensure that all places that are complaining about exhaustion of shared
memory say 'out of shared memory'; some were doing that and some just
said 'out of memory'. Also add a HINT about increasing max_locks_per_transaction
where relevant, per suggestion from Sean Chittenden. (The former change
does not break the strings freeze; the latter does, but I think it's
worth doing anyway.)
Tom Lane [2003年10月16日 20:03:09 +0000 (20:03 +0000)]
Cause tab completion to do something moderately reasonable with mixed-case
identifiers --- it will now complete these correctly with double quoting.
Fix a few other issues in passing.
Add mention of SIGHUP on the postmaster manual page.
Tom Lane [2003年10月16日 16:50:41 +0000 (16:50 +0000)]
Fix bad interaction between NOTIFY processing and V3 extended query
protocol, per report from Igor Shevchenko. NOTIFY thought it could
do its thing if transaction blockState is TBLOCK_DEFAULT, but in
reality it had better check the low-level transaction state is
TRANS_DEFAULT as well. Formerly it was not possible to wait for the
client in a state where the first is true and the second is not ...
but now we can have such a state. Minor cleanup in StartTransaction()
as well.
Tom Lane [2003年10月16日 04:52:21 +0000 (04:52 +0000)]
Minor copy-editing.
Add:
> * Allow pg_dump to dump CREATE CONVERSION (Christopher)
Fix SGML markup.
Update HISTORY file.
This patch adds another item to the "migration to 7.4" list in the
HISTORY file, and attributes the shared-buffer-alignment change to
Manfred Spraul.
Neil Conway
I have run pg_autovacuum on AIX, so that can, at least loosely, be
considered "tested."
And I have turned all of the 7.4 HISTORY material into DocBook for
release.sgml
Christopher Browne
Tom Lane [2003年10月15日 22:23:56 +0000 (22:23 +0000)]
Cause the default CFLAGS to be -O2 -fno-strict-aliasing when using gcc,
per recent pghackers discussions. Also ensure that explicitly setting
CFLAGS in the configure environment will be honored.
Translation updates
New translation
Translation update
New translation
Tom Lane [2003年10月14日 22:47:12 +0000 (22:47 +0000)]
Use PQescapeString to ensure that tab-completion queries are not messed
up by quotes or backslashes in words that are being matched to database
names (per gripe from Ian Barwick, though I didn't use his patch).
Also fix possible memory leakage if _complete_with_query isn't run to
completion (not clear if that can happen or not, but be safe).
Remove void* in MemSet until we understand the gcc 3.3.1 problem better.
Add compile -O flag only for non-debug mode, per Tom
Tom Lane [2003年10月13日 23:48:16 +0000 (23:48 +0000)]
pull_up_subqueries() should copy the subquery before starting to modify
it. Not sure why I'd thought it would be a good idea to do differently
way back when, but Greg Stark exposed the folly of doing so ...
Back out makeNode() patch to fix gcc 3.3.1 warning.
Remove registration message, after discussion concluded that it was of
little use.
Translation update
Tom Lane [2003年10月13日 21:06:44 +0000 (21:06 +0000)]
Determine max_connections first, then see how large shared_buffers can
be made, to avoid corner cases where max_connections ends up unreasonably
small because shared_buffers is hogging too much shmem space. Per pghackers
discussion about a week ago. Also, fix the copy-newlines problem in a
more robust way, by using COPY FROM filename instead of COPY FROM STDIN;
per a suggestion from Peter.
Tom Lane [2003年10月13日 20:02:52 +0000 (20:02 +0000)]
Adjust setRelhassubclassInRelation() to not perform actual heap_update
when the pg_class.relhassubclass value is already correct. This should
avoid most cases of the 'tuple concurrently updated' problem that
Robert Creager recently complained about. Also remove a bunch of dead
code in StoreCatalogInheritance() --- it was still computing the complete
list of direct and indirect inheritance ancestors, though that list has
not been needed since we got rid of the pg_ipl catalog.
Use makeNode() to allocate structures that have to be cast to Node *,
rather than allocating them on the stack.
Fixes complaint from gcc 3.3.1.
New translation
Added missing "commit" in test case.
Add void * cast to MemSet to silence compiler, and add comment that we
already check for alignment.
Back out -fstrict-aliasing void* casting.
Translation updates
This patch will stop gcc from issuing warnings about type-punned objects
when -fstrict-aliasing is turned on, as it is in the latest gcc when you
use -O2
Andrew Dunstan
Update max existing db size to 32tb.
Fix core dump on root starting pg_autovacuum.
Change conditionals to be more constent with our code
if (const == var) => if (var == const).
Translation updates
Rename __arm__/__arm__ to __arm__/__arm, found by Neil Conway
Add NULL regression tests.
Manfred Koizar
Change Win32 rename/unlink timeout to 3 seconds.
Update Russian FAQ.
Viktor Vislobokov
Add:
> * Prevent libpq's PQfnumber() from lowercasing the column name
572d572
< * Vadim is Vadim B. Mikheev <vadim4o@email.com> of Sector Data
> That's a fairly useless place to put it, though, since someone would
> only think to look at sort_mem if they already had a clue. It should
> be mentioned under bulk data load (in performance tips chapter)
Attached is a doc patch that does this. The way I've worded it may not
be the best, though.
Neil Conway
Add count(*) TODO detail.
Add TODO.detail for count(*):
> to allow fast COUNT(*) queries with no WHERE clause(?) [count]
Allow pg_id to compile on Win32.
Andrew Dunstan
Add:
> o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]
Remove -pipe from compiles.
Add:
> * Have VACUUM FULL use REINDEX rather than index vacuum
About section 8.5.1.5. ("Special Values"):
I suggest adding LOCALTIMESTAMP and LOCALTIME to the first paragraph.
Maybe it should be phrased as:
The following SQL-compatible functions can be used to obtain
current datetime-related values: CURRENT_DATE, CURRENT_TIME,
CURRENT_TIMESTAMP, LOCALTIME and LOCALTIMESTAMP.
(See Section 9.8.4.)
Troels Arvin
Make sure that -- comments extend to the end of the line. This fixes the
misscanning of this construct:
SELECT ''hello world''
-- SELECT ''goodbye world''
::text;
Some updates
Add mention of logrotate for syslog, from Robert Treat
Update Solaris FAQ to mention -fast.
Remove -pipe on Linux, per reports from Peter.
Add -pipe compile for Linux.
Make template CFLAGS handling consistent.
Someone report me small bug in contrib/pg_dumplo today. It's problem
with a little dirty snprintf() usage which I used some years ago:
snprintf(path, BUFSIZ, "%s/lo_dump.index", path);
Karel Zak
Re-add -pipe compile flags for bsd's.
Update:
> * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT | LANGUAGE ]
> (Christopher)
This centralizes the optimization defaults into configure.in, rather
than having CFLAGS= in the template files.
It uses -O2 for gcc (generated by autoconf), and -O for non-gcc, unless
the template overrides it.
Add:
> * COMMENT ON [ CAST | CONVERSION | OPERATOR CLASS | LARGE OBJECT ] (Christopher)
Change "query:" to "statement:".
Have log_duration print when log_min_duration_statement prints.
Add quotes to CFLAG define.
Jan Wieck [Thu, 9 Oct 2003 01:17:07 +0000 (01:17 +0000)]
Protected access to variable m_preparedCount via synchronized
function to prevent multiple threads using automatic cursors on
the same connection from stomping over each others cursor.
Jan
Add:
<
346a346
> * Remove CREATE CONSTRAINT TRIGGER
Add 2-phase info, add Win32 URL:
< o Sample implementation in contrib/rserv
29c28,29
< * Create native Win32 port [win32]
> * Create native Win32 port, http://momjian.postgresql.org/main/writings/pgsql/win32.html
>
367c367,368
< * Two-phase commit to implement distributed transactions
> * Add two-phase commit to all distributed transactions with
> offline/readonly server status or administrator notification for failure
New translations
Add:
> * Use background process to write dirty shared buffers to disk
New translations
Add quotes around -O setting for consistency.
Change some awkward wording in the pg_autovacuum README file. I really
only read this because of Niel :-)
Robert Treat
Removed my debug printf() call from numeric.c
Use calloc() to allocate empty structures.
Fix pg_restore tar log output bug where Special flag wasn't being
initialized; bug seen on XP.
Have log_min_duration_statement = 0 always print duration/statement.
Change log line to be "duration: ms query:"
Indent multi-line queries with a tab in the server logs.
Fixed floating point exception in long=>numeric conversion.
Fix include used by entab.
Add missing include file.
Fixed error handling in Informix compat str to date conversion.
New Italian translation
Tom Lane [Mon, 6 Oct 2003 20:09:47 +0000 (20:09 +0000)]
Fix binary_oper_exact() so that the heuristic 'an unknown literal on
one side of a binary operator is probably supposed to be the same type
as the other operand' will be applied for domain types. This worked
in 7.3 but was broken in 7.4 due to code rearrangements. Mea culpa.
Translation updates
Tom Lane [Mon, 6 Oct 2003 16:38:28 +0000 (16:38 +0000)]
During ALTER TABLE ADD FOREIGN KEY, try to check the existing rows using
a single LEFT JOIN query instead of firing the check trigger for each
row individually. Stephan Szabo, with some kibitzing from Tom Lane and
Jan Wieck.
New Slovene translations
- Fixed constant listing in execute using clause.
- Fixed typo in ecpg for Informix dec_t type.
- Fixed precision handling in Informix compat funxtions.
Translation updates
Tom Lane [Mon, 6 Oct 2003 02:38:53 +0000 (02:38 +0000)]
Modify COPY FROM to match the null-value string against the column value
before it is de-backslashed, not after. This allows the null string \N
to be reliably distinguished from the data value \N (which must be
represented as \\N). Per bug report from Manfred Koizar ... but it's
amazing this hasn't been reported before ...
Also, be consistent about encoding conversion for null string: the form
specified in the command is in the server encoding, but what is sent
to/from client must be in client encoding. This never worked quite
right before either.
Tom Lane [Mon, 6 Oct 2003 01:11:12 +0000 (01:11 +0000)]
Fix order of operations within SendQuery() so that the time spent in
data transfer during COPY is included in the \timing display. Also
avoid portability problems if tv_usec is unsigned on some platform.
Tom Lane [Sun, 5 Oct 2003 22:44:25 +0000 (22:44 +0000)]
Add a little more smarts to estimate_hash_bucketsize(): if there's no
statistics, but there is a unique index on the column, we can safely
assume it's well-distributed.
Make psql \timing show three digits.
This is the main PostgreSQL git repository.
RSS
Atom