aboutsummaryrefslogtreecommitdiff
path: root/src/interfaces
Commit message (Collapse)AuthorAge
* Clean up some warnings and bugs and make things build easier.Peter Eisentraut2001-08-11
|
* Since PQoidStatus is deprecated, we should probably stop using it inTom Lane2001-08-10
| | | | our own code ...
* Make OIDs optional, per discussions in pghackers. WITH OIDS is still theTom Lane2001-08-10
| | | | | | | | | | | | default, but OIDS are removed from many system catalogs that don't need them. Some interesting side effects: TOAST pointers are 20 bytes not 32 now; pg_description has a three-column key instead of one. Bugs fixed in passing: BINARY cursors work again; pg_class.relhaspkey has some usefulness; pg_dump dumps comments on indexes, rules, and triggers in a valid order. initdb forced.
* Attached is a patch to remove some redundant code in the JDBC driver.Bruce Momjian2001-08-10
| | | | | | | | | | | * Merges identical code from org.postgresql.jdbc[1|2].Statement into org.postgresql.Statement. * Moves escapeSQL() method from Connection to Statement (the only place it's used) * Minor cleanup of the new isolation level stuff. * Minor cleanup of version string handling. Anders Bengtsson
* Patch to LOCK multiple tables in one LOCK command.Bruce Momjian2001-08-10
| | | | Neil Padgett
* Add new files for the preparation.Hiroshi Inoue2001-08-10
|
* I think you replaced too many things with put(...Bruce Momjian2001-08-07
| | | | | | | | | | | | | Here is a context diff from latest cvs And I see why you couldn't apply the last diff, the setCatalog diff has been backed out, that was causing the compile problem in the first place. This following one needs to be applied to allow the current cvs to compile Dave Cramer
* Russian translation by Serguei MokhovPeter Eisentraut2001-08-07
|
* Back out LOCK A,B,C patch at Tom's suggestion.Bruce Momjian2001-08-04
|
* Compile fix for jdbc1.Bruce Momjian2001-08-04
|
* Add LOCK A,B,C functionality as LOCK A;LOCK B;LOCK C; as agreed.Bruce Momjian2001-08-04
| | | | Neil Padgett
* > 1) When a row is retrieved, and then a SQL_FETCH_FIRST is issued, theBruce Momjian2001-08-04
| | | | | | | | | | | | check > in convert.c > does not consider the fact that the value in the field has been altered to > be a '1' if the > backend handed it a 't'. The net result being that the first row on any > subsequent queries > has all it's boolean set to 0. Aidan Mountford
* Attached is a patch that does the following:Bruce Momjian2001-08-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1) improves performance of commit/rollback by reducing number of round trips to the server 2) uses 7.1 functionality for setting the transaction isolation level 3) backs out a patch from 11 days ago because that code failed to compile under jdk1.1 Details: 1) The old code was doing the following for each commit: commit begin set transaction isolation level xxx thus a call to commit was performing three round trips to the database. The new code does this in one round trip as: commit; begin; set transaction isolation level xxx In a simple test program that performs 1000 transactions (where each transaction does one simple select inside that transaction) has the following before and after timings: Client and Server on same machine old new --- --- 1.877sec 1.405sec 25.1% improvement Client and Server on different machines old new --- --- 4.184sec 2.927sec 34.3% improvement (all timings are an average of four different runs) 2) The driver was using 'set transaction isolation level xxx' at the begining of each transaction, instead of using the new 7.1 syntax of 'set session characteristics as transaction isolation level xxx' which only needs to be done once instead of for each transaction. This is done conditionally (i.e. if server is 7.0 or older do the old behaviour, else do the new behaviour) to not break backward compatibility. This also required the movement of some code to check/test database version numbers from the DatabaseMetaData object to the Connection object. 3) Finally while testing, I discovered that the code that was checked in 11 days ago actually didn't compile. The code in the patch for Connection.setCatalog() used Properties.setProperty() which only exists in JDK1.2 or higher. Thus compiling the JDBC1 driver failed as this method doesn't exist. Thus I backed out that patch. Barry Lind
* Fix residual breakage from Windows socket-errno patch: the routinesTom Lane2001-08-03
| | | | that should use regular errno, not WSAGetLastError(), now do so again.
* Fix win32.mak to support MULTIBYTE build --- it was pulling in severalTom Lane2001-08-03
| | | | | backend files that it shouldn't anymore, causing compile failures. Per report from Darko Prenosil.
* Message typo was fixed in sources, but not in de.po.Tom Lane2001-08-01
|
* Remove WIN32_NON_BLOCKING_CONNECTIONS tests, since we don't need 'emTom Lane2001-07-31
| | | | anymore.
* This patch merges the identical methods from the JDBC1 and JDBC2Bruce Momjian2001-07-30
| | | | | | | | | | | | connection implementations (org.postgresql.jdbc[1|2].Connection) into their superclass (org.postgresql.Connection). It also changes the close() methods of Connection and PG_Stream, so that PG_Stream no longer is responsible for sending the termination packet 'X' to the backend. I figured that protocol-level stuff like that belonged in Connection more than in PG_Stream. Anders Bengtsson
* Move EncodingTest.java file.Bruce Momjian2001-07-21
|
* DatabaseMetaData.getColumns() doesn't appear to get the defaultBruce Momjian2001-07-21
| | | | | | | value for each column. Here is a context diff of CVS which should fix it. Jason Davies
* Great, here is a context diff of CVS for implementing the get/setCatalog methodsBruce Momjian2001-07-21
| | | | | | | in Connection - note: I've updated setCatalog(String catalog) from my previous diff so it checks whether it is already connected to the specified catalog. Jason Davies
* JDBC encoding additions.Bruce Momjian2001-07-21
| | | | | | | Here's a patch against the current CVS. The changes from the previous patch are mostly related to the changed interface for PG_Stream. Anders Bengtsson
* I downloaded new source for lib (only few hours old !!!), and madeBruce Momjian2001-07-21
| | | | | | | | | | changes on this new source to make non-blocking connection work. I tested it, and PQSendQuery and PQGetResult are working fine. In win32.h I added one line: #define snprintf _snprintf Darko Prenosil
* i've spotted a following problem using DBD::Pg under win32. winsockBruce Momjian2001-07-20
| | | | | | | | | functions do not set errno, so some normal conditions are treated as fatal errors. e.g. fetching large tuples fails, as at some point recv() returns EWOULDBLOCK. here's a patch, which replaces errno with WSAGetLastError(). i've tried to to affect non-win32 code. Dmitry Yurtaev
* Fix fault in message.Peter Eisentraut2001-07-16
|
* Partial indexes work again, courtesy of Martijn van Oosterhout.Tom Lane2001-07-16
| | | | | | Note: I didn't force an initdb, figuring that one today was enough. However, there is a new function in pg_proc.h, and pg_dump won't be able to dump partial indexes until you add that function.
* NLS for libpq. Clean up the message formats and change the documentationPeter Eisentraut2001-07-15
| | | | accordingly.
* The attached patch fixes problems with the JDBC driver handling longBruce Momjian2001-07-15
| | | | | | | | | | | | | | | | | | | | | | | | null terminated strings. The FE/BE protocol sends in some cases null terminated strings to the client. The docs for the FE/BE protocol state that there is no limit on the size of a null terminated string sent to the client and a client should be coded using an expanding buffer to deal with large strings. The old code did not do this and gave an error if a null terminated string was greater than either 4 or 8K. It appears that with the advent of TOAST very long SQL statements are becoming more common, and apparently some error messages from the backend include the SQL statement thus easily exceeding the 8K limit in the old code. In fixing I also cleaned up some calls in the JDBC fastpath code that were not doing character set conversion under multibyte, and removed some methods that were no longer needed. I also removed a potential threading problem with a shared variable that was being used in Connection.java. Thanks to Steve Wampler for discovering the problem and sending the initial diffs that were the basis of this patch. thanks, --Barry
* Remove grammar restrictions on order of optional clauses in CREATE GROUP.Tom Lane2001-07-12
| | | | From Vince Vielhaber.
* Add win32 c++ files.Bruce Momjian2001-07-12
|
* Add missing encode file.Bruce Momjian2001-07-12
|
* Libpq++ fixes for Win32 compile.Bruce Momjian2001-07-11
| | | | Christian Ullrich
* Add prototypes to supress warnings.Bruce Momjian2001-07-11
|
* The SQL preprocessor ecpg generates "initially deferrable" fromBruce Momjian2001-07-11
| | | | | | INITIALLY DEFERRED in source code. cf. preproc.y:1455. Unknown.
* Changes from Vince Vielhaber to allow the optional clauses of CREATETom Lane2001-07-10
| | | | | | | | USER and ALTER USER to appear in any order, not only the fixed order they used to be required to appear in. Also, some changes from Tom Lane to create a FULL option for VACUUM; it doesn't do anything yet, but I needed to change many of the same files to make that happen, so now seemed like a good time.
* Support fake root install, separate build dir, dependency tracking, ourPeter Eisentraut2001-07-10
| | | | | | choice of compiler and flags, uninstall, and peculiar Python installation layouts for PyGreSql. Also install into site-packages now, as officially recommended. And pgdb.py is also installed now, used to be forgotten.
* Add SHARE UPDATE EXCLUSIVE lock mode, coming soon to a VACUUM near you.Tom Lane2001-07-09
| | | | Name chosen per pghackers discussion around 6/22/01.
* German message localization for JDBCPeter Eisentraut2001-07-09
|
* postgresql.badint property name was probably meant to bePeter Eisentraut2001-07-09
| | | | postgresql.res.badint, since that's the name in the properties file.
* Implement DatabaseMetaData.getCatalogs()Peter Eisentraut2001-07-08
|
* Bring DatabaseMetaData feature tests up to date:Peter Eisentraut2001-07-08
| | | | | | | | | | | | | | | | * NULLs are sorted differently in 7.2 * table correlation names are supported * GROUP BY, ORDER BY unrelated is supported since 6.4 * ESCAPE/LIKE only supported since 7.1 * outer joins only since 7.1 * preferred term for procedure is "function" * preferred term for catalog is "database" * supports SELECT for UPDATE since 6.5 * supports subqueries * supports UNION; supports UNION ALL since 7.1 * update some of the max lengths to match reality * rearrange some functions to match the order in the spec for easier maintenance
* Sync with jdbc2, remove gratuitous white space differences.Peter Eisentraut2001-07-07
|
* Resolve a number of oddities in the Java build. First, remove the weirdPeter Eisentraut2001-07-06
| | | | | | | | | redirections between the build files, which didn't work completely. Now you just go to the directory of your choice and run make. Clean up the build files to have a logical order, fix the unnecessary rebuilds, prevent the deleting targets from removing files they're not responsible for. Ant 1.3 does not have a bug. It deletes directories just fine if you follow the documentation.
* Use CONNECTION_OK to determine whether startup phase is complete.Peter Eisentraut2001-07-06
|
* Terminate message doesn't have a trailing zero byte.Peter Eisentraut2001-07-06
|
* Repair libpq to follow protocol by not sending Terminate messages beforePeter Eisentraut2001-07-06
| | | | | the startup exchange is complete. Also make sure that packets defined as single bytes aren't sent with a trailing '\0'.
* Remove ConnectionHook.java. No longer used, bad code.Bruce Momjian2001-07-04
|
* The attached patch removes some old and dead code (and some relatedBruce Momjian2001-07-04
| | | | | | misleading comments) from the PG_Stream class. Anders Bengtsson
* This patch moves the setting of the timezone on the SimpleDateFormatBruce Momjian2001-07-04
| | | | | | | | object inside the initialization section instead of doing it everytime the setTimestamp method is called. Thanks to Dave Harkness for this suggestion. Barry Lind
* Attached is a patch to remove the ConnectionHook functionality and thusBruce Momjian2001-07-04
| | | | | | | the JDK 1.3 dependency. For a further explanation see my posting to the JDBC list on Friday, explaining why this is being done. Barry Lind
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 11:50:03 +0000