]> granicus.if.org Git - postgresql/log
postgresql
28 years agoMove "port specific" #ifdefs out of here and into config.h
Marc G. Fournier [Thu, 17 Oct 1996 23:59:45 +0000 (23:59 +0000)]
Move "port specific" #ifdefs out of here and into config.h
- created a HAVE_TZSET define for this purpose

28 years agoAdd a HAVE_TZSET define to clean up defines in backend/utils/adt/nabstime.c
Marc G. Fournier [Thu, 17 Oct 1996 23:55:27 +0000 (23:55 +0000)]
Add a HAVE_TZSET define to clean up defines in backend/utils/adt/nabstime.c

28 years agoChange treatment of sigaction structure again to include even more platforms.
Bryan Henderson [Wed, 16 Oct 1996 09:41:13 +0000 (09:41 +0000)]
Change treatment of sigaction structure again to include even more platforms.
Thanks D'Arcy.

28 years agoRemove 4th element of sigaction structure so it works on more platforms.
Bryan Henderson [Tue, 15 Oct 1996 07:16:41 +0000 (07:16 +0000)]
Remove 4th element of sigaction structure so it works on more platforms.

28 years agoNew FAQ's.
Bruce Momjian [Mon, 14 Oct 1996 12:12:14 +0000 (12:12 +0000)]
New FAQ's.

28 years agoMore closing of relations left open by parser.
Bruce Momjian [Mon, 14 Oct 1996 03:53:53 +0000 (03:53 +0000)]
More closing of relations left open by parser.

28 years agoChange display of char(5) to (bp)char 5 so psql \d can
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).

28 years agoRemoved const warning.
Bruce Momjian [Sun, 13 Oct 1996 18:39:41 +0000 (18:39 +0000)]
Removed const warning.

28 years agoD'Arcy change.
Bruce Momjian [Sun, 13 Oct 1996 18:38:51 +0000 (18:38 +0000)]
D'Arcy change.

28 years agoAdded include needed for recent addition.
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.

28 years agoAdded include needed for recent addition.
Bruce Momjian [Sun, 13 Oct 1996 18:37:19 +0000 (18:37 +0000)]
Added include needed for recent addition.

28 years agoFix structure member name from previous patch.
Bruce Momjian [Sun, 13 Oct 1996 17:13:58 +0000 (17:13 +0000)]
Fix structure member name from previous patch.

28 years agoRemoved duplicate MAXNAMELEN define I accidentally added.
Bruce Momjian [Sun, 13 Oct 1996 13:46:20 +0000 (13:46 +0000)]
Removed duplicate MAXNAMELEN define I accidentally added.

28 years agoAdded consistent include file handling for MAXHOSTNAMELEN.
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.

28 years agoI checked the alter table code, and started suspecting the relation
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.

28 years agoFix prototypes so postmaster.c will compile.
Bryan Henderson [Sun, 13 Oct 1996 04:01:05 +0000 (04:01 +0000)]
Fix prototypes so postmaster.c will compile.

28 years agoNew host-based authentication -- set up pg_hba.conf instead of pg_hba
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

28 years agoNew host-based authentication -- send error message when authentication fails
Bryan Henderson [Sat, 12 Oct 1996 07:48:49 +0000 (07:48 +0000)]
New host-based authentication -- send error message when authentication fails

28 years agoNew host-based authentication with ident
Bryan Henderson [Sat, 12 Oct 1996 07:47:12 +0000 (07:47 +0000)]
New host-based authentication with ident

28 years agoNew host-based authentication -- install pg_hba.conf instead of pg_hba
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

28 years agoSeparate general purpose functions from portal functions so they may be
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.

28 years agoPrepare for new host-based authentication
Bryan Henderson [Fri, 11 Oct 1996 09:12:18 +0000 (09:12 +0000)]
Prepare for new host-based authentication

28 years agoAdd a MIPS/NetBSD port...
Marc G. Fournier [Fri, 11 Oct 1996 03:56:41 +0000 (03:56 +0000)]
Add a MIPS/NetBSD port...

28 years agoThis change should have no practical effect but it is the more
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)

