[GENERAL] C code with embedded SQL

2016-11-14 Thread Poul Kristensen
Can't the gcc compiler be used for the subject I have ordered the book "Postgresql for develophers" and hope to see some examples there covering C(Gnu) with embedded SQL. Thanks Poul

[GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-21 Thread Poul Kristensen
Hi! Hopefully this is this list. A shell variabel is defined like this var1= value used like ${var1}. How is the equal defened in the Postgresql C programming? Thanks. Poul BTW: I have not received my ordered book yet!

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-22 Thread Poul Kristensen
; On Mon, Nov 21, 2016 at 11:22 AM, Poul Kristensen > wrote: > >> Thank you for fast repons! >> >> The $1 substitution below. I assume that it refers to "joe's place". But >> it is not very clear to me, how "joe's place" will appear ins

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-23 Thread Poul Kristensen
LL, /* defaul to all text params */ 1); /* return all values as binary */ Thanks. /Poul 2016-11-22 15:50 GMT+01:00 John McKown : > On Tue, Nov 22, 2016 at 8:22 AM, Poul Kristensen > wrote: > >> I think I understand. >> When I use this in my code I get >> &q

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-23 Thread Poul Kristensen
ommandline. Do you have a hint of the substitution syntax to be used in gnu gcc. Thanks. /Poul 2016-11-23 16:44 GMT+01:00 Tom Lane : > "David G. Johnston" writes: > > On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen > wrote: > >> In the postgresql.log I get

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

2016-11-27 Thread Poul Kristensen
2016-11-23 21:31 GMT+01:00 Poul Kristensen : > My goal is to grap a user from the OS and and substitute the grapped user > - to be the owner of the database - in the sql commands > e.g using shell-script substitution syntax: >create user ${user} with login; >cr

Re: [GENERAL] ora2pg - Java Message Service (JMS) Type

2016-12-10 Thread Poul Kristensen
er_data AQ$_JMS_TEXT_MESSAGE, > > > > Thanks, > > Joanna > This message and the information contained herein is proprietary and > confidential and subject to the Amdocs policy statement, you may review at > http://www.amdocs.com/email_disclaimer.asp > -- Med venlig hilsen / Best regards Poul Kristensen Linux-OS/Virtualizationexpert and Oracle DBA

[GENERAL] pg_hba.conf debugging or logging when using ldag to authenticate

2016-12-19 Thread Poul Kristensen
Hi ! Does anyone know how to log or debug authentication against ad? A few years ago is it was possible to log everything to confirm using the right KDC and the right principal and hereby be sure to send the right userid possible concatenated with the realm.(I can't remember exacty) As far as I ca

[GENERAL] Checksum and Wal files

2017-03-23 Thread Poul Kristensen
Hi! Are all files inclusive wal files added a checksum? We will be doing regularly tests of recovery using checksums as the parameter of a succesfull recovery. Thanks Poul

Re: [GENERAL] dynamic schema modeling and performance

2017-04-11 Thread Poul Kristensen
he "dynamic" schema aspect. A > concern here is the lack of relation support, thus leading to a more > denormalized data structure and the potential for the data to become > corrupted. > > Any opinions on the use of psql for this case, or other options would be >

[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] 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 Kristens

Re: [GENERAL] Postgresql and github

2017-11-09 Thread Poul Kristensen
00 GMT+01:00 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 >