[no subject]

Re: oracle_fdw Question

chiru r wrote: > I am trying to install and configure the oracle_fdw on PostgreSQL DB servers. > What we are trying is, inorder to install (make, make install) oracle_fdw on > all DB servers,we want to compile on one server and want build a package/tar > file to copy the library files and require

Re: Trying to the behavior of a parallel query with with a change in the transaction isolation mode

Thanks for the answer it worked, the third analyze in the sequence below show multiple workers planned and none launched. PREPARE st AS SELECT avg(a) FROM parallel_big; EXPLAIN ANALYZE EXECUTE st; BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED, READ ONLY; EXPLAIN ANALYZE EXECUTE st; COMM

RE: Barman 2.3 errors

Hi 1/ thanks for your answer 2/ it’ right … the barman support list is better … sorry 3/ i’ve verified the pg replication slot : postgres@postgres# SELECT slot_name, active, restart_lsn FROM pg_replication_slots WHERE slot_type = 'physical' AND slot_name = 'barman'; slot_name | active | restart_

Prepared statements (PREPARE and JDBC) are a lot slower than "normal" ones.

We are seeing a quite heavy slow down when using prepared statements in 10.1. I haven't done some thorough testing, to be honest, but what we are having is a select from a view (complexity of it should not matter in my opinion), something like this: prepare TEST (text, int) select * from OUR_

Re: Prepared statements (PREPARE and JDBC) are a lot slower than "normal" ones.

Robert Zenz wrote: > We are seeing a quite heavy slow down when using prepared statements in 10.1. > > I haven't done some thorough testing, to be honest, but what we are having is > a > select from a view (complexity of it should not matter in my opinion), > something > like this: > > prep

Re: session_replication_role meaning?

On Wed, Jan 31, 2018 at 5:19 AM, Peter Eisentraut wrote: > The documentation was recently updated in the master branch, so maybe > you will find this explanation a bit more detailed: > https://www.postgresql.org/docs/devel/static/runtime-config-client.html#GUC-SESSION-REPLICATION-ROLE > Looks a l

Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Hi, Require assistance on the below: Code snippet: Map ic; //Populate values for ic long count = ((BigDecimal)ic.get(“EB”)).longValue(); Getting the below error: java.math.BigInteger cannot be cast to java.math.BigDecimal ®java.lang.ClassCastException: java.math.BigInteger cannot be cas

Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Hi, On Tue, 2018-02-13 at 14:28 +0530, Vinodh NV wrote: > Hi, > > Require assistance on the below: > > Code snippet: > Map ic; > //Populate values for ic > long count = ((BigDecimal)ic.get(“EB”)).longValue(); > > > Getting the below error: > java.math.BigInteger cannot be cast to java.math

Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Vinodh: On Tue, Feb 13, 2018 at 9:58 AM, Vinodh NV wrote: > Require assistance on the below: > Code snippet: > Map ic; > //Populate values for ic > long count = ((BigDecimal)ic.get(“EB”)).longValue(); > > > Getting the below error: > java.math.BigInteger cannot be cast to java.math.BigDecimal

Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

On Tue, Feb 13, 2018 at 12:39 PM, rob stone wrote: >> long count = ((BigDecimal)ic.get(“EB”)).longValue(); .. > The method is documented as:- > public static BigDecimal valueOf(long val) His problem seems to be the opposit, he does not have the long value and wants it. Francisco Olarte.

Multiple postmasters running from same directory

Hi, We are running Postgresql 9.4 with streaming replication and repmgr. Operating system is RHEL6.8 On the master I can see multiple postmaster processes from the same data directory. ps -ef |grep -i postgres|grep postm postgres 81440 1 0 Jan31 ?00:11:37 /usr/pgsql-9.4/bin/postma

Re: Multiple postmasters running from same directory

Vikas Sharma wrote: > We are running Postgresql 9.4 with streaming replication and repmgr. > Operating system is RHEL6.8 > > On the master I can see multiple postmaster processes from the same data > directory. > > ps -ef |grep -i postgres|grep postm > postgres 81440 1 0 Jan31 ?

Re: Multiple postmasters running from same directory