28 years agoI have written some patches to the postgres lock manager which allow the
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>

28 years agoReinstituted NAMEDATALEN OIDNAMELEN in Makefile.global so that initdb
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...

28 years agoAdd PGUSER environment variable for client to specify Postgres username.
Bryan Henderson [Thu, 10 Oct 1996 08:20:11 +0000 (08:20 +0000)]
Add PGUSER environment variable for client to specify Postgres username.

28 years agoComment cleanup.
Bruce Momjian [Thu, 10 Oct 1996 00:18:52 +0000 (00:18 +0000)]
Comment cleanup.

28 years agoChanged psql \h command to print commands in three columns.
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.

28 years agoChange sh-style comments to C comments.
Bruce Momjian [Tue, 8 Oct 1996 22:23:19 +0000 (22:23 +0000)]
Change sh-style comments to C comments.

28 years agoAdd execute permission.
Bruce Momjian [Tue, 8 Oct 1996 04:09:50 +0000 (04:09 +0000)]
Add execute permission.

28 years agoAdd execute permits.
Bruce Momjian [Tue, 8 Oct 1996 04:04:38 +0000 (04:04 +0000)]
Add execute permits.

28 years agoAdd execute permission.
Bruce Momjian [Tue, 8 Oct 1996 03:53:10 +0000 (03:53 +0000)]
Add execute permission.

28 years agoMoved the following definitions to include/config.h from Makefile.global:
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?

28 years agoMove the NAMEDATALEN/OIDNAMELEN defines to include/config.h
Marc G. Fournier [Mon, 7 Oct 1996 23:57:01 +0000 (23:57 +0000)]
Move the NAMEDATALEN/OIDNAMELEN defines to include/config.h

28 years agoFix handling of no '../doc' directory in compile procedure...
Marc G. Fournier [Mon, 7 Oct 1996 23:53:47 +0000 (23:53 +0000)]
Fix handling of no '../doc' directory in compile procedure...

28 years agoWell I haven't received any feedback pro or con re my suggested new Tcl
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

28 years agoFix a couple of small things from D'Arcy's last patch
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

28 years agoModified Assert to be more selective.
Bruce Momjian [Mon, 7 Oct 1996 19:53:15 +0000 (19:53 +0000)]
Modified Assert to be more selective.

28 years agoFixed a missed change from Carsten Heyl <heyl@nads.de>
Marc G. Fournier [Mon, 7 Oct 1996 07:18:34 +0000 (07:18 +0000)]
Fixed a missed change from Carsten Heyl <heyl@nads.de>

28 years agoMostly adding "const" keyword and making some functions static.
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

28 years agoChange new assert so it generates assert message rather than SIGSEG.
Bruce Momjian [Mon, 7 Oct 1996 02:50:19 +0000 (02:50 +0000)]
Change new assert so it generates assert message rather than SIGSEG.

28 years agoadd FROM to update page, clean up spelling error in select.
Bruce Momjian [Mon, 7 Oct 1996 02:34:54 +0000 (02:34 +0000)]
add FROM to update page, clean up spelling error in select.

28 years agoRemove sytax errors from file.
Bruce Momjian [Mon, 7 Oct 1996 02:33:25 +0000 (02:33 +0000)]
Remove sytax errors from file.

28 years agoUpdate help for alter table. remove EXTEND function.
Bruce Momjian [Mon, 7 Oct 1996 02:32:39 +0000 (02:32 +0000)]
Update help for alter table. remove EXTEND function.

28 years agoFix typo in help text.
Bruce Momjian [Sat, 5 Oct 1996 21:34:33 +0000 (21:34 +0000)]
Fix typo in help text.

28 years agoRenamed file.
Bruce Momjian [Sat, 5 Oct 1996 21:16:34 +0000 (21:16 +0000)]
Renamed file.

28 years agoStylistic cleanups...
Marc G. Fournier [Sat, 5 Oct 1996 20:39:05 +0000 (20:39 +0000)]
Stylistic cleanups...

28 years agoAdd comment about possible zero value.
Bruce Momjian [Sat, 5 Oct 1996 20:33:45 +0000 (20:33 +0000)]
Add comment about possible zero value.

