OSDN Git Service
Bruce Momjian [Mon, 14 Oct 1996 00:33:47 +0000 (00:33 +0000)]
Change display of char(5) to (bp)char 5 so psql \d can
distinguish between char and char(1).
Bruce Momjian [Sun, 13 Oct 1996 18:39:41 +0000 (18:39 +0000)]
Removed const warning.
Bruce Momjian [Sun, 13 Oct 1996 18:38:51 +0000 (18:38 +0000)]
D'Arcy change.
Bruce Momjian [Sun, 13 Oct 1996 18:38:04 +0000 (18:38 +0000)]
Added include needed for recent addition.
I hope everyone has sys/socket.h.
Bruce Momjian [Sun, 13 Oct 1996 18:37:19 +0000 (18:37 +0000)]
Added include needed for recent addition.
Bruce Momjian [Sun, 13 Oct 1996 17:13:58 +0000 (17:13 +0000)]
Fix structure member name from previous patch.
Bruce Momjian [Sun, 13 Oct 1996 13:46:20 +0000 (13:46 +0000)]
Removed duplicate MAXNAMELEN define I accidentally added.
Bruce Momjian [Sun, 13 Oct 1996 04:50:27 +0000 (04:50 +0000)]
Added consistent include file handling for MAXHOSTNAMELEN.
If I have introduced any syntax errors with this, I will patch them in
the morning, and Marc will have a good laugh.
Bruce Momjian [Sun, 13 Oct 1996 04:26:39 +0000 (04:26 +0000)]
I checked the alter table code, and started suspecting the relation
cache. I found if I manually added a line to flush the whole relation
cache, the assert error disappeared. Looking through the code, I found
that the relation cache is flushed at the end of each query if the
reference count is zero for the relation. However, printf's showed that
the rd_relcnt(reference count) for the accessed query was not returning
to zero after each query.
It turns out the parser was doing a heap_ropen in parser/analyze.c to
get information about the table's columns, but was not doing a
heap_close.
This was causing the query after the ALTER TABLE ADD to see the old
table structure, and the executor's assert was reporting the problem.
Bryan Henderson [Sun, 13 Oct 1996 04:01:05 +0000 (04:01 +0000)]
Fix prototypes so postmaster.c will compile.
Bryan Henderson [Sat, 12 Oct 1996 07:49:56 +0000 (07:49 +0000)]
New host-based authentication -- set up pg_hba.conf instead of pg_hba
Bryan Henderson [Sat, 12 Oct 1996 07:48:49 +0000 (07:48 +0000)]
New host-based authentication -- send error message when authentication fails
Bryan Henderson [Sat, 12 Oct 1996 07:47:12 +0000 (07:47 +0000)]
New host-based authentication with ident
Bryan Henderson [Sat, 12 Oct 1996 07:44:39 +0000 (07:44 +0000)]
New host-based authentication -- install pg_hba.conf instead of pg_hba
Bryan Henderson [Fri, 11 Oct 1996 09:47:14 +0000 (09:47 +0000)]
Separate general purpose functions from portal functions so they may be
used in test drivers.
Bryan Henderson [Fri, 11 Oct 1996 09:12:18 +0000 (09:12 +0000)]
Prepare for new host-based authentication
Marc G. Fournier [Fri, 11 Oct 1996 03:56:41 +0000 (03:56 +0000)]
Add a MIPS/NetBSD port...
Marc G. Fournier [Fri, 11 Oct 1996 03:25:00 +0000 (03:25 +0000)]
This change should have no practical effect but it is the more
correct way to do this. Theoretically you could have a NULL
pointer that isn't represented internally as all 0 bits. This
guarantees that it convert correctly.
Submitted by: darcy@druid.com (D'Arcy J.M. Cain)
Marc G. Fournier [Fri, 11 Oct 1996 03:22:59 +0000 (03:22 +0000)]
I have written some patches to the postgres lock manager which allow the
use of long term cooperative locks managed by the user applications.
Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>
Marc G. Fournier [Fri, 11 Oct 1996 02:38:16 +0000 (02:38 +0000)]
Reinstituted NAMEDATALEN OIDNAMELEN in Makefile.global so that initdb
works again...
Bryan Henderson [Thu, 10 Oct 1996 08:20:11 +0000 (08:20 +0000)]
Add PGUSER environment variable for client to specify Postgres username.
Bruce Momjian [Thu, 10 Oct 1996 00:18:52 +0000 (00:18 +0000)]
Comment cleanup.
Bruce Momjian [Wed, 9 Oct 1996 00:15:44 +0000 (00:15 +0000)]
Changed psql \h command to print commands in three columns.
No more scrolling off the screen.
Bruce Momjian [Tue, 8 Oct 1996 22:23:19 +0000 (22:23 +0000)]
Change sh-style comments to C comments.
Bruce Momjian [Tue, 8 Oct 1996 04:09:50 +0000 (04:09 +0000)]
Add execute permission.
Bruce Momjian [Tue, 8 Oct 1996 04:04:38 +0000 (04:04 +0000)]
Add execute permits.
Bruce Momjian [Tue, 8 Oct 1996 03:53:10 +0000 (03:53 +0000)]
Add execute permission.
Marc G. Fournier [Tue, 8 Oct 1996 00:09:05 +0000 (00:09 +0000)]
Moved the following definitions to include/config.h from Makefile.global:
NAMEDATALEN
OIDDATALEN
EUROPEAN_DATES
HBA
DEADLOCK_TIMEOUT
OPENLINK_PATCHES
NULL_PATCH
ARRAY_PATCH
Attempting to document and centralize as many of the "defines" as possible...
kinda useless to have defines if nobody knows they exist, eh?
Marc G. Fournier [Mon, 7 Oct 1996 23:57:01 +0000 (23:57 +0000)]
Move the NAMEDATALEN/OIDNAMELEN defines to include/config.h
Marc G. Fournier [Mon, 7 Oct 1996 23:53:47 +0000 (23:53 +0000)]
Fix handling of no '../doc' directory in compile procedure...
Marc G. Fournier [Mon, 7 Oct 1996 21:19:09 +0000 (21:19 +0000)]
Well I haven't received any feedback pro or con re my suggested new Tcl
function so I am going to assume that it is such a good idea that no
one sees any point in discussing it. :-) I have made two changes -
I have merged this into pgtclCmds.c and I have taken out any code for
updating tuples after the loop body runs. See comments for discussion
of this.
I have also fixed up the error checking stuff so that break, continue
and syntax errors have the expected result.
Submitted by: D'Arcy Cain
Marc G. Fournier [Mon, 7 Oct 1996 21:17:01 +0000 (21:17 +0000)]
Fix a couple of small things from D'Arcy's last patch
Submitted by: D'Arcy Cain
Bruce Momjian [Mon, 7 Oct 1996 19:53:15 +0000 (19:53 +0000)]
Modified Assert to be more selective.
Marc G. Fournier [Mon, 7 Oct 1996 07:18:34 +0000 (07:18 +0000)]
Fixed a missed change from Carsten Heyl <heyl@nads.de>
Marc G. Fournier [Mon, 7 Oct 1996 03:30:40 +0000 (03:30 +0000)]
Mostly adding "const" keyword and making some functions static.
Submitted by: D'Arcy Cain
Bruce Momjian [Mon, 7 Oct 1996 02:50:19 +0000 (02:50 +0000)]
Change new assert so it generates assert message rather than SIGSEG.
Bruce Momjian [Mon, 7 Oct 1996 02:34:54 +0000 (02:34 +0000)]
add FROM to update page, clean up spelling error in select.
Bruce Momjian [Mon, 7 Oct 1996 02:33:25 +0000 (02:33 +0000)]
Remove sytax errors from file.
Bruce Momjian [Mon, 7 Oct 1996 02:32:39 +0000 (02:32 +0000)]
Update help for alter table. remove EXTEND function.
Bruce Momjian [Sat, 5 Oct 1996 21:34:33 +0000 (21:34 +0000)]
Fix typo in help text.
Bruce Momjian [Sat, 5 Oct 1996 21:16:34 +0000 (21:16 +0000)]
Renamed file.
Marc G. Fournier [Sat, 5 Oct 1996 20:39:05 +0000 (20:39 +0000)]
Stylistic cleanups...
Bruce Momjian [Sat, 5 Oct 1996 20:33:45 +0000 (20:33 +0000)]
Add comment about possible zero value.
Bruce Momjian [Sat, 5 Oct 1996 20:33:10 +0000 (20:33 +0000)]
Change shell-style comments to C-style.
Bruce Momjian [Sat, 5 Oct 1996 20:31:38 +0000 (20:31 +0000)]
Fix assert to allow zero. OK'ed by Bryan.
Bruce Momjian [Sat, 5 Oct 1996 20:30:31 +0000 (20:30 +0000)]
Fix args to match prototype.
Bruce Momjian [Sat, 5 Oct 1996 20:29:57 +0000 (20:29 +0000)]
Replace double // with /. THis confuses mkid.
Bruce Momjian [Sat, 5 Oct 1996 03:24:47 +0000 (03:24 +0000)]
Added single-letter options and case statement.
Bruce Momjian [Sat, 5 Oct 1996 03:23:49 +0000 (03:23 +0000)]
Improved creation of mkid files.
Marc G. Fournier [Fri, 4 Oct 1996 20:32:07 +0000 (20:32 +0000)]
Here the fix for the first assertion failure I had which killed
my postmaster 1.07.
It's really simple, the loop dealing with all sockets
can't handle more than one ready socket :-)
A simple logic error dealing with lists.
OR IS THERE ANY REASON FOR SETTING curr TO 0?
Submitted by: Carsten Heyl <Heyl@nads.de>
Marc G. Fournier [Fri, 4 Oct 1996 20:29:35 +0000 (20:29 +0000)]
And bring in change from 1.0.7 tree to here...
Marc G. Fournier [Fri, 4 Oct 1996 20:20:57 +0000 (20:20 +0000)]
Moved the define of SIGNAL_ARGS that D'Arcy just created to config.h so that
hopefully this sort of thing can eventually be determined using configure?
Marc G. Fournier [Fri, 4 Oct 1996 20:17:11 +0000 (20:17 +0000)]
The remainder of D'Arcy's changes, most notibly the usage of SIGNAL_ARGS
Marc G. Fournier [Fri, 4 Oct 1996 20:08:29 +0000 (20:08 +0000)]
This patch corrects some errors in sample commands in the INSTALL file.
Submitted by: bryanh@giraffe.netgate.net (Bryan Henderson)
Marc G. Fournier [Fri, 4 Oct 1996 20:07:10 +0000 (20:07 +0000)]
This patch fixes problems in initdb, including that it doesn't run
with some versions of sh, and a bug in the master make file that
causes it to issue the message "postgres has been built" at the wrong
time.
Submitted by: bryanh@giraffe.netgate.net (Bryan Henderson)
Bruce Momjian [Fri, 4 Oct 1996 15:23:00 +0000 (15:23 +0000)]
Moved files.
Bruce Momjian [Fri, 4 Oct 1996 15:15:24 +0000 (15:15 +0000)]
new TODO.
Bruce Momjian [Fri, 4 Oct 1996 14:50:18 +0000 (14:50 +0000)]
Added purge(l) mention in manual page.
Bruce Momjian [Thu, 3 Oct 1996 23:34:36 +0000 (23:34 +0000)]
Removed -S from example and added nohup to log file.
Marc G. Fournier [Thu, 3 Oct 1996 22:41:42 +0000 (22:41 +0000)]
Added dlfcn.h to dl.c in BSD44_derived port
Bruce Momjian [Thu, 3 Oct 1996 20:11:41 +0000 (20:11 +0000)]
Added restriction to tables vacuum'able.
Added NOTICE messages for bad table names.
Bruce Momjian [Thu, 3 Oct 1996 20:09:48 +0000 (20:09 +0000)]
Added chown to Makefile to set files to Postgres user.
Does not display and generates no error messages on failure.
Bruce Momjian [Thu, 3 Oct 1996 17:27:48 +0000 (17:27 +0000)]
MOved them.
Bruce Momjian [Thu, 3 Oct 1996 17:27:01 +0000 (17:27 +0000)]
Moved them.
Bruce Momjian [Thu, 3 Oct 1996 17:15:56 +0000 (17:15 +0000)]
New FAQ.
Bruce Momjian [Thu, 3 Oct 1996 15:50:10 +0000 (15:50 +0000)]
Renamed createdb.l to create_database.l.
Changed portal to cursor.
Bruce Momjian [Thu, 3 Oct 1996 15:46:31 +0000 (15:46 +0000)]
Brought psql help up to date with syntax and manual.
Bruce Momjian [Thu, 3 Oct 1996 04:21:31 +0000 (04:21 +0000)]
New vacuum optoin.
Bruce Momjian [Thu, 3 Oct 1996 04:20:41 +0000 (04:20 +0000)]
New vacuum option.
Bruce Momjian [Thu, 3 Oct 1996 04:20:11 +0000 (04:20 +0000)]
Fixes extra space in printing.
Bruce Momjian [Thu, 3 Oct 1996 04:19:29 +0000 (04:19 +0000)]
Allow vacuum to run for only one table. Fixes allocation bug.
Bruce Momjian [Thu, 3 Oct 1996 01:14:37 +0000 (01:14 +0000)]
Fixed file to properly do SEMUN for BSDI.
Grouped some PORTNAME's for SEMUN.
Bruce Momjian [Thu, 3 Oct 1996 00:25:53 +0000 (00:25 +0000)]
Manual changes for initdb.sh change.
Bruce Momjian [Thu, 3 Oct 1996 00:23:42 +0000 (00:23 +0000)]
Added new single-letter options to initdb.sh.
Removed long-option names that used ${#} shell feature which
was a compatability problem.
Marc G. Fournier [Wed, 2 Oct 1996 21:38:35 +0000 (21:38 +0000)]
change stdout to fout
Submitted by: Carsten Heyl <heyl@nads.de>
Marc G. Fournier [Wed, 2 Oct 1996 20:42:20 +0000 (20:42 +0000)]
Added NEED_UNION_SEMUN to config.h
Marc G. Fournier [Wed, 2 Oct 1996 20:40:17 +0000 (20:40 +0000)]
Moved whether to define union semun from include/storage/ipc.h to
a define in include/config.h
Bruce Momjian [Sun, 29 Sep 1996 19:11:20 +0000 (19:11 +0000)]
This file was superceeded by README.fsync.
Bruce Momjian [Sat, 28 Sep 1996 00:57:41 +0000 (00:57 +0000)]
Changed default port name.
Bruce Momjian [Thu, 26 Sep 1996 18:34:49 +0000 (18:34 +0000)]
Change README to 2.0.
Bruce Momjian [Thu, 26 Sep 1996 16:49:09 +0000 (16:49 +0000)]
Add fsync option to Postgres manual page.
Bruce Momjian [Thu, 26 Sep 1996 16:29:05 +0000 (16:29 +0000)]
palloc() finfo memory. From Kurt.
Bruce Momjian [Thu, 26 Sep 1996 15:43:35 +0000 (15:43 +0000)]
Fix cluster finfo problem Kurt reported.
Bruce Momjian [Thu, 26 Sep 1996 15:40:45 +0000 (15:40 +0000)]
Fixed YACC depenencies and 'make clean' now cleans totally.
Bruce Momjian [Thu, 26 Sep 1996 14:07:07 +0000 (14:07 +0000)]
Updated version.
Bruce Momjian [Thu, 26 Sep 1996 04:22:49 +0000 (04:22 +0000)]
This should cause 'make clean' to clean up bki files. Looks like a typo.
Bruce Momjian [Thu, 26 Sep 1996 03:17:44 +0000 (03:17 +0000)]
Prevents possible packet loss from SIGCHLD.
Bruce Momjian [Thu, 26 Sep 1996 01:13:14 +0000 (01:13 +0000)]
upgrade.
Bruce Momjian [Thu, 26 Sep 1996 00:48:48 +0000 (00:48 +0000)]
Updated version.
Bruce Momjian [Wed, 25 Sep 1996 19:37:31 +0000 (19:37 +0000)]
Fix location of include files to match postgres.h includes.
Bruce Momjian [Wed, 25 Sep 1996 19:24:58 +0000 (19:24 +0000)]
Changed gawk to awk.
Marc G. Fournier [Tue, 24 Sep 1996 01:57:01 +0000 (01:57 +0000)]
Patch for:
# _fUnKy_POSTPORT_sTuFf_ - port to run the postmaster on
Submitted by: D'Arcy
Marc G. Fournier [Mon, 23 Sep 1996 18:17:42 +0000 (18:17 +0000)]
Change the comments pertaining to Makefile.custom
Submitted by: darcy@druid.druid.com (D'Arcy J.M. Cain)
Marc G. Fournier [Mon, 23 Sep 1996 18:15:41 +0000 (18:15 +0000)]
Prototype setMaxOid()
Submitted by: Bruce
Marc G. Fournier [Mon, 23 Sep 1996 18:14:08 +0000 (18:14 +0000)]
CFLAGS +- -I... got messed by one of Bryan's patches
Fix Submitted by: Bryan himself :)
Marc G. Fournier [Mon, 23 Sep 1996 08:43:40 +0000 (08:43 +0000)]
Fix for using Makefile.custom
Suggested/Submitted by: darcy@druid.druid.com
Cleaner Method Submitted by: Bryan Henderson <bryanh@giraffe.netgate.net>
Marc G. Fournier [Mon, 23 Sep 1996 08:39:53 +0000 (08:39 +0000)]
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Bryan Henderson <bryanh@giraffe.netgate.net>
Cc: Postgres95-development <pg95-dev@ki.net>
Subject: Re: [PG95-DEV] DELETE statement
>
> Does the man page for DELETE need to be corrected? It gives as syntax
>
> DELETE instance_variable [FROM fromlist] [WHERE qual] .
>
> But the actual syntax appears to be
>
> DELETE FROM classname WHERE qual .
>
> --
> Bryan Henderson Phone 408-227-6803
> San Jose, California
>
This patch fixes the delete manual page in 2.0:
Marc G. Fournier [Mon, 23 Sep 1996 08:38:45 +0000 (08:38 +0000)]
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Postgres95-development <pg95-dev@ki.net>
Subject: [PG95-DEV] postgres.h patch
This removes the parameters from the func_ptr prototype in postgres.h in
2.0.
Marc G. Fournier [Mon, 23 Sep 1996 08:37:41 +0000 (08:37 +0000)]
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Postgres95-development <pg95-dev@ki.net>
Subject: [PG95-DEV] Makefile.global patch
Can we apply the following patch to make EUROPEAN_DATES consistent with
other parameters?
Marc G. Fournier [Mon, 23 Sep 1996 08:36:39 +0000 (08:36 +0000)]
Date: Sun, 22 Sep 1996 13:47:39 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Postgres95-development <pg95-dev@ki.net>
Subject: [PG95-DEV] 2.0 patch for fastgetattr