Re: Space Stalker in SQL Output

On 06/27/2018 12:45 PM, Susan Hurst wrote: > Wow!  The -A option worked perfectly! > > Thanks for the syntax lesson Steve and Jerry! If you are going to be doing lots of scripting with Postgres, you might want to take a look here: https://github.com/jconway/shebang HTH, Joe -- Crunchy Data -

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

On 06/27/2018 09:55 AM, Moreno Andreo wrote: Il 22/06/2018 19:56, Adrian Klaver ha scritto: On 06/22/2018 09:50 AM, Moreno Andreo wrote: Il 22/06/2018 15:18, Adrian Klaver ha scritto: I am at a loss now. The only thing I can think of is that data itself is actually corrupted. Maybe some

Re: Database name with semicolon

On 06/27/2018 06:22 AM, Joby John wrote: Hi, We have a windows application which communicate to Postgres database via PostgreSQL ODBC drivers for windows. One of our customers has a database with semicolon in its name (e.g.: “db; name”) and our application is failing to establish connection

Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function

Hi, On 2018-06-27 20:35:16 +0200, Luca Ferrari wrote: > I've found this strange (to me) behavior when doing nasty things with > indexes and immutable functions: > > create table t( pk serial, t text ); > insert into t( t ) values( 'hello' ), ('world'); > create or replace function f_fake( i int

Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function

On Wed, Jun 27, 2018 at 11:35 AM, Luca Ferrari wrote: > If I then disconnect and reconnect I'm able to issue the select and > get back the results. But if I issue a reindex I got the same error > and the table "becames unreadable" for the whole session. > On 10.3 the table is never locked for the

Re: Space Stalker in SQL Output

Wow! The -A option worked perfectly! Thanks for the syntax lesson Steve and Jerry! Sue --- Susan E Hurst Principal Consultant Brookhurst Data LLC Email: susan.hu...@brookhurstdata.com Mobile: 314-486-3261 On 2018-06-27 14:38, Jerry Sievers wrote:

Re: Space Stalker in SQL Output

Susan Hurst writes: > Why would a psql statement insert a leading space into the output, > which is a single integer value? > > The leading space caused my job call to fail elsewhere in the same > shell script as the psql call. Here is the anonymized version of the > psql call to assign a value

Space Stalker in SQL Output

Why would a psql statement insert a leading space into the output, which is a single integer value? The leading space caused my job call to fail elsewhere in the same shell script as the psql call. Here is the anonymized version of the psql call to assign a value to a shell script

Re: Database name with semicolon

On Wed, Jun 27, 2018 at 10:25 AM, Pavel Stehule wrote: > Hi > > > modern Postgresql has not any problems with special chars > > I think the issue is that he cannot create a proper connection string to pass to the ODBC driver, since semi-colon is used as a delimiter for the fields.

could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function

I've found this strange (to me) behavior when doing nasty things with indexes and immutable functions: create table t( pk serial, t text ); insert into t( t ) values( 'hello' ), ('world'); create or replace function f_fake( i int ) returns text as $body$ declare v_t text; begin select t into

Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data

Il 22/06/2018 19:56, Adrian Klaver ha scritto: On 06/22/2018 09:50 AM, Moreno Andreo wrote: Il 22/06/2018 15:18, Adrian Klaver ha scritto: Are you sure that the entries where not encrypted with a different key because I can't replicate.(More comments below): (other replies below, inline)

Re: We find few queries running three times simultaneously with same parameters on postgres db

Get Outlook for Android From: amandeep singh Sent: Wednesday, 27 June, 8:42 PM Subject: Re: We find few queries running three times simultaneously with same parameters on postgres db To: pgsql-general@lists.postgresql.org, Edson Carlos Ericksson Richter Thanks Edson

Re: We find few queries running three times simultaneously with same parameters on postgres db

Thanks Edson for ur support. As I am not a developer , I will share this test case with development team. Once I get feedback from team, will share it on this mailing list. Get Outlook for Android From: Edson Carlos Ericksson Richter Sent: Wednesday, June 27, 2018

Re: EXTERNAL: Re: Database name with semicolon

Hi 2018-06-27 16:39 GMT+02:00 Joby John : > Hi Pavel, > > > > Thanks for coming back to me. > please, don't top post https://en.wikipedia.org/wiki/Posting_style#Top-posting > > The version of the Postgres server where I am trying is: 9.5.3 > 9.5 is modern Postgres. There should not be

Re: Database name with semicolon

Hi 2018-06-27 15:22 GMT+02:00 Joby John : > Hi, > > > > We have a windows application which communicate to Postgres database via > PostgreSQL ODBC drivers for windows. > > One of our customers has a database with semicolon in its name (e.g.: “db; > name”) and our application is failing to

Database name with semicolon

