Key error when converting aggregate to YAML about pyrseas HOT 4 OPEN

I believe this is a variation of issue #175 and a symptom of #185, i.e., the problem is because currently we do not retrieve "built-in" types. This wouldn't be too difficult to do just for dbtoyaml, because we could retrieve all the catalog info and (perhaps) output to YAML any pg_catalog type that was found to be a dependency for one of the user objects. However, for yamltodb the YAML input would have to either bypass any pg_catalog types or implement a workaround (either by querying the target db before processing the YAML or having PG-derived caches, e.g., from src/include/catalog as part of the Pyrseas release).

from pyrseas.

Grégoire, if I may ask, are you using both dbtoyaml and yamltodb or just the former? If you're only using dbtoyaml, we could perhaps come up with a solution faster, i.e., by splitting the work needed for #185.

from pyrseas.

Yes after a little more research I saw #175 and guessed it was a similar problem.
Actually we are currently using a homemade cli made in php inspired by the very early versions of Pyrseas.
We are trying to let go of this custom code and switch to pyrseas. So right now schema is dumped to database using our scripts and we are trying to extract them with pyrseas. However the end goal remains to be able to use both dbtoyaml and yamltodb and fully switch to pyrseas.
I'll check with our postgres and Python experts in the team if we can find a solution for #185.

from pyrseas.

I'd like to offer some suggestions to your experts, but I think it would be best if we continue the conversation under #185, so I'll leave comments there. I'll leave this issue open for a while.

from pyrseas.