My last run-through before the apocalypse ...
* Disallow inherited columns with the same name as new columns
Either this was just not marked off, or there is some misconception about
how things should work. E.g.,
create table a (x int);
create table b (x text) inherits (a);
will fail, for obvious reasons.
create table a (x int);
create table b (x int) inherits (a);
will not fail, but will create a table b with *one* column x which is the
one inherited from a. This might be confusing in this context, but what
about
create table a (x int);
create table b (y text) inherits (a);
create table c (z text) inherits (a);
create table d (q time) inherits (b, c);
In this case you must allow this "column merging" to happen, otherwise
this whole scheme of inheriting would be impossible. So either the above
item seems done or we prohibit multiple inheritance.
* Do not allow bpchar column creation without length
peter=> create table foo (a bpchar);
CREATE
peter=> \d foo Table "foo"Attribute | Type | Extra
-----------+---------+-------a | char(1) |
Looks good to me (and is standard compliant).
* Update table SET table.value = 3 fails(SQL standard says this is OK)
We agreed that this was definitely not okay by any standard we know of.
Please remove it.
* SELECT ... UNION ... ORDER BY fails when sort expr not in result list
Looks good to me:
peter=> select * from test1;a | b
---+----1 | 112 | 22
(2 rows)
peter=> select * from test2;a | b
---+----3 | 334 | 44
(2 rows)
peter=> select a from test1 union select a from test2 order by b;a
---1234
(4 rows)
Perhaps be more specific?
* SELECT ... UNION ... GROUP BY fails if column types disagree
Shouldn't it?
* Allow user to define char1 column
Both of
create table test (a char);
create table test (a char(1));
seem to work.
* Add support for & operator
To do what? I can only see this specified in embedded SQL. More specific
here as well?
* Make Absolutetime/Relativetime int4 because time_t can be int8 on some
ports
This is done.
* Make type equivalency apply to aggregates
This is done.
* -Add ALTER TABLE DROP/ALTER COLUMN feature
Ain't gonna happen. (Okay, the ALTER COLUMN part is, but not the rest.)
* Add PL/Perl(Mark Hollomon)
I understand this is done as well. Someone might want to incorporate this
into the build process, as well as add it into createlang.
* Pre-generate lex and yacc output so not required for install
Done.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
