tag:blogger.com,1999:blog-2356137376934964551.comments2023-06-14T06:01:24.499-04:00Andrew Dunstan's PostgreSQL and Technical blogAndrew Dunstanhttp://www.blogger.com/profile/04684286585449188201noreply@blogger.comBlogger310125tag:blogger.com,1999:blog-2356137376934964551.post-69972689979417326052021-07-22T10:09:50.533-04:002021-07-22T10:09:50.533-04:00many thanksmany thanksasdklhfdshttps://www.blogger.com/profile/08286870512431664130noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-23851735500060669522021-06-20T11:14:55.066-04:002021-06-20T11:14:55.066-04:00Turns out it's even simpler than this. Watch t...Turns out it's even simpler than this. Watch the git repo. :-)Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-71438757421695751912020-04-30T04:01:24.849-04:002020-04-30T04:01:24.849-04:00currently it is not clear where i should store gra...currently it is not clear where i should store grabbed js code? in which location?dardevhttps://www.blogger.com/profile/11867788411452941498noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-29635093902900294172019-12-11T09:48:19.785-05:002019-12-11T09:48:19.785-05:00Came across this when planning to drop columns on ...Came across this when planning to drop columns on a partitioned table in postgres 12. When running your script, it came out that the columns already were dropped in the child tables even though they were defined before they were set up as partitions.<br /><br />Anyhow, thanks :-)Morten Sickelhttps://www.blogger.com/profile/02891447332362225572noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-7409084410906885392017-01-15T08:49:28.412-05:002017-01-15T08:49:28.412-05:00Yeah. I just tried and got a permissions error. I ...Yeah. I just tried and got a permissions error. I don't know any other way, sorry.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-66400463796667388072017-01-13T17:57:20.259-05:002017-01-13T17:57:20.259-05:00@Maurits were you saying that works in Amazon RDS...@Maurits were you saying that works in Amazon RDS? I've never been able to run ALTER DATABASE commands in RDS. Always get a permission error. I assumed it was because of the locked down nature of RDS.Anonymoushttps://www.blogger.com/profile/07392832595511202834noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-22342438738019925782017-01-05T17:10:36.113-05:002017-01-05T17:10:36.113-05:00Just for the record: yes it does: "ALTER DATA...Just for the record: yes it does: "ALTER DATABASE dbname SET plv8.start_proc = 'plv8_startup';"Maurits Lamershttps://www.blogger.com/profile/04928830065162315067noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-35872963634001926412016-08-08T12:13:48.767-04:002016-08-08T12:13:48.767-04:00Yeah, that's reasonable. Thanks.Yeah, that's reasonable. Thanks.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-90566977281727655182016-08-08T12:09:03.878-04:002016-08-08T12:09:03.878-04:00EXECUTE format('EXPLAIN (FORMAT json) %s',...EXECUTE format('EXPLAIN (FORMAT json) %s', myquery) INTO exp;<br />RAISE NOTICE 'rows: %', exp#>>'{0,Plan,Plan Rows}';xocolatlhttps://www.blogger.com/profile/10075944893945740105noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-69002111200722256842016-07-14T08:29:33.182-04:002016-07-14T08:29:33.182-04:00You set it in via plv8.start_proc in postgresql.co...You set it in via plv8.start_proc in postgresql.conf, as the post says.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-51685811232185684532016-07-14T08:26:45.672-04:002016-07-14T08:26:45.672-04:00Setting it on the database via ALTER DATABASE migh...Setting it on the database via ALTER DATABASE might work. Try it and see.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-25110188611235608642016-06-02T01:41:33.499-04:002016-06-02T01:41:33.499-04:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/02278780378574470222noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-18661686495009378922016-06-02T00:46:28.219-04:002016-06-02T00:46:28.219-04:00Especially nested views. That just made it worse.Especially nested views. That just made it worse.Anonymoushttps://www.blogger.com/profile/02278780378574470222noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-2367893486824178452016-06-02T00:44:42.228-04:002016-06-02T00:44:42.228-04:00Ha! I was there. It was because we used a lot of v...Ha! I was there. It was because we used a lot of views, and mix CTEs into views on top of large tables, and things go south fast, which sucks because they're waaaaay easier to read with the CTEs :(Anonymoushttps://www.blogger.com/profile/02278780378574470222noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-47251610293540419832016-06-01T18:39:03.304-04:002016-06-01T18:39:03.304-04:00That seems a bit excessive.That seems a bit excessive.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-86999205710110939952016-06-01T18:13:05.614-04:002016-06-01T18:13:05.614-04:00At a former job, I imposed a ban on all use of CTE...At a former job, I imposed a ban on all use of CTEs unless you were doing recursion. It was unfortunate that I had to do so, as the CTE syntax is MUCH nicer than nested subqueries, but it was just way too easy for people to materialize huge chunks of data without even knowing it.Anonymoushttps://www.blogger.com/profile/10225165980320590149noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-46769615409274362862016-06-01T12:39:09.515-04:002016-06-01T12:39:09.515-04:00So true.So true.Jacobhttps://www.blogger.com/profile/16485447956156668102noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-31355180170991107182016-04-17T21:59:50.024-04:002016-04-17T21:59:50.024-04:00Hi, I made a VS Project for This exact situation. ...Hi, I made a VS Project for This exact situation. https://github.com/jmguazzo/pg_empty JMGhttps://www.blogger.com/profile/03054036082815628144noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-59660837881404357022016-03-19T23:17:14.391-04:002016-03-19T23:17:14.391-04:00This comment has been removed by the author.Tostinohttps://www.blogger.com/profile/17330018990492429849noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-68222239576305241882016-03-19T23:16:04.584-04:002016-03-19T23:16:04.584-04:00Extremely happy to see this in. Fingers crossed t...Extremely happy to see this in. Fingers crossed that we get both this and UUID support in 9.7 (if UUID support isn't in 9.6 that is, last I saw it was stalled). It's been a pain having to work around the limitation for exclusion constraints in my databases.<br /><br />Thanks for the work on this!Tostinohttps://www.blogger.com/profile/17330018990492429849noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-24035199222301465332016-03-19T16:24:56.500-04:002016-03-19T16:24:56.500-04:00Aha!Aha!Colin 't Harthttps://www.blogger.com/profile/15623835285718803326noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-83252724948205016442016-03-19T16:19:17.597-04:002016-03-19T16:19:17.597-04:00We are several weeks past the date for accepting n...We are several weeks past the date for accepting new features for 9.6.Andrew Dunstanhttps://www.blogger.com/profile/04684286585449188201noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-39892470690462264922016-03-19T12:31:21.494-04:002016-03-19T12:31:21.494-04:00Do you mean "too late for 9.5"? Otherwis...Do you mean "too late for 9.5"? Otherwise I fail to see why this couldn't make 9.6?Colin 't Harthttps://www.blogger.com/profile/15623835285718803326noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-72419090939113102162016-01-15T13:20:48.374-05:002016-01-15T13:20:48.374-05:00PostgreSQL is more and more becoming the Swiss Arm...PostgreSQL is more and more becoming the Swiss Army Knife of databases. Love this use case. (I will be using it, for sure!)Ross Reedstromhttps://www.blogger.com/profile/05592010675819388393noreply@blogger.comtag:blogger.com,1999:blog-2356137376934964551.post-41473697985035331992016-01-08T04:54:15.641-05:002016-01-08T04:54:15.641-05:00Thanks !!Thanks !!Faisal K Khttps://www.blogger.com/profile/16885541031873516465noreply@blogger.com