Re: TODO list updates

Lists: pgsql-hackers
From: Mark Hollomon <mhh(at)mindspring(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TODO list updates
Date: 2000-09-07 14:19:57
Message-ID: 20000907101957.B20520@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


* Disallow LOCK on view
change to
* -Disallow LOCK on view (Mark H)
well, at least when my patch is applied :)

* Allow SQL function indexes
This seems to work in the CVS code, or I have misunderstood:
CREATE TABLE t ( a int);
CREATE FUNCTION mod5(int) RETURNS int AS 'select $1 % 5' LANGUAGE 'sql';
CREATE INDEX sql_index ON t ( mod5(a) );

* Add ALTER TABLE command to change table ownership
Dibs on this.

--
Mark Hollomon
mhh(at)mindspring(dot)com

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Mark Hollomon <mhh(at)mindspring(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO list updates
Date: 2000-09-07 23:28:41
Message-ID: 3.0.5.32.20000908092841.024cad10@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

At 10:19 7/09/00 -0400, Mark Hollomon wrote:
>
>* Add ALTER TABLE command to change table ownership
> Dibs on this.

Any chance of doing more than just tables? pg_dump does many \connect's to
set ownership of things appropriately. If there were appropriate ALTER
commands, then it's job would be simpler.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mark Hollomon <mhh(at)mindspring(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO list updates
Date: 2000-10-16 19:49:26
Message-ID: 200010161949.PAA02216@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Thanks. TODO updated.

>
> * Disallow LOCK on view
> change to
> * -Disallow LOCK on view (Mark H)
> well, at least when my patch is applied :)
>
>
> * Allow SQL function indexes
> This seems to work in the CVS code, or I have misunderstood:
> CREATE TABLE t ( a int);
> CREATE FUNCTION mod5(int) RETURNS int AS 'select $1 % 5' LANGUAGE 'sql';
> CREATE INDEX sql_index ON t ( mod5(a) );
>
>
> * Add ALTER TABLE command to change table ownership
> Dibs on this.
>
>
> --
> Mark Hollomon
> mhh(at)mindspring(dot)com
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026