I'm pretty sure that Watcom 9.6 libraries lacks long long or any such
variants.
And, of course, I don' t have another tool chain.
Thank you
On 21/08/17 22:20, George Neuner wrote:
On Mon, 21 Aug 2017 13:27:56 -0300, marcelo
wrote:
Is there a libpq porting to QNX 4.25? I just tried to compile
Hi, I’m having issues with deadlocks.
v9.6 on Debian Jessie.
I have a number of ‘select’ functions which for logging purposes also call
another fn that inserts a record into a ‘logging’ table.
However, even with only 1 or 2 users making very infrequent calls to the parent
fn, deadlocks are occ
On Tue, Aug 22, 2017 at 9:42 AM, Martin Moore
wrote:
> Hi, I’m having issues with deadlocks.
>
> v9.6 on Debian Jessie.
>
> I have a number of ‘select’ functions which for logging purposes also call
> another fn that inserts a record into a ‘logging’ table.
>
> However, even with only 1 or 2 user
On Tue, Aug 22, 2017 at 3:06 AM, Michael Paquier
wrote:
> On Tue, Aug 22, 2017 at 9:52 AM, Dylan Luong
> wrote:
> > 1. Disable the master ltm member (all connections redired to slave
> > member)
> > 2. Promote slave (touch promote.me)
> > 3. Stop the master db (old master)
> >
marcelo writes:
> Is there a libpq porting to QNX 4.25? I just tried to compile one of the
> modules, but was rejected because the QNX's standard library have not an
> Int64 type.
We removed QNX support in 8.2, so you could try using some pre-8.2
release. It's possible it was broken for awhile
Or this is the bug in 9.1?
Since it looks like there are 2 columns with the same info in 1 table/view
Thank you.
On Tue, Aug 22, 2017 at 12:08 AM, Igor Korot wrote:
> Hi, ALL,
> draft=# SELECT * FROM information_schema.key_column_usage WHERE
> table_schema = 'public' AND table_name = 'leagu
Thank you, Tom.
We'll replace those QNX machines with WIndows XP ones (via dual boot),
so we can use our Devart's ORM the same as the most "user oriented"
applications.
On 22/08/17 12:39, Tom Lane wrote:
marcelo writes:
Is there a libpq porting to QNX 4.25? I just tried to compile one of t
On Tue, Aug 22, 2017 at 8:43 AM, Igor Korot wrote:
> Or this is the bug in 9.1?
> Since it looks like there are 2 columns with the same info in 1
> table/view
>
This old email thread sounds similar to what you are describing here.
https://www.postgresql.org/message-id/56D0C4B8.7020200%40a
Hi, David,
On Tue, Aug 22, 2017 at 12:06 PM, David G. Johnston
wrote:
> On Tue, Aug 22, 2017 at 8:43 AM, Igor Korot wrote:
>>
>> Or this is the bug in 9.1?
>> Since it looks like there are 2 columns with the same info in 1
>> table/view
>
>
> This old email thread sounds similar to what you
*While the information_schema is useful, there is no substitute for
learning how to use the pg_catalog and system information functions.*
*See if this query gives you what you are looking for:*
*SELECT rel.relname, con.conname, con.contype,
con.consrc, pg_get_constraintdef
On Mon, Aug 21, 2017 at 9:08 PM, Igor Korot wrote:
> Hi, ALL,
> draft=# SELECT * FROM information_schema.key_column_usage
>
[...]
> There are 3 foreign keys in that table.
>
> Is there a way to get values of 0, 1, 1, and 2 for the ordinal position?
>
Not using the key_column_usage view. Wha
Hi, Melvin,
On Tue, Aug 22, 2017 at 12:55 PM, Melvin Davidson
wrote:
>
>
>
> *While the information_schema is useful, there is no substitute for
> learning how to use the pg_catalog and system information functions.*
>
>
> *See if this query gives you what you are looking for:*
>
>
>
>
>
>
> *SE
Hi, ALL,
[quote]
PQntuples
Returns the number of rows (tuples) in the query result. Because it
returns an integer result, large result sets might overflow the return
value on 32-bit operating systems.
int PQntuples(const PGresult *res);
[/quote]
Is there another way to not to overflow the resu
Hi,
On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote:
> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
> 9.2 version that comes with CentOS 7.
>
> Is there a simple way to fix this so the 9.5 version of tools and libraries
> are used.
yum remove postgresql-*
y
We have a requirement to encrypt the entire database. What is the best tool
to accomplish this. Our primary goal is that it should be transparent to the
application, with no change in the application, as compared to un-encrypted
database. Reading about pgcrypto module, it seems it is good for few
On 08/22/2017 12:48 PM, rakeshkumar464 wrote:
We have a requirement to encrypt the entire database. What is the best tool
to accomplish this. Our primary goal is that it should be transparent to the
application, with no change in the application, as compared to un-encrypted
database. Reading abo
On Tue, Aug 22, 2017 at 2:48 PM, rakeshkumar464
wrote:
> We have a requirement to encrypt the entire database. What is the best tool
> to accomplish this. Our primary goal is that it should be transparent to the
> application, with no change in the application, as compared to un-encrypted
> datab
On 08/22/2017 02:55 PM, Joshua D. Drake wrote:
On 08/22/2017 12:48 PM, rakeshkumar464 wrote:
We have a requirement to encrypt the entire database. What is the best tool
to accomplish this. Our primary goal is that it should be transparent to the
application, with no change in the application, a
On 08/22/2017 01:08 PM, John McKown wrote:
On Tue, Aug 22, 2017 at 2:48 PM, rakeshkumar464
wrote:
We have a requirement to encrypt the entire database.
Personally, what I'd do (and actually do at work) is to us LUKS.
I second that, although I'll add that if you're on AWS you can also use
e
Thanks John and JD.
John: Are you telling that the backup of a database has no protection?
--
View this message in context:
http://www.postgresql-archive.org/PG-and-database-encryption-tp5979618p5979624.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent vi
On Tue, Aug 22, 2017 at 3:27 PM, rakeshkumar464
wrote:
> Thanks John and JD.
>
> John: Are you telling that the backup of a database has no protection?
If you use LUKS to encrypt a filesystem and then copy any file data on
that filesystem to another file on an unencrypted filesystem, then the
cop
On Tue, 22 Aug 2017 12:48:13 -0700 (MST)
rakeshkumar464 wrote:
> We have a requirement to encrypt the entire database. What is the best tool
> to accomplish this. Our primary goal is that it should be transparent to the
> application, with no change in the application, as compared to un-encrypte
Hi
Is there a reliable way to create a database link from PosgreSQL 9.6 to
Oracle 11g?
I am running 9.6 on Linux 64 bit.
I can connect to the Oracle database with sqlplus from the PostgreSQL
server.
Also, I have in attempted to install the oracle_fdw wrapper as an
alternatve, but I keep getting
Melvin et al,
On Tue, Aug 22, 2017 at 12:55 PM, Melvin Davidson
wrote:
>
>
>
> *While the information_schema is useful, there is no substitute for
> learning how to use the pg_catalog and system information functions.*
>
>
> *See if this query gives you what you are looking for:*
>
>
>
>
>
>
> *
On Tue, Aug 22, 2017 at 12:44 PM, Devrim Gündüz wrote:
>
> Hi,
>
> On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote:
>> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
>> 9.2 version that comes with CentOS 7.
>>
>> Is there a simple way to fix this so the 9.5 versi
On Tue, Aug 22, 2017 at 3:13 PM, PT wrote:
> On Tue, 22 Aug 2017 12:48:13 -0700 (MST)
> rakeshkumar464 wrote:
>
>> We have a requirement to encrypt the entire database. What is the best tool
>> to accomplish this. Our primary goal is that it should be transparent to the
>> application, with no c
On Tue, Aug 22, 2017 at 2:47 PM, Peter Koukoulis
wrote:
>
> Hi
>
> Is there a reliable way to create a database link from PosgreSQL 9.6 to
> Oracle 11g?
> I am running 9.6 on Linux 64 bit.
> I can connect to the Oracle database with sqlplus from the PostgreSQL
> server.
>
> Also, I have in attem
On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot wrote:
> [quote]
> PQntuples
>
> Returns the number of rows (tuples) in the query result. Because it
> returns an integer result, large result sets might overflow the return
> value on 32-bit operating systems.
>
> int PQntuples(const PGresult *res);
>
Hi, Michael,
On Tue, Aug 22, 2017 at 8:32 PM, Michael Paquier
wrote:
> On Wed, Aug 23, 2017 at 3:19 AM, Igor Korot wrote:
>> [quote]
>> PQntuples
>>
>> Returns the number of rows (tuples) in the query result. Because it
>> returns an integer result, large result sets might overflow the return
>>
On Tue, Aug 22, 2017 at 11:39 PM, Magnus Hagander wrote:
> On Tue, Aug 22, 2017 at 3:06 AM, Michael Paquier
> wrote:
>> That flow looks correct to me. No I think that you should trigger
>> manually a checkpoint after step 2 on the promoted standby so as its
>> control file gets forcibly updated c
On 22-08-2017 22:48, rakeshkumar464 wrote:
We have a requirement to encrypt the entire database. What is the best
tool
to accomplish this. Our primary goal is that it should be transparent
to the
application, with no change in the application, as compared to
un-encrypted
database. Reading abou
31 matches
Mail list logo
