Re: Two things bit baffling in RDS PG

2018-05-03 Thread David G. Johnston
On Thu, May 3, 2018 at 1:18 PM, Ravi Krishna wrote: > I am playing around with RDS PG and I am not able to understand the > following: > > 1. The database name I created via RDS console is in upper case with no > quotes. From the remote machine via psql, > if I try to use lower case db name

Two things bit baffling in RDS PG

2018-05-03 Thread Ravi Krishna
I am playing around with RDS PG and I am not able to understand the following: 1. The database name I created via RDS console is in upper case with no quotes. From the remote machine via psql, if I try to use lower case db name with the -d option it errors out "database not found". Works

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Justin Pryzby
On Thu, May 03, 2018 at 11:15:19AM -0700, Adrian Klaver wrote: > On 05/03/2018 10:38 AM, Justin Pryzby wrote: > >On Thu, May 03, 2018 at 09:31:12AM -0700, Adrian Klaver wrote: > >>On 05/03/2018 09:20 AM, Alvaro Herrera wrote: > https://www.postgresql.org/docs/10/static/sql-createtable.html > >>

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Adrian Klaver
On 05/03/2018 10:38 AM, Justin Pryzby wrote: On Thu, May 03, 2018 at 09:31:12AM -0700, Adrian Klaver wrote: On 05/03/2018 09:20 AM, Alvaro Herrera wrote: https://www.postgresql.org/docs/10/static/sql-createtable.html "A partitioned table is divided into sub-tables (called partitions), which ar

Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

2018-05-03 Thread Adrian Klaver
On 05/03/2018 09:47 AM, George Neuner wrote: On Wed, 2 May 2018 16:01:01 -0700, Adrian Klaver wrote: On 05/02/2018 02:29 PM, Jim Michaels wrote: - the microsoft patented CSV would be required for implementation. it handles special data with commas and double-quotes in them Huh?: https://e

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Justin Pryzby
On Thu, May 03, 2018 at 09:31:12AM -0700, Adrian Klaver wrote: > On 05/03/2018 09:20 AM, Alvaro Herrera wrote: > >>https://www.postgresql.org/docs/10/static/sql-createtable.html > >> > >>"A partitioned table is divided into sub-tables (called partitions), which > >>are created using separate CREATE

Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN

2018-05-03 Thread George Neuner
On Wed, 2 May 2018 16:01:01 -0700, Adrian Klaver wrote: >On 05/02/2018 02:29 PM, Jim Michaels wrote: > >> >> - the microsoft patented CSV would be required for implementation. it >> handles special data with commas and double-quotes in them > >Huh?: >https://en.wikipedia.org/wiki/Comma-separated

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Adrian Klaver
On 05/03/2018 09:20 AM, Alvaro Herrera wrote: Adrian Klaver wrote: and from here: https://www.postgresql.org/docs/10/static/sql-createtable.html "A partitioned table is divided into sub-tables (called partitions), which are created using separate CREATE TABLE commands. The partitioned table i

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Alvaro Herrera
Adrian Klaver wrote: > and from here: > > https://www.postgresql.org/docs/10/static/sql-createtable.html > > "A partitioned table is divided into sub-tables (called partitions), which > are created using separate CREATE TABLE commands. The partitioned table is > itself empty. A data row inserted

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Adrian Klaver
On 05/03/2018 08:45 AM, Justin Pryzby wrote: On Thu, May 03, 2018 at 07:44:24AM -0700, Adrian Klaver wrote: On 05/03/2018 07:14 AM, Justin Pryzby wrote: I (finally) realized that my script for ANALYZEing parents of table hierarchies every month or so was looping around the same parent tables ev

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Justin Pryzby
On Thu, May 03, 2018 at 07:44:24AM -0700, Adrian Klaver wrote: > On 05/03/2018 07:14 AM, Justin Pryzby wrote: > >I (finally) realized that my script for ANALYZEing parents of table > >hierarchies > >every month or so was looping around the same parent tables every night due > >to > >no stats for

Re: relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Adrian Klaver
On 05/03/2018 07:14 AM, Justin Pryzby wrote: I (finally) realized that my script for ANALYZEing parents of table hierarchies every month or so was looping around the same parent tables every night due to no stats for date of last last analysis. Would help to see the script. I guess that's de

relkind='p' has no pg_stat_user_tables

2018-05-03 Thread Justin Pryzby
I (finally) realized that my script for ANALYZEing parents of table hierarchies every month or so was looping around the same parent tables every night due to no stats for date of last last analysis. I guess that's deliberate/known and maybe related to relkind='p' having no relfilenode. Is there

Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb

2018-05-03 Thread Fabio Pardi
oh! I was late! well..you have one extra link now! :) On 03/05/18 11:00, Fabio Pardi wrote: > Hi Craig, > > > are those good? > > > http://mirror1.net.one.com/postgres/pool/main/p/postgresql-9.6/postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb > > http://atalia.postgresql.org/morgue/p/postgresq

Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb

2018-05-03 Thread Fabio Pardi
Hi Craig, are those good? http://mirror1.net.one.com/postgres/pool/main/p/postgresql-9.6/postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb http://atalia.postgresql.org/morgue/p/postgresql-9.6/postgresql-9.6-dbg_9.6.5-1.pgdg80%2b1_amd64.deb regards, fabio pardi On 03/05/18 10:23, Craig Ringer

Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb

2018-05-03 Thread Craig Ringer
On 3 May 2018 at 16:46, Karsten Hilbert wrote: > On Thu, May 03, 2018 at 04:23:14PM +0800, Craig Ringer wrote: > >> I'm trying to debug a PostgreSQL install with a very hard to reproduce >> bug. The user did not install debug info, and apt.postgresql.org has >> purged the packages. 2ndQuadrant doe

Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb

2018-05-03 Thread Karsten Hilbert
On Thu, May 03, 2018 at 04:23:14PM +0800, Craig Ringer wrote: > I'm trying to debug a PostgreSQL install with a very hard to reproduce > bug. The user did not install debug info, and apt.postgresql.org has > purged the packages. 2ndQuadrant doesn't yet have a mirror of all > historical packages up

Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb

2018-05-03 Thread Craig Ringer
Hi all I'm trying to debug a PostgreSQL install with a very hard to reproduce bug. The user did not install debug info, and apt.postgresql.org has purged the packages. 2ndQuadrant doesn't yet have a mirror of all historical packages up and running (though we're working on it). So I need postgresq