Re: Postgres enum problem

Stian Sletner <[email protected]> Tue, 16 Aug 2016 15:06:26 +0200
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
Rm9sbG93aW5nIHVwIG9uIHRoaXMuCgpTbyBiYXNlZCBvbiB5b3VyIGhpbnRzIEkgdGhpbmsgSSBt
YXkgaGF2ZSBhIHNvbHV0aW9uIHN1Y2ggdGhhdDoKCihkZWZ0eXBlIG15LWtleXdvcmQgKCkgJ2tl
eXdvcmQpCihkZWZtZXRob2QgY2xzcWwtc3lzOmRhdGFiYXNlLW91dHB1dC1zcWwtYXMtdHlwZQog
ICAgICgodHlwZSAoZXFsICdteS1rZXl3b3JkKSkgKHZhbCBzeW1ib2wpIGRhdGFiYXNlIGRiLXR5
cGUpCiAgKHN0cmluZyB2YWwpKQooZGVmbWV0aG9kIGNsc3FsLXN5czpyZWFkLXNxbC12YWx1ZQog
ICAgICgodmFsIHN0cmluZykgKHR5cGUgKGVxbCAnbXkta2V5d29yZCkpIGRhdGFiYXNlIGRiLXR5
cGUpCiAgKGludGVybiB2YWwgOmtleXdvcmQpKQoKKGRlZi12aWV3LWNsYXNzIHRlc3RrdzIgKCkK
ICAoKGt3IDphY2Nlc3NvciB0ZXN0a3cyLWt3IDppbml0YXJnIDprdyA6dHlwZSBteS1rZXl3b3Jk
KSkpCihjcmVhdGUtdmlldy1mcm9tLWNsYXNzICd0ZXN0a3cyKQooZGVmcGFyYW1ldGVyICppKiAo
bWFrZS1pbnN0YW5jZSAndGVzdGt3MiA6a3cgOmhlaSkpCih1cGRhdGUtcmVjb3Jkcy1mcm9tLWlu
c3RhbmNlICppKikKCkF0IHRoaXMgcG9pbnQgSSBjYW4gZmluZCB0aGUgb2JqZWN0OgoKKHNlbGVj
dCAndGVzdGt3MiA6d2hlcmUgWz0gW2t3XSA6aGVpXSkKCkFuZCB0aGUgc3RvcmFnZSBsb29rcyBs
aWtlIEkgd2FudDoKCmZqYXM9IyBzZWxlY3QgKiBmcm9tIHRlc3RrdzI7CistLS0tLSsKfCBrdyAg
fAorLS0tLS0rCnwgSEVJIHwKKy0tLS0tKwooMSByb3cpCgpEb2VzIHRoYXQgc2VlbSBsaWtlIGEg
cmVhc29uYWJsZSBzb2x1dGlvbj8KCgpPbiAyMDE2LTA4LTE2IDEzOjMwLCBTdGlhbiBTbGV0bmVy
IHdyb3RlOgo+IEhpIFJ1c3MuCj4gCj4gVGhhbmtzIGZvciBhIHZlcnkgdGhvcm91Z2ggYW5kIGlu
Zm9ybWF0aXZlIHJlcGx5LiAgSSdtIGEgbGl0dGxlIGNvbmZ1c2VkCj4gaGVyZSwgc28gYmVhciB3
aXRoIG1lIC0tIGxlYXZpbmcgdGhlIGVudW0gaXNzdWUgYXNpZGUgZm9yIGEgbWludXRlLCBhcwo+
IGl0IHNob3VsZG4ndCBiZSBhIGh1Z2UgcHJvYmxlbSB0byBjaGFuZ2UgdG8gYSB0ZXh0IGZpZWxk
IC0tIGhvdyBhcmUKPiBrZXl3b3JkIHR5cGUgZmllbGRzIHN1cHBvc2VkIHRvIGJlIHVzZWQgYXQg
YWxsPyAgSXQgZG9lc24ndCBzZWVtCj4gcG9zc2libGUgdG8gU0VMRUNUIG9uIHRoZW0uCj4gCj4g
SWYgSSBsZWF2ZSBpdCBhbGwgdXAgdG8gQ0xTUUw6Cj4gCj4gKGRlZi12aWV3LWNsYXNzIHRlc3Rr
dyAoKQo+ICAgKChrdyA6YWNjZXNzb3IgdGVzdGt3LWt3IDppbml0YXJnIDprdyA6dHlwZSBrZXl3
b3JkKSkpCj4gKGNyZWF0ZS12aWV3LWZyb20tY2xhc3MgJ3Rlc3RrdykKPiAoZGVmcGFyYW1ldGVy
ICppKiAobWFrZS1pbnN0YW5jZSAndGVzdGt3IDprdyA6aGVpKSkKPiAodXBkYXRlLXJlY29yZHMt
ZnJvbS1pbnN0YW5jZSAqaSopCj4gCj4gVGhlbiBJIGdldCBhIHRhYmxlIGxpa2UgdGhpczoKPiAK
PiBmamFzPSMgXGQgdGVzdGt3Cj4gICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMudGVzdGt3Igo+
ICstLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rCj4gfCBDb2x1
bW4gfCAgICAgICAgICBUeXBlICAgICAgICAgIHwgTW9kaWZpZXJzIHwKPiArLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKwo+IHwga3cgICAgIHwgY2hhcmFjdGVy
IHZhcnlpbmcoMjU1KSB8ICAgICAgICAgICB8Cj4gKy0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLSstLS0tLS0tLS0tLSsKPiAKPiBmamFzPSMgc2VsZWN0ICogZnJvbSB0ZXN0a3c7Cj4g
Ky0tLS0tLSsKPiB8ICBrdyAgfAo+ICstLS0tLS0rCj4gfCA6SEVJIHwKPiArLS0tLS0tKwo+ICgx
IHJvdykKPiAKPiBXaGljaCBpcyBmaW5lLCBidXQgSSBzdGlsbCBjYW4ndCBzZWxlY3Qgb24gdGhl
IGtleXdvcmQ6Cj4gCj4gKiAoc2VsZWN0IFtrd10gOmZyb20gW3Rlc3Rrd10pCj4gOzsgMjAxNi0w
OC0xNlQxMjo0MzoyNSAvZmphcy9zdGlhbiA9PiBTRUxFQ1QgS1cgRlJPTSBURVNUS1cKPiAoKCI6
SEVJIikpCj4gKCJrdyIpCj4gCj4gKiAoc2VsZWN0IFtrd10gOmZyb20gW3Rlc3Rrd10gOndoZXJl
IFs9IFtrd10gOmhlaV0pCj4gOzsgMjAxNi0wOC0xNlQxMjo0MzozNSAvZmphcy9zdGlhbiA9PiBT
RUxFQ1QgS1cgRlJPTSBURVNUS1cgV0hFUkUgKEtXID0KPiAnSEVJJykKPiBOSUwKPiAoImt3IikK
PiAKPiBUaGlzIHdvcmtzLCBidXQgd291bGQgYmUgdmVyeSBjdW1iZXJzb21lIHRvIGFkYXB0IHRv
Ogo+IAo+IChzZWxlY3QgW2t3XSA6ZnJvbSBbdGVzdGt3XSA6d2hlcmUgWz0gW2t3XSAiOkhFSSJd
KQo+IDs7IDIwMTYtMDgtMTZUMTI6NDU6NDkgL2ZqYXMvc3RpYW4gPT4gU0VMRUNUIEtXIEZST00g
VEVTVEtXIFdIRVJFIChLVyA9Cj4gJzpIRUknKQo+ICgoIjpIRUkiKSkKPiAoImt3IikKPiAKPiBC
VFcgSSBhZ3JlZSB0aGF0IGVudW0gdHlwZXMgYXJlIHByb2JhYmx5IG5vdCB1c2VkIHVuaWZvcm1s
eSBhY3Jvc3MKPiBkaWZmZXJlbnQgZGF0YWJhc2VzLCBhbmQgaXMgcHJvYmFibHkgYmV0dGVyIGxl
ZnQgb3V0LiAgSXQgc2VlbXMgdG8gbWUKPiBub3cgdGhhdCBpdCB3YXMgbm90IHRoZSBjZW50cmFs
IHBhcnQgb2YgbXkgcHJvYmxlbSBhbnl3YXkuICBBZ2FpbiwgSSdtCj4ganVzdCBjb25mdXNlZC4K
PiAKPiBQUzogSW4gbXkgY29kZSB3YW5kZXJpbmdzIEkgY2FtZSBhY3Jvc3MgdGhlc2UgY2FzZXMg
aW4gb29kbWwubGlzcDoKPiAKPiAoZGVmbWV0aG9kIGRhdGFiYXNlLW91dHB1dC1zcWwtYXMtdHlw
ZQo+IC4uLgo+ICAgICAgKGNhc2UgdHlwZQo+ICAgICAgICAoKG9yIHN5bWJvbCBrZXl3b3JkKQo+
ICAgICAgICAgKHByaW50LXJlYWRhYmxlLXN5bWJvbCB2YWwpKQo+ICAgICAgICAoc3RyaW5nIHZh
bCkKPiAuLi4KPiAKPiAoZGVmbWV0aG9kIHJlYWQtc3FsLXZhbHVlICh2YWwgdHlwZSBkYXRhYmFz
ZSBkYi10eXBlKQo+IC4uLgo+ICAgICAgICAoY2hhciAoc3RyaW5nIChzY2hhciB2YWwgMCkpKQo+
ICAgICAgICAoKG9yIGtleXdvcmQgc3ltYm9sKQo+ICAgICAgICAgKHJlYWQtZnJvbS1zdHJpbmcg
dmFsKSkKPiAgICAgICAgKChzbWFsbGludCBtZWRpdW1pbnQgYmlnaW50IGludGVnZXIgdW5pdmVy
c2FsLXRpbWUpCj4gLi4uCj4gCj4gSSBjb3VsZCBiZSB3cm9uZywgYnV0IGluIGJvdGggb2YgdGhl
c2UgdGhlICJvciIgbG9va3MgbGlrZSBpdCBjb3VsZCBiZSBhCj4gbWlzdGFrZS4KPiAKPiAKPiBP
biAyMDE2LTA4LTE1IDE4OjQ3LCBSdXNzIFR5bmRhbGwgd3JvdGU6Cj4+IEhvd2R5IFN0aWFuLAo+
PiAKPj4gSGVyZSBhcmUgdGhlIHJlbGV2YW50IGRpc2N1c3Npb25zIGFyb3VuZCB0aGlzIGZyb20g
MjAxNC0wNCB0aGlzOgo+PiBodHRwOi8vbGlzdHMua3BlLmlvL3BpcGVybWFpbC9jbHNxbC8yMDE0
LUFwcmlsL3RocmVhZC5odG1sCj4+IGh0dHBzOi8vZ2l0aHViLmNvbS9Vbndhc2hlZE1lbWUvY2xz
cWwvY29tbWl0LzMxYWU4MmYxZTBhZWZjZGQxMWEyNTIzOWI2ZmIyMWMxM2QzOGQ5ZjIKPj4gCj4+
IFRoZSBlYXNpZXN0IHdheSB0byBieXBhc3MgdGhpcyB3b3VsZCBiZSB0byBjaGFuZ2UgdGhlIGtl
eXdvcmRzIHRvIAo+PiBzeW1ib2xzIG9yIHN0cmluZ3MuICBZb3UgY2FuIGRvIHRoaXMgZGlyZWN0
bHkgdXNpbmcgdGhlIDpkYi10eXBlIAo+PiBhcmd1bWVudCBhbmQgc3BlY2lhbGl6aW5nIHRoZSBm
b2xsb3dpbmcgZnVuY3Rpb25zLgo+PiAKPj4gYAo+PiAoZGVmbWV0aG9kIGRhdGFiYXNlLW91dHB1
dC1zcWwtYXMtdHlwZSAodHlwZSB2YWwgZGF0YWJhc2UgZGItdHlwZSkuLi4pCj4+IChkZWZtZXRo
b2QgcmVhZC1zcWwtdmFsdWUgKHZhbCB0eXBlIGRhdGFiYXNlIGRiLXR5cGUpIC4uLikKPj4gYAo+
PiAKPj4gSWYgeW91IHVzZSBhIGA6ZGItdHlwZSAgJ2VudW1gIHdlIGNvdWxkIHVzZSB0aGF0IHRv
IGRpcmVjdCBjbHNxbCB0byAKPj4gd3JpdGUgIHRoZSBzbG90IGNvbnRlbnRzIGFzIGEgc3RyaW5n
IHZhbHVlIGluIHlvdXIgYXBwbGljYXRpb24sIChvciB3ZSAKPj4gY291bGQgYWRkIGl0IHRvIGNs
c3FsIGRpcmVjdGx5IGFzIHRoYXQgc2VlbXMgZmFpcmx5IGludHVpdGl2ZSAtIGFsdGhvdWdoIAo+
PiBlbnVtcyBjb3VsZCBhbHNvIGJlIGludGVnZXIgdmFsdWVkIC0gZWc6IHR5cGVzIHRhYmxlcyku
Cj4+IAo+PiBFeGFtcGxlOgo+PiBgCj4+IChkZWZtZXRob2QgZGF0YWJhc2Utb3V0cHV0LXNxbC1h
cy10eXBlCj4+ICAgICAgKCh0eXBlICdlbnVtKSAodmFsIHN5bWJvbCkgZGF0YWJhc2UgZGItdHlw
ZSkKPj4gICAgIChwcmluYy10by1zdHJpbmcgdmFsKSkKPj4gKGRlZm1ldGhvZCByZWFkLXNxbC12
YWx1ZQo+PiAgICAgICgodHlwZSAnZW51bSkgKHZhbCBzdHJpbmcpIGRhdGFiYXNlIGRiLXR5cGUp
Cj4+ICAgICAobGV0ICgoKnBhY2thZ2UqIDprZXl3b3JkKSkgKHJlYWQtZnJvbS1zdHJpbmcgdmFs
KSkKPj4gYAo+PiAKPj4gCj4+IFRoZSBwcm9ibGVtIHdhcyB0aGF0IHRoYXQgYWxsIHN5bWJvbHMg
d2VyZSBiZWluZyB3cml0dGVuIHRoZSBzYW1lIAo+PiByZWdhcmRsZXNzIG9mIHBhY2thZ2UgKG1h
a2luZyB0aGVtIG5vdCByZXZlcnNpYmxlIGluIHRoZSBmYWNlIG9mIAo+PiBtdWx0aXBsZSBwYWNr
YWdlcyksIElFOiB0aGV5IHdlcmUgbm90IHJvdW5kIHRyaXAgc2FmZS4gIFRoZSBzb2x1dGlvbiAK
Pj4gd2UvSSBjYW1lIHVwIHdpdGggd2FzIHRvIHdyaXRlIHN5bWJvbHMgd2l0aCB0aGUgcGFja2Fn
ZSBuYW1lIGluY2x1ZGVkLCAKPj4gc3VjaCB0aGF0IHdlIGNvdWxkIGxvb2sgdXAgdGhlIGNvcnJl
Y3Qgc3ltYm9sIHdoZW4gcmVhZGluZyBmcm9tIHRoZSAKPj4gZGF0YWJhc2UuICBUaGlzIHN5c3Rl
bSBpcyBmYWlybHkgY29tcGxleCBhbmQgSSBhbSBub3Qgc3VyZSB0aGF0IGEgCj4+IHNvbHV0aW9u
IGV4aXN0cyB0aGF0IHNvbHZlcyB0aGUgY2FzZSBmb3IgYWxsIHVzZXJzLiAgSSB0aGluayAKPj4g
ZnVuZGFtZW50YWxseSByZWFkaW5nIGFuZCB3cml0aW5nIHRvIHRoZSBkYXRhYmFzZSBzaG91bGQg
YmUgcmV2ZXJzaWJsZSwgCj4+IHdoaWNoIHJlcXVpcmVzIHByaW50aW5nIHRoZSBwYWNrYWdlIG5h
bWUgb2YgYSBzeW1ib2wgZm9yIGBkYi10eXBlICdzeW1ib2xgLgo+PiAKPj4gSSBoYXZlIG5ldmVy
IHVzZWQgUG9zdGdyZXNxbCBlbnVtcywgYW5kIHRoZXJlIGFyZSBub3QgaW4gdGhlIHRlc3RzLCBz
byAKPj4gaXRzIGRlZmluaXRlbHkgc29tZXRoaW5nIHRoYXQgY291bGQgaGF2ZSBicm9rZW4gdW5u
b3RpY2VkLiAgVGhlcmUgd2FzIAo+PiBzb21lIHdvcmsgcXVpdGUgYSBmZXcgdmVyc2lvbnMgYWdv
IHRvIG5vcm1hbGl6ZSBoYW5kbGluZyBvZiBzeW1ib2xzLCBzbyAKPj4gaXRzIHBvc3NpYmxlIHNv
bWV0aGluZyBpcyBzdGlsbCBub3QgcXVpdGUgcmlnaHQsIGJ1dCBpdCBoYXMgYSBtdWNoIG1vcmUg
Cj4+IG5vcm1hbGl6ZWQgaGFuZGxpbmcuCj4+IAo+PiBJZiB5b3UgdGhpbmsgdGhpcyBzaG91bGQg
YmUgcmVhc29uYWJsZSBzdGFuZGFyZCBiZWhhdmlvciAoSSBhbSBub3QgCj4+IGNvbnZpbmNlZCBv
ZiB0aGlzKSBhbmQgY2FuIGNvbnZpbmNlIG1lIG9mIHRoaXMsIEkgd291bGQgYmUgd2lsbGluZyB0
byAKPj4gYWRkIGl0IGFzIHN0YW5kYXJkLiAgTXkgY29uY2VybiBpcyB0aGF0IHNvbWUgZm9sa3Mg
d2lsbCBpbnRlcnByZXQgImVudW0iIAo+PiBhcyBzeW1ib2w9PmlkIG1hcCAoYSBkYXRhYmFzZSB0
eXBlcyB0YWJsZSkgaW5zdGVhZCBvZiBhIGtleXdvcmQgPT4gCj4+IHN0cmluZyBtYXAuICBBcyBi
b3RoIG9mIHRoZXNlIHNlZW0gcmVhc29uYWJsZSBpbnRlcnByZXRhdGlvbnMgb2YgdGhlIAo+PiB3
b3JkLCBpdCBtaWdodCBiZSBiZXR0ZXIgdG8gbGVhdmUgdGhpcyBhcyBhcHBsaWNhdGlvbiBzcGVj
aWZpYyBiZWhhdmlvci4KPj4gCj4+IENoZWVycyBhbmQgdGhhbmtzIGZvciB1c2luZyBDTFNRTCwK
Pj4gUnVzcyBUeW5kYWxsCj4+IEFjY2VsZXJhdGlvbi5uZXQKPj4gCj4+IE9uIDA4LzEyLzIwMTYg
MDY6MTIgQU0sIFN0aWFuIFNsZXRuZXIgd3JvdGU6Cj4+PiBbVHJ5aW5nIGFnYWluLCB3YXMgc3Vi
c2NyaWJlZCB3aXRoIHRoZSB3cm9uZyBhZGRyZXNzLl0KPj4+Cj4+PiBIZWxsby4KPj4+Cj4+PiBJ
IG5lZWQgc29tZSBoZWxwIHdpdGggYSBDTFNRTCBiZWhhdmlvdXIgY2hhbmdlLiAgVGhlIGlzc3Vl
IGlzIHRoYXQgSQo+Pj4gaGF2ZSBhIFBvc3RncmVzIGVudW0gdHlwZSBsaWtlIHNvOgo+Pj4KPj4+
IENSRUFURSBUWVBFIGpvYl9zdGF0dXMgQVMgRU5VTSAoCj4+PiAgICAgICdORVcnLAo+Pj4gICAg
ICAnUlVOTklORycsCj4+PiAgICAgICdET05FJywKPj4+ICAgICAgJ0ZBSUxFRCcsCj4+PiAgICAg
ICdBQk9SVEVEJwo+Pj4gKTsKPj4+Cj4+PiBUaGlzIGlzIHVzZWQgaW4gYSBjb2x1bW4gd2l0aCBh
IHNsb3QgZGVmaW5pdGlvbiBsaWtlIHNvOgo+Pj4KPj4+ICAgICAoam9iLXN0YXR1cyA6aW5pdGFy
ZyA6am9iLXN0YXR1cyA6YWNjZXNzb3Igam9iLXN0YXR1cyA6aW5pdGZvcm0gOm5ldwo+Pj4gICAg
ICAgICAgICAgICAgIDp0eXBlIGtleXdvcmQpCj4+Pgo+Pj4gVGhpcyB1c2VkIHRvIG1hcCBiYWNr
IGFuZCBmb3J0aCBmcm9tIGtleXdvcmRzIGZpbmUgZm9yIG1hbnkgeWVhcnMsIGJ1dAo+Pj4gaW4g
dGhlIGxhdGVzdCBDTFNRTCB2ZXJzaW9ucyBpdCB0cmllcyB0byBzdG9yZSB0aGUga2V5d29yZHMg
d2l0aCBjb2xvbi4KPj4+ICAgU29tZSB0aGluZ3Mgd29yayBhcyBleHBlY3RlZDoKPj4+Cj4+PiAq
IChzZWxlY3QgLi4uIDp3aGVyZSBbPSBbam9iLXN0YXR1c10gOm5ld10pCj4+Pgo+Pj4gOzsgMjAx
Ni0wOC0xMVQxMzoyNDozNSAuLi4gPT4gU0VMRUNUIC4uLiBGUk9NIC4uLiBXSEVSRSAoSk9CX1NU
QVRVUyA9ICdORVcnKQo+Pj4KPj4+IEJ1dCBmb3IgZXhhbXBsZSBVUERBVEUtUkVDT1JEUy1GUk9N
LUlOU1RBTkNFIHRyaWVzIHRvIHN0b3JlIHdpdGggY29sb246Cj4+Pgo+Pj4gICAgRXJyb3IgMjJQ
MDIgLyBpbnZhbGlkIGlucHV0IHZhbHVlIGZvciBlbnVtIGpvYl9zdGF0dXM6ICI6RkFJTEVEIgo+
Pj4KPj4+IEkgZG9uJ3Qga25vdyBpZiB0aGlzIGlzIGEgYnVnIG9yIHdoZXRoZXIgaXQgd2FzIG5l
dmVyIHN1cHBvc2VkIHRvIHdvcmsKPj4+IGxpa2UgdGhpcywgaWYgc28gSSdkIGFwcHJlY2lhdGUg
YW55IHRpcHMgb24gaG93IGl0IHNob3VsZCBiZSBkb25lLgo+Pj4KPj4gCj4+IAo+IAo+IAoKCi0t
IApTdGlhbiBTbGV0bmVyClQuICs0NyAyMSA1MyA2OSA0MApDb3B5bGVmdCBTb2x1dGlvbnMKd3d3
LmNvcHlsZWZ0c29sdXRpb25zLmNvbQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fXwpDTFNRTCBtYWlsaW5nIGxpc3QKQ0xTUUxAbGlzdHMua3BlLmlvCmh0dHA6
Ly9saXN0cy5rcGUuaW8vY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2Nsc3FsCg==