aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces
Commit message (Collapse)AuthorAge
* Clean files after installing, since those files will most likely be rootPeter Eisentraut2000-11-16
| | | | owned, which can be annoying.
* Make pgsql compile on FreeBSD-alpha.Bruce Momjian2000-11-16
| | | | | | | | | | | | | | | | | | Context diff this time. Remove -m486 compile args for FreeBSD-i386, compile -O2 on i386. Compile with only -O on alpha for codegen safety. Make the port use the TEST_AND_SET for alpha and i386 on FreeBSD. Fix a lot of bogus string formats for outputting pointers (cast to int and %u/%x replaced with no cast and %p), and 'Size'(size_t) are now cast to 'unsigned long' and output with %lu/ Remove an unused variable. Alfred Perlstein
* Rename PortName to PortNumber.Bruce Momjian2000-11-14
|
* Remove -k unix socketpath option from client side, allow hostname withBruce Momjian2000-11-13
| | | | leading slash to behave as a unix socket path.
* UUNET is looking into offering PostgreSQL as a part of a managed webBruce Momjian2000-11-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | hosting product, on both shared and dedicated machines. We currently offer Oracle and MySQL, and it would be a nice middle-ground. However, as shipped, PostgreSQL lacks the following features we need that MySQL has: 1. The ability to listen only on a particular IP address. Each hosting customer has their own IP address, on which all of their servers (http, ftp, real media, etc.) run. 2. The ability to place the Unix-domain socket in a mode 700 directory. This allows us to automatically create an empty database, with an empty DBA password, for new or upgrading customers without having to interactively set a DBA password and communicate it to (or from) the customer. This in turn cuts down our install and upgrade times. 3. The ability to connect to the Unix-domain socket from within a change-rooted environment. We run CGI programs chrooted to the user's home directory, which is another reason why we need to be able to specify where the Unix-domain socket is, instead of /tmp. 4. The ability to, if run as root, open a pid file in /var/run as root, and then setuid to the desired user. (mysqld -u can almost do this; I had to patch it, too). The patch below fixes problem 1-3. I plan to address #4, also, but haven't done so yet. These diffs are big enough that they should give the PG development team something to think about in the meantime :-) Also, I'm about to leave for 2 weeks' vacation, so I thought I'd get out what I have, which works (for the problems it tackles), now. With these changes, we can set up and run PostgreSQL with scripts the same way we can with apache or proftpd or mysql. In summary, this patch makes the following enhancements: 1. Adds an environment variable PGUNIXSOCKET, analogous to MYSQL_UNIX_PORT, and command line options -k --unix-socket to the relevant programs. 2. Adds a -h option to postmaster to set the hostname or IP address to listen on instead of the default INADDR_ANY. 3. Extends some library interfaces to support the above. 4. Fixes a few memory leaks in PQconnectdb(). The default behavior is unchanged from stock 7.0.2; if you don't use any of these new features, they don't change the operation. David J. MacKenzie
* Update to PyGreSQL 3.1:Bruce Momjian2000-11-10
| | | | | | | | | | | | | | | | | | | | | | | | | | Fix some quoting functions. In particular handle NULLs better. Use a method to add primary key information rather than direct manipulation of the class structures. Break decimal out in _quote (in pg.py) and treat it as float. Treat timestamp like date for quoting purposes. Remove a redundant SELECT from the get method speeding it, and insert since it calls get, up a little. Add test for BOOL type in typecast method to pgdbTypeCache class. (tv@beamnet.de) Fix pgdb.py to send port as integer to lower level function (dildog@l0pht.com) Change pg.py to speed up some operations Allow updates on tables with no primary keys. D'Arcy J.M. Cain
* the bug was not fixed in the snapshot of November 5th. Also the enterpriseBruce Momjian2000-11-10
| | | | | | | | | edition of the driver did not compile. I have fixed both issues again. I have attached the modified files to this email, maybe you can check them into the repository. (Fixes are marked with //FIXME). Enterprise edition driver now compiles and seems to work. Jan Thomae
* Applied yet another patch by Christof. Thanks Cristof!Michael Meskes2000-11-09
| | | | Synced parser.
* Add dependencies required for parallel makePeter Eisentraut2000-11-08
|
* Undo incorrectly committed Makefile.Michael Meskes2000-11-07
|
* Third try. Sorry, I had a wrong path in my copy statement.Michael Meskes2000-11-07
|
* Added more patches by Cristif Petig.Michael Meskes2000-11-07
|
* Fix for missing EUC_TW encodingTatsuo Ishii2000-11-04
|
* Parser sync.Michael Meskes2000-11-03
|
* Fixed minor bug in ResultSet for jdbc2 reported by Matthew Denner that ↵Peter Mount2000-11-01
| | | | absolute doesnt handle negative row numbers correctly.
* Added patch by Christof Petig <christof.petig@wtal.de> that fixes some bugs ↵Michael Meskes2000-10-31
| | | | in preproc.y.
* Use $(filter ...), not $(findstring ...).Peter Eisentraut2000-10-31
|
* Sync preproc.y with gram.y.Michael Meskes2000-10-30
|
* Avoid dependency on backend's multibyte module as possible.Tatsuo Ishii2000-10-30
| | | | | Now frontend/libpq has its own version of pg_encoding_to_char and pg_char_to_encoding.
* Removed multibyte stuff since client does not know about encoding in the ↵Michael Meskes2000-10-29
| | | | backendFixed quoting bug reported by Sascha Demetrio (sd@b-comp.de).
* Remove compiler warnings (add missing include files). Only link againstPeter Eisentraut2000-10-28
| | | | -lm if it's actually there.
* Synced preproc.y with gram.y.Michael Meskes2000-10-25
|
* Rearrange handling of -L linker options so that they are always before allPeter Eisentraut2000-10-25
| | | | | | | the -l options. (This was not the case when using the OpenSSL or Kerberos options.) Also make sure that shared library links get to see all the -L options. Get Kerberos 5 support to compile on Redhat 7.0. Add OpenSSL and -lsocket (if used/found) to libpq link.
* From Zoltan Kovacs back in April (sorry for the delay Zoltan!):Thomas G. Lockhart2000-10-25
| | | | | | | | | | | | | | | I modified the current ODBC driver for * referential integrity error reporting, * SELECT in transactions and * disabling autocommit. I tested these changes with Borland C++ Builder -> ODBCExpress -> WinODBC driver (DLL) -> Postgres 7.0beta1 and Borland C++ Builder -> BDE -> WinODBC driver (DLL) -> Postgres 7.0beta1. The patch is based on snapshot of 22th April (I don't think that someone has modified it since that: Byron hasn't gave any sign of living for about a month and I didn't find any comments about the ODBC driver on the list).
* Added some more C constructs to the parser.Michael Meskes2000-10-25
|
* Eliminate POLLUTE=1 hack for cross-Perl-version compatibility by usingTom Lane2000-10-24
| | | | Devel::PPPort instead. Thanks to Gilles Darold for doing the legwork.
* Increase buffer size to improve performance of client-side lo_import.Tom Lane2000-10-24
|
* Major overhaul of large-object implementation, by Denis Perchine withTom Lane2000-10-24
| | | | | | | | | | | | | kibitzing from Tom Lane. Large objects are now all stored in a single system relation "pg_largeobject" --- no more xinv or xinx files, no more relkind 'l'. This should offer substantial performance improvement for large numbers of LOs, since there won't be directory bloat anymore. It'll also fix problems like running out of locktable space when you access thousands of LOs in one transaction. Also clean up cruft in read/write routines. LOs with "holes" in them (never-written byte ranges) now work just like Unix files with holes do: a hole reads as zeroes but doesn't occupy storage space. INITDB forced!
* Polish shared library build to reduce number of special hacks. InPeter Eisentraut2000-10-23
| | | | | | | | | particular, allow linking with arbitrary commands rather than only $(AR) or $(LD), and treat C++ without hacks. Add option to disable shared libraries. This takes the place of the BSD_SHLIB variable. The regression test driver ignores the plpgsql test if there are no shared libraries available.
* Back out xti.h portion of the patch.Bruce Momjian2000-10-23
|
* Makeover for Unixware 7.1.1Peter Eisentraut2000-10-22
| | | | | | | | | | | | | | | | | | | | | | | | | | * Makefile: Add more standard targets. Improve shell redirection in GNU make detection. * src/backend/access/transam/rmgr.c: Fix incorrect(?) C. * src/backend/libpq/pqcomm.c (StreamConnection): Work around accept() bug. * src/include/port/unixware.h: ...with help from here. * src/backend/nodes/print.c (plannode_type): Remove some "break"s after "return"s. * src/backend/tcop/dest.c (DestToFunction): ditto. * src/backend/nodes/readfuncs.c: Add proper prototypes. * src/backend/utils/adt/numutils.c (pg_atoi): Cope specially with strtol() setting EINVAL. This saves us from creating an extra set of regression test output for the affected systems. * src/include/storage/s_lock.h (tas): Correct prototype. * src/interfaces/libpq/fe-connect.c (parseServiceInfo): Don't use variable as dimension in array definition. * src/makefiles/Makefile.unixware: Add support for GCC. * src/template/unixware: same here * src/test/regress/expected/abstime-solaris-1947.out: Adjust whitespace. * src/test/regress/expected/horology-solaris-1947.out: Part of this file was evidently missing. * src/test/regress/pg_regress.sh: Fix shell. mkdir -p returns non-zero if the directory exists. * src/test/regress/resultmap: Add entries for Unixware.
* Fixed mixing of two enum datatypes.Michael Meskes2000-10-22
|
* Add support for VPATH builds, that is, building somewhere else than in thePeter Eisentraut2000-10-20
| | | | | | | | | source directory. This involves mostly makefiles using $(srcdir) when they might have used ".". (Regression tests don't work with this, yet.) Sort out usage of CPPFLAGS, CFLAGS (and CXXFLAGS). Add "override" keyword in most places, to preserve necessary flags even when the user overrode the flags.
* Remove 'override' keyword, which breaks the build on HPUX, and probablyTom Lane2000-10-20
| | | | | | | | anywhere else that Makefile.shlib needs to modify CFLAGS to produce valid code for a shared library. I'm not real clear on *why* the use of override causes make to ignore the later attempt to assign CFLAGS += but it indubitably does --- at least on gmake 3.79.1. gmake bug?
* Locate the file pg_service.conf in the directory configured as --syconfdirPeter Eisentraut2000-10-17
| | | | (i.e., /usr/local/pgsql/etc by default).
* Fixed some bugs in C language parsing.Michael Meskes2000-10-17
|
* Some more getTimestamp() fixesPeter Mount2000-10-17
|
* Simplified parsing of connect rule.Michael Meskes2000-10-17
|
* TNS:Bruce Momjian2000-10-17
| | | | | | | | I prepared and tested a patch vs. 7.0.2, and it works fine. I've added another option which allows users to have their own service file in ~/.pg_service.conf, which might come handy sometimes. Mario Weilguni
* Fixed handling of variables in connect rule.Michael Meskes2000-10-16
|
* The configure script fails to find <netinet/tcp.h>.Bruce Momjian2000-10-14
| | | | | | | | | | | | | | | | | | | | | | | As a result, backend/libpq/pqcomm.c and interfaces/libpq/fe-connect.c fail to compile. The <netinet/tcp.h> header needs to be preceded by <netinet/in.h>, at least on IRIX, Solaris and AIX. The simple configure test fails. (That header on Linux is idempotent.) The basic problem is that <netinet/tcp.h> is a BSD header. The correct header for TCP internals such as TCP_NODELAY on a UNIX system is <xti.h>. By UNIX I mean UNIX95 (aka XPG4v2 or SUSv1) or later. The current UNIX standard (UNIX98 aka SUSv2) is available online at <http://www.opengroup.org/onlinepubs/7908799/>. The fix is to add header support for <xti.h> into configure.in and config.h.in. The 2 files which conditionally include <netinet/tcp.h> need also to conditionally include <xti.h>. Pete Forman
* Replace constants by C variables wherever possible.Michael Meskes2000-10-12
|
* Major update part I involving delayed patches, reworked Makefile, and howPeter Mount2000-10-12
| | | | the versioning works. There's also a new utils directory used by Makefile
* Add more files from backendTatsuo Ishii2000-10-12
|
* Synced preproc.y with gram.yMichael Meskes2000-10-11
|
* Back out Gunnar R|nning jdbc changes.Bruce Momjian2000-10-09
|
* Okay, I have some new code in place that hopefully should work better. IBruce Momjian2000-10-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | couldn't produce a full patch using cvs diff -c this time since I have created new files and anonymous cvs usage doesn't allow you to adds. I'm supplying the modified src/interfaces/jdbc as a tarball at : http://www.candleweb.no/~gunnar/projects/pgsql/postgres-jdbc-2000-10-05.tgz The new files that should be added are : ? org/postgresql/PGStatement.java ? org/postgresql/ObjectPool.java ? org/postgresql/ObjectPoolFactory.java There is now a global static pool of free byte arrays and used byte arrays connected to a statement object. This is the role of the new PGStatement class. Access to the global free array is synchronized, while we rely on the PG_Stream synchronization for the used array. My measurements show that the perfomance boost on this code is not quite as big as my last shot, but it is still an improvement. Maybe some of the difference is due to the new synchronization on the global array. I think I will look into choosing between on a connection level and global level. I have also started experimented with improving the performance of the various conversions. The problem here is ofcourse related handle the various encodings. One thing I found to speed up ResultSet.getInt() a lot was to do custom conversion on the byte array into int instead of going through the getString() to do the conversion. But I'm unsure if this is portable, can we assume that a digit never can be represented by more than one byte ? It works fine in my iso-latin-8859-1 environment, but what about other environments ? Maybe we could provide different ResultSet implementations depending on the encoding used or delegate some methods of the result set to an "converter class". Check the org/postgresql/jdbc2/FastResultSet.java in the tarball above to see the modified getInt() method. Regards, Gunnar
* Added patch by Cristof for catching yet another NOTICE.Michael Meskes2000-10-04
|
* removed binary fileMichael Meskes2000-10-04
| | | | CV: ----------------------------------------------------------------------
* Treat empty connection parameters as is, in particular to enable overridingPeter Eisentraut2000-10-03
| | | | | environment variables with "nothing". Empty host parameter indicates Unix socket.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-31 03:34:15 +0000