]> granicus.if.org Git - postgresql/log
postgresql
26 years agoCleaning GCC warnings.
Vadim B. Mikheev [Fri, 26 Dec 1997 06:02:26 +0000 (06:02 +0000)]
Cleaning GCC warnings.

26 years agoextern char* crypt_getpwdfilename(void);
Vadim B. Mikheev [Fri, 26 Dec 1997 05:51:51 +0000 (05:51 +0000)]
extern char* crypt_getpwdfilename(void);
                                  ^^^^ gcc likes this

26 years agoImplementation of UNIONs.
Bruce Momjian [Wed, 24 Dec 1997 06:06:58 +0000 (06:06 +0000)]
Implementation of UNIONs.

26 years agoReverse out Thomas's group clause change.
Bruce Momjian [Tue, 23 Dec 1997 21:49:03 +0000 (21:49 +0000)]
Reverse out Thomas's group clause change.

26 years agoMake no-tty not use quiet in psql, fix group by copy failure, fix ccsym to delete...
Bruce Momjian [Tue, 23 Dec 1997 21:38:53 +0000 (21:38 +0000)]
Make no-tty not use quiet in psql, fix group by copy failure, fix ccsym to delete tmp files.

26 years agoAdd newline/tab to middle of long failure message to pretty it up a bit.
Thomas G. Lockhart [Tue, 23 Dec 1997 20:00:06 +0000 (20:00 +0000)]
Add newline/tab to middle of long failure message to pretty it up a bit.

26 years agoChange field name in RetrieveStmt from selectClause to unionClause.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:58:12 +0000 (19:58 +0000)]
Change field name in RetrieveStmt from selectClause to unionClause.
Add unionall boolean field to SubSelect structure.

26 years agoLengthen some time conversion routine names now that longer names
Thomas G. Lockhart [Tue, 23 Dec 1997 19:55:51 +0000 (19:55 +0000)]
Lengthen some time conversion routine names now that longer names
 (> 16 characters) are allowed in pg_proc (thanks Bruce!).

26 years agoFix numeric comparision (... != NULL) to be (... > 0). gcc is happier now.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:53:30 +0000 (19:53 +0000)]
Fix numeric comparision (... != NULL) to be (... > 0). gcc is happier now.
Add non-working code which is commented-out to copy GroupClause structures.

26 years agoAdd routines to print AExpr, Ident, and AConst parsing structures.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:50:54 +0000 (19:50 +0000)]
Add routines to print AExpr, Ident, and AConst parsing structures.

26 years agoImplement CREATE TABLE ... AS SELECT borrowing code from SubSelect
Thomas G. Lockhart [Tue, 23 Dec 1997 19:47:32 +0000 (19:47 +0000)]
Implement CREATE TABLE ... AS SELECT borrowing code from SubSelect
 and from SELECT ... INTO ... support code.
Allow NOT, IS NULL, IS NOT NULL in constraints.
Define unionall boolean flag in SubSelect structure.
Implement row descriptors: (a, b, c) = (x, y, z).
Change IS TRUE, IS FALSE, etc. to expressions using "=" rather than
 function calls to istrue() or isfalse() to allow optimization.
Force type for TRUE and FALSE to bool.

26 years agoChange variable name reference from selectClause to more appropriate unionClause.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:39:42 +0000 (19:39 +0000)]
Change variable name reference from selectClause to more appropriate unionClause.
Add a few lines of test code playing with the unique flag for unions.
 Does not do much helpful yet.

26 years agoFix up some elog error messages.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:36:20 +0000 (19:36 +0000)]
Fix up some elog error messages.

26 years agoExpand a few date/time routine names to > 16 characters now that this
Thomas G. Lockhart [Tue, 23 Dec 1997 19:29:15 +0000 (19:29 +0000)]
Expand a few date/time routine names to > 16 characters now that this
 is legal. Fix a little whitespace in other declarations.

26 years agoFix format to produce actual German style. Affects new "GERMAN" feature only.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:26:31 +0000 (19:26 +0000)]
Fix format to produce actual German style. Affects new "GERMAN" feature only.

26 years agoChange logic slightly to avoid one unnecessary calculation. No big deal.
Thomas G. Lockhart [Tue, 23 Dec 1997 19:24:43 +0000 (19:24 +0000)]
Change logic slightly to avoid one unnecessary calculation. No big deal.

