OSDN Git Service
Bruce Momjian [Mon, 12 Oct 1998 02:01:41 +0000 (02:01 +0000)]
autoconf
Bruce Momjian [Mon, 12 Oct 1998 01:58:14 +0000 (01:58 +0000)]
Cleanup.
Bruce Momjian [Mon, 12 Oct 1998 01:30:26 +0000 (01:30 +0000)]
Fix for inet_net_pton() from Tom.
Bruce Momjian [Mon, 12 Oct 1998 01:23:29 +0000 (01:23 +0000)]
More Solaris fixes.
Bruce Momjian [Mon, 12 Oct 1998 01:10:09 +0000 (01:10 +0000)]
Add SVr4 shared libraries.
Bruce Momjian [Mon, 12 Oct 1998 01:04:02 +0000 (01:04 +0000)]
Solaris shared library fixes.
Bruce Momjian [Mon, 12 Oct 1998 00:53:42 +0000 (00:53 +0000)]
Fix for vacuum and cache use. Fix for BSDI 4.0.
Thomas G. Lockhart [Sat, 10 Oct 1998 17:13:47 +0000 (17:13 +0000)]
Add new "-n" flag to pg_dump.
Update UNLISTEN to not require double-quotes around the wildcard argument.
Clean up markup.
Thomas G. Lockhart [Sat, 10 Oct 1998 17:12:18 +0000 (17:12 +0000)]
Clean up markup.
Add new bibliographic references from Paul Aoki.
Include libpq++ docs from the old man page in the Programmer's Guide.
Update Unix installation info for ODBC.
Thomas G. Lockhart [Sat, 10 Oct 1998 17:08:11 +0000 (17:08 +0000)]
Move documentation to sgml sources, so remove man page installation.
Thomas G. Lockhart [Sat, 10 Oct 1998 17:07:16 +0000 (17:07 +0000)]
Move documentation to sgml sources.
Bruce Momjian [Sat, 10 Oct 1998 03:08:02 +0000 (03:08 +0000)]
shared library instructions.
Bruce Momjian [Fri, 9 Oct 1998 21:41:36 +0000 (21:41 +0000)]
New shared library mentions.
Bruce Momjian [Fri, 9 Oct 1998 21:31:34 +0000 (21:31 +0000)]
Reverse out vacuum change.
Bruce Momjian [Fri, 9 Oct 1998 21:28:50 +0000 (21:28 +0000)]
major/minor shared name cleanup
Bruce Momjian [Fri, 9 Oct 1998 19:53:10 +0000 (19:53 +0000)]
Recommend ldconfig on any ELF.
Bruce Momjian [Fri, 9 Oct 1998 17:34:57 +0000 (17:34 +0000)]
autoconf
Bruce Momjian [Fri, 9 Oct 1998 17:31:39 +0000 (17:31 +0000)]
configure cleanup
Bruce Momjian [Fri, 9 Oct 1998 16:59:43 +0000 (16:59 +0000)]
autoconf
Bruce Momjian [Fri, 9 Oct 1998 16:57:10 +0000 (16:57 +0000)]
There where a few more problems fixed by the patch below.
o configure.in
Jan.
Bruce Momjian [Fri, 9 Oct 1998 16:42:32 +0000 (16:42 +0000)]
Fix for version() string overwrite.
Thomas G. Lockhart [Fri, 9 Oct 1998 07:06:37 +0000 (07:06 +0000)]
Add wildcard asterisk to the UNLISTEN syntax.
Thomas G. Lockhart [Fri, 9 Oct 1998 07:04:53 +0000 (07:04 +0000)]
Changes to support standalone installation.
Thomas G. Lockhart [Fri, 9 Oct 1998 07:01:26 +0000 (07:01 +0000)]
Adjustments for standalone and integrated ODBC.
Bruce Momjian [Fri, 9 Oct 1998 04:50:12 +0000 (04:50 +0000)]
More bsdi 4.0 cleanups for shared libraries.
Bruce Momjian [Fri, 9 Oct 1998 04:22:49 +0000 (04:22 +0000)]
More bsdi 4.0 fixes.
Bruce Momjian [Fri, 9 Oct 1998 04:07:49 +0000 (04:07 +0000)]
Cleanup of distclean.
Bruce Momjian [Fri, 9 Oct 1998 03:08:00 +0000 (03:08 +0000)]
Fix for BSDI shared libraries.
Bruce Momjian [Fri, 9 Oct 1998 00:51:50 +0000 (00:51 +0000)]
Autoconf
Bruce Momjian [Fri, 9 Oct 1998 00:41:28 +0000 (00:41 +0000)]
Cleanup of pl files.
Tom Lane [Thu, 8 Oct 1998 23:50:28 +0000 (23:50 +0000)]
Clean up minor gcc warning about lack of reset_r_plans prototype.
Bruce Momjian [Thu, 8 Oct 1998 23:45:19 +0000 (23:45 +0000)]
I have had a few problems with the PL stuff recently committed. The
following patches fix the problems (i.e., all regression tests pass)
in what I hope to be a platform-independent fashion. The accomplish
the following:
Brook Milligan
Tom Lane [Thu, 8 Oct 1998 23:31:20 +0000 (23:31 +0000)]
Do not enable TCL_ARRAYS feature by default, because it
is wrong and dangerous unless you are using contrib/string. We really
need a thorough look at the issue of making the backend and the FE/BE
protocols completely 8-bit-clean for string data, but that's a task
for some future release.
Bruce Momjian [Thu, 8 Oct 1998 22:50:20 +0000 (22:50 +0000)]
Update to pgaccess 0.90.
Bruce Momjian [Thu, 8 Oct 1998 18:37:14 +0000 (18:37 +0000)]
No need compile command/version.c anymore.
Bruce Momjian [Thu, 8 Oct 1998 18:30:52 +0000 (18:30 +0000)]
Make functions static or ifdef NOT_USED. Prevent pg_version creation.
Tom Lane [Thu, 8 Oct 1998 03:23:03 +0000 (03:23 +0000)]
libpgtcl.sgml still needs work, but at least there are
fewer errors than there were.
Bruce Momjian [Thu, 8 Oct 1998 02:08:47 +0000 (02:08 +0000)]
Fix for INET type addition.
Tom Lane [Thu, 8 Oct 1998 01:28:58 +0000 (01:28 +0000)]
Grammar, my boy, grammar :-(
Tom Lane [Thu, 8 Oct 1998 01:16:18 +0000 (01:16 +0000)]
I'm too short of time to make these man pages look like the
newly-updated SGML reference pages, so I just inserted a comment that they
are obsolete. If you want to transcribe the newer info into these pages,
be my guest.
Tom Lane [Thu, 8 Oct 1998 01:10:28 +0000 (01:10 +0000)]
I continue my quest to eliminate documentation that claims
a listen/notify condition name is a class or table name, 'cause it ain't.
Bruce Momjian [Thu, 8 Oct 1998 00:41:36 +0000 (00:41 +0000)]
Add changelog.
Bruce Momjian [Thu, 8 Oct 1998 00:39:11 +0000 (00:39 +0000)]
remove unused file.
Bruce Momjian [Thu, 8 Oct 1998 00:38:21 +0000 (00:38 +0000)]
Just a quick patch. This makes the JDBC driver thread safe, which is an
important step towards making the driver compliant, and means that for
some Java applications and servlets, only a single database connection
is
needed, so in a sence this is a nice little show stopper for 6.4 (and
should still be backward compatible to 6.3.2).
Peter
Bruce Momjian [Thu, 8 Oct 1998 00:34:47 +0000 (00:34 +0000)]
Cleanup for snprintf for long long's.
Tom Lane [Thu, 8 Oct 1998 00:19:49 +0000 (00:19 +0000)]
Link unlisten.sgml into what I hope are the right places.
Bruce Momjian [Thu, 8 Oct 1998 00:19:47 +0000 (00:19 +0000)]
I agree. I think, though, that the best argument presented in the
debate was from Paul Vixie, who wanted INET to be the name covering
both IPV4 and IPV6. The following kit makes the needed changes:
Tom Ivar Helbekkmo
Tom Lane [Thu, 8 Oct 1998 00:19:13 +0000 (00:19 +0000)]
And some UNLISTEN doco too!
Tom Lane [Thu, 8 Oct 1998 00:18:31 +0000 (00:18 +0000)]
LISTEN/NOTIFY doc improvements.
Bruce Momjian [Thu, 8 Oct 1998 00:10:49 +0000 (00:10 +0000)]
Hello!
Here are two new patches for the Win32 support.
1) The patch based on the one from Hiroshi Inoue [Inoue@tpf.co.jp], to
load
Winsock.dll from libpq.dll.
2) A patch for psql.c to remove the call to WSAStartup(), since it is
not
required when it's done in libpq.dll.
I'm still looking for the possibility of having a crypt() function in
libpq.dll too, the same way getopt was included. Any chance of getting
this
before 6.4, or should we wait for the next one?
//Magnus
Bruce Momjian [Wed, 7 Oct 1998 22:31:50 +0000 (22:31 +0000)]
vacuum cleanups
Bruce Momjian [Wed, 7 Oct 1998 17:12:52 +0000 (17:12 +0000)]
Fix snprintf.c for machines that don't have long long, like some Irix.
Thomas G. Lockhart [Wed, 7 Oct 1998 06:50:37 +0000 (06:50 +0000)]
Use the $(LN_S) substitution for "ln -s" since configure tests for it.
Thomas G. Lockhart [Wed, 7 Oct 1998 06:49:22 +0000 (06:49 +0000)]
Clean up for configuration from the Postgres main configure script.
Use @top-srcdir@ to find the right Makefile.global and use ODBCSRCDIR
to point to this local directory.
Move non-platform-specific stuff to outside the if clauses.
Still need to move all platform-specific stuff to the templates.
Thomas G. Lockhart [Wed, 7 Oct 1998 06:41:40 +0000 (06:41 +0000)]
Add conditional compilation of the ODBC directory.
Requires --with-odbc specified in the standalone configure.
Thomas G. Lockhart [Wed, 7 Oct 1998 06:39:30 +0000 (06:39 +0000)]
Add a few items to support an integrated build of the ODBC interface.
Thomas G. Lockhart [Wed, 7 Oct 1998 06:38:29 +0000 (06:38 +0000)]
Separate out the lextest so that it is run by "make" and "make install".
Before, "make install" did not run the lextest.
Fix up the ODBC make from this main configure.
Include configure test for "ln -s" in Makefile.global.in.
Was always in configure, just not carried through to here for use.
Bruce Momjian [Wed, 7 Oct 1998 03:45:12 +0000 (03:45 +0000)]
make lock variable only used with fcntl
Bruce Momjian [Wed, 7 Oct 1998 02:49:10 +0000 (02:49 +0000)]
Update pg_dump sgml and manuals to remove rule restriction.
Bruce Momjian [Tue, 6 Oct 1998 22:14:21 +0000 (22:14 +0000)]
Playing around with pg_dump for a while resulted in some
fixes, enhancements and some found bugs not yet fixed. After
all I was able to get useful results when dumping/reloading
the regression database.
Jan
Tom Lane [Tue, 6 Oct 1998 14:22:12 +0000 (14:22 +0000)]
Took it on myself to change libpq's sharedlib version number from
1.1 to 2.0 for this release. The other frontend shlibs need version
number bumps too, but I think a minor version number change will do for them.
Tom Lane [Tue, 6 Oct 1998 14:16:50 +0000 (14:16 +0000)]
If we're going to offer a default definition of PQmblen,
it probably ought to actually work.
Tom Lane [Tue, 6 Oct 1998 14:05:02 +0000 (14:05 +0000)]
Re-apply fix stomped on by someone else's patch. Tsk, tsk.
Thomas G. Lockhart [Tue, 6 Oct 1998 05:58:41 +0000 (05:58 +0000)]
Update source code to Byron's v6.30.0250 sources plus minor cleanup
to get rid of unused variables.
Get clean compile on Linux (Thomas and Gerald).
Implement autoconf/configure for standalone builds and use the existing
autoconf/configure system when in the Postgres source tree.
Code tests and functions with ApplixWare-4.4.1beta on a Linux box.
Changes should be backward compatible with WIN32 but still needs testing.
Thomas G. Lockhart [Tue, 6 Oct 1998 05:44:05 +0000 (05:44 +0000)]
Install man pages from here now. "make install" will do that along with
the html/ps material...
Thomas G. Lockhart [Tue, 6 Oct 1998 05:42:58 +0000 (05:42 +0000)]
Try to configure interfaces/odbc using the --with-odbc switch.
Suppress installing man pages from here; do it from the doc/Makefile now.
Thomas G. Lockhart [Tue, 6 Oct 1998 05:35:42 +0000 (05:35 +0000)]
Forgot to initialize double quote option to be enabled.
Thomas G. Lockhart [Tue, 6 Oct 1998 05:05:48 +0000 (05:05 +0000)]
Add mention of the new "suppress double quotes" command line option "-n".
Bruce Momjian [Tue, 6 Oct 1998 03:55:43 +0000 (03:55 +0000)]
Fix for double free from Tatsuo Ishii
Bruce Momjian [Tue, 6 Oct 1998 03:12:59 +0000 (03:12 +0000)]
> > There is a bug in check_foreign_key of refint.c which is bundled with
> > the standard distribution. It occurs when a trigger calling this
> > function recursively fires another trigger which calls the same
> > function. The calling check_foreign_key loses its plan informantion and
> > when it tries to use it the backend closes its channel. You can check it
> > with the sql script I am attaching below.
> > The solution to this is to do a find_plan again before executing it at
> > line 483 of refint.c.
> > Therefore two more lines should be added before line 483:
Anand Surelia
Bruce Momjian [Tue, 6 Oct 1998 03:09:02 +0000 (03:09 +0000)]
Hi all
Is it too late to add a feature to pg_dump for 6.4??
I just spent most of the day learning pg_dump and modifing it so it
would
dump views also.
This is the first time I have ever contributed any code changes, so I'm
not sure of how to submit it.
The diff's and a readme as a tgz file are attached.
Thanks
Terry Mackintosh <terry@terrym.com> http://www.terrym.com
Bruce Momjian [Tue, 6 Oct 1998 03:02:29 +0000 (03:02 +0000)]
Here are the patches against the current source tree. I have run the
regression test on a FreeBSD box with both non-MULTIBYTE and
MULTIBYTE-enabled, and confirmed that the results are same.
However I do not tested on PCs(I don't have access to win). Please let
me know if the patches break anything on PCs.
Also please note that the patch for varchar.c is a fix for a nasty bug
of char(n) types that I introduced and I believe at least this should
be applied.
Tatsuo Ishii
Tom Lane [Tue, 6 Oct 1998 02:40:09 +0000 (02:40 +0000)]
Substantial rewrite of async.c to avoid problems with non-reentrant stdio
and possibly other problems. Minor changes in xact.c and postgres.c's
main loop to support new handling of async NOTIFY.
Tom Lane [Tue, 6 Oct 1998 02:32:28 +0000 (02:32 +0000)]
Add configure test to make sure fcntl(SETLK) is available.
Tom Lane [Tue, 6 Oct 1998 02:31:42 +0000 (02:31 +0000)]
Add configure test to make sure fcntl(SETLK) is available,
and make backend/libpq/pqcomm.c only try to lock the socket file when
the call exists. Also, change open-RDONLY to open-WRONLY; at least
on my platform, you can't get a write lock on a file you didn't open
for writing.
Tom Lane [Mon, 5 Oct 1998 04:11:47 +0000 (04:11 +0000)]
Many updates...
Thomas G. Lockhart [Mon, 5 Oct 1998 02:55:58 +0000 (02:55 +0000)]
Information is now in the chapter on syntax in the User's Guide.
Thomas G. Lockhart [Mon, 5 Oct 1998 02:54:45 +0000 (02:54 +0000)]
Add new information for utility commands.
Haven't yet done cleardbdir, ipcclean, pg_passwd, and pg_upgrade.
Add reference info for the SQL VACUUM command (oops, forgot it earlier).
Thomas G. Lockhart [Mon, 5 Oct 1998 02:51:21 +0000 (02:51 +0000)]
Properly interpret environment variables passed as the input location.
Thomas G. Lockhart [Mon, 5 Oct 1998 02:49:36 +0000 (02:49 +0000)]
Fix up warning and error messages to use single-quotes around strings.
Thomas G. Lockhart [Mon, 5 Oct 1998 02:48:49 +0000 (02:48 +0000)]
Fix up warning and error messages to use single-quotes aroun strings.
Tom Lane [Sun, 4 Oct 1998 22:48:42 +0000 (22:48 +0000)]
Add note explaining that NoticeResponse messages can
arrive even while idle.
Tom Lane [Sun, 4 Oct 1998 20:46:39 +0000 (20:46 +0000)]
Disable doubling of backslashes in PQprint, per discussion
on pgsql-interfaces a couple months ago.
Tom Lane [Sun, 4 Oct 1998 20:19:08 +0000 (20:19 +0000)]
hash.h's use of BSHIFT conflicts with <sys/param.h> on my
system. Finally got tired of looking at the compiler warning messages.
BSHIFT isn't all that useful, so I just took out the macro.
Tom Lane [Sun, 4 Oct 1998 18:28:10 +0000 (18:28 +0000)]
Our 'install-sh' script is BSD-style, therefore requires -c
to behave sanely. configure was not treating it as BSD...
Bruce Momjian [Sun, 4 Oct 1998 16:24:32 +0000 (16:24 +0000)]
Add includes for prototypes for new IP type.
Bruce Momjian [Sun, 4 Oct 1998 15:38:58 +0000 (15:38 +0000)]
Unixware patches from Billy G. Allie.
Bruce Momjian [Sun, 4 Oct 1998 15:35:12 +0000 (15:35 +0000)]
Add prototype include to inet types.
Bruce Momjian [Sun, 4 Oct 1998 15:31:09 +0000 (15:31 +0000)]
Remove u_int32_t
Bruce Momjian [Sun, 4 Oct 1998 03:30:56 +0000 (03:30 +0000)]
cnf'ify cleanup
Bruce Momjian [Sat, 3 Oct 1998 05:41:01 +0000 (05:41 +0000)]
Integrate new IP type from Tom Ivar Helbekkmo.
Thomas G. Lockhart [Sat, 3 Oct 1998 02:33:51 +0000 (02:33 +0000)]
Changes from Michael Meskes:
Check strdup calls for out of memory.
Set library version to 2.6.2
Synced preproc.y and keywords.c with gram.y and keywords.c yet again.
Set version to 2.4.3
Thomas G. Lockhart [Sat, 3 Oct 1998 02:30:47 +0000 (02:30 +0000)]
Update for newest changes.
Bruce Momjian [Fri, 2 Oct 1998 21:53:39 +0000 (21:53 +0000)]
Please apply the patch at the end. Disables use of system
columns of views at all (not only oid, cmin etc. too).
pgsql=> select cmin from pg_rules;
ERROR: system column cmin not available - pg_rules is a view
pgsql=> select * from pg_rules where pg_rules.oid = pg_class.oid;
ERROR: system column oid not available - pg_rules is a view
pgsql=>
Jan
Thomas G. Lockhart [Fri, 2 Oct 1998 16:46:34 +0000 (16:46 +0000)]
Obsolete information completely superceded by the sgml sources.
These weren't really "man page"-ish anyway, and I've verified that
all information in them has moved to the newer sources.
Thomas G. Lockhart [Fri, 2 Oct 1998 16:43:41 +0000 (16:43 +0000)]
Surround all identifiers with double quotes.
Formerly did so only for those which clearly required it, but that
would still miss things like reserved key words which also require it.
Implement the "-n" switch to revert the double quote behavior
to put DQs only where there is more than lower-case, digits,
and underscores.
Bruce Momjian [Fri, 2 Oct 1998 16:28:04 +0000 (16:28 +0000)]
Here's a combination of all the patches I'm currently waiting
for against a just updated CVS tree. It contains
Partial new rewrite system that handles subselects, view
aggregate columns, insert into select from view, updates
with set col = view-value and select rules restriction to
view definition.
Updates for rule/view backparsing utility functions to
handle subselects correct.
New system views pg_tables and pg_indexes (where you can
see the complete index definition in the latter one).
Enabling array references on query parameters.
Bugfix for functional index.
Little changes to system views pg_rules and pg_views.
The rule system isn't a release-stopper any longer.
But another stopper is that I don't know if the latest
changes to PL/pgSQL (not already in CVS) made it compile on
AIX. Still wait for some response from Dave.
Jan
Bruce Momjian [Fri, 2 Oct 1998 16:23:07 +0000 (16:23 +0000)]
the following little patch adds array references to query
parameters. With it applied a function like
CREATE FUNCTION getname(oid8, int4) RETURNS name AS
'SELECT typname FROM pg_type WHERE oid = $1[$2]'
LANGUAGE 'sql';
is possible. Mainly I need this to enable array references in
expressions for PL/pgSQL. Complete regression test ran O.K.
Jan
Bruce Momjian [Fri, 2 Oct 1998 16:18:20 +0000 (16:18 +0000)]
Summary
The ident() function in src/backend/libpq/hba.c doesn't cope when
postmaster is contacted on an IP alias. This patch fixes it.
Malcolm Beattie
Bruce Momjian [Fri, 2 Oct 1998 15:38:04 +0000 (15:38 +0000)]
Fixes for Irix from Robert Bruccoleri