Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

Yogesh Sharma wrote: > I have doubt regarding release notes of all versions. > As per release notes, below change logs are mentioned in all versions. > > "(8.3.8,8.4.1,8.2.14) Make LOAD of an already-loaded loadable module into a > no-op (Tom Lane)" > 1. What is meaning of above lines? > 2. This

Re: [GENERAL] PgQ and pg_dump

Martin wrote: > I wonder if this is the desirable way of handling pgq, or if those > tables should be dumped. I'm starting to think that this is a PgQ bug, > or maybe it's not a good idea to install PgQ as an extension. As I am looking at that I would qualify that as a bug in pg_dump. Schemas can

Re: [GENERAL] PgQ and pg_dump

Hi Michael, 2016-06-15 5:00 GMT-03:00 Michael Paquier : > Martin wrote: >> I wonder if this is the desirable way of handling pgq, or if those >> tables should be dumped. I'm starting to think that this is a PgQ bug, >> or maybe it's not a good idea to install PgQ as an extension. > > As I am looki

[GENERAL] Question about RUM-index

Hi.   First; Is this the correct forum to ask questions about the Postgres Pro's new RUM-index?   If not, please point me to the right forum.   I'm trying to do this (done with GIN):   create extension if not exists btree_gin; drop table if EXISTS delivery; create tabledelivery( id BIGSERIAL prim

[GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

Hi sir This is mahesh. i got following erro when i ran ./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly -allTables dbo below error generated as i have given correct credentials to connect respective server & database how to rectify this issue sirplease let me know Ru

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On Wed, Jun 15, 2016 at 8:31 AM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > Running EnterpriseDB Migration Toolkit (Build 49.0.4) ... > ​You should contact the supplier of this tool using their support channels. The community is not responsible for this product. I will note that by

Re: [GENERAL] Question about RUM-index

On Wed, Jun 15, 2016 at 6:56 AM, Andreas Joseph Krogh wrote: > Hi. > > First; Is this the correct forum to ask questions about the Postgres Pro's > new RUM-index? > ​-general is fairly broad in scope and the authors do monitor here as far as I am aware. I'm not sure this is strictly related to

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

On Wed, Jun 15, 2016 at 3:31 AM, Albe Laurenz wrote: > Yogesh Sharma wrote: > > I have doubt regarding release notes of all versions. > > As per release notes, below change logs are mentioned in all versions. > > > > "(8.3.8,8.4.1,8.2.14) Make LOAD of an already-loaded loadable module > into a no

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

> 8.2, 8.3, and 8.4 are all Major releases of the PostgreSQL product. For > most other products it would as if the numbering went from "15, to 16, to > 17". The last 8.x release was 8.4 (so, there were 5 major releases that all > shared the same prefix value of 8) and the 9.x series goes from 9.0

Re: ***SPAM*** Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

On 06/14/2016 09:49 PM, Catalin Maftei wrote: hei Adrian, thx for your reply, this is an example: "CREATE OR REPLACE VIEW feedback.get_answers_set AS SELECT f.awb || '/' || r.dulapid as "awb", q.qid, q.question, a.aid, a.answer, q.questionareid, f.stamp_created , c

[GENERAL] Moving from PHP to Java: A result was returned when none was expected.

Good afternoon, at PostgreSQL 9.5.3 I have a stored function (full source code below) returning void, which I successfully call with PHP: function skipGame($dbh, $uid, $gid) { $sth = $dbh->prepare('SELECT words_skip_game(?, ?)'); $sth->execute(array($uid, $gid)); } Now I am tryin

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

Actually I meant the doc https://jdbc.postgresql.org/documentation/94/update.html

Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

On Wed, Jun 15, 2016 at 12:36 AM, Adrian Klaver wrote: > On 06/14/2016 02:59 PM, Catalin Maftei wrote: > >> when I recreate a VIEW or FUNCTION with a small change I get: >> > > What are the actual statements you are running? > > What program are you running them from? > > Is the server you are ru

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

On Wed, Jun 15, 2016 at 9:52 AM, Rakesh Kumar wrote: > > 8.2, 8.3, and 8.4 are all Major releases of the PostgreSQL product. For > > most other products it would as if the numbering went from "15, to 16, to > > 17". The last 8.x release was 8.4 (so, there were 5 major releases that > all > > sh

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote: > Now I am trying to call the same function through JDBC driver 9.4.1208.jre7: > > private static final String SQL_SKIP_GAME = > "SELECT words_skip_game(?, ?)"; > > try (PreparedStatement st = > mDatabase

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

Hello Jan, On Wed, Jun 15, 2016 at 4:17 PM, Jan de Visser wrote: > On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote: > > Now I am trying to call the same function through JDBC driver > 9.4.1208.jre7: > > > > private static final String SQL_SKIP_GAME = > > "SELE

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 4:21:47 PM EDT Alexander Farber wrote: > Hello Jan, > > On Wed, Jun 15, 2016 at 4:17 PM, Jan de Visser wrote: > > On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote: > > > Now I am trying to call the same function through JDBC driver > > > > 9.4.1208.jr

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote: > > Point is that you're doing a SELECT. A SELECT returns a result, which can > be > empty. I would use executeQuery and ignore the result. > > There is a bit of a mismatch between the JDBC stored procedure model and > the > pgsql function mo

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote: > On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote: > > Point is that you're doing a SELECT. A SELECT returns a result, which can > > be > > empty. I would use executeQuery and ignore the result. > > > > There is a bit of a

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote: > On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote: > > Point is that you're doing a SELECT. A SELECT returns a result, which can > > be > > empty. I would use executeQuery and ignore the result. > > > > There is a bit of a

Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

-- Forwarded message -- From: David G. Johnston Date: Wed, Jun 15, 2016 at 8:40 PM Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh To: Durgamahesh Manne On Wed, Jun 15, 2016 at 11:00 AM, Durgamahesh Manne < maheshpostgr...@gmail.c

Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

-- Forwarded message -- From: Durgamahesh Manne Date: Wed, Jun 15, 2016 at 8:57 PM Subject: Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh To: pgsql-general@postgresql.org Cc: "David G. Johnston" -- Forwarded message --

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wed, Jun 15, 2016 at 11:24 AM, Jan de Visser wrote: > On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote: > > On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser > wrote: > > > Point is that you're doing a SELECT. A SELECT returns a result, which > can > > > be > > > empty. I wou

[GENERAL] Looking for a good programming reference

So, I am a decent oracle SQL and PL/SQL programmer looking to expand into PostgreSQL. Can someone point me to a decent programming book on the topic? I have looked Amazon and Apress and not found much, so I am not sure where to turn. Or perhaps I am looking the wrong places. -- Andrew W. Kerbe

Re: [GENERAL] Looking for a good programming reference

On Wed, Jun 15, 2016 at 12:01 PM, Andrew Kerber wrote: > So, I am a decent oracle SQL and PL/SQL programmer looking to expand into > PostgreSQL. Can someone point me to a decent programming book on the > topic? I have looked Amazon and Apress and not found much, so I am not > sure where to turn

Re: [GENERAL] Question about RUM-index

På onsdag 15. juni 2016 kl. 15:27:32, skrev David G. Johnston < david.g.johns...@gmail.com >: On Wed, Jun 15, 2016 at 6:56 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: Hi.   First; Is this the correct forum to ask questions about the Postgres Pro's

Re: [GENERAL] Looking for a good programming reference

On 6/15/2016 9:13 AM, Melvin Davidson wrote: *Your request is a bit generic. I'm not sure what you mean by "a decent programming book", as that can encompass several programming languages. * *That being said, if you are specifically wanting to learn more about PostgreSQL, I would suggest you

Re: [GENERAL] pg_tune replacement

On Sun, Jun 12, 2016 at 9:39 PM, Ivan Mincik wrote: > Hi all, > I am looking for some pg_tune replacement, which is working for latest > PostgreSQL versions. What I need is to have some tool, which can compute > some basic, reasonable configuration defaults for basic deployment > scenarios like pg

Re: [GENERAL] Converting Postgres SQL constraint logic to PHP?

On Fri, Jun 10, 2016 at 2:23 PM, Ken Tanzer wrote: > On Fri, Jun 10, 2016 at 1:47 PM, Steve Atkins wrote: > >> > You could look at one of the existing SQL parsers implemented in PHP, and >> use those to parse the constraint to a tree from which you could easily >> pull PHP. >> > >> This one sou

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

I only understand a quarter of what you guys are writing, but to me the JDBC driver throwing SQLException "A result was returned when none was expected" when my stored function is declared as "void" with CREATE OR REPLACE FUNCTION words_skip_game( IN in_uid integer, IN in_gid integ

Re: Fwd: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On 06/15/2016 08:27 AM, Durgamahesh Manne wrote: -- Forwarded message -- From: *David G. Johnston* mailto:david.g.johns...@gmail.com>> Date: Wed, Jun 15, 2016 at 8:40 PM Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh To: Durgamahe

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wed, Jun 15, 2016 at 3:07 PM, Alexander Farber < alexander.far...@gmail.com> wrote: > I only understand a quarter of what you guys are writing, > but to me the JDBC driver throwing SQLException > "A result was returned when none was expected" > when my stored function is declared as "void" with

Re: [GENERAL] Index seems "lost" after consecutive deletes

Em 14/06/2016 12:02, Edson Richter escreveu: Em 14/06/2016 10:32, David G. Johnston escreveu: On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter wrote: Em 14/06/2016 01:33, David G. Johnston escreveu: On Monday, June 13, 2016, Edson Richter mailto:edsonrich...@hotmail.com>> wrote:

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On 06/15/2016 12:07 PM, Alexander Farber wrote: I only understand a quarter of what you guys are writing, but to me the JDBC driver throwing SQLException "A result was returned when none was expected" when my stored function is declared as "void" with Because as I see it you used executeUpdate(

Re: [GENERAL] Data ingestion failing when using higher Batch size

On 06/14/2016 10:20 PM, Rupesh Choudhary wrote: Hi Adrian, Please find anwer in line : What is the SQL you are running? -We have a table with about 167 columns and we are trying to run batch updates on the table . I am attaching the part of code for your reference . How is that being run in the

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 9:07:10 PM EDT Alexander Farber wrote: > I only understand a quarter of what you guys are writing, > but to me the JDBC driver throwing SQLException > "A result was returned when none was expected" > when my stored function is declared as "void" with > > CREATE OR REPLA

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > may i know recommended approach to migrate the tables from sql server to > postgresql instead of using 3rd party tools > > ​Answering this specifically. There are none. The community PostgreSQL project mai

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne < maheshpostgr...@gmail.com> wrote: > > i earlier mentioned the host name of the server (archive.tf.com) > > ​No, you did not. And if you believe you did that may indeed be part of the problem. The log you showed has this: conn =jdbc:postgresq

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On 06/15/2016 01:30 PM, David G. Johnston wrote: On Wed, Jun 15, 2016 at 11:27 AM, Durgamahesh Manne mailto:maheshpostgr...@gmail.com>>wrote: may i know recommended approach to migrate the tables from sql server to postgresql instead of using 3rd party tools ​Answering this specifical

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

On 6/15/2016 1:30 PM, David G. Johnston wrote: One possible option to use the PostgreSQL's FDW capabilities with a suitable third-party extension that does talk to SQL Server. The other is to dump plain SQL, hopefully standard-conforming, INSERT statements from the SQL Server and load them int

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Wednesday, June 15, 2016 1:31 PM To: Durgamahesh Manne Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres w

Re: [GENERAL] Question about RUM-index

On Wed, Jun 15, 2016 at 3:56 AM, Andreas Joseph Krogh wrote: > Hi. > > First; Is this the correct forum to ask questions about the Postgres Pro's > new RUM-index? > > If not, please point me to the right forum. > I think that https://github.com/postgrespro/rum/issues might be the best forum. >

Re: [GENERAL] PgQ and pg_dump

On Wed, Jun 15, 2016 at 7:19 PM, Martín Marqués wrote: > Hi Michael, > > 2016-06-15 5:00 GMT-03:00 Michael Paquier : >> Martin wrote: >>> I wonder if this is the desirable way of handling pgq, or if those >>> tables should be dumped. I'm starting to think that this is a PgQ bug, >>> or maybe it's

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

Dear David sir/All, Thanks for your help. Just wanted to confirm few things. (9.3.5,9.2.9,9.1.14,9.0.18,8.4.22) Fix REASSIGN OWNED to not fail for text search objects (Álvaro Herrera) As per my understanding from what you told the fix was done in 9.3.5 and then back patched to all the remainin

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

sir as per above discussion .the URL which i mentioned in toolkit properties was 100% correct .i have checked db connectivity from another cluster with psql .connection esatblished to below mentioned database conn =jdbc:postgresql://archive.trustfort.com:5432/edb thank you for the valuable info

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

Please don't top post. On Thursday, June 16, 2016 3:42:53 AM EDT Yogesh Sharma wrote: > Dear David sir/All, > > Thanks for your help. > Just wanted to confirm few things. > > (9.3.5,9.2.9,9.1.14,9.0.18,8.4.22) Fix REASSIGN OWNED to not fail for text > search objects (Álvaro Herrera) > As per m

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

On Wednesday, June 15, 2016, Yogesh Sharma < yogesh1.sha...@nectechnologies.in> wrote: > Dear David sir/All, > > > > Thanks for your help. > > Just wanted to confirm few things. > > > > (9.3.5,9.2.9,9.1.14,9.0.18,8.4.22) Fix REASSIGN OWNED to not fail for > text search objects (Álvaro Herrera) > >

[GENERAL] Re: Moving from PHP to Java: A result was returned when none was expected.

Alexander Farber schrieb am 15.06.2016 um 15:56: > Good afternoon, > > at PostgreSQL 9.5.3 I have a stored function (full source code below) > returning void, which I successfully call with PHP: > > function skipGame($dbh, $uid, $gid) { > $sth = $dbh->prepare('SELECT words_skip_game(?, ?