Re: [HACKERS] TODO list

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> * User who can create databases can modify pg_database table
>
> Not anymore.

Done. Good.

>
> * Interlock to prevent DROP DATABASE on a database with running backends
>
> I think Tom wanted this listed as an achievement, because it's already
> done.

Done.

>
> * Better interface for adding to pg_group
>
> Done.

Yes. I can remove the pg_group FAQ item after 7.0 is out to most
people.

>
> * Allow array on int8[]
>
> Done. (Credit to Thomas, thought, he just forgot to apply the patch.)

Good.

>
> * Make Absolutetime/Relativetime int4 because time_t can be int8 on some
> ports
>
> Does this mean the abstime/reltime types or all of them? I thought the
> former were deprecated anyway.

I think the idea is that it can roll over the mac int4 value. Not sure
about which types are active.

>
> * Permissions on indexes, prevent them?
>
> Done (prevented)

Good.

>
> * Make postgres user have a password by default
>
> Done. (--pwprompt option, enter it blind twice, echo ALTER USER |
> postgres; probably as secure as it gets)

Perfect. We don't want to do it by default.

>
> * Update table SET table.value = 3 fails(SQL standard says this is OK)
>
> Not the standard I'm looking at. Someone please enlighten me.
>
> <update statement: searched> ::=
> UPDATE <table name>
> SET <set clause list>
> [ WHERE <search condition> ]
>
> <set clause list> ::=
> <set clause> [ { <comma> <set clause> }... ]
>
> <set clause> ::=
> <object column> <equals operator> <update source>
>
> <object column> ::= <column name>
>
> <column name> ::= <identifier>
>
> <identifier> ::=
> [ <introducer><character set specification> ] <actual identifier>
>
> <introducer> ::= <underscore>
>
> <character set specification> ::=
> { nothing of interest }
>
> <actual identifier> ::=
> <regular identifier>
> | <delimited identifier>
>
> { meaning a non-quoted identifier or a quoted one }
>

I don't see anything in the spec that says you can use table.column on
the left-hand side of the equals. No?

--
Bruce Momjian | http://www.op.net/~candle
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