- 11 8月, 2002 13 次提交
-
-
由 Bruce Momjian 提交于
> Looks like Alvaro got sideswiped by the system catalog indexing changes > I made over the weekend. It's a simple change, just reduce the whole > mess to a "CatalogUpdateIndexes()" call. I update two tuples, so I manually CatalogOpenIndexes() and CatalogIndexInsert() two times, as per comments in CatalogUpdateIndexes(). I also removed a couple of useless CommandCounterIncrement(), some useless definitions in src/include/commands/cluster.h and useless includes in src/backend/commands/cluster.c. This version passes the regression test I had made for previous versions. Alvaro Herrera
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
contrib/tsearch and contrib/ltree :) Teodor Sigaev
-
由 Bruce Momjian 提交于
Christopher Kings-Lynne wrote: > I'm still getting ltree failures on 64bit freebsd: > > sed 's,MODULE_PATHNAME,$libdir/ltree,g' ltree.sql.in >ltree.sql > gcc -pipe -O -g -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DPI > C -DLOWER_NODE -I. -I../../src/include -c -o ltree_io.o ltree_io.c -MMD > ltree_io.c: In function `ltree_in': > ltree_io.c:57: warning: int format, different type arg (arg 3) > ltree_io.c:63: warning: int format, different type arg (arg 4) > ltree_io.c:68: warning: int format, different type arg (arg 3) Teodor Sigaev
-
由 Bruce Momjian 提交于
> l.mode, l.isgranted from pg_lock_info() as l(relation oid, database oid, > backendpid int4, mode text, isgranted bool); > ERROR: badly formatted planstring "COLUMNDEF "... > Reported by Neil Conway -- I never implemented readfuncs.c support for ColumnDef or TypeName, which is needed so that views can be created on functions returning type RECORD. Here's a patch. Joe Conway
-
由 Bruce Momjian 提交于
relfilenode. I sent the CLUSTER patch a few days ago and I think it was missed. I append it again, this time including the regression test files. For the committer, please note that you have to cvs add the files as they don't exist. Maybe add to the parallel and serial schedules also, but I don't know such stuff. Alvaro Herrera (<alvherre[a]atentus.com>)
-
由 Bruce Momjian 提交于
1. Reworked patch from Andrey Oktyabrski (ano@spider.ru) with functions: icount, sort, sort_asc, uniq, idx, subarray operations: #, +, -, |, & FUNCTIONS: int icount(int[]) - the number of elements in intarray int[] sort(int[], 'asc' | 'desc') - sort intarray int[] sort(int[]) - sort in ascending order int[] sort_asc(int[]),sort_desc(int[]) - shortcuts for sort int[] uniq(int[]) - returns unique elements int idx(int[], int item) - returns index of first intarray matching element to item, or '0' if matching failed. int[] subarray(int[],int START [, int LEN]) - returns part of intarray starting from element number START (from 1) and length LEN. OPERATIONS: int[] && int[] - overlap - returns TRUE if arrays has at least one common elements. int[] @ int[] - contains - returns TRUE if left array contains right array int[] ~ int[] - contained - returns TRUE if left array is contained in right array # int[] - return the number of elements in array int[] + int - push element to array ( add to end of array) int[] + int[] - merge of arrays (right array added to the end of left one) int[] - int - remove entries matched by right argument from array int[] - int[] - remove left array from right int[] | int - returns intarray - union of arguments int[] | int[] - returns intarray as a union of two arrays int[] & int[] - returns intersection of arrays Oleg Bartunov
-
由 Bruce Momjian 提交于
error handling, and simplifies the code that remains. Apparently, the code that left Berkeley had a whole "error handling subsystem", which exceptions and whatnot. Since we don't use that anymore, there's no reason to keep it around. The regression tests pass with the patch applied. Unless anyone sees a problem, please apply. Neil Conway
-
由 Tom Lane 提交于
discussion. Also, cause the \timing command to display time in a format consistent with the backend's EXPLAIN ANALYZE output.
-
由 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 3 次提交
-
-
由 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
-