Thank you for your reply.
sed is a solution for making substitutions on plain text. But if we work
with directory mode to use parallelism, I don't see how to proceed to make
a schema remap. Editing the toc file in text mode does not work neither.
Regards,
Fabrice
On Mon, Aug 8, 2022 at 9:27 PM M
hey Karthick, if you've made triple sure that it's not a permissions issue,
take a look at some of the suggestions in this old thread:
https://dba.stackexchange.com/questions/17546/why-is-pg-dumpall-throwing-an-oid-does-not-exist-error
On Mon, Aug 8, 2022 at 5:30 AM Techsupport wrote:
> *Hi to a
>
> People have asked for such a thing before, but it'd be quite difficult
> to do reliably --- particularly inside function bodies, which aren't
> normally parsed at all during a dump/restore. If you're willing to
> accept a 95% solution, running the pg_restore output through "sed"
> would likely
Guillaume Lelarge writes:
> Le lun. 8 août 2022 à 18:28, Fabrice Chapuis a
>> Is a development in progress to add this option
> Nope, never heard of someone working on this.
People have asked for such a thing before, but it'd be quite difficult
to do reliably --- particularly inside function bo
Hi,
Le lun. 8 août 2022 à 18:28, Fabrice Chapuis a
écrit :
> Hello,
> I can't find an option with pg_restore to rename an exported schema
> schema1 -> schema2
>
That's because it doesn't exist :)
> Is a development in progress to add this option
>
>
Nope, never heard of someone working on thi
Hello,
I can't find an option with pg_restore to rename an exported schema
schema1 -> schema2
Is a development in progress to add this option
Regards,
Fabrice
Hi to all,
We are using PostgreSQL 12.3 and it is running under Windows environment. In
my server multiple databases are available.
When we try to Back up one of the database, it gives the following error
message, we can able to connect and read & write to the database.
But unable to back up th
Hello,
On Mon, 2022-08-08 at 15:52 +0800, Wind wrote:
> hi~
> I test "tablesample" feature on pg9.5 and found that tablesample
> doesnt support to be applied to subquery.
> for example this sql doesnt work on pg9.5:
> ```
> create table t1(
> c1 int,
> c2 int
> );
> select c2 from (select
hi~
I test "tablesample" feature on pg9.5 and found that tablesample doesnt support
to be applied to subquery.
for example this sql doesnt work on pg9.5:
```
create table t1(
c1 int,
c2 int
);
select c2 from (select * from t1) as t2 tablesample system (50);
```
while i read sql2003 standar