26 years agoChange a few routine names back to full length now that pg_proc allows
Thomas G. Lockhart [Tue, 23 Dec 1997 19:23:09 +0000 (19:23 +0000)]
Change a few routine names back to full length now that pg_proc allows
 names over 16 characters. datet_datetime() -> datetime_datetime(), etc.

26 years agoRemove regression in function.
Bruce Momjian [Tue, 23 Dec 1997 03:27:23 +0000 (03:27 +0000)]
Remove regression in function.

26 years agoFix notty output to show status result. -q option still turns it off.
Bruce Momjian [Mon, 22 Dec 1997 20:03:53 +0000 (20:03 +0000)]
Fix notty output to show status result.  -q option still turns it off.

26 years agoFix for test 0 error.
Bruce Momjian [Mon, 22 Dec 1997 05:56:43 +0000 (05:56 +0000)]
Fix for test 0 error.

26 years agoFix for select 1=1 or 2=2, select 1=1 and 2=2, and select sum(2+2).
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).

26 years agoRemove some recursion in optimizer and clean up some code there.
Bruce Momjian [Sun, 21 Dec 1997 05:18:48 +0000 (05:18 +0000)]
Remove some recursion in optimizer and clean up some code there.

26 years agoPotential fix for Bruce's "test" problem
Marc G. Fournier [Sat, 20 Dec 1997 18:36:26 +0000 (18:36 +0000)]
Potential fix for Bruce's "test" problem

26 years agoFix aggregates on inherited tables.
Bruce Momjian [Sat, 20 Dec 1997 07:59:44 +0000 (07:59 +0000)]
Fix aggregates on inherited tables.

26 years agoMove more to dynloader subdir
Marc G. Fournier [Sat, 20 Dec 1997 04:48:11 +0000 (04:48 +0000)]
Move more  to dynloader subdir

26 years agoMake sure distclean works as well as clean
Marc G. Fournier [Sat, 20 Dec 1997 04:43:20 +0000 (04:43 +0000)]
Make sure distclean works as well as clean

26 years agoMissed a HAVE_
Marc G. Fournier [Sat, 20 Dec 1997 04:26:27 +0000 (04:26 +0000)]
Missed a HAVE_

26 years agofix so that dynloader.h is included instead of port-protos.h
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

26 years agoFix use of variable in Makefile.in
Marc G. Fournier [Sat, 20 Dec 1997 04:10:35 +0000 (04:10 +0000)]
Fix use of variable in Makefile.in

26 years agoMake sure configure reflects changes
Marc G. Fournier [Sat, 20 Dec 1997 03:41:06 +0000 (03:41 +0000)]
Make sure configure reflects changes

26 years agoOops, forgot to add what I took away
Marc G. Fournier [Sat, 20 Dec 1997 03:38:20 +0000 (03:38 +0000)]
Oops, forgot to add what I took away

26 years agoMore cleanups...
Marc G. Fournier [Sat, 20 Dec 1997 03:36:35 +0000 (03:36 +0000)]
More cleanups...

26 years agoMore ports switched over
Marc G. Fournier [Sat, 20 Dec 1997 03:23:46 +0000 (03:23 +0000)]
More ports switched over

26 years agoMove over the BSDi port files
Marc G. Fournier [Sat, 20 Dec 1997 03:13:59 +0000 (03:13 +0000)]
Move over the BSDi port files

26 years agoThis should get the linux port to work...
Marc G. Fournier [Sat, 20 Dec 1997 02:36:26 +0000 (02:36 +0000)]
This should get the linux port to work...

26 years agoGet it so that everything else *should* work with my changes...
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...

26 years agoMajor cleanout of PORTNAME variables from Makefiles...bound to screw up
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...

26 years agoFirst clean compile without a "PORTNAME" variable being set...
Marc G. Fournier [Sat, 20 Dec 1997 00:11:13 +0000 (00:11 +0000)]
First clean compile without a "PORTNAME" variable being set...

26 years agoremoved the port-protos.h from bsd a little too quick...remedied now
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

26 years agoIf this doesn't break something, nothing will *muhahaha*
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

26 years agoThese files will get link'd to 'dynloader.[ch]', from configure, which
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

26 years agoMore removal of port dependent stuff
Marc G. Fournier [Fri, 19 Dec 1997 22:56:03 +0000 (22:56 +0000)]
More removal of port dependent stuff

