On 8/30/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Merlin Moncure" <[EMAIL PROTECTED]> writes: > > I noticed that enums are not available to be queried as binary through > > the protocol. > > What do you think the binary representation ought to be? Copying OIDs > seems pretty useless.
I'm on the fence on this one. I actually think this would be ok, if you mean pg_enum.oid, or the string would be fine too. I agree that binary protocol is supposed to be fast, and I can prefetch the pg_enum table to the client and do the magic there. Many other binary formats do similarly inscrutable things. One other very small observation: afaict, there appears to be no way to list enum contents in psql (although you can list the enums themselves in the type listing). Maybe this should be possible? I'm willing to take a stab at these things if Andrew is busy. merlin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
