]> granicus.if.org Git - postgresql/log
postgresql
23 years agoRevert shlib changes.
Bruce Momjian [Sat, 10 Feb 2001 16:26:38 +0000 (16:26 +0000)]
Revert shlib changes.

23 years agoRemove protcol option buttons.
Bruce Momjian [Sat, 10 Feb 2001 16:25:10 +0000 (16:25 +0000)]
Remove protcol option buttons.

23 years agoODBC BSD/OS fix.
Bruce Momjian [Sat, 10 Feb 2001 15:59:16 +0000 (15:59 +0000)]
ODBC BSD/OS fix.

23 years agocleanup
Bruce Momjian [Sat, 10 Feb 2001 12:07:12 +0000 (12:07 +0000)]
cleanup

23 years agoAdd URL for my2pg.pl.
Bruce Momjian [Sat, 10 Feb 2001 11:59:36 +0000 (11:59 +0000)]
Add URL for my2pg.pl.

23 years agoAdd description.
Bruce Momjian [Sat, 10 Feb 2001 11:53:14 +0000 (11:53 +0000)]
Add description.

23 years agoAdd both conversion utilities.
Bruce Momjian [Sat, 10 Feb 2001 11:46:00 +0000 (11:46 +0000)]
Add both conversion utilities.

23 years agocleanup
Bruce Momjian [Sat, 10 Feb 2001 11:43:33 +0000 (11:43 +0000)]
cleanup

23 years agoAdd other mysql conversion utility for comparisons.
Bruce Momjian [Sat, 10 Feb 2001 11:43:12 +0000 (11:43 +0000)]
Add other mysql conversion utility for comparisons.

23 years agoAllow -Bsymbolic on BSDI for ODBC.
Bruce Momjian [Sat, 10 Feb 2001 11:31:35 +0000 (11:31 +0000)]
Allow -Bsymbolic on BSDI for ODBC.

23 years agoFix on Linux
Peter Eisentraut [Sat, 10 Feb 2001 10:27:28 +0000 (10:27 +0000)]
Fix on Linux

23 years agoMinor improvements and copy-editing.
Tom Lane [Sat, 10 Feb 2001 08:30:13 +0000 (08:30 +0000)]
Minor improvements and copy-editing.

23 years agoMore ODBC formatting cleanup.
Bruce Momjian [Sat, 10 Feb 2001 07:11:28 +0000 (07:11 +0000)]
More ODBC formatting cleanup.

23 years agoFix example of syntactic ambiguity between prefix/infix/postfix operators
Tom Lane [Sat, 10 Feb 2001 07:08:44 +0000 (07:08 +0000)]
Fix example of syntactic ambiguity between prefix/infix/postfix operators
--- Postgres now accepts the example we claimed it wouldn't.  Miscellaneous
copy-editing as well.

23 years agoRun pgindent over ODBC source. We couldn't do this years ago because we
Bruce Momjian [Sat, 10 Feb 2001 07:01:19 +0000 (07:01 +0000)]
Run pgindent over ODBC source.  We couldn't do this years ago because we
weren't the master source.  We are now, and it really needs it.

23 years agoRemove protocol-dependent code. This should have been on previous commit.
Bruce Momjian [Sat, 10 Feb 2001 06:58:40 +0000 (06:58 +0000)]
Remove protocol-dependent code.  This should have been on previous commit.

23 years agoCleanup
Bruce Momjian [Sat, 10 Feb 2001 06:57:53 +0000 (06:57 +0000)]
Cleanup

23 years agoMore cleanup, again not sure it works.
Bruce Momjian [Sat, 10 Feb 2001 06:12:15 +0000 (06:12 +0000)]
More cleanup, again not sure it works.

23 years agoClean up bad variable used in script. Still not sure it works under Linux.
Bruce Momjian [Sat, 10 Feb 2001 05:55:17 +0000 (05:55 +0000)]
Clean up bad variable used in script.  Still not sure it works under Linux.