26 years agoMore cleanups. Move alot of the prototype definitions straight into
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...

26 years agoGet rid of PORTNAME from Makefile.global.in...
Marc G. Fournier [Fri, 19 Dec 1997 21:29:28 +0000 (21:29 +0000)]
Get rid of PORTNAME from Makefile.global.in...

26 years agoAdd regression output from FreeBSD
Marc G. Fournier [Fri, 19 Dec 1997 21:23:19 +0000 (21:23 +0000)]
Add regression output from FreeBSD

26 years agoReplace foo/bar to l1/l2.
Bruce Momjian [Fri, 19 Dec 1997 16:54:15 +0000 (16:54 +0000)]
Replace foo/bar to l1/l2.

26 years agoHere is the difference between expected->results of the regression
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

26 years agoMore cleanups...only need one rusagestub.h
Marc G. Fournier [Fri, 19 Dec 1997 13:35:17 +0000 (13:35 +0000)]
More cleanups...only need one rusagestub.h

26 years agoremove port from OBJS line...
Marc G. Fournier [Fri, 19 Dec 1997 13:28:06 +0000 (13:28 +0000)]
remove port from OBJS line...

26 years agoNice clean compile...still need to run regression tests, but its a major
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

26 years agoUpdate configure so that it auto-detects and configures for missing
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...

26 years agoOkay, that's it for tonight...broke a few ports, most likely, but that
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 :)

26 years agoMore cleanups
Marc G. Fournier [Fri, 19 Dec 1997 02:56:35 +0000 (02:56 +0000)]
More cleanups

26 years agoMore cleanups...several ports are major redundancies of other ports
Marc G. Fournier [Fri, 19 Dec 1997 02:46:25 +0000 (02:46 +0000)]
More cleanups...several ports are major redundancies of other ports

26 years agoport.c no longer required...individual functions that were in there are
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

26 years agoMore cleanups. I can now compile without PORTNAME being defined n
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 :)

26 years agocopy query cleanup.
Bruce Momjian [Thu, 18 Dec 1997 19:46:37 +0000 (19:46 +0000)]
copy query cleanup.

26 years agoRemove init_query_planner(), merged into planner().
Bruce Momjian [Thu, 18 Dec 1997 19:41:44 +0000 (19:41 +0000)]
Remove init_query_planner(), merged into planner().

26 years agoFix copy for no aggregates.
Bruce Momjian [Thu, 18 Dec 1997 19:13:49 +0000 (19:13 +0000)]
Fix copy for no aggregates.

26 years agoRemove Existential, and ifdef out generate_fjoin. Neither did anything.
Bruce Momjian [Thu, 18 Dec 1997 12:54:45 +0000 (12:54 +0000)]
Remove Existential, and ifdef out generate_fjoin.  Neither did anything.

26 years agoCost cleanup.
Bruce Momjian [Thu, 18 Dec 1997 12:30:44 +0000 (12:30 +0000)]
Cost cleanup.

26 years agoCost cleanup.
Bruce Momjian [Thu, 18 Dec 1997 12:21:02 +0000 (12:21 +0000)]
Cost cleanup.

26 years agoCleanup of agg copy.
Bruce Momjian [Thu, 18 Dec 1997 05:58:40 +0000 (05:58 +0000)]
Cleanup of agg copy.

26 years agoCleanup of agg copy.
Bruce Momjian [Thu, 18 Dec 1997 04:33:31 +0000 (04:33 +0000)]
Cleanup of agg copy.

26 years agoFix Query handling for inheritance, and cost computations.
Bruce Momjian [Thu, 18 Dec 1997 03:03:41 +0000 (03:03 +0000)]
Fix Query handling for inheritance, and cost computations.

26 years agoEnable timespan_finite() and text_timespan() routines (was commented out).
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.

26 years agoMove declarations for timespan2tm() and tm2timespan() from dt.c to here.
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.

26 years agoRename Query label so ctags finds real structure.
Bruce Momjian [Wed, 17 Dec 1997 18:21:37 +0000 (18:21 +0000)]
Rename Query label so ctags finds real structure.

26 years agoAdd optimizer README file.
Bruce Momjian [Wed, 17 Dec 1997 18:02:33 +0000 (18:02 +0000)]
Add optimizer README file.

