Postgres Pro
Downloads
Home   >   mailing lists

Re: The output sql generated by pg_dump for a create function refers to a modified table name - Mailing list pgsql-hackers

From Tom Lane
Subject Re: The output sql generated by pg_dump for a create function refers to a modified table name
Date
Msg-id 2539470.1676646575@sss.pgh.pa.us
Whole thread Raw
In response to Re: The output sql generated by pg_dump for a create function refers to a modified table name  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Responses Re: The output sql generated by pg_dump for a create function refers to a modified table name
List pgsql-hackers
Tree view 
"Jonathan S. Katz" <jkatz@postgresql.org> writes:
> Good catch. Do you have thoughts on how we can adjust the naming logic 
> to handle cases like this?

I think it's perfectly fine that ruleutils decided to use different
aliases for the two different occurrences of "t1": the statement is
quite confusing as written.  The problem probably is that
get_delete_query_def() has no idea that it's supposed to print the
adjusted alias just after "DELETE FROM tab".  UPDATE likely has same
issue ... maybe INSERT too?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: DDL result is lost by CREATE DATABASE with WAL_LOG strategy
Next
From: Julien Rouhaud
Date:
Subject: Re: pg_upgrade and logical replication