summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2001-09-18EXPLAIN ANALYZE feature to measure and show actual runtimes and tupleTom Lane
counts alongside the planner's estimates. By Martijn van Oosterhout, with some further work by Tom Lane.
2001-09-17Unify the zip rules and variables.Peter Eisentraut
2001-09-17Fix bogus failure-return value from lo_create, per report from GavinTom Lane
Sherry. Also clean up leakage of open files and LOs in failure exits from lo_import and lo_export.
2001-09-17Attached is a patch that fixes ResultSetMetaData.isNullable() inBruce Momjian
the JDBC driver. This method is currently unimplemented and always returns ResultSetMetaData.columnNullable. This is obviously incorrect when a column is defined with NOT NULL or PRIMARY KEY. And we have to think of check constraints, views, functions etc. The patch simply changes the return value to ResultSetMetaData.columnNullableUnknown. This is until someone comes up with a real implementation of course. On Fri, 14 Sep 2001 17:53:50 +0200, Tomisaw Kity?ski wrote: >Hello there, > >could someone tell me, please, do I have any chance to get >proper implementation of above method in JDBC (1.1+) soon? > >Current "return 1" works fine on most tables, however it seems >to be a little bit incorrect with some of them ;) Ren? Pijlman
2001-09-17I'm attaching a patch which fixes the corruption in strings causedBruce Momjian
by escape processing in the SQL statement. I've tested this for a while now and it appears to work well. Previously string data with {d was getting corrupt as the {d was being stripped regardless of whether it was an escape code or not. I also added checking for time and timestamp escape processing strings as per 11.3 in the specification. The patch is against the latest CVS. Thomas O'Dowd
2001-09-17Change vacuumlo to take 'lo' type into account.Hiroshi Inoue
2001-09-17Change FixupBlobXrefs() to take 'lo' type into account.Hiroshi Inoue
2001-09-17Simplify and clean up FigureColname; make it work without coredumpingTom Lane
for TypeCast case.
2001-09-17Use portable putenv(), not unportable setenv().Tom Lane
2001-09-17Suppress compiler warning.Tom Lane
2001-09-16Update documentation's info about location of our CVSROOT.Tom Lane
2001-09-16Russian translation from Serguei MokhovPeter Eisentraut
2001-09-16Update from Serguei MokhovPeter Eisentraut
2001-09-16Update intro in face of TOAST.Peter Eisentraut
2001-09-16Install dynamically loadable modules into a private subdirectoryPeter Eisentraut
under libdir, for a cleaner separation in the installation layout and compatibility with binary packaging standards. Point backend's default search location there. The contrib modules are also installed in the said location, giving them the benefit of the default search path as well. No changes in user interface nevertheless.
2001-09-16Update highlights. More items to add.Bruce Momjian
2001-09-16Point to HISTORY File for current info.Bruce Momjian
2001-09-16Add list of 7.2 changes in preparation for beta.Bruce Momjian
2001-09-15updatesPeter Eisentraut
2001-09-15Markup examples as examples.Peter Eisentraut
2001-09-15Markup examples as examples. Fix formatting of examples.Peter Eisentraut
2001-09-14Some formatting changes, add CSS stylesheet. Include indexes inPeter Eisentraut
documentation tarball builds.
2001-09-14> Here's a revised patch. Changes:Bruce Momjian
> > 1. Now outputs '\\' instead of '\134' when using encode(bytea, 'escape') > Note that I ended up leaving \0 as \000 so that there are no ambiguities > when decoding something like, for example, \0123. > > 2. Fixed bug in byteain which allowed input values which were not valid > octals (e.g. \789), to be parsed as if they were octals. > > Joe > Here's rev 2 of the bytea string support patch. Changes: 1. Added missing declaration for MatchBytea function 2. Added PQescapeBytea to fe-exec.c 3. Applies cleanly on cvs tip from this afternoon I'm hoping that someone can review/approve/apply this before beta starts, so I guess I'd vote (not that it counts for much) to delay beta a few days :-) Joe Conway
2001-09-14Allow '1' in jdbc2 boolean test.Bruce Momjian
2001-09-14Remove --enable-unicode-conversionTatsuo Ishii
unicode-conversion is always on if --enable-multibyte is specified Tatsuo Ishii
2001-09-14Add semicolonTatsuo Ishii
2001-09-14Fix typo.Tatsuo Ishii
2001-09-14Fix exmapleTatsuo Ishii
Tatsuo Ishii
2001-09-14Fix show messageTatsuo Ishii
Tatsuo Ishii
2001-09-14Add semicolonTatsuo Ishii
Tatsuo Ishii
2001-09-14Example rules do not work.Tatsuo Ishii
CREATE RULE bad_rule_combination_1 AS ON SELECT TO emp DO INSTEAD SELECT * FROM toyemp; CREATE RULE bad_rule_combination_2 AS ON SELECT TO toyemp DO INSTEAD SELECT * FROM emp; Tatsuo Ishii
2001-09-14Add semicolonTatsuo Ishii
2001-09-14Add semicolonTatsuo Ishii
Tatsuo Ishii
2001-09-14Change an *if condition*.Hiroshi Inoue
Hiroshi Inoue
2001-09-141) Improve the implementation of *Disallow Premature* forHiroshi Inoue
older versions of servers. 2) Implement SQLProcedures. Hiroshi Inoue
2001-09-14Update TODO list.Bruce Momjian
2001-09-14Fix a coversation error with pre 6.4 versions.Hiroshi Inoue
Hiroshi Inoue
2001-09-14Update TODO list.Bruce Momjian
2001-09-14Update TODO list.Bruce Momjian
2001-09-13Add missing paren to ODBC compiles.Bruce Momjian
2001-09-13Update compatibility information.Peter Eisentraut
2001-09-13Update compatibility information.Peter Eisentraut
2001-09-13Update compatibility information.Peter Eisentraut
2001-09-13Didn't want that jdbc patch in there yet.Bruce Momjian
2001-09-13> I found a problem with PQescapeString (I think). Since it escapesBruce Momjian
> null bytes to be literally '\0', the following can happen: > 1. User inputs string value as "<null byte>##" where ## are digits in the > range of 0 to 7. > 2. PQescapeString converts this to "\0##" > 3. Escaped string is used in a context that causes "\0##" to be evaluated as > an octal escape sequence. I agree that this is a problem, though it is not possible to do anything harmful with it. In addition, it only occurs if there are any NUL characters in its input, which is very unlikely if you are using C strings. The patch below addresses the issue by removing escaping of \0 characters entirely. > If the goal is to "safely" encode null bytes, and preserve the rest of the > string as it was entered, I think the null bytes should be escaped as \\000 > (note that if you simply use \000 the same string truncation problem > occurs). We can't do that, this would require 4n + 1 bytes of storage for the result, breaking the interface. Florian Weimer
2001-09-13Replace ASCII-quotes with proper markup.Peter Eisentraut
2001-09-131) Not export ODBC 3.0 functions.Hiroshi Inoue
2) (Maybe) fix a bug reported by Mika Muntila.
2001-09-12'chown -R postgres /usr/local/pgsql' is wrong. Need to do some more typing.Peter Eisentraut
2001-09-12Attached patch is correction for 'doc/jdbc.sgml' of PostgreSQL 7.1.3.Bruce Momjian
Correction content: * I revised a mistake of type (copy and paste). * I revised multiplicity of description. Ryouichi Matsuda
2001-09-12Followings are proposed fixes to jdbc.sgml(line numbers are for 7.1.3Bruce Momjian
doc). Hiroyuki Yatabe