Re: deallocate statement failing

On Fri, 2020-02-07 at 00:48 -0500, Tom Lane wrote: > rob stone writes: > > 2020-02-07 15:42:55 AEDT ERROR: syntax error at or near > > "'AIT1581050529'" at character 13 > > 2020-02-07 15:42:55 AEDT STATEMENT: DEALLOCATE 'AIT1581050529' > > The deallocate statement fails. It doesn't matter

Re: deallocate statement failing

rob stone writes: > 2020-02-07 15:42:55 AEDT ERROR: syntax error at or near > "'AIT1581050529'" at character 13 > 2020-02-07 15:42:55 AEDT STATEMENT: DEALLOCATE 'AIT1581050529' > The deallocate statement fails. It doesn't matter if it is just > "DEALLOCATE" or "DEALLOCATE PREPARE". I think

Re: deallocate statement failing

On 2/6/20 9:02 PM, rob stone wrote: Hello, Version:- PostgreSQL 12.1 (Debian 12.1-2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 9.2.1-22) 9.2.1 20200104, 64-bit Log:- 2020-02-07 15:42:55 AEDT LOG: statement: SELECT COUNT(*) AS ps_count FROM pg_prepared_statements WHERE name =

deallocate statement failing

Hello, Version:- PostgreSQL 12.1 (Debian 12.1-2) on x86_64-pc-linux-gnu, compiled by gcc (Debian 9.2.1-22) 9.2.1 20200104, 64-bit Log:- 2020-02-07 15:42:55 AEDT LOG: statement: SELECT COUNT(*) AS ps_count FROM pg_prepared_statements WHERE name = 'AIT1581050529' 2020-02-07 15:42:55 AEDT

Re: POLL: Adding transaction status to default psql prompt

> > Em qua, 5 de fev de 2020 às 23:55, Vik Fearing > escreveu: > >> >> Please answer +1 if you want or don't mind seeing transaction status by >> default in psql or -1 if you would prefer to keep the current default. > > +1 I liked the idea just reading about it, but thought it would be good

Re: POLL: Adding transaction status to default psql prompt

On Wed, Feb 5, 2020 at 8:05 PM Vik Fearing wrote: > Because it isn't always easy to modify the .psqlrc file. This is > especially true if you frequently connect to other people's systems. > Exactly. You can tune your psql a lot, including excellent pspg, but then you frequently troubleshoot

Re: Unable to startup postgres: Could not read from file "pg_clog/00EC"

On Fri, Feb 7, 2020 at 1:47 AM Nick Renders wrote: > Thank you for the feedback, Alvaro. > > Unfortunately, the database is no longer "dumpable". We were able to do > a pg_dump yesterday morning (12 hours after the crash + purging the > pg_clog) but if we try one now, we get the following error:

Re: POLL: Adding transaction status to default psql prompt

Em qua, 5 de fev de 2020 às 23:55, Vik Fearing escreveu: > > Please answer +1 if you want or don't mind seeing transaction status by > default in psql or -1 if you would prefer to keep the current default. > +1 -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/

Re: Function not imported in Entity Framework

On 2/6/20 1:36 AM, Vikram Sah wrote: Dear sir/mam, I want to integrate PostgreSQL database to entity framework in asp.net using database first approach. but when try to add function then error occurred: *Error 6046: Unable to generate function import return type of the

Re: POLL: Adding transaction status to default psql prompt

Please answer +1 if you want or don't mind seeing transaction status by default in psql or -1 if you would prefer to keep the current default. +1 -- Charles Clavadetscher Swiss PostgreSQL Users Group Treasurer Spitzackerstrasse 9 CH - 8057 Zürich http://www.swisspug.org

Re: POLL: Adding transaction status to default psql prompt

чт, 6 февр. 2020 г. в 04:55, Vik Fearing : > Please answer +1 if you want or don't mind seeing transaction status by > default in psql or -1 if you would prefer to keep the current default. > +1 -- Victor Yegorov

Re: Unable to startup postgres: Could not read from file "pg_clog/00EC"

Thank you for the feedback, Alvaro. Unfortunately, the database is no longer "dumpable". We were able to do a pg_dump yesterday morning (12 hours after the crash + purging the pg_clog) but if we try one now, we get the following error: unexpected chunk number 1 (expected 0) for toast value

Re: POLL: Adding transaction status to default psql prompt

On 06/02/2020 02:54, Vik Fearing wrote: > Hello, > > I proposed a patch to add %x to PROMPT1 and PROMPT2 by default in psql. > > The effect of this is: > > - nothing at all when not in a transaction, > - adding a '*' when in a transaction or a '!' when in an aborted > transaction. > > Before

Re: POLL: Adding transaction status to default psql prompt

>On Thu, Feb 06, 2020 at 03:54:48AM +0100, Vik Fearing wrote: >> Please answer +1 if you want or don't mind seeing transaction status by >> default in psql or -1 if you would prefer to keep the current default. > >+1 +1 Daniel

Re: POLL: Adding transaction status to default psql prompt

On Thu, Feb 06, 2020 at 03:54:48AM +0100, Vik Fearing wrote: > Please answer +1 if you want or don't mind seeing transaction status by > default in psql or -1 if you would prefer to keep the current default. +1 depesz

Function not imported in Entity Framework

Dear sir/mam, I want to integrate PostgreSQL database to entity framework in asp.net using database first approach. but when try to add function then error occurred: *Error 6046: Unable to generate function import return type of the store function.* I have following configuration: PostgreSQL