Thread: TODO list updates

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


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


* Add ALTER TABLE command to change table ownershipDibs on this.


-- 
Mark Hollomon
mhh@mindspring.com

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   |/

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@mindspring.com
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@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