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

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

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

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

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

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,

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

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

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)

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:

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

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