]>
granicus.if.org Git - postgresql/log
Bruce Momjian [Mon, 22 Dec 1997 05:42:25 +0000 (05:42 +0000)]
Fix for select 1=1 or 2=2, select 1=1 and 2=2, and select sum(2+2).
Bruce Momjian [Sun, 21 Dec 1997 05:18:48 +0000 (05:18 +0000)]
Remove some recursion in optimizer and clean up some code there.
Marc G. Fournier [Sat, 20 Dec 1997 18:36:26 +0000 (18:36 +0000)]
Potential fix for Bruce's "test" problem
Bruce Momjian [Sat, 20 Dec 1997 07:59:44 +0000 (07:59 +0000)]
Fix aggregates on inherited tables.
Marc G. Fournier [Sat, 20 Dec 1997 04:48:11 +0000 (04:48 +0000)]
Move more to dynloader subdir
Marc G. Fournier [Sat, 20 Dec 1997 04:43:20 +0000 (04:43 +0000)]
Make sure distclean works as well as clean
Marc G. Fournier [Sat, 20 Dec 1997 04:26:27 +0000 (04:26 +0000)]
Missed a HAVE_
Marc G. Fournier [Sat, 20 Dec 1997 04:13:31 +0000 (04:13 +0000)]
fix so that dynloader.h is included instead of port-protos.h
Marc G. Fournier [Sat, 20 Dec 1997 04:10:35 +0000 (04:10 +0000)]
Fix use of variable in Makefile.in
Marc G. Fournier [Sat, 20 Dec 1997 03:41:06 +0000 (03:41 +0000)]
Make sure configure reflects changes
Marc G. Fournier [Sat, 20 Dec 1997 03:38:20 +0000 (03:38 +0000)]
Oops, forgot to add what I took away
Marc G. Fournier [Sat, 20 Dec 1997 03:36:35 +0000 (03:36 +0000)]
More cleanups...
Marc G. Fournier [Sat, 20 Dec 1997 03:23:46 +0000 (03:23 +0000)]
More ports switched over
Marc G. Fournier [Sat, 20 Dec 1997 03:13:59 +0000 (03:13 +0000)]
Move over the BSDi port files
Marc G. Fournier [Sat, 20 Dec 1997 02:36:26 +0000 (02:36 +0000)]
This should get the linux port to work...
Marc G. Fournier [Sat, 20 Dec 1997 02:33:56 +0000 (02:33 +0000)]
Get it so that everything else *should* work with my changes...
Marc G. Fournier [Sat, 20 Dec 1997 00:29:35 +0000 (00:29 +0000)]
Major cleanout of PORTNAME variables from Makefiles...bound to screw up
some of the ports...
Marc G. Fournier [Sat, 20 Dec 1997 00:11:13 +0000 (00:11 +0000)]
First clean compile without a "PORTNAME" variable being set...
Marc G. Fournier [Fri, 19 Dec 1997 23:17:42 +0000 (23:17 +0000)]
removed the port-protos.h from bsd a little too quick...remedied now
Marc G. Fournier [Fri, 19 Dec 1997 23:10:16 +0000 (23:10 +0000)]
If this doesn't break something, nothing will *muhahaha*
Just got rid of PORTNAME altogether for FreeBSD and AIX...more to follow
Marc G. Fournier [Fri, 19 Dec 1997 22:58:27 +0000 (22:58 +0000)]
These files will get link'd to 'dynloader.[ch]', from configure, which
will then get link'd into SUBSYS.o
Marc G. Fournier [Fri, 19 Dec 1997 22:56:03 +0000 (22:56 +0000)]
More removal of port dependent stuff
Marc G. Fournier [Fri, 19 Dec 1997 22:47:00 +0000 (22:47 +0000)]
More cleanups. Move alot of the prototype definitions straight into
config.h, right beside their appropriate HAVE_ #ifdefs...one central
location that is included everywhere...
Marc G. Fournier [Fri, 19 Dec 1997 21:29:28 +0000 (21:29 +0000)]
Get rid of PORTNAME from Makefile.global.in...
Marc G. Fournier [Fri, 19 Dec 1997 21:23:19 +0000 (21:23 +0000)]
Add regression output from FreeBSD
Bruce Momjian [Fri, 19 Dec 1997 16:54:15 +0000 (16:54 +0000)]
Replace foo/bar to l1/l2.
Marc G. Fournier [Fri, 19 Dec 1997 15:50:18 +0000 (15:50 +0000)]
Here is the difference between expected->results of the regression
tests under sparc_solaris
Marc G. Fournier [Fri, 19 Dec 1997 13:35:17 +0000 (13:35 +0000)]
More cleanups...only need one rusagestub.h
Marc G. Fournier [Fri, 19 Dec 1997 13:28:06 +0000 (13:28 +0000)]
remove port from OBJS line...
Marc G. Fournier [Fri, 19 Dec 1997 03:42:14 +0000 (03:42 +0000)]
Nice clean compile...still need to run regression tests, but its a major
start
Marc G. Fournier [Fri, 19 Dec 1997 03:08:03 +0000 (03:08 +0000)]
Update configure so that it auto-detects and configures for missing
functions...
Marc G. Fournier [Fri, 19 Dec 1997 03:06:22 +0000 (03:06 +0000)]
Okay, that's it for tonight...broke a few ports, most likely, but that
is expected...a few ports don't have "ports" anymore, with most things
auto-configured by configure like it should be :)
Marc G. Fournier [Fri, 19 Dec 1997 02:56:35 +0000 (02:56 +0000)]
More cleanups
Marc G. Fournier [Fri, 19 Dec 1997 02:46:25 +0000 (02:46 +0000)]
More cleanups...several ports are major redundancies of other ports
Marc G. Fournier [Fri, 19 Dec 1997 02:27:20 +0000 (02:27 +0000)]
port.c no longer required...individual functions that were in there are
auto-generated via configure
individual functions in individual files
Marc G. Fournier [Fri, 19 Dec 1997 02:09:10 +0000 (02:09 +0000)]
More cleanups. I can now compile without PORTNAME being defined n
Makefile.global.
End result, if all goes well, should allow for much easier porting, since
there will no longer be a concept of a "port". Most, if not everything,
*should* be determined by configure, or by the compiler itself. Still
work to be done though :)
Bruce Momjian [Thu, 18 Dec 1997 19:46:37 +0000 (19:46 +0000)]
copy query cleanup.
Bruce Momjian [Thu, 18 Dec 1997 19:41:44 +0000 (19:41 +0000)]
Remove init_query_planner(), merged into planner().
Bruce Momjian [Thu, 18 Dec 1997 19:13:49 +0000 (19:13 +0000)]
Fix copy for no aggregates.
Bruce Momjian [Thu, 18 Dec 1997 12:54:45 +0000 (12:54 +0000)]
Remove Existential, and ifdef out generate_fjoin. Neither did anything.
Bruce Momjian [Thu, 18 Dec 1997 12:30:44 +0000 (12:30 +0000)]
Cost cleanup.
Bruce Momjian [Thu, 18 Dec 1997 12:21:02 +0000 (12:21 +0000)]
Cost cleanup.
Bruce Momjian [Thu, 18 Dec 1997 05:58:40 +0000 (05:58 +0000)]
Cleanup of agg copy.
Bruce Momjian [Thu, 18 Dec 1997 04:33:31 +0000 (04:33 +0000)]
Cleanup of agg copy.
Bruce Momjian [Thu, 18 Dec 1997 03:03:41 +0000 (03:03 +0000)]
Fix Query handling for inheritance, and cost computations.
Thomas G. Lockhart [Wed, 17 Dec 1997 23:22:17 +0000 (23:22 +0000)]
Enable timespan_finite() and text_timespan() routines (was commented out).
Define an "ISO-style" timespan output format with "hh:mm:ss" fields.
Enabled by DateStyle = USE_ISO_DATES.
Thomas G. Lockhart [Wed, 17 Dec 1997 23:19:28 +0000 (23:19 +0000)]
Move declarations for timespan2tm() and tm2timespan() from dt.c to here.
Bruce Momjian [Wed, 17 Dec 1997 18:21:37 +0000 (18:21 +0000)]
Rename Query label so ctags finds real structure.
Bruce Momjian [Wed, 17 Dec 1997 18:02:33 +0000 (18:02 +0000)]
Add optimizer README file.
Marc G. Fournier [Wed, 17 Dec 1997 04:59:16 +0000 (04:59 +0000)]
First pass through, of many to come, towards making the whole source
tree "non-PORTNAME" dependent. Technically, anything that is PORTNAME
dependent should be able to be derived at compile time, through configure
or through gcc
Marc G. Fournier [Wed, 17 Dec 1997 04:44:50 +0000 (04:44 +0000)]
Makefile cleaned up
async.c: #include <port-protos.h> surrounded by an #ifdef HAVE_STRDUP
vacuum.c: #include <port-protos.h> commented out...can someone comment as
to why it was included, as it doesn't seem to have any effect
under FreeBSD so far...would like some sort of #ifdef wrapper
like async.c if possible
Marc G. Fournier [Wed, 17 Dec 1997 04:31:34 +0000 (04:31 +0000)]
Clean up the Makefiles
Essentially, this cleans things up so that if PORTNAME isn't defined (I'm
working on getting rid of it for FreeBSD, at least, to see if its possible)
none of the PORTNAME related stuff gets passed around.
Had a little bit of -I related redundancy as well
Marc G. Fournier [Wed, 17 Dec 1997 04:03:30 +0000 (04:03 +0000)]
Make it entirely possible for PORTNAME to be undefined
Marc G. Fournier [Wed, 17 Dec 1997 03:23:52 +0000 (03:23 +0000)]
Add recognition for 'machten'
Thomas G. Lockhart [Tue, 16 Dec 1997 16:01:05 +0000 (16:01 +0000)]
Mention PST8PDT explicitly in the banner message (rather than PST/PDT).
Thomas G. Lockhart [Tue, 16 Dec 1997 15:59:11 +0000 (15:59 +0000)]
Define text, varchar, and bpchar string length functions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:58:14 +0000 (15:58 +0000)]
Use MAXPGPATH to declare size of socket name storage.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:57:00 +0000 (15:57 +0000)]
Use environment variable PGDATESTYLE on backend startup to initialize
date/time formats and conventions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:55:17 +0000 (15:55 +0000)]
Add declarations for text, bpchar, and varchar length functions.
Remove declarations in builtins.h duplicated in dt.h.
Change a few return type declarations to use "type *"
rather than "struct ...".
Thomas G. Lockhart [Tue, 16 Dec 1997 15:53:17 +0000 (15:53 +0000)]
Add declarations for text, bpchar, and varchar length functions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:50:54 +0000 (15:50 +0000)]
Allow multiple-argument functions in constraint clauses.
Formerly allowed only single arguments.
Declare column constraints using the usual list mechanism rather
than explicit itemized lists.
Remove NOTNULL from default clause syntax (retain "NOT NULL").
NOTNULL is not SQL92; eventually remove it from expressions too?
Move ISNULL, NOTNULL to Postgres-specific token declarations.
Fix up tabs and indenting on new CREATE USER commands.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:45:46 +0000 (15:45 +0000)]
Improve (well, ok, fix) generated constraint name for column CHECK clause.
Bruce Momjian [Tue, 16 Dec 1997 05:04:00 +0000 (05:04 +0000)]
Fix order of keywords, must be alphabetical.
Bruce Momjian [Mon, 15 Dec 1997 22:03:59 +0000 (22:03 +0000)]
Fix for user password packet processing, from Goran Thyni.
Bruce Momjian [Fri, 12 Dec 1997 16:26:36 +0000 (16:26 +0000)]
Make password null on startup.
Bruce Momjian [Thu, 11 Dec 1997 17:36:58 +0000 (17:36 +0000)]
Rename pg_plan and pg_eval to be more meaningful.
Bruce Momjian [Thu, 11 Dec 1997 17:03:52 +0000 (17:03 +0000)]
Remove PGDATA setting and use DataDir.
Bruce Momjian [Tue, 9 Dec 1997 20:55:33 +0000 (20:55 +0000)]
Spark/Linux patch for locking, from Tom Szybist
Marc G. Fournier [Tue, 9 Dec 1997 03:11:25 +0000 (03:11 +0000)]
Major code cleanup following the pg_password insertion...
...malloc/free -> palloc/pfree
...fopen/fclose -> AllocateFile/FreeFile
Thomas G. Lockhart [Tue, 9 Dec 1997 01:46:31 +0000 (01:46 +0000)]
Include informational messages added for implicit index creation.
Thomas G. Lockhart [Tue, 9 Dec 1997 01:44:14 +0000 (01:44 +0000)]
Add information message about implicitly created indices.
Check for duplicate implicit index names and generate unique names.
Thomas G. Lockhart [Tue, 9 Dec 1997 01:40:30 +0000 (01:40 +0000)]
Remove trailing period from an elog message.
Most other messages do not have one.
Bruce Momjian [Mon, 8 Dec 1997 04:42:48 +0000 (04:42 +0000)]
More VARHDRSZ additions.
Marc G. Fournier [Sun, 7 Dec 1997 20:57:45 +0000 (20:57 +0000)]
Add error check on getenv("DATADIR")
Add code to set DATADIR in postmaster.c if -D is used
Bruce Momjian [Sat, 6 Dec 1997 22:57:36 +0000 (22:57 +0000)]
Add VARHDRSZ where needed. Many places just used 4.
Thomas G. Lockhart [Sat, 6 Dec 1997 03:02:34 +0000 (03:02 +0000)]
Allow logging of output to syslog or /tmp/postgres.log.
Put all configurable parameters near top of file.
Remove explicit path to postmaster executable.
More comments.
Thomas G. Lockhart [Fri, 5 Dec 1997 01:14:55 +0000 (01:14 +0000)]
Add test for multi-character char().
Bruce Momjian [Fri, 5 Dec 1997 01:13:24 +0000 (01:13 +0000)]
Fix tolower loops to go in proper direction for cache.
Marc G. Fournier [Fri, 5 Dec 1997 01:04:25 +0000 (01:04 +0000)]
I found one other change that I would like to make to the
src. It is in the function ParseACL. When I find that I
can not allocate enough memory for the ACL structure I
return an NULL instead of doing an exit_nicely(g_conn);
From: Matthew C Aycock <maycock@scuba.pcpipeline.com>
Thomas G. Lockhart [Fri, 5 Dec 1997 00:01:22 +0000 (00:01 +0000)]
Change constraint syntax to SQL92 style.
Add tests for PRIMARY KEY and UNIQUE clauses.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:58:01 +0000 (23:58 +0000)]
Define USE_GERMAN_DATES for use in date/time I/O functions.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:55:52 +0000 (23:55 +0000)]
Change Constraint structure to be a full node structure.
Add new constraint types PRIMARY, UNIQUE.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:43:59 +0000 (23:43 +0000)]
Add Constraint node type.
Remove TimeRange node type tag (everything else already gone).
Thomas G. Lockhart [Thu, 4 Dec 1997 23:30:52 +0000 (23:30 +0000)]
Add 'GERMAN' style to date/time output.
Probably have it wrong (dd.mm/yyyy) but can change it when we know.
Input routines always handled it.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:28:20 +0000 (23:28 +0000)]
Run through toupper() conversion in the forward direction.
Most processors should optimize this a bit better wrt cache prefetch.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:20:32 +0000 (23:20 +0000)]
Add some printing capability for a few more node types (CreateStmt,
IndexStmt, IndexElem, ColumnDef).
Thomas G. Lockhart [Thu, 4 Dec 1997 23:17:13 +0000 (23:17 +0000)]
Add 'GERMAN' option to DateStyle.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:15:28 +0000 (23:15 +0000)]
Change Constraint structure name from ConstraintDef to Constraint.
Change reference to field inside to be compatible with new definition
as a "node" structure rather than a specialty structure.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:07:23 +0000 (23:07 +0000)]
Add SQL92-compliant syntax for constraints.
Implement PRIMARY KEY and UNIQUE clauses using indices.
Thomas G. Lockhart [Thu, 4 Dec 1997 23:04:08 +0000 (23:04 +0000)]
Backend code redefinitions to allow read/write
of integer Unix system times.
Bruce Momjian [Thu, 4 Dec 1997 20:32:35 +0000 (20:32 +0000)]
Update description for PGHOST and unix domain sockets. Add warning for failed connections.
Bruce Momjian [Thu, 4 Dec 1997 20:26:37 +0000 (20:26 +0000)]
Update description for PGHOST and unix domain sockets. Add warning for failed connections.
Marc G. Fournier [Thu, 4 Dec 1997 01:31:28 +0000 (01:31 +0000)]
Incorporate patch from Matt(maycock@intelliquest.com) for dumping ACLs
Clean up formatting of code
Integrate new functions into dumpTable
This is not tested yet...have to recompile server due to patches from
Todd...but this compiles cleanly as it stands now
Marc G. Fournier [Thu, 4 Dec 1997 00:34:01 +0000 (00:34 +0000)]
Missed a few files from Todd's patch...oops :)
Marc G. Fournier [Thu, 4 Dec 1997 00:28:15 +0000 (00:28 +0000)]
From: todd brandys <brandys@eng3.hep.uiuc.edu>
An extension to the code to allow for a pg_password authentication database
that is *seperate* from the system password file
Bruce Momjian [Tue, 2 Dec 1997 16:09:15 +0000 (16:09 +0000)]
Fix vacuum analyze syntax problem.
Marc G. Fournier [Tue, 2 Dec 1997 03:43:54 +0000 (03:43 +0000)]
the -l option doesn't take a port option, so the man page shouldn't say it
does
Marc G. Fournier [Tue, 2 Dec 1997 03:19:42 +0000 (03:19 +0000)]
gmake distclean wasn't removing the configure generated Makefile in
pg_version...
...fixed
Thomas G. Lockhart [Tue, 2 Dec 1997 02:54:15 +0000 (02:54 +0000)]
Remove premature code in constraint parsing.
Change elog WARN to NOTICE for unimplemented constraints.
Marc G. Fournier [Tue, 2 Dec 1997 02:43:08 +0000 (02:43 +0000)]
Linux related change to .similar to handle 'a.out' files...
From: Herb Richter <hgr@buynet.com>