OSDN Git Service
Tom Lane [Mon, 15 Oct 2001 18:56:30 +0000 (18:56 +0000)]
Fix some portability problems (get it to compile, at least, on HP's cc)
Tom Lane [Mon, 15 Oct 2001 18:49:40 +0000 (18:49 +0000)]
Fix some portability problems (get it to compile, at least, on HP's cc)
Bruce Momjian [Mon, 15 Oct 2001 18:16:31 +0000 (18:16 +0000)]
> Uh, isn't the correct fix
> ! $$ = cat_str(8, make_str("grant"), $2, make_str("on"), $4, $5,
> make_str("to"), $7, $8);
> ISTM your patch loses the opt_with_grant clause. (Of course the
> backend doesn't currently accept that clause anyway, but that's no
> reason for ecpg to drop it.)
My patch doesn't loose the option, it's never been passed on anyway:
opt_with_grant: WITH GRANT OPTION
{
mmerror(ET_ERROR, "WITH GRANT OPTION is not supported. Only relation owners can
set privileges");
}
| /*EMPTY*/
;
The existing code in ecpg/preproc/preproc.y to handle the WITH option
simply throws an error and aborts the processing... The patch below
prevents the segfault and also passes on the WITH option to the
backend, probably a better fix.
Lee Kindness
Tom Lane [Mon, 15 Oct 2001 17:41:33 +0000 (17:41 +0000)]
Updated regression test for tsearch, from Teodor Sigaev.
Bruce Momjian [Mon, 15 Oct 2001 16:40:27 +0000 (16:40 +0000)]
Prompt for password from /dev/tty and fall back to stdin/stderr.
Tatsuo Ishii [Mon, 15 Oct 2001 04:52:59 +0000 (04:52 +0000)]
Forgot to add this file...
Bruce Momjian [Mon, 15 Oct 2001 02:50:16 +0000 (02:50 +0000)]
PG_DUMP NLS (Russian)
Here is another one :)
Another chunk of translated messages.
Please apply to the same file.
Serguei Mokhov
Tom Lane [Mon, 15 Oct 2001 02:02:06 +0000 (02:02 +0000)]
Suggest placing audit trail on pg_shadow, not its view pg_user.
Tatsuo Ishii [Mon, 15 Oct 2001 01:25:10 +0000 (01:25 +0000)]
Commit Patrice's patches except:
> - corrects a bit the UTF-8 code from Tatsuo to allow Unicode 3.1
> characters (characters with values >= 0x10000, which are encoded on
> four bytes).
Also, update mb/expected/unicode.out. This is necessary since the
patches affetc the result of queries using UTF-8.
---------------------------------------------------------------
Hi,
I should have sent the patch earlier, but got delayed by other stuff.
Anyway, here is the patch:
- most of the functionality is only activated when MULTIBYTE is
defined,
- check valid UTF-8 characters, client-side only yet, and only on
output, you still can send invalid UTF-8 to the server (so, it's
only partly compliant to Unicode 3.1, but that's better than
nothing).
- formats with the correct number of columns (that's why I made it in
the first place after all), but only for UNICODE. However, the code
allows to plug-in routines for other encodings, as Tatsuo did for
the other multibyte functions.
- corrects a bit the UTF-8 code from Tatsuo to allow Unicode 3.1
characters (characters with values >= 0x10000, which are encoded on
four bytes).
- doesn't depend on the locale capabilities of the glibc (useful for
remote telnet).
I would like somebody to check it closely, as it is my first patch to
pgsql. Also, I created dummy .orig files, so that the two files I
created are included, I hope that's the right way.
Now, a lot of functionality is NOT included here, but I will keep that
for 7.3 :) That includes all string checking on the server side (which
will have to be a bit more optimised ;) ), and the input checking on
the client side for UTF-8, though that should not be difficult. It's
just to send the strings through mbvalidate() before sending them to
the server. Strong checking on UTF-8 strings is mandatory to be
compliant with Unicode 3.1+ .
Do I have time to look for a patch to include iso-8859-15 for 7.2 ?
The euro is coming 1. january 2002 (before 7.3 !) and over 280
millions people in Europe will need the euro sign and only iso-8859-15
and iso-8859-16 have it (and unfortunately, I don't think all Unices
will switch to Unicode in the meantime)....
err... yes, I know that this is not every single person in Europe that
uses PostgreSql, so it's not exactly 280m, but it's just a matter of
time ! ;)
I'll come back (on pgsql-hackers) later to ask a few questions
regarding the full unicode support (normalisation, collation,
regexes,...) on the server side :)
Here is the patch !
Patrice.
--
Patrice HÉDÉ ------------------------------- patrice à islande org -----
-- Isn't it weird how scientists can imagine all the matter of the
universe exploding out of a dot smaller than the head of a pin, but they
can't come up with a more evocative name for it than "The Big Bang" ?
-- What would _you_ call the creation of the universe ?
-- "The HORRENDOUS SPACE KABLOOIE !" - Calvin and Hobbes
------------------------------------------ http://www.islande.org/ -----
Tatsuo Ishii [Mon, 15 Oct 2001 01:19:15 +0000 (01:19 +0000)]
Add UTF-8 char >= 0x10000 check
Tom Lane [Mon, 15 Oct 2001 01:00:59 +0000 (01:00 +0000)]
Update examples of type coercion rules --- some of them no longer worked
as the example claimed, because of changes elsewhere in the system.
Tom Lane [Mon, 15 Oct 2001 00:06:04 +0000 (00:06 +0000)]
Synchronize with main parser's keyword list (someone didn't check his
last commit very carefully...)
Bruce Momjian [Sun, 14 Oct 2001 23:27:31 +0000 (23:27 +0000)]
Update FAQ.
Michael Meskes [Sun, 14 Oct 2001 12:07:57 +0000 (12:07 +0000)]
- Fixed GRANT statement.
- Synced preproc.y with gram.y.
Tom Lane [Sat, 13 Oct 2001 23:32:34 +0000 (23:32 +0000)]
Make selectivity routines cope gracefully with NaNs, infinities, and
NUMERIC values that are out of the range of 'double'. Per trouble
report from Mike Quinn.
Peter Eisentraut [Sat, 13 Oct 2001 19:16:32 +0000 (19:16 +0000)]
Fix logic in insert() function.
Tom Lane [Sat, 13 Oct 2001 17:41:11 +0000 (17:41 +0000)]
Fixing closed-path intersection logic causes this test to find more
streets than it used to...
Tom Lane [Sat, 13 Oct 2001 17:40:24 +0000 (17:40 +0000)]
path_inter, path_distance, path_length, dist_ppath now do the right
things with closed paths --- ie, include the closing line segment in
their calculations. Per bug report from Curtis Barrett 9-Oct-01.
Tom Lane [Sat, 13 Oct 2001 16:34:08 +0000 (16:34 +0000)]
Add missing prototype to suppress gcc warning.
Tom Lane [Sat, 13 Oct 2001 15:24:23 +0000 (15:24 +0000)]
Residual cleanup from making pltcl unknown support always enabled.
Tom Lane [Sat, 13 Oct 2001 15:20:51 +0000 (15:20 +0000)]
Autoconf.
Bruce Momjian [Sat, 13 Oct 2001 05:27:05 +0000 (05:27 +0000)]
Update FAQ.
Bruce Momjian [Sat, 13 Oct 2001 04:58:35 +0000 (04:58 +0000)]
More keyword uppercasing.
Bruce Momjian [Sat, 13 Oct 2001 04:25:27 +0000 (04:25 +0000)]
Here are few more translated messages into Russian
for the PG_DUMP component.
Please apply to </src/bin/pg_dump/ru.po>
Serguei A. Mokhov
Bruce Momjian [Sat, 13 Oct 2001 04:23:50 +0000 (04:23 +0000)]
Attached patch for unconditional enabling of pltcl-unknown support.
Enabling this feature adds very light overhead of 1 select from pg_class on
first using of pl/tcl in backend if unknown suppport is really unused.
But pl/tcl with this support has very improved functionality.
Patch includes changes to documentation.
Bruce Momjian [Sat, 13 Oct 2001 03:53:45 +0000 (03:53 +0000)]
Update FAQ.
Bruce Momjian [Sat, 13 Oct 2001 03:37:42 +0000 (03:37 +0000)]
Update FAQ.
Bruce Momjian [Sat, 13 Oct 2001 01:35:25 +0000 (01:35 +0000)]
Mention createlang when language not installed, per problem report.
Bruce Momjian [Sat, 13 Oct 2001 01:32:47 +0000 (01:32 +0000)]
Update FAQ.
Bruce Momjian [Fri, 12 Oct 2001 23:34:30 +0000 (23:34 +0000)]
More uppercasing.
Bruce Momjian [Fri, 12 Oct 2001 23:32:34 +0000 (23:32 +0000)]
Uppercase keywords where appropriate.
Tom Lane [Fri, 12 Oct 2001 23:19:09 +0000 (23:19 +0000)]
txtidx datatype for full text indexing with GiST.
From Oleg Bartunov and Teodor Sigaev.
Bruce Momjian [Fri, 12 Oct 2001 21:19:09 +0000 (21:19 +0000)]
Fix reverse FOR loop to work properly, uppercase cleanup in file.
Bruce Momjian [Fri, 12 Oct 2001 17:46:00 +0000 (17:46 +0000)]
Remove locale/multibyte in HISTORY file, for Tatsuo.
Bruce Momjian [Fri, 12 Oct 2001 17:35:10 +0000 (17:35 +0000)]
Add WAL mmap() mention.
Bruce Momjian [Fri, 12 Oct 2001 17:34:36 +0000 (17:34 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:33:46 +0000 (17:33 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:28:41 +0000 (17:28 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 17:23:04 +0000 (17:23 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:29:36 +0000 (16:29 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:14:17 +0000 (16:14 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:13:48 +0000 (16:13 +0000)]
Update TODO list.
Bruce Momjian [Fri, 12 Oct 2001 16:10:51 +0000 (16:10 +0000)]
Remove mutex mention. Fixed now.
Bruce Momjian [Fri, 12 Oct 2001 16:07:34 +0000 (16:07 +0000)]
Update TODO list.
Hiroshi Inoue [Fri, 12 Oct 2001 09:41:49 +0000 (09:41 +0000)]
Update the version of psqlodbc driver.
Bruce Momjian [Fri, 12 Oct 2001 02:50:48 +0000 (02:50 +0000)]
Update TODO list.
Tatsuo Ishii [Fri, 12 Oct 2001 02:08:34 +0000 (02:08 +0000)]
Add a new function "pg_client_encoding" which returns the current client
side encoding name. This is necessary for client API's such as JDBC
to perform correct encoding conversions. See my email "[HACKERS]
pg_client_encoding" 10 Sep 2001.
Hiroshi Inoue [Fri, 12 Oct 2001 01:08:51 +0000 (01:08 +0000)]
Fix the bug reported by Chris Lee.
Tom Lane [Fri, 12 Oct 2001 00:07:15 +0000 (00:07 +0000)]
Break transformCreateStmt() into multiple routines and make
transformAlterStmt() use these routines, instead of having lots of
duplicate (not to mention should-have-been-duplicate) code.
Adding a column with a CHECK constraint actually works now,
and the tests to reject unsupported DEFAULT and NOT NULL clauses
actually fire now. ALTER TABLE ADD PRIMARY KEY works, modulo
having to have created the column(s) NOT NULL already.
Bruce Momjian [Thu, 11 Oct 2001 21:16:26 +0000 (21:16 +0000)]
Document use of GEQO param in subquery pullups.
Bruce Momjian [Thu, 11 Oct 2001 20:40:38 +0000 (20:40 +0000)]
Update TODO list.
Bruce Momjian [Thu, 11 Oct 2001 20:25:42 +0000 (20:25 +0000)]
Add documention for ecpg -209 error.
Tom Lane [Thu, 11 Oct 2001 18:06:52 +0000 (18:06 +0000)]
Suppress gcc warnings.
Bruce Momjian [Thu, 11 Oct 2001 16:54:18 +0000 (16:54 +0000)]
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> As you can see, psql reconnect as any user if the password is same as
> foo. Of course this is due to the careless password setting, but I
> think it's better to prompt ANY TIME the user tries to switch to
> another user. Comments?
Yeah, I agree. Looks like a simple change in dbconnect():
/*
* Use old password if no new one given (if you didn't have an old
* one, fine)
*/
if (!pwparam && oldconn)
pwparam = PQpass(oldconn);
to
/*
* Use old password (if any) if no new one given and we are
* reconnecting as same user
*/
if (!pwparam && oldconn && PQuser(oldconn) && userparam &&
strcmp(PQuser(oldconn), userparam) == 0)
pwparam = PQpass(oldconn);
regards, tom lane
Bruce Momjian [Thu, 11 Oct 2001 16:35:50 +0000 (16:35 +0000)]
Update TODO list.
Bruce Momjian [Thu, 11 Oct 2001 16:30:41 +0000 (16:30 +0000)]
Remove mention of "pg_result -list" becuase it is not implemented, per
Tatsuo.
Tatsuo Ishii [Thu, 11 Oct 2001 14:20:35 +0000 (14:20 +0000)]
Add support for ISO-8859-6 to 16
Peter Eisentraut [Wed, 10 Oct 2001 00:02:42 +0000 (00:02 +0000)]
Remove gratuitous discrepancy between extract() and date_part(),
regarding timezone_hour, timezone_minute vs. tz_hour, tz_minute.
Document the former.
Peter Eisentraut [Tue, 9 Oct 2001 22:32:33 +0000 (22:32 +0000)]
Allow optional () after current_user, session_user, user, current_time,
current_timestamp, current_date for ODBC compatibility.
Add more functions to odbc.sql catalog extension, use new CREATE OR
REPLACE FUNCTION.
Document iODBC/unixODBC build options.
Barry Lind [Tue, 9 Oct 2001 20:47:35 +0000 (20:47 +0000)]
This patch fixes a bug introduced in the jdbc bytea support patch.
That patch broke the ability to read data from binary cursors.
--Barry Lind
Modified Files:
pgsql/src/interfaces/jdbc/org/postgresql/Connection.java
pgsql/src/interfaces/jdbc/org/postgresql/ResultSet.java
pgsql/src/interfaces/jdbc/org/postgresql/core/QueryExecutor.java
pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/Connection.java
pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/ResultSet.java
pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/Connection.java
pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java
pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/UpdateableResultSet.java
Peter Eisentraut [Tue, 9 Oct 2001 18:46:00 +0000 (18:46 +0000)]
Bunch of copy fitting and style sheet tweakage to get decent looking print
output (from pdfjadetex). Also updated instructions to install documentation
processing toolchain.
Tom Lane [Tue, 9 Oct 2001 15:59:56 +0000 (15:59 +0000)]
Change plpgsql compiler so that all elogs are trapped and a suitable
NOTICE added about error location (same method already used by plpgsql
executor). Add checking of pg_proc row xmin/cmin to ensure that
plpgsql functions will be recompiled after they've been modified by
CREATE OR REPLACE FUNCTION.
Tom Lane [Tue, 9 Oct 2001 14:00:22 +0000 (14:00 +0000)]
Fix typo in error message. Noted by laser@zhengmai.com.cn.
Tom Lane [Tue, 9 Oct 2001 04:55:11 +0000 (04:55 +0000)]
Correct some errors in plpgsql examples, as reported by Junichi Kobayasi.
Tom Lane [Tue, 9 Oct 2001 04:15:38 +0000 (04:15 +0000)]
Change plpgsql to depend on main parser's type-declaration grammar,
rather than having its own somewhat half-baked notion of what a type
declaration looks like. This is necessary now to ensure that plpgsql
will think a 'timestamp' variable has the same semantics as 'timestamp'
does in the main SQL grammar; and it should avoid divergences in future.
Tom Lane [Mon, 8 Oct 2001 21:48:51 +0000 (21:48 +0000)]
Another go-round with FigureColname, to produce less surprising results
for nested typecasts. It now produces a column header of 'timestamptz'
for 'SELECT CURRENT_TIMESTAMP', rather than 'text' as it was doing for
awhile there.
Tom Lane [Mon, 8 Oct 2001 21:46:59 +0000 (21:46 +0000)]
Fix transformExpr() to not scribble on its input datastructure while
transforming CASE expressions. This was definitely confusing
FigureColname, and might lead to bad things elsewhere as well.
Tom Lane [Mon, 8 Oct 2001 19:55:07 +0000 (19:55 +0000)]
Fix ruleutils to depend on format_type, rather than having a private
copy of code that knows about displaying types with typmod info.
Needed so that it does the right thing with timestamp datatypes now.
Tom Lane [Mon, 8 Oct 2001 18:40:04 +0000 (18:40 +0000)]
Make ALTER TABLE RENAME COLUMN update column names of indexes that
refer to the renamed column. Brent Verner, with a little help from tgl.
Tom Lane [Mon, 8 Oct 2001 18:16:59 +0000 (18:16 +0000)]
Remove redundant code, update comments, cause CURRENT_TIME to
agree with CURRENT_TIME(n).
Bruce Momjian [Mon, 8 Oct 2001 17:10:11 +0000 (17:10 +0000)]
Update TODO list.
Michael Meskes [Mon, 8 Oct 2001 08:08:42 +0000 (08:08 +0000)]
Fix include file so library is binary compatible again.
Bruce Momjian [Mon, 8 Oct 2001 03:23:37 +0000 (03:23 +0000)]
Update TODO list.
Tom Lane [Sat, 6 Oct 2001 23:21:45 +0000 (23:21 +0000)]
Rearrange fmgr.c and relcache so that it's possible to keep FmgrInfo
lookup info in the relcache for index access method support functions.
This makes a huge difference for dynamically loaded support functions,
and should save a few cycles even for built-in ones. Also tweak dfmgr.c
so that load_external_function is called only once, not twice, when
doing fmgr_info for a dynamically loaded function. All per performance
gripe from Teodor Sigaev, 5-Oct-01.
Bruce Momjian [Sat, 6 Oct 2001 14:41:17 +0000 (14:41 +0000)]
While playing around with trying to add foreign keys to the
\d table display in psql, I noticed that tableinfo.triggers
is not used once it is set.
Greg Sabino Mullane
Peter Eisentraut [Fri, 5 Oct 2001 21:15:38 +0000 (21:15 +0000)]
Fix shared library builds for MacOS X.
Peter Eisentraut [Fri, 5 Oct 2001 21:14:35 +0000 (21:14 +0000)]
Move psql's zh_TW.po to the right place.
Bruce Momjian [Fri, 5 Oct 2001 20:43:09 +0000 (20:43 +0000)]
Update TODO list.
Bruce Momjian [Fri, 5 Oct 2001 19:05:54 +0000 (19:05 +0000)]
files attached are Traditional Chinese translations translated
and modified from Simplified Chinese translations for backend,
pgsql, pg_dump and libpq. I've appended their names to zh_TW.po.
forth
Bruce Momjian [Fri, 5 Oct 2001 19:01:13 +0000 (19:01 +0000)]
Attached is the updated version of the patch, which matches
on words as opposed to lines, which means that all of the
following work in psql:
\d foo \d bar
\d foo; \d bar
\d foo \d bar;;
\d foo; <space>
This one also uses "true and false" and strips semicolons
for the following backslash commands: \C \c \d \e \i \o \s \z
Greg Sabino Mullane
Michael Meskes [Fri, 5 Oct 2001 17:37:07 +0000 (17:37 +0000)]
Make sure each call to ECPGraise is logged.
Tom Lane [Fri, 5 Oct 2001 17:28:13 +0000 (17:28 +0000)]
Further cleanup of dynahash.c API, in pursuit of portability and
readability. Bizarre '(long *) TRUE' return convention is gone,
in favor of just raising an error internally in dynahash.c when
we detect hashtable corruption. HashTableWalk is gone, in favor
of using hash_seq_search directly, since it had no hope of working
with non-LONGALIGNable datatypes. Simplify some other code that was
made undesirably grotty by promixity to HashTableWalk.
Bruce Momjian [Fri, 5 Oct 2001 15:50:11 +0000 (15:50 +0000)]
ouput -> output
Oliver Elphick
Bruce Momjian [Fri, 5 Oct 2001 15:47:48 +0000 (15:47 +0000)]
> > I am quite sure that all AIX Versions accept the CLOBBER method,
> > thus I ask you to apply the following patch, to make it work.
Zeugswetter Andreas SB SD
Michael Meskes [Fri, 5 Oct 2001 06:39:23 +0000 (06:39 +0000)]
Fixed typo in proproc.y
Thomas G. Lockhart [Fri, 5 Oct 2001 06:38:59 +0000 (06:38 +0000)]
Define CEST as a synonym for Central European Savings Time
per Jan Varga <varga@utcru.sk>
Fix up spacing and formatting.
Thomas G. Lockhart [Fri, 5 Oct 2001 06:37:42 +0000 (06:37 +0000)]
Implement explicit date/time precision per SQL99 spec.
Use CAST() mechanism to define CURRENT_TIME and CURRENT_TIMESTAMP.
Tom Lane [Thu, 4 Oct 2001 22:39:34 +0000 (22:39 +0000)]
Don't try to hack pg_description if not superuser. (Really want a
COMMENT ON LARGE OBJECT command instead, but no time for it now.)
Fix some code that would not work with OIDs > 2G.
Peter Eisentraut [Thu, 4 Oct 2001 22:30:14 +0000 (22:30 +0000)]
Finetuning for legalnotice in print output. Add some "ASCII markup" for
text output.
Peter Eisentraut [Thu, 4 Oct 2001 22:28:44 +0000 (22:28 +0000)]
Finetuning for better print formatting
Peter Eisentraut [Thu, 4 Oct 2001 22:27:58 +0000 (22:27 +0000)]
Replace simplelists with itemizedlists for better formatting
Peter Eisentraut [Thu, 4 Oct 2001 22:27:18 +0000 (22:27 +0000)]
Rewording
Peter Eisentraut [Thu, 4 Oct 2001 22:26:27 +0000 (22:26 +0000)]
Fix spacing to get proper URL formatting in print output
Peter Eisentraut [Thu, 4 Oct 2001 22:25:48 +0000 (22:25 +0000)]
Hack for Jade vs TeX interpretation of "--"
Tom Lane [Thu, 4 Oct 2001 22:06:46 +0000 (22:06 +0000)]
Consider interpreting a function call as a trivial (binary-compatible)
type coercion after failing to find an exact match in pg_proc, but before
considering interpretations that involve a function call with one or
more argument type coercions. This avoids surprises wherein what looks
like a type coercion is interpreted as coercing to some third type and
then to the destination type, as in Dave Blasby's bug report of 3-Oct-01.
See subsequent discussion in pghackers.
Tom Lane [Thu, 4 Oct 2001 22:00:10 +0000 (22:00 +0000)]
Ooops, I was a little too enthusiastic about suppressing default
index opclasses; they might be default for some other datatype,
in which case we mustn't suppress 'em.
Tom Lane [Thu, 4 Oct 2001 19:13:55 +0000 (19:13 +0000)]
Plug memory leaks introduced by dynamic-search-path changes.
From Teodor Sigaev.
Tom Lane [Thu, 4 Oct 2001 17:52:24 +0000 (17:52 +0000)]
Make the world safe for atttypmod=0 ... this didn't use to mean anything,
but timestamp now wants it to mean something.
Tom Lane [Thu, 4 Oct 2001 17:10:11 +0000 (17:10 +0000)]
Make current_time deliver a fractional-second answer.
Bruce Momjian [Thu, 4 Oct 2001 15:48:37 +0000 (15:48 +0000)]
elog command need to use unicode conversion too.
Vsevolod Lobko