Adrian Klaver writes:
> On 10/24/19 2:58 PM, stan wrote:
>> So, it appears that this means that the function cannot be found, even if it
>> is in the new
>> (default) schema.
> The original error was not about finding the function it was about not
> finding the table in the function:
> psql:ta
On 10/24/19 2:58 PM, stan wrote:
On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote:
On 10/24/19 7:32 AM, stan wrote:
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
On 10/24/19 3:52 AM, stan wrote:
I have a very confusing isse. I am trying to backup and restre a
On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote:
> On 10/24/19 7:32 AM, stan wrote:
> > On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
> > > On 10/24/19 3:52 AM, stan wrote:
> > > >
> > > >
> > > > I have a very confusing isse. I am trying to backup and restre a si
On 10/24/19 7:32 AM, stan wrote:
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
On 10/24/19 3:52 AM, stan wrote:
I have a very confusing isse. I am trying to backup and restre a signle
table .
first I dump the table.
Actually you are just dumping the table data.
More below
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
> On 10/24/19 3:52 AM, stan wrote:
> >
> >
> > I have a very confusing isse. I am trying to backup and restre a signle
> > table .
> >
> > first I dump the table.
>
> Actually you are just dumping the table data.
>
> More below.
>
On 10/24/19 3:52 AM, stan wrote:
I have a very confusing isse. I am trying to backup and restre a signle
table .
first I dump the table.
Actually you are just dumping the table data.
More below.
Script started on 2019-10-24 06:29:12-0400
]0;stan@smokey: ~stan@smokey:~$ pg_dump -a --tab
On Thu, Oct 24, 2019 at 07:57:14AM -0500, Ron wrote:
> Why did you do "\i task_instance.dump" instead of "pg_restore"?
Ah, that may be the root of my problem. I had in the back of my mind that
the result of a pg_dump was a free standing SQL script, but that my be
exactly what is going on. I will
I have a very confusing isse. I am trying to backup and restre a signle
table .
first I dump the table.
Script started on 2019-10-24 06:29:12-0400
]0;stan@smokey: ~stan@smokey:~$ pg_dump -a --table task_instance >
task_instance.dump
Then I connect to the db, and verify that things are as