Marc G. Fournier [Tue, 13 Oct 1998 14:12:22 +0000 (14:12 +0000)]
Remove the -soname ${SHLIB} from solaris_{sparc,x86} as they conflict
with the -o $@ used in the ${SHLIB} directive, causing a failure for
*at least* gcc2.8.1 + Solaris 2.6 under both hardware platforms...
Bruce Momjian [Mon, 12 Oct 1998 02:45:45 +0000 (02:45 +0000)]
This patch updates the ImageViewer example to use Multiple Threading.
When importing an image into the database, the example now fires off a
new
Thread, which imports the image in the background. This also means that
the application doesn't freeze on the user, and they can still browse
the
images in the database, while the upload is running.
This now makes the ImageViewer a true example on how to use Threads (the
threadtest class is just that - a test).
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.
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:
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.
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.
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).
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:
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?
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.
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 [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.
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.
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.
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:
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.
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: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.
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).