pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: table restruct... 4+ messages / 4 participants [nested] [flat]
* Re: table restruct... @ 2001-09-20 13:40 Kovacs Baldvin <kb136@hszk.bme.hu> 0 siblings, 1 reply; 4+ messages in thread From: Kovacs Baldvin @ 2001-09-20 13:40 UTC (permalink / raw) To: David M. Richter <d.Richter@dkfz-heidelberg.de>; +Cc: pgsql-sql Hi! Do you REALLY need to restructure your data for changing columns? Probably you could use views instead. Üdv, Baldvin ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: table restruct... @ 2001-09-20 14:31 David M. Richter <d.Richter@dkfz-heidelberg.de> parent: Kovacs Baldvin <kb136@hszk.bme.hu> 0 siblings, 2 replies; 4+ messages in thread From: David M. Richter @ 2001-09-20 14:31 UTC (permalink / raw) To: Kovacs Baldvin <kb136@hszk.bme.hu>; +Cc: pgsql-sql Hi! Thanks, to You! Yes I have to do . Now I solved that problem with rename the original table study to _study then create the new right structured table study , Insert into study (chilioid,...,...) SELECT * FROM _study; Ok not elegant but it works. Another questions: Can I change the physical order of the rows in a database? Is the order of a database under all circumstances the same? (in pg) That is essential for my further restruction of the database... Thanks a lot David Attachments:^ permalink raw reply [nested|flat] 4+ messages in threadd.Richter.vcf (text/x-vcard, 497B) download
begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum/German Cancer Research Center;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-17024 fn:David M. Richter end:vcard
* Re: table restruct... @ 2001-09-20 14:46 Stephan Szabo <sszabo@megazone23.bigpanda.com> parent: David M. Richter <d.Richter@dkfz-heidelberg.de> 1 sibling, 0 replies; 4+ messages in thread From: Stephan Szabo @ 2001-09-20 14:46 UTC (permalink / raw) To: David M. Richter <d.Richter@dkfz-heidelberg.de>; +Cc: pgsql-sql On Thu, 20 Sep 2001, David M. Richter wrote: > Hi! > > Thanks, to You! > > Yes I have to do . Now I solved that problem with rename the original > table study to _study > then create the new right structured table study , Insert into study > (chilioid,...,...) SELECT * FROM _study; > Ok not elegant but it works. > > Another questions: > Can I change the physical order of the rows in a database? You mean the order the rows are stored on disk? AFAIK, only cluster, and that has a lot of caveats, and doesn't keep the rows in any particular order after that. > Is the order of a database under all circumstances the same? (in pg) Umm, not really. In general under 7.1 and earlier, I think the heap rows are in order of insertion (at least before a vacuum, but I'm not sure about after). > That is essential for my further restruction of the database... Given that sql guarantees nothing about row ordering, I'm not sure what kind of restructuring you're trying to do. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: table restruct... @ 2001-09-20 15:23 Thurstan R. McDougle <trmcdougle@my-deja.com> parent: David M. Richter <d.Richter@dkfz-heidelberg.de> 1 sibling, 0 replies; 4+ messages in thread From: Thurstan R. McDougle @ 2001-09-20 15:23 UTC (permalink / raw) To: pgsql-sql "David M. Richter" wrote: > snip... > Yes I have to do . Now I solved that problem with rename the original > table study to _study > then create the new right structured table study , Insert into study > (chilioid,...,...) SELECT * FROM _study; > Ok not elegant but it works. > > Another questions: > Can I change the physical order of the rows in a database? Look at the entry for the CLUSTER command at http://www.postgresql.org/idocs/index.php?sql-cluster.html > Is the order of a database under all circumstances the same? (in pg) Normally the primary key or an ORDER BY on the SELECT force this according to the use the specific search is for. > > That is essential for my further restruction of the database... Changing columns is no unheard of, but changing row order is only normally done for performance reasons... Could you say why you need this, we suspect you do not in fact NEED it! > > Thanks a lot > > David -- This is the identity that I use for NewsGroups. Email to this will just sit there. If you wish to email me replace the domain with knightpiesold . co . uk (no spaces). ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-09-20 15:23 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2001-09-20 13:40 Re: table restruct... Kovacs Baldvin <kb136@hszk.bme.hu> 2001-09-20 14:31 ` David M. Richter <d.Richter@dkfz-heidelberg.de> 2001-09-20 14:46 ` Stephan Szabo <sszabo@megazone23.bigpanda.com> 2001-09-20 15:23 ` Thurstan R. McDougle <trmcdougle@my-deja.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox