summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2003-06-11Make "log_min_duration_statement" SUSET --- will be adjusted with newBruce Momjian
USERLIMIT patch.
2003-06-11Fix brain damage in deciding which python input converter to use.Tom Lane
2003-06-11Add log_min_duration_statement.Bruce Momjian
Christopher Kings-Lynne
2003-06-11pg_dump and pg_restore were stripping quotes and downcasing some butTom Lane
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.
2003-06-11Well, the discussion about SSL a bit back perked my interest and I didBruce Momjian
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
2003-06-11During looking stuff up for a discussion on -general, I realized thatBruce Momjian
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
2003-06-11Add missing DLLIMPORT for cpu_index_tuple_cost toBruce Momjian
src/include/optimizer/cost.h. This is required to compile the PostGIS extension module with Cygwin http://postgis.refractions.net Norman Vine
2003-06-11Represent grant options in the information schema.Peter Eisentraut
2003-06-11Add Rendezvous support to postmaster, from Chris CampbellBruce Momjian
2003-06-11Make sure a variable is no longer referenced when it is removed.Michael Meskes
Fixed counting bug in parsing "->" operator. Removed that silly debugging function I accidently committed last night.
2003-06-11Document the -h client flag can use a socket directory as well as a hostBruce Momjian
name.
2003-06-11Remove lock* GUC variables from postgresql.conf.Bruce Momjian
Document why certain GUC variables aren't in postgresql.conf.
2003-06-10Fixed some bugs.Michael Meskes
2003-06-09freeaddrinfo2() does need two parameters after all, per comment byTom Lane
Kurt Roeckx. Add some documentation to try to prevent others from repeating my mistake.
2003-06-08libpq can now talk to either 3.0 or 2.0 protocol servers. It first triesTom Lane
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.)
2003-06-06Add -DFRONTEND for non-MinGW Win32 ports.Bruce Momjian
2003-06-06Add defense in assign_session_authorization() against trying to doTom Lane
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.
2003-06-06Implement outer-level aggregates to conform to the SQL spec, withTom Lane
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.
2003-06-05Information schema views about functionsPeter Eisentraut
2003-06-05Support for Intel compiler on LinuxPeter Eisentraut
2003-06-02Make the world at least marginally safe for usernames with embedded spaces.Tom Lane
Per recent gripe.
2003-06-02In src/include/mb/pg_wchar.h we have:Bruce Momjian
#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
2003-06-02Fixed segfault in forward definition parsing.Michael Meskes
2003-05-31markTargetListOrigin neglected to handle outer-scope Vars properly;Tom Lane
per report from Joe Conway.
2003-05-30Cause pg_dumpall to support the -a, -s, -x options of pg_dump.Tom Lane
2003-05-30Cause pg_dumpall to include GRANT/REVOKE for database-level permissionsTom Lane
in its output. Make it work with server versions back to 7.0, too.
2003-05-30Small performance improvement for hash joins and hash aggregation:Tom Lane
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.
2003-05-30Create a real prototype function for describe.Michael Meskes
2003-05-30Sync and some minor cleanup/fixing work plus an EXEC SQL DESCRIBE prototype.Michael Meskes
2003-05-29Ensure that in all flex lexers that are part of the backend, aTom Lane
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).
2003-05-29one more change to correctly support the removeall of autocommitBarry Lind
2003-05-29Adopt latest bison's spelling of 'syntax error' rather than 'parse error'Tom Lane
for grammar-detected problems. Revert Makefile hack that kept it looking like the pre-bison-1.875 output.
2003-05-29Don't explicitly close() the session socket during backend exit; insteadTom Lane
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).
2003-05-29AFAICT, none of our shared libraries are anywhere near big enough toTom Lane
need -fPIC on HPPA. Reduce to -fpic.
2003-05-29Changed variable parsing so struct[n].attr works.Michael Meskes
2003-05-29Parse forward definiton of structs.Michael Meskes
2003-05-29Applied patch from Fernando Nasser to fix up small type errorBarry Lind
2003-05-29Applied patch from Fernando Nasser to improve buffer sizes to avoid ↵Barry Lind
unnecessary resizing.
2003-05-29clean up warnings produced by EclipseBarry Lind
2003-05-29Adding .cvsignore files for Eclipse IDEBarry Lind
2003-05-29Up the build number to reflect the changes for V3 protocol supportBarry Lind
2003-05-29Initial attempt to integrate in V3 protocol support. This is still a work inBarry Lind
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
2003-05-29Add a regression test to catch future silliness in the index-buildingTom Lane
area...
2003-05-29Fix stupid oversight :-(Tom Lane
2003-05-28Knock down a couple more lappend() hotspots for large WHERE clauses.Tom Lane
2003-05-28Fix some planner performance problems with large WHERE clauses, byTom Lane
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.
2003-05-28Fix breakage of LINUX_PROFILE code due to recent Windows changes.Tom Lane
2003-05-28Fix things so that an error occuring during standalone-backend processingTom Lane
in initdb will result in exit(1), allowing the initdb script to realize that there's something wrong.
2003-05-28In bootstrap and standalone-backend modes, do not sort LOG elevel outTom Lane
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.
2003-05-28Replace functional-index facility with expressional indexes. Any columnTom Lane
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.