OSDN Git Service
Tom Lane [Sat, 10 Feb 2001 07:08:44 +0000 (07:08 +0000)]
Fix example of syntactic ambiguity between prefix/infix/postfix operators
--- Postgres now accepts the example we claimed it wouldn't. Miscellaneous
copy-editing as well.
Bruce Momjian [Sat, 10 Feb 2001 07:01:19 +0000 (07:01 +0000)]
Run pgindent over ODBC source. We couldn't do this years ago because we
weren't the master source. We are now, and it really needs it.
Bruce Momjian [Sat, 10 Feb 2001 06:58:40 +0000 (06:58 +0000)]
Remove protocol-dependent code. This should have been on previous commit.
Bruce Momjian [Sat, 10 Feb 2001 06:57:53 +0000 (06:57 +0000)]
Cleanup
Bruce Momjian [Sat, 10 Feb 2001 06:12:15 +0000 (06:12 +0000)]
More cleanup, again not sure it works.
Bruce Momjian [Sat, 10 Feb 2001 05:55:17 +0000 (05:55 +0000)]
Clean up bad variable used in script. Still not sure it works under Linux.
Bruce Momjian [Sat, 10 Feb 2001 05:50:29 +0000 (05:50 +0000)]
Properly exit ODBC with 'X', allow linking on BSD/OS.
Tom Lane [Sat, 10 Feb 2001 05:32:33 +0000 (05:32 +0000)]
Fix documentation of EXECUTE, add documentation of FOR ... EXECUTE.
Tom Lane [Sat, 10 Feb 2001 04:07:25 +0000 (04:07 +0000)]
Fix byte-vs-word-width oversight in m68k TAS() code.
Man, this brings back some old memories ...
Tom Lane [Sat, 10 Feb 2001 03:57:42 +0000 (03:57 +0000)]
Update findoidjoins notes for 7.1.
Tom Lane [Sat, 10 Feb 2001 03:44:54 +0000 (03:44 +0000)]
Compile a little more cleanly.
Tom Lane [Sat, 10 Feb 2001 03:44:06 +0000 (03:44 +0000)]
Add oid2name subdirectory to contrib Makefile.
Tom Lane [Sat, 10 Feb 2001 03:12:16 +0000 (03:12 +0000)]
Ignore leading whitespace when trying to determine statement type,
so that ODBC driver doesn't go belly up by failing to recognize a
SELECT as such.
Tom Lane [Sat, 10 Feb 2001 02:31:31 +0000 (02:31 +0000)]
Restructure the key include files per recent pghackers discussion: there
are now separate files "postgres.h" and "postgres_fe.h", which are meant
to be the primary include files for backend .c files and frontend .c files
respectively. By default, only include files meant for frontend use are
installed into the installation include directory. There is a new make
target 'make install-all-headers' that adds the whole content of the
src/include tree to the installed fileset, for use by people who want to
develop server-side code without keeping the complete source tree on hand.
Cleaned up a whole lot of crufty and inconsistent header inclusions.
Peter Eisentraut [Sat, 10 Feb 2001 00:50:18 +0000 (00:50 +0000)]
Update section about how to start server from boot scripts.
Peter Eisentraut [Sat, 10 Feb 2001 00:13:23 +0000 (00:13 +0000)]
Add new FreeBSD start script that makes use of new pg_ctl functionality.
Bruce Momjian [Fri, 9 Feb 2001 22:23:47 +0000 (22:23 +0000)]
Remove last code that assumed xinv/xinx are large object files.
Peter Eisentraut [Fri, 9 Feb 2001 20:38:15 +0000 (20:38 +0000)]
Avoid a particular <simplelist>. jadetex has formatting problems,
apparently when the content is long enough to require line breaks.
Peter Eisentraut [Fri, 9 Feb 2001 20:24:08 +0000 (20:24 +0000)]
Make more portable.
Tom Lane [Fri, 9 Feb 2001 19:26:45 +0000 (19:26 +0000)]
This hasn't been used for anything for a long time...
Bruce Momjian [Fri, 9 Feb 2001 19:24:09 +0000 (19:24 +0000)]
Large object manual updates.
Tom Lane [Fri, 9 Feb 2001 18:42:35 +0000 (18:42 +0000)]
Remove link to dead subdirectory 'linux'.
Bruce Momjian [Fri, 9 Feb 2001 17:55:48 +0000 (17:55 +0000)]
Mention NetBSD
Bruce Momjian [Fri, 9 Feb 2001 17:53:44 +0000 (17:53 +0000)]
Remove pg_service mention.
Bruce Momjian [Fri, 9 Feb 2001 17:37:49 +0000 (17:37 +0000)]
Update TODO list.
Tom Lane [Fri, 9 Feb 2001 17:30:03 +0000 (17:30 +0000)]
When updating a tuple containing compressed-in-line fields, do not
decompress the existing fields unnecessarily.
Bruce Momjian [Fri, 9 Feb 2001 17:16:57 +0000 (17:16 +0000)]
Add -g as synonmym for --globals-only in pg_dumpall. Add info about
-c,--clean option to manual page.
Bruce Momjian [Fri, 9 Feb 2001 15:22:22 +0000 (15:22 +0000)]
Update TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:20:54 +0000 (15:20 +0000)]
Update TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:15:09 +0000 (15:15 +0000)]
Update TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:13:49 +0000 (15:13 +0000)]
I have deleted the include of termios.h in include/port/qnx4.h.
Then I recompiled pgsql and I have compiled a program with ecpg.
I have removed the termios.h, and the ECHO hack.
Thanks
Maurizio
Hiroshi Inoue [Fri, 9 Feb 2001 06:03:14 +0000 (06:03 +0000)]
Change SELECT to not trigger "BEGIN" in not autocommit mode.
Tom Lane [Fri, 9 Feb 2001 03:26:28 +0000 (03:26 +0000)]
plpgsql's private copy of xlateSqlType was out of sync. Again. This
is clearly not maintainable, so dike it out in favor of calling the real
version in the backend's gram.y.
Tom Lane [Fri, 9 Feb 2001 03:06:38 +0000 (03:06 +0000)]
Document PL/TclU language variant, and do some minor copy-editing.
Tom Lane [Fri, 9 Feb 2001 02:20:52 +0000 (02:20 +0000)]
Restructure discussion of PL installation to emphasize createlang as the
recommended install procedure, rather than mentioning it as an afterthought.
Tom Lane [Fri, 9 Feb 2001 01:05:42 +0000 (01:05 +0000)]
Remove no-longer-needed mklang script; now superseded by createlang.
Tom Lane [Fri, 9 Feb 2001 00:14:26 +0000 (00:14 +0000)]
EXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
rather than executing the INTO clause with non-plpgsql semantics
as it was doing for the last few weeks/months. This keeps our options
open for making it do the right plpgsql-ish thing in future without
creating a backwards compatibility problem. There is no loss of
functionality since people can get the same behavior with CREATE TABLE AS.
Peter Eisentraut [Thu, 8 Feb 2001 19:53:33 +0000 (19:53 +0000)]
Remove outdated contrib/linux start scripts. Beat some sense into
contrib/init.d start script. Place into more aptly named directory. Maybe
we could add scripts for other platforms here later.
Peter Eisentraut [Thu, 8 Feb 2001 19:39:24 +0000 (19:39 +0000)]
Make -w the default for shut down, add -W option to specify no wait.
Add -l option to name log file. Set umask to 077.
Proper file descriptor redirection to allow postmaster to detach from
shell's process group.
Add -s option to turn off informational messages.
Bruce Momjian [Thu, 8 Feb 2001 04:57:24 +0000 (04:57 +0000)]
UPdate file from Patrick.
Hiroshi Inoue [Thu, 8 Feb 2001 01:54:29 +0000 (01:54 +0000)]
Fix a misuse of 'char *' declaration.
Tom Lane [Thu, 8 Feb 2001 00:35:10 +0000 (00:35 +0000)]
When launching a child backend, take care to close file descriptors for
any other client connections that may exist (which would only happen if
another client is currently in the authentication cycle). This avoids
wastage of open descriptors in a child. It might also explain peculiar
behaviors like not closing connections when expected, since the kernel
will probably not signal EOF as long as some other backend is randomly
holding open a reference to the connection, even if the client went away
long since ...
Vadim B. Mikheev [Wed, 7 Feb 2001 23:36:22 +0000 (23:36 +0000)]
FixBTree flag still exists and may be used to turn
runtime recovery OFF.
Vadim B. Mikheev [Wed, 7 Feb 2001 23:35:33 +0000 (23:35 +0000)]
Runtime btree recovery is now ON by default.
Vadim B. Mikheev [Wed, 7 Feb 2001 23:34:18 +0000 (23:34 +0000)]
Macro for btree runtime fix.
Tom Lane [Wed, 7 Feb 2001 23:31:38 +0000 (23:31 +0000)]
Repair postmaster memory leakage during password authentication.
Tom Lane [Wed, 7 Feb 2001 21:30:12 +0000 (21:30 +0000)]
Redo pgaccess' queries about views so that they will work in both 7.1
and prior releases --- rely on pg_views view instead of direct access
to pg_class and pg_rewrite.
Tom Lane [Wed, 7 Feb 2001 21:25:55 +0000 (21:25 +0000)]
Not sure why this work script was in the repository ... but it doesn't
belong ...
Tom Lane [Wed, 7 Feb 2001 20:46:55 +0000 (20:46 +0000)]
Minor copy-editing.
Tom Lane [Wed, 7 Feb 2001 20:30:20 +0000 (20:30 +0000)]
Use explicit path to libpgtcl.so, instead of relying on LD_LIBRARY_PATH
or local equivalent. Also, honor --with-pgport configure option for
default port number, and allow PGPORT environment variable to override
this.
Tom Lane [Wed, 7 Feb 2001 20:13:27 +0000 (20:13 +0000)]
Make DEF_PGPORT available to Makefiles, so it can be substituted into
scripts like pgaccess.
Tom Lane [Wed, 7 Feb 2001 20:00:08 +0000 (20:00 +0000)]
Actually, it looks like DEF_PGPORT belongs over in config.h.win32 for
the Windows build...
Tom Lane [Wed, 7 Feb 2001 19:30:22 +0000 (19:30 +0000)]
Remove broken (and unnecessary) definition of DEF_PGPORT.
Peter Eisentraut [Wed, 7 Feb 2001 18:22:10 +0000 (18:22 +0000)]
Only pass the -L* portions of LDFLAGS to the Python build environment.
Other flags can have unpredictable effects when Python uses different
commands to build than we do.
Tom Lane [Wed, 7 Feb 2001 17:59:58 +0000 (17:59 +0000)]
Need to specify DYNAMIC_PATH flag to shl_load, else HPUX's dld will not
honor library search path that we so carefully installed into the
executable ...
Bruce Momjian [Wed, 7 Feb 2001 16:33:32 +0000 (16:33 +0000)]
Update FAQ.
Bruce Momjian [Wed, 7 Feb 2001 16:32:47 +0000 (16:32 +0000)]
Update FAQ.
Peter Mount [Wed, 7 Feb 2001 09:13:20 +0000 (09:13 +0000)]
Some updates prior to retrieving a fresh cvs copy:
Tue Feb 06 19:00:00 GMT 2001 peter@retep.org.uk
- Completed first two TestCase's for the test suite. JUnit is now
recognised by ant.
Bruce Momjian [Wed, 7 Feb 2001 04:50:55 +0000 (04:50 +0000)]
Add java.
Bruce Momjian [Wed, 7 Feb 2001 04:50:50 +0000 (04:50 +0000)]
Update TODO list.
Bruce Momjian [Wed, 7 Feb 2001 04:48:27 +0000 (04:48 +0000)]
Add item.
Bruce Momjian [Wed, 7 Feb 2001 00:52:56 +0000 (00:52 +0000)]
Update TODO list.
Bruce Momjian [Wed, 7 Feb 2001 00:52:42 +0000 (00:52 +0000)]
Update TODO list.
Bruce Momjian [Tue, 6 Feb 2001 21:38:43 +0000 (21:38 +0000)]
cleaned up.
Bruce Momjian [Tue, 6 Feb 2001 21:37:55 +0000 (21:37 +0000)]
Make it clearer.
Peter Eisentraut [Tue, 6 Feb 2001 19:20:16 +0000 (19:20 +0000)]
Only use termcap xor [n]curses, depending on what readline needs. Solaris
has problems when linking with both.
Bruce Momjian [Tue, 6 Feb 2001 18:05:13 +0000 (18:05 +0000)]
Well, learned the hard way...
Marko Kreen
Bruce Momjian [Tue, 6 Feb 2001 18:02:25 +0000 (18:02 +0000)]
Add.
Bruce Momjian [Tue, 6 Feb 2001 17:47:48 +0000 (17:47 +0000)]
Update /contrib and TODO.detail.
Bruce Momjian [Tue, 6 Feb 2001 17:42:37 +0000 (17:42 +0000)]
Update TODO list.
Bruce Momjian [Tue, 6 Feb 2001 17:42:18 +0000 (17:42 +0000)]
Update TODO list.
Peter Eisentraut [Tue, 6 Feb 2001 17:00:01 +0000 (17:00 +0000)]
If the first argument is --version or --help, skip the root check.
Vadim B. Mikheev [Tue, 6 Feb 2001 06:24:00 +0000 (06:24 +0000)]
PageAddItem in overwrite mode: must *NOT* check itemid' flag if
OffsetNumber == MaxOffsetNumber + 1 - there may be garbage there!
Bruce Momjian [Tue, 6 Feb 2001 04:28:50 +0000 (04:28 +0000)]
Update FAQ.
Hiroshi Inoue [Tue, 6 Feb 2001 02:21:12 +0000 (02:21 +0000)]
Improved version handling introduced by Dave Page.
The driver version is 07.01.0002 now.
1) initialized pg_version by DSN's protocol info
so that we could always use pg_version info
once a connection is established (pg_version()
didn't exist before 6.4). PROTOCOL_XX() macros
are removed(except from connection.[ch]).
2) provided a few macros to encapsulate connection's
version info and replaced existent comparison
stuff by those macros.
3) change SQLTables() so that 7.1 servers could show
views.
In addtion, the following patch from Dave Page is applied.
This patch fixes a bug in SQLGetInfo for SQL_DBMS_VER which corrupted the
driver version string. The driver version number has also been incremented
to 07.01.0002.
Regards, Dave. <<odbc.diff>>
Tom Lane [Tue, 6 Feb 2001 02:02:27 +0000 (02:02 +0000)]
Now that I look at it, PQoidValue() ain't quite right either.
Tom Lane [Tue, 6 Feb 2001 02:00:09 +0000 (02:00 +0000)]
Repair PQoidStatus() bug reported by darcy@druid.net.
Tom Lane [Tue, 6 Feb 2001 01:53:53 +0000 (01:53 +0000)]
Out-of-bounds memory allocation request sizes should be treated as just
elog(ERROR) not an Assert trap, since we've downgraded out-of-memory to
elog(ERROR) not a fatal error. Also, change the hard boundary from 256Mb
to 1Gb, just so that anyone who's actually got that much memory to spare
can play with TOAST objects approaching a gigabyte.
Peter Eisentraut [Mon, 5 Feb 2001 19:21:45 +0000 (19:21 +0000)]
Document BETWEEN.
Bruce Momjian [Mon, 5 Feb 2001 17:37:44 +0000 (17:37 +0000)]
Update FAQ.
Peter Eisentraut [Mon, 5 Feb 2001 17:35:04 +0000 (17:35 +0000)]
Dump/display 'timestamp' as 'timestamp with time zone', to make room for a
future 'timestamp without time zone', which SQL claims is equivalent to
plain 'timestamp'.
Peter Eisentraut [Sun, 4 Feb 2001 15:28:18 +0000 (15:28 +0000)]
Move PL docs to programmer's guide, "storage" chapter to admin guide,
clean up some things in the affected areas.
Peter Eisentraut [Sun, 4 Feb 2001 14:09:33 +0000 (14:09 +0000)]
Check for -lresolv.
Peter Eisentraut [Sun, 4 Feb 2001 13:21:46 +0000 (13:21 +0000)]
Pass LDFLAGS along with LIBS to the Python build stuff, especially to pick
up -L options.
Peter Eisentraut [Sun, 4 Feb 2001 12:23:11 +0000 (12:23 +0000)]
Must run jadetex three times to get correct page numbers. Add support for
pdfjadetex.
Peter Eisentraut [Sun, 4 Feb 2001 12:18:08 +0000 (12:18 +0000)]
When making xrefs to refsects, the linkend should point to the refsect and
the endterm to the title element, not both to the title. At least
docbook2man prefers it that way.
Bruce Momjian [Sat, 3 Feb 2001 21:50:45 +0000 (21:50 +0000)]
Re-add Peter E's changes.
Tom Lane [Sat, 3 Feb 2001 21:17:52 +0000 (21:17 +0000)]
Fix inappropriate attempt to push down qual clauses into a view that
has UNION/INTERSECT/EXCEPT operations. Per bug report from Ferrier.
Peter Eisentraut [Sat, 3 Feb 2001 20:13:05 +0000 (20:13 +0000)]
Use elog() instead of exit() for fatal scanner errors.
Peter Eisentraut [Sat, 3 Feb 2001 19:09:46 +0000 (19:09 +0000)]
Improved wording, from Albert REINER <areiner@tph.tuwien.ac.at>.
Peter Eisentraut [Sat, 3 Feb 2001 19:03:27 +0000 (19:03 +0000)]
Update, polish, consistencify preface/intro sections.
Bruce Momjian [Sat, 3 Feb 2001 04:13:22 +0000 (04:13 +0000)]
Change description.
Vadim B. Mikheev [Fri, 2 Feb 2001 19:49:15 +0000 (19:49 +0000)]
Runtime tree recovery is implemented, just testing is left -:)
Bruce Momjian [Fri, 2 Feb 2001 18:21:59 +0000 (18:21 +0000)]
Apply patches for QNX from Maurizio
Bruce Momjian [Thu, 1 Feb 2001 19:13:47 +0000 (19:13 +0000)]
A patch for the GROUP BY/HAVING example. p.date should be s.date.
Robert B. Easter
Bruce Momjian [Thu, 1 Feb 2001 18:31:10 +0000 (18:31 +0000)]
Please replace with the one attached to this email message. The
previous version depended on the below patch, this one does not. It is
also a bit cleaner and has a few more helpful comments.
Ryan Kirkpatrick
Michael Meskes [Wed, 31 Jan 2001 16:12:34 +0000 (16:12 +0000)]
Applied two bug fixes by Christof Petig.
Peter Mount [Wed, 31 Jan 2001 09:23:45 +0000 (09:23 +0000)]
Wed Jan 31 08:46:00 GMT 2001 peter@retep.org.uk
- Some minor additions to Statement to make our own extensions more
portable.
- Statement.close() will now call ResultSet.close() rather than just
dissasociating with it.
Peter Mount [Wed, 31 Jan 2001 08:26:02 +0000 (08:26 +0000)]
Tue Jan 30 22:24:00 GMT 2001 peter@retep.org.uk
- Fixed bug where Statement.setMaxRows() was a global setting. Now
limited to just itself.
- Changed LargeObject.read(byte[],int,int) to return the actual number
of bytes read (used to be void).
- LargeObject now supports InputStream's!
- PreparedStatement.setBinaryStream() now works!
- ResultSet.getBinaryStream() now returns an InputStream that doesn't
copy the blob into memory first!
- Connection.isClosed() now tests to see if the connection is still alive
rather than if it thinks it's alive.
Vadim B. Mikheev [Wed, 31 Jan 2001 01:08:36 +0000 (01:08 +0000)]
Couple additional functions to fix tree at runtime.
Need in one more function to handle "my bits moved..."
case. FixBTree is still FALSE.