summaryrefslogtreecommitdiff
path: root/src/bin/psql
AgeCommit message (Collapse)Author
2000-06-17Remove fmgrstamp-h business -- not needed and confusingPeter Eisentraut
Add options to configure to automatically build for Kerberos support; no more editing of make files.
2000-06-10Moved the intricacies of the perl interface build into its own makefilePeter Eisentraut
that now functions as a wrapper around the MakeMaker stuff. It might even behave sensically when we have separate build dirs. Same for plperl, which of course still doesn't work very well. Made sure that plperl respects the choice of --libdir. Added --with-python to automatically build and install the Python interface. Works similarly to the Perl5 stuff. Moved the burden of the distclean targets lower down into the source tree. Eventually, each make file should have its own. Added automatic remaking of makefiles and configure. Currently only for the top-level because of a bug(?) in Autoconf. Use GNU `missing' to work around missing autoconf and aclocal. Start factoring out macros into their own config/*.m4 files to increase readability and organization.
2000-05-26Fix \h SELECT to not show SELECT INTO.Bruce Momjian
2000-05-14That psql option should be --no-readline (as it used to be), not --noreadline.Peter Eisentraut
2000-05-12Back out -\?. Didn't look good to Peter.Bruce Momjian
2000-05-12/home/peter/commit-msgPeter Eisentraut
2000-05-12Small cleanup of file.Bruce Momjian
2000-05-11More psql help cleanupBruce Momjian
2000-05-11Makefile CFLAGS cleanups.Bruce Momjian
2000-05-11Display -? as -\? under unix for psql.Bruce Momjian
2000-05-11Add options and cleanup psql \? and -? help displaysBruce Momjian
2000-05-09Update psql \? to show file rather than "fname".Bruce Momjian
2000-05-05psql: suppress warnings about too many arguments if the command is not valid ↵Peter Eisentraut
in the first place
2000-05-05Spello SERIALIZED -> SERIALIZABLE in psql tab completionPeter Eisentraut
2000-04-24Fix \h to not go past array boundsBruce Momjian
2000-04-21Fix still more static-declaration-vs-nonstatic-definition glitches.Tom Lane
gcc doesn't think these are a problem, but somewhere out there is a compiler that will spit up.
2000-04-16squished \dS+ bug pointed out by Mike MascariPeter Eisentraut
2000-04-16Tweak create_help.pl so it will work under either perl 4.* or perl 5.*.Tom Lane
Remove knowledge of path to documentation source directory from perl script, instead have Makefile pass it to script.
2000-04-16more psql bug squashing:Peter Eisentraut
\copy without arguments failed commands with too many arguments were too silent
2000-04-14fixed another psql \e bug (handle newlines as whitespace)Peter Eisentraut
repaired psql option scanning bug (special treatment to \g |pipe) fixed ipcclean makefile made configure look for Perl to handle psql help build gracefully
2000-04-12Ye-old pgindent run. Same 4-space tabs.Bruce Momjian
2000-04-11Clean up temp files from \e.Bruce Momjian
2000-03-27Fixed bug with repeated \e in psql (failed to clear buffers correctly)Peter Eisentraut
2000-03-18Fixed psql -c "\slashcmd"Peter Eisentraut
2000-03-18Modify lexing of multi-char operators per pghackers discussion aroundTom Lane
16-Mar-00: trailing + or - is not part of the operator unless the operator also contains characters not present in SQL92-defined operators. This solves the 'X=-Y' problem without unduly constraining users' choice of operator names --- in particular, no existing Postgres operator names become invalid. Also, remove processing of // comments, as agreed in the same thread.
2000-03-17Add safety check on expression nesting depth. Default value is set byTom Lane
a config.h #define, and the runtime value can be controlled via SET.
2000-03-13Fixed deficiency where an unterminated (no semicolon) command at end ofPeter Eisentraut
psql script would be dropped silently.
2000-03-11Karel Zakr's revised patch to fix psql prompt for local host connections.Peter Eisentraut
2000-03-08I've made a diff against the 7.0beta1 tree that accomplishes several things:Bruce Momjian
1) adds NetBSD shared lib support on both ELF and a.out platforms 2) replaces "-L$(LIBPQDIR) -lpq" with "$(LIBPQ)" defined in Makefile.global. This makes it much easier to build stuff in the source tree after you've already installed the libraries. 3) adds TEMPLATEDIR in Makefile.global that indicates where the database templates are stored. This separates the template files from real libraries that are installed in $(LIBDIR). 4) changes include order of <readline/readline.h> and <readline.h>. The latest GNU readline installs its headers under a readline subdirectory. In addition to applying the patch below the following files need to be copied: backend/port/dynloader: bsd.h -> netbsd.h bsd.c -> netbsd.c include/port: bsd.h -> netbsd.h makefiles: Makefile.bsd -> Makefile.netbsd It would be great to see this incorporated into the source tree before the 7.0 release is cut. Thanks! -- Johnny C. Lam <lamj@stat.cmu.edu>
2000-03-08 Hi Peter,Bruce Momjian
I try change prompt in the psql, but it is set '.' (as '%m') for non-TCP/IP connection. This small patch try use uname() information for non-TCP/IP instead '.'. Karel
2000-03-05Added configure test for readline's filename_completion_functionPeter Eisentraut
Completed psql's \? help
2000-03-01More fixes for psql ^C handling, especially during copy. Still doesn'tPeter Eisentraut
cope so well with copy to but that will have to wait for the next release. Also added -X option to prevent reading .psqlrc startup file.
2000-02-27Fix a couple of inconsistent usages of include <...> vs. include "...".Tom Lane
2000-02-26psql's \d command wasn't doing the right things with 'char' (type 18)Tom Lane
fields, nor with bpchar and varchar fields that have typmod -1. The latter effectively have an unspecified length, so I made them display as char() and varchar() rather than falsely equating them to char(1) and varchar(1).
2000-02-21Fixed psql's Control-C handling when COPY in progressPeter Eisentraut
2000-02-21Fixes for \encoding command.Tatsuo Ishii
1) freeing null pointer 2) invalid encoding info may be stored into psql variable 3) fix indentation
2000-02-20Moved psql \eset and \eshow to \encodingPeter Eisentraut
Improved psql's Ctrl-C handling Fixed configure test for sigsetjmp that now even recognizes it if it's a macro
2000-02-20Fix missing \n in some psql_error calls.Tom Lane
2000-02-19Add new backslash command \eset and \eshow.Tatsuo Ishii
2000-02-16Clean up include files use in psql.Bruce Momjian
2000-02-15New cost model for planning, incorporating a penalty for random pageTom Lane
accesses versus sequential accesses, a (very crude) estimate of the effects of caching on random page accesses, and cost to evaluate WHERE- clause expressions. Export critical parameters for this model as SET variables. Also, create SET variables for the planner's enable flags (enable_seqscan, enable_indexscan, etc) so that these can be controlled more conveniently than via PGOPTIONS. Planner now estimates both startup cost (cost before retrieving first tuple) and total cost of each path, so it can optimize queries with LIMIT on a reasonable basis by interpolating between these costs. Same facility is a win for EXISTS(...) subqueries and some other cases. Redesign pathkey representation to achieve a major speedup in planning (I saw as much as 5X on a 10-way join); also minor changes in planner to reduce memory consumption by recycling discarded Path nodes and not constructing unnecessary lists. Minor cleanups to display more-plausible costs in some cases in EXPLAIN output. Initdb forced by change in interface to index cost estimation functions.
2000-02-13Adjusted psql echoing options (-a and -e)Peter Eisentraut
2000-02-10Default argument for createdbPeter Eisentraut
Changed EXIT_ON_ERROR to ON_ERROR_STOP in psql
2000-02-09I checked the WinNT port yesterday (a few days old snapshot from CVS) and IBruce Momjian
am including a patch to get it compile. changes to psql: - added less as default pager when compiling on Cygwin - need to declare "filename_completion_function" because it is not exported from readline -> added to include/port/win.h changes to pg_id: - include of <getopt.h> - add .exe when installing I think there is a problem with calling the regress tests on WinNT - it should be called with PORTNAME not HOST as the parameter to regress.sh or the check when to add "-h localhost" to psql has to be changed. Now it is checked against the PORTNAME. The results of the regress tests were OK with expected failures ;-) Daniel Horak
2000-02-07Fixed psql double quoting of SQL idsPeter Eisentraut
Fixed libpq printing functions
2000-02-05Change function name PQclientencoding to PQclientEncoding sinceTatsuo Ishii
it seems more suitable for the naming convention in libpq.
2000-01-29A few minor psql enhancementsPeter Eisentraut
Initdb help correction Changed end/abort to commit/rollback and changed related notices Commented out way old printing functions in libpq Fixed a typo in alter table / alter column
2000-01-27fix for compile.Bruce Momjian
2000-01-26Update files.Bruce Momjian
2000-01-26Add:Bruce Momjian
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc to all files copyright Regents of Berkeley. Man, that's a lot of files.