Re: [GENERAL] Migrating money column from MS SQL Server to Postgres

2017-11-09 Thread Allan Kamau
On Thu, Nov 9, 2017 at 9:58 AM, Igal @ Lucee.org wrote: > On 11/8/2017 6:25 PM, Igal @ Lucee.org wrote: > >> On 11/8/2017 5:27 PM, Allan Kamau wrote: >> >>> Maybe using NUMERIC without explicitly stating the precision is >>> recommended. This would allow for values with many

Re: [GENERAL] Oracle to PostgreSQL

2017-11-09 Thread Brahmam Eswar
Here is the snippet of it. *Oracle :* *Declaration part in Store Procedure* CREATE OR REPLACE PROCEDURE "A"."Datastore" ( , In_Param1 IN VARCHAR2 , In_Param2 IN VARCHAR2 , In_Param3 IN VARCHAR2 , Out_Param1 OUT VARCHAR2 , ERROR_MSG OUT VARCHAR2 ) AS TEMP_ERR_MSG VARCHAR2(4000);

Re: [GENERAL] Combine multiple text search configuration

2017-11-09 Thread Aleksandr Parfenov
On Thu, 9 Nov 2017 09:11:07 +0100 Johannes Graën wrote: > On 2017-11-07 08:27, hmidi slim wrote: > > Hi,  > > Thank for your proposition but when to use this query :  > > (to_tsvector('english', document) || to_tsvector('french', > > document)) @@ (to_tsquery('english',

[GENERAL] Postgresql and github

2017-11-09 Thread Poul Kristensen
Hi! How come that Postgresql is not present in a github with latest release? It would be very convenient to deploy PG using Ansible. Oracle(latest release) is available through github. TIA Poul

Re: [GENERAL] Oracle to PostgreSQL

2017-11-09 Thread Laurenz Albe
On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote: > Here is the snippet of it. >TYPE INV_LINES_RT IS RECORD( > VENDOR_NUM A.Datastore.VENDOR_NUM%TYPE, > VENDOR_SITE_CODE A.Datastore.VENDOR_SITE_CODE%TYPE, > INVOICE_NUM A.Datastore.INVOICE_NUM%TYPE, >

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Michael Paquier
On Thu, Nov 9, 2017 at 8:27 PM, Poul Kristensen wrote: > How come that Postgresql is not present in a github with latest release? > > It would be very convenient to deploy PG using Ansible. > > Oracle(latest release) is available through github. You are looking for that, which

Fwd: Re: [GENERAL] Combine multiple text search configuration

2017-11-09 Thread Johannes Graën
On 2017-11-07 08:27, hmidi slim wrote: > Hi,  > Thank for your proposition but when to use this query :  > (to_tsvector('english', document) || to_tsvector('french', document)) @@ > (to_tsquery('english', query) || to_tsquery('french', query)) > I think that the performance decrease and not a good

Re: [GENERAL] Oracle to PostgreSQL

2017-11-09 Thread Laurenz Albe
Brahmam Eswar wrote: > How to migrate the Oracle collection types ( IsTableOF, IsRecord) to postgres. Are you talking about table definitions or PL/SQL code? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Oracle to PostgreSQL

2017-11-09 Thread Felix Kunde
On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote: > You can create a composite type in PostgreSQL: > CREATE TYPE complex AS (r integer, i integer); > You would use an array in this case: > DECLARE > carr complex[]; I've once faced the same thing, and did as Laurenz suggested. You will like

[GENERAL] Oracle to PostgreSQL

2017-11-09 Thread Brahmam Eswar
Hi , How to migrate the Oracle collection types ( IsTableOF, IsRecord) to postgres. -- Thanks & Regards, Brahmeswara Rao J.

Re: [GENERAL] Migrating money column from MS SQL Server to Postgres

2017-11-09 Thread Adam Brusselback
> Since you are migrating data into a staging table in PostgreSQL, you may set > the field data type as TEXT for each field where you have noticed or > anticipate issues. > Then after population perform the datatype transformation query on the given > fields to determine the actual field value

Re: [GENERAL] Migrating money column from MS SQL Server to Postgres

2017-11-09 Thread Merlin Moncure
On Thu, Nov 9, 2017 at 8:22 AM, Adam Brusselback wrote: >> Since you are migrating data into a staging table in PostgreSQL, you may set >> the field data type as TEXT for each field where you have noticed or >> anticipate issues. >> Then after population perform the

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Poul Kristensen
No it isn't. What I want to do is: ansible-playbook somepostgresql.yml and postgresql is then changed on some server the way things are done by e.g. github.com/oravirt/ansible-oracle Thanks Poul 2017-11-09 17:18 GMT+01:00 Igal @ Lucee.org : > On 11/9/2017 3:27 AM, Poul

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Nicklas Avén
On Thu, 2017-11-09 at 12:27 +0100, Poul Kristensen wrote: > Hi! > > How come that Postgresql is not present in a github with latest > release? > > It would be very convenient to deploy PG using Ansible. > > Oracle(latest release) is available through github. > > TIA > > Poul > How can you

[GENERAL] Migrating plattaform

2017-11-09 Thread Valdir Kageyama
Hello, I need migrated the postgres from Linux on IBM Power to Oracle Linux on SPARC. My doubt is possible copy the datafiles to new enviorement ? or I need using other means of copying the data. For exemples: pg_dump/pg_restore. regards Tikara

[GENERAL] Index not used when using expression

2017-11-09 Thread Dingyuan Wang
Hi, I have a table named "gps", with an indexed column "packettime", which has unix timestamps. The following query: select * from gps where packettime < extract(epoch from '2017-05-01 08:00+08'::timestamp with time zone) explains to: Seq Scan on gps (cost=0.00..43411860.64 rows=384325803

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Steve Atkins
> On Nov 9, 2017, at 9:37 AM, Poul Kristensen wrote: > > No it isn't. > > What I want to do is: > > ansible-playbook somepostgresql.yml > > and postgresql is then changed on some server > the way things are done by e.g. > github.com/oravirt/ansible-oracle You're

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Igal @ Lucee.org
On 11/9/2017 3:27 AM, Poul Kristensen wrote: How come that Postgresql is not present in a github with latest release? What do you mean?  Is this not what you're referring to:     https://github.com/postgres/postgres/releases ? Igal Sapir Lucee Core Developer Lucee.org

Re: [GENERAL] Index not used when using expression

2017-11-09 Thread Tom Lane
Dingyuan Wang writes: > I have a table named "gps", with an indexed column "packettime", which > has unix timestamps. > The following query: > select * from gps where packettime < extract(epoch from '2017-05-01 > 08:00+08'::timestamp with time zone) > explains to: > Seq Scan

Re: [GENERAL] Migrating plattaform

2017-11-09 Thread Jaime Soler
You should use pg_dump & pg_restore because datafiles of differents on architectures are incompatibles. El 9 nov. 2017 16:47, "Valdir Kageyama" escribió: > Hello, > > I need migrated the postgres from Linux on IBM Power to Oracle Linux on > SPARC. > > My doubt is possible

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Poul Kristensen
Dear friends, The reason I posted this: For the last 6 months I have noticed the enormous numbers of github's raising on the Internet. For the last 10 years I have worked with Oracle(yes expensive)and Postgresql(from version 8.4!) and I am familiar conserning the _big_ difference between the to

[GENERAL] OpeSSL - PostgreSQL

2017-11-09 Thread chiru r
Hi All, I am using PostgreSQL version *9.5.7* on Red hat enterprise Linux *7.2.* *OpenSSL version : * OpenSSL 1.0.1e-fips 11 Feb 2013. I have a requirement to enable the SSL in my environment with specific cipher suites,we want to restrict weak cipher suites from open SSL default list. We have

Re: [GENERAL] OpeSSL - PostgreSQL

2017-11-09 Thread John R Pierce
On 11/9/2017 1:59 PM, chiru r wrote: How to configure the PostgreSQL to allow specif cipher suites from different client applications? see https://www.postgresql.org/docs/9.5/static/ssl-tcp.html -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Jeremy Schneider
Hi Poul, and thanks for using PostgreSQL! I've also been a very heavy user of Oracle and now a heavy user of PostgreSQL. I remember the days before Oracle acquired the RMAN software and bundled it with their database. Not so long ago, doing backups on Oracle wasn't so different from PostgreSQL;

Re: [GENERAL] Migrating money column from MS SQL Server to Postgres

2017-11-09 Thread Igal @ Lucee.org
On 11/9/2017 8:19 AM, Merlin Moncure wrote: On Thu, Nov 9, 2017 at 8:22 AM, Adam Brusselback wrote: Since you are migrating data into a staging table in PostgreSQL, you may set the field data type as TEXT for each field where you have noticed or anticipate issues.

Re: [GENERAL] OpeSSL - PostgreSQL

2017-11-09 Thread Tom Lane
John R Pierce writes: > On 11/9/2017 1:59 PM, chiru r wrote: >> How to configure the PostgreSQL to allow specif cipher suites from >> different client applications? > see https://www.postgresql.org/docs/9.5/static/ssl-tcp.html Note that while you can adjust ssl_ciphers,

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

2017-11-09 Thread Joe Conway
On 11/09/2017 01:59 PM, chiru r wrote: > I am using PostgreSQL version *9.5.7* on Red hat enterprise Linux *7.2.* > > *OpenSSL version : * OpenSSL 1.0.1e-fips 11 Feb 2013. > > I have a requirement to enable the SSL in my environment with specific > cipher suites,we want to restrict weak cipher

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

2017-11-09 Thread Joe Conway
On 11/09/2017 05:52 PM, chiru r wrote: > If OpenSSL apply any patches at OS level, Is there any > changes/maintenance we need to perform at PostgreSQL end? > > On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote: >> Assuming you mean that you need only FIPS 140-2 compliant ciphers, you >> would want

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

2017-11-09 Thread chiru r
Thanks. If OpenSSL apply any patches at OS level, Is there any changes/maintenance we need to perform at PostgreSQL end? On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote: > On 11/09/2017 01:59 PM, chiru r wrote: > > I am using PostgreSQL version *9.5.7* on Red hat