OSDN Git Service
Bruce Momjian [Sun, 12 Jul 1998 04:49:47 +0000 (04:49 +0000)]
add mention of DISTINCT ON attrN
Bruce Momjian [Sun, 12 Jul 1998 04:43:28 +0000 (04:43 +0000)]
Reverse out unused patch.
Bruce Momjian [Sun, 12 Jul 1998 04:37:55 +0000 (04:37 +0000)]
Print relation name before vacuum, results after vacuum.
Thomas G. Lockhart [Sat, 11 Jul 1998 12:46:20 +0000 (12:46 +0000)]
Moved to select_implicit.out.
Bruce Momjian [Thu, 9 Jul 1998 17:59:49 +0000 (17:59 +0000)]
change <CODE> to <I>.
Bruce Momjian [Thu, 9 Jul 1998 15:45:00 +0000 (15:45 +0000)]
update
Bruce Momjian [Thu, 9 Jul 1998 14:59:27 +0000 (14:59 +0000)]
Fix for views that use AS with two words.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:36:51 +0000 (14:36 +0000)]
Update regression test run times for v6.4beta.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:35:52 +0000 (14:35 +0000)]
Fix typos. Refer to "open source" rather than "freeware".
Thomas G. Lockhart [Thu, 9 Jul 1998 14:34:05 +0000 (14:34 +0000)]
Handle case of GROUP BY target list column number out of range.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:32:58 +0000 (14:32 +0000)]
"select_implicit" is renamed from "junkfilter" test.
Move from last test in list up to other "select_xxx" tests.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:32:14 +0000 (14:32 +0000)]
Renamed from "junkfilter" test.
Marc G. Fournier [Thu, 9 Jul 1998 03:35:39 +0000 (03:35 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>
I see someone missed an ancient bit of shell-scripting lore:
on some older shells, if your script's argument list is empty,
then "$@" generates an empty-string word rather than no word
at all. You need to write ${1+"$@"} to get the latter behavior.
(Read your shell man page to see exactly how that works,
but it does the Right Thing on every Bourne shell.)
In particular, pg_dumpall fails when invoked without any switches
on HPUX 9.*, because pg_dump gets an empty-string argument that it
thinks is the name of the database to dump. I expect this bug
also affects some other OSes, but couldn't tell you just which ones.
Patch attached.
Marc G. Fournier [Thu, 9 Jul 1998 03:32:10 +0000 (03:32 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>
The attached patches respond to discussion that was on pgsql-hackers
around the beginning of June (see thread "libpgtcl bug (and symptomatic
treatment)"). The changes are:
1. Remove code in connectDB that throws away the password after making
a connection. This doesn't really add much security IMHO --- a bad guy
with access to your client's address space can likely extract the
password anyway, to say nothing of what he might do directly. And
there's the serious shortcoming that it prevents PQreset() from working
if the database requires a password.
2. Fix coredump problem: fe_sendauth did not guard against being handed
a NULL password pointer. (This is the proximate cause of the coredump-
during-PQreset problem that Magosanyi Arpad complained of last month.)
3. Remove highly questionable "error recovery" logic in libpgtcl's
pg_exec statement.
I believe the consensus of the discussion last month was in favor of
#1 and #3, but I'm just now getting around to making the change.
I realized that #2 was a bug in process of looking at the change.
Marc G. Fournier [Thu, 9 Jul 1998 03:30:49 +0000 (03:30 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>
Attached are diffs (from current cvs sources) to bring libpq.sgml
and libpq.3 up to date.
It appears that at various times in the past, people have made edits to
one or the other of these files but not both. I propagated some changes
from each into the other, but I don't think I caught every
inconsistency. It'd be real nice if the man pages could be
automatically generated from the SGML...
Marc G. Fournier [Thu, 9 Jul 1998 03:29:11 +0000 (03:29 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>
Making PQrequestCancel safe to call in a signal handler turned out to be
much easier than I feared. So here are the diffs.
Some notes:
* I modified the postmaster's packet "iodone" callback interface to allow
the callback routine to return a continue-or-drop-connection return
code; this was necessary to allow the connection to be closed after
receiving a Cancel, rather than proceeding to launch a new backend...
Being a neatnik, I also made the iodone proc have a typechecked
parameter list.
* I deleted all code I could find that had to do with OOB.
* I made some edits to ensure that all signals mentioned in the code
are referred to symbolically not by numbers ("SIGUSR2" not "2").
I think Bruce may have already done at least some of the same edits;
I hope that merging these patches is not too painful.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:33:19 +0000 (14:33 +0000)]
Surround table and column names with double-quotes
in generated SQL code to preserve case (SQL92 syntax).
Thomas G. Lockhart [Wed, 8 Jul 1998 14:31:02 +0000 (14:31 +0000)]
Include tests for new 8-byte integer.
Include tests for HAVING clause.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:30:21 +0000 (14:30 +0000)]
Include int8_tbl from tests for new 8-byte integer.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:29:09 +0000 (14:29 +0000)]
Include tests for new 8-byte integer (minimal).
Include tests for HAVING clause.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:18:45 +0000 (14:18 +0000)]
Include int8 as a built-in data type.
Merge "resjunk" handling with automatic type conversion
when selecting from another column.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:10:30 +0000 (14:10 +0000)]
Add int8 8-byte integer type.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:09:00 +0000 (14:09 +0000)]
Add int8 type for 8-byte integers.
Fix OID conflict between "line()" and "version()" by changing version OID.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:04:11 +0000 (14:04 +0000)]
Allow floating point constants for "def_arg" numeric arguments.
Used in the generic "CREATE xxx" parsing.
Do some automatic type conversion for inserts from other columns.
Previous trouble with "resjunk" regression test remains for now.
Thomas G. Lockhart [Wed, 8 Jul 1998 13:57:05 +0000 (13:57 +0000)]
Include 8-byte integer type.
At the moment, probably only works for i686/gcc and Alphas...
Thomas G. Lockhart [Wed, 8 Jul 1998 13:54:26 +0000 (13:54 +0000)]
Fix suggestions on file protection for alternate DB locations.
Thomas G. Lockhart [Wed, 8 Jul 1998 13:53:15 +0000 (13:53 +0000)]
Split function and operator User Guide info
from datatype.sgml into separate files.
Add type conversion information.
Format historical release notes.
Bruce Momjian [Tue, 7 Jul 1998 22:00:31 +0000 (22:00 +0000)]
Rename signal to SIGHUP.
Marc G. Fournier [Tue, 7 Jul 1998 18:00:09 +0000 (18:00 +0000)]
From: "Dr. Michael Meskes" <meskes@online-club.de>
My first try at libpq. This one enables the two styles we agreed upon for
database descriptors.
Marc G. Fournier [Tue, 7 Jul 1998 17:59:32 +0000 (17:59 +0000)]
From: "Dr. Michael Meskes" <meskes@online-club.de>
+ Thu Jul 2 20:30:14 CEST 1998
+
+ - Changed new style db name to allow connection types "tcp" and
+ "unix" only
+
+ Tue Jul 7 15:14:14 CEST 1998
+
+ - Fixed some bugs in preproc.y
+ - Set version to 2.3.4
Bruce Momjian [Mon, 6 Jul 1998 20:28:09 +0000 (20:28 +0000)]
Patches HPUX applied for Tom Lane.
Bruce Momjian [Mon, 6 Jul 1998 18:16:07 +0000 (18:16 +0000)]
Update lock manager README.
Bruce Momjian [Sat, 4 Jul 1998 17:50:04 +0000 (17:50 +0000)]
Add PQsetdbLogin() and cleanup.
Bruce Momjian [Fri, 3 Jul 1998 19:30:40 +0000 (19:30 +0000)]
Update layout
Bruce Momjian [Fri, 3 Jul 1998 19:17:22 +0000 (19:17 +0000)]
Update flow chart
Bruce Momjian [Fri, 3 Jul 1998 04:29:04 +0000 (04:29 +0000)]
win32 cleanup
Bruce Momjian [Fri, 3 Jul 1998 04:24:16 +0000 (04:24 +0000)]
Hello!
Through some minor changes, I have been able to compile the libpq
client libraries on the Win32 platform. Since the libpq communications
part has been rewritten, this has become much easier. Enclosed is
a patch that will allow at least Microsoft Visual C++ to compile
libpq into both a static and a dynamic library. I will take a look
at porting the psql frontend as well, but I figured it was a good
idea to send in these patches first - so no major changes are done
to the files before it gets applied (if it does).
Regards,
Magnus Hagander
Bruce Momjian [Tue, 30 Jun 1998 19:09:57 +0000 (19:09 +0000)]
Rename shared memory area.
Bruce Momjian [Tue, 30 Jun 1998 04:35:34 +0000 (04:35 +0000)]
update
Bruce Momjian [Tue, 30 Jun 1998 02:33:34 +0000 (02:33 +0000)]
Rename locking structure names to be clearer. Add narrative to
backend flowchart.
Bruce Momjian [Sun, 28 Jun 1998 21:17:36 +0000 (21:17 +0000)]
Rename lockt to locktype and rename LOCKT to LOCKTYPE.
Bruce Momjian [Sun, 28 Jun 1998 18:59:26 +0000 (18:59 +0000)]
update
Bruce Momjian [Sun, 28 Jun 1998 16:35:41 +0000 (16:35 +0000)]
backend update.
Bruce Momjian [Sun, 28 Jun 1998 15:00:28 +0000 (15:00 +0000)]
Update flowchart and backend descriptions.
Bruce Momjian [Sun, 28 Jun 1998 06:17:14 +0000 (06:17 +0000)]
Update backend flowchart.
Bruce Momjian [Sat, 27 Jun 1998 15:47:48 +0000 (15:47 +0000)]
Rename BindingTable to ShmemIndex.
Bruce Momjian [Sat, 27 Jun 1998 14:06:41 +0000 (14:06 +0000)]
More cleanups for compiler warnings.
Bruce Momjian [Sat, 27 Jun 1998 13:24:21 +0000 (13:24 +0000)]
Rename proc_exit_clear to on_exit_reset.
Bruce Momjian [Sat, 27 Jun 1998 04:53:49 +0000 (04:53 +0000)]
Fix for hang after postmaster restart. Add new proc_exit and
shmem_exit to replace exitpg().
Bruce Momjian [Fri, 26 Jun 1998 19:57:50 +0000 (19:57 +0000)]
Rename Lockm to Locks.
Bruce Momjian [Fri, 26 Jun 1998 01:58:46 +0000 (01:58 +0000)]
Rename LockTab to LockTable in function name.
Bruce Momjian [Thu, 25 Jun 1998 14:24:35 +0000 (14:24 +0000)]
Rename BindingTab to BindingTable.
Bruce Momjian [Wed, 24 Jun 1998 13:21:30 +0000 (13:21 +0000)]
cleanup
Bruce Momjian [Wed, 24 Jun 1998 13:05:01 +0000 (13:05 +0000)]
regenerate manual page list.
Bruce Momjian [Wed, 24 Jun 1998 13:01:26 +0000 (13:01 +0000)]
manual cleanup
Bruce Momjian [Wed, 24 Jun 1998 12:52:47 +0000 (12:52 +0000)]
Add another underscore to manual page name.
Bruce Momjian [Tue, 23 Jun 1998 17:59:54 +0000 (17:59 +0000)]
Back out some changes I made just for testing.
Bruce Momjian [Tue, 23 Jun 1998 17:52:38 +0000 (17:52 +0000)]
Add underscores in manual references.
Bruce Momjian [Tue, 23 Jun 1998 16:04:46 +0000 (16:04 +0000)]
cleanups
Bruce Momjian [Tue, 23 Jun 1998 15:43:19 +0000 (15:43 +0000)]
Remove mention of monitor in manual pages.
Bruce Momjian [Tue, 23 Jun 1998 15:35:48 +0000 (15:35 +0000)]
rename MAIN_MEMORY to STABLE_MEMORY_STORAGE
Bruce Momjian [Mon, 22 Jun 1998 02:04:29 +0000 (02:04 +0000)]
new linux_ppc port.
Bruce Momjian [Sun, 21 Jun 1998 16:39:11 +0000 (16:39 +0000)]
Remove un-needed include files.
Bruce Momjian [Sat, 20 Jun 1998 04:34:31 +0000 (04:34 +0000)]
Fixup for asserts.
Bruce Momjian [Sat, 20 Jun 1998 02:49:38 +0000 (02:49 +0000)]
Remove -c option for Constraint syntax so we us it by default.
Marc G. Fournier [Fri, 19 Jun 1998 11:40:46 +0000 (11:40 +0000)]
From: t-ishii@sra.co.jp
As mentioned around line 1153 in backend/commands/copy.c, the method
of array checking is not perfect.
test=> create table t1 (i text);
test=> insert into t1 values('{\\.}');
INSERT
2645600 1
test=> select * from t1;
i
-----
{\\.}
(2 rows)
test=> copy t1 to '/tmp/aaa';
test=> copy t1 from '/tmp/aaa';
ERROR: CopyReadAttribute - end of record marker corrupted
Copy cannot read data produced by itself!
Bruce Momjian [Fri, 19 Jun 1998 03:23:41 +0000 (03:23 +0000)]
Port name cleanup
Bruce Momjian [Fri, 19 Jun 1998 02:55:19 +0000 (02:55 +0000)]
Solaris cleanup.
Bruce Momjian [Thu, 18 Jun 1998 16:38:59 +0000 (16:38 +0000)]
autocoinf
Bruce Momjian [Thu, 18 Jun 1998 16:35:38 +0000 (16:35 +0000)]
Add SLEEP_ON_ABORT
Bruce Momjian [Thu, 18 Jun 1998 16:32:51 +0000 (16:32 +0000)]
port name cleanup
Bruce Momjian [Thu, 18 Jun 1998 04:29:53 +0000 (04:29 +0000)]
Update .similar file for new template names.
Bruce Momjian [Thu, 18 Jun 1998 04:20:34 +0000 (04:20 +0000)]
Add Assert().
Bruce Momjian [Thu, 18 Jun 1998 03:56:08 +0000 (03:56 +0000)]
Cleanup UsePrivateMemory define.
Bruce Momjian [Thu, 18 Jun 1998 03:44:00 +0000 (03:44 +0000)]
Cleanups.
Bruce Momjian [Wed, 17 Jun 1998 23:01:58 +0000 (23:01 +0000)]
goodbye vfork.
Bruce Momjian [Wed, 17 Jun 1998 22:59:26 +0000 (22:59 +0000)]
cleanup
Byron Nikolaidis [Tue, 16 Jun 1998 21:29:19 +0000 (21:29 +0000)]
Update to v.0246
Bruce Momjian [Tue, 16 Jun 1998 17:53:44 +0000 (17:53 +0000)]
> Sure send it in, we can put it in contrib. > > > > > I wrote a
real small function to revoke update on a column. The function >
> doesn't do anything > > fancy like checking user ids. > > > >
I copied most of it from the refint.c in the contrib directory.
> > > > Should I post this somewhere? It really isn't very big.
> >
Here it is...
--
| Email - rick@rpacorp.com
Rick Poleshuck | Voice - (908) 653-1070 Fax - (908) 653-0265
| Mail - RPA Corporation | - 308 Elizabeth
Avenue, Cranford, New Jersey 07016
Bruce Momjian [Tue, 16 Jun 1998 17:04:31 +0000 (17:04 +0000)]
Add files to be updated for release.
Bruce Momjian [Tue, 16 Jun 1998 07:38:20 +0000 (07:38 +0000)]
More mb patches.
Bruce Momjian [Tue, 16 Jun 1998 07:29:54 +0000 (07:29 +0000)]
Hi, here are the patches to enhance existing MB handling. This time
I have implemented a framework of encoding translation between the
backend and the frontend. Also I have added a new variable setting
command:
SET CLIENT_ENCODING TO 'encoding';
Other features include:
Latin1 support more 8 bit cleaness
See doc/README.mb for more details. Note that the pacthes are
against May 30 snapshot.
Tatsuo Ishii
Bruce Momjian [Tue, 16 Jun 1998 07:18:16 +0000 (07:18 +0000)]
Here is the long awaited optimized version of the S_LOCK patch.
This incorporates all the precedeing patches and emailed suggestions
and the results of the performance testing I posted last week. I
would like to get this tested on as many platforms as possible so
I can verify it went in correctly (as opposed to the horrorshow
last time I sent in a patch).
Once this is confirmed, I will make a tarball of files that can be
dropped into a 6.3.2 source tree as a few people have asked for
this in 6.3.2 as well.
David Gould
Bruce Momjian [Tue, 16 Jun 1998 07:07:11 +0000 (07:07 +0000)]
Ok, attached is the lo type, which goes some way with Large Object
Orphaning that occurs with JDBC & ODBC.
Contents:
contrib/lo/Makefile contrib/lo/README contrib/lo/lo.c contrib/lo/lo.sql.in
These are just test stuff - not essential
contrib/lo/test.sql contrib/lo/drop.sql
Peter Mount
Bruce Momjian [Tue, 16 Jun 1998 06:57:27 +0000 (06:57 +0000)]
Added missing file.
Bruce Momjian [Tue, 16 Jun 1998 06:53:27 +0000 (06:53 +0000)]
large object fix
Bruce Momjian [Tue, 16 Jun 1998 06:52:15 +0000 (06:52 +0000)]
I've hacked up pg_dump so that it generates CONSTRAINT and CHECK
syntax that can be read back in with psql. I did this by adding
a
"-c" switch that controls moving the CONTSTRAINT statements inside
the CREATE TABLE statements and adding () around the CHECK arguments.
Here's diffs against the 6.3.2 version of pg_dump.c.
ccb
Bruce Momjian [Tue, 16 Jun 1998 06:42:02 +0000 (06:42 +0000)]
Hello!
Attached to the mail is locale-patch.tar.gz. In the archive
there are:
file README.locale
short description
directory src/test/locale
test suite; currently only koi8-r tests, but the suite can be
easily extended
file locale.patch
the very patch; to apply: patch < locale.patch; should be applied
to postgres-6.3.2 (at least I created it with 6.3.2 without any
additional
patches)
Files touched by the patch: src/include/utils/builtins.h
src/backend/utils/adt/char.c src/backend/utils/adt/varchar.c
src/backend/utils/adt/varlena.c
Oleg
Bruce Momjian [Tue, 16 Jun 1998 05:50:55 +0000 (05:50 +0000)]
There is a patch which has worked for me. The real problem might
be in PQreset, which can't reset a conninfo based connection. The
patch:
Arpad Magosanyi
Bruce Momjian [Tue, 16 Jun 1998 05:35:12 +0000 (05:35 +0000)]
try again
Bruce Momjian [Tue, 16 Jun 1998 04:34:30 +0000 (04:34 +0000)]
I investigated carefully POSTGRES data base (in idea to use it for
our internal IP routing data base, and because I have participated
in Ingres development here in Russia in RUBIN/DEMOS project -
through it was not freeware work - and it was very interesting for
me too see such good freeware data base as PostgreSQL), and I
modified 'ipaddr' data type library in accordance to our requests
and to allow SQL do indexing over ipaddr objects.
You can read description at 'http://relcom.EU.net/ipaddr.html' and
get sources at 'http://relcom.EU.net/ip_class.tar.gz'. It contains
sources, sql scripts for incorporating new data type into postgres
(including ipaddr_ops operator class incorporation) and 20,000
records based data test for the indexing.
I am not sure if it's proper mail list for this information, and
if it's interesting for anyone except me to get full-functional
ipaddress class. I am ready to make all modifications, bug fixing
and documentation for this data class if it's nessesary for it's
contribution to the Postgres data base.
Anyway, all my work was based at original 'ip&mac data type'
contribution, written by Tom Ivar Helbekkmo.
Be free to write me any questions or requests about this work.
==============================================================
Aleksei Roudnev, Network Operations Center, Relcom, Moscow (+7 095)
194-19-95 (Network Operations Center Hot Line),(+7 095) 239-10-10,
N 13729 (pager) (+7 095) 196-72-12 (Support), (+7 095) 194-33-28
(Fax)
Bruce Momjian [Tue, 16 Jun 1998 04:10:17 +0000 (04:10 +0000)]
The attached patch modifies libpgtcl per previous discussion: the
pg_notifies statement is eliminated, and callbacks defined by
pg_listen are instead invoked automatically from the Tcl idle loop
whenever a NOTIFY message is received.
I have done only cursory testing, so there may be problems still
lurking (particularly on non-Unix machines?). But it seems to
work.
Patch is against today's cvs sources. Note that this will not work
with the 6.3.2 release since it depends on the new libpq.
The diffs are a bit large so I've gzipped them. A patch to update
libpgtcl.sgml is included too.
regards, tom lane
Bruce Momjian [Tue, 16 Jun 1998 04:04:00 +0000 (04:04 +0000)]
Add flag for linux-alpha.
Bruce Momjian [Tue, 16 Jun 1998 03:55:15 +0000 (03:55 +0000)]
Add FAQ_CVS.
Bruce Momjian [Tue, 16 Jun 1998 03:33:31 +0000 (03:33 +0000)]
autoconf
Bruce Momjian [Tue, 16 Jun 1998 03:28:58 +0000 (03:28 +0000)]
Here are two patches to fix up the c++ (and c) support in the
configuration system. The idea is to make the configure arguments
that specify compilers to be compatible with the other --with
options. The main point, though, is that the c++ support is on by
default, but can easily be disabled by the --without-CXX option
for those few(?) that don't want it.
Brook Milligan
Bruce Momjian [Tue, 16 Jun 1998 03:17:47 +0000 (03:17 +0000)]
Add bsdi shared library support.
Bruce Momjian [Tue, 16 Jun 1998 03:03:03 +0000 (03:03 +0000)]
Remove time travel reference.
Bruce Momjian [Tue, 16 Jun 1998 02:53:26 +0000 (02:53 +0000)]
Change error message and remove non-functional update message, from
Vadim.
Bruce Momjian [Mon, 15 Jun 1998 21:01:54 +0000 (21:01 +0000)]
Fix portname defines in Makefiles.