OSDN Git Service
Bruce Momjian [Fri, 12 Jun 1998 22:26:24 +0000 (22:26 +0000)]
template changes
Bruce Momjian [Fri, 12 Jun 1998 18:44:21 +0000 (18:44 +0000)]
run autoconf
Bruce Momjian [Fri, 12 Jun 1998 18:36:42 +0000 (18:36 +0000)]
Clean up template names and remove LINUX_ELF hack. No longer
needed.
Bruce Momjian [Tue, 9 Jun 1998 22:59:04 +0000 (22:59 +0000)]
Now 6.4.
Bruce Momjian [Tue, 9 Jun 1998 19:20:59 +0000 (19:20 +0000)]
Auto-seed random so user's can't request random values based on
our postmaster random seed used from cancel.
Bruce Momjian [Tue, 9 Jun 1998 17:36:28 +0000 (17:36 +0000)]
Fix for exec() removal.
Bruce Momjian [Tue, 9 Jun 1998 17:13:06 +0000 (17:13 +0000)]
Another for for exec() removal and finding binaries.
Bruce Momjian [Tue, 9 Jun 1998 04:06:12 +0000 (04:06 +0000)]
Attached is a patch that fixes these leaks, and does a couple other
things as well:
* Computes and saves a cancel key for each backend. * fflush
before forking, to eliminate double-buffering problems
between postmaster and backends.
Other cleanups.
Tom Lane
Bruce Momjian [Mon, 8 Jun 1998 22:28:30 +0000 (22:28 +0000)]
Fixed exec path problem.
Byron Nikolaidis [Mon, 8 Jun 1998 20:55:33 +0000 (20:55 +0000)]
Official V.0244 (missed a file)
Bruce Momjian [Mon, 8 Jun 1998 19:36:40 +0000 (19:36 +0000)]
Show filename on exec failure.
Bruce Momjian [Mon, 8 Jun 1998 19:15:05 +0000 (19:15 +0000)]
Fix typo.
Bruce Momjian [Mon, 8 Jun 1998 16:48:49 +0000 (16:48 +0000)]
Make regression optional.
Bruce Momjian [Mon, 8 Jun 1998 16:43:15 +0000 (16:43 +0000)]
update to say "most advanced".
Byron Nikolaidis [Mon, 8 Jun 1998 16:15:12 +0000 (16:15 +0000)]
Update driver to official 6.30.0244 release.
Bruce Momjian [Mon, 8 Jun 1998 04:27:59 +0000 (04:27 +0000)]
Add real random() call to postmaster for use in cancel.
Bruce Momjian [Fri, 5 Jun 1998 03:56:03 +0000 (03:56 +0000)]
Also added two new files.
src/test/regess/sql/junkfilter.sql -- SQL for
regression test src/test/regess/expected/junkfilter.out --
Expected output SQL for regression test
David Hartwig
Bruce Momjian [Fri, 5 Jun 1998 03:49:20 +0000 (03:49 +0000)]
I made several adjustments to my earlier patch to handle the
condition where the target label is ambiguous.
Bruce Momjian [Thu, 4 Jun 1998 17:26:49 +0000 (17:26 +0000)]
Show backend status on ps command line. Remove unused args from
pg_exec_query().
Byron Nikolaidis [Wed, 3 Jun 1998 20:33:45 +0000 (20:33 +0000)]
Update odbc driver to current version V.0244
Marc G. Fournier [Wed, 3 Jun 1998 19:43:29 +0000 (19:43 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
Bug fixes:
PreparedStatement.setObject didn't handle short's
ResultSet.getDate() now handles null dates (returns null rather
than a NullPointerException)
ResultSetMetaData.getPrecision() now returns 0 for VARCHAR
New features:
Field now caches the typename->oid in a Hashtable to speed things
up. It removes the need for some unnecessary queries to the
backend.
PreparedStatement.toString() now returns the sql statement that
it will send to the backend. Before it did nothing.
DatabaseMetaData.getTypeInfo() now does something.
Marc G. Fournier [Wed, 3 Jun 1998 18:56:09 +0000 (18:56 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
Bug fixes:
PreparedStatement.setObject didn't handle short's
ResultSet.getDate() now handles null dates (returns null rather
than a NullPointerException)
ResultSetMetaData.getPrecision() now returns 0 for VARCHAR
New features:
Field now caches the typename->oid in a Hashtable to speed things
up. It removes the need for some unnecessary queries to the
backend.
PreparedStatement.toString() now returns the sql statement that
it will send to the backend. Before it did nothing.
DatabaseMetaData.getTypeInfo() now does something.
Marc G. Fournier [Wed, 3 Jun 1998 13:55:15 +0000 (13:55 +0000)]
From: Michael Meskes <meskes@topsystem.de>
+ Wed Jun 3 13:38:57 CEST 1998
+
+ - Made sqlca struct compatible with other systems.
+ - Give back a warning in case of truncation
+ - Changed the handling of OptimizableStmt since the old one broke
+ CREATE RULE
+ - Set library version to 2.3
+ - Set version to 2.3.3
Edmund Mergl [Mon, 1 Jun 1998 16:50:23 +0000 (16:50 +0000)]
pgsql no more needs to be installed for perl
Edmund Mergl [Mon, 1 Jun 1998 16:44:08 +0000 (16:44 +0000)]
removed constraint for perl: installed pgsql
Edmund Mergl [Mon, 1 Jun 1998 16:41:27 +0000 (16:41 +0000)]
adapted Makefile.PL to be build in source tree
Marc G. Fournier [Sun, 31 May 1998 22:20:44 +0000 (22:20 +0000)]
Update the text...
Thomas G. Lockhart [Sun, 31 May 1998 17:08:35 +0000 (17:08 +0000)]
Rewrite JROUND macro to multiply by 1e6 rather than divide by 1e-6
and vica versa for the next operation.
This is reputed to fix inline math optimization troubles in glibc-2.0.x.
Regression tests still pass on libc/i686 machine. Patch suggested by Matt.
Bruce Momjian [Fri, 29 May 1998 17:10:07 +0000 (17:10 +0000)]
cleanup.
Bruce Momjian [Fri, 29 May 1998 17:00:34 +0000 (17:00 +0000)]
Remove fork()/exec() and only do fork(). Small cleanups.
Thomas G. Lockhart [Fri, 29 May 1998 14:07:50 +0000 (14:07 +0000)]
Define new routines oper_exact() and oper_inexact().
Add coerce_target_expr().
Thomas G. Lockhart [Fri, 29 May 1998 14:03:08 +0000 (14:03 +0000)]
Add func_select_candidate() to allow use in unary operator parsing.
Thomas G. Lockhart [Fri, 29 May 1998 14:02:28 +0000 (14:02 +0000)]
Add NAMEOID as built-in type.
Change ordering of IS_BUILTIN_TYPE() macro to optimize lookup.
Make CASH type _not_ equivalent to INT4.
CASH is passed by reference rather than passed by value.
Thomas G. Lockhart [Fri, 29 May 1998 14:00:24 +0000 (14:00 +0000)]
Do type conversion to match columns in UNION clauses.
Currently force the type to match the _first_ select in the union.
Move oper_select_candidate() from parse_func.c to parse_oper.c.
Throw error inside of oper_inexact() if no match for binary operators.
Check more carefully that types can be coerced
even if there is only one candidate operator in oper_inexact().
Fix up error messages for more uniform look.
Remove unused code.
Fix up comments.
Thomas G. Lockhart [Fri, 29 May 1998 13:43:14 +0000 (13:43 +0000)]
Require #define variable ALLOW_ABSOLUTE_DBPATHS if absolute paths are
allowed to be used for alternate database locations.
Probably best to default to not allowed, as now, since there are security
and integrity issues which should be considered carefully before
opening things up.
Will update docs to discuss this issue.
Thomas G. Lockhart [Fri, 29 May 1998 13:39:30 +0000 (13:39 +0000)]
Fix up a couple of comments broken by the automatic indenting process.
Thomas G. Lockhart [Fri, 29 May 1998 13:37:29 +0000 (13:37 +0000)]
Add conversion functions between "name" and other string types.
Thomas G. Lockhart [Fri, 29 May 1998 13:33:58 +0000 (13:33 +0000)]
Add conversion functions to and from the "name" data type.
Thomas G. Lockhart [Fri, 29 May 1998 13:31:52 +0000 (13:31 +0000)]
Ensure string is completely null padded on input (as advertised).
Thomas G. Lockhart [Fri, 29 May 1998 13:23:02 +0000 (13:23 +0000)]
Add test for UNION.
Add additional tests in strings for conversions of the "name" data type.
Test SQL92 string functions such as SUBSTRING() and POSITION().
Thomas G. Lockhart [Fri, 29 May 1998 13:22:42 +0000 (13:22 +0000)]
Add test for UNION.
Add additional tests in strings for conversions of the "name" data type.
Test SQL92 string functions such as SUBSTRING() and POSITION().
Fix geometry tests to reflect code fixed by Gautam.
Update error messages.
Thomas G. Lockhart [Fri, 29 May 1998 13:16:36 +0000 (13:16 +0000)]
Clarify ownership and security issues with alternate db locations.
Thomas G. Lockhart [Fri, 29 May 1998 13:14:25 +0000 (13:14 +0000)]
Define PGDOC to use POSTGRESDIR by default.
Can be set to something else in Makefile.custom if necessary.
Bruce Momjian [Wed, 27 May 1998 18:32:05 +0000 (18:32 +0000)]
postmaster/postgres options cleanup.
Bruce Momjian [Tue, 26 May 1998 17:29:07 +0000 (17:29 +0000)]
Cleanup.
Marc G. Fournier [Tue, 26 May 1998 13:43:55 +0000 (13:43 +0000)]
From: Michael Meskes <meskes@topsystem.de>
+Wed May 20 10:46:48 CEST 1998
+
+ - Fixed handling of preprocessor directives and variable
+ initialization.
+ - Added enum datatype.
- Set version to 2.3.2
Bruce Momjian [Tue, 26 May 1998 03:44:07 +0000 (03:44 +0000)]
Fix for drop database and junk filters.
Bruce Momjian [Tue, 26 May 1998 03:20:01 +0000 (03:20 +0000)]
Fix for postgres started from command line, sends 'Z' protocol
flag.
Bruce Momjian [Sun, 24 May 1998 17:34:23 +0000 (17:34 +0000)]
Clean up pg_hba.conf
Marc G. Fournier [Sun, 24 May 1998 03:54:56 +0000 (03:54 +0000)]
1998-05-18 Karl Eichwalder <ke@suse.de>
* configure.in (AC_CHECK_LIB): check for ncurses; if this fails
check for curses.
Marc G. Fournier [Sun, 24 May 1998 03:52:39 +0000 (03:52 +0000)]
From: Brook Milligan <brook@trillium.NMSU.Edu>
Everything (except of course random) passes on my netbsd box except int2,
int4, oidint2, and oidint4; all fail because of error message differences.
Below are some patches to the expectations to correct the problem by creating
*-NetBSD.out files.
Marc G. Fournier [Sun, 24 May 1998 03:48:58 +0000 (03:48 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>
... which causes it to build and install the shared version of
libpgtcl under the wrong name, on HPUX only. Patch against
today's sources follows.
Bruce Momjian [Fri, 22 May 1998 04:48:45 +0000 (04:48 +0000)]
Solaris 5 fix.
Bruce Momjian [Fri, 22 May 1998 04:20:53 +0000 (04:20 +0000)]
Move FAQ_DEV to docs directory, where it belongs.
Marc G. Fournier [Thu, 21 May 1998 03:53:51 +0000 (03:53 +0000)]
From: David Hartwig <daveh@insightdist.com>
Here is a patch to remove the requirement that ORDER/GROUP BY clause
identifiers be included in the target list.
Marc G. Fournier [Thu, 21 May 1998 03:52:37 +0000 (03:52 +0000)]
From: Michael Meskes <meskes@topsystem.de>
+ Tue May 19 11:49:34 CEST 1998
+
+ - Tested (and fixed) 'set connection'
+ - Fixed string notation in C
+ - Set version to 2.3.2
Bruce Momjian [Tue, 19 May 1998 18:05:58 +0000 (18:05 +0000)]
Allow cancel from client of backend query. Change some int variables
to bool's.
Marc G. Fournier [Mon, 18 May 1998 16:05:05 +0000 (16:05 +0000)]
From: Michael Meskes <meskes@topsystem.de>
+
+ Wed May 6 16:09:45 CEST 1998
+
+ - Some more cleanups in the library.
+
+ Thu May 7 12:34:28 CEST 1998
+
+ - Made CONNECT and DISCONNECT statement more SQL3 compliant.
+ - Changed the API for the ECPGconnect function to be able to handle
+ hostnames and ports
+
+ Fri May 8 13:54:45 CEST 1998
+ - More changes to the parser. The connect statement now allows
+ ORACLE style logins.
+ - db-name is accepted in two ways:
+ - <dbname>[@<server>][:<port>]
+ - esql:postgresql://<server>[:<port>][/<dbname>]
+
+ Mon May 11 10:28:37 CEST 1998
+
+ - Added '? options' to connect call.
+ - Also allow USING as keyword for the password
+
+ Thu May 14 15:09:58 CEST 1998
+
+ - Changed preproc.y and pgc.l according to the parser changes in the
+ backend.
+
+ Fri May 15 09:55:21 CEST 1998
+
+ - Added connection_name handling
+
+
+ Mon May 18 10:33:58 CEST 1998
+
+ - Fixed some more bugs
+ - Set version to 2.3.1
+ - Set library version to 2.2
Marc G. Fournier [Fri, 15 May 1998 20:10:42 +0000 (20:10 +0000)]
From: "Aldrin L." <aldrin@americasnet.com>
Subject: [INTERFACES] mSQL Compatibility Library (fwd)
Bruce Momjian [Fri, 15 May 1998 01:57:33 +0000 (01:57 +0000)]
Another \f\ fix for psql.
Bruce Momjian [Thu, 14 May 1998 17:18:14 +0000 (17:18 +0000)]
Pass atttypmod to the frontend.
Thomas G. Lockhart [Wed, 13 May 1998 05:34:39 +0000 (05:34 +0000)]
First reference manual.
Thomas G. Lockhart [Wed, 13 May 1998 05:34:00 +0000 (05:34 +0000)]
First files for reference pages.
Thomas G. Lockhart [Wed, 13 May 1998 05:33:32 +0000 (05:33 +0000)]
First changes for reference pages. Fix markup in the docguide.
Thomas G. Lockhart [Wed, 13 May 1998 04:54:16 +0000 (04:54 +0000)]
Remove extraneous -DPARSEDEBUG from CFLAGS options.
Marc G. Fournier [Wed, 13 May 1998 04:01:44 +0000 (04:01 +0000)]
Made a copy of errors with the AC_TRY_RUN() macro...appears to work better
under FreeBSD for DBL_MIN check now...
Marc G. Fournier [Wed, 13 May 1998 03:44:48 +0000 (03:44 +0000)]
Add a check for DBL_MIN problem...not sure if this is right...needs
testing...
Bruce Momjian [Wed, 13 May 1998 03:44:24 +0000 (03:44 +0000)]
Remove added NullProc define, and use fmgr.h value from fmgr.h.
Bruce Momjian [Wed, 13 May 1998 03:29:12 +0000 (03:29 +0000)]
|I noticed that the -assignbyidx function of -result in libpgtcl
is not |documented, here is the relevant patch for it
Anton
Bruce Momjian [Wed, 13 May 1998 03:27:07 +0000 (03:27 +0000)]
Fix to allow \f \ to make spaces as delimiter.
Bruce Momjian [Tue, 12 May 1998 23:14:00 +0000 (23:14 +0000)]
Remove --disable in configure
Bruce Momjian [Tue, 12 May 1998 23:12:42 +0000 (23:12 +0000)]
Remove --disabled options from configure
Bruce Momjian [Tue, 12 May 1998 23:05:12 +0000 (23:05 +0000)]
The attached patch corrects two problems with autoconfiguration of
psql in Postgres 6.3.2. Both of these problems were complained of
recently in pgsql-questions:
1. In the right circumstances, psql.c will fail to compile due to
trying
to include a nonexistent <history.h>. (Thread "Compile-time
error" around 17 Apr 98.) 2. In other circumstances, psql will
compile but does not provide
command history capability, even though the underlying readline
library supports it. (Various threads, most recently "query
repetition in psql" around 29 Apr.)
Tom Lane
Bruce Momjian [Tue, 12 May 1998 23:04:01 +0000 (23:04 +0000)]
Give proper error on psql \copy use.
Bruce Momjian [Tue, 12 May 1998 21:44:08 +0000 (21:44 +0000)]
Cleanups for large objects, so file is trucated on open, fix for
solaris/spare shared libararies, new error message for postmaster
startup, and makefile cleanups.
Bruce Momjian [Tue, 12 May 1998 17:46:50 +0000 (17:46 +0000)]
Someone remove a #define too much from pg_proc.h which breaks
compiling nbtsearch.c after configuring with --enable-cassert.
Patch below.
-- --------------------------------------------- Göran Thyni,
sysadm, JMS Bildbasen, Kiruna
Bruce Momjian [Tue, 12 May 1998 15:42:09 +0000 (15:42 +0000)]
Add sys/time.h to fe-misc.c, prevent pgtclsh from using old libaries,
and allow CUSTOM_COPT to appear in compile AND LINK commands.
Thomas G. Lockhart [Sat, 9 May 1998 23:50:24 +0000 (23:50 +0000)]
Changed error message slightly.
Thomas G. Lockhart [Sat, 9 May 1998 23:46:35 +0000 (23:46 +0000)]
Add some more node print routines for debugging only
(inside of #ifdef PARSEDEBUG blocks).
Thomas G. Lockhart [Sat, 9 May 1998 23:45:29 +0000 (23:45 +0000)]
Fix CACHEDEBUG debugging statements; usually not used and apparently
broke a long time ago when some definitions changed.
Thomas G. Lockhart [Sat, 9 May 1998 23:43:45 +0000 (23:43 +0000)]
Change parameters to func_error().
Thomas G. Lockhart [Sat, 9 May 1998 23:31:34 +0000 (23:31 +0000)]
Add capabilities for automatic type conversion.
Thomas G. Lockhart [Sat, 9 May 1998 23:28:49 +0000 (23:28 +0000)]
Add TIMEZONE_HOUR, TIMEZONE_MINUTE keywords per SQL92 specs.
Thomas G. Lockhart [Sat, 9 May 1998 23:27:39 +0000 (23:27 +0000)]
llow more variations on valid floating point numbers (e.g. ".1", "1e6").
Reintroduce fixes for unary minus parsing with leading spaces.
Thomas G. Lockhart [Sat, 9 May 1998 23:27:14 +0000 (23:27 +0000)]
Implement TIMEZONE_HOUR, TIMEZONE_MINUTE per SQL92 specs.
Check for and properly ignore FOREIGN KEY column constraints
(already had fixed same for table constraints).
Define USER as synonym for CURRENT_USER per SQL92 specs
(no longer allowed as bare column name, sorry).
Re-enable HAVING clause but no fixes elsewhere yet.
Other stuff from today's update of gram.y...
Thomas G. Lockhart [Sat, 9 May 1998 23:24:27 +0000 (23:24 +0000)]
Add parse_coerce.c for type conversion handling.
Thomas G. Lockhart [Sat, 9 May 1998 23:22:15 +0000 (23:22 +0000)]
Implement TIMEZONE_HOUR, TIMEZONE_MINUTE per SQL92 specs.
Check for and properly ignore FOREIGN KEY column constraints
(already had fixed same for table constraints).
Define USER as synonym for CURRENT_USER per SQL92 specs
(no longer allowed as bare column name, sorry).
Re-enable HAVING clause but no fixes elsewhere yet.
Make "char" type a synonum for "char(1)" (actually implemented as bpchar).
Compress/compact row-style subselect and operator definitions
(cut out ~140 lines of code with no change in functionality).
Save string type if specified for DEFAULT clause handling.
Enough for now...
Thomas G. Lockhart [Sat, 9 May 1998 23:15:20 +0000 (23:15 +0000)]
Allow more variations on valid floating point numbers (e.g. ".1", "1e6").
Reintroduce fixes for unary minus parsing with leading spaces.
Thomas G. Lockhart [Sat, 9 May 1998 22:48:37 +0000 (22:48 +0000)]
Make lines and support routines/operators more visible.
Add #define's for remaining "builtin" types.
Thomas G. Lockhart [Sat, 9 May 1998 22:45:14 +0000 (22:45 +0000)]
Add routines to convert between varchar and bpchar.
Add routines to allow sizing of varchar and bpchar into target columns.
Thomas G. Lockhart [Sat, 9 May 1998 22:44:38 +0000 (22:44 +0000)]
Make lines more visible to the user.
Thomas G. Lockhart [Sat, 9 May 1998 22:43:50 +0000 (22:43 +0000)]
Add bit flags to support timezonehour and minute in data retrieval.
Thomas G. Lockhart [Sat, 9 May 1998 22:39:55 +0000 (22:39 +0000)]
Make a few line routines visible.
Incorporate patches from Gautam for line/point intersection.
Thomas G. Lockhart [Sat, 9 May 1998 22:38:18 +0000 (22:38 +0000)]
Define "tz_hour" and "tz_minute" arguments to date_part().
Fix up "ISO-style" timespan decoding and encoding.
Thomas G. Lockhart [Sat, 9 May 1998 22:32:03 +0000 (22:32 +0000)]
Allow building a source tarball.
Try to generalize the gzip/tar usage for more portability.
Thomas G. Lockhart [Sat, 9 May 1998 22:23:38 +0000 (22:23 +0000)]
Minor markup change.
Bruce Momjian [Thu, 7 May 1998 16:17:18 +0000 (16:17 +0000)]
Add missing includes.
Bruce Momjian [Thu, 7 May 1998 14:52:52 +0000 (14:52 +0000)]
Add missing file from Tom Lane.
Bruce Momjian [Wed, 6 May 1998 23:53:48 +0000 (23:53 +0000)]
It seems the regression tests don't cover copy in/out at all, so
code that I had assumed was working had not been tested. Naturally,
it was broken ...
Tom Lane
Bruce Momjian [Wed, 6 May 1998 23:51:16 +0000 (23:51 +0000)]
What I've done:
1. Rewritten libpq to allow asynchronous clients.
2. Implemented client side of cancel protocol in library,
and patched psql.c to send a cancel request upon SIGINT. The
backend doesn't notice it yet :-(
3. Implemented 'Z' protocol message addition and renaming of
copy in/out start messages. These are implemented conditionally,
ie, the client protocol version is checked; so the code should
still work with 1.0 clients.
4. Revised protocol and libpq sgml documents (don't have an SGML
compiler, though, so there may be some markup glitches here).
What remains to be done:
1. Implement addition of atttypmod field to RowDescriptor messages.
The client-side code is there but ifdef'd out. I have no idea
what to change on the backend side. The field should be sent
only if protocol >= 2.0, of course.
2. Implement backend response to cancel requests received as OOB
messages. (This prolly need not be conditional on protocol
version; just do it if you get SIGURG.)
3. Update libpq.3. (I'm hoping this can be generated mechanically
from libpq.sgml... if not, will do it by hand.) Is there any
other doco to fix?
4. Update non-libpq interfaces as necessary. I patched libpgtcl
so that it would compile, but haven't tested it. Dunno what
needs to be done with the other interfaces.
Have at it!
Tom Lane