Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake wrote: > On 09/14/2018 01:31 AM, Chris Travers wrote: > > > I apologize for the glacial slowness with which this has all been moving. >> The core team has now agreed to some revisions to the draft CoC based on >> the comments in this thread; see

Re: Code of Conduct plan

Greetings, * Adrian Klaver (adrian.kla...@aklaver.com) wrote: > On 9/14/18 1:31 AM, Chris Travers wrote: > >On Wed, Sep 12, 2018 at 10:53 PM Tom Lane >> wrote: > > > >I wrote: > > > Stephen Frost mailto:sfr...@snowman.net>> > >writes: > > >> We seem to

Re: Code of Conduct plan

On 09/14/2018 06:59 AM, Robert Eckhardt wrote: I really have to object to this addition: "This Code is meant to cover all interaction between community members, whether or not it takes place within postgresql.org infrastructure, so long as there is not another Code of

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:13 PM, Adrian Klaver wrote: > On 9/14/18 6:59 AM, Robert Eckhardt wrote: > >> On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver >> wrote: >> >>> On 9/14/18 1:31 AM, Chris Travers wrote: >>> >> > I really have to object to this addition: "This Code is meant to

Re: Code of Conduct plan

Greetings, * Joshua D. Drake (j...@commandprompt.com) wrote: > I think this is a complicated issue. On the one hand, postgresql.org has no > business telling people how to act outside of postgresql.org. Full stop. This is exactly what this CoC points out- yes, PG.Org absolutely can and should

Re: Code of Conduct plan

> > Yes, I believe so. Isn't that what "To that end, we have established this Code > of Conduct for community interaction and participation in the project’s > work and the community at large." basically says? > No? What's the "community at large"? To me that sounds like "all interactions" whether

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:55 PM, James Keener wrote: > > > Yes. They can. The people who make the majority of the contributions to >> the software can decide what happens, because without them there is no >> software. If you want to spend 20 years of your life >> > > So everyone who moderates

Re: Code of Conduct plan

On 09/14/2018 07:51 AM, Dave Page wrote: If that business is publicly bringing the project into disrepute, or harassing other community members and they approach us about it, then it becomes our business. If it's unrelated to PostgreSQL, then it's your personal business and not

Re: Code of Conduct plan

> > And if you believe strongly that a given statement you may have made is > not objectionable...you should be willing to defend it in an adjudication > investigation. So because someone doesn't like what I say in a venue 100% separate from postgres, I have to subject myself, and waste my

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 4:14 PM Dave Page wrote: > > > On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake > wrote: > >> On 09/14/2018 01:31 AM, Chris Travers wrote: >> >> >> I apologize for the glacial slowness with which this has all been moving. >>> The core team has now agreed to some

Re: Slow shutdowns sometimes on RDS Postgres

On 9/14/18 8:43 AM, Jeremy Schneider wrote: Hi Chris - this is an interesting one that we do see from time to time; seems worth responding here as actually our best understanding right now is that this is something in community code, not AWS-specific. On 9/13/18 16:10, Adrian Klaver wrote:

Re: Code of Conduct plan

On Fri, 14 Sep 2018 at 15:10, James Keener wrote: > I understand the concern, however, if you look at how attacks happen > >> it is frequently through other sites. Specifically under/poorly >> moderated sites. For specific examples, people who have issues with >> people on Quora will frequently

Re: Code of Conduct plan

On 09/14/2018 07:14 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake > wrote: On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The core team

Re: Code of Conduct plan

Greetings, (trimmed to -general, tho I don't know if it'll really help) * James Keener (j...@jimkeener.com) wrote: > > To many of us, we absolutely are a community. Remember, there are people > > here who have been around for 20+ years, of which many have become close > > friends, having started

Re: Behaviour when autovacuum is canceled

On 2018-Sep-13, Martín Fernández wrote: > By performing this changes we are going to start relying more heavily > on the autovacuum work and the concern of "lost work" caused by > autovacuum canceling itself when locking contention happen showed up. > I'm guessing that we might be over thinking

Re: Convert interval to hours

On Fri, 14 Sep 2018 11:55:18 -0400 Peter Kleiner wrote: > On Fri, Sep 14, 2018 at 11:51 AM David Gauthier > wrote: > > > > Hi: > > > > In perl/DBI, I have code that's getting me an "age" which returns > > something like... "-17 days -08:29:35". How can I convert that to > > a number of hours

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:28 PM, Adrian Klaver wrote: > On 9/14/18 7:19 AM, Dave Page wrote: > >> >> >> > >> No one is tracking anything as part of the CoC. That's nothing but a >> straw man argument. >> > > Not buying it or the below is null and void: > > "This Code is meant to cover all

Fwd: Code of Conduct plan

I didn't realize they had replied personally to me. -- Forwarded message -- From: James Keener Date: Fri, Sep 14, 2018 at 10:43 AM Subject: Re: Code of Conduct plan To: Dave Page If that business is publicly bringing the project into disrepute, or > harassing other community

Re: C++ classes as result of selection in postgresql database

пт, 14 сент. 2018 г. в 17:23, Yuriy Rusinov : > > Dear colleagues ! > > I have to calculate road graph from coordinates and save it to postgresql > database. Is it possible to construct my classes using libpqxx API and return > it to client or I need to develop these API on another layer after

Convert interval to hours

Hi: In perl/DBI, I have code that's getting me an "age" which returns something like... "-17 days -08:29:35". How can I convert that to a number of hours (as a float I would presume) ? Thanks

Re: Code of Conduct plan

> Community is people who joined it We're not a "community." We're people using email to get help with or discuss technical aspects of PostgreSQL. The types of discussions that would normally be held within a "community" would be entirely off-topic here. We should be professional to each other

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:43 PM, Joshua D. Drake wrote: > On 09/14/2018 07:36 AM, Dave Page wrote: > > > > On Fri, Sep 14, 2018 at 3:21 PM, James Keener wrote: > >> >> Now, you may say that (2) would be rejected by the committee, but I would counter that it's still a stain on me and

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 7:16 AM, Tom Lane wrote: > [ Let's try to trim this discussion to just -general, please ] > > Robert Eckhardt writes: > > On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver > > wrote: > >> On 9/14/18 1:31 AM, Chris Travers wrote: > >>> I really have to object to this

Re: Code of Conduct plan

> > I fail to see how that makes everyone here part of a community anymore > than > > I'm part of the "community" of regulars at a bar I walk into for the > first > > time. > > Does the bartender get to kick you out if you get into a fight? Or if > you're rude or inappropriate towards the

Re: Code of Conduct plan

On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The core team has now agreed to some revisions to the draft CoC based on the comments in this thread; see

C++ classes as result of selection in postgresql database

Dear colleagues ! I have to calculate road graph from coordinates and save it to postgresql database. Is it possible to construct my classes using libpqxx API and return it to client or I need to develop these API on another layer after data selection ? -- Best regards, Sincerely yours, Yuriy

Re: Code of Conduct plan

On 09/14/2018 07:36 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:21 PM, James Keener > wrote: Now, you may say that (2) would be rejected by the committee, but I would counter that it's still a stain on me and something that

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:41 PM, James Keener wrote: > > Community is people who joined it > > We're not a "community." We're people using email to get help with or > discuss technical aspects of PostgreSQL. The types of discussions that > would normally be held within a "community" would be

Re: Code of Conduct plan

Yes. They can. The people who make the majority of the contributions to the > software can decide what happens, because without them there is no > software. If you want to spend 20 years of your life > So everyone who moderates this group and that will be part of the CoC committee will have had

Re: Code of Conduct plan

On 9/14/18 7:52 AM, James Keener wrote: I fail to see how that makes everyone here part of a community anymore than I'm part of the "community" of regulars at a bar I walk into for the first time. As I said, the rules can and should apply within the list, but applying them outside the list

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:57 PM, James Keener wrote: > > >> Yes, I believe so. Isn't that what "To that end, we have established >> this Code of Conduct for community interaction and participation in the >> project’s work and the community at large." basically says? >> > > No? What's the

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 4:51 PM Dave Page wrote: > > > On Fri, Sep 14, 2018 at 3:43 PM, Joshua D. Drake > wrote: > >> On 09/14/2018 07:36 AM, Dave Page wrote: >> >> >> >> On Fri, Sep 14, 2018 at 3:21 PM, James Keener wrote: >> >>> >>> Now, you may say that (2) would be rejected by the

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:37 PM, Joshua D. Drake wrote: > On 09/14/2018 07:14 AM, Dave Page wrote: > > > > On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake > wrote: > >> On 09/14/2018 01:31 AM, Chris Travers wrote: >> >> >> I apologize for the glacial slowness with which this has all been

Re: C++ classes as result of selection in postgresql database

Thanks a lot. On Fri, Sep 14, 2018 at 6:41 PM Dmitry Igrishin wrote: > пт, 14 сент. 2018 г. в 17:23, Yuriy Rusinov : > > > > Dear colleagues ! > > > > I have to calculate road graph from coordinates and save it to > postgresql database. Is it possible to construct my classes using libpqxx > API

Re: Code of Conduct plan

I understand the concern, however, if you look at how attacks happen > it is frequently through other sites. Specifically under/poorly > moderated sites. For specific examples, people who have issues with > people on Quora will frequently go after them on Facebook and Twitter. > > these aren't a

Re: Code of Conduct plan

On 9/14/18 7:19 AM, Dave Page wrote: No one is tracking anything as part of the CoC. That's nothing but a straw man argument. Not buying it or the below is null and void: "This Code is meant to cover all interaction between community members, whether or not it takes place within

Re: Code of Conduct plan

> On 14. Sep 2018, at 16:17, Dave Page wrote: > > > The lists are just one of many different ways people in this community > interact. I could only heavily +1 this. I can get from where comes the idea that community is only what happens just on postgresql.org or just on some other channel

Re: Code of Conduct plan

On 9/14/18 6:59 AM, Robert Eckhardt wrote: On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver wrote: On 9/14/18 1:31 AM, Chris Travers wrote: I really have to object to this addition: "This Code is meant to cover all interaction between community members, whether or not it takes place within

Re: Code of Conduct plan

> Now, you may say that (2) would be rejected by the committee, but I would >> counter that it's still a stain on me and something that will forever >> appear >> along side my name in search results and that the amount of time and >> stress it'd take me to defend myself would make my voluntarily

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:21 PM, James Keener wrote: > > Now, you may say that (2) would be rejected by the committee, but I would >>> counter that it's still a stain on me and something that will forever >>> appear >>> along side my name in search results and that the amount of time and >>>

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 4:16 PM Tom Lane wrote: > [ Let's try to trim this discussion to just -general, please ] > > Robert Eckhardt writes: > > On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver > > wrote: > >> On 9/14/18 1:31 AM, Chris Travers wrote: > >>> I really have to object to this

Re: Code of Conduct plan

> To many of us, we absolutely are a community. Remember, there are people > here who have been around for 20+ years, of which many have become close > friends, having started working on PostgreSQL as a hobby. We have always > seen the project as a community of like-minded technologists, and

Re: Code of Conduct plan

[ Let's try to trim this discussion to just -general, please ] Robert Eckhardt writes: > On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver > wrote: >> On 9/14/18 1:31 AM, Chris Travers wrote: >>> I really have to object to this addition: "This Code is meant to cover all interaction between

Re: Convert interval to hours

On Fri, Sep 14, 2018 at 11:51 AM David Gauthier wrote: > > Hi: > > In perl/DBI, I have code that's getting me an "age" which returns something > like... "-17 days -08:29:35". How can I convert that to a number of hours > (as a float I would presume) ? > > Thanks > > > > I've done this as

Re: Code of Conduct plan

> On 14. Sep 2018, at 16:31, Ilya Kosmodemiansky wrote: > > > > > I could only heavily +1 this. I can get I can’t get of course, sorry for typo > from where comes the idea that community is only what happens just on > postgresql.org or just on some other channel community uses. > .

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 3:10 PM, James Keener wrote: > I understand the concern, however, if you look at how attacks happen > >> it is frequently through other sites. Specifically under/poorly >> moderated sites. For specific examples, people who have issues with >> people on Quora will

Re: Code of Conduct plan

On 09/14/2018 09:42 AM, Dave Page wrote: > There are some fuzzy edges I guess (e.g. Slack), but in my mind it's always > been anyone who participates in any of the projects communications channels. Then you Sir are an evil ter'rist member of isis because your spoken words are carried by the same

Re: Code of Conduct plan

I hesitate to exacerbate what is a society-wide debate that is being worked out across organizations across the spectrum, but if I may provide a thought for consideration. The framing and language of the Code of Conduct, as written and proposed, includes a large number of checkpoints to protect

Re: Code of Conduct plan

On 09/14/2018 12:14 PM, Peter Geoghegan wrote: > No CoC can possibly provide for every conceivable situation. Somebody > has to interpret the rules, and it has to be possible to impose > sanctions when the CoC is violated -- otherwise, what's the point? > There are several checks and balances in

Re: Behaviour when autovacuum is canceled

Alvaro, Thanks for the insight, was really helpful! Best, Martín On Fri, Sep 14th, 2018 at 12:41 PM, Alvaro Herrera wrote: > > > > On 2018-Sep-13, Martín Fernández wrote: > > > By performing this changes we are going to start relying more heavily > > on the autovacuum work and the

Query act different when doing by hand and by using a driver in app

Hello, Not sure that this is the right mailing list, so sorry from advance. I have a program that when it does a query I have one raw returns, but when I execute the same query with the same conditions, I get the right number of rows back. I'm using gonlang and https://github.com/jackc/pgx .

Re: Convert interval to hours

On Fri, 14 Sep 2018 12:21:14 -0400 David Gauthier wrote: > I'm using postgres v9.5.2 on RH6. PG can convert the times for you. For times (not timestamps) you are always better off dealing with either time or integer seconds. There are a variety of issues with rouding that affect repeatability

Bitmap Heap Scan and Bitmap Index Scan

Here is a explain plan of a very simple query: aruprakshit=# explain analyze select first_name, last_name from users where lower(state) = 'colorado'; QUERY PLAN

Re: Slow shutdowns sometimes on RDS Postgres

> On Sep 14, 2018, at 08:43, Jeremy Schneider wrote: > So yeah, it's not common... In our experience, it's actually quite common that an RDS shutdown (or even just applying parameter changes) can take a while. What's particularly concerning is that it's not predictable, and that can make it

Re: Code of Conduct plan

Greetings, * James Keener (j...@jimkeener.com) wrote: > > > I fail to see how that makes everyone here part of a community anymore > > than > > > I'm part of the "community" of regulars at a bar I walk into for the > > first > > > time. > > > > Does the bartender get to kick you out if you get

Re: Convert interval to hours

On 09/14/2018 11:10 AM, Steven Lembark wrote: On Fri, 14 Sep 2018 11:55:18 -0400 Peter Kleiner wrote: On Fri, Sep 14, 2018 at 11:51 AM David Gauthier wrote: Hi: In perl/DBI, I have code that's getting me an "age" which returns something like... "-17 days -08:29:35". How can I convert that

Re: Code of Conduct plan

On 9/14/18, 12:50 PM, "Joshua D. Drake" wrote: On 09/14/2018 07:41 AM, James Keener wrote: > > Community is people who joined it > > We're not a "community." I do not think you are going to get very many people on board with that argument. As anyone who knows me

Re: Code of Conduct plan

On 09/14/2018 01:17 PM, Chris Travers wrote: > And frankly I am probably being paranoid here though I find paranoia is a > good thing when it comes to care of databases and computer systems. But I > do worry about the interactions between the PostgreSQL community and the > larger world with

Re: Convert interval to hours

On Fri, Sep 14, 2018 at 2:42 PM Steven Lembark wrote: > > On Fri, 14 Sep 2018 12:21:14 -0400 > David Gauthier wrote: > > > I'm using postgres v9.5.2 on RH6. > > PG can convert the times for you. > For times (not timestamps) you are always better off dealing with > either time or integer seconds.

Re: Code of Conduct plan

Robert Haas writes: > It's not clear to me that there IS a general consensus here. It looks > to me like the unelected core team got together and decided to impose > a vaguely-worded code of conduct on a vaguely-defined group of people > covering not only their work on PostgreSQL but also their

Re: Code of Conduct plan

On 09/14/2018 07:41 AM, James Keener wrote: > Community is people who joined it We're not a "community." I do not think you are going to get very many people on board with that argument. As anyone who knows me will attest I am one of the most contrarian members of this community but I still

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 11:06 AM, Dimitri Maziuk wrote: > Personally I would like that. Others might prefer an invitation to > unsubscribe or forever hold their peace, I could live with that too, but > I believe explicit opt-ins are preferable to opt-outs. I think that it's a legitimate position

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 7:19 AM, Joshua D. Drake wrote: > Sure and that is unfortunate but isn't it up to the individual to deal with > it through appropriate channels for whatever platform they are on? All of > these platforms are: > > 1. Voluntary to use > 2. Have their own Terms of Use and

Re: Code of Conduct plan

Greetings, * Dimitri Maziuk (dmaz...@bmrb.wisc.edu) wrote: > On 09/14/2018 12:46 PM, Peter Geoghegan wrote: > > On Fri, Sep 14, 2018 at 10:31 AM, Dimitri Maziuk > > wrote: > >> So let me get this straight: you want to have a "sanctioned" way to deny > >> people access to postgresql community

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 10:31 AM, Dimitri Maziuk wrote: > So let me get this straight: you want to have a "sanctioned" way to deny > people access to postgresql community support channel? Yes. > "Because > somebody who may or may not be the same person, allegedly said something > somewhere that

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 11:10 AM, Dave Page wrote: > That wording has been in the published draft for 18 months, and noone > objected to it that I'm aware of. There will always be people who don't like > some of the wording, much as there are often people who disagree with the > way a patch to

commit timestamps and replication

Hi, we're discussing a system design and it boils down to a question regarding commit timestamps (in the sense of [1], track_commit_timestamp='on'): We have a insert-only (append-only) table. Do commit timestamps on this table constitute the same order in which records become visible on a

Re: Code of Conduct plan

On Fri, 14 Sep 2018, 15:55 James Keener, wrote: > > > Yes. They can. The people who make the majority of the contributions to >> the software can decide what happens, because without them there is no >> software. If you want to spend 20 years of your life >> > > So everyone who moderates this

Re: Code of Conduct plan

While agreeing that there are good arguments that we are a "community" in a prescriptive sense, I don't think the discussion about whether we constitute a community is relevant. For at least 25 years "community" has been applied to virtually any group of people, much to the chagrin of those such

Re: Code of Conduct plan

On 09/14/2018 12:46 PM, Peter Geoghegan wrote: > On Fri, Sep 14, 2018 at 10:31 AM, Dimitri Maziuk > wrote: >> So let me get this straight: you want to have a "sanctioned" way to deny >> people access to postgresql community support channel? > > Yes. A question to TPTBs, then: once The Great

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 7:47 PM Peter Geoghegan wrote: > On Fri, Sep 14, 2018 at 10:31 AM, Dimitri Maziuk > wrote: > > So let me get this straight: you want to have a "sanctioned" way to deny > > people access to postgresql community support channel? > > Yes. > > > "Because > > somebody who may

Re: commit timestamps and replication

Hi, On 2018-09-14 21:01:54 +0200, Andreas Brandl wrote: > we're discussing a system design and it boils down to a question > regarding commit timestamps (in the sense of [1], > track_commit_timestamp='on'): > > We have a insert-only (append-only) table. Do commit timestamps on > this table

Re: column information from view

"Sebastian P. Luque" writes: > Tom Lane wrote: >> Personally, I'd probably write it something like this: >> select pa.attnum, pa.attname, col_description(pa.attrelid, pa.attnum) >> from pg_attribute pa, pg_attribute ta where pa.attrelid = >> 'persistent_view'::regclass and ta.attrelid = >>

Vacuum not deleting tuples when lockless

Hello, We are experiencing some `vacuum` issues with a given table (potentially more). When a manual vacuum runs on the given table it seems that the `vacuum` process is not doing the expected cleanup. ``` DETAIL:  113257 dead row versions cannot be removed yet. ``` I've been investigating

Re: column information from view

On 9/14/18 3:17 PM, Sebastian P. Luque wrote: On Fri, 14 Sep 2018 14:47:07 -0700, Adrian Klaver wrote: SELECT cols.ordinal_position, cols.column_name, col_description(cl.oid, cols.ordinal_position::INT) FROM pg_class cl, information_schema.columns cols WHERE

Re: Vacuum not deleting tuples when lockless

Martín Fernández writes: > * > Hello, > > We are experiencing some `vacuum` issues with a given table > (potentially more). When a manual vacuum runs on the given table it > seems that the `vacuum` process is not doing the expected cleanup. > > ``` > DETAIL:  113257 dead row versions cannot be

Re: Code of Conduct plan

On Fri, 14 Sep 2018 13:18:12 + Martin Mueller wrote: > I have followed this list for a couple of years, have benefited > several times from quick and helpful advice, and wonder whether all > this code of conduct stuff is a solution in search of a problem. No, it's not. Talk to anyone

column information from view

Hello, I'm trying to generate a table with information on columns from a temporary view that simply selects a subset of columns from a persistent view in a given schema. The persistent view joins a number of tables with columns that may or may not have a description entered. I need a table with

Re: Slow shutdowns sometimes on RDS Postgres

On 9/14/18 12:11 PM, Jeremy Schneider wrote: On 9/14/18 10:04, Christophe Pettus wrote: Thanks Christophe - even if it's not what Chris is running into, this is is another good call-out. It's important to distinguish here between the RDS parts and the community PostgreSQL parts.  I think

Re: column information from view

On Fri, 14 Sep 2018 17:52:28 -0400, Tom Lane wrote: > Umm ... why are you doing cols.table_name = 'persistent_view' and not > cols.table_name = 'temporary_view' ? I should have pointed out that the column descriptions are all NULL in the temporary view, and I'd like to pull them from the

Re: Code of Conduct plan

The preceding's pretty simple. An attacker goes after an individual, > presumably without provocation and/or asymetrically. The attacked > person is on this mailing list. IMHO this attacker must choose between > continuing his attacks, and belonging to the Postgres community. > > What's tougher is

Re: column information from view

On Fri, 14 Sep 2018 14:47:07 -0700, Adrian Klaver wrote: > SELECT cols.ordinal_position, cols.column_name, > col_description(cl.oid, cols.ordinal_position::INT) > FROM pg_class cl, information_schema.columns cols > WHERE cols.table_catalog='aquaculture' AND cols.table_schema ilike > 'pg_temp%'

Re: column information from view

On Fri, 14 Sep 2018 18:29:27 -0400, Tom Lane wrote: > "Sebastian P. Luque" writes: >> Tom Lane wrote: >>> Personally, I'd probably write it something like this: >>> select pa.attnum, pa.attname, col_description(pa.attrelid, >>> pa.attnum) from pg_attribute pa, pg_attribute ta where

Re: Query act different when doing by hand and by using a driver in app

On 9/14/18 12:11 PM, ik wrote: Hello, Not sure that this is the right mailing list, so sorry from advance. I have a program that when it does a query I have one raw returns, but when I execute the same query with the same conditions, I get the right number of rows back. The above is going

Re: Slow shutdowns sometimes on RDS Postgres

Hey Jeremy, Thanks so much for your response. That's a great tip regarding enabling enhanced monitoring. Maybe it will give some insight into which particular backends are causing the shutdown to hang. One interesting data point when this happened is that in cloudwatch, once the database

Re: Code of Conduct plan

On Fri, 14 Sep 2018 10:10:38 -0400 James Keener wrote: > > I understand the concern, however, if you look at how attacks happen > > > > it is frequently through other sites. Specifically under/poorly > > moderated sites. For specific examples, people who have issues with > > people on Quora will

Re: Vacuum not deleting tuples when lockless

=?UTF-8?q?Mart=C3=ADn_Fern=C3=A1ndez?= writes: > We are experiencing some `vacuum` issues with a given table (potentially > more). When a manual vacuum runs on the given table it seems that the > `vacuum` process is not doing the expected cleanup. > DETAIL:  113257 dead row versions cannot be

Re: Vacuum not deleting tuples when lockless

Tom Lane writes: > =?UTF-8?q?Mart=C3=ADn_Fern=C3=A1ndez?= writes: > >> We are experiencing some `vacuum` issues with a given table >> (potentially more). When a manual vacuum runs on the given table it >> seems that the `vacuum` process is not doing the expected cleanup. > >> DETAIL:  113257

Re: column information from view

On 9/14/18 2:35 PM, Sebastian P. Luque wrote: Hello, I'm trying to generate a table with information on columns from a temporary view that simply selects a subset of columns from a persistent view in a given schema. The persistent view joins a number of tables with columns that may or may not

Re: column information from view

"Sebastian P. Luque" writes: > Here's my attempt at listing the temporary view's columns and respective > descriptions: > SELECT cols.ordinal_position, cols.column_name, > col_description(cl.oid, cols.ordinal_position::INT) > FROM pg_class cl, information_schema.columns cols > WHERE

Re: Code of Conduct plan

On Fri, 14 Sep 2018 07:19:59 -0700 "Joshua D. Drake" wrote: > I agree that within Postgresql.org we must have a professional code > of conduct but the idea that an arbitrary committee appointed by an > unelected board can decide the fate of a community member based on > actions outside of the

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 10:38:56AM +0200, Chris Travers wrote: > > I really have to object to this addition: > > "This Code is meant to cover all interaction between community members, > > whether or not it takes place within postgresql.org infrastructure, so > > long as there is not another Code

Re: Code of Conduct plan

On Wed, Sep 12, 2018 at 10:53 PM Tom Lane wrote: > I wrote: > > Stephen Frost writes: > >> We seem to be a bit past that timeline... Do we have any update on when > >> this will be moving forward? > >> Or did I miss something? > > > Nope, you didn't. Folks have been on holiday which made it

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 10:31 AM Chris Travers wrote: > > > On Wed, Sep 12, 2018 at 10:53 PM Tom Lane wrote: > >> I wrote: >> > Stephen Frost writes: >> >> We seem to be a bit past that timeline... Do we have any update on >> when >> >> this will be moving forward? >> >> Or did I miss

Re: Code of Conduct plan

I find a lot of neo-con/trumpian political stances moronic, short-sighted, and anti-intellectual and therefore consider them offensive, an affront on my way of life, and a stain on my country. 1) Can I report anyone holding such views and discussing them on a 3rd party forum? 2) Could I be

Re: Can I add Index to make a query faster which involves joins on unnest ?

Hello Rob, So how do I improve this query speed? Thanks, Arup Rakshit a...@zeit.io > On 14-Sep-2018, at 12:27 AM, Rob Sargent wrote: > > > >> On Sep 13, 2018, at 12:17 PM, Arup Rakshit > > wrote: >> >> The below query basically gives the result by maintaining the

Re: Code of Conduct plan

Please take me off this list. > On Sep 14, 2018, at 05:31, Chris Travers wrote: > > > > On Wed, Sep 12, 2018 at 10:53 PM Tom Lane > wrote: > I wrote: > > Stephen Frost mailto:sfr...@snowman.net>> writes: > >> We seem to be a bit past that timeline... Do we have

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 11:45 AM Ilya Kosmodemiansky wrote: > On Fri, Sep 14, 2018 at 10:31 AM, Chris Travers > wrote: > > I really have to object to this addition: > > "This Code is meant to cover all interaction between community members, > > whether or not it takes place within

Re: Code of Conduct plan

On Fri, Sep 14, 2018 at 10:31 AM, Chris Travers wrote: > I really have to object to this addition: > "This Code is meant to cover all interaction between community members, > whether or not it takes place within postgresql.org infrastructure, so long > as there is not another Code of Conduct that

Re: Code of Conduct plan

I have followed this list for a couple of years, have benefited several times from quick and helpful advice, and wonder whether all this code of conduct stuff is a solution in search of a problem. Or, if there is a problem now and then, whether an elaborate code does a better job than

  1   2   >