28 years agoChange shell-style comments to C-style.
Bruce Momjian [Sat, 5 Oct 1996 20:33:10 +0000 (20:33 +0000)]
Change shell-style comments to C-style.

28 years agoFix assert to allow zero. OK'ed by Bryan.
Bruce Momjian [Sat, 5 Oct 1996 20:31:38 +0000 (20:31 +0000)]
Fix assert to allow zero.  OK'ed by Bryan.

28 years agoFix args to match prototype.
Bruce Momjian [Sat, 5 Oct 1996 20:30:31 +0000 (20:30 +0000)]
Fix args to match prototype.

28 years agoReplace double // with /. THis confuses mkid.
Bruce Momjian [Sat, 5 Oct 1996 20:29:57 +0000 (20:29 +0000)]
Replace double // with /.  THis confuses mkid.

28 years agoAdded single-letter options and case statement.
Bruce Momjian [Sat, 5 Oct 1996 03:24:47 +0000 (03:24 +0000)]
Added single-letter options and case statement.

28 years agoImproved creation of mkid files.
Bruce Momjian [Sat, 5 Oct 1996 03:23:49 +0000 (03:23 +0000)]
Improved creation of mkid files.

28 years agoHere the fix for the first assertion failure I had which killed
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>

28 years agoAnd bring in change from 1.0.7 tree to here...
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...

28 years agoMoved the define of SIGNAL_ARGS that D'Arcy just created to config.h so that
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?

28 years agoThe remainder of D'Arcy's changes, most notibly the usage of SIGNAL_ARGS
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

28 years agoThis patch corrects some errors in sample commands in the INSTALL file.
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)

28 years agoThis patch fixes problems in initdb, including that it doesn't run
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)

28 years agoMoved files.
Bruce Momjian [Fri, 4 Oct 1996 15:23:00 +0000 (15:23 +0000)]
Moved files.

28 years agonew TODO.
Bruce Momjian [Fri, 4 Oct 1996 15:15:24 +0000 (15:15 +0000)]
new TODO.

28 years agoAdded purge(l) mention in manual page.
Bruce Momjian [Fri, 4 Oct 1996 14:50:18 +0000 (14:50 +0000)]
Added purge(l) mention in manual page.

28 years agoRemoved -S from example and added nohup to log file.
Bruce Momjian [Thu, 3 Oct 1996 23:34:36 +0000 (23:34 +0000)]
Removed -S from example and added nohup to log file.

28 years agoAdded dlfcn.h to dl.c in BSD44_derived port
Marc G. Fournier [Thu, 3 Oct 1996 22:41:42 +0000 (22:41 +0000)]
Added dlfcn.h to dl.c in BSD44_derived port

28 years agoAdded restriction to tables vacuum'able.
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.

28 years agoAdded chown to Makefile to set files to Postgres user.
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.

28 years agoMOved them.
Bruce Momjian [Thu, 3 Oct 1996 17:27:48 +0000 (17:27 +0000)]
MOved them.

28 years agoMoved them.
Bruce Momjian [Thu, 3 Oct 1996 17:27:01 +0000 (17:27 +0000)]
Moved them.

28 years agoNew FAQ.
Bruce Momjian [Thu, 3 Oct 1996 17:15:56 +0000 (17:15 +0000)]
New FAQ.

28 years agoRenamed createdb.l to create_database.l.
Bruce Momjian [Thu, 3 Oct 1996 15:50:10 +0000 (15:50 +0000)]
Renamed createdb.l  to create_database.l.
Changed portal to cursor.

28 years agoBrought psql help up to date with syntax and manual.
Bruce Momjian [Thu, 3 Oct 1996 15:46:31 +0000 (15:46 +0000)]
Brought psql help up to date with syntax and manual.

28 years agoNew vacuum optoin.
Bruce Momjian [Thu, 3 Oct 1996 04:21:31 +0000 (04:21 +0000)]
New vacuum optoin.

28 years agoNew vacuum option.
Bruce Momjian [Thu, 3 Oct 1996 04:20:41 +0000 (04:20 +0000)]
New vacuum option.

