Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 19/09/2014 4:30 AM, Szymon Guz wrote: I think all people here agree that adding another package to linux repository or an option to windows installer is OK. What some people disagree here is adding jre to the core postgres. So we're in agreement. Oh, and btw, I've got a package named postg

Re: [GENERAL] Why isn't Java support part of Postgresql core?

I am beginning to feel like people are putting words in my mouth :) I agree with most of what you said. I will only comment on the differences: There is nothing special in java, that's just another language like perl, python and tcl. I don't see any reason to treat that differently. I don't d

[GENERAL] Reserved keywords and qualified identifiers

Hi, http://dev.mysql.com/doc/refman/5.7/en/reserved-words.html explicitly states that qualified identifiers do not have to be quoted even if they are reserved keywords ("A word that follows a period in a qualified name must be an identifier, so it need not be quoted even if it is reserved"). http

[GENERAL] 64-bit TXID?

Hi, A recent discussion in Slashdot brought up the topic of PostgreSQL's 32-bit TXID system: http://slashdot.org/comments.pl?sid=5725497&cid=47942637 I did a quick search and noticed that 8 years ago, a Skype employee provided a patch for migrating to a 64-bit TXID: http://postgresql.1045698.n5.n

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 18/09/2014 4:26 PM, David G Johnston [via PostgreSQL] wrote: > ​ "only PostgreSQL uses it" ... PostgreSQL doesn't use Java. I don't think it makes a difference from a licensing point of view. The point is that the JRE is not used to run multiple distinct applications. > You want PostgreSQL to

Re: [GENERAL] Why isn't Java support part of Postgresql core?

