OSDN Git Service
Bruce Momjian [Wed, 9 Jul 2003 17:57:47 +0000 (17:57 +0000)]
Add description for new GUC context.
Aizaz Ahmed
Michael Meskes [Wed, 9 Jul 2003 14:53:18 +0000 (14:53 +0000)]
Argh! Missed one file.
Michael Meskes [Wed, 9 Jul 2003 13:49:38 +0000 (13:49 +0000)]
Fixed some Informix compat functions so they handle NULL resp. indicators better.
Bruce Momjian [Wed, 9 Jul 2003 08:52:56 +0000 (08:52 +0000)]
Doc update for LOG_MIN_DURATION_STATEMENT set to zero.
Bruce Momjian [Wed, 9 Jul 2003 08:51:19 +0000 (08:51 +0000)]
Add special checks for non-super-user setting LOG_MIN_DURATION_STATEMENT
to zero.
Bruce Momjian [Wed, 9 Jul 2003 06:47:34 +0000 (06:47 +0000)]
Add new USERLIMIT GUC source level so certain options can be disabled
or increased only by super-users.
This fixes problems caused by making certain variables SUSET for
security reasons.
Barry Lind [Wed, 9 Jul 2003 05:12:04 +0000 (05:12 +0000)]
Applied patch from Kim Ho @ redhat.com to make support for setObject() more
spec complient with regards to various data/time/timestamp objects
Modified Files:
jdbc/org/postgresql/errors.properties
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
Michael Meskes [Tue, 8 Jul 2003 12:11:35 +0000 (12:11 +0000)]
More informix fixes.
Michael Meskes [Tue, 8 Jul 2003 07:13:48 +0000 (07:13 +0000)]
Fix segfault in connect in informix mode.
Michael Meskes [Mon, 7 Jul 2003 12:15:33 +0000 (12:15 +0000)]
"char *" of course is not the same as "char []". So I had to fix the way ecpg treated the second one.
Tom Lane [Fri, 4 Jul 2003 18:21:14 +0000 (18:21 +0000)]
tm2timestamp should return -1, not elog, on overflow. (In the backend
this is merely an API inconsistency, but in ecpg it's fatal.) Also,
fix misconceived overflow test in HAVE_INT64_TIMESTAMP case.
Tom Lane [Fri, 4 Jul 2003 18:15:10 +0000 (18:15 +0000)]
Fix missing code for HAVE_INT64_TIMESTAMP.
Tom Lane [Fri, 4 Jul 2003 16:41:22 +0000 (16:41 +0000)]
Add --help-config facility to dump information about GUC parameters
without needing a running backend. Reorder postgresql.conf.sample
to match new layout of runtime.sgml. This commit re-adds work lost
in Wednesday's crash.
Tom Lane [Fri, 4 Jul 2003 16:28:03 +0000 (16:28 +0000)]
Add #include <limits.h> (re-add lost change from Wednesday).
Michael Meskes [Fri, 4 Jul 2003 12:00:52 +0000 (12:00 +0000)]
date, interval and timestamp data should be quoted.
Michael Meskes [Fri, 4 Jul 2003 11:30:48 +0000 (11:30 +0000)]
Fixed informix behaviour for select without into.
Tom Lane [Fri, 4 Jul 2003 02:51:34 +0000 (02:51 +0000)]
Some early work on error message editing. Operator-not-found and
function-not-found messages now distinguish the cases no-match and
ambiguous-match, and they follow the style guidelines too.
Tom Lane [Thu, 3 Jul 2003 19:41:47 +0000 (19:41 +0000)]
Fix bug I introduced in recent rewrite of NUMERIC code: numeric to
integer conversions gave the wrong answer for values with stripped
trailing zeroes, such as
10000000.
Tom Lane [Thu, 3 Jul 2003 19:07:54 +0000 (19:07 +0000)]
Do honest transformation and preprocessing of LIMIT/OFFSET clauses,
instead of the former kluge whereby gram.y emitted already-transformed
expressions. This is needed so that Params appearing in these clauses
actually work correctly. I suppose some might claim that the side effect
of 'SELECT ... LIMIT 2+2' working is a new feature, but I say this is
a bug fix.
Tom Lane [Thu, 3 Jul 2003 16:34:26 +0000 (16:34 +0000)]
Code review for UPDATE tab SET col = DEFAULT patch ... whack it around
so it has some chance of working in rules ...
Michael Meskes [Wed, 2 Jul 2003 07:57:36 +0000 (07:57 +0000)]
Fixed initialization bug and added postgres_fe.h to pgtypeslib.
Tom Lane [Tue, 1 Jul 2003 21:47:09 +0000 (21:47 +0000)]
Support polymorphic functions in plpgsql. Along the way, replace
linked-list search of function cache with hash-table lookup.
By Joe Conway.
Bruce Momjian [Tue, 1 Jul 2003 19:58:23 +0000 (19:58 +0000)]
Fix ecpg typo --- change ;; to ;.
Tom Lane [Tue, 1 Jul 2003 19:10:53 +0000 (19:10 +0000)]
Aggregates can be polymorphic, using polymorphic implementation functions.
It also works to create a non-polymorphic aggregate from polymorphic
functions, should you want to do that. Regression test added, docs still
lacking. By Joe Conway, with some kibitzing from Tom Lane.
Tom Lane [Tue, 1 Jul 2003 19:07:02 +0000 (19:07 +0000)]
Dept. of second thoughts: supporting inlining of polymorphic SQL functions
takes only a few more lines of code than preventing it, so might as well
support it.
Tom Lane [Tue, 1 Jul 2003 13:52:29 +0000 (13:52 +0000)]
Fix documentation comment about restricted environments, per Kevin Jacobs.
Tom Lane [Tue, 1 Jul 2003 13:49:47 +0000 (13:49 +0000)]
STRENGH => STRENGTH, per Jon Jensen.
Michael Meskes [Tue, 1 Jul 2003 12:40:52 +0000 (12:40 +0000)]
Use ISO dates in pgtypeslib by default.
Applied patch by Philip Yarra to fix some thread issues.
Added a new data type "decimal" which is mostly the same as our
"numeric" but uses a fixed length array to store the digits. This is
for compatibility with Informix and maybe others.
Tom Lane [Tue, 1 Jul 2003 01:28:32 +0000 (01:28 +0000)]
Department of second thoughts: even if we can't run the full parser on
a SQL function with polymorphic inputs, we can at least run the raw
parser to catch silly syntactic errors.
Peter Eisentraut [Tue, 1 Jul 2003 00:05:49 +0000 (00:05 +0000)]
Translation update
Tom Lane [Tue, 1 Jul 2003 00:04:39 +0000 (00:04 +0000)]
SQL functions can have arguments and results declared ANYARRAY or
ANYELEMENT. The effect is to postpone typechecking of the function
body until runtime. Documentation is still lacking.
Original patch by Joe Conway, modified to postpone type checking
by Tom Lane.
Peter Eisentraut [Tue, 1 Jul 2003 00:04:31 +0000 (00:04 +0000)]
Change EXECUTE INTO to CREATE TABLE AS EXECUTE.
Dave Cramer [Mon, 30 Jun 2003 21:10:55 +0000 (21:10 +0000)]
patches by Kim Ho to fix
getByte, getSort if input has decimal or whitespace
setObject if object is a BIT
boolean not on list of SQLKeywords
Tom Lane [Mon, 30 Jun 2003 20:02:53 +0000 (20:02 +0000)]
Update contrib/Makefile's list of subdirectories that it does not try
to build.
Tom Lane [Mon, 30 Jun 2003 19:58:57 +0000 (19:58 +0000)]
Put back inappropriately-removed entry for earthdistance subdirectory.
Tom Lane [Mon, 30 Jun 2003 18:31:42 +0000 (18:31 +0000)]
Rename plpython to plpythonu, and update documentation to reflect its
now-untrusted status.
Tom Lane [Mon, 30 Jun 2003 16:47:02 +0000 (16:47 +0000)]
Add GUC option log_error_verbosity to control which fields of error
reports get put into the postmaster log. Options are TERSE, DEFAULT,
VERBOSE, with the same behavior as implemented on the client side in
libpq.
Barry Lind [Mon, 30 Jun 2003 16:39:42 +0000 (16:39 +0000)]
Minor jdbc doc updates submitted by Kris Jurka
Modified Files:
sgml/jdbc.sgml
Barry Lind [Mon, 30 Jun 2003 16:38:30 +0000 (16:38 +0000)]
Patches applied:
1) Patch from Kris Jurka to fix IPv6 parsing of the jdbc URL
2) Patch from Kris Jurka to fix an ArrayIndexOutOfBounds error
when calling moveToCurrentRow while currentRow is "beforeFirst"
3) Patch from Kim Ho to fix add some bounds checking in setMaxRows(),
setQueryTimeout(), setFetchSize()
Modified Files:
jdbc/org/postgresql/Driver.java.in
jdbc/org/postgresql/errors.properties
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
Tom Lane [Sun, 29 Jun 2003 23:05:05 +0000 (23:05 +0000)]
Restructure building of join relation targetlists so that a join plan
node emits only those vars that are actually needed above it in the
plan tree. (There were comments in the code suggesting that this was
done at some point in the dim past, but for a long time we have just
made join nodes emit everything that either input emitted.) Aside from
being marginally more efficient, this fixes the problem noted by Peter
Eisentraut where a join above an IN-implemented-as-join might fail,
because the subplan targetlist constructed in the latter case didn't
meet the expectation of including everything.
Along the way, fix some places that were O(N^2) in the targetlist
length. This is not all the trouble spots for wide queries by any
means, but it's a step forward.
Michael Meskes [Sun, 29 Jun 2003 16:52:58 +0000 (16:52 +0000)]
- Made sure Informix style decimal vars are initialized. They use a
fixed amount of digits and not an allocated one. So we have to work
around. PostgreSQL numeric type remains the same.
- In INFORMIX_SE mode with autcommit set, make all cursors be "with
hold". Is this really they way SE behaves?
Peter Eisentraut [Sun, 29 Jun 2003 15:14:41 +0000 (15:14 +0000)]
Information schema views for group privileges, some corrections on column
privileges.
Peter Eisentraut [Sun, 29 Jun 2003 10:18:26 +0000 (10:18 +0000)]
It was comparing the wrong pair of columns, which triggered the previously
mentioned bug.
Peter Eisentraut [Sun, 29 Jun 2003 10:13:13 +0000 (10:13 +0000)]
Add missing PO files from last commit.
Michael Meskes [Sun, 29 Jun 2003 09:25:19 +0000 (09:25 +0000)]
Just another sync.
Tom Lane [Sun, 29 Jun 2003 00:33:44 +0000 (00:33 +0000)]
Support expressions of the form 'scalar op ANY (array)' and
'scalar op ALL (array)', where the operator is applied between the
lefthand scalar and each element of the array. The operator must
yield boolean; the result of the construct is the OR or AND of the
per-element results, respectively.
Original coding by Joe Conway, after an idea of Peter's. Rewritten
by Tom to keep the implementation strictly separate from subqueries.
Peter Eisentraut [Sat, 28 Jun 2003 22:31:01 +0000 (22:31 +0000)]
Merge PO file updates from 7.3 branch.
Peter Eisentraut [Sat, 28 Jun 2003 20:50:08 +0000 (20:50 +0000)]
Make information schema aware of arrays.
The view element_types is currently not functional, awaiting some fixes in
the planner (reported on -hackers).
Bruce Momjian [Sat, 28 Jun 2003 18:05:12 +0000 (18:05 +0000)]
Add:
> * Automatically place fixed-width, NOT NULL columns first in a table
Bruce Momjian [Sat, 28 Jun 2003 00:36:40 +0000 (00:36 +0000)]
Group ISBN/ISSN definitions.
Tom Lane [Sat, 28 Jun 2003 00:12:40 +0000 (00:12 +0000)]
Update psql for some features of new FE/BE protocol. There is a
client-side AUTOCOMMIT mode now: '\set AUTOCOMMIT off' supports
SQL-spec commit behavior. Get rid of LO_TRANSACTION hack --- the
LO operations just work now, using libpq's ability to track the
transaction status. Add a VERBOSE variable to control verboseness
of error message display, and add a %T prompt-string code to show
current transaction-block status. Superuser state display in the
prompt string correctly follows SET SESSION AUTHORIZATION commands.
Control-C works to get out of COPY IN state.
Tom Lane [Sat, 28 Jun 2003 00:06:01 +0000 (00:06 +0000)]
When using new protocol, PQexec can get out of a COPY IN or COPY OUT
state by itself, so do so.
Bruce Momjian [Fri, 27 Jun 2003 22:04:50 +0000 (22:04 +0000)]
Adjust pgtest grep.
Bruce Momjian [Fri, 27 Jun 2003 21:46:20 +0000 (21:46 +0000)]
Update pgtest to use 'gmake check'.
Tom Lane [Fri, 27 Jun 2003 19:08:38 +0000 (19:08 +0000)]
Add is_superuser parameter reporting, soon to be used by psql.
Bruce Momjian [Fri, 27 Jun 2003 18:20:50 +0000 (18:20 +0000)]
Document kernel changes needed for BSD/OS 4.3.
Tom Lane [Fri, 27 Jun 2003 17:07:03 +0000 (17:07 +0000)]
Fix compile warnings.
Tom Lane [Fri, 27 Jun 2003 16:55:23 +0000 (16:55 +0000)]
Missing calls to PQclear in large_obj.c and describe.c.
Greg Sabino Mullane
Peter Eisentraut [Fri, 27 Jun 2003 14:45:32 +0000 (14:45 +0000)]
First batch of object rename commands.
Bruce Momjian [Fri, 27 Jun 2003 04:35:41 +0000 (04:35 +0000)]
Remove as duplicate:
< * Improve performance for queries with many columns
Bruce Momjian [Fri, 27 Jun 2003 02:48:44 +0000 (02:48 +0000)]
Add:
> * Improve performance for queries with many columns
Tom Lane [Fri, 27 Jun 2003 00:33:26 +0000 (00:33 +0000)]
Create real array comparison functions (that use the element datatype's
comparison functions), replacing the highly bogus bitwise array_eq. Create
a btree index opclass for ANYARRAY --- it is now possible to create indexes
on array columns.
Arrange to cache the results of catalog lookups across multiple array
operations, instead of repeating the lookups on every call.
Add string_to_array and array_to_string functions.
Remove singleton_array, array_accum, array_assign, and array_subscript
functions, since these were for proof-of-concept and not intended to become
supported functions.
Minor adjustments to behavior in some corner cases with empty or
zero-dimensional arrays.
Joe Conway (with some editorializing by Tom Lane).
Tom Lane [Thu, 26 Jun 2003 18:23:07 +0000 (18:23 +0000)]
Add comment pointing out that XLByteToPrevSeg macro is not broken.
Michael Meskes [Thu, 26 Jun 2003 11:37:05 +0000 (11:37 +0000)]
Added just another compatibility level for Informix.
Bruce Momjian [Thu, 26 Jun 2003 01:45:04 +0000 (01:45 +0000)]
Wrap LONG_LONG_MIN redfinition around HAVE_LONG_LONG_INT_64.
Bruce Momjian [Thu, 26 Jun 2003 01:33:23 +0000 (01:33 +0000)]
Fix compile problem for missing LONG_LONG_MIN on BSD/OS.
Bruce Momjian [Wed, 25 Jun 2003 21:56:55 +0000 (21:56 +0000)]
Add:
> * Create improved PostgreSQL introductory documentation for the PHP
> manuals (Rory)
Bruce Momjian [Wed, 25 Jun 2003 21:55:44 +0000 (21:55 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:47:53 +0000 (21:47 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:47:24 +0000 (21:47 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:46:10 +0000 (21:46 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:45:40 +0000 (21:45 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:45:06 +0000 (21:45 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:42:07 +0000 (21:42 +0000)]
Add:
> * Allow the identifier length to be increased via a configure option
Bruce Momjian [Wed, 25 Jun 2003 21:40:48 +0000 (21:40 +0000)]
Add:
> * Promote debug_query_string into a server-side function current_query()
Bruce Momjian [Wed, 25 Jun 2003 21:37:53 +0000 (21:37 +0000)]
Back out rserv changes that would allow limit of replicated tables ---
not ready yet.
Bruce Momjian [Wed, 25 Jun 2003 21:30:34 +0000 (21:30 +0000)]
Back out array mega-patch.
Joe Conway
Tom Lane [Wed, 25 Jun 2003 21:14:15 +0000 (21:14 +0000)]
In ISO datestyle, never emit just HH:MM, always emit HH:MM:SS or
HH:MM:SS.SSS... when there is a nonzero part-of-a-day field in an
interval value. The seconds part used to be suppressed if zero,
but there's no equivalent behavior for timestamp, and since we're
modeling this format on timestamp it's probably wrong. Per complaint
and patch from Larry Rosenman.
Bruce Momjian [Wed, 25 Jun 2003 21:08:06 +0000 (21:08 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:07:28 +0000 (21:07 +0000)]
sync
Bruce Momjian [Wed, 25 Jun 2003 21:06:29 +0000 (21:06 +0000)]
sync
Tom Lane [Wed, 25 Jun 2003 20:07:39 +0000 (20:07 +0000)]
Don't generate 'zero' typeids in the output from gen_cross_product.
This is no longer necessary or appropriate since we don't use zero typeid
as a wildcard anymore, and it fixes a nasty performance problem with
functions with many parameters. Per recent example from Reuven Lerner.
Tom Lane [Wed, 25 Jun 2003 18:13:50 +0000 (18:13 +0000)]
'third' -> 'fourth' where needed, per Joe Conway.
Michael Meskes [Wed, 25 Jun 2003 17:55:50 +0000 (17:55 +0000)]
The remaining files ...
Michael Meskes [Wed, 25 Jun 2003 16:12:27 +0000 (16:12 +0000)]
remove including of postgres_fe.h
Bruce Momjian [Wed, 25 Jun 2003 15:01:14 +0000 (15:01 +0000)]
sync.
Michael Meskes [Wed, 25 Jun 2003 11:51:18 +0000 (11:51 +0000)]
Some systems need another header file included.
Michael Meskes [Wed, 25 Jun 2003 10:44:21 +0000 (10:44 +0000)]
Implemented Informix special way to treat NULLs, removed warnings, synced.
Bruce Momjian [Wed, 25 Jun 2003 04:32:03 +0000 (04:32 +0000)]
Fix up JOIN .. USING with domains
The attached fixes select_common_type() to support the below case:
create table t1( c1 int);
create domain dom_c1 int;
create table t2(c1 dom_c1);
select * from t1 join t2 using( c1 );
I didn't see a need for maintaining the domain as the preferred type. A
simple getBaseType() call on all elements of the list seems to be
enough.
--
Rod Taylor <rbt@rbt.ca>
Bruce Momjian [Wed, 25 Jun 2003 04:23:59 +0000 (04:23 +0000)]
Done:
> * -Allow CIDR format to be used in pg_hba.conf
Bruce Momjian [Wed, 25 Jun 2003 04:19:35 +0000 (04:19 +0000)]
Done:
> * -Allow UPDATE to use SET col = DEFAULT
Bruce Momjian [Wed, 25 Jun 2003 04:19:24 +0000 (04:19 +0000)]
UPDATE ... SET <col> = DEFAULT
Rod Taylor
Bruce Momjian [Wed, 25 Jun 2003 04:08:19 +0000 (04:08 +0000)]
If they're not, the below causes problems, as the foreign key is added
after the CHECK. Cluster depends on the index name, so I thought it
wise to ensure all names are available, rather than leaving off the
CONSTRAINT "$n" portion for internally named constraints.
CREATE TABLE jkey (col integer primary key);
CREATE TABLE j (col integer REFERENCES jkey);
ALTER TABLE j ADD CHECK(col > 5);
This is a problem in 7.3 series as well as -Tip.
Rod Taylor <rbt@rbt.ca>
Bruce Momjian [Wed, 25 Jun 2003 03:56:31 +0000 (03:56 +0000)]
Updated the pg_get_constraintdef() to use conbin. Update pg_dump to use
pg_get_constraintdef() for >= 70400.
Rod Taylor <rbt@rbt.ca>
Bruce Momjian [Wed, 25 Jun 2003 03:50:52 +0000 (03:50 +0000)]
Add missing </row>'s.
Bruce Momjian [Wed, 25 Jun 2003 03:40:19 +0000 (03:40 +0000)]
Includes:
- LIKE <subtable> [ INCLUDING DEFAULTS | EXCLUDING DEFAULTS ]
- Quick cleanup of analyze.c function prototypes.
- New non-reserved keywords (INCLUDING, EXCLUDING, DEFAULTS), SQL 200X
Opted not to extend for check constraints at this time.
As per the definition that it's user defined columns, OIDs are NOT
inherited.
Doc and Source patches attached.
--
Rod Taylor <rbt@rbt.ca>
Bruce Momjian [Wed, 25 Jun 2003 03:02:37 +0000 (03:02 +0000)]
Back out commit.
Bruce Momjian [Wed, 25 Jun 2003 03:01:35 +0000 (03:01 +0000)]
Adjust expected output for new functions.
Bruce Momjian [Wed, 25 Jun 2003 02:43:54 +0000 (02:43 +0000)]
Add:
> * Allow creation of a libpq-only tarball
>
Bruce Momjian [Wed, 25 Jun 2003 02:07:33 +0000 (02:07 +0000)]
Seems the runtime.sgml and perform.sgml patches combined are
incompatible.
I believe the attached xref meets the intent of the perform.sgml change.
--
Rod Taylor <rbt@rbt.ca>