RE: Read only to schema

Hello From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Freitag, 13. Juli 2018 07:00 To: pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Read only to schema Hi Guys, Yesterday i tried all day to figure out system to read only schemas. I want to : Here is

Read only to schema

Hi Guys, Yesterday i tried all day to figure out system to read only schemas. I want to : 1. Create user who can login (user: jaryszek) 2. Create role who can read only data (only watching tables) (role: readonly) 3, Create role who can read all data (inserting, deleting, altering, dropping) (ro

Re: How to watch for schema changes

On 07/12/2018 06:19 PM, Igor Korot wrote: Hi, On Thu, Jul 12, 2018 at 7:45 PM, Rob Sargent wrote: Can you try that again as root? Or with sudo? Yes, it did show up. But now it looks like I have 2 places to set the logging: log_statement_stats which I presume is just for statistics and

Re: How to watch for schema changes

Hi, On Thu, Jul 12, 2018 at 7:45 PM, Rob Sargent wrote: > >> [code] >> MyMac:/ igorkorot$ find . -name postgresql.conf >> find: ./.DocumentRevisions-V100: Permission denied >> find: ./.fseventsd: Permission denied >> find: ./.Spotlight-V100: Permission denied >> find: ./.Trashes: Permission deni

Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

--- The ODBC Global tracing was turned on too but any one entry was made from the powerbuilder app. --- No problem on sending the entire PB app, but it's really big, so follows the initial script with the connect and the ini file content with the parameters. I will make a minimalist PB script to

Re: How to watch for schema changes

On 07/12/2018 05:28 PM, Igor Korot wrote: Hi, On Thu, Jul 12, 2018 at 12:16 PM, David G. Johnston wrote: On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot wrote: No, see: https://www.postgresql.org/docs/10/static/sql-createtrigger.html AFTER trigger on views are STATEMENT level only. But I d

Re: How to watch for schema changes

Hi, On Thu, Jul 12, 2018 at 12:16 PM, David G. Johnston wrote: > On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot wrote: >> >> > No, see: >> > >> > https://www.postgresql.org/docs/10/static/sql-createtrigger.html >> > >> > AFTER trigger on views are STATEMENT level only. >> >> But I do have access t

Re: Postgres sometimes stalling on 'percentile_cont'

Tom van Tilburg writes: > Problem is that the query is not slow, it just stalls and never finishes ( > I waited several hours for a 2 seconds query). Would it still be possible > to derive an EXPLAIN ANALYZE from it in that case? No, not really, but it'd be sufficient to compare EXPLAIN (without

Re: How to watch for schema changes

On 07/12/2018 09:16 AM, David G. Johnston wrote: On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot >wrote: > No, see: > > https://www.postgresql.org/docs/10/static/sql-createtrigger.html

Re: How to watch for schema changes

On Thu, Jul 12, 2018 at 8:50 AM, Igor Korot wrote: > > No, see: > > > > https://www.postgresql.org/docs/10/static/sql-createtrigger.html > > > > AFTER trigger on views are STATEMENT level only. > > But I do have access to the STATEMENT right? > ​Yes, except nothing in the system actually attempt

Re: How to watch for schema changes

Hi, Adrian, On Wed, Jul 11, 2018 at 11:12 PM, Adrian Klaver wrote: > On 07/11/2018 08:46 PM, Igor Korot wrote: >> >> Hi, guys, >> >> >> On Mon, Jul 9, 2018 at 5:38 PM, Adrian Klaver >> wrote: >>> >>> On 07/09/2018 01:49 PM, Igor Korot wrote: Hi, Adrian On Tue, Jul 3, 201

Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

On 07/12/2018 05:19 AM, Igor Korot wrote: ,Hi, On Wed, Jul 11, 2018 at 10:33 PM, Edgard Battisti Guimarães wrote: I've ported a powerbuilder application to postgresql. Tested ok on windows 10 64, was installed on two win10-64 other computers, all connecting the postgresql database in the loca

Re: Stored function | Grayed out option when I try modify the return type

On 07/12/2018 02:28 AM, Abelardo León González wrote: -Mensaje original- De: Andreas Kretschmer Enviado el: jueves, 12 de julio de 2018 11:07 Para: Abelardo León González ; pgsql-general@lists.postgresql.org Asunto: Re: Stored function | Grayed out option when I try modify the return

Re: ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

,Hi, On Wed, Jul 11, 2018 at 10:33 PM, Edgard Battisti Guimarães wrote: > I've ported a powerbuilder application to postgresql. Tested ok on windows > 10 64, was installed on two win10-64 other computers, all connecting the > postgresql database in the localhost with access via odbc. The third o

Re: Stored function | Grayed out option when I try modify the return type

Am 12.07.2018 um 11:28 schrieb Abelardo León González: Sorry for top-posting here. :S I won't do it anymore. The idea is to modify the original function in order to meet the requirements. yeah, i understand. It's not to create two functions, it's to modify the original one. Internally,

ODBC - Getting CONN ERROR: errmsg='The buffer was too small for the InfoValue'

I've ported a powerbuilder application to postgresql. Tested ok on windows 10 64, was installed on two win10-64 other computers, all connecting the postgresql database in the localhost with access via odbc. The third of them presented the error detailed below in the logs (mylog and psqlodbc) inte

RE: Stored function | Grayed out option when I try modify the return type

-Mensaje original- De: Andreas Kretschmer Enviado el: jueves, 12 de julio de 2018 11:07 Para: Abelardo León González ; pgsql-general@lists.postgresql.org Asunto: Re: Stored function | Grayed out option when I try modify the return type Am 12.07.2018 um 10:56 schrieb Abelardo León

Re: Stored function | Grayed out option when I try modify the return type

Am 12.07.2018 um 10:56 schrieb Abelardo León González: Thanks Andreas for your response. This is an annoying procedure to modify it. Why did pgAdmin staff decide to do it this way? It's a waste time! No. Two functions with the same name, but different returns types (for instance) are valid

RE: Stored function | Grayed out option when I try modify the return type

Thanks Andreas for your response. This is an annoying procedure to modify it. Why did pgAdmin staff decide to do it this way? It's a waste time! :/ Best regards. -Mensaje original- De: Andreas Kretschmer Enviado el: jueves, 12 de julio de 2018 10:53 Para: pgsql-general@lists.postg

Re: Stored function | Grayed out option when I try modify the return type

Am 12.07.2018 um 10:25 schrieb Abelardo León González: Hello world, Here a newbie in PgAdmin. When I create a stored function and I try to modify it to change the return type (or anything else), I can’t modify it. I am not sure if it is a bug….and I am not sure if this message should be

Re: How to watch for schema changes

2018-07-12 6:12 GMT+02:00 Adrian Klaver : > On 07/11/2018 08:46 PM, Igor Korot wrote: > >> Hi, guys, >> >> >> On Mon, Jul 9, 2018 at 5:38 PM, Adrian Klaver >> wrote: >> >>> On 07/09/2018 01:49 PM, Igor Korot wrote: >>> Hi, Adrian On Tue, Jul 3, 2018 at 1:24 PM, Adrian Klaver <

Stored function | Grayed out option when I try modify the return type

Hello world, Here a newbie in PgAdmin. When I create a stored function and I try to modify it to change the return type (or anything else), I can’t modify it. I am not sure if it is a bug….and I am not sure if this message should be in bugs mail list. Sorry if I am wrong. Best regar