OSDN Git Service
Thomas G. Lockhart [Wed, 21 Nov 2001 05:57:33 +0000 (05:57 +0000)]
Repair swapped sign for time minus time routine (time_mi_time()).
Problem reported by Manuel Sugawara (masm@fciencias.unam.mx).
Thomas G. Lockhart [Wed, 21 Nov 2001 05:55:18 +0000 (05:55 +0000)]
Allow 'PostgreSQL' as a date/time formatting style. Formerly, recognized
'Postgres' only, but now accepts both.
Thomas G. Lockhart [Wed, 21 Nov 2001 05:53:41 +0000 (05:53 +0000)]
Deprecate 'current' for date/time input.
Fix up references to "PostgreSQL" rather than "Postgres". Was roughly
evenly split between the two before. ref/ files not yet done.
Thomas G. Lockhart [Wed, 21 Nov 2001 05:52:01 +0000 (05:52 +0000)]
Update for first platforms reported as working
for the upcoming 7.2 release.
Bruce Momjian [Wed, 21 Nov 2001 05:45:31 +0000 (05:45 +0000)]
I think it's patch's size problem that I can't
send patches to pgsql-patches list.
the zh_CN NLS patch is about 80K,
but sended twice and still can emerge on list.
so I've put it at:
http://laser.zhengmai.com.cn/download/zh_CN.po.diff.tar.gz
If possible, please download it and apply it.
(for current CVS).
regards laser
Bruce Momjian [Wed, 21 Nov 2001 05:41:15 +0000 (05:41 +0000)]
Fix beta build, for Marc.
Bruce Momjian [Wed, 21 Nov 2001 05:03:16 +0000 (05:03 +0000)]
// -> /* */, per Tatsuo.
Bruce Momjian [Wed, 21 Nov 2001 03:17:22 +0000 (03:17 +0000)]
Peter Eisentraut wrote:
> So I would base this discussion on the premise "bytea stores binary data"
> (insert examples).
>
> Some stylistic issues:
>
> bytea => <type>bytea</type>
>
> NULLs => zero bytes/bytes of value zero ("NULL" is too overloaded)
>
> 'non-printable' => <quote>nonprintable</quote>
>
> MUST => <emphasis>must</emphasis>
>
Here's a patch against *CVS tip* to address Peter's comments. Please let
me know what you think!
Joe Conway
Bruce Momjian [Wed, 21 Nov 2001 03:15:54 +0000 (03:15 +0000)]
Update for bytea, from Joe Conway
Bruce Momjian [Wed, 21 Nov 2001 02:43:30 +0000 (02:43 +0000)]
Update my2pg.pl for release.
Bruce Momjian [Wed, 21 Nov 2001 02:20:11 +0000 (02:20 +0000)]
Update HISTORY, for Tatsuo.
Tom Lane [Tue, 20 Nov 2001 22:22:24 +0000 (22:22 +0000)]
Bruce's octet_length change breaks this regression test.
Bruce Momjian [Tue, 20 Nov 2001 21:10:38 +0000 (21:10 +0000)]
Include sys/types.h in crypt-des.c. FreeBSD netinet/in.h
needs it.
Seems it is getting compileable...
Marko Kreen
Bruce Momjian [Tue, 20 Nov 2001 21:09:53 +0000 (21:09 +0000)]
Added a few paragraphs to explain current restricted execution environment,
and error handling behavior.
Bradley McLean
Bruce Momjian [Tue, 20 Nov 2001 20:28:31 +0000 (20:28 +0000)]
Here's a patch adding documentation for the PQescapeBytea function to
libpq.sgml
I was trying (but gave up) to cross-reference back to the input escape
table in the User's Guide, but could not get the documentation to
compile with a cross-book xref (missing IDREF error). Can a cross-book
xref be done?
Joe Conway
Bruce Momjian [Tue, 20 Nov 2001 18:54:07 +0000 (18:54 +0000)]
Duh, my regexp's missed bunch of them. Here's next batch, this
should be all.
Marko Kreen
Bruce Momjian [Tue, 20 Nov 2001 18:23:37 +0000 (18:23 +0000)]
Add mention of template1 usage.
Bruce Momjian [Tue, 20 Nov 2001 15:50:53 +0000 (15:50 +0000)]
pgcrypto uses non-standard type uint, which causes compile
failures on FreeBSD. This patch replaces uint -> unsigned.
This was reported by Daniel Holtzman against 0.4pre3 standalone
package, but it needs fixing in contrib/pgcrypto too.
Marko Kreen
Bruce Momjian [Tue, 20 Nov 2001 15:42:44 +0000 (15:42 +0000)]
I've created a new section to func.sgml, "Binary String Functions and
Operators", plagiarized shamelessly from the "String Functions and
Operators" section. There were enough differences that it made sense (at
least to me) to give this its own section instead of cramming it in with
normal string functions. This way I could also make the examples
relevant, which is particularly important for bytea.
One thing I think worth mentioning: while documenting the trim()
function I realized that I never implemented the bytea equivalent of
rtrim and ltrim. Therefore, the 'leading' and 'trailing' forms of trim,
available with text, are not available with bytea (I'd be happy to
correct this, but since it would require an initdb, I guess not until
7.3) -- the submitted doc accurately reflects this.
I will look for other areas of the docs that need mention of bytea, but
any guidance would be much appreciated.
--
Here's a second bytea documentation patch. This one significantly
expands the "Binary Data" section added by Bruce recently.
Joe Conway
Bruce Momjian [Tue, 20 Nov 2001 15:28:37 +0000 (15:28 +0000)]
Update TODO list.
Tom Lane [Tue, 20 Nov 2001 04:27:49 +0000 (04:27 +0000)]
Expand discussion of logfile management a little bit.
Bruce Momjian [Tue, 20 Nov 2001 04:18:49 +0000 (04:18 +0000)]
Update HISTORY to current changes.
PostgreSQL Daemon [Tue, 20 Nov 2001 03:51:31 +0000 (03:51 +0000)]
update configure.in for b3 ...
Tom Lane [Tue, 20 Nov 2001 02:46:13 +0000 (02:46 +0000)]
Some minor tweaks of REINDEX processing: grab exclusive lock a little
earlier, make error checks more uniform.
Tom Lane [Tue, 20 Nov 2001 02:45:00 +0000 (02:45 +0000)]
Expand description of how to use REINDEX.
Tatsuo Ishii [Tue, 20 Nov 2001 01:32:29 +0000 (01:32 +0000)]
Simplify pg_convert() in that it calls pg_convert2 using new fmgr interface.
Tom Lane [Tue, 20 Nov 2001 00:27:13 +0000 (00:27 +0000)]
Double quotes in ln command to guard against spaces in path.
Bruce Momjian [Mon, 19 Nov 2001 23:19:21 +0000 (23:19 +0000)]
Change 'return ;' to 'return;'; remove space.
Tom Lane [Mon, 19 Nov 2001 23:17:38 +0000 (23:17 +0000)]
Fill in empty tutorial section about transactions.
Bruce Momjian [Mon, 19 Nov 2001 23:16:46 +0000 (23:16 +0000)]
Indent jdbc case labels using pgjindent.
Bruce Momjian [Mon, 19 Nov 2001 22:43:13 +0000 (22:43 +0000)]
More jdbc comment cleanups. Code looks very nice now.
Bruce Momjian [Mon, 19 Nov 2001 22:36:11 +0000 (22:36 +0000)]
Update pgindent README so it gets *.java.in files.
Bruce Momjian [Mon, 19 Nov 2001 22:33:39 +0000 (22:33 +0000)]
JDBC indenting, comment cleanups.
Bruce Momjian [Mon, 19 Nov 2001 20:02:25 +0000 (20:02 +0000)]
Update TODO list.
Tom Lane [Mon, 19 Nov 2001 19:51:20 +0000 (19:51 +0000)]
Tweak format_type so that we get good behavior for both column type
display (with a typemod) and function arg/result type display (without
a typemod).
Bruce Momjian [Mon, 19 Nov 2001 19:15:07 +0000 (19:15 +0000)]
Fix arg coerect match text type, per Tom.
Tom Lane [Mon, 19 Nov 2001 19:03:56 +0000 (19:03 +0000)]
Try to be a little bit clearer about the implications of GRANT TO PUBLIC
and REVOKE FROM PUBLIC: the latter is not the same as 'revoke from all
users', but the ref page blurred the difference.
Bruce Momjian [Mon, 19 Nov 2001 18:21:10 +0000 (18:21 +0000)]
Make text octet_length() return non-compressed length to be consistent
with other data types, per disucssion. Encoding issue still open.
Bruce Momjian [Mon, 19 Nov 2001 18:10:38 +0000 (18:10 +0000)]
Update TODO list.
Tom Lane [Mon, 19 Nov 2001 09:05:02 +0000 (09:05 +0000)]
Grammatical and spelling fixes.
Tatsuo Ishii [Mon, 19 Nov 2001 06:48:39 +0000 (06:48 +0000)]
Fix nasty bugs in pg_convert() and pg_convert2().
o they sometimes returns a result garbage string appended.
o they do not work if client encoding is different from server
encoding
Hiroshi Inoue [Mon, 19 Nov 2001 06:26:00 +0000 (06:26 +0000)]
Fix comment at top of file to match file name.
Tom Lane [Mon, 19 Nov 2001 06:06:21 +0000 (06:06 +0000)]
pg_restore should exit with status 0, not 1, on success.
Tom Lane [Mon, 19 Nov 2001 05:37:53 +0000 (05:37 +0000)]
Fix a few typos, grammatical problems, etc in new tutorial material.
Overall a really nice job here, Peter ...
Tom Lane [Mon, 19 Nov 2001 03:58:25 +0000 (03:58 +0000)]
A bunch of small doco updates motivated by scanning the comments on
the interactive docs.
Tom Lane [Sun, 18 Nov 2001 23:24:16 +0000 (23:24 +0000)]
Add example of using 'sameuser' followed by 'all' pg_hba records to
enforce a limit on who can connect to databases other than their own.
From a recent discussion in pg-admin.
Bruce Momjian [Sun, 18 Nov 2001 23:02:19 +0000 (23:02 +0000)]
Improve comments about duplicate files.
Tom Lane [Sun, 18 Nov 2001 22:27:00 +0000 (22:27 +0000)]
Fix some typos.
Tom Lane [Sun, 18 Nov 2001 22:17:30 +0000 (22:17 +0000)]
Update various obsolete remarks about VACUUM.
Tom Lane [Sun, 18 Nov 2001 22:13:48 +0000 (22:13 +0000)]
Fix typo.
Tom Lane [Sun, 18 Nov 2001 21:28:00 +0000 (21:28 +0000)]
utils/geo-decls.h should be utils/geo_decls.h, per report from
StÅphane Raimbault.
Tom Lane [Sun, 18 Nov 2001 21:17:10 +0000 (21:17 +0000)]
Mention that LIKE ... ESCAPE '' is allowed to specify no
escape character.
Bruce Momjian [Sun, 18 Nov 2001 21:17:04 +0000 (21:17 +0000)]
Update TODO list.
Tom Lane [Sun, 18 Nov 2001 21:14:20 +0000 (21:14 +0000)]
Point out that TRUNCATE can't be used inside a transaction block.
Peter Eisentraut [Sun, 18 Nov 2001 20:35:02 +0000 (20:35 +0000)]
Initial round of tweakage for man pages
Peter Eisentraut [Sun, 18 Nov 2001 20:33:32 +0000 (20:33 +0000)]
Updates about NLS
Bruce Momjian [Sun, 18 Nov 2001 15:32:39 +0000 (15:32 +0000)]
Update TODO list.
Tatsuo Ishii [Sun, 18 Nov 2001 12:07:07 +0000 (12:07 +0000)]
Optimization for bpcharlen, textlen, varcharlen in case of single byte
encodings.
Tom Lane [Sun, 18 Nov 2001 07:14:49 +0000 (07:14 +0000)]
Mention the option to submit bug reports via a web-form. Minor
copy editing.
Tom Lane [Sun, 18 Nov 2001 00:59:00 +0000 (00:59 +0000)]
Fix obsolete claim that only btree indexes support multiple columns;
GiST does now, too. (Someone needs to write a description of GiST
to add to this chapter. I don't know enough about it ...)
Tom Lane [Sun, 18 Nov 2001 00:38:00 +0000 (00:38 +0000)]
Clean up treatment of creating/dropping databases in User's Guide and
Admin Guide. Move discussion of template databases out of footnotes
in CREATE DATABASE ref page and into a section of the Admin Guide.
Clean up various obsolete claims, do some copy-editing.
Tom Lane [Sat, 17 Nov 2001 22:23:55 +0000 (22:23 +0000)]
Copy-editing.
Tom Lane [Sat, 17 Nov 2001 22:20:34 +0000 (22:20 +0000)]
Expand documentation for sequence functions (nextval and friends).
Place it in the expected place in the User's Guide, rather than
hiding it in the command reference page for CREATE SEQUENCE.
Bruce Momjian [Sat, 17 Nov 2001 19:53:07 +0000 (19:53 +0000)]
Update TODO list.
Bruce Momjian [Sat, 17 Nov 2001 19:29:19 +0000 (19:29 +0000)]
Update TODO list.
Peter Eisentraut [Sat, 17 Nov 2001 13:27:16 +0000 (13:27 +0000)]
Update key words for recent grammar changes
Tom Lane [Sat, 17 Nov 2001 06:09:30 +0000 (06:09 +0000)]
Fix performance problems in TOAST compressor. The management of
search lists was broken in such a way that only the most recent
instance of a given hash code would ever be searched, thus possibly
missing longer matches further back. Fixing this gave 5 to 10%
compression improvement on some text test cases. Additional small
tweaks to improve speed of inner loops a little bit. There is no
compatibility issue created by this change, since the compressed data
format and decompression algorithm don't change.
Bruce Momjian [Sat, 17 Nov 2001 05:11:43 +0000 (05:11 +0000)]
Update Japanese FAQ's.
Tom Lane [Fri, 16 Nov 2001 23:30:35 +0000 (23:30 +0000)]
IsSystemRelationName() treats TOAST relations as system relations.
This seems the right thing for most usages, but I notice two places
where it is the wrong thing. One is that the default permissions on
TOAST rels should be no-access, not world-readable; the other is that
PrepareForTupleInvalidation doesn't really need to spend time looking
at tuples of TOAST relations.
Bruce Momjian [Fri, 16 Nov 2001 18:28:16 +0000 (18:28 +0000)]
Add missing prototype.
Bruce Momjian [Fri, 16 Nov 2001 18:10:04 +0000 (18:10 +0000)]
Add configure result checks on odbc, per Peter E.
Tom Lane [Fri, 16 Nov 2001 18:04:31 +0000 (18:04 +0000)]
plpython security and error handling fixes, from
Kevin Jacobs and Brad McLean.
Bruce Momjian [Fri, 16 Nov 2001 17:43:25 +0000 (17:43 +0000)]
Update TODO list.
Tom Lane [Fri, 16 Nov 2001 17:01:48 +0000 (17:01 +0000)]
Once again, Michael has overwritten someone else's patch ...
Peter Eisentraut [Fri, 16 Nov 2001 16:32:33 +0000 (16:32 +0000)]
Make the yacc rules safe for parallel make. See discussion on pgsql-patches
and comment in src/backend/parser/Makefile for the technical details.
Tom Lane [Fri, 16 Nov 2001 16:31:16 +0000 (16:31 +0000)]
Remove 'triggered data change violation' error check, per recent
discussions in pghackers.
Peter Eisentraut [Fri, 16 Nov 2001 16:29:56 +0000 (16:29 +0000)]
Use -f for rm.
Michael Meskes [Fri, 16 Nov 2001 08:36:37 +0000 (08:36 +0000)]
Committed again to add the missing files/patches.
Hiroshi Inoue [Fri, 16 Nov 2001 05:55:10 +0000 (05:55 +0000)]
Change SQLDescribeCol so that it returns alias name properly.
Tom Lane [Fri, 16 Nov 2001 04:08:33 +0000 (04:08 +0000)]
Update keyword lists per suggestions by Peter. There are now four
mutually exclusive keyword lists spanning all known keywords ---
including AS. Moved COALESCE and a few other ColLabels into the
can-be-ColId list.
Tom Lane [Fri, 16 Nov 2001 00:40:11 +0000 (00:40 +0000)]
Fix silly error in plpgsql example.
Tom Lane [Thu, 15 Nov 2001 23:32:39 +0000 (23:32 +0000)]
Add documentation for new plpgsql cursor operations. Also, another
round of editorial effort.
Tom Lane [Thu, 15 Nov 2001 23:31:09 +0000 (23:31 +0000)]
Fix some problems in new plpgsql cursor operations, found while trying
to reverse-engineer documentation for them.
Bruce Momjian [Thu, 15 Nov 2001 18:40:52 +0000 (18:40 +0000)]
Read getopt() into an int, not char.
Tom Lane [Thu, 15 Nov 2001 17:31:44 +0000 (17:31 +0000)]
Autoconf.
Bruce Momjian [Thu, 15 Nov 2001 16:35:19 +0000 (16:35 +0000)]
Well the absolute correct solution would involve all of:
int8, int16, int32, int64 and separately uint8, uint16, uint32, uint64
The previous patch grouped:
int8, int16 and int32
uint8, uint16 and uint32
int64 and uint64 <-- this grouping is wrong on AIX 4.3.3 and below
If you prefer to make 4 groups out of this you could apply this patch.
Andreas
Bruce Momjian [Thu, 15 Nov 2001 16:16:08 +0000 (16:16 +0000)]
Update md5.h because it can't get the value from configure.
Bruce Momjian [Thu, 15 Nov 2001 16:09:34 +0000 (16:09 +0000)]
Fix for AIX compile and unsigned/signed typedefs.
Peter E, Tatsuo, Andreas
Peter Eisentraut [Thu, 15 Nov 2001 16:08:15 +0000 (16:08 +0000)]
Only use RTLD_GLOBAL when available, which it isn't in older releases of the OS.
Tom Lane [Thu, 15 Nov 2001 06:25:22 +0000 (06:25 +0000)]
Significant editorial overhaul of plpgsql documentation.
Tatsuo Ishii [Thu, 15 Nov 2001 06:15:34 +0000 (06:15 +0000)]
Add changes for multibyte support in 7.2.
Bruce Momjian [Thu, 15 Nov 2001 03:12:53 +0000 (03:12 +0000)]
Fix comment at top of file to match file name.
Bruce Momjian [Thu, 15 Nov 2001 03:11:32 +0000 (03:11 +0000)]
Update TODO list.
Tom Lane [Wed, 14 Nov 2001 22:26:02 +0000 (22:26 +0000)]
Overhaul SPI documentation: bring it into some semblance of agreement
with reality, and add doco for Jan's recent round of enhancements.
Tom Lane [Wed, 14 Nov 2001 22:14:22 +0000 (22:14 +0000)]
Try to be a little less terse about dealing with variable-length structs
in C, but recommend that newbies who don't recognize this trick should do
some studying ...
Bruce Momjian [Wed, 14 Nov 2001 20:40:33 +0000 (20:40 +0000)]
Gnu -> GNU in docs.
Dave Cramer [Wed, 14 Nov 2001 20:04:00 +0000 (20:04 +0000)]
fixes getIndex to work with forte's transparent persistence
Bruce Momjian [Wed, 14 Nov 2001 16:31:38 +0000 (16:31 +0000)]
Update TODO list.
Michael Meskes [Wed, 14 Nov 2001 11:11:49 +0000 (11:11 +0000)]
Added Christof's patches.
Barry Lind [Wed, 14 Nov 2001 04:11:37 +0000 (04:11 +0000)]
Attached is a patch against the CVS repository that fixes the ResultSet absolute() problem.
There's also a little fix for the getRow() method. While fixing
absolute(), I noticed that getRow() wasn't quite following the spec: it
wasn't returning 0 when the ResultSet wasn't positioned on a row. I've
started a ResultSet test case and included it as well.
Liam Stewart