OSDN Git Service
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.
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 ...
Bruce Momjian [Wed, 7 Feb 2001 16:33:32 +0000 (16:33 +0000)]
Update FAQ.
Bruce Momjian [Wed, 7 Feb 2001 16:32:47 +0000 (16:32 +0000)]
Update FAQ.
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.
Bruce Momjian [Wed, 7 Feb 2001 04:50:55 +0000 (04:50 +0000)]
Add java.
Bruce Momjian [Wed, 7 Feb 2001 04:50:50 +0000 (04:50 +0000)]
Update TODO list.
Bruce Momjian [Wed, 7 Feb 2001 04:48:27 +0000 (04:48 +0000)]
Add item.
Bruce Momjian [Wed, 7 Feb 2001 00:52:56 +0000 (00:52 +0000)]
Update TODO list.
Bruce Momjian [Wed, 7 Feb 2001 00:52:42 +0000 (00:52 +0000)]
Update TODO list.
Bruce Momjian [Tue, 6 Feb 2001 21:38:43 +0000 (21:38 +0000)]
cleaned up.
Bruce Momjian [Tue, 6 Feb 2001 21:37:55 +0000 (21:37 +0000)]
Make it clearer.
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.
Bruce Momjian [Tue, 6 Feb 2001 18:05:13 +0000 (18:05 +0000)]
Well, learned the hard way...
Marko Kreen
Bruce Momjian [Tue, 6 Feb 2001 18:02:25 +0000 (18:02 +0000)]
Add.
Bruce Momjian [Tue, 6 Feb 2001 17:47:48 +0000 (17:47 +0000)]
Update /contrib and TODO.detail.
Bruce Momjian [Tue, 6 Feb 2001 17:42:37 +0000 (17:42 +0000)]
Update TODO list.
Bruce Momjian [Tue, 6 Feb 2001 17:42:18 +0000 (17:42 +0000)]
Update TODO list.
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.
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!
Bruce Momjian [Tue, 6 Feb 2001 04:28:50 +0000 (04:28 +0000)]
Update FAQ.
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>>
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.
Tom Lane [Tue, 6 Feb 2001 02:00:09 +0000 (02:00 +0000)]
Repair PQoidStatus() bug reported by darcy@druid.net.
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.
Peter Eisentraut [Mon, 5 Feb 2001 19:21:45 +0000 (19:21 +0000)]
Document BETWEEN.
Bruce Momjian [Mon, 5 Feb 2001 17:37:44 +0000 (17:37 +0000)]
Update FAQ.
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'.
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.
Peter Eisentraut [Sun, 4 Feb 2001 14:09:33 +0000 (14:09 +0000)]
Check for -lresolv.
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.
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.
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.
Bruce Momjian [Sat, 3 Feb 2001 21:50:45 +0000 (21:50 +0000)]
Re-add Peter E's changes.
Tom Lane [Sat, 3 Feb 2001 21:17:52 +0000 (21:17 +0000)]
Fix inappropriate attempt to push down qual clauses into a view that
has UNION/INTERSECT/EXCEPT operations. Per bug report from Ferrier.
Peter Eisentraut [Sat, 3 Feb 2001 20:13:05 +0000 (20:13 +0000)]
Use elog() instead of exit() for fatal scanner errors.
Peter Eisentraut [Sat, 3 Feb 2001 19:09:46 +0000 (19:09 +0000)]
Improved wording, from Albert REINER <areiner@tph.tuwien.ac.at>.
Peter Eisentraut [Sat, 3 Feb 2001 19:03:27 +0000 (19:03 +0000)]
Update, polish, consistencify preface/intro sections.
Bruce Momjian [Sat, 3 Feb 2001 04:13:22 +0000 (04:13 +0000)]
Change description.
Vadim B. Mikheev [Fri, 2 Feb 2001 19:49:15 +0000 (19:49 +0000)]
Runtime tree recovery is implemented, just testing is left -:)
Bruce Momjian [Fri, 2 Feb 2001 18:21:59 +0000 (18:21 +0000)]
Apply patches for QNX from Maurizio
Bruce Momjian [Thu, 1 Feb 2001 19:13:47 +0000 (19:13 +0000)]
A patch for the GROUP BY/HAVING example. p.date should be s.date.
Robert B. Easter
Bruce Momjian [Thu, 1 Feb 2001 18:31:10 +0000 (18:31 +0000)]
Please replace with the one attached to this email message. The
previous version depended on the below patch, this one does not. It is
also a bit cleaner and has a few more helpful comments.
Ryan Kirkpatrick
Michael Meskes [Wed, 31 Jan 2001 16:12:34 +0000 (16:12 +0000)]
Applied two bug fixes by Christof Petig.
Peter Mount [Wed, 31 Jan 2001 09:23:45 +0000 (09:23 +0000)]
Wed Jan 31 08:46:00 GMT 2001 peter@retep.org.uk
- Some minor additions to Statement to make our own extensions more
portable.
- Statement.close() will now call ResultSet.close() rather than just
dissasociating with it.
Peter Mount [Wed, 31 Jan 2001 08:26:02 +0000 (08:26 +0000)]
Tue Jan 30 22:24:00 GMT 2001 peter@retep.org.uk
- Fixed bug where Statement.setMaxRows() was a global setting. Now
limited to just itself.
- Changed LargeObject.read(byte[],int,int) to return the actual number
of bytes read (used to be void).
- LargeObject now supports InputStream's!
- PreparedStatement.setBinaryStream() now works!
- ResultSet.getBinaryStream() now returns an InputStream that doesn't
copy the blob into memory first!
- Connection.isClosed() now tests to see if the connection is still alive
rather than if it thinks it's alive.
Vadim B. Mikheev [Wed, 31 Jan 2001 01:08:36 +0000 (01:08 +0000)]
Couple additional functions to fix tree at runtime.
Need in one more function to handle "my bits moved..."
case. FixBTree is still FALSE.
Bruce Momjian [Tue, 30 Jan 2001 17:37:49 +0000 (17:37 +0000)]
Update /contrib README and add init.d from Ryan.
Bruce Momjian [Mon, 29 Jan 2001 18:58:45 +0000 (18:58 +0000)]
Update HISTORY/release with current changes.
Bruce Momjian [Mon, 29 Jan 2001 17:57:41 +0000 (17:57 +0000)]
Update TODO list.
Bruce Momjian [Mon, 29 Jan 2001 17:57:26 +0000 (17:57 +0000)]
Remove unused TODO.detail functions.
Bruce Momjian [Mon, 29 Jan 2001 17:52:47 +0000 (17:52 +0000)]
Remove subquery.
Bruce Momjian [Mon, 29 Jan 2001 17:50:26 +0000 (17:50 +0000)]
Update TODO list.
Bruce Momjian [Mon, 29 Jan 2001 17:48:11 +0000 (17:48 +0000)]
Update TODO list.
Bruce Momjian [Mon, 29 Jan 2001 16:27:48 +0000 (16:27 +0000)]
Update to PyGreSQL-3.1
Vadim B. Mikheev [Mon, 29 Jan 2001 07:28:17 +0000 (07:28 +0000)]
Call _bt_fixroot() from _bt_insertonpg.
Marc G. Fournier [Mon, 29 Jan 2001 02:52:30 +0000 (02:52 +0000)]
update configure to beta4
Install a ChangeLog file from beta3->beta4
Bruce Momjian [Mon, 29 Jan 2001 01:23:36 +0000 (01:23 +0000)]
Update FAQ.
Tom Lane [Mon, 29 Jan 2001 00:39:20 +0000 (00:39 +0000)]
Clean up handling of tuple descriptors so that result-tuple descriptors
allocated by plan nodes are not leaked at end of query. This doesn't
really matter for normal queries, but it sure does for queries invoked
repetitively inside SQL functions. Clean up some other grotty code
associated with tupdescs, and fix a few other memory leaks exposed by
tests with simple SQL functions.
Bruce Momjian [Mon, 29 Jan 2001 00:11:41 +0000 (00:11 +0000)]
The following patch is required for successful compilation on Irix.
Robert E. Bruccole
Bruce Momjian [Sun, 28 Jan 2001 17:43:54 +0000 (17:43 +0000)]
Update FAQ.
Bruce Momjian [Sun, 28 Jan 2001 17:42:12 +0000 (17:42 +0000)]
Update FAQ.
Bruce Momjian [Sun, 28 Jan 2001 17:39:44 +0000 (17:39 +0000)]
Update FAQ.
Bruce Momjian [Sun, 28 Jan 2001 15:42:42 +0000 (15:42 +0000)]
Update TODO list.
Bruce Momjian [Sun, 28 Jan 2001 15:41:58 +0000 (15:41 +0000)]
Update TODO list.
Bruce Momjian [Sun, 28 Jan 2001 15:18:45 +0000 (15:18 +0000)]
Update FAQ.
Bruce Momjian [Sun, 28 Jan 2001 05:05:11 +0000 (05:05 +0000)]
Update TODO list.
Philip Warner [Sun, 28 Jan 2001 03:47:49 +0000 (03:47 +0000)]
Used LEFT OUTER JOIN for various queries
Philip Warner [Sun, 28 Jan 2001 02:57:06 +0000 (02:57 +0000)]
Applied (slightly modified) patches from Tatsuo:
Ok. I have made patches for fixing some of pg_dump problems(see
attached patches). The patches address the problem with user defined
functions, operators and aggregates.
Bruce Momjian [Sat, 27 Jan 2001 21:49:59 +0000 (21:49 +0000)]
Here is an update on the Win32 patch. Modified files are 'config.h.win32'
and two 'win32.mak'. Addresses the following:
1) Oops. Spelled fcntl.h wrong in the last one. D'uh.
2) PG_VERSION changed to be defined with " around it. psql/command.c failed
to compile without that.
3) Changed makefiles to use "/MD" and link both psql and libpq.dll against
MSVCRT.DLL instead of a static library. This takes care of the
crash-upon-free in psql.
I *think* this is what is on the "Open 7.1 Items" list as "Magnus Hagander
ODBC Issues?". It has nothing to do with ODBC, but it's the only issue I've
been involved with...
Magnus Hagander
Bruce Momjian [Sat, 27 Jan 2001 20:19:34 +0000 (20:19 +0000)]
Update FAQ.
Bruce Momjian [Sat, 27 Jan 2001 19:49:45 +0000 (19:49 +0000)]
Add 'foreign' file.
Bruce Momjian [Sat, 27 Jan 2001 18:36:24 +0000 (18:36 +0000)]
Add missing pgaccess files.
Bruce Momjian [Sat, 27 Jan 2001 18:34:38 +0000 (18:34 +0000)]
Update to pgaccess 0.98.7.
Philip Warner [Sat, 27 Jan 2001 12:35:29 +0000 (12:35 +0000)]
When dropping the schema, reconnect as owner of each object.
Peter Eisentraut [Sat, 27 Jan 2001 11:12:53 +0000 (11:12 +0000)]
Make into appendix, correct some items.
Peter Eisentraut [Sat, 27 Jan 2001 10:19:52 +0000 (10:19 +0000)]
Add permission check for CHECKPOINT.
Tom Lane [Sat, 27 Jan 2001 07:23:48 +0000 (07:23 +0000)]
Fix failure to create sequences for more than one SERIAL column in a
table.
Bruce Momjian [Sat, 27 Jan 2001 05:49:12 +0000 (05:49 +0000)]
Update TODO list.
Bruce Momjian [Sat, 27 Jan 2001 05:40:51 +0000 (05:40 +0000)]
Update TODO list.
Tom Lane [Sat, 27 Jan 2001 05:16:58 +0000 (05:16 +0000)]
Looks like I broke cases involving combinations of deferred update/delete
triggers ... oops ... but the regress tests should have covered this ...
Bruce Momjian [Sat, 27 Jan 2001 05:07:28 +0000 (05:07 +0000)]
in the tutorial, chapter 2., "Relational Data Model Formalities"
(sql490.htm), there is
"set of all k-tuples v1, v2, ... vk, such that v1 [isin] D1, v1 [isin] D1"
i assume it should be
"set of all k-tuples v1, v2, ... vk, such that v1 [isin] D1, v2 [isin] D2"
Divide by Zero
Bruce Momjian [Sat, 27 Jan 2001 04:42:56 +0000 (04:42 +0000)]
Update TODO list.
Tom Lane [Sat, 27 Jan 2001 04:42:32 +0000 (04:42 +0000)]
Don't crash if subquery appears multiple times in jointree. This should
not happen anyway, but let's try not to get completely confused if it does
(due to rewriter bugs or whatever).
Tom Lane [Sat, 27 Jan 2001 04:40:59 +0000 (04:40 +0000)]
Repair bug reported by Huxton, 1/24/01. We need to include a rule's
original table ('OLD' table) in its join tree if OLD is referenced by
either the rule action, the rule qual, or the original query qual that
will be added to the rule action. However, we only want one instance
of the original table to be included; so beware of the possibility that
the rule action already has a jointree entry for OLD.
Bruce Momjian [Sat, 27 Jan 2001 04:38:54 +0000 (04:38 +0000)]
Update FAQ.
Bruce Momjian [Sat, 27 Jan 2001 04:35:16 +0000 (04:35 +0000)]
Update FAQ.
Bruce Momjian [Sat, 27 Jan 2001 04:26:37 +0000 (04:26 +0000)]
Just a quick patch to make the geometry test on Sparc/Linux
regression tests for Pgsql 7.1beta3 pass. This is very similr to the one I
submitted back in July for Linux/Alpha. Apparently non-x86 Linux machines
like to compute nth place float point digits like Sun/Solaris does?
Otherwise, 7.1beta3 runs without problems (i.e. all other
regression tests pass) on my Sparc 20 running Debian GNU/Linux 2.2.
Ryan Kirkpatrick
Tom Lane [Sat, 27 Jan 2001 01:44:20 +0000 (01:44 +0000)]
Refuse to try to attach a condition to a NOTIFY or other utility statement,
rather than coredumping (as prior 7.1 code did) or silently dropping the
condition (as 7.0 did). This is annoying but there doesn't seem to be
any good way to fix it, short of a major querytree restructuring.
Tom Lane [Sat, 27 Jan 2001 01:41:19 +0000 (01:41 +0000)]
Suppress coredump when EXPLAINing query that is rewritten to include
a NOTIFY.
Tom Lane [Sat, 27 Jan 2001 00:05:31 +0000 (00:05 +0000)]
Re-read Unix-socket lock file every so often (every CheckPoint interval,
actually) to ensure that its file access time doesn't get old enough to
tempt a /tmp directory cleaner to remove it. Still another reason we
should never have put the sockets in /tmp in the first place ...
Peter Eisentraut [Fri, 26 Jan 2001 23:40:39 +0000 (23:40 +0000)]
Clean up markup, add description of contrib/array operators by Joel Burton
<jburton@scw.org>.
Tom Lane [Fri, 26 Jan 2001 22:50:26 +0000 (22:50 +0000)]
Change float8-to-int8 conversion to round to nearest, rather than
truncating to integer. Remove regress test that checks whether
4567890123456789 can be converted to float without loss; since that's
52 bits, it's on the hairy edge of failing with IEEE float8s, and indeed
rint seems to give platform-dependent results for it.
Bruce Momjian [Fri, 26 Jan 2001 22:41:59 +0000 (22:41 +0000)]
odbc1.diff changes the text on the Protocol Radio buttons on the driver
dialogue from '6.4/6.5' to '6.5+' and removes some C++ comments from
resource.h (which VC++ insists on putting there).
odbc2.diff adds code to query the PostgreSQL version upon connection. This
is then used to determine what values to return for from SQLGetInfo for
SQL_DBMS_VER, SQL_MAX_ROW_SIZE, SQL_MAX_STATEMENT_LEN, SQL_OJ_CAPABILITIES
and SQL_OUTER_JOINS. The version string as returned by SELECT vERSION() (as
a char array) and the major.minor version number (as a flost) have been
added to the ConnectionClass structure.
Dave Page
Tom Lane [Fri, 26 Jan 2001 22:25:36 +0000 (22:25 +0000)]
gcc complains about improperly terminated comment.
Bruce Momjian [Fri, 26 Jan 2001 22:17:52 +0000 (22:17 +0000)]
Update TODO list.
Peter Eisentraut [Fri, 26 Jan 2001 22:04:22 +0000 (22:04 +0000)]
Add some links from data type chapter to section on literal constants.
Bruce Momjian [Fri, 26 Jan 2001 21:34:25 +0000 (21:34 +0000)]
Update TODO list.
Bruce Momjian [Fri, 26 Jan 2001 21:17:25 +0000 (21:17 +0000)]
Update TODO list.
Bruce Momjian [Fri, 26 Jan 2001 21:16:15 +0000 (21:16 +0000)]
Update TODO list.