23 years agoProperly exit ODBC with 'X', allow linking on BSD/OS.
Bruce Momjian [Sat, 10 Feb 2001 05:50:29 +0000 (05:50 +0000)]
Properly exit ODBC with 'X', allow linking on BSD/OS.

23 years agoFix documentation of EXECUTE, add documentation of FOR ... EXECUTE.
Tom Lane [Sat, 10 Feb 2001 05:32:33 +0000 (05:32 +0000)]
Fix documentation of EXECUTE, add documentation of FOR ... EXECUTE.

23 years agoFix byte-vs-word-width oversight in m68k TAS() code.
Tom Lane [Sat, 10 Feb 2001 04:07:25 +0000 (04:07 +0000)]
Fix byte-vs-word-width oversight in m68k TAS() code.
Man, this brings back some old memories ...

23 years agoUpdate findoidjoins notes for 7.1.
Tom Lane [Sat, 10 Feb 2001 03:57:42 +0000 (03:57 +0000)]
Update findoidjoins notes for 7.1.

23 years agoCompile a little more cleanly.
Tom Lane [Sat, 10 Feb 2001 03:44:54 +0000 (03:44 +0000)]
Compile a little more cleanly.

23 years agoAdd oid2name subdirectory to contrib Makefile.
Tom Lane [Sat, 10 Feb 2001 03:44:06 +0000 (03:44 +0000)]
Add oid2name subdirectory to contrib Makefile.

23 years agoIgnore leading whitespace when trying to determine statement type,
Tom Lane [Sat, 10 Feb 2001 03:12:16 +0000 (03:12 +0000)]
Ignore leading whitespace when trying to determine statement type,
so that ODBC driver doesn't go belly up by failing to recognize a
SELECT as such.

23 years agoRestructure the key include files per recent pghackers discussion: there
Tom Lane [Sat, 10 Feb 2001 02:31:31 +0000 (02:31 +0000)]
Restructure the key include files per recent pghackers discussion: there
are now separate files "postgres.h" and "postgres_fe.h", which are meant
to be the primary include files for backend .c files and frontend .c files
respectively.  By default, only include files meant for frontend use are
installed into the installation include directory.  There is a new make
target 'make install-all-headers' that adds the whole content of the
src/include tree to the installed fileset, for use by people who want to
develop server-side code without keeping the complete source tree on hand.
Cleaned up a whole lot of crufty and inconsistent header inclusions.

23 years agoUpdate section about how to start server from boot scripts.
Peter Eisentraut [Sat, 10 Feb 2001 00:50:18 +0000 (00:50 +0000)]
Update section about how to start server from boot scripts.

23 years agoAdd new FreeBSD start script that makes use of new pg_ctl functionality.
Peter Eisentraut [Sat, 10 Feb 2001 00:13:23 +0000 (00:13 +0000)]
Add new FreeBSD start script that makes use of new pg_ctl functionality.

23 years agoRemove last code that assumed xinv/xinx are large object files.
Bruce Momjian [Fri, 9 Feb 2001 22:23:47 +0000 (22:23 +0000)]
Remove last code that assumed xinv/xinx are large object files.

23 years agoAvoid a particular <simplelist>. jadetex has formatting problems,
Peter Eisentraut [Fri, 9 Feb 2001 20:38:15 +0000 (20:38 +0000)]
Avoid a particular <simplelist>.  jadetex has formatting problems,
apparently when the content is long enough to require line breaks.

23 years agoMake more portable.
Peter Eisentraut [Fri, 9 Feb 2001 20:24:08 +0000 (20:24 +0000)]
Make more portable.

23 years agoThis hasn't been used for anything for a long time...
Tom Lane [Fri, 9 Feb 2001 19:26:45 +0000 (19:26 +0000)]
This hasn't been used for anything for a long time...

23 years agoLarge object manual updates.
Bruce Momjian [Fri, 9 Feb 2001 19:24:09 +0000 (19:24 +0000)]
Large object manual updates.

23 years agoRemove link to dead subdirectory 'linux'.
Tom Lane [Fri, 9 Feb 2001 18:42:35 +0000 (18:42 +0000)]
Remove link to dead subdirectory 'linux'.

