OSDN Git Service
Philip Warner [Mon, 16 Oct 2000 03:34:47 +0000 (03:34 +0000)]
Added pg_restore to allfiles.sgml
Bruce Momjian [Mon, 16 Oct 2000 03:25:17 +0000 (03:25 +0000)]
Here is a patch against the same cvs tree as the SSL patch (Aug 20).
I hope I didn't mess the SGML up too bad, but somebody should definitly
look that over. I tried to steal as much as I could from around :-)
This patch updates:
* Installation instructions (paragraph on how to compile with openssl)
* Documentation of pg_hba.conf (added "hostssl" record docs)
* Libpq documentation (added connection option, documentation of
PQgetssl() function)
* Add section on SSL to "Server Runtime Environment"
If you beleive any particular area needs more attention, please let me know.
//Magnus
Marc G. Fournier [Mon, 16 Oct 2000 02:41:52 +0000 (02:41 +0000)]
author setting
Marc G. Fournier [Mon, 16 Oct 2000 02:41:23 +0000 (02:41 +0000)]
again
Marc G. Fournier [Mon, 16 Oct 2000 02:40:58 +0000 (02:40 +0000)]
again ...
Marc G. Fournier [Mon, 16 Oct 2000 02:40:13 +0000 (02:40 +0000)]
test again
Marc G. Fournier [Mon, 16 Oct 2000 02:30:37 +0000 (02:30 +0000)]
let's see if this gets the 'committer' into the email now ...
Bruce Momjian [Mon, 16 Oct 2000 02:20:58 +0000 (02:20 +0000)]
Change jdbc docs from postgresql.Driver to org.postgresql.Driver.
Marc G. Fournier [Mon, 16 Oct 2000 02:08:22 +0000 (02:08 +0000)]
testing ...
Bruce Momjian [Sun, 15 Oct 2000 21:52:48 +0000 (21:52 +0000)]
Update TODO list.
Bruce Momjian [Sun, 15 Oct 2000 21:50:49 +0000 (21:50 +0000)]
Update TODO list.
Bruce Momjian [Sun, 15 Oct 2000 21:45:30 +0000 (21:45 +0000)]
Update TODO list.
Bruce Momjian [Sun, 15 Oct 2000 18:53:25 +0000 (18:53 +0000)]
Update TODO list.
Philip Warner [Sun, 15 Oct 2000 00:34:54 +0000 (00:34 +0000)]
Fix prototype declaration based on patch from David Reid
Bruce Momjian [Sat, 14 Oct 2000 23:59:12 +0000 (23:59 +0000)]
autoconf
Bruce Momjian [Sat, 14 Oct 2000 23:57:46 +0000 (23:57 +0000)]
This fixes a small problem with identifying -lbind as required for
BeOS.
David Reid
Bruce Momjian [Sat, 14 Oct 2000 23:56:59 +0000 (23:56 +0000)]
The configure script fails to find <netinet/tcp.h>.
As a result, backend/libpq/pqcomm.c and interfaces/libpq/fe-connect.c
fail to compile.
The <netinet/tcp.h> header needs to be preceded by <netinet/in.h>, at
least on IRIX, Solaris and AIX. The simple configure test fails.
(That header on Linux is idempotent.)
The basic problem is that <netinet/tcp.h> is a BSD header. The
correct header for TCP internals such as TCP_NODELAY on a UNIX system
is <xti.h>. By UNIX I mean UNIX95 (aka XPG4v2 or SUSv1) or later.
The current UNIX standard (UNIX98 aka SUSv2) is available online at
<http://www.opengroup.org/onlinepubs/
7908799/>.
The fix is to add header support for <xti.h> into configure.in and
config.h.in.
The 2 files which conditionally include <netinet/tcp.h> need also to
conditionally include <xti.h>.
Pete Forman
Bruce Momjian [Sat, 14 Oct 2000 23:55:58 +0000 (23:55 +0000)]
Here is a patch for resultmap and the results file.
I have counted 9 differences in the least significant digit compared
with geometry-positive-zeros.out. It would be wise for someone else
to double check.
Pete Forman
Bruce Momjian [Sat, 14 Oct 2000 21:56:03 +0000 (21:56 +0000)]
Update TODO list.
Marc G. Fournier [Sat, 14 Oct 2000 21:53:06 +0000 (21:53 +0000)]
gain
Marc G. Fournier [Sat, 14 Oct 2000 21:49:49 +0000 (21:49 +0000)]
testing committers list ...
Bruce Momjian [Sat, 14 Oct 2000 04:29:47 +0000 (04:29 +0000)]
Update detail for new todo items.
Bruce Momjian [Sat, 14 Oct 2000 04:22:14 +0000 (04:22 +0000)]
Update TODO list.
Bruce Momjian [Sat, 14 Oct 2000 04:19:27 +0000 (04:19 +0000)]
Update TODO list.
Vadim B. Mikheev [Fri, 13 Oct 2000 12:06:40 +0000 (12:06 +0000)]
Various utils for WAL
Vadim B. Mikheev [Fri, 13 Oct 2000 12:05:22 +0000 (12:05 +0000)]
WAL
Philip Warner [Fri, 13 Oct 2000 03:11:06 +0000 (03:11 +0000)]
Minor buglet in dumping functions onlt
Vadim B. Mikheev [Fri, 13 Oct 2000 02:03:02 +0000 (02:03 +0000)]
WAL
Bruce Momjian [Fri, 13 Oct 2000 01:54:40 +0000 (01:54 +0000)]
Update TODO list.
Philip Warner [Fri, 13 Oct 2000 00:43:31 +0000 (00:43 +0000)]
Fix bug in sequence dumping using new setval function
Philip Warner [Fri, 13 Oct 2000 00:33:47 +0000 (00:33 +0000)]
Make setval(text,int32,bool) visible
Bruce Momjian [Thu, 12 Oct 2000 22:16:58 +0000 (22:16 +0000)]
Fix typo
Bruce Momjian [Thu, 12 Oct 2000 22:08:42 +0000 (22:08 +0000)]
Fix typo.
Bruce Momjian [Thu, 12 Oct 2000 21:23:34 +0000 (21:23 +0000)]
Fix typo
Bruce Momjian [Thu, 12 Oct 2000 21:21:29 +0000 (21:21 +0000)]
Update FAQ.
Bruce Momjian [Thu, 12 Oct 2000 20:26:11 +0000 (20:26 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 20:23:44 +0000 (20:23 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 19:00:02 +0000 (19:00 +0000)]
Update TODO.detail.
Bruce Momjian [Thu, 12 Oct 2000 18:59:26 +0000 (18:59 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 18:59:10 +0000 (18:59 +0000)]
Update TODO list.
Michael Meskes [Thu, 12 Oct 2000 18:25:36 +0000 (18:25 +0000)]
Replace constants by C variables wherever possible.
Bruce Momjian [Thu, 12 Oct 2000 17:33:35 +0000 (17:33 +0000)]
Update FAQ.
Bruce Momjian [Thu, 12 Oct 2000 17:33:22 +0000 (17:33 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 17:32:40 +0000 (17:32 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 15:43:51 +0000 (15:43 +0000)]
Update TODO list.
Philip Warner [Thu, 12 Oct 2000 14:09:37 +0000 (14:09 +0000)]
First pass at docs for pg_restore
Peter Mount [Thu, 12 Oct 2000 08:55:28 +0000 (08:55 +0000)]
Major update part I involving delayed patches, reworked Makefile, and how
the versioning works. There's also a new utils directory used by Makefile
Tatsuo Ishii [Thu, 12 Oct 2000 07:38:13 +0000 (07:38 +0000)]
Add more files from backend
Tatsuo Ishii [Thu, 12 Oct 2000 07:36:51 +0000 (07:36 +0000)]
Disable elog when linked with frontend.
Tatsuo Ishii [Thu, 12 Oct 2000 06:08:28 +0000 (06:08 +0000)]
Support for automatic code conversion between UNICODE and other
encodings
Tatsuo Ishii [Thu, 12 Oct 2000 06:06:50 +0000 (06:06 +0000)]
Support for conversion between UNICODE and other encodings
currently ISO8859-[1-5] and EUC_JP are supported.
support for other encodings will be coming soon.
Bruce Momjian [Thu, 12 Oct 2000 04:24:24 +0000 (04:24 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 03:12:41 +0000 (03:12 +0000)]
Update FAQ.
Bruce Momjian [Thu, 12 Oct 2000 03:04:44 +0000 (03:04 +0000)]
Update TODO list.
Bruce Momjian [Thu, 12 Oct 2000 01:23:37 +0000 (01:23 +0000)]
Update TODO for LIKE/ESCAPE.
Bruce Momjian [Thu, 12 Oct 2000 01:22:39 +0000 (01:22 +0000)]
Update TODO list.
Bruce Momjian [Wed, 11 Oct 2000 21:28:19 +0000 (21:28 +0000)]
Fix temp relation handling for indexes, cleanup
Bruce Momjian [Wed, 11 Oct 2000 19:19:51 +0000 (19:19 +0000)]
autoconf
Tom Lane [Wed, 11 Oct 2000 18:29:52 +0000 (18:29 +0000)]
Correct error in description of AccessExclusiveLock mode
(failed to say that it conflicts with AccessShareLock).
Bruce Momjian [Wed, 11 Oct 2000 18:09:38 +0000 (18:09 +0000)]
Add pooling discussion.
Bruce Momjian [Wed, 11 Oct 2000 17:58:01 +0000 (17:58 +0000)]
Oops, back out my unintended changes.
Bruce Momjian [Wed, 11 Oct 2000 17:55:34 +0000 (17:55 +0000)]
Update make_mkid
Tom Lane [Wed, 11 Oct 2000 17:38:36 +0000 (17:38 +0000)]
Improve MVCC discussion.
Philip Warner [Wed, 11 Oct 2000 15:31:34 +0000 (15:31 +0000)]
Added new SQL function setval(seq,val,bool) to restore is_called as well as value
(will be used in a future pg_dump).
Michael Meskes [Wed, 11 Oct 2000 14:56:37 +0000 (14:56 +0000)]
Synced preproc.y with gram.y
Bruce Momjian [Wed, 11 Oct 2000 01:24:01 +0000 (01:24 +0000)]
pg_hba.conf mention fix.
Bruce Momjian [Tue, 10 Oct 2000 22:03:31 +0000 (22:03 +0000)]
More pg_config updates.
Bruce Momjian [Tue, 10 Oct 2000 22:01:55 +0000 (22:01 +0000)]
Rename pg-config to pg_config to be consistent with other pg commands.
Peter Eisentraut [Tue, 10 Oct 2000 21:22:29 +0000 (21:22 +0000)]
Unify solaris_i386 and solaris_sparc templates. They were almost identical
anyway, the rest being due to them not being kept in sync. Add configure
test for lorder and use it (on Solaris) when found.
Peter Eisentraut [Tue, 10 Oct 2000 21:08:04 +0000 (21:08 +0000)]
Some dynloader files missed the template rename a while back.
Bruce Momjian [Tue, 10 Oct 2000 17:13:30 +0000 (17:13 +0000)]
This is a stupid garden variety bug and I'm not sure why I didn't catch
it previously. The patch included is against fairly current sources, but
it may apply cleanly against 7.0.2 as well.
On Fri, 6 Oct 2000, Vilson farias wrote:
> I found a irregular behavior with constraints.
>
> I can only set a referencial integrity between these tables when there are
> no data, even if there are no change to referential integrity violation.
Philip Warner [Tue, 10 Oct 2000 13:55:28 +0000 (13:55 +0000)]
- Be more paranoid when getting views
- Support for 'isstrict' procedure attribute.
- Disable --blobs and --table
(replaced prior to attempting to fix sequence dump problems)
Bruce Momjian [Tue, 10 Oct 2000 13:04:46 +0000 (13:04 +0000)]
Remove override of CFLAGS.
Bruce Momjian [Tue, 10 Oct 2000 04:42:43 +0000 (04:42 +0000)]
Add spaces to manual page.
Bruce Momjian [Mon, 9 Oct 2000 20:21:01 +0000 (20:21 +0000)]
Update FAQ.
Bruce Momjian [Mon, 9 Oct 2000 19:41:27 +0000 (19:41 +0000)]
Update TODO list.
Bruce Momjian [Mon, 9 Oct 2000 16:48:19 +0000 (16:48 +0000)]
Back out Gunnar R|nning jdbc changes.
Peter Eisentraut [Mon, 9 Oct 2000 16:42:55 +0000 (16:42 +0000)]
Cosmetic cleanups of Beos port
Bruce Momjian [Mon, 9 Oct 2000 07:38:53 +0000 (07:38 +0000)]
Update FAQ.
Bruce Momjian [Mon, 9 Oct 2000 07:38:35 +0000 (07:38 +0000)]
Update TODO list.
Bruce Momjian [Mon, 9 Oct 2000 03:49:42 +0000 (03:49 +0000)]
I have compiled and tested PostgreSQL 7.1devel on UnixWare 7.1. During the
process, the need for changes to the FAQ_SCO document was uncovered. The
attach patch file implements thost changes.
Billy G. Allie
Peter Eisentraut [Sun, 8 Oct 2000 21:13:27 +0000 (21:13 +0000)]
Append "/postgresql" to (certain) installation subdirectories when
installing into a shared location. Also Makefile.global organizational
cleanup.
Bruce Momjian [Sun, 8 Oct 2000 19:44:01 +0000 (19:44 +0000)]
initlocation must set env before postmaster start.
Bruce Momjian [Sun, 8 Oct 2000 19:37:56 +0000 (19:37 +0000)]
Okay, I have some new code in place that hopefully should work better. I
couldn't produce a full patch using cvs diff -c this time since I have
created new files and anonymous cvs usage doesn't allow you to
adds. I'm supplying the modified src/interfaces/jdbc as a tarball at :
http://www.candleweb.no/~gunnar/projects/pgsql/postgres-jdbc-2000-10-05.tgz
The new files that should be added are :
? org/postgresql/PGStatement.java
? org/postgresql/ObjectPool.java
? org/postgresql/ObjectPoolFactory.java
There is now a global static pool of free byte arrays and used byte arrays
connected to a statement object. This is the role of the new PGStatement
class. Access to the global free array is synchronized, while we rely on
the PG_Stream synchronization for the used array.
My measurements show that the perfomance boost on this code is not quite as
big as my last shot, but it is still an improvement. Maybe some of the
difference is due to the new synchronization on the global array. I think I
will look into choosing between on a connection level and global level.
I have also started experimented with improving the performance of the
various conversions. The problem here is ofcourse related handle the
various encodings. One thing I found to speed up ResultSet.getInt() a lot
was to do custom conversion on the byte array into int instead of going
through the getString() to do the conversion. But I'm unsure if this is
portable, can we assume that a digit never can be represented by more than
one byte ? It works fine in my iso-latin-8859-1 environment, but what about
other environments ? Maybe we could provide different ResultSet
implementations depending on the encoding used or delegate some methods of
the result set to an "converter class".
Check the org/postgresql/jdbc2/FastResultSet.java in the tarball above to
see the modified getInt() method.
Regards,
Gunnar
Bruce Momjian [Sun, 8 Oct 2000 13:52:22 +0000 (13:52 +0000)]
autoconf
Bruce Momjian [Sun, 8 Oct 2000 13:49:47 +0000 (13:49 +0000)]
This removes the LDFLAGS from the template and adds an autoconf check
for the library. not sure if this will cause problems on other
platforms, but if it does it can be easily fixed. Also remove the
references to the GeekGadgets includes as the majority of users don't
have them installed and they foul the build process. We can document
that adding them if you have them installed is a good idea.
David Reid
Peter Eisentraut [Sun, 8 Oct 2000 13:25:11 +0000 (13:25 +0000)]
These aren't used anymore.
Peter Eisentraut [Sun, 8 Oct 2000 13:24:09 +0000 (13:24 +0000)]
Split out Developer's from Programmer's guide.
Peter Eisentraut [Sun, 8 Oct 2000 13:22:24 +0000 (13:22 +0000)]
markup repair
Tatsuo Ishii [Sun, 8 Oct 2000 09:25:38 +0000 (09:25 +0000)]
Add runtime configuration option "silent_mode".
This is equivalent to postmaster's -S option.
Bruce Momjian [Sun, 8 Oct 2000 04:38:21 +0000 (04:38 +0000)]
Tom Lane wrote:
> > For a while I though it might be because we are using an alpha TAS in
> > the spinlock rather than the old semaphore. I replaced our spinlock
> > with the standard one and it made no difference. We have been running
> > with our spinlock implementation for nearly 2 months on a production
> > database now without a hitch, so I think it is ok. Did I ever submit
> > any patches for the Alpha spinlock?
>
> Not that I recall. We did get some advice from some Alpha gurus at DEC
> who seemed to think the existing TAS code is OK. What was it that you
> felt needed to be improved?
The current code uses semaphores, which has the advantage that it works
well even on multi-processor machines, but the disadvantage that it is not
the fastest way possible. Writing a spinlock on Alpha for SMP machines is
very difficult, as you need to deal with memory barriers. A real mess. But
then one of the people at Compaq pointed out to us that there is a
ready-made routine on Alpha. We implemented it with the two patches below.
I ran tests with lots of parallel back-ends and got around a 10% speed
increase. I include the two patches. Perhaps some of the other people
running Tru64 can have a look at these as well.
Cheers,
Adriaan Joubert
Bruce Momjian [Sun, 8 Oct 2000 03:53:15 +0000 (03:53 +0000)]
Back out:
> this is patch v 0.4 to support transactions with BLOBs.
> All BLOBs are in one table. You need to make initdb.
>
> --
> Sincerely Yours,
> Denis Perchine
Bruce Momjian [Sun, 8 Oct 2000 03:18:57 +0000 (03:18 +0000)]
Hello,
this is patch v 0.4 to support transactions with BLOBs.
All BLOBs are in one table. You need to make initdb.
--
Sincerely Yours,
Denis Perchine
Tom Lane [Sun, 8 Oct 2000 02:51:50 +0000 (02:51 +0000)]
Revert rules.out to non-broken state. I will with difficulty hold my
tongue about the sloppiness of (a) submitting and (b) committing this
file.
Bruce Momjian [Sat, 7 Oct 2000 22:14:09 +0000 (22:14 +0000)]
Remove S-Tree_indexes.html.gz
Peter Eisentraut [Sat, 7 Oct 2000 20:23:03 +0000 (20:23 +0000)]
To create a temporary installation, the regression test driver should use
the make program that was used to build itself. This seems more correct
than guessing around for some gmake.
Bruce Momjian [Sat, 7 Oct 2000 19:48:27 +0000 (19:48 +0000)]
Thanks for the patch
It builds and run nicely now
it seem that the resultmap file have not been updated.
Cyril VELTER
Peter Eisentraut [Sat, 7 Oct 2000 18:59:12 +0000 (18:59 +0000)]
Remove stuff that shouldn't be here.
Peter Eisentraut [Sat, 7 Oct 2000 18:43:23 +0000 (18:43 +0000)]
Separate -Wl,-E or equivalent into separate make variable, since it's only
necessary for the postgres/postmaster link, not every link.
Bruce Momjian [Sat, 7 Oct 2000 14:57:17 +0000 (14:57 +0000)]
autoconf