- 11 8月, 2002 4 次提交
-
-
由 Tom Lane 提交于
arguments of CREATE OPERATOR.
-
由 Peter Eisentraut 提交于
single source file a few directories deep in the backend tree has changed.
-
由 Peter Eisentraut 提交于
and database. In particular, make script wrappers understand the PGDATABASE environment variable.
-
由 Tom Lane 提交于
-
- 10 8月, 2002 5 次提交
-
-
由 Tom Lane 提交于
also have a unique index on OID.
-
由 Tom Lane 提交于
follows recent pghackers discussion. This commit includes all the relevant fixes from Greg Mullane's patch of 24-June.
-
由 Peter Eisentraut 提交于
are only activated temporarily to read out formatting information.
-
由 Tom Lane 提交于
per Joe Conway's patch of 20-July.
-
由 Tom Lane 提交于
has_language_privilege, has_schema_privilege to let SQL queries test all the new privilege types in 7.3. Also, add functions pg_table_is_visible, pg_type_is_visible, pg_function_is_visible, pg_operator_is_visible, pg_opclass_is_visible to test whether objects contained in schemas are visible in the current search path. Do some minor cleanup to centralize accesses to pg_database, as well.
-
- 09 8月, 2002 6 次提交
-
-
由 Hiroshi Inoue 提交于
in auto-commit off mode.
-
由 Bruce Momjian 提交于
> o -Fix PL/PgSQL to handle quoted mixed-case identifiers
-
由 Bruce Momjian 提交于
> * Allow INET subnet tests using non-constants
-
由 Tom Lane 提交于
I did not force an initdb via catversion ... but the rules regression test will fail until you do an initdb.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
table or column, or of an output column of the view itself.
-
- 08 8月, 2002 10 次提交
-
-
由 Tom Lane 提交于
-
由 Tatsuo Ishii 提交于
-
由 Tatsuo Ishii 提交于
-
由 Tatsuo Ishii 提交于
executed to prevent database access while performing encoding conversion.
-
由 Tatsuo Ishii 提交于
-
由 Tom Lane 提交于
to behave according to SQL92 (or according to my current understanding of same, anyway). Per pghackers discussion way back in March 2002: thread 'Do FROM items of different schemas conflict?'
-
由 Tom Lane 提交于
correctly, truncate to NAMEDATALEN where needed, allow whitespace around dots in qualified identifiers. Get rid of T_RECFIELD and T_TGARGV token categories, which weren't accomplishing anything except to create room for sins of omission in the grammar, ie, places that should have allowed them and didn't. Fix a few other bugs en passant.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
-
- 07 8月, 2002 3 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
offset past the last-used-item-plus-one, since that would result in leaving uninitialized holes in the item pointer array. AFAICT the only place that was depending on this was btree index build, which was being cavalier about when to fill in the P_HIKEY pointer; easily fixed. Also a small performance improvement: shuffle itemid's by means of memmove, not a one-at-a-time loop.
-
由 Tom Lane 提交于
-
- 06 8月, 2002 11 次提交
-
-
由 Tom Lane 提交于
pg_convert3 does not belong in a backend/catalog file at all, IMHO; it should be in utils/adt.
-
由 Tatsuo Ishii 提交于
-
由 Bruce Momjian 提交于
Teodor Sigaev
-
由 Bruce Momjian 提交于
rangefunc regression test for the new behavior. Joe Conway
-
由 Bruce Momjian 提交于
>> alias in this case. What do you think? > > I guess that would make sense. I'll make a separate patch just for that > change if that's OK. > Simple change -- patch attached. test=# select * from myfoo1() as z; z ---- 1 2 3 (3 rows) Joe Conway
-
由 Bruce Momjian 提交于
don't return type RECORD. It also catches a core dump condition when a function returning RECORD had an alias list instead of a coldeflist. Now both conditions throw an ERROR. Joe Conway
-
由 Bruce Momjian 提交于
START TRANSACTION command. Neil Conway
-
由 Bruce Momjian 提交于
executed in an implicitely aborted transaction (e.g. after an occur occurs), we return an error (and not just a warning). For example: nconway=# begin; BEGIN nconway=# insert; -- syntax error ERROR: parser: parse error at or near ";" nconway=# select * from a; ERROR: current transaction is aborted, queries ignored until end of transaction block The old behavior was: nconway=# begin; BEGIN nconway=# insert; ERROR: parser: parse error at or near ";" nconway=# select * from a; WARNING: current transaction is aborted, queries ignored until end of transaction block *ABORT STATE* Which can be confusing: if the client isn't paying careful attention, they will conclude that the query has executed (because no error is returned). Neil Conway
-
由 Tom Lane 提交于
The local buffer manager is no longer used for newly-created relations (unless they are TEMP); a new non-TEMP relation goes through the shared bufmgr and thus will participate normally in checkpoints. But TEMP relations use the local buffer manager throughout their lifespan. Also, operations in TEMP relations are not logged in WAL, thus improving performance. Since it's no longer necessary to fsync relations as they move out of the local buffers into shared buffers, quite a lot of smgr.c/md.c/fd.c code is no longer needed and has been removed: there's no concept of a dirty relation anymore in md.c/fd.c, and we never fsync anything but WAL. Still TODO: improve local buffer management algorithms so that it would be reasonable to increase NLocBuffer.
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
Still needs to be filled with more information, but it gives us a framework to have a User's Guide with complete coverage of the basic SQL operations. Move arrays into data type chapter, inheritance into DDL chapter (for now). Make <comment>s show up in the output while the version number ends in "devel". Allow cross-book references with entities &cite-user; etc.
-
- 05 8月, 2002 1 次提交
-
-
由 Tom Lane 提交于
hardwired lists of index names for each catalog, use the relcache's mechanism for caching lists of OIDs of indexes of any table. This reduces the common case of updating system catalog indexes to a single line, makes it much easier to add a new system index (in fact, you can now do so on-the-fly if you want to), and as a nice side benefit improves performance a little. Per recent pghackers discussion.
-