28 years agoFixes extra space in printing.
Bruce Momjian [Thu, 3 Oct 1996 04:20:11 +0000 (04:20 +0000)]
Fixes extra space in printing.

28 years agoAllow vacuum to run for only one table. Fixes allocation bug.
Bruce Momjian [Thu, 3 Oct 1996 04:19:29 +0000 (04:19 +0000)]
Allow vacuum to run for only one table.  Fixes allocation bug.

28 years agoFixed file to properly do SEMUN for BSDI.
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.

28 years agoManual changes for initdb.sh change.
Bruce Momjian [Thu, 3 Oct 1996 00:25:53 +0000 (00:25 +0000)]
Manual changes for initdb.sh change.

28 years agoAdded new single-letter options to initdb.sh.
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.

28 years agochange stdout to fout
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>

28 years agoAdded NEED_UNION_SEMUN to config.h
Marc G. Fournier [Wed, 2 Oct 1996 20:42:20 +0000 (20:42 +0000)]
Added NEED_UNION_SEMUN to config.h

28 years agoMoved whether to define union semun from include/storage/ipc.h to
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

28 years agoThis file was superceeded by README.fsync.
Bruce Momjian [Sun, 29 Sep 1996 19:11:20 +0000 (19:11 +0000)]
This file was superceeded by README.fsync.

28 years agoChanged default port name.
Bruce Momjian [Sat, 28 Sep 1996 00:57:41 +0000 (00:57 +0000)]
Changed default port name.

28 years agoChange README to 2.0.
Bruce Momjian [Thu, 26 Sep 1996 18:34:49 +0000 (18:34 +0000)]
Change README to 2.0.

28 years agoAdd fsync option to Postgres manual page.
Bruce Momjian [Thu, 26 Sep 1996 16:49:09 +0000 (16:49 +0000)]
Add fsync option to Postgres manual page.

28 years agopalloc() finfo memory. From Kurt.
Bruce Momjian [Thu, 26 Sep 1996 16:29:05 +0000 (16:29 +0000)]
palloc() finfo memory.  From Kurt.

28 years agoFix cluster finfo problem Kurt reported.
Bruce Momjian [Thu, 26 Sep 1996 15:43:35 +0000 (15:43 +0000)]
Fix cluster finfo problem Kurt reported.

28 years agoFixed YACC depenencies and 'make clean' now cleans totally.
Bruce Momjian [Thu, 26 Sep 1996 15:40:45 +0000 (15:40 +0000)]
Fixed YACC depenencies and 'make clean' now cleans totally.

28 years agoUpdated version.
Bruce Momjian [Thu, 26 Sep 1996 14:07:07 +0000 (14:07 +0000)]
Updated version.

28 years agoThis should cause 'make clean' to clean up bki files. Looks like a typo.
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.

28 years agoPrevents possible packet loss from SIGCHLD.
Bruce Momjian [Thu, 26 Sep 1996 03:17:44 +0000 (03:17 +0000)]
Prevents possible packet loss from SIGCHLD.

28 years agoupgrade.
Bruce Momjian [Thu, 26 Sep 1996 01:13:14 +0000 (01:13 +0000)]
upgrade.

28 years agoUpdated version.
Bruce Momjian [Thu, 26 Sep 1996 00:48:48 +0000 (00:48 +0000)]
Updated version.

28 years agoFix location of include files to match postgres.h includes.
Bruce Momjian [Wed, 25 Sep 1996 19:37:31 +0000 (19:37 +0000)]
Fix location of include files to match postgres.h includes.

28 years agoChanged gawk to awk.
Bruce Momjian [Wed, 25 Sep 1996 19:24:58 +0000 (19:24 +0000)]
Changed gawk to awk.

28 years agoPatch for:
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

28 years agoChange the comments pertaining to Makefile.custom
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)

28 years agoPrototype setMaxOid()
Marc G. Fournier [Mon, 23 Sep 1996 18:15:41 +0000 (18:15 +0000)]
Prototype setMaxOid()

Submitted by: Bruce