SV: Log files polluted with permission denied error messages after every 10 seconds

> > >Fra: Andrus >Sendt: 8. marts 2021 23:24 >Emne: Re: Log files polluted with permission denied error messages after every >10 seconds > >Permission denied error occur in Windows. Debian logs doesnt contain it. >In Windows also pg_database_size('mydb') and similar ones fail frequently >with

Re: Need help with clarification on stored procedure support in PostGreSQL database

On Mon, Mar 8, 2021 at 9:41 PM Tom Lane wrote: > Guyren Howe writes: > > This seems like an important consideration. I’ve spent 10 minutes > searching the documentation for PG 11 and can’t find where it is > documented. Perhaps it should be made more prominent? > > https://www.postgresql.org/doc

Re: Need help with clarification on stored procedure support in PostGreSQL database

I think that’s burying the lede a bit. Still, unless the “Extending SQL Section” acquired an Overview section, I’m not sure where else you’d put it. On Mar 8, 2021, 20:41 -0800, Tom Lane , wrote: > Guyren Howe writes: > > This seems like an important consideration. I’ve spent 10 minutes searching

Re: Need help with clarification on stored procedure support in PostGreSQL database

Guyren Howe writes: > This seems like an important consideration. I’ve spent 10 minutes searching > the documentation for PG 11 and can’t find where it is documented. Perhaps it > should be made more prominent? https://www.postgresql.org/docs/current/xproc.html regards,

Re: Need help with clarification on stored procedure support in PostGreSQL database

This seems like an important consideration. I’ve spent 10 minutes searching the documentation for PG 11 and can’t find where it is documented. Perhaps it should be made more prominent? On Mar 8, 2021, 16:53 -0800, raf , wrote: > On Mon, Mar 08, 2021 at 06:31:56PM -0500, Tom Lane wrote: > > > raf

Re: Need help with clarification on stored procedure support in PostGreSQL database

On Mon, Mar 08, 2021 at 06:31:56PM -0500, Tom Lane wrote: > raf writes: > > Is there any important different between a stored procedure and > > a stored function that returns void? I've been using functions > > for everything but calling them procedures in my head (even though > > most of them d

Re: Need help with clarification on stored procedure support in PostGreSQL database

raf writes: > Is there any important different between a stored procedure and > a stored function that returns void? I've been using functions > for everything but calling them procedures in my head (even though > most of them do return a value or result set). A procedure can commit or rollback a

Re: Log files polluted with permission denied error messages after every 10 seconds

Yeah, I've wondered for some time if the apparent EACCES code is actually being mapped from something other than ERROR_SHARING_VIOLATION in (some of?) these reports. The hard part is to hold onto the Windows error code alongside errno without massively invasive changes. Permission denied erro

Re: Need help with clarification on stored procedure support in PostGreSQL database

On Sun, Mar 07, 2021 at 11:01:07AM -0800, Adrian Klaver wrote: > On 3/7/21 10:48 AM, Bysani, Ram wrote: > > PostgreSQL version: 11.11 > > > > Operating system:   Linux 64 bit > > > > Description: > > > > Greetings > > > > We have found posts on several forums that Stored Procedures are not >

Re: Log files polluted with permission denied error messages after every 10 seconds

Another thought: if it's not a sharing violation, I wonder if we should consider dumping more raw Windows error information in the messages we log, because, if I recall correctly, we're converting many Windows error codes into few Unix-style error numbers and thereby throwing away valuable clues

Re: Log files polluted with permission denied error messages after every 10 seconds

Thomas Munro writes: > Another thought: if it's not a sharing violation, I wonder if we > should consider dumping more raw Windows error information in the > messages we log, because, if I recall correctly, we're converting many > Windows error codes into few Unix-style error numbers and thereby >

Re: Log files polluted with permission denied error messages after every 10 seconds

On Sat, Mar 6, 2021 at 2:36 PM Michael Paquier wrote: > On Fri, Mar 05, 2021 at 07:36:37PM +0200, Andrus wrote: > > Then turned real-time protection off: > > > > Problem persists. New entry is written after every 10 seconds. > > On which files are those complaints? It seems to me that you may hav

