Re: [HACKERS] Developers page is down
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write: By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. What do you mean by in a middle of a table? A relation is simply a set of attributes that _don't_ forcibly have an order, because sets are unordered. -- output = reverse(gro.gultn @ enworbbc) http://cbbrowne.com/info/nonrdbms.html What we need is either less corruption, or more chance to participate in it. -- Unknown ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Developers page is down
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shahbaz Javeed wrote: | I've always considered a table definition to be an unordered hash so | the concept of putting something in the middle of a table from that | view doesn't seem to have a point. | | Just my $0.02 I already wrote my motivation, and I'll do again. In our development environment we have a .sql file for each table, view, function. The schema creation is Makefile driven and the development three is divided in packages / projects. Each project and packages are composed by various components. I try to organize the table definition grouping the homogeneous field together: Suppose that this is the definition of a table: CREATE TABLE foo ( a1 INTEGER, ~a2 VARCHAR, ~... ~an FLOAT, ~b1 ~... ~bn ... ); some time ( fortunately not so often ) you need to add a field to that table that for homogeneity is a(n+1). Some time is also not possible to split foo in two tables for various reasons: ~ - is not possible define multitable constraint, of course ~is possible with triggers but is more work: a function ~trigger to maintain and test. ~ - is not possible to define a multitable index and no ~work around for this, in my knowledge at least. What we do actually is put that field at the end and not in his logical place, this because before to apply the new schema in production I do a diff between the production schema and the development schema. You can argue that is the diff tool that must be fixed however is hard to work with a table in production that is dumped/displayed by various tools: pgaccess, dbvisualizer, pgadminII/III, enterprise architect, visio,... in a different way your development table. This is why in our coding rule we have - New fields must be added at the end. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBOt717UpzwH2SGd4RAuuZAJwKkDVpwgRNI0vQJ4TC7qllQjH5XgCgmrKv kqwKVVO3ha+FUsQHggyfyvU= =z9y4 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Developers page is down
Jaime Casanova wrote: Hi guys i was looking for the http://developer.postgresql.org/todo.php in order to view what things are you posponing for later versions but the entire developer.postgresql.org site is down. By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. No IIRC. The core doesn't think this is a valid feature. I had in the past my reasons to ask for it too. If you have yours may be... Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Developers page is down
Christopher Browne wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write: By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. What do you mean by in a middle of a table? A relation is simply a set of attributes that _don't_ forcibly have an order, because sets are unordered. Means the order that \d show the columns ( for example ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Developers page is down
I've always considered a table definition to be an unordered hash so the concept of putting something in the middle of a table from that view doesn't seem to have a point. Just my $0.02 Shahbaz Javeed On Sat, 04 Sep 2004 21:44:24 +0200, Gaetano Mendola [EMAIL PROTECTED] wrote: Christopher Browne wrote: Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write: By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. What do you mean by in a middle of a table? A relation is simply a set of attributes that _don't_ forcibly have an order, because sets are unordered. Means the order that \d show the columns ( for example ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Shahbaz Javeed ---(end of broadcast)--- TIP 8: explain analyze is your friend
[HACKERS] Developers page is down
Hi guys i was looking for the http://developer.postgresql.org/todo.php in order to view what things are you posponing for later versions but the entire developer.postgresql.org site is down. By the way, will be a way in postgresql 8 to add a column in a middle of a table. just curious. thanx in advance, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend