summaryrefslogtreecommitdiff
path: root/src/interfaces
Commit message (Collapse)AuthorAgeFilesLines
* creation for postgresql-6.1Edmund Mergl1997-04-2911-0/+2681
|
* From: Raymond Toy <toy@rtp.ericsson.se>Marc G. Fournier1997-04-171-1/+2
| | | | | | | | | | | | | | | | | Subject: [PATCHES] 970417: some large object patches Two patches here, made against 970417. Both have to do with large objects: 1. lobjfuncs was not initialized in PQconnectdb. This causes failure later if large objects are used. (Someone already caught this error in PQsetdb.) 2. Postgres functions lo_import and lo_export sometimes produce garbage for the file names because the filename strings aren't always terminated by \0. (VARDATA isn't necessarily null terminated.)
* connectDB(): setsockopt (..., TCP_NODELAY, ...) added.Vadim B. Mikheev1997-04-161-2/+21
|
* A couple of cleanups from Scott Harrison <Scott_Harrison@next.com>Marc G. Fournier1997-04-151-1/+2
|
* This commit represents a clean compile with the new templates underMarc G. Fournier1997-04-043-9/+9
| | | | | | | | | FreeBSD The Makefile(s) have all been cleaned up such that there is a single LDFLAGS vs LD_ADD or LDADD or LDFLAGS or LDFLAGS_BE. The Makefile(s) should be alot more straightforward then they were before...and consistent
* Install os.h when we install the other headers...Marc G. Fournier1997-04-041-1/+3
| | | | Pointed out by: System Administrator <sysadmin@sba.miami.edu>
* From: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at>Marc G. Fournier1997-04-021-2/+2
| | | | | | | Subject: [HACKERS] libpq variable set patch Just a small change, so the automatic variable setting on connection startup actually works...
* From: Anton de Wet <adw@obsidian.co.za>Marc G. Fournier1997-04-021-7/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Subject: [HACKERS] Small patch to pgtclCmds.c Hi I have made the following small change to the extensions I made to pgtclCmds.c quite a while ago. At the moment there is a -assignbyidx option to pg_result assigning the returned tuples to an array by using the 1st field of the select statement as the key to the array. eg "select name,age from vitalstatistics" will result in an array with myarray(peter) = 32 myarray(paul) = 45 Often I need to have a pseudo-multi dimentional array eg. "select name,age from vitalstatistics where occupation='plummer' I would like to be able to generate an array newarray(peter,overpaid) = 32 So to add a arbitrary string to the key value I have extended pg_result $res -assignbyidx $arrayname to have an optional argument pg_result $res -assignbyidx $arrayname $appendstr So that that string is appended to the key value.
* From: Oleg Bartunov <oleg@sai.msu.su>Marc G. Fournier1997-04-021-6/+1
| | | | | | | | | | | | | | | | | | | | | | | | | Subject: [HACKERS] locale patches ! Hi there, here are little patches to get Postgres 6.1 works with locale stuff. This is a patch against 970402.tar.gz, there are no problem to apply them by hand to 6.0 release. Collate stuff tested about 1-2 months in real working database but I'm sure there must be no problem. US hackers could vote against locale implementation ( locale for sure will affect to speed of postgres ), so I introduce variable USE_LOCALE which controls locale stuff. Non-US users now could use ~* operator for searching and <order by> for strings with nation alphabet. Please, don't forget, as I did first time, to set environment variable LC_CTYPE and LC_COLLATE because backend get locale information from them. I start postmaster from a little script, assuming that shell is Bash shell it looks like: #!/bin/sh export LC_CTYPE=koi8-r export LC_COLLATE=koi8-r postmaster -B 1024 -S -D/usr/local/pgsql/data/ -o '-Fe'
* Various patches for shared libraries under i386-solaris by:Marc G. Fournier1997-03-253-15/+47
| | | | Christoph Kaesling <ck@dog.pfalz.sub.de>
* Here's two more diffs...Marc G. Fournier1997-03-252-5/+5
| | | | | | | | | | | | The first fixes a warning from gcc about the assignment within the condition. The extra set of parens should not make a difference, but with -Werror, they are necessary. The second fixes an "ln -s" invocation that assumes the current directory is implicitly the target if not specified. Not true in all cases, and again, it should not make a difference except to those implementation that it does. From: "Michael P. Snyder" <msnyder@hawkeye.huntersmoon.com>
* - Renamed the variable names to something shorter, and I hopeMarc G. Fournier1997-03-251-3/+7
| | | | | | | | | | | | | | | | | | nicer. Also, I grabbed my copy of the Informix manual, and added a couple of variables that make sense (formats for money, time, a language setting, a timezone). - New functions SetPGVariable() and GetPGVariable() in tcop/*. These don't actually do anything for the moment, but should be enough to implement the SET var_name TO var_val in the parser? SetPGVariable() expects just two strings, the var_name and the var_value from above, and is expected to do the right thing. Returns TRUE if everything okay. From: "Martin J. Laubach" <mjl@wwx.vip.at>
* - Move most of the I/O in both libpq and the backend to a setMarc G. Fournier1997-03-181-1/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | of common routines in pqcomprim.c (pq communication primitives). Not all adapted to it yet, but it's a start. - Rewritten some of those routines, to write/read bigger chunks of data, precomputing stuff in buffers instead of sending out byte by byte. - As a consequence, I need to know the endianness of the machine. Currently I rely on getting it from machine/endian.h, but this may not be available everywhere? (Who the hell thought it was a good idea to pass integers to the backend the other way around than the normal network byte order? *argl*) - Libpq looks in the environment for magic variables, and upon establishing a connection to the backend, sends it queries of the form "SET var_name TO 'var_value'". This needs a change in the backend parser (Mr. Parser, are you there? :) - Currently it looks for two Env-Vars, namely PG_DATEFORMAT and PG_FLOATFORMAT. What else makes sense? PG_TIMEFORMAT? PG_TIMEZONE? From: "Martin J. Laubach" <mjl@wwx.vip.at>
* Fixes for libpgtcl from MassimoMarc G. Fournier1997-03-172-3/+5
|
* Don't forget the fe-connect.h include fileMarc G. Fournier1997-03-161-0/+29
|
* From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov>Marc G. Fournier1997-03-161-1/+1
| | | | | | | | | | | Subject: [HACKERS] Patches for 970316 compilation I made a small pre-emptive change in the new datetime code to eliminate calls to infnan(). Hopefully this will make Solaris (and probably other non-GNUlib) systems happier. Didn't find fe-connect.h in the 970316 distribution, so made one up. Also, one of the test routines needs an update for the geo-decls.h -> geo_decls.h name change. Patches appear below...
* om: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at>Marc G. Fournier1997-03-162-89/+83
| | | | | | | | | | | Subject: [HACKERS] Patch for io routines I am currently trying to improve on the front-backend communication routines; and noticed that lots of code are duplicated for libpq and the backend. This is a first patch that tries to share code between the two, more to follow. mjl
* NetBSD Shared Library Patch from Martin J. LaubachMarc G. Fournier1997-03-151-11/+17
|
* Date/Time updates from Thomas...Marc G. Fournier1997-03-141-4/+4
|
* From: Dan McGuirk <mcguirk@indirect.com>Marc G. Fournier1997-03-124-10/+64
| | | | | | | | | | | | | | | | | | | | | | Subject: [HACKERS] password authentication This patch adds support for plaintext password authentication. To use it, you add a line like host all 0.0.0.0 0.0.0.0 password pg_pwd.conf to your pg_hba.conf, where 'pg_pwd.conf' is the name of a file containing the usernames and password hashes in the format of the first two fields of a Unix /etc/passwd file. (Of course, you can use a specific database name or IP instead.) Then, to connect with a password through libpq, you use the PQconnectdb() function, specifying the "password=" tag in the connect string and also adding the tag "authtype=password". I also added a command-line switch '-u' to psql that tells it to prompt for a username and password and use password authentication.
* Bring in Leo's <lsh@lubrizol.com> massive changes to libpq++Marc G. Fournier1997-02-1325-603/+1332
|
* Various patches for nextstep by GregorHoffleitMarc G. Fournier1997-02-131-2/+10
| | | | Replaced NEED_STRDUP by !HAVE_STRDUP
* Remove from include/config.h:Marc G. Fournier1997-01-241-2/+6
| | | | | | | | | | | | #if defined(aix) #define TERMIOS_H_LOCATION <termios.h> #else #define TERMIOS_H_LOCATION <sys/termios.h> #endif libpq/fe-exec.c modified so that location of termios.h is determined by whether HAVE_TERMIOS_H is defined or not, in preparation for switch to configure
* The last patch fixes some incongruences in the #define used to compile theMarc G. Fournier1997-01-231-6/+6
| | | | | | | Tcl arrays support. Here are the correct values to be defined in config.h and pgtclCmds.c. Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
* Fix from Andrew for compiling libpgtcl...basically, switch off -Werror,Marc G. Fournier1997-01-231-1/+6
| | | | | which probably isn't needed, since we are going to take off -Werror anyway, right?
* Use gcc to make Linux ELF shared library, instead of ld.Bryan Henderson1997-01-201-3/+3
|
* Fixes:Marc G. Fournier1997-01-111-2/+2
| | | | | | I forgot to clear out the variable created and the memory used. From: darcy@druid.net (D'Arcy J.M. Cain)
* From: darcy@druid.net (D'Arcy J.M. Cain)Marc G. Fournier1997-01-111-9/+10
| | | | | | Fix for libpgtcl: I forgot to clear out the variable created and the memory used.
* cleanup for LINUX_ELFBruce Momjian1997-01-102-13/+12
|
* I found the following bugs in the version 6.0 (dated 961229).Bruce Momjian1997-01-101-3/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | At least the first two should be fixed before the final release of 6.0. 1) There is a mismatch between the type declared in the catalog for the input/output attributes of pg_type and the actual type of values stored in the table. The type of typinput, typoutput, typsend and typreceive are declared oid (26) while the values are regproc (24). The error was there also in previous versions but nobody noticed it until an Assert has been added in ExecEvalVar. The effect is that it is now impossible to replace the typoutput of existing data types with new procs. 2) The identd hba fails after the first time because the data read from the identd socket is not zero-terminated and strlen reports an incorrect length if the stack contains garbage, which usually happens after the first connection has been made. 3) The new initdb wants to create itself the data directory. This implies that the parent directory must be writable by postgres and this may not always be desirable. A better solution would be to allow the directory to be created by root and then filled by initdb. It would also nice to have some reasonable default for PGLIB and PGDATA like the previous version did. This applies also to the postmaster executable.
* Additional fixes for shared library (BSD44_Derived port).Vadim B. Mikheev1997-01-101-10/+7
|
* From: wieck@sapserv.debis.deMarc G. Fournier1997-01-081-5/+21
| | | | | | | | | | | Hi, counting the empty dummy queries in libpq isn't everything. If the backend sends an error, the I returns from the dummies still come. So we must eat them up in any case, not just returning on the occurence of an E reply. Until later, Jan
* minor path problem fix by tgl@mythos.jpl.nasa.govMarc G. Fournier1997-01-081-2/+2
|
* Fix mismatching prototype (const int vs int)Bryan Henderson1997-01-061-2/+2
|
* NeXT port specific changes by: Ovidiu Predescu <ovidiu@bx.logicnet.ro>Marc G. Fournier1997-01-061-5/+1
|
* Shared library fixes for BSD44_Derived portMarc G. Fournier1997-01-051-3/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Submitted by: "Martin J. Laubach" <mjl@wwx.vip.at> NOTE: The following patch I was uncertain of, but applied it...will end up testing the compile on my machine later tonight anyway, but if anyone knows why this *shouldn't* have been done, please change it. (CC -> LD) *************** *** 61,68 **** ../backend/lib/dllist.o: $(MAKE) -C ../backend/lib dllist.o ! libpq.so.1: $(OBJS) ! $(CC) $(LDFLAGS) -shared $(OBJS) -o libpq.so.1 c.h: ../include/c.h rm -f c.h --- 66,73 ---- ../backend/lib/dllist.o: $(MAKE) -C ../backend/lib dllist.o ! $(shlib): $(OBJS) ! $(LD) $(LDFLAGS) -shared $(OBJS) -o $(shlib) c.h: ../include/c.h rm -f c.h
* someone added pg_listen and pg_notifies to libpgtcl. But firstMarc G. Fournier1997-01-033-31/+20
| | | | | | | | | | | these routines try to use the old pointer casting stuff to get the connection id, second the notification hash table should be part of the cliendData. Otherwise, one interpreter might eat up the notifies for another one. Please apply the patch below to the current 6.0 tree. Submitted by: wieck@sapserv.debis.de
* Make error messages more explicit, PQtrace() output more readable.Bryan Henderson1996-12-312-138/+186
|
* Here's the final set of patches to 6.0 (sup'd on 27/12/96) that allow a fullBruce Momjian1996-12-281-5/+1
| | | | | | | | | gmake of the code without interruption. There's also some tidy-up of the MAXPATHLEN stuff based on the assumption that all supported platforms have MAXPATHLEN defined in <sys/param.h>. (The only unknowns for the above are AIX and IRIX5.)
* Patch for copy from stdin.Bruce Momjian1996-12-281-28/+24
|
* Remove use of "bool", which user program may not have defined.Bryan Henderson1996-12-261-7/+13
|
* pq/signal() portability patch. Also psql copy prompt fix.Bruce Momjian1996-12-263-16/+13
|
* Clarify error message about trying to PQgetvalue() nonexistent row.Bryan Henderson1996-12-241-12/+17
|
* Fix multiple "C" from backend.Bruce Momjian1996-12-201-46/+20
|
* Add two new comments to pglibtcl...Marc G. Fournier1996-12-193-3/+171
| | | | From: Massimo Dal Zotto <dz@cs.unitn.it>
* Make compile on AIX, Alpha OSF. Thanks Darren King, Igor Notanzon.Bryan Henderson1996-12-151-2/+2
|
* Clean up. Get rid of tabs and overly long lines.Bryan Henderson1996-12-131-672/+714
|
* Fix bug: libpq clients (which include libpq-fe.h) won't compile.Bryan Henderson1996-12-102-19/+16
|
* Change portname "sparc" to "sunos4" and change some portname dependencies toBryan Henderson1996-12-041-3/+3
| | | | feature dependencies. Thanks Kurt J. Lidl.
* Make strdup work for Ultrix. Thanks Erik BertelsenBryan Henderson1996-11-281-15/+1
|