| From: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "David Blasby" <dblasby(at)refractions(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SELECT * FROM <table> LIMIT 1; is really slow |
| Date: | 2004-05-27 08:36:25 |
| Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA40184D0E9@m0114.s-mxs.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2004-05-27 09:29:54 | Re: tablespaces and DB administration |
| Previous Message | Neil Conway | 2004-05-27 07:58:50 | Re: Tablespaces |