Re: BUG #8435: PGAdmin backup: obect list missing objects

marta(dot)mihoff(at)dal(dot)ca writes:
> Using the backup option (right click on an object) and then selecting the
> Objects tab: Not all objects appears in the list. This is true for versions
> 1.14.3 and the most recent version 1.16.1 downloaded today. I have a
> database called otn with over 100 schema. I wish to back up several tables
> from one schema, but that schema called "pgs" does not appear in the list of
> schema. When I change the name of the schema to "psg" then it does appear.

You should probably report this on the pgadmin mailing list, I'm not sure
how many of those folk read the core-server bug list.

I would expect PGAdmin to hide schemas beginning with "pg_", since those
are reserved as system schema names. It sounds like someone got the test
wrong and is checking for just "pg" not "pg_". I'm suspicious there's a
LIKE test coded as LIKE 'pg_%', which is wrong because "_" is a
metacharacter in LIKE patterns ...

regards, tom lane