From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "ir(dot) F(dot)T(dot)M(dot) van Vugt bc(dot)" <ftm(dot)van(dot)vugt(at)foxi(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL Top 10 Wishlist |
Date: | 2006-01-18 08:18:35 |
Message-ID: | 20060118081835.GA23604@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jan 18, 2006 at 09:10:23AM +0100, ir. F.T.M. van Vugt bc. wrote:
> Op woensdag 18 januari 2006 08:10, schreef Joost Kraaijeveld:
> > Because a lot of tools that I use to manage a database during
> > *development* (e.g. PgAdmin) show the columns in an other order than the
> > order of attributes in my Java/C++ code. The "logical" order of the
> > columns/attributes can change during development.
<snip>
> geleden dat ik daar mee gespeeld heb ;) Je kunt dit terugvinden in 'select *
> from information_schema.columns', maar je zult zelf even terug moeten zoeken
> welke systeemtabellen daar bij zijn betrokken, ik denk overigens dat dit
> pg_attribute.attnum is. Denk eraan dat dit soort wijzigingen in de
> systeemtabellen zonder garantie komen...... ;)
Just to avoid anyone getting strange ideas: editting the catalog
manually has a 100% certainty of trashing any data in the table. Also,
various things like indexes and foreign keys may use the attnum also
and become non-functional. It's entirely possible that on an empty
table with nothing attached that changing attnum manually might work,
but I wouldn't bet on it.
Have a nice day.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Joost Kraaijeveld | 2006-01-18 08:42:36 | Re: PostgreSQL Top 10 Wishlist |
Previous Message | Frank van Vugt | 2006-01-18 08:13:04 | Re: PostgreSQL Top 10 Wishlist |