23 years agoMention NetBSD
Bruce Momjian [Fri, 9 Feb 2001 17:55:48 +0000 (17:55 +0000)]
Mention NetBSD

23 years agoRemove pg_service mention.
Bruce Momjian [Fri, 9 Feb 2001 17:53:44 +0000 (17:53 +0000)]
Remove pg_service mention.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 17:37:49 +0000 (17:37 +0000)]
Update TODO list.

23 years agoWhen updating a tuple containing compressed-in-line fields, do not
Tom Lane [Fri, 9 Feb 2001 17:30:03 +0000 (17:30 +0000)]
When updating a tuple containing compressed-in-line fields, do not
decompress the existing fields unnecessarily.

23 years agoAdd -g as synonmym for --globals-only in pg_dumpall. Add info about
Bruce Momjian [Fri, 9 Feb 2001 17:16:57 +0000 (17:16 +0000)]
Add -g as synonmym for --globals-only in pg_dumpall.  Add info about
-c,--clean option to manual page.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:22:22 +0000 (15:22 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:20:54 +0000 (15:20 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Fri, 9 Feb 2001 15:15:09 +0000 (15:15 +0000)]
Update TODO list.

23 years agoI have deleted the include of termios.h in include/port/qnx4.h.
Bruce Momjian [Fri, 9 Feb 2001 15:13:49 +0000 (15:13 +0000)]
I have deleted the include of termios.h in include/port/qnx4.h.
Then I recompiled pgsql and I have compiled a program with ecpg.

I have removed the termios.h, and the ECHO hack.

Thanks
Maurizio

23 years agoChange SELECT to not trigger "BEGIN" in not autocommit mode.
Hiroshi Inoue [Fri, 9 Feb 2001 06:03:14 +0000 (06:03 +0000)]
Change SELECT to not trigger "BEGIN" in not autocommit mode.

23 years agoplpgsql's private copy of xlateSqlType was out of sync. Again. This
Tom Lane [Fri, 9 Feb 2001 03:26:28 +0000 (03:26 +0000)]
plpgsql's private copy of xlateSqlType was out of sync.  Again.  This
is clearly not maintainable, so dike it out in favor of calling the real
version in the backend's gram.y.

23 years agoDocument PL/TclU language variant, and do some minor copy-editing.
Tom Lane [Fri, 9 Feb 2001 03:06:38 +0000 (03:06 +0000)]
Document PL/TclU language variant, and do some minor copy-editing.

23 years agoRestructure discussion of PL installation to emphasize createlang as the
Tom Lane [Fri, 9 Feb 2001 02:20:52 +0000 (02:20 +0000)]
Restructure discussion of PL installation to emphasize createlang as the
recommended install procedure, rather than mentioning it as an afterthought.

23 years agoRemove no-longer-needed mklang script; now superseded by createlang.
Tom Lane [Fri, 9 Feb 2001 01:05:42 +0000 (01:05 +0000)]
Remove no-longer-needed mklang script; now superseded by createlang.

23 years agoEXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
Tom Lane [Fri, 9 Feb 2001 00:14:26 +0000 (00:14 +0000)]
EXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
rather than executing the INTO clause with non-plpgsql semantics
as it was doing for the last few weeks/months.  This keeps our options
open for making it do the right plpgsql-ish thing in future without
creating a backwards compatibility problem.  There is no loss of
functionality since people can get the same behavior with CREATE TABLE AS.

23 years agoRemove outdated contrib/linux start scripts. Beat some sense into
Peter Eisentraut [Thu, 8 Feb 2001 19:53:33 +0000 (19:53 +0000)]
Remove outdated contrib/linux start scripts.  Beat some sense into
contrib/init.d start script.  Place into more aptly named directory.  Maybe
we could add scripts for other platforms here later.

23 years agoMake -w the default for shut down, add -W option to specify no wait.
Peter Eisentraut [Thu, 8 Feb 2001 19:39:24 +0000 (19:39 +0000)]
Make -w the default for shut down, add -W option to specify no wait.
Add -l option to name log file.  Set umask to 077.
Proper file descriptor redirection to allow postmaster to detach from
shell's process group.
Add -s option to turn off informational messages.

23 years agoUPdate file from Patrick.
Bruce Momjian [Thu, 8 Feb 2001 04:57:24 +0000 (04:57 +0000)]
UPdate file from Patrick.

23 years agoFix a misuse of 'char *' declaration.
Hiroshi Inoue [Thu, 8 Feb 2001 01:54:29 +0000 (01:54 +0000)]
Fix a misuse of 'char *' declaration.

23 years agoWhen launching a child backend, take care to close file descriptors for
Tom Lane [Thu, 8 Feb 2001 00:35:10 +0000 (00:35 +0000)]
When launching a child backend, take care to close file descriptors for
any other client connections that may exist (which would only happen if
another client is currently in the authentication cycle).  This avoids
wastage of open descriptors in a child.  It might also explain peculiar
behaviors like not closing connections when expected, since the kernel
will probably not signal EOF as long as some other backend is randomly
holding open a reference to the connection, even if the client went away
long since ...

23 years agoFixBTree flag still exists and may be used to turn
Vadim B. Mikheev [Wed, 7 Feb 2001 23:36:22 +0000 (23:36 +0000)]
FixBTree flag still exists and may be used to turn
runtime recovery OFF.

23 years agoRuntime btree recovery is now ON by default.
Vadim B. Mikheev [Wed, 7 Feb 2001 23:35:33 +0000 (23:35 +0000)]
Runtime btree recovery is now ON by default.

23 years agoMacro for btree runtime fix.
Vadim B. Mikheev [Wed, 7 Feb 2001 23:34:18 +0000 (23:34 +0000)]
Macro for btree runtime fix.

23 years agoRepair postmaster memory leakage during password authentication.
Tom Lane [Wed, 7 Feb 2001 23:31:38 +0000 (23:31 +0000)]
Repair postmaster memory leakage during password authentication.

23 years agoRedo pgaccess' queries about views so that they will work in both 7.1
Tom Lane [Wed, 7 Feb 2001 21:30:12 +0000 (21:30 +0000)]
Redo pgaccess' queries about views so that they will work in both 7.1
and prior releases --- rely on pg_views view instead of direct access
to pg_class and pg_rewrite.

23 years agoNot sure why this work script was in the repository ... but it doesn't
Tom Lane [Wed, 7 Feb 2001 21:25:55 +0000 (21:25 +0000)]
Not sure why this work script was in the repository ... but it doesn't
belong ...

23 years agoMinor copy-editing.
Tom Lane [Wed, 7 Feb 2001 20:46:55 +0000 (20:46 +0000)]
Minor copy-editing.

23 years agoUse explicit path to libpgtcl.so, instead of relying on LD_LIBRARY_PATH
Tom Lane [Wed, 7 Feb 2001 20:30:20 +0000 (20:30 +0000)]
Use explicit path to libpgtcl.so, instead of relying on LD_LIBRARY_PATH
or local equivalent.  Also, honor --with-pgport configure option for
default port number, and allow PGPORT environment variable to override
this.

23 years agoMake DEF_PGPORT available to Makefiles, so it can be substituted into
Tom Lane [Wed, 7 Feb 2001 20:13:27 +0000 (20:13 +0000)]
Make DEF_PGPORT available to Makefiles, so it can be substituted into
scripts like pgaccess.

23 years agoActually, it looks like DEF_PGPORT belongs over in config.h.win32 for
Tom Lane [Wed, 7 Feb 2001 20:00:08 +0000 (20:00 +0000)]
Actually, it looks like DEF_PGPORT belongs over in config.h.win32 for
the Windows build...

23 years agoRemove broken (and unnecessary) definition of DEF_PGPORT.
Tom Lane [Wed, 7 Feb 2001 19:30:22 +0000 (19:30 +0000)]
Remove broken (and unnecessary) definition of DEF_PGPORT.

23 years agoOnly pass the -L* portions of LDFLAGS to the Python build environment.
Peter Eisentraut [Wed, 7 Feb 2001 18:22:10 +0000 (18:22 +0000)]
Only pass the -L* portions of LDFLAGS to the Python build environment.
Other flags can have unpredictable effects when Python uses different
commands to build than we do.

23 years agoNeed to specify DYNAMIC_PATH flag to shl_load, else HPUX's dld will not
Tom Lane [Wed, 7 Feb 2001 17:59:58 +0000 (17:59 +0000)]
Need to specify DYNAMIC_PATH flag to shl_load, else HPUX's dld will not
honor library search path that we so carefully installed into the
executable ...

23 years agoUpdate FAQ.
Bruce Momjian [Wed, 7 Feb 2001 16:33:32 +0000 (16:33 +0000)]
Update FAQ.

23 years agoUpdate FAQ.
Bruce Momjian [Wed, 7 Feb 2001 16:32:47 +0000 (16:32 +0000)]
Update FAQ.

23 years agoSome updates prior to retrieving a fresh cvs copy:
Peter Mount [Wed, 7 Feb 2001 09:13:20 +0000 (09:13 +0000)]
Some updates prior to retrieving a fresh cvs copy:

Tue Feb 06 19:00:00 GMT 2001 peter@retep.org.uk
        - Completed first two TestCase's for the test suite. JUnit is now
          recognised by ant.

23 years agoAdd java.
Bruce Momjian [Wed, 7 Feb 2001 04:50:55 +0000 (04:50 +0000)]
Add java.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Feb 2001 04:50:50 +0000 (04:50 +0000)]
Update TODO list.

