Thread: Open 6.5 items
I will assume I can remove this item(thanks Tom): GEQO has trouble with many tables/eats memory - Backend message type 0x44 Current list is: --------------------------------------------------------------------------- Default of '' causes crash in some cases shift/reduce conflict in grammar, SELECT ... FOR [UPDATE|CURSOR] SELECT 1; SELECT 2 fails when sent not via psql, semicolon problem SELECT * FROM test WHERE test IN (SELECT * FROM test) fails with strange error CREATE OPERATOR *= (leftarg=_varchar, rightarg=varchar, procedure=array_varchareq); fails, varchar is reserved word, quoteswork CLUSTER failure if vacuum has not been performed in a while Improve Subplan list handling Allow Subplans to use efficient joins(hash, merge) with upper variable Improve NULL parameter passing into functions Table with an element of type inet, will show "0.0.0.0/0" as "00/0" When creating a table with either type inet or type cidr as a primary,unique key, the "198.68.123.0/24" and "198.68.123.0/27"are considered equal Allow ESCAPE '\' at the end of LIKE for ANSI compliance, or rewrite theLIKE handling by rewriting the user string with thesupplied ESCAPE Fix leak for expressions?, aggregates? Improve LIMIT processing by using index to limit rows processed Allow "col AS name" to use name in WHERE clause? Is this ANSI? Works in GROUP BY Update reltuples from COPY command nodeResults.c and parse_clause.c give compiler warnings Move LIKE index optimization handling to the optimizer? MVCC locking, deadlock, priorities? Make sure pg_internal.init generation can't cause unreliability SELECT ... WHERE col ~ '(foo|bar)' works, but CHECK on table always fails CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) failsindex can't store constant parameters, allowSQL function indexes? Have hashjoins use portals, not fixed-size memory DROP TABLE leaves INDEX file descriptor open ALTER TABLE ADD COLUMN to inherited table put column in wrong place resno's, sublevelsup corrupt when reaching rewrite system crypt_loadpwdfile() is mixing and (mis)matching memory allocation protocols, trying to use pfree() to release pwd_cache vectorfrom realloc() 3 = sum(x) in rewrite system is a problem Fix function pointer calls to take Datum args for char and int2 args Do we want pg_dump -z to be the default? pg_dump of groups fails pg_dump -o -D does not work, and can not work currently, generate error? psql \d should show precision dumping out sequences should not be counted in pg_dump display Make psql \help, man pages, and sgml reflect changes in grammar Markup sql.sgml, Stefan's intro to SQL Markup cvs.sgml, cvs and cvsup howto Add figures to sql.sgml and arch-dev.sgml, both from Stefan Include Jose's date/time history in User's Guide (neat!) Generate Admin, User, Programmer hardcopy postscript DROP TABLE/RENAME TABLE doesn't remove extended files, *.1, *.2 Vacuum of tables >2 gigs - NOTICE: Can't truncate multi-segments relation Make Serial its own type? Add support for & operator store binary-compatible type information in the system somewhere add ability to add comments to system tables using table/colname combination process const=const parts of OR clause in separate pass make oid use oidin/oidout not int4in/int4out in pg_type.h, make oid useunsigned int more reliably, pg_atoi() CREATE VIEW ignores DISTINCT -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
On Sun, 16 May 1999, Bruce Momjian wrote:
> nodeResults.c and parse_clause.c give compiler warnings
No warnings on Redhat Linux 6.0 (Linux 2.2.7, egcs 1.1.2, glibc 2.1)
> DROP TABLE leaves INDEX file descriptor open
Shouldn't now.. index_destroy() gets called, which again calls smgrunlink.
It looks like smgrunlink closes all fds.
> DROP TABLE/RENAME TABLE doesn't remove extended files, *.1, *.2
This now works(with the patch from yesterday).
> Vacuum of tables >2 gigs - NOTICE: Can't truncate multi-segments relation
This is actually more of a fundamental problem with mdtruncate. It looks
like someone just didn't add support for multiple segments for truncation.
The following patch seems to do the right thing, for me at least.
It passed my tests, my data looks right(no data that shouldn't be in
there) and regression is ok.
Ole Gjerde
--- src/backend/storage/smgr/md.c 1999/04/05 22:25:11 1.42
+++ src/backend/storage/smgr/md.c 1999/05/17 06:23:23
@@ -711,15 +711,26 @@ MdfdVec *v;#ifndef LET_OS_MANAGE_FILESIZE
- int curnblk;
+ int curnblk,
+ i,
+ oldsegno,
+ newsegno;
+ char fname[NAMEDATALEN];
+ char tname[NAMEDATALEN + 10]; curnblk = mdnblocks(reln);
- if (curnblk / RELSEG_SIZE > 0)
- {
- elog(NOTICE, "Can't truncate multi-segments relation %s",
- reln->rd_rel->relname.data);
- return curnblk;
- }
+ oldsegno = curnblk / RELSEG_SIZE;
+ newsegno = nblocks / RELSEG_SIZE;
+
+ StrNCpy(fname, RelationGetRelationName(reln)->data, NAMEDATALEN);
+
+ if (newsegno < oldsegno) {
+ for (i = (newsegno + 1);; i++) {
+ sprintf(tname, "%s.%d", fname, i);
+ if (FileNameUnlink(tname) < 0)
+ break;
+ }
+ }#endif fd = RelationGetFile(reln);
List updated. Patch applied. Thanks.
> On Sun, 16 May 1999, Bruce Momjian wrote:
> > nodeResults.c and parse_clause.c give compiler warnings
>
> No warnings on Redhat Linux 6.0 (Linux 2.2.7, egcs 1.1.2, glibc 2.1)
>
> > DROP TABLE leaves INDEX file descriptor open
>
> Shouldn't now.. index_destroy() gets called, which again calls smgrunlink.
> It looks like smgrunlink closes all fds.
>
> > DROP TABLE/RENAME TABLE doesn't remove extended files, *.1, *.2
>
> This now works(with the patch from yesterday).
>
> > Vacuum of tables >2 gigs - NOTICE: Can't truncate multi-segments relation
>
> This is actually more of a fundamental problem with mdtruncate. It looks
> like someone just didn't add support for multiple segments for truncation.
>
> The following patch seems to do the right thing, for me at least.
> It passed my tests, my data looks right(no data that shouldn't be in
> there) and regression is ok.
>
> Ole Gjerde
>
> --- src/backend/storage/smgr/md.c 1999/04/05 22:25:11 1.42
> +++ src/backend/storage/smgr/md.c 1999/05/17 06:23:23
> @@ -711,15 +711,26 @@
> MdfdVec *v;
>
> #ifndef LET_OS_MANAGE_FILESIZE
> - int curnblk;
> + int curnblk,
> + i,
> + oldsegno,
> + newsegno;
> + char fname[NAMEDATALEN];
> + char tname[NAMEDATALEN + 10];
>
> curnblk = mdnblocks(reln);
> - if (curnblk / RELSEG_SIZE > 0)
> - {
> - elog(NOTICE, "Can't truncate multi-segments relation %s",
> - reln->rd_rel->relname.data);
> - return curnblk;
> - }
> + oldsegno = curnblk / RELSEG_SIZE;
> + newsegno = nblocks / RELSEG_SIZE;
> +
> + StrNCpy(fname, RelationGetRelationName(reln)->data, NAMEDATALEN);
> +
> + if (newsegno < oldsegno) {
> + for (i = (newsegno + 1);; i++) {
> + sprintf(tname, "%s.%d", fname, i);
> + if (FileNameUnlink(tname) < 0)
> + break;
> + }
> + }
> #endif
>
> fd = RelationGetFile(reln);
>
>
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026