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 > wrote: Tom, For starters, let's talk strictly about improving the deployment situation, which the core team *is* uniquely positioned to do. The pl/java

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

On Wed, Sep 17, 2014 at 9:42 PM, cowwoc wrote: > Tom, > > For starters, let's talk strictly about improving the deployment > situation, which the core team *is* uniquely positioned to do. > > The pl/java author(s) should figure out what needs to be done but once > that's known we need to do *some

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

Tom, For starters, let's talk strictly about improving the deployment situation, which the core team *is* uniquely positioned to do. The pl/java author(s) should figure out what needs to be done but once that's known we need to do *something* in core so the deployment process is reduced to 1-2

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

John R Pierce writes: > On 9/17/2014 5:02 PM, cowwoc wrote: >> This shouldn't be too technically difficult to pull off. > right. > wait, which user?the java user/developer who typically hasn't a > clue how system-level stuff functions or operates, or the postgresql > database administrat

Re: [GENERAL] encoding confusion with \copy command

On 9/17/2014 6:08 PM, John DeSoi wrote: On Sep 17, 2014, at 11:52 AM, Martin Waite wrote: >You are right that I need an intermediate step. I will probably use a CSV parser that is liberal in what it accepts, but writes out strict CSV data suitable for postgres. > If you find such a utility

Re: [GENERAL] encoding confusion with \copy command

On 09/17/2014 06:08 PM, John DeSoi wrote: On Sep 17, 2014, at 11:52 AM, Martin Waite wrote: You are right that I need an intermediate step. I will probably use a CSV parser that is liberal in what it accepts, but writes out strict CSV data suitable for postgres. If you find such a utili

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

On 9/17/2014 5:02 PM, cowwoc wrote: As far as I understand it, this is the end-user's problem (to be documented) as opposed to a development problem. As far as I know, the jni.h files should be compatible with all other JDKs on the same platforms so you only need to release one DLL/SO per platf

Re: [GENERAL] encoding confusion with \copy command

On Sep 17, 2014, at 11:52 AM, Martin Waite wrote: > You are right that I need an intermediate step. I will probably use a CSV > parser that is liberal in what it accepts, but writes out strict CSV data > suitable for postgres. > If you find such a utility, please share. My clients love Exce

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

As far as I understand it, this is the end-user's problem (to be documented) as opposed to a development problem. As far as I know, the jni.h files should be compatible with all other JDKs on the same platforms so you only need to release one DLL/SO per platforms (like you would if this was pla

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

On 9/17/2014 3:07 PM, cowwoc wrote: Can you be more specific? Are you talking about load-time linking against jvm.dll/so? $JAVA_HOME/jre/lib/amd64/server/libjvm.so or whatever, yeah.the path of that relative to $JAVA_HOME is rather variable, depending on a lot of things, like 32 vs 64

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 Postgresql and was as easy to inst

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

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 Postgresql and was as easy to install as "CREATE EXTENSION pljava" then we wouldn't be having this discus

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 it was s

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] [SQL] pg_multixact issues

On 09/17/2014 01:36 PM, Dev Kumkar wrote: On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar mailto:devdas.kum...@gmail.com>> wrote: On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: http://www.postgresql.org/__docs/9.3/static/routine-__vacuumin

Re: [GENERAL] [SQL] pg_multixact issues

On 09/17/2014 01:36 PM, Dev Kumkar wrote: On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar mailto:devdas.kum...@gmail.com>> wrote: On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: http://www.postgresql.org/__docs/9.3/static/routine-__vacuumin

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

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 It is hard to > > believe, so there can be 3 developers, who start work on PL/

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

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 It is hard to > believe, so there can be 3 developers, who start work on PL/Java. Stupid, completely offensive guess: Most Java p

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

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 it was stuck in a transition of the build system fro

Re: [GENERAL] Regarding timezone

On 09/17/2014 01:14 PM, Dev Kumkar wrote: On Thu, Sep 18, 2014 at 1:22 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 09/17/2014 12:26 PM, Dev Kumkar wrote: I hope the binaries archive containing ""pgsql/share/postgresql/ timezone/Europe/Moscow" uploaded at

Re: [GENERAL] [SQL] pg_multixact issues

On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar wrote: > On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver > wrote: > >> >> http://www.postgresql.org/docs/9.3/static/routine- >> vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND >> > Looked into these details. Can there be an example explained that will re

Re: [GENERAL] Regarding timezone

On Thu, Sep 18, 2014 at 1:22 AM, Adrian Klaver wrote: > On 09/17/2014 12:26 PM, Dev Kumkar wrote: > >> I hope the binaries archive containing ""pgsql/share/postgresql/ >> timezone/Europe/Moscow" uploaded at >> http://www.enterprisedb.com/products-services-training/pgbindownload >> will also get c

Re: [GENERAL] Regarding timezone

On 09/17/2014 12:26 PM, Dev Kumkar wrote: On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: The next set of minor releases, whenever those are (and no, there's no schedule). I hope the binaries archive containing ""pgsql/share/postgresql/ timezone/Europe/Mos

Re: [GENERAL] Regarding timezone

On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane wrote: > The next set of minor releases, whenever those are (and no, there's > no schedule). > I hope the binaries archive containing ""pgsql/share/postgresql/ timezone/Europe/Moscow" uploaded at http://www.enterprisedb.com/products-services-training/pg

Re: [GENERAL] Regarding timezone

Dev Kumkar writes: > Which upgraded postgres version will have the corrected Moscow timezone? The next set of minor releases, whenever those are (and no, there's no schedule). > Tom, can you too provide your comments on the mentioned hack here. It would break timezone reporting for historical M

Re: [GENERAL] Regarding timezone

On Wed, Sep 17, 2014 at 8:52 PM, Adrian Klaver wrote: > > I am not that versed in the timezone handling to make a definitive > statement. I would say it should work until you upgrade. At that point the > new Moscow timezone should be correct and the change will not matter. I > would verify on the

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] encoding confusion with \copy command

You are right that I need an intermediate step. I will probably use a CSV parser that is liberal in what it accepts, but writes out strict CSV data suitable for postgres. Thanks for the help. On 17 September 2014 15:40, Adrian Klaver wrote: > On 09/17/2014 06:48 AM, Martin Waite wrote: > >> Hi

Re: [GENERAL] strange problem with not existing roles

On 09/17/2014 08:08 AM, lud...@kni-online.de wrote: Hi list, I have a strange problem in postgres (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 64-bit), there are granted privileges on schemas, tables, columns for roles that don't exist. So how did the data get into the database? Exa

Re: [GENERAL] Regarding timezone

On 09/17/2014 07:53 AM, Dev Kumkar wrote: On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: So you will need to determine what method you binaries use. If they are using the system timezone data, you will need to update that. Thanks! Just a hack

[GENERAL] strange problem with not existing roles

Hi list, I have a strange problem in postgres (PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 64-bit), there are granted privileges on schemas, tables, columns for roles that don't exist. Example: In pgAdmin for schema user_data the follwing wrong grants are reported: ... GRANT ALL ON SCHEM

Re: [GENERAL] [SQL] pg_multixact issues

On Wed, Sep 17, 2014 at 7:20 PM, Dev Kumkar wrote: > Thanks, yes have been looking into pg_stat_activity table and somehow the > standard queries are hanging. > Not sure if this is because the database response has become very slow. > Would having a huge pg_multixact directory have an impact on

Re: [GENERAL] Regarding timezone

On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver wrote: > So you will need to determine what method you binaries use. If they are > using the system timezone data, you will need to update that. Thanks! Just a hack here, how about copying "pgsql/share/postgresql/timezone/Etc/GMT-3" as "pgsql/shar

Re: [GENERAL] encoding confusion with \copy command

On 09/17/2014 06:48 AM, Martin Waite wrote: Hi Adrian, I apologise - I meant 9.4 Looks like you will need an intermediate step. A quick search found the below which might offer a solution: http://www.excel-sql-server.com/sql-server-export-to-excel-using-bcp-sqlcmd-csv.htm FYI the good stuf

Re: [GENERAL] Regarding timezone

On 09/16/2014 11:43 PM, Dev Kumkar wrote: On Tue, Sep 16, 2014 at 6:16 PM, Dev Kumkar mailto:devdas.kum...@gmail.com>> wrote: On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: What OS and what packaging? For both windows-64-bit and Li

Re: [GENERAL] pg_multixact issues

On Wed, Sep 17, 2014 at 6:53 PM, Andres Freund wrote: > On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote: > > On one my machine the pg_multixact directory size has grown up to 5 GB > and > > am not sure how to clean up this directory. > > Which version of postgres are you using? > > Greetings, > >

Re: [GENERAL] [SQL] pg_multixact issues

On Wed, Sep 17, 2014 at 6:51 PM, Adrian Klaver wrote: > > http://www.postgresql.org/docs/9.3/static/routine- > vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND > > Might also want to take a look at pg_stat_activity to see what queries > maybe hanging up: > > > http://www.postgresql.org/docs/9.3/sta

Re: [GENERAL] encoding confusion with \copy command

On 09/17/2014 03:03 AM, Martin Waite wrote: Hi, I have a postgresql 7.4 server and client on Centos 6.4. The database server is using UTF-8 encoding. First I think we need to establish what version of Postgres you using. Are you really using 7.4? I have been exploring the use of the \cop

Re: [GENERAL] encoding confusion with \copy command

Hi Adrian, I apologise - I meant 9.4 regards, Martin On 17 September 2014 14:35, Adrian Klaver wrote: > On 09/17/2014 03:03 AM, Martin Waite wrote: > >> Hi, >> >> I have a postgresql 7.4 server and client on Centos 6.4. The database >> server is using UTF-8 encoding. >> > > First I think we n

Re: [GENERAL] pg_multixact issues

On 2014-09-17 17:46:05 +0530, Dev Kumkar wrote: > On one my machine the pg_multixact directory size has grown up to 5 GB and > am not sure how to clean up this directory. Which version of postgres are you using? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadr

Re: [GENERAL] [SQL] pg_multixact issues

On 09/17/2014 05:16 AM, Dev Kumkar wrote: Hello, On one my machine the pg_multixact directory size has grown up to 5 GB and am not sure how to clean up this directory. From the storage-file-layout this directory contains multitransaction status data. pg_multixactSubdirectory containing mu

[GENERAL] pg_multixact issues

Hello, On one my machine the pg_multixact directory size has grown up to 5 GB and am not sure how to clean up this directory. >From the storage-file-layout this directory contains multitransaction status data. pg_multixactSubdirectory containing multitransaction status data (used for shared row l

[GENERAL] encoding confusion with \copy command

Hi, I have a postgresql 7.4 server and client on Centos 6.4. The database server is using UTF-8 encoding. I have been exploring the use of the \copy command for importing CSV data generated by SQL Server 2008. SQL Server 2008 export tool does not escape quotes that are in the content of fields,