Thread: Re: SELECT * FROM <table> LIMIT 1; is really slow : Postgres Professional

Thread: Re: SELECT * FROM LIMIT 1; is really slow

Re: SELECT * FROM

From

"Zeugswetter Andreas SB SD"

Date:

27 May 2004, 08:37:27

> What would be useful for that (as of 7.5) is a dummy ALTER TABLE TYPE,
> viz
>
>     ALTER TABLE tab ALTER COLUMN col TYPE same-type-it-already-has

I think we should add special syntax for this purpose, since I would like to
(or someone else later on) see all possible cases of "alter column" short
circuited.

The syntax I would see fit is something like:
ALTER TABLE tab [MOVE] TABLESPACE xy;

For the above special case the tablespace would be the same as before.

Andreas