23 years agoAdd item.
Bruce Momjian [Wed, 7 Feb 2001 04:48:27 +0000 (04:48 +0000)]
Add item.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Feb 2001 00:52:56 +0000 (00:52 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Wed, 7 Feb 2001 00:52:42 +0000 (00:52 +0000)]
Update TODO list.

23 years agocleaned up.
Bruce Momjian [Tue, 6 Feb 2001 21:38:43 +0000 (21:38 +0000)]
cleaned up.

23 years agoMake it clearer.
Bruce Momjian [Tue, 6 Feb 2001 21:37:55 +0000 (21:37 +0000)]
Make it clearer.

23 years agoOnly use termcap xor [n]curses, depending on what readline needs. Solaris
Peter Eisentraut [Tue, 6 Feb 2001 19:20:16 +0000 (19:20 +0000)]
Only use termcap xor [n]curses, depending on what readline needs.  Solaris
has problems when linking with both.

23 years agoWell, learned the hard way...
Bruce Momjian [Tue, 6 Feb 2001 18:05:13 +0000 (18:05 +0000)]
Well, learned the hard way...

Marko Kreen

23 years agoAdd.
Bruce Momjian [Tue, 6 Feb 2001 18:02:25 +0000 (18:02 +0000)]
Add.

23 years agoUpdate /contrib and TODO.detail.
Bruce Momjian [Tue, 6 Feb 2001 17:47:48 +0000 (17:47 +0000)]
Update /contrib and TODO.detail.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 6 Feb 2001 17:42:37 +0000 (17:42 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 6 Feb 2001 17:42:18 +0000 (17:42 +0000)]
Update TODO list.

23 years agoIf the first argument is --version or --help, skip the root check.
Peter Eisentraut [Tue, 6 Feb 2001 17:00:01 +0000 (17:00 +0000)]
If the first argument is --version or --help, skip the root check.

23 years agoPageAddItem in overwrite mode: must *NOT* check itemid' flag if
Vadim B. Mikheev [Tue, 6 Feb 2001 06:24:00 +0000 (06:24 +0000)]
PageAddItem in overwrite mode: must *NOT* check itemid' flag if
OffsetNumber == MaxOffsetNumber + 1 - there may be garbage there!

23 years agoUpdate FAQ.
Bruce Momjian [Tue, 6 Feb 2001 04:28:50 +0000 (04:28 +0000)]
Update FAQ.

23 years agoImproved version handling introduced by Dave Page.
Hiroshi Inoue [Tue, 6 Feb 2001 02:21:12 +0000 (02:21 +0000)]
Improved version handling introduced by Dave Page.
The driver version is 07.01.0002 now.
1) initialized pg_version by DSN's protocol info
   so that we could always use pg_version info
   once a connection is established (pg_version()
   didn't exist before 6.4). PROTOCOL_XX() macros
   are removed(except from connection.[ch]).
2) provided a few macros to encapsulate connection's
   version info and replaced existent comparison
   stuff by those macros.
