aboutsummaryrefslogtreecommitdiff
path: root/src/bin
Commit message (Collapse)AuthorAge
* Adjust lo type in contrib during pg_restore so that pg_restore couldHiroshi Inoue2003-01-03
| | | | reload the type.
* Attached is a patch to provide makefiles, etc. to allow the compilationBruce Momjian2002-12-30
| | | | | | | of the libpq interface static and dynamic libraries with the freely downloadable Borland C++ compiler version 5.5 and/or C++ Builder. Lester Godwin
* Make use of TCL_INCLUDE_SPEC if available (it's new in Tcl 8.4, too badTom Lane2002-12-30
| | | | it took 'em this long to realize it's needed...)
* Remove overenthusiastic free'ing of comment dependencies; could lead toTom Lane2002-12-27
| | | | core dump in pg_dump when dumping views having comments. See bug #855.
* pg_dump should consider information_schema to be a system schema.Tom Lane2002-12-21
| | | | | | Also, tweak -C option (emit CREATE DATABASE command) to emit encoding name rather than encoding number, for consistency with pg_dumpall and better cross-version portability.
* Fix possible buffer overrun in \d command: substr(..., 128) producesTom Lane2002-12-21
| | | | | | a result of at most 128 chars, but that could be more than 128 bytes. Also ensure we don't try to pfree uninitialized pointers during error cleanup.
* Initial version of the SQL information schemaPeter Eisentraut2002-12-14
|
* Increment libpq major number for 7.3.1 and minor for 7.4.Bruce Momjian2002-12-13
|
* Here's the patch I mentioned on HACKERS to fix up ALTER command tabBruce Momjian2002-12-13
| | | | | | | | | | completion. Note that it's based on 7.3 tarball, not CVS HEAD, or 7.3rel branch. Damn, looking at CVS, this will patch into 7.3rel (just tested, it does) probably collide with Rod Taylor's patch adding ALTER TRIGGER stuff. O.K, second patch attached against HEAD - not tested, hand merged. Ross Reedstrom
* Don't produce bogus COPY command when there are no undropped columnsTom Lane2002-12-12
| | | | in a table.
* TODO marked as done:Bruce Momjian2002-12-12
| | | | | | | | | | | | | | | | | | | | | * Add schema, cast, and conversion backslash commands to psql I had to create a new publically available function, pg_conversion_is_visible, as it seemed to be missing from the catalogs. This required me to do no small amount of hacking around in namespace.c I have updated the \? help and sgml docs. \dc - list conversions [PATTERN] \dC - list casts \dn list schemas I didn't support patterns with casts as there's nothing obvious to match against. Catalog version incremented --- initdb required. Christopher Kings-Lynne
* Don't force rebuild of all of backend/parser when we only needTom Lane2002-12-12
| | | | keywords.o.
* Move psql \? Formatting above Large Object/Copy.Bruce Momjian2002-12-11
|
* psql \? rearrangement, suggested by Tom.Bruce Momjian2002-12-11
|
* Reorder psql \? help into groupings, idea from Harald Armin Massa.Bruce Momjian2002-12-11
|
* Back out psql help change. Not done yet.Bruce Momjian2002-12-11
|
* Bump version for 7.3 and 7.4.Bruce Momjian2002-12-11
|
* Fix pg_dump failure against 7.1 or older servers, perTom Lane2002-12-01
| | | | report from Philip Warner.
* This patch fixes two tiny memory leaks in pg_dump and two in pg_dumpall.Bruce Momjian2002-11-29
| | | | Neil Conway
* Remove check for pg_group file as part of initdb -W password assignmentBruce Momjian2002-11-25
| | | | --- not needed.
* Heres a patch which will create the sql_help.h file on Win32 if itBruce Momjian2002-11-23
| | | | | | | doesn't already exist using an installed copy of perl. I've tested it using perl v5.6.1 from ActiveState and all appears to work. Al Sutton
* This patch implements FOR EACH STATEMENT triggers, per my email toBruce Momjian2002-11-23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | -hackers a couple days ago. Notes/caveats: - added regression tests for the new functionality, all regression tests pass on my machine - added pg_dump support - updated PL/PgSQL to support per-statement triggers; didn't look at the other procedural languages. - there's (even) more code duplication in trigger.c than there was previously. Any suggestions on how to refactor the ExecXXXTriggers() functions to reuse more code would be welcome -- I took a brief look at it, but couldn't see an easy way to do it (there are several subtly-different versions of the code in question) - updated the documentation. I also took the liberty of removing a big chunk of duplicated syntax documentation in the Programmer's Guide on triggers, and moving that information to the CREATE TRIGGER reference page. - I also included some spelling fixes and similar small cleanups I noticed while making the changes. If you'd like me to split those into a separate patch, let me know. Neil Conway
* Quote database name properly when invoking pg_dump. Per report fromTom Lane2002-11-22
| | | | Christopher Kings-Lynne.
* Finish implementation of hashed aggregation. Add enable_hashagg GUCTom Lane2002-11-21
| | | | | | parameter to allow it to be forced off for comparison purposes. Add ORDER BY clauses to a bunch of regression test queries that will otherwise produce randomly-ordered output in the new regime.
* Clean up psql:Bruce Momjian2002-11-15
| | | | | | | | | | | | | | | | | | | | | | | | | Add simple ALTER DATABASE, ALTER TRIGGER, CHECK POINT, CREATE CONVERSION, CREATE DOMAIN, CREATE LANGUAGE, DEALLOCATE, DROP CONVERSION, DROP DOMAIN, DROP LANGUAGE, EXECUTE, PREPARE Complete CAST in CREATE CAST and DROP CAST but doesn't suggest what should follow. Add many more SET / SHOW variables to the list. Taken from SHOW ALL output. Complete a case sensitive search to allow \dD, \dd, \dS, \ds, \h, \H to complete properly. But there are no matches, then try a case insensitive search to allow case conversion. Add all missing help options. \Q<tab> -> \q \dD<tab> -> \dD \dd<tab> -> \dd \D<tab><tab><tab> -> \d (with listing of \d? commands) sel<tab> -> SELECT Rod Taylor
* pg_dump for domain constraints.Bruce Momjian2002-11-15
| | | | Rod Taylor
* Rename:Bruce Momjian2002-11-15
| | | | | | | | | | | | | | ! #show_parser_stats = false ! #show_planner_stats = false ! #show_executor_stats = false ! #show_statement_stats = false TO: ! #log_parser_stats = false ! #log_planner_stats = false ! #log_executor_stats = false ! #log_statement_stats = false
* Rename server_min_messages to log_min_messages. Part of consolidationBruce Momjian2002-11-14
| | | | of log_ settings.
* Here is a patch that does just that, while maintaining theBruce Momjian2002-11-08
| | | | | | | | "traditional" behavior, so the change should be transparent. Use the command "\pset pager always" to turn it on. Anything else does the normal toggle between "on" and "off" Greg Sabino Mullane
* Add extra_float_digits GUC parameter to allow adjustment of displayedTom Lane2002-11-08
| | | | | | | precision for float4, float8, and geometric types. Set it in pg_dump so that float data can be dumped/reloaded exactly (at least on platforms where the float I/O support is properly implemented). Initial patch by Pedro Ferreira, some additional work by Tom Lane.
* Avoid malloc(0) when printing a table of no columns. On some platformsTom Lane2002-11-01
| | | | this returns NULL, which confuses the code.
* Add popen/pclose -> _popen/_pclose() mapping for Win32.Bruce Momjian2002-10-29
|
* getopt.c now in /port, for MS Win.Bruce Momjian2002-10-29
|
* Suppress compile warnings on OS X.Tom Lane2002-10-27
|
* Change to fseeko(), per Philip.Bruce Momjian2002-10-25
|
* Allow fseeko in pg_dump only if fseeko() will work for all supported fileBruce Momjian2002-10-25
| | | | sizes.
* Fix include files for new PageOutput call.Bruce Momjian2002-10-24
|
* Page \h output and centralize psql paging code in PageOutput().Bruce Momjian2002-10-23
|
* Allow 8-byte off_t to properly pg_dump, from Philip Warner with mods by Bruce.Bruce Momjian2002-10-22
|
* Cleanup for CLUSTERDB failure:Bruce Momjian2002-10-21
| | | | | | | | | | | | | | | | | | | On Sat, Oct 19, 2002 at 12:11:32AM +0200, Peter Eisentraut wrote: > $ ./clusterdb > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > clusterdb: While clustering peter, the following failed: > $ > > This could probably handled a little more gracefully. Yes, sorry. A patch for this is attached. Please apply. Alvaro Herrera
* Translation updatesPeter Eisentraut2002-10-21
|
* Returns exit status 1 if invalid encoding name orTatsuo Ishii2002-10-20
| | | | encoding number is given.
* Make psql's \df display functions that return sets as having return typeTom Lane2002-10-19
| | | | | 'setof something'; formerly you could not tell at all that the function returns set.
* Fix psql's \copy to accept table names containing schemas, as well asTom Lane2002-10-19
| | | | | | | a column list. Bring its parsing of quoted names and quoted strings somewhat up to speed --- I believe it now handles all non-error cases the same way the backend would, but weird boundary conditions are not necessarily done the same way.
* Improve formatting of --help output.Peter Eisentraut2002-10-18
|
* Un-break createlang build.Tom Lane2002-10-18
|
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-18
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* Make pg_dump save for autocommit = off.Bruce Momjian2002-10-16
|
* Improve appearance of SET command.Bruce Momjian2002-10-16
|
* Fix script to handle autocommit = 'off' by prepending autocommit 'on' toBruce Momjian2002-10-16
| | | | | | the start of the psql commandline. This is better than adding BEGIN/END because it handles multiple queries well, and allows the return code for psql to return the proper value.