Home > mailing lists

Mailing lists [pgsql-novice]

1 November 2017

01:01 [NOVICE] How to list partitions of a table in PostgreSQL 10 Stephen Froehlich
01:59 Re: [NOVICE] How to list partitions of a table in PostgreSQL 10 Stephen Froehlich
02:10 Re: [NOVICE] How to list partitions of a table in PostgreSQL 10 Thomas Kellerer

5 November 2017

00:35 [NOVICE] Old solutions for listing tables by tablespace broken in PG 10 forpartitions. Stephen Froehlich
00:41 [NOVICE] Re: Old solutions for listing tables by tablespace broken in PG 10for partitions. Stephen Froehlich

8 November 2017

01:42 [NOVICE] Using set role inside a function question Garry Chen
01:57 Re: [NOVICE] Using set role inside a function question Vianello, Daniel A

9 November 2017

08:20 [NOVICE] what does t(x) in select x from generate_series(1, 10) as t(x) stand for? john snow
08:55 Re: [NOVICE] what does t(x) in select x from generate_series(1, 10)as t(x) stand for? David G. Johnston
09:56 Re: [NOVICE] what does t(x) in select x from generate_series(1, 10) as t(x) stand for? Tom Lane

13 November 2017

01:19 [NOVICE] varchar vs varchar(n) john snow
01:34 Re: [NOVICE] varchar vs varchar(n) Tom Lane
03:53 Re: [NOVICE] varchar vs varchar(n) john snow
21:09 Re: [NOVICE] array_agg cast issue pinker
21:18 Re: [NOVICE] array_agg cast issue Tom Lane
21:27 Re: [NOVICE] varchar vs varchar(n) Ken Benson
21:27 Re: [NOVICE] array_agg cast issue pinker
21:34 Re: [NOVICE] array_agg cast issue Tom Lane
21:39 Re: [NOVICE] varchar vs varchar(n) Tom Lane
21:40 Re: [NOVICE] array_agg cast issue pinker
21:59 Re: [NOVICE] array_agg cast issue Tom Lane
22:35 Re: [NOVICE] array_agg cast issue pinker

14 November 2017

21:45 [NOVICE] Strange problem with autovacuum Efraín Déctor
22:15 Re: [NOVICE] Strange problem with autovacuum Stephen Froehlich
22:40 Re: [NOVICE] Strange problem with autovacuum Efraín Déctor
22:49 Re: [NOVICE] Strange problem with autovacuum David G. Johnston
23:04 [NOVICE] Please advice on a query JORGE MALDONADO
23:11 Re: [NOVICE] Strange problem with autovacuum Efraín Déctor
23:19 Re: [NOVICE] Please advice on a query Efraín Déctor

15 November 2017

00:10 Re: [NOVICE] Strange problem with autovacuum Peter Geoghegan
01:00 Re: [NOVICE] Strange problem with autovacuum Efraín Déctor
02:11 Re: [NOVICE] Please advice on a query Lutz Horn

16 November 2017

01:14 [NOVICE] How to get n records from parent table and their children JORGE MALDONADO
01:51 Re: [NOVICE] How to get n records from parent table and theirchildren Lutz Horn
09:53 [NOVICE] group by rollup and cube john snow
13:21 Re: [NOVICE] How to get n records from parent table and theirchildren Laurenz Albe
13:27 Re: [NOVICE] group by rollup and cube Laurenz Albe

18 November 2017

04:52 [NOVICE] ERROR: expected one dependency record for TOAST table, found 0 Dean Montgomery

19 November 2017

02:48 [NOVICE] best practices for fixing stored procedures already in production? john snow

20 November 2017

20:33 [NOVICE] Migration to pglister - Before Stephen Frost
20:52 Migration to PGLister - After Stephen Frost

21 November 2017

02:12 Re: [NOVICE] ERROR: expected one dependency record for TOASTtable, found 0 Dean Montgomery

24 November 2017

23:08 macOS ownership and premissions Craig H

26 November 2017

17:27 Re: A particular database to move to other drive Andreas Kretschmer
17:27 Re: A particular database to move to other drive Andreas Kretschmer
17:27 Re: A particular database to move to other drive Andreas Kretschmer

27 November 2017

04:25 Novice question about users and...rights? Dale Schmitz
10:45 Re: Novice question about users and...rights? Laurenz Albe
23:15 Re: Novice question about users and...rights? Stephen Frost
23:21 Re: Novice question about users and...rights? Stephen Frost
23:49 Subscription How? Bee.Lists
23:54 Re: Subscription How? Stephen Frost

28 November 2017

00:00 Re: Novice question about users and...rights? Laurenz Albe
00:13 Re: Novice question about users and...rights? Stephen Frost