Re: [GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

"drum.lu...@gmail.com" writes: > So, the new plan is: > > 1 - Select 50.000 rows and gives it a batch number. > 2 - Select *MORE* 50,000 rows and gives it a *NEW* batch number. > 3 - Select *MORE* 50,000 rows and gives it a *NEW* batch number. Why so complicated? Here's a

Re: [GENERAL] Error installing 9.5 on Win 2012 R2: data dir not created

Found the issue: The install that worked is on our in-house development server and I installed with a weak alpah-numeric password. The problem install is on a hosted, soon-to-be production server where I am using a strong, ramdomly generated password that includes special characters. One of the

Re: [GENERAL] “Loop” in plpgsql Function - PostgreSQL 9.2

hello, On Tue, 2016-01-19 at 10:37 +1300, drum.lu...@gmail.com wrote: > I've created a function that allows me to do an huge update. > > But I need to limit this function. I need to do 50k rows (example) and > then stop it. After that I need to continue from the rows that I've > stopped...

Re: [GENERAL] Dynamic collation support

On Tue, Jan 19, 2016 at 1:15 PM, Pavel Stehule wrote: > > > 2016-01-19 20:04 GMT+01:00 Merlin Moncure : >> >> On Tue, Jan 19, 2016 at 11:11 AM, Tom Lane wrote: >> > Merlin Moncure writes: >> >> On Tue, Jan 19,

Re: [GENERAL] Question about the postgresql's certifications

On 01/19/2016 12:14 PM, John R Pierce wrote: On 1/15/2016 8:59 AM, Jaime Manuel Padron Cano wrote: Hello, i would like to know what is the difference between the postgresql CE 8 silver and postgresql associate certification which provides EnterpriseDB. Which one is the most recently and which

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

On 01/19/2016 12:21 PM, AI Rumman wrote: Hi All, My production boxes are running on Redhat 5 and I need to build Postgresql 9.4 rpm for it following our environment setup. If I build the rpm on Centos 5, will it be ok to run on Red Hat 5 boxes? Can you please let me know? Thanks. CentOS 5

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

On 01/19/2016 11:05 PM, Peter Devoy wrote: > As part of the extension I am writing I am trying to create a trigger > procedure in which the value of the primary key of the NEW or OLD row > is used. The trigger will be fired by arbitrary tables so the column > name must be dynamic. Something like:

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

We build our own rpms. Thanks. On Tue, Jan 19, 2016 at 12:34 PM, Adrian Klaver wrote: > On 01/19/2016 12:29 PM, AI Rumman wrote: > >> We have all our scripts running on older Postrgesql versions for years >> where it is using PGHOME and other paths. We need to make

[GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

As part of the extension I am writing I am trying to create a trigger procedure in which the value of the primary key of the NEW or OLD row is used. The trigger will be fired by arbitrary tables so the column name must be dynamic. Something like: pk_column := 'foo_id'; --example

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

We have all our scripts running on older Postrgesql versions for years where it is using PGHOME and other paths. We need to make the 9.4 rpm to follow those directory structure. Considering above, am I going on right track? Please let me know. Thanks. On Tue, Jan 19, 2016 at 12:25 PM, Joshua D.

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

On 01/19/2016 12:37 PM, AI Rumman wrote: We build our own rpms. Confusion on my part. When you say scripts below are you talking about scripts you use to start/stop/monitor/otherwise control Postgres or the scripts you use to build the RPMs? Thanks. On Tue, Jan 19, 2016 at 12:34 PM,

Re: [GENERAL] plv8 binaries for PostgreSQL 9.5 on Windows

> On 01/11/2016 05:50 PM, Igal @ Lucee.org wrote: > Where can I find binaries for plv8 for PostgreSQL 9.5 for Windows? I've posted PostgreSQL 9.5 Windows binaries for PLV8 http://www.postgresonline.com/journal/archives/360-PLV8-binaries-for-Postgre SQL-9.5-windows-both-32-bit-and-64-bit.html

Re: [GENERAL] plv8 binaries for PostgreSQL 9.5 on Windows

On 1/19/2016 2:56 PM, Regina Obe wrote: On 01/11/2016 05:50 PM, Igal @ Lucee.org wrote: Where can I find binaries for plv8 for PostgreSQL 9.5 for Windows? I've posted PostgreSQL 9.5 Windows binaries for PLV8 http://www.postgresonline.com/journal/archives/360-PLV8-binaries-for-Postgre

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

On Tue, Jan 19, 2016 at 5:05 PM, Peter Devoy wrote: > As part of the extension I am writing I am trying to create a trigger > procedure in which the value of the primary key of the NEW or OLD row > is used. The trigger will be fired by arbitrary tables so the column > name must

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

On 01/19/2016 11:14 PM, Vik Fearing wrote: > On 01/19/2016 11:05 PM, Peter Devoy wrote: >> As part of the extension I am writing I am trying to create a trigger >> procedure in which the value of the primary key of the NEW or OLD row >> is used. The trigger will be fired by arbitrary tables so the

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

On 1/19/2016 12:25 PM, Joshua D. Drake wrote: On 01/19/2016 12:21 PM, AI Rumman wrote: Hi All, My production boxes are running on Redhat 5 and I need to build Postgresql 9.4 rpm for it following our environment setup. If I build the rpm on Centos 5, will it be ok to run on Red Hat 5 boxes? Can

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

On Tue, Jan 19, 2016 at 5:05 PM, Peter Devoy wrote: > As part of the extension I am writing I am trying to create a trigger > procedure in which the value of the primary key of the NEW or OLD row > is used. The trigger will be fired by arbitrary tables so the column > name must

[GENERAL] Odd quoting behavior from \set

Is this odd quoting behavior expected? (Note difference between "'a':1" and "'b':'a'") ~@decina.local/53896# \set df pd.DataFrame.from_dict([{'a':1,'b':'a'},{'a':2,'b':'b'}]) ~@decina.local/53896# \echo :df pd.DataFrame.from_dict([{a:1,b:'a'},{a:2,b:'b'}]) ~@decina.local/53896# -- Jim

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

On 01/19/2016 01:05 PM, AI Rumman wrote: Ccing list Yes, these are the scripts to start/stop/manipulate data etc. Well it seems you have two choices: 1) Use someone else's packaging and change the above scripts 2) Use your previous custom RPM configuration to build the 9.4 RPMs and keep your

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

>Argh! I *always* type the wrong one. It should be %I instead of %L You're not alone, I did the same thing in my example with quote_literal. -_- Thank you all very much for your solutions -- I can end this 14hr day on a high note! Peter -- Sent via pgsql-general mailing list

[GENERAL] Building 9.4 rpm for Red Hat 5

Hi All, My production boxes are running on Redhat 5 and I need to build Postgresql 9.4 rpm for it following our environment setup. If I build the rpm on Centos 5, will it be ok to run on Red Hat 5 boxes? Can you please let me know? Thanks.

Re: [GENERAL] Odd quoting behavior from \set

On Tue, Jan 19, 2016 at 1:39 PM, Jim Nasby wrote: > Is this odd quoting behavior expected? (Note difference between "'a':1" > and "'b':'a'") > > ~@decina.local/53896# \set df >> pd.DataFrame.from_dict([{'a':1,'b':'a'},{'a':2,'b':'b'}]) >> ~@decina.local/53896# \echo :df

Re: [GENERAL] plpython3 package absent in 9.5 repository

Hi, On Wed, 2016-01-13 at 10:44 -0200, Clodoaldo Neto wrote: > Where to get the plpython3 packages for 9.5? Pushed them to repo now, for Fedora 22+. Thanks for the heads up! Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL

Re: [GENERAL] Building 9.4 rpm for Red Hat 5

On 01/19/2016 12:29 PM, AI Rumman wrote: We have all our scripts running on older Postrgesql versions for years where it is using PGHOME and other paths. We need to make the 9.4 rpm to follow those directory structure. Considering above, am I going on right track? Please let me know. How did

Re: [GENERAL] Dynamic collation support

On Tue, Jan 19, 2016 at 11:11 AM, Tom Lane wrote: > Merlin Moncure writes: >> On Tue, Jan 19, 2016 at 9:15 AM, Pavel Stehule >> wrote: >>> Different collates requires different plans - so using dynamic SQL is much >>> more

Re: [GENERAL] Question about the postgresql's certifications

On 1/15/2016 8:59 AM, Jaime Manuel Padron Cano wrote: Hello, i would like to know what is the difference between the postgresql CE 8 silver and postgresql associate certification which provides EnterpriseDB. Which one is the most recently and which of those is based in postgres 9.5? per

[GENERAL] Re: [BUGS] about test_parser installation failure problem(PostgreSQL in 9.5.0)？

閬閬イふ wrote: > hi postgreSql ! > test_parser install is ok (postgresql 9.2.4) > but at (postgresql 9.5.0) failure？ > why？the postgresql say: > CREATE EXTENSION zhparser What is zhparser anyway? There is one such thing at https://github.com/amutu/zhparser but I don't think it depends on

Re: [GENERAL] Dynamic collation support

2016-01-19 20:04 GMT+01:00 Merlin Moncure : > On Tue, Jan 19, 2016 at 11:11 AM, Tom Lane wrote: > > Merlin Moncure writes: > >> On Tue, Jan 19, 2016 at 9:15 AM, Pavel Stehule > wrote: > >>> Different collates

Re: [GENERAL] Recurring and non recurring events.

On Sat, Dec 26, 2015 at 03:15:50PM -0500, Tom Lane wrote: > Gavin Flower writes: > > The motivation of bottom posting like this: is that people get to see > > the context before the reply, AND emails don't end up getting longer & > > longer as people reply at the

Re: [GENERAL] CoC [Final]

On Mon, 18 Jan 2016 10:02:33 -0800 "Joshua D. Drake" wrote: > * Participants who disrupt the collaborative space, or participate in > a pattern of behaviour which could be considered harassment will not > be tolerated. This one might come back to bite you. I, along with

Re: [GENERAL] JSONB performance enhancement for 9.6

Bill Moran wrote: > As far as a current solution: my solution would be to decompose the > JSON into an optimized table. I.e.: > > CREATE TABLE store1 ( > id SERIAL PRIMARY KEY, > data JSONB > ); > > CREATE TABLE store2 ( > id INT NOT NULL REFERENCES store1(id), > top_level_key

[GENERAL] Dynamic collation support

For database functions, is there any way to manage collations besides dynamic sql? It doesn't look like there is but I thought I'd ask. For example, I want to do something like: DO $$ DECLARE c name DEFAULT 'en_GB'; BEGIN SELECT * FROM foo ORDER BY a COLLATE c; END; $$; and not DO $$

Re: [GENERAL] Dynamic collation support

2016-01-19 16:07 GMT+01:00 Merlin Moncure : > For database functions, is there any way to manage collations besides > dynamic sql? It doesn't look like there is but I thought I'd ask. > > For example, I want to do something like: > > DO > $$ > DECLARE > c name DEFAULT

Re: [GENERAL] WIP: CoC V5, etc., etc., etc., etc., ....

Joshua D. Drake wrote: On 01/13/2016 06:00 PM, Berend Tober wrote: Whether or not it is a foregone conclusion that this community will adopt a CoC, it seems like a mailing list is not the place to do revision control. Can you people start a github project or something to develope your ideas

[GENERAL] about test_parser installation failure problem(PostgreSQL in 9.5.0)？

hi postgreSql ! test_parser install is ok (postgresql 9.2.4) but at (postgresql 9.5.0) failure？ why？the postgresql say: CREATE EXTENSION zhparser say: ERROR: syntax error at or near "" LINE 1: CREATE EXTENSION zhparser ^ ** 错误 ** ERROR: syntax error at or

[GENERAL] Question about the postgresql's certifications

Hello, i would like to know what is the difference between the postgresql CE 8 silver and postgresql associate certification which provides EnterpriseDB. Which one is the most recently and which of those is based in postgres 9.5? regards

[GENERAL] Postgre compatible version with RHEL 7.2

Hello Team, Can you please confirm if PostgreSQL version 9.4.x is compatible with RHEL 7.2? and if not when the same will be available? Regards/// Deepti Sharma Sr. Configuration Engineer (ITIL 2011 Foundation Certified)

[GENERAL] Missing RHEL rpm(pg_catcheck-95) in postgres 9.5 repo.

Hello team, We are looking to upgrade our application from postgres 9.4 to 9.5, but we are unable to find the RPM named 'pg_catcheck-95' for RHEL (http://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/). Whereas it is available for Fedora, we request your help in getting this rpm for RHEL as

[GENERAL] How can i add a postgresql connection using inno setup?

Hi all I want to know how can i add a connection using inno setup program like below picture. In my program, I should add databases to localhost like below picture. How can I add

Re: [GENERAL] Missing RHEL rpm(pg_catcheck-95) in postgres 9.5 repo.

Adding another PDL dedicated to pg-catcheck. Thanks, Prateek From: Kaliappa, Karthic Sent: Monday, January 18, 2016 11:57 AM To: pgsql-pkg-...@postgresql.org; pgsql-general@postgresql.org Cc: Agarwal, Prateek ; Agarwal, Shalini Subject: Missing RHEL

Re: [GENERAL] about test_parser installation failure problem(PostgreSQL in 9.5.0)？

On 01/14/2016 06:51 PM, 閬閬イふ wrote: hi postgreSql ! test_parser install is ok (postgresql 9.2.4) but at (postgresql 9.5.0) failure？ why？the postgresql say: CREATE EXTENSION zhparser say: ERROR: syntax error at or near "" LINE 1: CREATE EXTENSION zhparser ^ ** 错误

Re: [GENERAL] Dynamic collation support

On Tue, Jan 19, 2016 at 9:15 AM, Pavel Stehule wrote: > 2016-01-19 16:07 GMT+01:00 Merlin Moncure : >> For database functions, is there any way to manage collations besides >> dynamic sql? It doesn't look like there is but I thought I'd ask. >> >> For

[GENERAL] Setting privileges for users

Hello, I'm a postgres newb and am trying to set up some privileges. My request goes like this. I have 2 schemas: - external_data - internal_data There are various apps reading and writing in those to schemas. I have two roles, admin and reader. The purpose of the admin role is to transfer

[GENERAL] BDR install broken on Ubuntu 14.04

Hi, I have the same issue. It was working fine a month ago. I wrote a cookbook with chef to install BDR a month ago since then I did not change the cookbook but now I got this error. This seem to be the heart of the issue: Removing obsolete dictionary files: ==> ldev4: * No PostgreSQL

Re: [GENERAL] WIP: CoC V5, etc., etc., etc., etc., ....

Bill Moran wrote: On Tue, 12 Jan 2016 22:10:43 -0500 Tom Lane wrote: Kevin Grittner writes: I'm not the greatest word-smith, but I'll attempt to rework Josh's draft to something that seems more "natural" to me. Minor (or not?) comment: Whether or

Re: [GENERAL] Dynamic collation support

On Tue, Jan 19, 2016 at 9:42 AM, Merlin Moncure wrote: > On Tue, Jan 19, 2016 at 9:15 AM, Pavel Stehule > wrote: > >> Different collates requires different plans - so using dynamic SQL is much >> more correct. >> >> It is same like using variables as

[GENERAL] Re: [pgsql-pkg-yum] Missing RHEL rpm(pg_catcheck-95) in postgres 9.5 repo.

Thanks! --Prateek -Original Message- From: Devrim GÜNDÜZ [mailto:dev...@gunduz.org] Sent: Monday, January 18, 2016 4:03 PM To: Kaliappa, Karthic ; pgsql-pkg-...@postgresql.org; pgsql-general@postgresql.org Cc: Agarwal, Prateek ; Agarwal,

Re: [GENERAL] Postgre compatible version with RHEL 7.2

On 01/17/2016 05:06 AM, Deepti Sharma S wrote: Hello Team, Can you please confirm if PostgreSQL version 9.4.x is compatible with RHEL 7.2? and if not when the same will be available? See below for full Postgres to RH/Centos/Fedora/SL/etc mapping: http://yum.postgresql.org/repopackages.php

Re: [GENERAL] JSONB performance enhancement for 9.6

On Mon, Jan 11, 2016 at 09:01:03PM -0500, Tom Smith wrote: > Hi, > > Congrats on the official release of 9.5 > > And I'd like bring up the issue again about if 9.6 would address the jsonb > performance issue > with large number of top level keys. > It is true that it does not have to use JSON

Re: [GENERAL] Dynamic collation support

Merlin Moncure writes: > On Tue, Jan 19, 2016 at 9:15 AM, Pavel Stehule > wrote: >> Different collates requires different plans - so using dynamic SQL is much >> more correct. >> It is same like using variables as columns or tablenames. > Right -- I

Re: [GENERAL] How can i add a postgresql connection using inno setup?

Just do it. What's the Problem? Errors? On 18 January 2016 08:31:33 CET, yang wrote: >Hi all > >I want to know how can i add a connection using inno setup program like >below picture. > > > > >In my program, I should add

Re: [GENERAL] plv8 binaries for PostgreSQL 9.5 on Windows

On 1/13/2016 8:25 AM, Igal @ Lucee.org wrote: On 1/12/2016 12:57 PM, Adrian Klaver wrote: On 01/11/2016 05:50 PM, Igal @ Lucee.org wrote: Where can I find binaries for plv8 for PostgreSQL 9.5 for Windows? The only Windows binaries I could find where for 9.4, here: