Re: [GENERAL] Redo the filenode link in tablespace

On 05/31/2017 06:05 AM, tel medola wrote: Hi. I have a rather serious problem in my database. I'll try to summarize what happened and how far I've gotten with the help of friends from the pgsql-sql list. When I returned the copy of the drives, the records were no longer found. For

Re: [GENERAL] jsonb case insensitive search

> On May 31, 2017, at 2:32 PM, David G. Johnston > wrote: > > On Wed, May 31, 2017 at 12:18 PM, armand pirvu > wrote: > > For the example mentioned > > SELECT * > FROM cfg_files_data > WHERE

Re: [GENERAL] jsonb case insensitive search

On Wed, May 31, 2017 at 12:18 PM, armand pirvu wrote: > > For the example mentioned > > SELECT * > FROM cfg_files_data > WHERE cfg_files_data.show_id = 32 > AND cfg_files_data.file_id = 123 > AND lower((file_data_record ->> 'Company')) = lower('CompuTestSystems'); > ; > >

[GENERAL] jsonb case insensitive search

Hi The goal would be to be able to search case insensitive by any key:value combined with some other columns like outlined below, but initially would be Company:CompuTestSystems A sample would be SELECT * FROM cfg_files_data WHERE cfg_files_data.show_id = 32 AND cfg_files_data.file_id =

Re: [GENERAL] Ora2Pg-Database migration report

On 31/05/2017 16:36, PAWAN SHARMA wrote: > Hi All, > > What is the formula to calculate estimated cost in Ora2Pg-Database > migration report? You can find some information on the official documentation: http://ora2pg.darold.net/documentation.html#migration_assessment_method If you want more

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

Osahon Oduware writes: > Thanks for the response. Yes, I did all of that. Well, better start double-checking, because it certainly appears that the version of pg_config you're calling is not from a --with-libxml build. After thinking a bit, another possible way of messing

Re: [GENERAL] dump to pg

> On May 31, 2017, at 9:27 AM, David G. Johnston > wrote: > > On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris wrote: > Hi, > > I have dumps from oracle and microsoft sql server (no more details). Is it > possible to load them "directly" into

Re: [GENERAL] dump to pg

On Wed, May 31, 2017 at 7:43 AM, Nicolas Paris wrote: > Hi, > > I have dumps from oracle and microsoft sql server (no more details). Is it > possible to load them "directly" into postgres (without oracle/mssql > license)? > dump -> csv -> postgtres > or something ? > >

[GENERAL] dump to pg

Hi, I have dumps from oracle and microsoft sql server (no more details). Is it possible to load them "directly" into postgres (without oracle/mssql license)? dump -> csv -> postgtres or something ? Thanks a lot

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

Hi Tom, Thanks for the response. Yes, I did all of that. On Wed, May 31, 2017 at 2:46 PM, Tom Lane wrote: > Adrian Klaver writes: > > On 05/31/2017 06:24 AM, Osahon Oduware wrote: > >> I successfully built PostgreSQL from source on Linux (Centos

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

I am using PostgreSQL 9.6.2 On Wed, May 31, 2017 at 2:34 PM, Adrian Klaver wrote: > On 05/31/2017 06:24 AM, Osahon Oduware wrote: > >> Hi All, >> >> I successfully built PostgreSQL from source on Linux (Centos 7) using the >> following: >> > > What version of

[GENERAL] Ora2Pg-Database migration report

Hi All, What is the formula to calculate estimated cost in Ora2Pg-Database migration report? -Pawan

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

Adrian Klaver writes: > On 05/31/2017 06:24 AM, Osahon Oduware wrote: >> I successfully built PostgreSQL from source on Linux (Centos 7) using >> the following: >> ./configure --prefix=/home/nagispg/local/pgsql --with-libxml --with-libxslt >> ... >> When I run

Re: [GENERAL] Build PostgreSQL With XML Support on Linux

On 05/31/2017 06:24 AM, Osahon Oduware wrote: Hi All, I successfully built PostgreSQL from source on Linux (Centos 7) using the following: What version of Postgres? ./configure --prefix=/home/nagispg/local/pgsql --with-libxml --with-libxslt I would look in config.log in the build

[GENERAL] Build PostgreSQL With XML Support on Linux

Hi All, I successfully built PostgreSQL from source on Linux (Centos 7) using the following: ./configure --prefix=/home/nagispg/local/pgsql --with-libxml --with-libxslt Prior to this I had installed the xml and xslt packages (amongst others) using: yum install libxml2-devel yum install

[GENERAL] Redo the filenode link in tablespace

Hi. I have a rather serious problem in my database. I'll try to summarize what happened and how far I've gotten with the help of friends from the pgsql-sql list. First of all I apologize for the size of the question. But I do not see any other way to do it. Windows 2008 R2 - 64 bits PostgreSQL

Re: [GENERAL] Slow query plan used

Am 31.05.2017 um 13:27 schrieb Wetzel, Juergen (Juergen): Only 130 rows out of the 3 have ARCHIVED = 0 in this case i would suggest a partial index: create index on (archived) where archived = 0; Thanks, Andreas. Sorry for the confusion about the table names. The hint with the partial

Re: [GENERAL] Slow query plan used

>> Only 130 rows out of the 3 have ARCHIVED = 0 > in this case i would suggest a partial index: > create index on (archived) where archived = 0; Thanks, Andreas. Sorry for the confusion about the table names. The hint with the partial index sounds as it could solve the problem. I will

Re: [GENERAL] Slow query plan used

Am 30.05.2017 um 10:42 schrieb Wetzel, Juergen (Juergen): > I have a question concerning the query planner. I observe that chosen query plan differs on length and content of a like > search expression. We have a view combining data from two tables, both containing same number of rows (round

Re: [GENERAL] Regexp + spaces PG 9.1

2017-05-31 16:34 GMT+12:00 David G. Johnston : > On Tue, May 30, 2017 at 9:17 PM, Patrick B > wrote: > >> >> regexp_matches(name, '((main|medium).name/\d+.\d+)') as filename, >> >> >> Example here: http://sqlfiddle.com/#!15/5f4f0/4 >> >>