tag:blogger.com,1999:blog-5541296000399974369.comments2024-03-09T02:51:27.612-05:00Peter Eisentraut's BlogAnonymoushttp://www.blogger.com/profile/02849480732923051923noreply@blogger.comBlogger550125tag:blogger.com,1999:blog-5541296000399974369.post-91516533120843195582018-02-11T02:24:03.906-05:002018-02-11T02:24:03.906-05:00Great post. I am writing some commands that I am g...Great post. I am writing some commands that I am going to run through psql to modify data in a live database and the ability to run the whole thing in a transaction is a great safety net to have. Purbashanoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-62227090724172093652017-11-04T02:29:31.200-04:002017-11-04T02:29:31.200-04:00Perfect! Thanks Peter.Perfect! Thanks Peter.Anihttps://www.blogger.com/profile/09016215367013182386noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-36281952538967679412017-10-30T11:32:12.441-04:002017-10-30T11:32:12.441-04:00Great post Peter. Thought about using magit? We ju...Great post Peter. Thought about using magit? We just wrote an article that may be informative. https://blog.mojotech.com/why-you-should-use-magit-git-porcelain-inside-emacs.Anonymoushttps://www.blogger.com/profile/16335218552725767358noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-84494590559779287772017-10-01T21:47:25.712-04:002017-10-01T21:47:25.712-04:00There's good amount of detail on logging for s...There's good amount of detail on logging for shell scripts via global varaibles of shell. We can emulate the similar kind of logging in shell script as shown here: http://www.cubicrace.com/2016/03/log-tracing-mechnism-for-shell-scripts.html<br /><br />The post has details on introducing log levels like INFO , DEBUG, ERROR. Tracing details like script entry, script exit, function entry, function exit.<br />Piyush Chordiahttps://www.blogger.com/profile/15209398165147441864noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-56120551022619211152017-09-26T08:56:30.207-04:002017-09-26T08:56:30.207-04:00C++ is horrible and ugly language with a lot of pi...C++ is horrible and ugly language with a lot of pitfalls! C++ still don't have formal grammar and that's why is hard to write good IDE for C++. PostgreSQL SHOULD stay with C until end. There are no problems to use modern C (C11 standard). But not C++!Anonymoushttps://www.blogger.com/profile/11884366537276060572noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-22024903229751675552017-07-27T03:07:51.681-04:002017-07-27T03:07:51.681-04:00Thanks a lot ! I spend 4 - 5 hrs to figure out de...Thanks a lot ! I spend 4 - 5 hrs to figure out details fr each command in shell script, IT really helps.<br />Appreciate your time and effort.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-24070490718206725912017-07-05T13:47:18.053-04:002017-07-05T13:47:18.053-04:00It is early, yes. :)It is early, yes. :)Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-19128039433673547712017-07-05T10:53:42.002-04:002017-07-05T10:53:42.002-04:00I understand its early but are you following a par...I understand its early but are you following a particular coding standard?Rui Pachecohttps://www.blogger.com/profile/01390046342162988660noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-28619824853086148662017-05-29T21:26:04.849-04:002017-05-29T21:26:04.849-04:00Some progress has been made lately on making the s...Some progress has been made lately on making the source code C++ compatible.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-13245510618114066672017-04-18T11:16:14.575-04:002017-04-18T11:16:14.575-04:00Any news on this?Any news on this?Rui Pachecohttps://www.blogger.com/profile/01390046342162988660noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-13823913227126075312016-10-22T08:04:46.046-04:002016-10-22T08:04:46.046-04:00I disagree with the "Requiring running throug...I disagree with the "Requiring running through all the upgrade scripts for a fresh deployment" point. For unit tests a simple create script is a better solution, but for production deployments the "Requiring running through all the upgrade scripts for a fresh deployment" is the only SAFE option. If you don't maintain that script from early on, it's likely that it is not working for EVERY published database version. And that would be a desaster.Andreas Kleffelhttps://www.blogger.com/profile/04784176485561904299noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-82436136736693144892016-10-22T07:50:06.866-04:002016-10-22T07:50:06.866-04:00I am more working with SQL Server and I am "s...I am more working with SQL Server and I am "shocked" that PostgreSQL supports generating schema dumps with a standard command line tool. In MSSQL you need to use complex programming APIs to achieve that.Andreas Kleffelhttp://www.sqllink.netnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-33898301111596275652016-10-08T15:14:00.755-04:002016-10-08T15:14:00.755-04:00I have to admit, as a business person considering ...I have to admit, as a business person considering moving my dependencies to Postgres, hearing these discussions give me the 'willies'. First because it's got the open source 'design by committee' process interwoven in it like a sticky ball of worms in a bait can. And then because it reveals 'the most advanced open source database' as 'half-baked' in its primary sense of 'not done'. I got here because I tried to specify 'use database' in a postgres query and then was stunned to hear google say, 'you have to create a new connection'. The meaning of 'flexible' is completely dependent on context: if it means you have to grasp the entirety of all lower level concepts, syntaxes, and techniques to utilize the 'flexibility aspect', flexibility is simply granularity in a prom dress. What these discussions mean is that usability is simply not a concern. And that consequence appears to be the result of an intense impression of the inevitable attraction to the existing syntax by the mature development community based primarily on familiarity (dependency). The bottom line is certainly that the 'postgresness' of postgres is in the loose and amorphous body of code that is exposed for modification and review underneath each of the syntax elements of the ANSI SQL Standard. The point of advancing a technology is to wrap up that messy stuff in neat, meaninful, and syntactically composable features that increase usability, obviousness, and business value propositions. To me, Robert Haas of EDB is the only person who has said anything that makes sense: https://www.youtube.com/watch?v=zsF1vfHBMBI.Kimball Johnsonhttp://www.stateofthemachine.comnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-80647396705067770002016-10-05T08:23:07.425-04:002016-10-05T08:23:07.425-04:00Old post, but still working and very helpful.
Than...Old post, but still working and very helpful.<br />Thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-12207562447612486242016-08-17T18:52:23.559-04:002016-08-17T18:52:23.559-04:00Note, recently Visual Studio started supporting mo...Note, recently Visual Studio started supporting most of C99: http://stackoverflow.com/q/27826409/1708801Shafik Yaghmourhttp://stackoverflow.com/users/1708801/shafik-yaghmournoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-9483679936764121392016-08-17T09:18:13.138-04:002016-08-17T09:18:13.138-04:00Why not Java...
Is GC a real problem ?
(For insta...Why not Java...<br />Is GC a real problem ? <br />(For instance, Cassandra doesn't seem to get in trouble using it)stefhttps://www.blogger.com/profile/13747069786553468064noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-15780317396247164352016-06-12T09:31:32.204-04:002016-06-12T09:31:32.204-04:00No, it wouldn't actually change anything about...No, it wouldn't actually change anything about that.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-74820247882522892532016-06-12T05:58:25.107-04:002016-06-12T05:58:25.107-04:00Will this proposed change make it easier to write ...Will this proposed change make it easier to write pg extensions in C++? The lack of official examples/tutorials make it near impossible for newcomers to reuse C++ code to extend postgresql. All one can find is a half-page principles and suggestions to look at rather large projects such as PL/V8 and PostGIS. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-38991272609046830062016-06-05T14:38:51.036-04:002016-06-05T14:38:51.036-04:00Try export PGCLIENTENCODING=LATIN1.Try export PGCLIENTENCODING=LATIN1.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-10216788316108162702016-06-03T06:53:19.553-04:002016-06-03T06:53:19.553-04:00Hello Peter,
I am new to PostgreSql. Please give ...Hello Peter,<br /><br />I am new to PostgreSql. Please give a solution for my problem.<br />My postgre database is UTF8 encoded. But I need to run a insert script which is having characters set ISO-8859-1<br />when executing this file using psql,getting < ERROR: invalid byte sequence for encoding "UTF8": 0xaa>.<br /><br />I am using the below command <br /><br />PGOPTIONS='--client_encoding=iso-8859-1' psql -X -q -a -1 -v ON_ERROR_STOP=1 --pset pager=off -d myDB -f dump.sql<br /><br />Could yo please suggest a solution ?PKnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-56742481146319165602016-03-02T13:12:23.677-05:002016-03-02T13:12:23.677-05:00There's good amount of detail on logging for s...There's good amount of detail on logging for shell scripts via global varaibles of shell. We can emulate the similar kind of logging in shell script as shown here: http://cubicrace.com/2016/03/efficient-logging-mechnism-in-shell.html<br /><br />The post has details on introducing log levels like INFO , DEBUG, ERROR. Tracing details like script entry, script exit, function entry, function exit.Piyush Chordiahttps://www.blogger.com/profile/15209398165147441864noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-54276480215751829032016-02-11T03:42:33.480-05:002016-02-11T03:42:33.480-05:00Well version 9.5 solved this issue http://stackove...Well version 9.5 solved this issue http://stackoverflow.com/questions/17267417/how-do-i-do-an-upsert-merge-insert-on-duplicate-update-in-postgresqlAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-9693952019496089252015-11-04T22:24:08.277-05:002015-11-04T22:24:08.277-05:00Well, that's an idea, but I don't think an...Well, that's an idea, but I don't think anyone is seriously interested in such a radical change at this point.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-72898054453062354122015-11-04T15:08:31.700-05:002015-11-04T15:08:31.700-05:00Sorry, let me expand on that: Rust has a Foreign F...Sorry, let me expand on that: Rust has a Foreign Function Interface. Mozilla says they're going to start adding Rust to their products incrementally - if something needs refactoring, they'll do it in Rust and call that piece of code from the current C++ codebase.<br /><br />Suggesting Rust because it's effectively C++ done right and contrary to Go it has no garbage collection. You keep the performance of C/C++ with a safer language than C and much smaller than C++.Rui Pachecohttps://www.blogger.com/profile/01390046342162988660noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-16531818651116612032015-10-29T21:06:40.377-04:002015-10-29T21:06:40.377-04:00The idea I was describing here is to keep the exis...The idea I was describing here is to keep the existing code but compile it with a C++ compiler. Rewriting the whole thing in a different language would be a whole different animal.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.com