cached plan must not change result type

2018-03-07 Thread Jan Bilek
Hi all, Our client noticed a problem which occurred so far twice, but might be having quite significant impact on our application processing in production: ResStatus: PGRES_FATAL_ERROR transaction. ErrorMessage: ERROR: cached plan must not change result type. Reading through the documentation

RE: Troubleshooting a segfault and instance crash

2018-03-08 Thread Jan Bilek
Hi Blair, Pavel, we are using procedure described in https://access.redhat.com/solutions/4896 to automate crash detail collection for our production systems on RHEL 7. Perhaps something like this can help on your side. Kind Regards, Jan On 2018-03-09 04:35:05+10:00 Pavel Stehule wrote: 2018

RE: Troubleshooting a segfault and instance crash

2018-03-24 Thread Jan Bilek
being able to link those debugging symbols to your core dump, we should immediately see where it is and you'll do a great help to the community. I'm sure that then Pavel will be able to issue a fix in a matter of minutes ;) Kind Regards, Jan -- Jan Bilek CTO, EFTLab M: +61 (0) 498 103

PCI:SSF - Safe SQL Query & operators filter

2022-11-07 Thread Jan Bilek
hat white-listing / blacklisting comes with its own problems where we are DB agnostic... I am sorry for a long email, but any ideas/pointers will be greatly appreciated. Thank you & Kind Regards, Jan -- Jan Bilek - CTO at EFTlab Pty Ltd.

Re: PCI:SSF - Safe SQL Query & operators filter

2022-11-07 Thread Jan Bilek
On 11/8/22 11:29, Christophe Pettus wrote: > >> On Nov 7, 2022, at 17:24, Jan Bilek wrote: >> Would there be any way to go around this? > The typical configuration is to not permit the PostgreSQL superuser to log in > remotely. The database can be managed by a differen

Re: PCI:SSF - Safe SQL Query & operators filter

2022-11-07 Thread Jan Bilek
On 11/8/22 11:50, Christophe Pettus wrote: > >> On Nov 7, 2022, at 17:43, Jan Bilek wrote: >> >> Well, superuser (our App) is already logged in and as it is designed >> very much as an "appliance" it simply does that job - manages its >> database.

Re: PCI:SSF - Safe SQL Query & operators filter

2022-11-07 Thread Jan Bilek
On 11/8/22 17:03, Laurenz Albe wrote: > On Tue, 2022-11-08 at 04:14 +0000, Jan Bilek wrote: > >> I know it is not exactly what you suggested (and agreeing a lot with our >> app user shouldn't be running as superuser), but as all other inputs >> from our application co

ERROR: unsupported Unicode escape sequence - in JSON-type column

2023-02-26 Thread Jan Bilek
Jan -- Jan Bilek - CTO at EFTlab Pty Ltd.

Re: ERROR: unsupported Unicode escape sequence - in JSON-type column

2023-02-27 Thread Jan Bilek
On 2/27/23 22:13, Laurenz Albe wrote: On Mon, 2023-02-27 at 06:28 +, Jan Bilek wrote: Our customer was able to sneak in an Unicode data into a column of a JSON Type and now that record fails on select. Would you be able to suggest any way out of this? E.g. finding infringing row, updating

Re: ERROR: unsupported Unicode escape sequence - in JSON-type column

2023-02-27 Thread Jan Bilek
at record was on & off - I couldn't pin-point it in DB as it seemed to be failing on multiple places ... until using that trick from Laurenz. Felt like a PostgreSQL memory corruption, but system remained stable without any complaints. Thanks & Cheers, Jan -- Jan Bilek - CTO at EFTlab Pty Ltd.

Requirement PA-DSS 1.1.4

2019-06-03 Thread Jan Bilek
Hi, We've build a Payments Authorisation system (Box solution) on Postgresql database and now we are hitting following issue with our PA:DSS audit - requirement PA-DSS 1.1.4: <> 1.1.4 Securely delete any track data (from the magnetic stripe or equivalent data contained on a chip), card verific

RE: Requirement PA-DSS 1.1.4

2019-06-05 Thread Jan Bilek
Hi team, anyone? Please let me know if this is not a correct group to ask, I'll move it somewhere else. Thank you in advance & Kind Regards, Jan On 2019-06-04 08:56:47+10:00 Jan Bilek wrote: Hi, We've build a Payments Authorisation system (Box solution) on Postgresql datab

RE: Requirement PA-DSS 1.1.4

2019-06-06 Thread Jan Bilek
Thank you all - Karsten, Benjamin, Pavel, PostgreSql team, I've discussed all your inputs with our developers and they came with a solution for this problem, which was already agreed (on a high level) by our auditor. I am adding it here so it can inspire the others, when potentially getting in