Laurenz Albe writes: > Vikas Sharma wrote: >> On the master I can see multiple postmaster processes from the same data >> directory. >> ps -ef |grep -i postgres|grep postm >> postgres 81440 1 0 Jan31 ?00:11:37 >> /usr/pgsql-9.4/bin/postmaster -D /var/lib/pgsql/9.4/data >> postgre

Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Thanks for the update Francisco. I had one more query: In Oracle the syntax for calling a stored procedure is Session sess = (Session) entityManager.getDelegate(); sess.createSQLQuery("{ call reset() }").executeUpdate(); Can you please let me know if the below equivalent for postgres is correct

Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal

Vinodh: You are BOTTOM QUOTING a message which has nothing to thank me from, I was just trying to clarify a misunderstanding of your original question. On Tue, Feb 13, 2018 at 4:14 PM, Vinodh NV wrote: > Thanks for the update Francisco. I had one more query: > In Oracle the syntax for calling a

Re: Multiple postmasters running from same directory

On Tue, Feb 13, 2018 at 4:50 PM, Tom Lane wrote: > Laurenz Albe writes: >> Vikas Sharma wrote: >>> On the master I can see multiple postmaster processes from the same data >>> directory. >>> ps -ef |grep -i postgres|grep postm >>> postgres 81440 1 0 Jan31 ?00:11:37 >>> /usr/pgsql

Re: Multiple postmasters running from same directory

Francisco Olarte writes: > On Tue, Feb 13, 2018 at 4:50 PM, Tom Lane wrote: >> Putting two and two together, you have some monitoring program that is >> hitting the postmaster with a constant stream of TCP connection requests >> none of which get completed, resulting in a whole lot of useless for

cursors and function question

Hi Is there any elegant way not a two steps way I can output the cursor value at each step? testtbl table has this content col1|col2| col3 ++-- E1 | CAT1 |0 E1 | CAT2 |0 E1 | CAT3 |0 E4

Re: cursors and function question

On Tuesday, February 13, 2018, armand pirvu wrote: > > CREATE OR REPLACE FUNCTION foofunc() >RETURNS text AS $$ > > select foofunc(); > foofunc > --- > ("E1","CAT1 ",0) > > But I am looking to get > > foofunc >

Re: Multiple postmasters running from same directory

Thanks Tom, So is it normal for postgres to fork out new postmaster processes from the same data directory? I haven't seen this earlier. I will check from where those connection requests are coming in, Best Regards Vikas On Feb 13, 2018 15:50, "Tom Lane" wrote: > Laurenz Albe writes: > > Vik

Re: cursors and function question

On 02/13/2018 10:22 AM, armand pirvu wrote: Hi Is there any elegant way not a two steps way I can output the cursor value at each step? testtbl table has this content col1|col2| col3 ++-- E1 | CAT1 |0 E1 | CAT2

Re: Multiple postmasters running from same directory

Vikas Sharma writes: > So is it normal for postgres to fork out new postmaster processes from the > same data directory? I haven't seen this earlier. They're not postmasters, they're child processes, as you can easily tell from the PID/PPID columns of your ps output. But a process inherits its t

Re: cursors and function question

> On Feb 13, 2018, at 12:26 PM, David G. Johnston > wrote: > > On Tuesday, February 13, 2018, armand pirvu > wrote: > > CREATE OR REPLACE FUNCTION foofunc() >RETURNS text AS $$ > > select foofunc(); > foofunc > --- >

Re: cursors and function question

On Tue, Feb 13, 2018 at 12:03 PM, armand pirvu wrote: > > ERROR: RETURN cannot have a parameter in function returning set > LINE 10: return var2; > HINT: Use RETURN NEXT or RETURN QUERY. > > > and it just sits there > > Any hints ? > > https://www.postgresql.org/docs/10/static/plpgsql

Re: pglogical in postgres 9.6

On 02/12/2018 06:09 PM, greigwise wrote: hireology_tmp=# \dx List of installed extensions Name | Version | Schema | Description --+-+--+

Re: cursors and function question

> On Feb 13, 2018, at 12:54 PM, Adrian Klaver wrote: > > On 02/13/2018 10:22 AM, armand pirvu wrote: >> Hi >> Is there any elegant way not a two steps way I can output the cursor value >> at each step? >> testtbl table has this content >> col1|col2| col3 >> +

Re: cursors and function question

On 02/13/2018 11:17 AM, armand pirvu wrote: On Feb 13, 2018, at 12:54 PM, Adrian Klaver > wrote: On 02/13/2018 10:22 AM, armand pirvu wrote: Hi Is there any elegant way not a two steps way I can output the cursor value at each step? testtbl table has this c

