Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 913579FB24F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  5 Oct 2006 12:16:03 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 66387-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu,  5 Oct 2006 15:15:56 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210])
	by postgresql.org (Postfix) with ESMTP id 771659FB27D
	for <pgsql-sql@postgresql.org>; Thu,  5 Oct 2006 12:15:56 -0300 (ADT)
Received: from host3.dynacom.ondsl.gr ([62.103.35.211]
 helo=ip216.internal.net)
	by matrix.gatewaynet.com with esmtp (Exim 4.62)
	(envelope-from <achill@matrix.gatewaynet.com>) id 1GVUx0-0007Ts-KE
	for pgsql-sql@postgresql.org; Thu, 05 Oct 2006 18:15:54 +0300
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-sql@postgresql.org
Subject: Re: i have table
Date: Thu, 5 Oct 2006 18:15:54 +0300
User-Agent: KMail/1.9.3
References: <A70AE049E81A6A40879D5DC0AC8C38C9073DCD8F@venus.infics.com>
	<200610051032.55610.achill@matrix.gatewaynet.com>
	<12317.1160055103@sss.pgh.pa.us>
In-Reply-To: <12317.1160055103@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200610051815.54282.achill@matrix.gatewaynet.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200610/58
X-Sequence-Number: 26447

=CE=A3=CF=84=CE=B9=CF=82 =CE=A0=CE=AD=CE=BC=CF=80=CF=84=CE=B7 05 =CE=9F=CE=
=BA=CF=84=CF=8E=CE=B2=CF=81=CE=B9=CE=BF=CF=82 2006 16:31, =CE=BF/=CE=B7 Tom=
 Lane =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> > Alright, you could play with something like:
> >
> > UPDATE pg_attribute SET attnum =3D <your number of ordering> where
> > attrelid=3D<your tableoid> and attname=3D'<your column name>';
>
> That's guaranteed to break his table, because the physical storage
> of the rows won't have changed.  (To name only the most obvious
> problem...)

Ooops....
Thanx for the info, altho i warned the guy to search before act.

>
> 			regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

=2D-=20
Achilleas Mantzios