Singleton SELECT inside cursor loop

2022-09-30 Thread Ron
AWS RDS Postgresql 12.11 It runs quickly, no matter what the fetched cursor values are, as long as the cursor returns less than 8 rows.  After that, the singleton SELECT's performance tanks. We've got plenty of other procedures which have a similar "Singleton SELECT inside a cursor" design (

Re: Limiting the operations that client-side code can perform upon its database backend's artifacts

2022-09-30 Thread Bryn Llewellyn
> hjp-pg...@hjp.at wrote: > >> b...@yugabyte.com wrote: >> >> Paraphrasing Peter, the design of the application's RDBMS backend has to >> implement its own notions of roles and privileges as a new layer on top of >> whatever the native RDBMS mechanisms provide. Some RDBMSs have native >> primi

Re: Is there Postgres ODBC binary for OSX?

2022-09-30 Thread Igor Korot
Hi, On Fri, Sep 30, 2022 at 10:41 AM Daniel Gustafsson wrote: > > > On 30 Sep 2022, at 17:36, Igor Korot wrote: > > > Is building it myself the only option? > > A quick googling indicates that there are options in the macOS package > managers: > > https://formulae.brew.sh/formula/psqlodb

RE: Postgresql database and application server compatibility

2022-09-30 Thread Rickson Marshall
Thanks Laurenz. Regards, Rickson -Original Message- From: Laurenz Albe Sent: Friday, September 30, 2022 12:53 PM To: Rickson Marshall ; pgsql-general@lists.postgresql.org Subject: Re: Postgresql database and application server compatibility EXTERNAL EMAIL On Fri, 2022-09-30 at 01:36

Re: Limiting the operations that client-side code can perform upon its database backend's artifacts

2022-09-30 Thread Peter J. Holzer
On 2022-09-29 20:24:59 -0700, Bryn Llewellyn wrote: > Paraphrasing Peter, the design of the application's RDBMS backend has to > implement its own notions of roles and privileges as a new layer on top of > whatever the native RDBMS mechanisms provide. Some RDBMSs have native > primitives that help

Re: Postgresql database and application server compatibility

2022-09-30 Thread Laurenz Albe
On Fri, 2022-09-30 at 01:36 +, Rickson Marshall wrote: > We will be moving from Postgresql 9.6 to Postgresql 13.XX which will be > installed in our > Rocky Linux 8 database server which will talk to our application which will > be installed > in our Windows application Server which will have

Re: Postgresql database and application server compatibility

2022-09-30 Thread Ron
Pg13 listens on port 5432 just like Pg 9.6, if that's what you mean. On 9/29/22 20:36, Rickson Marshall wrote: Hello Postgresql community, My name is Rickson. I hope this email finds you well and I hope that I’m asking this question in the right forum. If this is not the right mailing list,

Re: NULL values and Java JDBC

2022-09-30 Thread Matthias Apitz
El día viernes, septiembre 30, 2022 a las 09:56:07a. m. -0600, Rob Sargent escribió: > On 9/30/22 09:46, Matthias Apitz wrote: > > Hello, > > > > Columns may contain NULL values. The ecpg for pre-compiling ESQL/C code > > has an option to let return NULL values in CHAR columns as empty strings "

Re: NULL values and Java JDBC

2022-09-30 Thread Rob Sargent
On 9/30/22 09:46, Matthias Apitz wrote: Hello, Columns may contain NULL values. The ecpg for pre-compiling ESQL/C code has an option to let return NULL values in CHAR columns as empty strings "" and INTEGER as INT_MIN (-0x7fff - 1) values. Is there a similar option for Java JDBC? Thanks

NULL values and Java JDBC

2022-09-30 Thread Matthias Apitz
Hello, Columns may contain NULL values. The ecpg for pre-compiling ESQL/C code has an option to let return NULL values in CHAR columns as empty strings "" and INTEGER as INT_MIN (-0x7fff - 1) values. Is there a similar option for Java JDBC? Thanks matthias -- Matthias Apitz, ✉ g.

Re: Is there Postgres ODBC binary for OSX?

2022-09-30 Thread Daniel Gustafsson
> On 30 Sep 2022, at 17:36, Igor Korot wrote: > Is building it myself the only option? A quick googling indicates that there are options in the macOS package managers: https://formulae.brew.sh/formula/psqlodbc#default -- Daniel Gustafsson https://vmware.com/

Is there Postgres ODBC binary for OSX?

2022-09-30 Thread Igor Korot
Hi, ALL, Is building it myself the only option? Thank you.

Postgresql database and application server compatibility

2022-09-30 Thread Rickson Marshall
Hello Postgresql community, My name is Rickson. I hope this email finds you well and I hope that I’m asking this question in the right forum. If this is not the right mailing list, please let me know in which forum should I be asking this question. We will soon be upgrading all of our applicatio

Re: [BeginnerQuestion]Why I compile lex.yy.c failed?

2022-09-30 Thread Tom Lane
Wen Yi writes: > I am a beginner who are interested in database,when I do my study on the lex > and yacc,I write a example.l like this: > %% > .\|n ECHO > %% > and then I generate a lex.yy.c use lex > but when I compile this file,something wrong happend: > [beginnerc@bogon temp]$ flex '/home/

[BeginnerQuestion]Why I compile lex.yy.c failed?

2022-09-30 Thread Wen Yi
Hi community, I am a beginner who are interested in database,when I do my study on the lex and yacc,I write a example.l like this: %% .\|n ECHO %% and then I generate a lex.yy.c use lex but when I compile this file,something wrong happend: [beginnerc@bogon temp]$ flex '/home/beginnerc/work/tem