Temporary table geography columns appear in other's sessions
|Reported by:||Mike Taves||Owned by:||pramsey|
If you have multiple sessions, and from only one:
create temp table foo(id serial primary key, geog geography(Point, 4326));
Now all sessions "see" the column in geography_columns, even though it is not "their" temporary table. Other sessions can also create the same temporary table concurrently, but are distinguished by different f_table_schema values (pg_temp_3, pg_temp_4, etc.).