pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  2001-09-20 14:31 ` Re: table restruct... David M. Richter <d.Richter@dkfz-heidelberg.de>
  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 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   ` Re: table restruct... Stephan Szabo <sszabo@megazone23.bigpanda.com>
  2001-09-20 15:23   ` Re: table restruct... Thurstan R. McDougle <trmcdougle@my-deja.com>
  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:

d.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
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: table restruct...
  2001-09-20 13:40 Re: table restruct... Kovacs Baldvin <kb136@hszk.bme.hu>
  2001-09-20 14:31 ` Re: table restruct... David M. Richter <d.Richter@dkfz-heidelberg.de>
@ 2001-09-20 14:46   ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
  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 13:40 Re: table restruct... Kovacs Baldvin <kb136@hszk.bme.hu>
  2001-09-20 14:31 ` Re: table restruct... David M. Richter <d.Richter@dkfz-heidelberg.de>
@ 2001-09-20 15:23   ` Thurstan R. McDougle <trmcdougle@my-deja.com>
  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