Re: pglogical in postgres 9.6

No need! I figured it out. Had to put this "synchronize_data := false" on the create_subscription call. Weird that there seem to be redundant parameters for this; one on the replication set add and one on the create subscription. Maybe I'm not quite understanding the usage on those or something

Windows 10 Pro issue

Server:  Windows 10 Pro system Postgresql:  8.4.5 installed several months ago and working correctly, until recently On Feb 9, 2018 about 7 PM pg_log file recorded: 2018-02-09 15:04:23 CST LOG:  unexpected EOF on client connection 2018-02-09 19:12:41 CST LOG:  received fast shutdown request 20

Re: Windows 10 Pro issue

On 02/13/2018 12:07 PM, Dale Seaburg wrote: Server:  Windows 10 Pro system Postgresql:  8.4.5 installed several months ago and working correctly, until recently On Feb 9, 2018 about 7 PM pg_log file recorded: 2018-02-09 15:04:23 CST LOG:  unexpected EOF on client connection 2018-02-09 19:12:4

Re: Connection loosing at some places - caused by firewall

On Tue, 14 Nov 2017 12:09:31 +0100, Durumdara wrote: >*I disabled my firewall at home - the [keepalive] problem vanished!!!* What firewall are you using? Windows own firewall doesn't interfere with keepalive packets. Most commercial SOHO firewalls won't either. George

Re: Windows 10 Pro issue

On 02/13/2018 12:07 PM, Dale Seaburg wrote: Server:  Windows 10 Pro system Postgresql:  8.4.5 installed several months ago and working correctly, until recently Should have mentioned earlier, version 8.4 went EOL about three and half years ago: https://www.postgresql.org/support/versioning/

How do I get rid of database test-aria

development platform: HP Compaq 6710b postgresql 9.6 Operating System: Ubuntu 17.10 It probably doesn't matter since there is nothing in the database. I don't remember how I created the database. It appears that postgresql does not like a dash in the database name. I have not tried to create a ta

Re: How do I get rid of database test-aria

Hi > On 13.02.2018, at 21:38, Sherman Willden wrote: > > development platform: HP Compaq 6710b > postgresql 9.6 > Operating System: Ubuntu 17.10 > > It probably doesn't matter since there is nothing in the database. I don't > remember how I created the database. It appears that postgresql doe

Re: How do I get rid of database test-aria

On 02/13/2018 12:38 PM, Sherman Willden wrote: development platform: HP Compaq 6710b postgresql 9.6 Operating System: Ubuntu 17.10 It probably doesn't matter since there is nothing in the database. I don't remember  how I created the database. It appears that postgresql does not like a dash in

Re: cursors and function question

> On Feb 13, 2018, at 1:22 PM, Adrian Klaver wrote: > > On 02/13/2018 11:17 AM, armand pirvu wrote: >>> On Feb 13, 2018, at 12:54 PM, Adrian Klaver >> >> >> wrote: >>> >>> On 02/13/2018 10:22

Re: Windows 10 Pro issue

I've seen this before with Win10. 1.- Go to Windows ControlPanel-UserAccounts-ManageAnotherAccount, select postgres and re-enter the Postgres User password, save and close. 2.- Start Windows Services (if running as a service) right click on Postgres Service-Properties-LogOn then enter the same pas

Re: oracle_fdw Question

Thank you. On Tue, Feb 13, 2018 at 3:31 AM, Laurenz Albe wrote: > chiru r wrote: > > I am trying to install and configure the oracle_fdw on PostgreSQL DB > servers. > > What we are trying is, inorder to install (make, make install) > oracle_fdw on all DB servers,we want to compile on one server

PostgreSQL Download

Hello, The official postgresql download site ( https://www.postgresql.org/download/linux/redhat/) has a link to download the tar archives (https://www.enterprisedb.com/download-postgresql-binaries) or interactive installer from EnterpriseDB. Is the above download from EnterpriseDB is open source

Re: cursors and function question

On 02/13/2018 01:25 PM, armand pirvu wrote: On Feb 13, 2018, at 1:22 PM, Adrian Klaver > wrote: Not a trigger , but the idea is we will do some batch processing from said table let’s name it testtbl 1 - we get the records using  select for update with a

Re: cursors and function question

On Tue, Feb 13, 2018 at 3:31 PM, Adrian Klaver wrote: > 2) By global table do you mean a temporary table? If so not sure that is > going to work as I am pretty sure it will disappear after the function is > run. ​Temporary tables can survive until either session or transaction end - neither of

