Re: pg_dump empty tables

2020-06-23 Thread Edu Gargiulo
On Tue, Jun 23, 2020 at 2:25 PM Adrian Klaver wrote: > On 6/23/20 9:44 AM, Edu Gargiulo wrote: > > > > On Tue, Jun 23, 2020 at 11:45 AM Adrian Klaver > > mailto:adrian.kla...@aklaver.com>> wrote: > > > > On 6/23/20 7:37 AM, Edu Gargiulo wrote: > > > > > > > > > On Tue, Jun 23,

Re: pg_dump empty tables

2020-06-23 Thread Adrian Klaver
On 6/23/20 9:44 AM, Edu Gargiulo wrote: On Tue, Jun 23, 2020 at 11:45 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 6/23/20 7:37 AM, Edu Gargiulo wrote: > > > On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver > mailto:adrian.kla...@aklaver.com>

Re: pg_dump empty tables

2020-06-23 Thread Edu Gargiulo
On Tue, Jun 23, 2020 at 11:45 AM Adrian Klaver wrote: > On 6/23/20 7:37 AM, Edu Gargiulo wrote: > > > > > > On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver > > mailto:adrian.kla...@aklaver.com>> wrote: > > > > On 6/23/20 6:48 AM, Edu Gargiulo wrote: > > > On Tue, Jun 23, 2020 at 10:34 AM

Re: pg_dump empty tables

2020-06-23 Thread Adrian Klaver
On 6/23/20 7:37 AM, Edu Gargiulo wrote: On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 6/23/20 6:48 AM, Edu Gargiulo wrote: > On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver > mailto:adrian.kla...@aklaver.com>

Re: pg_dump empty tables

2020-06-23 Thread Edu Gargiulo
On Tue, Jun 23, 2020 at 10:56 AM Adrian Klaver wrote: > On 6/23/20 6:48 AM, Edu Gargiulo wrote: > > On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver > > mailto:adrian.kla...@aklaver.com>> wrote: > > > > On 6/23/20 6:30 AM, Edu Gargiulo wrote: > > > Hi all, > > > > > > We are usin

Re: pg_dump empty tables

2020-06-23 Thread Adrian Klaver
On 6/23/20 6:48 AM, Edu Gargiulo wrote: On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 6/23/20 6:30 AM, Edu Gargiulo wrote: > Hi all, > > We are using postgresql 11.7 on Debian. > I noticed that pg_dump is not including record

Re: pg_dump empty tables

2020-06-23 Thread Adrian Klaver
On 6/23/20 6:48 AM, Edu Gargiulo wrote: On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 6/23/20 6:30 AM, Edu Gargiulo wrote: > Hi all, > > We are using postgresql 11.7 on Debian. > I noticed that pg_dump is not including record

Re: pg_dump empty tables

2020-06-23 Thread Edu Gargiulo
On Tue, Jun 23, 2020 at 10:34 AM Adrian Klaver wrote: > On 6/23/20 6:30 AM, Edu Gargiulo wrote: > > Hi all, > > > > We are using postgresql 11.7 on Debian. > > I noticed that pg_dump is not including records on tables with fields > > defined as array type (integer[] and real[]). The table structu

Re: pg_dump empty tables

2020-06-23 Thread Adrian Klaver
On 6/23/20 6:30 AM, Edu Gargiulo wrote: Hi all, We are using postgresql 11.7 on Debian. I noticed that pg_dump is not including records on tables with fields defined as array type (integer[] and real[]). The table structure is normally restored but they have 0 records on restoring. What is t

pg_dump empty tables

2020-06-23 Thread Edu Gargiulo
Hi all, We are using postgresql 11.7 on Debian. I noticed that pg_dump is not including records on tables with fields defined as array type (integer[] and real[]). The table structure is normally restored but they have 0 records on restoring. i'm wondering if is it a normal behaviour of pg_dump a