Hi, We have a windows application which communicate to Postgres database via PostgreSQL ODBC drivers for windows. One of our customers has a database with semicolon in its name (e.g.: "db; name") and our application is failing to establish connection to that database saying like it could not

Re: We find few queries running three times simultaneously with same parameters on postgres db

Em 26/06/2018 14:26, amandeep singh escreveu: Hi Andreas The value for $1 is same in all queries. @Edson: number of such running queries are always  3. I see. It seems a programming logic error to me. I also use JPA (Hibernate and/or EclipseLink) and I don't have such problem. But I could

Re: Example setup for Odyssey connection pooler?

On 06/27/2018 06:07 AM, Pablo Hendrickx wrote: Please reply to list also. Ccing list. Yes that's the config file. How do I start Odyssey as a service? There are some example scripts: https://github.com/yandex/odyssey/tree/master/scripts If this does not help you might want to contact the

Re: Example setup for Odyssey connection pooler?

On 06/27/2018 04:37 AM, Pablo Hendrickx wrote: Hi Postgres! The installation instructions for Odyssey are very clear and helpful, but there are no setup instructions to be found for this multithreading tool. Can someone provide a simple example setup? ?:

Re: Fwd: problem with using VBA connection string to postgresql

Hi Adrian, John Pedro answered me, problem was that i had ODBC in the beginning of connection string... Strange, but in table connector you have to have ODBC in connection string, in directly connetion you can not have... Best 2018-06-27 14:49 GMT+02:00 Adrian Klaver : > On 06/27/2018 05:27

problem with using VBA connection string to postgresql

Hi Guys, I am using code : Sub copyingSchemas() > Dim dbCon As Object > Dim rst As Object > Dim username, pass, strConnect As String > username = Environ("username") > pass = "PasswordAccess" > Set dbCon = CreateObject("ADODB.Connection") > Set rst = CreateObject("ADODB.Recordset") > '''You can

Example setup for Odyssey connection pooler?

Hi Postgres! The installation instructions for Odyssey are very clear and helpful, but there are no setup instructions to be found for this multithreading tool. Can someone provide a simple example setup? Met vriendelijke groeten, Pablo Hendrickx Open Source DBA +32 489 73 09 37

Re: Code of Conduct committee: call for volunteers

On 27/06/18 10:44, ERR ORR wrote: I am apparently late in this discussion. I COMPLETELY DISAGREE with the idea of having a CoC in Postgres. I've participated for many years in the lists and don't remember one instance of inappropriate behavior. A CoC will only contribute to decrease the

Re: Code of Conduct committee: call for volunteers

I am apparently late in this discussion. I COMPLETELY DISAGREE with the idea of having a CoC in Postgres. I've participated for many years in the lists and don't remember one instance of inappropriate behavior. A CoC will only contribute to decrease the quality of the Postgres code. How? It will

Sv: Re: Sv: Re: CTE optimization fence

På onsdag 27. juni 2018 kl. 11:44:05, skrev Adrien NAYRAT < adrien.nay...@anayrat.info >: On 06/27/2018 09:58 AM, Andreas Joseph Krogh wrote: >      > >      > but we have to settle on a way of controlling it. > >     +1 from me. > >     I am running more

Re: pg_upgrade and wraparound

Alexander Shutyaev wrote: > Is there any hope the issue with pg_upgrade can be resolved? If not, > could you give me some hints as to how can I decrease time needed > for pg_dumpall | psql? Not sure about the larger problem, but for the part about having more than 1 million large objects

Re: Sv: Re: CTE optimization fence

On 06/27/2018 09:58 AM, Andreas Joseph Krogh wrote: > > but we have to settle on a way of controlling it. +1 from me. I am running more and more into situations where people consider this a bug rather than a feature. FWIW, I think a GUC that switches between the

Re: Too many range table entries error

Thank you very much for your guidance on this. I was speaking with a friend about this, and he said something to the effect of "keep it aside and do it later" and then a solution hit me. Since we can allow this data to be stale in our case, replacing some key views in the hierarchy of views with

Sv: Re: CTE optimization fence

På onsdag 27. juni 2018 kl. 07:45:25, skrev Thomas Kellerer mailto:spam_ea...@gmx.net>>: Tom Lane schrieb am 27.06.2018 um 05:48: >> I see there was some discussion last year about removing the CTE >> optimization fence (e.g. >> http://www.postgresql-archive.org/CTE-inlining-td5958992.html) but

Re: About "Cost-based Vacuum Delay"

Ilyeop Yi wrote: > Currently, I am working with a workload that is mostly insert and update, and > its performance suffers from autovacuum. > > I've adjusted parameters such as vacuum_cost_delay and vacuum_cost_limit, but > they have no significant effect. > > So, I would like to find a way to