On Fri, Feb 27, 2015 at 4:44 PM, Tomas Vondra <tomas.von...@2ndquadrant.com> wrote:
> On 27.2.2015 20:34, Alvaro Herrera wrote: > > Tomas Vondra wrote: > > > >> I think we could calls to the randomization functions into some of the > >> regression tests (say 'create_tables.sql'), but that makes regression > >> tests ... well, random, and I'm not convinced that's a good thing. > >> > >> Also, this makes regression tests harder to think, because "SELECT *" > >> does different things depending on the attlognum order. > > > > No, that approach doesn't seem very useful. Rather, randomize the > > columns in the CREATE TABLE statement, and then fix up the attlognums so > > that the SELECT * expansion is the same as it would be with the > > not-randomized CREATE TABLE. > > Yes, that's a possible approach too - possibly a better one for > regression tests as it fixes the 'SELECT *' but it effectively uses > fixed 'attlognum' and 'attnum' values (it's difficult to randomize > those, as they may be referenced in other catalogs). > > -- > Tomas Vondra http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > Sorry to intrude, I've been following this post and I was wondering if it would allow (in the currently planed form or in the future) a wider set of non-rewriting DDLs to Postgres. For example, drop a column without rewriting the table.
