Andreas Kretschmer wrote:
John McCawley <[EMAIL PROTECTED]> schrieb:
However, in the real world, ...
...And i think, other systems do this:
- begin
- create a new temp. table with the new order
- insert all values from the old table in the new temp. table
- drop the old table
- rename the temp. table to the old table name
- commit
You can do the same, no problem.
Except for the details regarding dependent views and foreign key
references... (as someone mentioned mentioned earlier!). And you
probably wouldn't want to do that on an in-production system, I would
think, although the transaction block prehaps provides appropriate
protection.
Regards,
Berend Tober
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq