debugger from superuser only.... why?

2023-09-19 Thread web
Checked few sources, can not seem to find reasoning behind this limit:> You must have superuser privileges to use the debugger.From here. Say, in java/c++/many_others... one can debug from non-proviledged user allright. Not so with pldbgapi. What is the reason? Alexander Petrossian (PAF)

Re: Changed functionality from 14.3 to 15.3

2023-09-19 Thread Erik Wienhold
On 2023-09-19 15:09 -0400, Michael Corey wrote: > We are experiencing different functionality once we upgraded from Postgres > 14.3 to Postgres 15.3. > > Below is a test case that we created which shows a schema user who has a > VIEW that accesses a table in another schema. In 14.3 the schema use

Changed functionality from 14.3 to 15.3

2023-09-19 Thread Michael Corey
We are experiencing different functionality once we upgraded from Postgres 14.3 to Postgres 15.3. Below is a test case that we created which shows a schema user who has a VIEW that accesses a table in another schema. In 14.3 the schema user is able to create the VIEW against the other schema's ta

Calculating Days/Time(Are Loops Neccessary?)

2023-09-19 Thread Anthony Apollis
I have a table that needs to give me all data up until yesterday. This will be part of an SSIS package that runs monthly, a day before the last day. code is: -- Create the new table if it doesn't exist and insert data CREATE TABLE IF NOT EXISTS "model"."IMETA_ZTBR_BRACS_Model_TA_BW" AS SELECT