Re: [GENERAL] Top posting....

Alvaro Herrera writes: > George Neuner wrote: >> I agree 100%. But excessive brevity can make it so a reader can't >> follow the conversation. Users of web forums often assume *you* can >> easily look back up the thread because *they* can. In my experience, >> it

Re: [GENERAL] Top posting....

George Neuner wrote: > On Thu, 11 May 2017 13:43:52 -0400, Tom Lane > wrote: > >Personally, when I've scrolled down through a couple of pages of quoted > >and re-quoted text and see no sign of it ending any time soon, I tend > >to stop reading. > > I agree 100%. But

Re: [GENERAL] psql: do/should we document that argument and option specification order doesn't matter?

On Thu, 11 May 2017 16:15:43 -0700, "David G. Johnston" wrote: >I don't know if this applies anywhere else but I just stumbled across the >fact that our psql documentation is imprecise: > >https://www.postgresql.org/docs/current/static/app-psql.html > >psql

Re: [GENERAL] Top posting....

On Thu, 11 May 2017 13:43:52 -0400, Tom Lane wrote: >... The point of quoting previous messages is not to replicate >the entire thread in each message; we have archives for that. The point >is to *briefly* remind readers what it is that you're responding to. >If you can't be

Re: [GENERAL] psql: do/should we document that argument and option specification order doesn't matter?

"David G. Johnston" writes: > I don't know if this applies anywhere else but I just stumbled across the > fact that our psql documentation is imprecise: > https://www.postgresql.org/docs/current/static/app-psql.html > psql [option...] [dbname [username]] > It does

[GENERAL] psql: do/should we document that argument and option specification order doesn't matter?

I don't know if this applies anywhere else but I just stumbled across the fact that our psql documentation is imprecise: https://www.postgresql.org/docs/current/static/app-psql.html psql [option...] [dbname [username]] It does matter that "dbname" precede username; and that it be present if

Re: [GENERAL]

On 05/11/2017 07:26 AM, Igor Korot wrote: Adrian et al, On Thu, May 11, 2017 at 9:54 AM, Adrian Klaver wrote: On 05/11/2017 06:24 AM, Igor Korot wrote: Thank you. Will take a look and modify to use in my program. I presume I'm allowed to do that, right? Yes.

Re: [GENERAL] Request to add feature to the Position function

On 05/11/2017 10:55 AM, Ron Ben wrote: any news on that? Did you ask on --hackers or file a bug report? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] pglogical and slony

Thanks to Adrian I got pointed in the direction of enabling triggers to use with pglogical In other words, whatever comes down the pglogical in terms of inserts/updates/deletes, I can track those in some audit table or do something else That got me thinking why not putting at the end of

Re: [GENERAL] Querying a policy

Stephen, Thank you for the quick reply! This information is very useful to me. Maybe some more questions will come in the future :) Thanks again and continue the good work! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Top posting....

On 12/05/17 05:04, Francisco Olarte wrote: Slightly unrelated... On Wed, May 10, 2017 at 11:21 PM, Gavin Flower wrote: It is normal on this list not to top post, but rather to add comments at the end (so people can see the context) - though interspersed comments

Re: [GENERAL]

> > Like I said, what I expect to see from the query is: > > id | integer | | 5| 2 | 0 | P | > name | varchar | 50| 2 | | | | > > So I need the information about the field and whether the field is a > primary/foreign key or not. > I had a go at it using the catalog tables from v9.5 and an

Re: [GENERAL] Constraints of view attributes

<51183...@gmx.at> writes: > create table t1 (f1 text not null); > create table t2 (f2 text); > create view v as (select t1.f1, t2.f2 from t1, t2); > Given v, How can a find out the t1.f1 has a not null constraint. I assume what you actually mean is you want to know whether the view v will

Re: [GENERAL] Constraints of view attributes

On 05/11/2017 12:24 PM, 51183...@gmx.at wrote: Hi, create table t1 (f1 text not null); create table t2 (f2 text); create view v as (select t1.f1, t2.f2 from t1, t2); Given v, How can a find out the t1.f1 has a not null constraint. I can easily find this for t1 in the system catalog, but not

[GENERAL] Constraints of view attributes

Hi, create table t1 (f1 text not null); create table t2 (f2 text); create view v as (select t1.f1, t2.f2 from t1, t2); Given v, How can a find out the t1.f1 has a not null constraint. I can easily find this for t1 in the system catalog, but not for v. I learned on IRC today that this should

Re: [GENERAL] How to recover my postgres database ?

Pierre Couderc writes: > Mmm, there is some misunderstanding. I have lost nothing. > All my DBs are ok. > I am speaking of the specific "postgres" database that you connect to with > \c postgres > What is its use ? how to restore it ? If you know that there should be nothing

Re: [GENERAL] Top posting....

Francisco Olarte writes: > Slightly unrelated... > On Wed, May 10, 2017 at 11:21 PM, Gavin Flower > wrote: >> It is normal on this list not to top post, but rather to add comments at the >> end (so people can see the context) - though

[GENERAL] File hashes for downloads

Needing to get the ODBC driver (downloading it from here https://www.postgresql.org/ftp/odbc/versions/msi/) , but I can't find any hashes to verify my download. Is there a list somewhere that I'm missing? Thank you, Evan Blackstone Oklahoma Employees Credit Union Information Security Officer

Re: [GENERAL] How to recover my postgres database ?

On 05/11/2017 07:10 PM, John R Pierce wrote: On 5/11/2017 9:53 AM, Pierre Couderc wrote: I have broken my postgres database by typing : psql How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? Thanks in advance was there

Re: [GENERAL] How to recover my postgres database ?

On 5/11/2017 9:53 AM, Pierre Couderc wrote: I have the pg_dumpall of last night, but many dbs have changed today... ? suggestion in the future, instead of simply pg_dumpall, where all your databases are in one opaque lump, try something like... #!/bin/bash # d=`date +\%a`

Re: [GENERAL] Top posting....

On Thu, May 11, 2017 at 12:04 PM, Francisco Olarte wrote: > Slightly unrelated... > > ​ > > > Full quoting ( I mean the people which even quotes others signatures ) > is especially ugly, combined with top posting I feel it as insulting ( > to me it feels as 'you do not

Re: [GENERAL] How to recover my postgres database ?

On 05/11/2017 07:07 PM, Hunley, Douglas wrote: On Thu, May 11, 2017 at 11:53 AM, Pierre Couderc > wrote: How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? If pg_dumpall is

Re: [GENERAL] How to recover my postgres database ?

On 5/11/2017 9:53 AM, Pierre Couderc wrote: I have broken my postgres database by typing : psql How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? Thanks in advance was there anything in the postgres database other than the

Re: [GENERAL] How to recover my postgres database ?

On Thu, May 11, 2017 at 11:53 AM, Pierre Couderc wrote: > How can I safely repair, knowing that I have the pg_dumpall of last > night, but many dbs have changed today... ? > If pg_dumpall is your only backup mechanism then you've lost all changes after the dump was taken.

[GENERAL] Top posting....

Slightly unrelated... On Wed, May 10, 2017 at 11:21 PM, Gavin Flower wrote: > It is normal on this list not to top post, but rather to add comments at the > end (so people can see the context) - though interspersed comments in the > body of the text is okay when

[GENERAL] How to recover my postgres database ?

I have broken my postgres database by typing : psql How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?

> On May 11, 2017, at 10:40 AM, Adrian Klaver wrote: > > On 05/11/2017 07:32 AM, Vibhor Kumar wrote: >>> On May 11, 2017, at 10:17 AM, Adrian Klaver >> >>

Re: [GENERAL] Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?

Am 11.05.2017 um 15:58 schrieb Martin Goodson: Hello. First time poster, so please be gentle :) I have a PostgreSQL 9.6 database cluster running on a standalone Redhat 7.2 (Maipo) server. This may seem like a silly question. It probably *is* a silly question, so apologies in advance.

Re: [GENERAL] Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?

On 05/11/2017 07:32 AM, Vibhor Kumar wrote: On May 11, 2017, at 10:17 AM, Adrian Klaver > wrote: Not sure how deep you are into your present situation. The only thing I can think of is to install Postgres using the PGDG repos

Re: [GENERAL] Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?

> On May 11, 2017, at 10:17 AM, Adrian Klaver wrote: > > On 05/11/2017 06:58 AM, Martin Goodson wrote: >> Hello. First time poster, so please be gentle :) >> I have a PostgreSQL 9.6 database cluster running on a standalone Redhat 7.2 >> (Maipo) server. >> This may

Re: [GENERAL]

Adrian et al, On Thu, May 11, 2017 at 9:54 AM, Adrian Klaver wrote: > On 05/11/2017 06:24 AM, Igor Korot wrote: >> >> Melvin et al, >> > >> >> Now are you saying that the information about the fields in the table can >> be retrieved from >> system catalog? Or are you

Re: [GENERAL] Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?

On 05/11/2017 06:58 AM, Martin Goodson wrote: Hello. First time poster, so please be gentle :) I have a PostgreSQL 9.6 database cluster running on a standalone Redhat 7.2 (Maipo) server. This may seem like a silly question. It probably *is* a silly question, so apologies in advance.

[GENERAL] Installing repmgr alongside PostgreSQL installed via EnterpriseDB installer instead of repositories?

Hello. First time poster, so please be gentle :) I have a PostgreSQL 9.6 database cluster running on a standalone Redhat 7.2 (Maipo) server. This may seem like a silly question. It probably *is* a silly question, so apologies in advance. PostgreSQL was installed using the "EDB Postgres

Re: [GENERAL]

On 05/11/2017 06:24 AM, Igor Korot wrote: Melvin et al, Now are you saying that the information about the fields in the table can be retrieved from system catalog? Or are you saying that retrieving everything in one shot As Melvin and others have mentioned that is where the

Re: [GENERAL]

On Thu, May 11, 2017 at 9:24 AM, Igor Korot wrote: > Melvin et al, > > On Thu, May 11, 2017 at 8:50 AM, Melvin Davidson > wrote: > >> >> On Wed, May 10, 2017 at 11:26 PM, Igor Korot wrote: >> >>> Hi, John et al, >>> >>> On Wed, May

Re: [GENERAL]

Melvin et al, On Thu, May 11, 2017 at 8:50 AM, Melvin Davidson wrote: > > On Wed, May 10, 2017 at 11:26 PM, Igor Korot wrote: > >> Hi, John et al, >> >> On Wed, May 10, 2017 at 11:02 PM, John R Pierce >> wrote: >> > On 5/10/2017

Re: [GENERAL]

On Wed, May 10, 2017 at 11:26 PM, Igor Korot wrote: > Hi, John et al, > > On Wed, May 10, 2017 at 11:02 PM, John R Pierce > wrote: > > On 5/10/2017 7:45 PM, Igor Korot wrote: > >> > >> I found > >>