Re: PostgreSQL Download

On 02/13/2018 02:27 PM, Thiagarajan Lakshminarayanan wrote: Hello, The official postgresql download site (https://www.postgresql.org/download/linux/redhat/) has a link to download the tar archives (https://www.enterprisedb.com/download-postgresql-binaries) or interactive installer from Enter

Re: I do not get the point of the information_schema

On 2018-02-12 23:01:41 +0100, Thiemo Kellner wrote: > I try to implement SCD2 on trigger level and try to generated needed code on > the fly. Therefore I need to read data about the objects in the database. So > far so good. I know of the information_schema and the pg_catalog. The > documentation f

Re: I do not get the point of the information_schema

On Tue, Feb 13, 2018 at 3:57 PM, Peter J. Holzer wrote: > (That said, it looks like both PostgreSQL and MariaDB include additional > columns beyond those mandated by the standard - you can't rely on those, > of course. And some databases like Oracle don't even have an information > schema.) > ​G

Re: How do I get rid of database test-aria

Yes the double quotes worked. I tried single quotes but since that didn't work I just assumed that double quotes would not work either. Thanks all; Sherman On Tue, Feb 13, 2018 at 1:41 PM, Adrian Klaver wrote: > On 02/13/2018 12:38 PM, Sherman Willden wrote: > >> development platform: HP Compa

Re: How do I get rid of database test-aria

On 02/13/2018 03:08 PM, Sherman Willden wrote: Yes the double quotes worked. I tried single quotes but since that didn't work I just assumed that double quotes would not work either. The below explains why: https://www.postgresql.org/docs/10/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIER

Re: I do not get the point of the information_schema

On 2018-02-13 16:06:43 -0700, David G. Johnston wrote: > On Tue, Feb 13, 2018 at 3:57 PM, Peter J. Holzer wrote: > > (That said, it looks like both PostgreSQL and MariaDB include additional > columns beyond those mandated by the standard - you can't rely on those, > of course. And som

Re: I do not get the point of the information_schema

On Tue, Feb 13, 2018 at 4:17 PM, Peter J. Holzer wrote: > > It is possible that all the columns that PostgreSQL has are required by > the standard and that MariaDB is non-conforming by omitting them, but at > least some of the names look quite PostgreSQL-specific to me. So my > guess is that the

Re: I do not get the point of the information_schema

"David G. Johnston" writes: > Unless our docs are completely misleading I'd say that PostgreSQL is being > conforming while MariaDB is treating information_schema as their version of > pg_catalog (or at least our system views over top of pg_catalog). Our project policy is that information_schema

Table Partitioning: Sequence jump issue 10 in 10 with serial datatype

Hi folks!! I have a problem with a serial data type and partitioned table, I used rules to insert in child tables. But the problem is that the some does'nt insert and the sequence value jump sometimes 3 in 3 or 10 in 10. The example is the next: I don't understand why sequence jumps in this

Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype

On Tuesday, February 13, 2018, DrakoRod wrote: > Hi folks!! > I have a problem with a serial data type and partitioned table, I used > rules > to insert in child tables. But the problem is that the some does'nt insert > and the sequence value jump sometimes 3 in 3 or 10 in 10. Do not know what

Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype

Sorry, your right! The example is: CREATE TABLE customers ( id serial PRIMARY KEY, name TEXT, other_data TEXT ); CREATE TABLE customers_part1( CHECK (id<1) )INHERITS (customers); CREATE TABLE customers_part2( CHECK (id>=1 AND id<2) )INHERITS (customers); CREATE OR R

unsubsribe

unsubsribe

Re: cursors and function question

> On Feb 13, 2018, at 4:37 PM, David G. Johnston > wrote: > > On Tue, Feb 13, 2018 at 3:31 PM, Adrian Klaver > wrote: > 2) By global table do you mean a temporary table? If so not sure that is > going to work as I am pretty sure it will disappear after the fu

Re: pglogical in postgres 9.6

On Tue, Feb 13, 2018 at 1:46 PM greigwise wrote: > No need! I figured it out. > > Had to put this "synchronize_data := false" on the create_subscription > call. > Weird that there seem to be redundant parameters for this; one on the > replication set add and one on the create subscription. Mayb