Thread: BUG #14207: A little is lacking to be the most advanced
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIwNwpMb2dnZWQgYnk6ICAg ICAgICAgIEV1Z2VuZSBRdWFuZ2VyCkVtYWlsIGFkZHJlc3M6ICAgICAgdWdv c3RyYXlAbGlzdC5ydQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNC40Ck9wZXJh dGluZyBzeXN0ZW06ICAgV2luN1BybzY0CkRlc2NyaXB0aW9uOiAgICAgICAg CgpQbGVhc2UgYWRkIEFGVEVSIHRvIGFsdGVyIHRhYmxlIGFkZCBjb2x1bW4g c3ludGF4LiBPZiBjb3Vyc2UgYWxsIHRoZSBjb2x1bW5zCnNob3VsZCBiZSBs aXN0ZWQgaW4gaW5zZXJ0IHN0YXRlbWVudCBhbmQgc3R1ZmYsIGJ1dCBzb21l dGltZXMoYXMgZm9yIG1lIGl0J3MKYWxsIHRoZSB0aW1lKSBmb3IgaHVtYW4g YmVpbmcsIHdobyByZWFkIHRoZSBkYXRhYmFzZSB3aXRoIGhpcyBleWVzIGl0 IGlzCmNvbWZvcnRhYmxlIHRvIGhhdmUgY29sdW1ucyBpbiBjZXJ0YWluIG9y ZGVyLCB0aGUgY29sdW1uIG9yZGVyIGRvZXNuJ3QKbWF0dGVyIG9ubHkgZm9y IHRoZSBtYWNoaW5lLiBJIG1vdmVkIHRvIFBvc3RncmVTUUwgZnJvbSBNeVNR TCBhbmQgSSByZWFsbHkKbWlzcyB0aGlzIGZlYXR1cmUuIEkgdGhvdWdodCAi bW9zdCBhZHZhbmNlZCIgaXMgbWVhbnQgdG8gc3VpdCBhbGwgdXNlcnMuCkRl bWFuZCBzaG91bGQgY3JlYXRlIHN1cHBseS4gQ3JlYXRpbmcgYW5vdGhlciB0 YWJsZSB3aXRoIGFkZGl0aW9uYWwgY29sdW1uCmFuZCByZS1pbnNlcnRpbmcg YWxsIHRoZSBkYXRhIGZyb20gb2xkIHRhYmxlIHRvIGEgbmV3IG9uZSBpcyBu b3QgYSB2ZXJ5CmVsZWdhbnQgc29sdXRpb24uIEkgY2FuJ3QgaGVscCBkaXNs aWtpbmcgUG9zdGdyZVNRTCBiZWNhdXNlIG9mIHRoYXQuIFdoYXQncwp3cm9u ZyBpZiB5b3Ugd2lsbCBpbXBsZW1lbnQgYSBmZWF0dXJlIHRoYXQgd2lsbCBt YWtlIHBlb3BsZSB0byBsaWtlIHRoaXMgREIKRW5naW5lIGV2ZW4gbW9yZSEg SXQncyB0cmlmbGUgYnV0IHZlcnkgcGxlYXNpbmchDQoNCkFuZCBieSB0aGUg d2F5IEkgYWxzbyBtaXNzIFNIT1cgQ1JFQVRFIFRBQkxFKEkga25vdyBob3cg dG8gd29ya2Fyb3VuZCB3aXRoCnRoaXMsIGJ1dCBhIHNtYWxsIHNob3J0Y3V0 IHRoYXQgeW91IGFsd2F5cyByZW1lbWJlciBhbmQgY2FuIHVzZSBpdCBpbgpi ZXR3ZWVuIGlzIGFsc28gdHJpZmxlIGJ1dCB2ZXJ5IHBsZWFzaW5nLiBJdCdz IGxpa2UgeW91IHNheSB0byB5b3VyIGhvbWUKcm9ib3QgLSAiZ2V0IG1lIGN1 cHBhIGNvZmZlZSIsIGFuZCBkb24ndCBjYXJlICdib3V0IGFueXRoaW5nIHlv dSBjYW4gYmUgc3VyZQpoZSdsbCBnZXQgaXQgZG9uZSkKCg==
On Tue, Jun 21, 2016 at 11:14 PM, <ugostray@list.ru> wrote: > The following bug has been logged on the website: > > Bug reference: 14207 > Logged by: Eugene Quanger > Email address: ugostray@list.ru > PostgreSQL version: 9.4.4 > Operating system: Win7Pro64 > Description: > > =E2=80=8BNot a bug.=E2=80=8B Please add AFTER to alter table add column syntax. I presume you want us to do more than just add the syntax...=E2=80=8B Of course all the columns > should be listed in insert statement and stuff, but sometimes(as for me > it's > all the time) for human being, who read the database with his eyes it is > comfortable to have columns in certain order, the column order doesn't > matter only for the machine. I moved to PostgreSQL from MySQL and I reall= y > miss this feature. The feature to separate physical and logical column order does have some demand.=E2=80=8B > I thought "most advanced" is meant to suit all users. > =E2=80=8BThe lack of a single capability another open source database has d= oes not make us less advanced. You need to look at the totality of the offering. While your desire is understandable your point-of-view on this is very biased.=E2=80=8B Demand should create supply. There's this thing called "critical mass". A demand of "one" usually doesn't create supply. Unless, of course, that one person is willing to pay the thousands of dollars necessary to see that their demand is supplied - or do it themselves. Creating another table with additional column > and re-inserting all the data from old table to a new one is not a very > elegant solution. I can't help disliking PostgreSQL because of that. =E2=80=8BYou are entitled to your opinion. Compared to everything else Pos= tgreSQL does well I don't find this lack of this particular feature a detraction.= =E2=80=8B What's > wrong if you will implement a feature that will make people to like this = DB > Engine even more! It's trifle but very pleasing! > =E2=80=8BIts not "trifle" otherwise it would have already=E2=80=8B been don= e (see comment about existing demand). You are welcome to comb the archives on -hackers (and maybe -general) if you like to review past discussions on the topic instead of just taking my word. > And by the way I also miss SHOW CREATE TABLE(I know how to workaround wit= h > this, but a small shortcut that you always remember and can use it in > between is also trifle but very pleasing. It's like you say to your home > robot - "get me cuppa coffee", and don't care 'bout anything you can be > sure > he'll get it done) > =E2=80=8BNoted. David J.
David G. Johnston wrote: > On Tue, Jun 21, 2016 at 11:14 PM, <ugostray@list.ru> wrote: > > And by the way I also miss SHOW CREATE TABLE(I know how to workaround with > > this, but a small shortcut that you always remember and can use it in > > between is also trifle but very pleasing. It's like you say to your home > > robot - "get me cuppa coffee", and don't care 'bout anything you can be > > sure > > he'll get it done) > > âNoted. We've discussed SHOW TABLE in the past (though it was quite long ago). After long discussions about how it would work it ends up being rejected. See the archives. -- Ãlvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services