Joseph S <jks@xxxxxxxxxxxxxxx> writes:
> David Fetter wrote:
>> - Arrange to put TOAST tables belonging to temporary tables into
>> special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn
> Does this apply to indexes on temp tables as well? Or is this not even
> an issue with indexes?
Indexes always live in the same schema as their parent table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