26 years agoFirst pass through, of many to come, towards making the whole source
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

26 years agoMakefile cleaned up
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

26 years agoClean up the Makefiles
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

26 years agoMake it entirely possible for PORTNAME to be undefined
Marc G. Fournier [Wed, 17 Dec 1997 04:03:30 +0000 (04:03 +0000)]
Make it entirely possible for PORTNAME to be undefined

26 years agoAdd recognition for 'machten'
Marc G. Fournier [Wed, 17 Dec 1997 03:23:52 +0000 (03:23 +0000)]
Add recognition for 'machten'

26 years agoMention PST8PDT explicitly in the banner message (rather than PST/PDT).
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).

26 years agoDefine text, varchar, and bpchar string length functions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:59:11 +0000 (15:59 +0000)]
Define text, varchar, and bpchar string length functions.

26 years agoUse MAXPGPATH to declare size of socket name storage.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:58:14 +0000 (15:58 +0000)]
Use MAXPGPATH to declare size of socket name storage.

26 years agoUse environment variable PGDATESTYLE on backend startup to initialize
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.

26 years agoAdd declarations for text, bpchar, and varchar length functions.
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 ...".

26 years agoAdd declarations for text, bpchar, and varchar length functions.
Thomas G. Lockhart [Tue, 16 Dec 1997 15:53:17 +0000 (15:53 +0000)]
Add declarations for text, bpchar, and varchar length functions.

26 years agoAllow multiple-argument functions in constraint clauses.
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.

26 years agoImprove (well, ok, fix) generated constraint name for column CHECK clause.
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.

26 years agoFix order of keywords, must be alphabetical.
Bruce Momjian [Tue, 16 Dec 1997 05:04:00 +0000 (05:04 +0000)]
Fix order of keywords, must be alphabetical.

26 years agoFix for user password packet processing, from Goran Thyni.
Bruce Momjian [Mon, 15 Dec 1997 22:03:59 +0000 (22:03 +0000)]
Fix for user password packet processing, from Goran Thyni.

26 years agoMake password null on startup.
Bruce Momjian [Fri, 12 Dec 1997 16:26:36 +0000 (16:26 +0000)]
Make password null on startup.

26 years agoRename pg_plan and pg_eval to be more meaningful.
Bruce Momjian [Thu, 11 Dec 1997 17:36:58 +0000 (17:36 +0000)]
Rename pg_plan and pg_eval to be more meaningful.

26 years agoRemove PGDATA setting and use DataDir.
Bruce Momjian [Thu, 11 Dec 1997 17:03:52 +0000 (17:03 +0000)]
Remove PGDATA setting and use DataDir.

26 years agoSpark/Linux patch for locking, from Tom Szybist
Bruce Momjian [Tue, 9 Dec 1997 20:55:33 +0000 (20:55 +0000)]
Spark/Linux patch for locking, from Tom Szybist

26 years agoMajor code cleanup following the pg_password insertion...
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

26 years agoInclude informational messages added for implicit index creation.
Thomas G. Lockhart [Tue, 9 Dec 1997 01:46:31 +0000 (01:46 +0000)]
Include informational messages added for implicit index creation.

26 years agoAdd information message about implicitly created indices.
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.

26 years agoRemove trailing period from an elog message.
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.

26 years agoMore VARHDRSZ additions.
Bruce Momjian [Mon, 8 Dec 1997 04:42:48 +0000 (04:42 +0000)]
More VARHDRSZ additions.

26 years agoAdd error check on getenv("DATADIR")
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

26 years agoAdd VARHDRSZ where needed. Many places just used 4.
Bruce Momjian [Sat, 6 Dec 1997 22:57:36 +0000 (22:57 +0000)]
Add VARHDRSZ where needed.  Many places just used 4.

26 years agoAllow logging of output to syslog or /tmp/postgres.log.
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.

26 years agoAdd test for multi-character char().
Thomas G. Lockhart [Fri, 5 Dec 1997 01:14:55 +0000 (01:14 +0000)]
Add test for multi-character char().

26 years agoFix tolower loops to go in proper direction for cache.
Bruce Momjian [Fri, 5 Dec 1997 01:13:24 +0000 (01:13 +0000)]
Fix tolower loops to go in  proper direction for cache.

26 years agoI found one other change that I would like to make to the
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>

26 years agoChange constraint syntax to SQL92 style.
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.