Thanks again, Scott. No success yet though.
I uninstalled Oracle instant client 12.1 using dpkg, downloaded RPMs for
instant client 10.2 and installed them with alien.
I also downloaded oracle_fdw 1.4 and installed it, since I was getting this
error with oracle_fdw 1.5:
---
postgres=# create exte
>
>
>>
>>
>
> Please have a look on this example Patrick: http://sqlfiddle.com/#!15/
> 1773d/4
>
> Lucas
>
>
This helped a lot... it's working now :) Thanks guys!!!
Patrick
On 16/09/16 08:07, Patrick B wrote:
>
>
> A select can make up columns too, not just what you've got in a table,
> so you can:
>
> select j_id, 'test-1 - comments' as comment from test2 where
> customer_id=88897;
>
> and then you can simply insert that into your other table
2016-09-16 10:07 GMT+12:00 Patrick B :
>
>>
>> A select can make up columns too, not just what you've got in a table,
>> so you can:
>>
>> select j_id, 'test-1 - comments' as comment from test2 where
>> customer_id=88897;
>>
>> and then you can simply insert that into your other table (you don't
>
>
>
>
> A select can make up columns too, not just what you've got in a table,
> so you can:
>
> select j_id, 'test-1 - comments' as comment from test2 where
> customer_id=88897;
>
> and then you can simply insert that into your other table (you don't
> need to specify the columns that are getting
On 16/09/16 07:45, Patrick B wrote:
> Hi guys,
>
>
> I got the test1 table with three columns:
>
> id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
>
>
> *This needs to be done 180 times:*
>
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1
> - comments'
On Thu, Sep 15, 2016 at 4:57 PM, Arun Rangarajan
wrote:
> Thanks, Scott.
>
> oracle_fdw version 1.5.0 from http://pgxn.org/dist/oracle_fdw/
>
> Oracle client version: instantclient 12.1
>
I've had problems using anything > instant client 10. Give it a shot.
--Scott
>
> /usr/lib/postgresql/9
Hi guys,
I got the test1 table with three columns:
id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
*This needs to be done 180 times:*
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1 -
> comments');
> INSERT INTO test1 (id,j_id,comments) VALUES (default,123322,'te
Thanks, Scott.
oracle_fdw version 1.5.0 from http://pgxn.org/dist/oracle_fdw/
Oracle client version: instantclient 12.1
/usr/lib/postgresql/9.4/lib# ldd oracle_fdw.so
linux-vdso.so.1 => (0x7fff50744000)
libclntsh.so.12.1 => /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1
(0x7f44769f
On Thu, Sep 15, 2016 at 3:25 PM, Arun Rangarajan
wrote:
> I am following the instructions here:
> http://blog.dbi-services.com/connecting-your-postgresql-
> instance-to-an-oracle-database/
> to install Oracle foreign data wrapper, oracle_fdw, on a PostgreSQL server.
>
> ---
> Oracle version: Orac
On Thu, Sep 15, 2016 at 5:46 AM, Jaap Roes wrote:
> I've got a table that stores some multilingual content:
>
> CREATE TABLE search (
> content text NOT NULL,
> language regconfig NOT NULL,
> fulltext tsvector
> );
> CREATE INDEX search_fulltext ON search USING GIN(f
On 9/15/2016 12:40 AM, MEERA wrote:
Could someone share below information?
- PgSQL versions supported on ubuntu 16
- PgSQL versions supported on debian 8
any current PG version (thats 9.1.latest (likely to be deprecated soon
when 9.6 releases) to 9.5.latest) can be run on most any version o
I am following the instructions here:
http://blog.dbi-services.com/connecting-your-postgresql-instance-to-an-oracle-database/
to install Oracle foreign data wrapper, oracle_fdw, on a PostgreSQL server.
---
Oracle version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
> On 15 Sep 2016, at 14:46, Jaap Roes wrote:
>
> I've got a table that stores some multilingual content:
>
>CREATE TABLE search (
> content text NOT NULL,
> language regconfig NOT NULL,
> fulltext tsvector
>);
>CREATE INDEX search_fulltext ON search USING GIN(fulltext
Hi,
Could someone share below information?
- PgSQL versions supported on ubuntu 16
- PgSQL versions supported on debian 8
--
thanks and regards,
Meera R Nair
Hi,
Below is my test environment.
2 DB servers: 9.4 postgres
1 PgPool and PgpoolAdmin server:
pgpool - version 3.5.4 (ekieboshi)
pgpoolAdmin - 3.5.3
php - PHP 5.6.25-2+deb.sury.org~xenial+1 (cli)
While setting up pgpoolAdmin I am getting error
"/var/www/html/pgpoolAdmin-3.5.3/conf/pgmgt.conf.php
Hey guys!
We are looking for active beta participants to try out our new SaaS-Based
Database Monitoring Tool. Our tool will monitor your databases and their
underlying (virtual) infrastructure. If you would like to be a part of the
beta, sign up here: http://www.bluemedora.com/early-access/
We wil
El 15/09/16 a las 11:57, Alex Sviridov escribió:
Hi all,
I have suspicions that my message don't get to pgsql-general mailing list.
Please, someone, answer this message if this get the mailing list.
Best regards, Alex
Arrived ok.
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 6
It did.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
From: Alex Sviridov
Sent: Thursday, September 15, 2016 4:57 PM
To: pgsql-general@post
Hi all,
I have suspicions that my message don't get to pgsql-general mailing list.
Please, someone, answer this message if this get the mailing list.
Best regards, Alex
El 15/09/16 a las 11:05, Tom Lane escribió:
"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes:
Hi, I'm getting this error:
2016-09-15 09:35:24 ART [13984-1] ERROR: could not read block 4 in file
"base/12210/11965": Error de entrada/salida
That looks like a hardware problem ... might want to budget f
"=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes:
> Hi, I'm getting this error:
> 2016-09-15 09:35:24 ART [13984-1] ERROR: could not read block 4 in file
> "base/12210/11965": Error de entrada/salida
That looks like a hardware problem ... might want to budget for a new disk
sometime soon, before fail
Yogesh Sharma writes:
> We are using below postgresql rpm.
> postgresql-8.1.18-2.1
As already noted, that version is *way* obsolete, and full of known bugs.
It's irresponsible to be storing data you care about in such a version.
Having said that ...
> In our system, below error is found and occu
I've got a table that stores some multilingual content:
CREATE TABLE search (
content text NOT NULL,
language regconfig NOT NULL,
fulltext tsvector
);
CREATE INDEX search_fulltext ON search USING GIN(fulltext);
INSERT INTO search (language, content) VALUES
Hi, I'm getting this error:
2016-09-15 09:35:24 ART [13984-1] ERROR: could not read block 4 in file
"base/12210/11965": Error de entrada/salida
2016-09-15 09:35:39 ART [14082-1] ERROR: could not read block 4 in file
"base/12210/11965": Error de entrada/salida
2016-09-15 09:35:54 ART [14170-1]
Dear John,
Thanks for your support.
>as far as how do you determine whats wrong with your file system?
I tried fsck and hardware check using SMART disk info, no issue found with disk
or filesystem.
>what file system are you using for the volume containing the postgres data
>directory ? with R
On 9/15/2016 12:53 AM, John R Pierce wrote:
ok, those RPM's were built and packaged by Redhat, I believe. If you
have a RHEL support contract, you should be able to get help from
them. If you don't, you really shouldn't be running RHEL as there's
no updates available without one.
wait
On 9/15/2016 12:25 AM, Yogesh Sharma wrote:
Dear John,
Thanks for your support.
Please find below name of rpm.
RPMS/postgresql-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-devel-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-libs-8.1.18-2.1.x86_64.rpm
RPMS/postgresql-python-8.1.18-2.1.x86_64.rpm
RPMS/postgre
> On Sep 15, 2016, at 1:20 AM, Yogesh Sharma
> wrote:
>
> Dear John and all,
>
> >8.1 has been obsolete and unsupported for about 6 years now.8.1.18 was
> >released in 2009, the final 8.1.23 release was in 2010, after which it was
> >>dropped.
> Yes, we understood your point.
> But we r
Dear John and all,
>8.1 has been obsolete and unsupported for about 6 years now.8.1.18 was
>released in 2009, the final 8.1.23 release was in 2010, after which it was
>>dropped.
Yes, we understood your point.
But we require some information related to this rpm.
>These errors suggest disk fi
30 matches
Mail list logo