3) change SQLTables() so that 7.1 servers could show
   views.

In addtion, the following patch from Dave Page is applied.

  This patch fixes a bug in SQLGetInfo for SQL_DBMS_VER which corrupted the
  driver version string. The driver version number has also been incremented
  to 07.01.0002.

  Regards, Dave. <<odbc.diff>>

23 years agoNow that I look at it, PQoidValue() ain't quite right either.
Tom Lane [Tue, 6 Feb 2001 02:02:27 +0000 (02:02 +0000)]
Now that I look at it, PQoidValue() ain't quite right either.

23 years agoRepair PQoidStatus() bug reported by darcy@druid.net.
Tom Lane [Tue, 6 Feb 2001 02:00:09 +0000 (02:00 +0000)]
Repair PQoidStatus() bug reported by darcy@druid.net.

23 years agoOut-of-bounds memory allocation request sizes should be treated as just
Tom Lane [Tue, 6 Feb 2001 01:53:53 +0000 (01:53 +0000)]
Out-of-bounds memory allocation request sizes should be treated as just
elog(ERROR) not an Assert trap, since we've downgraded out-of-memory to
elog(ERROR) not a fatal error.  Also, change the hard boundary from 256Mb
to 1Gb, just so that anyone who's actually got that much memory to spare
can play with TOAST objects approaching a gigabyte.

23 years agoDocument BETWEEN.
Peter Eisentraut [Mon, 5 Feb 2001 19:21:45 +0000 (19:21 +0000)]
Document BETWEEN.

23 years agoUpdate FAQ.
Bruce Momjian [Mon, 5 Feb 2001 17:37:44 +0000 (17:37 +0000)]
Update FAQ.

23 years agoDump/display 'timestamp' as 'timestamp with time zone', to make room for a
Peter Eisentraut [Mon, 5 Feb 2001 17:35:04 +0000 (17:35 +0000)]
Dump/display 'timestamp' as 'timestamp with time zone', to make room for a
future 'timestamp without time zone', which SQL claims is equivalent to
plain 'timestamp'.

23 years agoMove PL docs to programmer's guide, "storage" chapter to admin guide,
Peter Eisentraut [Sun, 4 Feb 2001 15:28:18 +0000 (15:28 +0000)]
Move PL docs to programmer's guide, "storage" chapter to admin guide,
clean up some things in the affected areas.

23 years agoCheck for -lresolv.
Peter Eisentraut [Sun, 4 Feb 2001 14:09:33 +0000 (14:09 +0000)]
Check for -lresolv.

23 years agoPass LDFLAGS along with LIBS to the Python build stuff, especially to pick
Peter Eisentraut [Sun, 4 Feb 2001 13:21:46 +0000 (13:21 +0000)]
Pass LDFLAGS along with LIBS to the Python build stuff, especially to pick
up -L options.

23 years agoMust run jadetex three times to get correct page numbers. Add support for
Peter Eisentraut [Sun, 4 Feb 2001 12:23:11 +0000 (12:23 +0000)]
Must run jadetex three times to get correct page numbers.  Add support for
pdfjadetex.

23 years agoWhen making xrefs to refsects, the linkend should point to the refsect and
Peter Eisentraut [Sun, 4 Feb 2001 12:18:08 +0000 (12:18 +0000)]
When making xrefs to refsects, the linkend should point to the refsect and
the endterm to the title element, not both to the title.  At least
docbook2man prefers it that way.

23 years agoRe-add Peter E's changes.
Bruce Momjian [Sat, 3 Feb 2001 21:50:45 +0000 (21:50 +0000)]
Re-add Peter E's changes.