Re: Stored function RETURNS table, but in some cases columns are missing - should I set them to NULL?

Alexander Farber writes: > However there are cases, when I only have the out_gid value, I do not want > to return any other values. > My question is: do I have to set the other OUT params explicitly to NULL? plpgsql initializes them to null by default, I believe, just like ordinary local variable

Re: Question about when PostgreSQL 11.0 was released

https://www.postgresql.org/docs/release/ 2021-03-08 15:33 GMT-03:00, Michael Lewis : > I can't find a page on the website right now that specifies it, but the > feature freeze is around April each year then general availability in > October. Minor releases are scheduled quarterly I believe. Major

Re: Stored function RETURNS table, but in some cases columns are missing - should I set them to NULL?

Hi po 8. 3. 2021 v 19:20 odesílatel Alexander Farber < alexander.far...@gmail.com> napsal: > Good evening, > > in PostgreSQL 13.2 I have a custom stored function: > > CREATE OR REPLACE FUNCTION words_join_new_game( > in_uid integer, > in_bid integer >

Re: updating PGDG 12 devel on centos7 requires llvm5.0

On Mon, 8 Mar 2021 at 16:15, I wrote: > Tried running yum update on my centos7 box. Get the following: > > Error: Package: postgresql12-devel-12.5-1PGDG.rhel7.x86_64 (postgresql_12) >Requires: llvm5.0-devel >= 5.0 > I tried adding the EPEL repo just in case that was the issue but it >

Re: Question about when PostgreSQL 11.0 was released

I can't find a page on the website right now that specifies it, but the feature freeze is around April each year then general availability in October. Minor releases are scheduled quarterly I believe. Major versions are EOL'd after 5 or so years.

Re: Question about when PostgreSQL 11.0 was released

On 3/8/21 1:22 PM, Bysani, Ram wrote: > I am not finding the release cadence for the PostgreSQL databases. Please let > me > know how I can find the base and dot version release dates for: > > PostgreSQL 11 > PostgreSQL 12 > PostgreSQL 13 I'm not sure a consolidated list of the minor release da

Re: Question about when PostgreSQL 11.0 was released

Bysani, Ram schrieb am 08.03.2021 um 19:22: Hello community: I am not finding the release cadence for the PostgreSQL databases. Please let me know how I can find the base and dot version release dates for: PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 Check the release notes for the respective

Question about when PostgreSQL 11.0 was released

Hello community: I am not finding the release cadence for the PostgreSQL databases. Please let me know how I can find the base and dot version release dates for: PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 Thanks Ram

Stored function RETURNS table, but in some cases columns are missing - should I set them to NULL?

Good evening, in PostgreSQL 13.2 I have a custom stored function: CREATE OR REPLACE FUNCTION words_join_new_game( in_uid integer, in_bid integer ) RETURNS table ( -- the player to be notified (sometimes there is no such user)

updating PGDG 12 devel on centos7 requires llvm5.0

Hi I'm clearly missing something obvious but it's passed me by what that might be, so a pointer would be appreciated... Tried running yum update on my centos7 box. Get the following: Error: Package: postgresql12-devel-12.5-1PGDG.rhel7.x86_64 (postgresql_12) Requires: llvm5.0-devel >=

Re: PostgreSQL container crash trouble.

On Mon, 2021-03-08 at 22:30 +0900, Daisuke Ikeda wrote: > I'm running PostgreSQL (enabled timescaledb extension) in the following > environment. > And I had db pod crashed error several times irregularly. > > I want to know the cause of this fail. > > Environment: > > - Base: Kubernetes(micr

PostgreSQL container crash trouble.

Dear all. I'm running PostgreSQL (enabled timescaledb extension) in the following environment. And I had db pod crashed error several times irregularly. I want to know the cause of this fail. Environment: - Base: Kubernetes(microk8s) - DB: PostgreSQL 12.4 (TimescaleDB) Container - DB OS: