summaryrefslogtreecommitdiff
path: root/src/bin/psql
AgeCommit message (Collapse)Author
2002-11-01Avoid malloc(0) when printing a table of no columns. On some platformsTom Lane
this returns NULL, which confuses the code.
2002-10-29Add popen/pclose -> _popen/_pclose() mapping for Win32.Bruce Momjian
2002-10-29getopt.c now in /port, for MS Win.Bruce Momjian
2002-10-24Fix include files for new PageOutput call.Bruce Momjian
2002-10-23Page \h output and centralize psql paging code in PageOutput().Bruce Momjian
2002-10-19Make psql's \df display functions that return sets as having return typeTom Lane
'setof something'; formerly you could not tell at all that the function returns set.
2002-10-19Fix psql's \copy to accept table names containing schemas, as well asTom Lane
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.
2002-10-18Improve formatting of --help output.Peter Eisentraut
2002-10-15Fix unintentional breakage of COPY TO/FROM stdin. Mea culpa.Tom Lane
2002-10-15Fix psql to cope with autocommit off, at least during startup.Tom Lane
Behavior of backslash commands (especially for large objects) may still require some thought.
2002-10-14Translation updatesPeter Eisentraut
2002-10-12psql thought that backslash is an escape character inside double quotes.Tom Lane
It isn't.
2002-10-03The attached patch fixes a number of issues related to compiling theBruce Momjian
client utilities (libpq.dll and psql.exe) for win32 (missing defines, adjustments to includes, pedantic casting, non-existent functions) per: http://developer.postgresql.org/docs/postgres/install-win32.html. It compiles cleanly under Windows 2000 using Visual Studio .net. Also compiles clean and passes all regression tests (regular and contrib) under Linux. In addition to a review by the usual suspects, it would be very desirable for someone well versed in the peculiarities of win32 to take a look. Joe Conway
2002-09-22Translation updates, some messages tweaked.Peter Eisentraut
2002-09-22Make \dS work more like it used to, viz, show only system objects.Tom Lane
2002-09-14Avoid overflow for large elapsed times in \timing output. PerTom Lane
Kenji Sugita.
2002-09-14Translation updatesPeter Eisentraut
2002-09-11Add sprompt.obj to Win32 makefiles.Bruce Momjian
2002-09-06Fix printf() quote handling and improper exit(), per Tom.Bruce Momjian
2002-09-05Remove PGPASSWORDFILE and default to always trying $HOME/.pgpass.Bruce Momjian
Cleanup up memory allocation for $HOME in related psql places. Update mention of $HOME/.pgpass in the docs; add mention in pg_dumpall.
2002-09-04pgindent run.Bruce Momjian
2002-09-03Remove all traces of multibyte and locale options. Clean up commentsPeter Eisentraut
referring to "multibyte" where it really means character encoding.
2002-09-02Translation updatesPeter Eisentraut
2002-09-02Tab completion in psql is missing the REINDEX command.Bruce Momjian
Alvaro Herrera
2002-09-02I checked all the previous string handling errors and most of them wereBruce Momjian
already fixed by You. However there were a few left and attached patch should fix the rest of them. I used StringInfo only in 2 places and both of them are inside debug ifdefs. Only performance penalty will come from using strlen() like all the other code does. I also modified some of the already patched parts by changing snprintf(buf, 2 * BUFSIZE, ... style lines to snprintf(buf, sizeof(buf), ... where buf is an array. Jukka Holappa
2002-09-02Add GUC variable to print original query to the server logs when thereBruce Momjian
is an error, warning, etc. Gavin Sherry
2002-09-01Improve footer length computation for psql.Bruce Momjian
Greg Sabino Mullan
2002-09-01Add log_duration to GUC/postgresql.conf.Bruce Momjian
Rename debug_print_query to log_statement and rename show_query_stats to show_statement_stats.
2002-08-30AUTOCOMMIT mode is now an available backend GUC variable; setting itTom Lane
to false provides more SQL-spec-compliant behavior than we had before. I am not sure that setting it false is actually a good idea yet; there is a lot of client-side code that will probably be broken by turning autocommit off. But it's a start. Loosely based on a patch by David Van Wie.
2002-08-30Back out unintented tab change.Bruce Momjian
2002-08-30Remove pgaccess from Makefile.Bruce Momjian
2002-08-29Code review for standalone composite types, query-specified compositeTom Lane
types, SRFs. Not happy with memory management yet, but I'll commit these other changes.
2002-08-28Updates from Dennis BjorklundPeter Eisentraut
2002-08-28backend where a statically sized buffer is written to. Most of theseBruce Momjian
should be pretty safe in practice, but it's probably better to be safe than sorry. I was actually looking for cases where NAMEDATALEN is assumed to be 32, but only found one. That's fixed too, as well as a few bits of code cleanup. Neil Conway
2002-08-27Enable locale, so case conversion (identifier processing) and numberPeter Eisentraut
formatting (\timing) works correctly. Change "Total time" to "Time" since there is nothing that "total" refers to. Remove non-multibyte code.
2002-08-27Add '+' mention in \? help. More clean of \? to do.Bruce Momjian
2002-08-24The cstring datatype can now be copied, passed around, etc. The typlenTom Lane
value '-2' is used to indicate a variable-width type whose width is computed as strlen(datum)+1. Everything that looks at typlen is updated except for array support, which Joe Conway is working on; at the moment it wouldn't work to try to create an array of cstring.
2002-08-22Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane
with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
2002-08-21Move PO files into subdirectories separate from the source code.Peter Eisentraut
2002-08-16Modify pg_dump to dump foreign-key constraints as constraints, not asTom Lane
sets of triggers. Also modify psql \d command to show foreign key constraints as such and hide the triggers. pg_get_constraintdef() function added to backend to support these. From Rod Taylor, code review and some editorialization by Tom Lane.
2002-08-15Tom Lane wrote:Bruce Momjian
> There's no longer a separate call to heap_storage_create in that routine > --- the right place to make the test is now in the storage_create > boolean parameter being passed to heap_create. A simple change, but > it passeth patch's understanding ... Thanks. Attached is a patch against cvs tip as of 8:30 PM PST or so. Turned out that even after fixing the failed hunks, there was a new spot in bufmgr.c which needed to be fixed (related to temp relations; RelationUpdateNumberOfBlocks). But thankfully the regression test code caught it :-) Joe Conway
2002-08-15The second enables tab-complete to analyze. It ignores schema stuff (soBruce Momjian
does every tab-completion command AFAICS) Alvaro Herrera
2002-08-14I guess I'd vote for changing the code to beBruce Momjian
sys = malloc(strlen(editorName) + strlen(fname) + 10 + 1); if (!sys) return false; sprintf(sys, "exec '%s' '%s'", editorName, fname); (note the added quotes to provide a little protection against spaces and such). Then it's perfectly obvious what the calculation is doing. I don't care about wasting 20-some bytes, but confusing readers of the code is worth avoiding. regards, tom lane
2002-08-13Put back old code.Bruce Momjian
2002-08-13Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per ↵Bruce Momjian
discussion on hackers.
2002-08-10psql prints its version number in its startup message, per recentTom Lane
discussion. Also, cause the \timing command to display time in a format consistent with the backend's EXPLAIN ANALYZE output.
2002-08-10Make sure all clients have the same understanding of default user namePeter Eisentraut
and database. In particular, make script wrappers understand the PGDATABASE environment variable.
2002-08-10Get rid of double PQclear(res) in error path.Tom Lane
2002-08-10psql backslash commands are schema-aware. Pattern matching behaviorTom Lane
follows recent pghackers discussion. This commit includes all the relevant fixes from Greg Mullane's patch of 24-June.
2002-08-09Column ordering in \d output should agree with sort ordering;Tom Lane
per Joe Conway's patch of 20-July.