OSDN Git Service
Bruce Momjian [Thu, 12 Jun 2003 08:02:57 +0000 (08:02 +0000)]
New patch with corrected README attached.
Also quickly added mention that it may be a qualified schema name.
Rod Taylor
Bruce Momjian [Thu, 12 Jun 2003 07:52:51 +0000 (07:52 +0000)]
Attached is a patch that enhances the output of psql's HTML mode.
The output now validates as HTML 4.01 Strict, XHTML 1.0 strict,
and XHTML 1.1 (assuming you wrap it in a valid html/body document).
It also wraps the output of PGRES_COMMAND_OK if the HTML tag is on,
for full compliance: this is why html_escaped_print has to be
externalized.
Greg Sabino Mullane greg@turnstep.com
Bruce Momjian [Thu, 12 Jun 2003 07:49:43 +0000 (07:49 +0000)]
Brief note about sequence cache not being cleared in other backends.
Actually clear the cache in the backend making the alteration. This
follows in the footsteps of setval().
Rod Taylor
Bruce Momjian [Thu, 12 Jun 2003 07:36:51 +0000 (07:36 +0000)]
IPv6 cleanups.
Kurt Roeckx
Andrew Dunstan
Bruce Momjian [Thu, 12 Jun 2003 07:00:57 +0000 (07:00 +0000)]
Back out this patch because it is patched inside a later patch.
---------------------------------------------------------------------------
here is a patch that allows CIDR netmasks in pg_hba.conf. It allows two
address/mask forms:
. address/maskbits, or
. address netmask (as now)
If the patch is accepted I will submit a documentation patch to cover
it.
This is submitted by agreement with Kurt Roeckx, who has worked on a
patch that covers this and other IPv6 issues.
Bruce Momjian [Thu, 12 Jun 2003 02:15:09 +0000 (02:15 +0000)]
I succeeded by fixing up setup.py:
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
--- setup.py~ Tue Mar 19 08:21:14 2002
+++ setup.py Wed May 14 15:10:30 2003
@@ -30,8 +30,8 @@
optional_libs=[ 'libpqdll', 'wsock32', 'advapi32' ]
data_files = [ 'libpq.dll' ]
else:
- include_dirs=['/usr/include/pgsql']
- library_dirs=['usr/lib/pgsql']
+ include_dirs=['../../include','../libpq','/usr/include/pgsql']
+ library_dirs=['../libpq','/usr/lib/pgsql']
optional_libs=['pq']
data_files = []
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
George Young
Bruce Momjian [Thu, 12 Jun 2003 02:12:58 +0000 (02:12 +0000)]
Here is a patch that allows CIDR netmasks in pg_hba.conf. It allows two
address/mask forms:
. address/maskbits, or
. address netmask (as now)
If the patch is accepted I will submit a documentation patch to cover
it.
This is submitted by agreement with Kurt Roeckx, who has worked on a
patch that covers this and other IPv6 issues.
Andrew Dunstan
Bruce Momjian [Thu, 12 Jun 2003 02:02:24 +0000 (02:02 +0000)]
Add Linux restart --- Slawomir Sudnik
Add "-l $PGLOG" for restart --- Darko Prenosil
Bruce Momjian [Thu, 12 Jun 2003 01:42:21 +0000 (01:42 +0000)]
Up to now, SerializableSnapshot and QuerySnapshot are malloc'ed and
free'd for every transaction or statement, respectively. This patch
puts these data structures into static memory, thus saving a few CPU
cycles and two malloc calls per transaction or (in isolation level
READ COMMITTED) per query.
Manfred Koizar
Bruce Momjian [Thu, 12 Jun 2003 01:38:08 +0000 (01:38 +0000)]
psql: tab completion for \encoding
Ian Barwick
Bruce Momjian [Thu, 12 Jun 2003 01:36:44 +0000 (01:36 +0000)]
This patch updates pg_autovacuum in several ways:
* A few bug fixes
* fixes solaris compile and crash issue
* decouple vacuum analyze and analyze thresholds
* detach from tty (dameonize)
* improved logging layout
* more conservative default configuration
* improved, expanded and updated README
please apply and 1st convenience, or before code freeze which ever comes
first :-)
At this point I think I have brought pg_autovacuum and its client side
design as far as I think it should go. It works, keeping file sizes in
check, helps performance and give the administrator a fair amount
flexibility in configuring it.
Next up is to do the FSM based design that is integrated into the back
end.
p.s. Thanks to Christopher Browne for his help.
Matthew T. O'Connor
Bruce Momjian [Thu, 12 Jun 2003 01:17:19 +0000 (01:17 +0000)]
I found the libpq function PGunescapeBytea a little slow. It was taking a
minute and a half to decode a 500Kb on a fairly fast machine. I think the
culprit is sscanf.
I attach a patch that replaces the function with one used to perform the same
task in pyPgSQL (a Python interface to PostgreSQL). This code was written by
Billy Allie, author of pyPgSQL. I've changed a few variable names to match
those in the original code and removed a bit of Pythonness.
Billy has kindly looked at the code and points out that it is slightly
stricter than the original implementation and if it encounters an invalid
bytea such as '\12C' it drops the unescape '\' and outputs '12C'.
The code is licensed by the author under a BSD license.
I've performed limited testing of the function by putting JPEGs into
PostgreSQL, extracting them using them using the new function and diffing
against the original files.
The new function is significantly faster on my machine with the JPEGs being
decoded in less than a second. I attach a modified libpq example program that
I used for my testing.
Ben Lamb.
Bruce Momjian [Wed, 11 Jun 2003 22:37:46 +0000 (22:37 +0000)]
This patch extracts page buffer pooling and the simple
least-recently-used strategy from clog.c into slru.c. It doesn't
change any visible behaviour and passes all regression tests plus a
TruncateCLOG test done manually.
Apart from refactoring I made a little change to SlruRecentlyUsed,
formerly ClogRecentlyUsed: It now skips incrementing lru_counts, if
slotno is already the LRU slot, thus saving a few CPU cycles. To make
this work, lru_counts are initialised to 1 in SimpleLruInit.
SimpleLru will be used by pg_subtrans (part of the nested transactions
project), so the main purpose of this patch is to avoid future code
duplication.
Manfred Koizar
Bruce Momjian [Wed, 11 Jun 2003 22:13:22 +0000 (22:13 +0000)]
Add add_missing_from GUC variable.
Nigel J. Andrews
Bruce Momjian [Wed, 11 Jun 2003 21:39:00 +0000 (21:39 +0000)]
Done:
* -Add config variable to prevent auto-adding missing FROM-clause tables
Tom Lane [Wed, 11 Jun 2003 19:43:36 +0000 (19:43 +0000)]
Update expected file to match new _int.sql.
Bruce Momjian [Wed, 11 Jun 2003 19:31:05 +0000 (19:31 +0000)]
Add missing intarray files.
Bruce Momjian [Wed, 11 Jun 2003 18:49:00 +0000 (18:49 +0000)]
Make "log_min_duration_statement" SUSET --- will be adjusted with new
USERLIMIT patch.
Bruce Momjian [Wed, 11 Jun 2003 18:44:15 +0000 (18:44 +0000)]
Changes:
1 intarray: bugfix for int[]-int[] operation
2 intarray: split _int.c to several files (_int.c now is unused)
3 ntarray (gist__intbig_ops opclass): use special type for index storage
4 ltree (gist__ltree_ops opclass), intarray (gist__intbig_ops): optimize
GiST's
penalty and picksplit interface functions, now use Hemming distance.
Teodor Sigaev
Tom Lane [Wed, 11 Jun 2003 18:33:39 +0000 (18:33 +0000)]
Fix brain damage in deciding which python input converter to use.
Bruce Momjian [Wed, 11 Jun 2003 18:01:14 +0000 (18:01 +0000)]
Add log_min_duration_statement.
Christopher Kings-Lynne
Tom Lane [Wed, 11 Jun 2003 16:29:42 +0000 (16:29 +0000)]
pg_dump and pg_restore were stripping quotes and downcasing some but
not all SQL identifiers taken from command line arguments. We decided
years ago that that was a bad idea: identifiers taken from the command
line should be treated as literally correct. Remove the inconsistent
code that has crept in recently. Also fix pg_dump so that the combination
of --schema and --table does what you'd expect, namely dump exactly one
table from exactly one schema. Per gripe from Deepak Bhole of Red Hat.
Tom Lane [Wed, 11 Jun 2003 15:28:55 +0000 (15:28 +0000)]
Update anonymous-CVS instructions.
Bruce Momjian [Wed, 11 Jun 2003 15:05:50 +0000 (15:05 +0000)]
Well, the discussion about SSL a bit back perked my interest and I did
some reading on the subject.
1) PostgreSQL uses ephemeral keying, for its connections (good thing)
2) PostgreSQL doesn't set the cipher list that it allows (bad thing,
fixed)
3) PostgreSQL's renegotiation code wasn't text book correct (could be
bad, fixed)
4) The rate of renegotiating was insanely low (as Tom pointed out, set
to a more reasonable level)
I haven't checked around much to see if there are any other SSL bits
that need some review, but I'm doing some OpenSSL work right now
and'll send patches for improvements along the way (if I find them).
At the very least, the changes in this patch will make security folks
happier for sure. The constant renegotiation of sessions was likely a
boon to systems that had bad entropy gathering means (read: Slowaris
/dev/rand|/dev/urand != ANDIrand). The new limit for renegotiations
is 512MB which should be much more reasonable.
Sean Chittenden
Bruce Momjian [Wed, 11 Jun 2003 15:02:25 +0000 (15:02 +0000)]
During looking stuff up for a discussion on -general, I realized that
I'd placed the check for newly created matching pk rows for on update no
action earlier than it needed to be so that it'd check even when the key
values hadn't changed. This patch moves it to after checking for NULLs
in the old row and comparing the values since the select's probably more
expensive.
Stephan Szabo
Bruce Momjian [Wed, 11 Jun 2003 15:01:15 +0000 (15:01 +0000)]
Add missing DLLIMPORT for cpu_index_tuple_cost to
src/include/optimizer/cost.h.
This is required to compile the PostGIS extension module with Cygwin
http://postgis.refractions.net
Norman Vine
Tom Lane [Wed, 11 Jun 2003 14:14:50 +0000 (14:14 +0000)]
Now that I look, that link doesn't belong there at all, does it?
Tom Lane [Wed, 11 Jun 2003 14:07:00 +0000 (14:07 +0000)]
Fix busted markup.
Tom Lane [Wed, 11 Jun 2003 14:02:57 +0000 (14:02 +0000)]
Remove platform-specific executable; does not belong in distribution.
Peter Eisentraut [Wed, 11 Jun 2003 09:23:55 +0000 (09:23 +0000)]
Represent grant options in the information schema.
Bruce Momjian [Wed, 11 Jun 2003 06:56:07 +0000 (06:56 +0000)]
Add Rendezvous support to postmaster, from Chris Campbell
Michael Meskes [Wed, 11 Jun 2003 06:39:13 +0000 (06:39 +0000)]
Make sure a variable is no longer referenced when it is removed.
Fixed counting bug in parsing "->" operator.
Removed that silly debugging function I accidently committed last night.
Bruce Momjian [Wed, 11 Jun 2003 05:13:12 +0000 (05:13 +0000)]
Document the -h client flag can use a socket directory as well as a host
name.
Bruce Momjian [Wed, 11 Jun 2003 05:04:51 +0000 (05:04 +0000)]
Remove lock* GUC variables from postgresql.conf.
Document why certain GUC variables aren't in postgresql.conf.
Michael Meskes [Tue, 10 Jun 2003 17:46:43 +0000 (17:46 +0000)]
Fixed some bugs.
Tatsuo Ishii [Tue, 10 Jun 2003 09:07:15 +0000 (09:07 +0000)]
Fix uninitialized memory bug
Add support for PGHOST, PGPORT, PGUSER environment variables
Tom Lane [Mon, 9 Jun 2003 17:59:19 +0000 (17:59 +0000)]
freeaddrinfo2() does need two parameters after all, per comment by
Kurt Roeckx. Add some documentation to try to prevent others from
repeating my mistake.
Tom Lane [Mon, 9 Jun 2003 03:41:47 +0000 (03:41 +0000)]
Make bison version test actually work ...
Tom Lane [Sun, 8 Jun 2003 17:43:00 +0000 (17:43 +0000)]
libpq can now talk to either 3.0 or 2.0 protocol servers. It first tries
protocol 3, then falls back to 2 if postmaster rejects the startup packet
with an old-format error message. A side benefit of the rewrite is that
SSL-encrypted connections can now be made without blocking. (I think,
anyway, but do not have a good way to test.)
Bruce Momjian [Sat, 7 Jun 2003 16:32:05 +0000 (16:32 +0000)]
Change configure check to use $YACC, per Tom.
Bruce Momjian [Sat, 7 Jun 2003 16:27:02 +0000 (16:27 +0000)]
Remove kerberos mention that doesn't support our software, from Peter.
Bruce Momjian [Fri, 6 Jun 2003 22:21:35 +0000 (22:21 +0000)]
Update German FAQ, from Ian Barwick.
Bruce Momjian [Fri, 6 Jun 2003 22:20:40 +0000 (22:20 +0000)]
Update FAQ from Ian Barwick.
Bruce Momjian [Fri, 6 Jun 2003 22:17:42 +0000 (22:17 +0000)]
Add -DFRONTEND for non-MinGW Win32 ports.
Bruce Momjian [Fri, 6 Jun 2003 19:46:20 +0000 (19:46 +0000)]
Add:
> o Have COPY return number of rows loaded/unloaded
Bruce Momjian [Fri, 6 Jun 2003 19:11:55 +0000 (19:11 +0000)]
Add configure warning to check for bison version >= 1.875.
Bruce Momjian [Fri, 6 Jun 2003 18:09:17 +0000 (18:09 +0000)]
Add mention of two auth_mod kerberos projects, from Daniel Kouril
Tom Lane [Fri, 6 Jun 2003 16:25:35 +0000 (16:25 +0000)]
Add defense in assign_session_authorization() against trying to do
catalog lookups when not in a transaction. This prevents bizarre
failures if someone tries to set a value for session_authorization in
postgresql.conf. Per report from Fernando Nasser.
Bruce Momjian [Fri, 6 Jun 2003 15:56:14 +0000 (15:56 +0000)]
Add:
> * Add checks for fclose() failure
Bruce Momjian [Fri, 6 Jun 2003 15:31:46 +0000 (15:31 +0000)]
Remove mention of ALTER USER able to remove passwords.
Tom Lane [Fri, 6 Jun 2003 15:04:03 +0000 (15:04 +0000)]
Implement outer-level aggregates to conform to the SQL spec, with
extensions to support our historical behavior. An aggregate belongs
to the closest query level of any of the variables in its argument,
or the current query level if there are no variables (e.g., COUNT(*)).
The implementation involves adding an agglevelsup field to Aggref,
and treating outer aggregates like outer variables at planning time.
Peter Eisentraut [Fri, 6 Jun 2003 14:17:08 +0000 (14:17 +0000)]
Update documentation build instructions.
Peter Eisentraut [Thu, 5 Jun 2003 16:08:47 +0000 (16:08 +0000)]
Information schema views about functions
Peter Eisentraut [Thu, 5 Jun 2003 16:07:25 +0000 (16:07 +0000)]
Support for Intel compiler on Linux
Tom Lane [Mon, 2 Jun 2003 19:00:29 +0000 (19:00 +0000)]
Make the world at least marginally safe for usernames with embedded spaces.
Per recent gripe.
Bruce Momjian [Mon, 2 Jun 2003 18:59:25 +0000 (18:59 +0000)]
In src/include/mb/pg_wchar.h we have:
#define PG_ENCODING_BE_LAST PG_ISO_8859_8
#define PG_ENCODING_FE_LAST PG_WIN1256
but the last client encoding in the enum list is actually PG_GB18030 and
it seems that
#define PG_ENCODING_IS_CLIEN_ONLY(_enc) \
(((_enc) > PG_ENCODING_BE_LAST && (_enc) <= PG_ENCODING_FE_LAST)
can never be true.
I think the define should read
#define PG_ENCODING_FE_LAST PG_GB18030
On the other hand, perhaps no-one cares, because
PG_ENCODING_IS_CLIEN_ONLY is never used.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Bruce Momjian [Mon, 2 Jun 2003 18:51:43 +0000 (18:51 +0000)]
Add:
> * Allow logging of only data definition(DDL), or DDL and modification statements
Bruce Momjian [Mon, 2 Jun 2003 18:42:31 +0000 (18:42 +0000)]
Add:
> * Allow a single index to index multiple tables (for inheritance and subtables)
408a410
> * Improve the planner to use CHECK constraints to prune the plan (for subtables)
418a421
> * Allow partitioning of table into multiple subtables
419a423
> T
Bruce Momjian [Mon, 2 Jun 2003 18:36:24 +0000 (18:36 +0000)]
Add data partitioning idea to tablespaces discussion.
Bruce Momjian [Mon, 2 Jun 2003 18:16:56 +0000 (18:16 +0000)]
Add Turkish FAQ, from Devrim GUNDUZ.
Bruce Momjian [Mon, 2 Jun 2003 17:26:16 +0000 (17:26 +0000)]
Add:
> * Allow SET CONSTRAINTS to be qualified by schema/table
Bruce Momjian [Mon, 2 Jun 2003 16:39:06 +0000 (16:39 +0000)]
Update Russian FAQ, from Viktor Vislobokov
Michael Meskes [Mon, 2 Jun 2003 15:38:02 +0000 (15:38 +0000)]
Fixed segfault in forward definition parsing.
Bruce Momjian [Mon, 2 Jun 2003 15:01:03 +0000 (15:01 +0000)]
Update URL to point to proper location.
Bruce Momjian [Mon, 2 Jun 2003 04:35:04 +0000 (04:35 +0000)]
Update Emacs settings, from Andrew Dunstan
Bruce Momjian [Sun, 1 Jun 2003 04:31:33 +0000 (04:31 +0000)]
Add:
> * Add config variable to prevent auto-adding missing FROM-clause tables
Tom Lane [Sat, 31 May 2003 19:03:34 +0000 (19:03 +0000)]
markTargetListOrigin neglected to handle outer-scope Vars properly;
per report from Joe Conway.
Bruce Momjian [Sat, 31 May 2003 02:54:57 +0000 (02:54 +0000)]
Add:
> * Prevent whole-row references from leaking memory, e.g. SELECT COUNT(tab.*)
Bruce Momjian [Sat, 31 May 2003 02:31:50 +0000 (02:31 +0000)]
Add:
> * Consider using MVCC to cache count(*) queries with no WHERE clause
Bruce Momjian [Sat, 31 May 2003 02:25:11 +0000 (02:25 +0000)]
Add item about sending success stories to advocacy.postgresql.org.
Tom Lane [Fri, 30 May 2003 23:55:10 +0000 (23:55 +0000)]
Cause pg_dumpall to support the -a, -s, -x options of pg_dump.
Tom Lane [Fri, 30 May 2003 22:55:16 +0000 (22:55 +0000)]
Cause pg_dumpall to include GRANT/REVOKE for database-level permissions
in its output. Make it work with server versions back to 7.0, too.
Tom Lane [Fri, 30 May 2003 20:23:10 +0000 (20:23 +0000)]
Small performance improvement for hash joins and hash aggregation:
when the plan is ReScanned, we don't have to rebuild the hash table
if there is no parameter change for its child node. This idea has
been used for a long time in Sort and Material nodes, but was not in
the hash code till now.
Michael Meskes [Fri, 30 May 2003 13:22:02 +0000 (13:22 +0000)]
Create a real prototype function for describe.
Michael Meskes [Fri, 30 May 2003 08:39:01 +0000 (08:39 +0000)]
Sync and some minor cleanup/fixing work plus an EXEC SQL DESCRIBE prototype.
Tom Lane [Thu, 29 May 2003 22:30:02 +0000 (22:30 +0000)]
Ensure that in all flex lexers that are part of the backend, a
yy_fatal_error() call results in elog(ERROR) not exit(). This was
already fixed in the main lexer and plpgsql, but extend same technique
to all the other dot-l files. Also, on review of the possible calls
to yy_fatal_error(), it seems safe to use elog(ERROR) not elog(FATAL).
Barry Lind [Thu, 29 May 2003 21:44:47 +0000 (21:44 +0000)]
one more change to correctly support the removeall of autocommit
Tom Lane [Thu, 29 May 2003 20:40:36 +0000 (20:40 +0000)]
Adopt latest bison's spelling of 'syntax error' rather than 'parse error'
for grammar-detected problems. Revert Makefile hack that kept it looking
like the pre-bison-1.875 output.
Tom Lane [Thu, 29 May 2003 19:15:34 +0000 (19:15 +0000)]
Don't explicitly close() the session socket during backend exit; instead
leave it for the kernel to do after the process dies. This allows clients
to wait for the backend to exit if they wish (after sending X message,
wait till EOF is detected on the socket).
Tom Lane [Thu, 29 May 2003 18:08:42 +0000 (18:08 +0000)]
AFAICT, none of our shared libraries are anywhere near big enough to
need -fPIC on HPPA. Reduce to -fpic.
Michael Meskes [Thu, 29 May 2003 13:59:26 +0000 (13:59 +0000)]
Changed variable parsing so struct[n].attr works.
Michael Meskes [Thu, 29 May 2003 12:00:22 +0000 (12:00 +0000)]
Parse forward definiton of structs.
Barry Lind [Thu, 29 May 2003 04:52:44 +0000 (04:52 +0000)]
Applied patch from Fernando Nasser to fix up small type error
Barry Lind [Thu, 29 May 2003 04:48:33 +0000 (04:48 +0000)]
Applied patch from Fernando Nasser to improve buffer sizes to avoid unnecessary resizing.
Barry Lind [Thu, 29 May 2003 04:39:51 +0000 (04:39 +0000)]
clean up warnings produced by Eclipse
Barry Lind [Thu, 29 May 2003 04:04:08 +0000 (04:04 +0000)]
Adding .cvsignore files for Eclipse IDE
Barry Lind [Thu, 29 May 2003 03:22:48 +0000 (03:22 +0000)]
Up the build number to reflect the changes for V3 protocol support
Barry Lind [Thu, 29 May 2003 03:21:32 +0000 (03:21 +0000)]
Initial attempt to integrate in V3 protocol support. This is still a work in
progress, although all RTs pass using the V3 protocol on a 7.4 database and also pass using the V2 protocol on a 7.3 database.
SSL support is known not to work.
Modified Files:
jdbc/org/postgresql/PGConnection.java
jdbc/org/postgresql/errors.properties
jdbc/org/postgresql/core/BaseConnection.java
jdbc/org/postgresql/core/Encoding.java
jdbc/org/postgresql/core/Field.java
jdbc/org/postgresql/core/PGStream.java
jdbc/org/postgresql/core/QueryExecutor.java
jdbc/org/postgresql/core/StartupPacket.java
jdbc/org/postgresql/fastpath/Fastpath.java
jdbc/org/postgresql/fastpath/FastpathArg.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
jdbc/org/postgresql/test/jdbc2/BlobTest.java
jdbc/org/postgresql/test/jdbc2/CallableStmtTest.java
jdbc/org/postgresql/test/jdbc2/MiscTest.java
jdbc/org/postgresql/test/jdbc3/Jdbc3TestSuite.java
Tom Lane [Thu, 29 May 2003 01:09:13 +0000 (01:09 +0000)]
Add a regression test to catch future silliness in the index-building
area...
Tom Lane [Thu, 29 May 2003 00:54:42 +0000 (00:54 +0000)]
Fix stupid oversight :-(
Tom Lane [Wed, 28 May 2003 23:06:16 +0000 (23:06 +0000)]
Knock down a couple more lappend() hotspots for large WHERE clauses.
Tom Lane [Wed, 28 May 2003 22:32:50 +0000 (22:32 +0000)]
Fix some planner performance problems with large WHERE clauses, by
introducing new 'FastList' list-construction subroutines to use in
hot spots. This avoids the O(N^2) behavior of repeated lappend's
by keeping a tail pointer, while not changing behavior by reversing
list order as the lcons() method would do.
Tom Lane [Wed, 28 May 2003 19:36:28 +0000 (19:36 +0000)]
Fix breakage of LINUX_PROFILE code due to recent Windows changes.
Tom Lane [Wed, 28 May 2003 18:19:09 +0000 (18:19 +0000)]
Fix things so that an error occuring during standalone-backend processing
in initdb will result in exit(1), allowing the initdb script to realize
that there's something wrong.
Tom Lane [Wed, 28 May 2003 17:25:02 +0000 (17:25 +0000)]
In bootstrap and standalone-backend modes, do not sort LOG elevel out
of order; the 'server log' output is actually client output in these
scenarios and we ought to treat elevels the same way as in the client
case. This allows initdb to not send backend stderr to /dev/null anymore,
which makes it much more likely that people will notice problems during
initdb.
Tom Lane [Wed, 28 May 2003 16:04:02 +0000 (16:04 +0000)]
Replace functional-index facility with expressional indexes. Any column
of an index can now be a computed expression instead of a simple variable.
Restrictions on expressions are the same as for predicates (only immutable
functions, no sub-selects). This fixes problems recently introduced with
inlining SQL functions, because the inlining transformation is applied to
both expression trees so the planner can still match them up. Along the
way, improve efficiency of handling index predicates (both predicates and
index expressions are now cached by the relcache) and fix 7.3 oversight
that didn't record dependencies of predicate expressions.
Bruce Momjian [Wed, 28 May 2003 05:02:38 +0000 (05:02 +0000)]
Add to thread discussion.
Bruce Momjian [Wed, 28 May 2003 04:35:28 +0000 (04:35 +0000)]
Add info about selecting a random row.
Peter Eisentraut [Tue, 27 May 2003 19:36:55 +0000 (19:36 +0000)]
Internationalize interactive yes/no responses.
Bruce Momjian [Tue, 27 May 2003 17:55:50 +0000 (17:55 +0000)]
Make log_ GUC settings controllable only by super-users, so non-super
users can't turn it off.