summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
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.
2003-05-28Add to thread discussion.Bruce Momjian
2003-05-28Add info about selecting a random row.Bruce Momjian
2003-05-27Internationalize interactive yes/no responses.Peter Eisentraut
2003-05-27Make log_ GUC settings controllable only by super-users, so non-superBruce Momjian
users can't turn it off.
2003-05-27Make debug_ GUC varables output DEBUG1 rather than LOG, and mention inBruce Momjian
docs that CLIENT/LOG_MIN_MESSAGES now controls debug_* output location. Doc changes included.
2003-05-27Add configure thread tests.Bruce Momjian
2003-05-27Allow input from stdin and output to stdout.Michael Meskes
2003-05-27Fixed incorrect output for some structs.Michael Meskes
2003-05-26Adjust error-handling logic in libpq. For the first time, libpq copesTom Lane
sanely with running out of memory for a query result.
2003-05-26Add item for changing a column's data type.Bruce Momjian
2003-05-26Fix misstatement in release-notes item.Tom Lane
2003-05-26Update:Bruce Momjian
< * Add now("transaction|statement|clock") functionality > * Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality
2003-05-26Make sure printtup() always sends the number of columns previouslyTom Lane
advertised in RowDescription message. Depending on the physical tuple's column count is not really correct, since according to heap_getattr() conventions the tuple may be short some columns, which will automatically get read as nulls. Problem has been latent since forever, but was only exposed by recent change to skip a projection step in SELECT * FROM...
2003-05-26Add documentation to 'createuser' that ALTER USER must be used to add orBruce Momjian
modify passwords, per user confusion report. Also clean up wording that command line utils need database access.
2003-05-26Add:Bruce Momjian
> * Allow UPDATE to use SET col = DEFAULT
2003-05-26Remove comment that cbrt() isn't being used.Bruce Momjian
2003-05-26Cause CHAR(n) to TEXT or VARCHAR conversion to automatically strip trailingTom Lane
blanks, in hopes of reducing the surprise factor for newbies. Remove redundant operators for VARCHAR (it depends wholly on TEXT operations now). Clean up resolution of ambiguous operators/functions to avoid surprising choices for domains: domains are treated as equivalent to their base types and binary-coercibility is no longer considered a preference item when choosing among multiple operators/functions. IsBinaryCoercible now correctly reflects the notion that you need *only* relabel the type to get from type A to type B: that is, a domain is binary-coercible to its base type, but not vice versa. Various marginal cleanup, including merging the essentially duplicate resolution code in parse_func.c and parse_oper.c. Improve opr_sanity regression test to understand about binary compatibility (using pg_cast), and fix a couple of small errors in the catalogs revealed thereby. Restructure "special operator" handling to fetch operators via index opclasses rather than hardwiring assumptions about names (cleans up the pattern_ops stuff a little).
2003-05-25Information schema improvementsPeter Eisentraut
2003-05-25Clean up our static cbrt() implementation in float.c.Bruce Momjian
2003-05-25Move item:Bruce Momjian
< * Update clients to use data types, typmod, schema.table.column names of < result sets using new query protocol 453a452,453 > o Update clients to use data types, typmod, schema.table.column names of > result sets using new query protocol
2003-05-25Update:Bruce Momjian
< * Allow clients to get data types, typmod, schema.table.column names from < result sets, either via the backend protocol or a new QUERYINFO command to: > * Update clients to use data types, typmod, schema.table.column names of > result sets using new query protocol
2003-05-24Add:Bruce Momjian
> * Allow clients to get data types, typmod, schema.table.column names from > result sets, either via the backend protocol or a new QUERYINFO command
2003-05-24Update XML items:Bruce Momjian
> * Allow backend to output result sets in XML > * Add XML capability to pg_dump and COPY, when backend XML capability
2003-05-24Added:Bruce Momjian
> * Find a way to reduce rotational delay when repeatedly writing > last WAL page
2003-05-24Add cost estimate discussion to TODO.detail.Bruce Momjian