Companies stick to Java 6 company-wide precisely because updating a public JRE would affect their other applications. Replacing a private JRE would not do that. Gili On 18/09/2014 3:40 PM, Guy Rouillier-4 [via PostgreSQL] wrote: > On 9/18/2014 2:44 PM, cowwoc wrote: > > Yes, that

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 18/09/2014 3:17 PM, John R Pierce [via PostgreSQL] wrote: > On 9/18/2014 11:44 AM, cowwoc wrote: > > > > Yes, that's what I meant. I just wanted to reinforce the fact that you > > don't need to bundle multiple JVMs (Oracle, OpenJDK and GCJ). You'd > pick

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 18/09/2014 2:21 PM, John R Pierce [via PostgreSQL] wrote: > > Right, so to recap: each platform will only need one jvm.dll/so library > > (which you would update over time). You don't need to include one > > version for Oracle JDK, OpenJDK, GCJ. You'd pick one, and bundle its > > jvm.dll (I'd su

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 18/09/2014 1:31 PM, John R Pierce [via PostgreSQL] wrote: > On 9/18/2014 10:17 AM, Szymon Guz wrote: > > Does it mean that there should be distributed many jvm.dlls for each > > of the jvm versions? > > jvm.dll is part of the jre, its not a standalone library. Right, so to recap: each platform

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 18/09/2014 9:18 AM, David G Johnston [via PostgreSQL] wrote: > What distributions of JRE are available on the Windows platform and > which ones are allowed to be "privately distributed"? (Answered in a follow-up email to John Pierce) > For this scenario your target audience is the people, at

Re: [GENERAL] Why isn't Java support part of Postgresql core?

John, You are confusing a private JRE installation with the public JRE installation (yes, there is such a thing). The public JRE is found in java/jre8. The private JRE is found in java/jdk1.8.0_20/jre. http://www.oracle.com/technetwork/java/javase/jdk-8-readme-2095712.html#redistribution give

Re: [GENERAL] Why isn't Java support part of Postgresql core?

Chris, On 18/09/2014 1:07 AM, Chris Travers wrote: On Wed, Sep 17, 2014 at 9:42 PM, cowwoc <mailto:cow...@bbs.darktech.org>> wrote: Tom, For starters, let's talk strictly about improving the deployment situation, which the core team *is* uniquely positioned to do.

Re: [GENERAL] Why isn't Java support part of Postgresql core?

duced to 1-2 steps max (CREATE EXTENSION pljava, and add Java to Postgresql's library path). Gili On 18/09/2014 12:31 AM, Tom Lane-2 [via PostgreSQL] wrote: > John R Pierce <[hidden email] > > writes: > > On 9/17/2014 5:02 PM, cowwoc wrote: > >> This shouldn&

Re: [GENERAL] Why isn't Java support part of Postgresql core?

s was plain C) and it is then up to the user to make sure the Postgres process has the right JRE DLL/SO in its PATH. This shouldn't be too technically difficult to pull off. Gili On 17/09/2014 6:26 PM, John R Pierce [via PostgreSQL] wrote: > On 9/17/2014 3:07 PM, cowwoc wrote: > >

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 17/09/2014 6:04 PM, John R Pierce [via PostgreSQL] wrote: > On 9/17/2014 2:50 PM, cowwoc wrote: > > I think it would be much more productive to fix the deployment problem > > (instead of throwing more documentation at it). If the extension came > > bundled with Postgres

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 17/09/2014 4:51 PM, Peter Eisentraut wrote: On 9/15/14 1:30 PM, cowwoc wrote: Any chance you guys could help cleaning up the build/deploy process? This is a pretty big hurdle to overcome for new users. I'm glad to hear that PL/Java is still working well for some people. Last I saw i

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 17/09/2014 5:05 PM, Pavel Stehule wrote: 2014-09-17 22:54 GMT+02:00 Peter Eisentraut >: On 9/15/14 1:46 PM, Pavel Stehule wrote: > I am strong sceptic. There is relative slow progress in JDBC driver, > that is 100x more important project than PL/Java - so I

Re: [GENERAL] Feature request: temporary schemas

Hi guys, I wanted to update you on this topic. Pete provided an excellent answer at http://dba.stackexchange.com/a/76661/4719 that almost worked (we couldn't find a solution for functions) but it turns out that my original problem definition was incorrect. I assumed that my unit tests only use on

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 15/09/2014 3:50 PM, Thomas Kellerer [via PostgreSQL] wrote: > cowwoc wrote on 15.09.2014 19:55: > > H2, HSQLDB, Derby all support Java triggers. > > But only because they already live/run inside a JVM, so it's the > "natural" choice of language. > > And

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 15/09/2014 2:12 PM, cowwoc wrote: > On 15/09/2014 2:02 PM, lup [via PostgreSQL] wrote: >> On 09/15/2014 11:49 AM, cowwoc wrote: >>> I think developers choosing this route (myself included) are willing >>> to pay the price in exchange for improved >>&

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 15/09/2014 2:02 PM, lup [via PostgreSQL] wrote: > On 09/15/2014 11:49 AM, cowwoc wrote: >> I think developers choosing this route (myself included) are willing >> to pay the price in exchange for improved readability/maintainability >> (the assumption being that the resul

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 15/09/2014 1:51 PM, Pavel Stehule [via PostgreSQL] wrote: > and I am not sure if Java as stored procedures is living technology, > It was designed as "esperanto", but it is supported only by Oracle > after 14 years. > > Pavel H2, HSQLDB, Derby all support Java triggers. Granted, we are not ta

Re: [GENERAL] Why isn't Java support part of Postgresql core?

Hi Pavel, On 15/09/2014 1:40 PM, Pavel Stehule wrote: The main drivers are: 1. Not having to learn yet another language. I find the expressiveness and readability of the other scripting languages very clunky compared to Java. PLpgSQL is different, it is based on Ada langu

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 15/09/2014 7:58 AM, Bill Moran wrote: On Sun, 14 Sep 2014 22:22:21 -0700 (PDT) cowwoc wrote: Out of curiosity, why is Postgresql's Java support so poor? To trampoline off what others have said: it gets implemented and maintained if people want/need it. But I feel like I have a little

Re: [GENERAL] Why isn't Java support part of Postgresql core?

On 15/09/2014 7:03 AM, Chris Travers wrote: I have a few questions on this, the answers of which may help answer your question: 1. How well does having a server-side JVM work, resource-wise, when you have a forked process model like PostgreSQL? Does having the additional JVM's pose performa

Re: [GENERAL] Why isn't Java support part of Postgresql core?

Hi guys, Any chance you guys could help cleaning up the build/deploy process? This is a pretty big hurdle to overcome for new users. Gili On 15/09/2014 8:55 AM, Tim Clarke [via PostgreSQL] wrote: > On 15/09/14 13:30, Achilleas Mantzios wrote: > > > > > This is far from dead. I works perfectly w

Re: [GENERAL] Feature request: temporary schemas

On 15/09/2014 10:37 AM, Adrian Klaver wrote: From your second post: " 1. I'm already planning to run unit tests against a separate (but identical) database than production, so there's no danger of wiping out the production database. 2. I need to create a new temporary schema per test, a

Re: [GENERAL] Feature request: temporary schemas

On 15/09/2014 9:39 AM, Adrian Klaver wrote: Not exactly. Each test is responsible for populating its own schema (creating tables, inserting data). The main purpose of using temporary schemas is to ensure that each test runs in isolation so that data from other tests cannot influence the outcome

[GENERAL] Why isn't Java support part of Postgresql core?

Hi, Out of curiosity, why is Postgresql's Java support so poor? I am specifically looking for the ability to write triggers in Java. I took a look at the PL/Java project and it looked both incomplete and dead, yet other languages like Javascript are taking off. I would have expected to see very s

Re: [GENERAL] Feature request: temporary schemas

Hi Adrian, Replies below. On 14/09/2014 8:34 PM, Adrian Klaver wrote: On 09/14/2014 02:01 PM, cowwoc wrote: See http://dba.stackexchange.com/q/76494/4719 for a related discussion. So from the above link and the discussion here so far I gather you want: 1) A CREATE TEMPORARY SCHEMA that

Re: [GENERAL] Feature request: temporary schemas

PM, Nick Guenther [via PostgreSQL] wrote: > > > On September 14, 2014 5:01:54 PM EDT, cowwoc <[hidden email] > > wrote: > >Hi, > > > >I'd like to propose the ability to create temporary schemas. > > > >This would facilitate running unit tests, wher

[GENERAL] Feature request: temporary schemas

Hi, I'd like to propose the ability to create temporary schemas. Unlike temporary tables, this feature would enable developers to create a temporary schema once and execute CREATE TABLE statements without the TEMPORARY parameter. This would facilitate running unit tests, where developers would l