Re: Postgres enum problem
Stian Sletner <[email protected]> Tue, 16 Aug 2016 13:30:01 +0200
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
SGkgUnVzcy4KClRoYW5rcyBmb3IgYSB2ZXJ5IHRob3JvdWdoIGFuZCBpbmZvcm1hdGl2ZSByZXBs eS4gIEknbSBhIGxpdHRsZSBjb25mdXNlZApoZXJlLCBzbyBiZWFyIHdpdGggbWUgLS0gbGVhdmlu ZyB0aGUgZW51bSBpc3N1ZSBhc2lkZSBmb3IgYSBtaW51dGUsIGFzCml0IHNob3VsZG4ndCBiZSBh IGh1Z2UgcHJvYmxlbSB0byBjaGFuZ2UgdG8gYSB0ZXh0IGZpZWxkIC0tIGhvdyBhcmUKa2V5d29y ZCB0eXBlIGZpZWxkcyBzdXBwb3NlZCB0byBiZSB1c2VkIGF0IGFsbD8gIEl0IGRvZXNuJ3Qgc2Vl bQpwb3NzaWJsZSB0byBTRUxFQ1Qgb24gdGhlbS4KCklmIEkgbGVhdmUgaXQgYWxsIHVwIHRvIENM U1FMOgoKKGRlZi12aWV3LWNsYXNzIHRlc3RrdyAoKQogICgoa3cgOmFjY2Vzc29yIHRlc3Rrdy1r dyA6aW5pdGFyZyA6a3cgOnR5cGUga2V5d29yZCkpKQooY3JlYXRlLXZpZXctZnJvbS1jbGFzcyAn dGVzdGt3KQooZGVmcGFyYW1ldGVyICppKiAobWFrZS1pbnN0YW5jZSAndGVzdGt3IDprdyA6aGVp KSkKKHVwZGF0ZS1yZWNvcmRzLWZyb20taW5zdGFuY2UgKmkqKQoKVGhlbiBJIGdldCBhIHRhYmxl IGxpa2UgdGhpczoKCmZqYXM9IyBcZCB0ZXN0a3cKICAgICAgICAgICAgIFRhYmxlICJwdWJsaWMu dGVzdGt3IgorLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKwp8 IENvbHVtbiB8ICAgICAgICAgIFR5cGUgICAgICAgICAgfCBNb2RpZmllcnMgfAorLS0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKwp8IGt3ICAgICB8IGNoYXJhY3Rl ciB2YXJ5aW5nKDI1NSkgfCAgICAgICAgICAgfAorLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tKwoKZmphcz0jIHNlbGVjdCAqIGZyb20gdGVzdGt3OworLS0tLS0t Kwp8ICBrdyAgfAorLS0tLS0tKwp8IDpIRUkgfAorLS0tLS0tKwooMSByb3cpCgpXaGljaCBpcyBm aW5lLCBidXQgSSBzdGlsbCBjYW4ndCBzZWxlY3Qgb24gdGhlIGtleXdvcmQ6CgoqIChzZWxlY3Qg W2t3XSA6ZnJvbSBbdGVzdGt3XSkKOzsgMjAxNi0wOC0xNlQxMjo0MzoyNSAvZmphcy9zdGlhbiA9 PiBTRUxFQ1QgS1cgRlJPTSBURVNUS1cKKCgiOkhFSSIpKQooImt3IikKCiogKHNlbGVjdCBba3dd IDpmcm9tIFt0ZXN0a3ddIDp3aGVyZSBbPSBba3ddIDpoZWldKQo7OyAyMDE2LTA4LTE2VDEyOjQz OjM1IC9mamFzL3N0aWFuID0+IFNFTEVDVCBLVyBGUk9NIFRFU1RLVyBXSEVSRSAoS1cgPQonSEVJ JykKTklMCigia3ciKQoKVGhpcyB3b3JrcywgYnV0IHdvdWxkIGJlIHZlcnkgY3VtYmVyc29tZSB0 byBhZGFwdCB0bzoKCihzZWxlY3QgW2t3XSA6ZnJvbSBbdGVzdGt3XSA6d2hlcmUgWz0gW2t3XSAi OkhFSSJdKQo7OyAyMDE2LTA4LTE2VDEyOjQ1OjQ5IC9mamFzL3N0aWFuID0+IFNFTEVDVCBLVyBG Uk9NIFRFU1RLVyBXSEVSRSAoS1cgPQonOkhFSScpCigoIjpIRUkiKSkKKCJrdyIpCgpCVFcgSSBh Z3JlZSB0aGF0IGVudW0gdHlwZXMgYXJlIHByb2JhYmx5IG5vdCB1c2VkIHVuaWZvcm1seSBhY3Jv c3MKZGlmZmVyZW50IGRhdGFiYXNlcywgYW5kIGlzIHByb2JhYmx5IGJldHRlciBsZWZ0IG91dC4g IEl0IHNlZW1zIHRvIG1lCm5vdyB0aGF0IGl0IHdhcyBub3QgdGhlIGNlbnRyYWwgcGFydCBvZiBt eSBwcm9ibGVtIGFueXdheS4gIEFnYWluLCBJJ20KanVzdCBjb25mdXNlZC4KClBTOiBJbiBteSBj b2RlIHdhbmRlcmluZ3MgSSBjYW1lIGFjcm9zcyB0aGVzZSBjYXNlcyBpbiBvb2RtbC5saXNwOgoK KGRlZm1ldGhvZCBkYXRhYmFzZS1vdXRwdXQtc3FsLWFzLXR5cGUKLi4uCiAgICAgKGNhc2UgdHlw ZQogICAgICAgKChvciBzeW1ib2wga2V5d29yZCkKICAgICAgICAocHJpbnQtcmVhZGFibGUtc3lt Ym9sIHZhbCkpCiAgICAgICAoc3RyaW5nIHZhbCkKLi4uCgooZGVmbWV0aG9kIHJlYWQtc3FsLXZh bHVlICh2YWwgdHlwZSBkYXRhYmFzZSBkYi10eXBlKQouLi4KICAgICAgIChjaGFyIChzdHJpbmcg KHNjaGFyIHZhbCAwKSkpCiAgICAgICAoKG9yIGtleXdvcmQgc3ltYm9sKQogICAgICAgIChyZWFk LWZyb20tc3RyaW5nIHZhbCkpCiAgICAgICAoKHNtYWxsaW50IG1lZGl1bWludCBiaWdpbnQgaW50 ZWdlciB1bml2ZXJzYWwtdGltZSkKLi4uCgpJIGNvdWxkIGJlIHdyb25nLCBidXQgaW4gYm90aCBv ZiB0aGVzZSB0aGUgIm9yIiBsb29rcyBsaWtlIGl0IGNvdWxkIGJlIGEKbWlzdGFrZS4KCgpPbiAy MDE2LTA4LTE1IDE4OjQ3LCBSdXNzIFR5bmRhbGwgd3JvdGU6Cj4gSG93ZHkgU3RpYW4sCj4gCj4g SGVyZSBhcmUgdGhlIHJlbGV2YW50IGRpc2N1c3Npb25zIGFyb3VuZCB0aGlzIGZyb20gMjAxNC0w NCB0aGlzOgo+IGh0dHA6Ly9saXN0cy5rcGUuaW8vcGlwZXJtYWlsL2Nsc3FsLzIwMTQtQXByaWwv dGhyZWFkLmh0bWwKPiBodHRwczovL2dpdGh1Yi5jb20vVW53YXNoZWRNZW1lL2Nsc3FsL2NvbW1p dC8zMWFlODJmMWUwYWVmY2RkMTFhMjUyMzliNmZiMjFjMTNkMzhkOWYyCj4gCj4gVGhlIGVhc2ll c3Qgd2F5IHRvIGJ5cGFzcyB0aGlzIHdvdWxkIGJlIHRvIGNoYW5nZSB0aGUga2V5d29yZHMgdG8g Cj4gc3ltYm9scyBvciBzdHJpbmdzLiAgWW91IGNhbiBkbyB0aGlzIGRpcmVjdGx5IHVzaW5nIHRo ZSA6ZGItdHlwZSAKPiBhcmd1bWVudCBhbmQgc3BlY2lhbGl6aW5nIHRoZSBmb2xsb3dpbmcgZnVu Y3Rpb25zLgo+IAo+IGAKPiAoZGVmbWV0aG9kIGRhdGFiYXNlLW91dHB1dC1zcWwtYXMtdHlwZSAo dHlwZSB2YWwgZGF0YWJhc2UgZGItdHlwZSkuLi4pCj4gKGRlZm1ldGhvZCByZWFkLXNxbC12YWx1 ZSAodmFsIHR5cGUgZGF0YWJhc2UgZGItdHlwZSkgLi4uKQo+IGAKPiAKPiBJZiB5b3UgdXNlIGEg YDpkYi10eXBlICAnZW51bWAgd2UgY291bGQgdXNlIHRoYXQgdG8gZGlyZWN0IGNsc3FsIHRvIAo+ IHdyaXRlICB0aGUgc2xvdCBjb250ZW50cyBhcyBhIHN0cmluZyB2YWx1ZSBpbiB5b3VyIGFwcGxp Y2F0aW9uLCAob3Igd2UgCj4gY291bGQgYWRkIGl0IHRvIGNsc3FsIGRpcmVjdGx5IGFzIHRoYXQg c2VlbXMgZmFpcmx5IGludHVpdGl2ZSAtIGFsdGhvdWdoIAo+IGVudW1zIGNvdWxkIGFsc28gYmUg aW50ZWdlciB2YWx1ZWQgLSBlZzogdHlwZXMgdGFibGVzKS4KPiAKPiBFeGFtcGxlOgo+IGAKPiAo ZGVmbWV0aG9kIGRhdGFiYXNlLW91dHB1dC1zcWwtYXMtdHlwZQo+ICAgICAgKCh0eXBlICdlbnVt KSAodmFsIHN5bWJvbCkgZGF0YWJhc2UgZGItdHlwZSkKPiAgICAgKHByaW5jLXRvLXN0cmluZyB2 YWwpKQo+IChkZWZtZXRob2QgcmVhZC1zcWwtdmFsdWUKPiAgICAgICgodHlwZSAnZW51bSkgKHZh bCBzdHJpbmcpIGRhdGFiYXNlIGRiLXR5cGUpCj4gICAgIChsZXQgKCgqcGFja2FnZSogOmtleXdv cmQpKSAocmVhZC1mcm9tLXN0cmluZyB2YWwpKQo+IGAKPiAKPiAKPiBUaGUgcHJvYmxlbSB3YXMg dGhhdCB0aGF0IGFsbCBzeW1ib2xzIHdlcmUgYmVpbmcgd3JpdHRlbiB0aGUgc2FtZSAKPiByZWdh cmRsZXNzIG9mIHBhY2thZ2UgKG1ha2luZyB0aGVtIG5vdCByZXZlcnNpYmxlIGluIHRoZSBmYWNl IG9mIAo+IG11bHRpcGxlIHBhY2thZ2VzKSwgSUU6IHRoZXkgd2VyZSBub3Qgcm91bmQgdHJpcCBz YWZlLiAgVGhlIHNvbHV0aW9uIAo+IHdlL0kgY2FtZSB1cCB3aXRoIHdhcyB0byB3cml0ZSBzeW1i b2xzIHdpdGggdGhlIHBhY2thZ2UgbmFtZSBpbmNsdWRlZCwgCj4gc3VjaCB0aGF0IHdlIGNvdWxk IGxvb2sgdXAgdGhlIGNvcnJlY3Qgc3ltYm9sIHdoZW4gcmVhZGluZyBmcm9tIHRoZSAKPiBkYXRh YmFzZS4gIFRoaXMgc3lzdGVtIGlzIGZhaXJseSBjb21wbGV4IGFuZCBJIGFtIG5vdCBzdXJlIHRo YXQgYSAKPiBzb2x1dGlvbiBleGlzdHMgdGhhdCBzb2x2ZXMgdGhlIGNhc2UgZm9yIGFsbCB1c2Vy cy4gIEkgdGhpbmsgCj4gZnVuZGFtZW50YWxseSByZWFkaW5nIGFuZCB3cml0aW5nIHRvIHRoZSBk YXRhYmFzZSBzaG91bGQgYmUgcmV2ZXJzaWJsZSwgCj4gd2hpY2ggcmVxdWlyZXMgcHJpbnRpbmcg dGhlIHBhY2thZ2UgbmFtZSBvZiBhIHN5bWJvbCBmb3IgYGRiLXR5cGUgJ3N5bWJvbGAuCj4gCj4g SSBoYXZlIG5ldmVyIHVzZWQgUG9zdGdyZXNxbCBlbnVtcywgYW5kIHRoZXJlIGFyZSBub3QgaW4g dGhlIHRlc3RzLCBzbyAKPiBpdHMgZGVmaW5pdGVseSBzb21ldGhpbmcgdGhhdCBjb3VsZCBoYXZl IGJyb2tlbiB1bm5vdGljZWQuICBUaGVyZSB3YXMgCj4gc29tZSB3b3JrIHF1aXRlIGEgZmV3IHZl cnNpb25zIGFnbyB0byBub3JtYWxpemUgaGFuZGxpbmcgb2Ygc3ltYm9scywgc28gCj4gaXRzIHBv c3NpYmxlIHNvbWV0aGluZyBpcyBzdGlsbCBub3QgcXVpdGUgcmlnaHQsIGJ1dCBpdCBoYXMgYSBt dWNoIG1vcmUgCj4gbm9ybWFsaXplZCBoYW5kbGluZy4KPiAKPiBJZiB5b3UgdGhpbmsgdGhpcyBz aG91bGQgYmUgcmVhc29uYWJsZSBzdGFuZGFyZCBiZWhhdmlvciAoSSBhbSBub3QgCj4gY29udmlu Y2VkIG9mIHRoaXMpIGFuZCBjYW4gY29udmluY2UgbWUgb2YgdGhpcywgSSB3b3VsZCBiZSB3aWxs aW5nIHRvIAo+IGFkZCBpdCBhcyBzdGFuZGFyZC4gIE15IGNvbmNlcm4gaXMgdGhhdCBzb21lIGZv bGtzIHdpbGwgaW50ZXJwcmV0ICJlbnVtIiAKPiBhcyBzeW1ib2w9PmlkIG1hcCAoYSBkYXRhYmFz ZSB0eXBlcyB0YWJsZSkgaW5zdGVhZCBvZiBhIGtleXdvcmQgPT4gCj4gc3RyaW5nIG1hcC4gIEFz IGJvdGggb2YgdGhlc2Ugc2VlbSByZWFzb25hYmxlIGludGVycHJldGF0aW9ucyBvZiB0aGUgCj4g d29yZCwgaXQgbWlnaHQgYmUgYmV0dGVyIHRvIGxlYXZlIHRoaXMgYXMgYXBwbGljYXRpb24gc3Bl Y2lmaWMgYmVoYXZpb3IuCj4gCj4gQ2hlZXJzIGFuZCB0aGFua3MgZm9yIHVzaW5nIENMU1FMLAo+ IFJ1c3MgVHluZGFsbAo+IEFjY2VsZXJhdGlvbi5uZXQKPiAKPiBPbiAwOC8xMi8yMDE2IDA2OjEy IEFNLCBTdGlhbiBTbGV0bmVyIHdyb3RlOgo+PiBbVHJ5aW5nIGFnYWluLCB3YXMgc3Vic2NyaWJl ZCB3aXRoIHRoZSB3cm9uZyBhZGRyZXNzLl0KPj4KPj4gSGVsbG8uCj4+Cj4+IEkgbmVlZCBzb21l IGhlbHAgd2l0aCBhIENMU1FMIGJlaGF2aW91ciBjaGFuZ2UuICBUaGUgaXNzdWUgaXMgdGhhdCBJ Cj4+IGhhdmUgYSBQb3N0Z3JlcyBlbnVtIHR5cGUgbGlrZSBzbzoKPj4KPj4gQ1JFQVRFIFRZUEUg am9iX3N0YXR1cyBBUyBFTlVNICgKPj4gICAgICAnTkVXJywKPj4gICAgICAnUlVOTklORycsCj4+ ICAgICAgJ0RPTkUnLAo+PiAgICAgICdGQUlMRUQnLAo+PiAgICAgICdBQk9SVEVEJwo+PiApOwo+ Pgo+PiBUaGlzIGlzIHVzZWQgaW4gYSBjb2x1bW4gd2l0aCBhIHNsb3QgZGVmaW5pdGlvbiBsaWtl IHNvOgo+Pgo+PiAgICAgKGpvYi1zdGF0dXMgOmluaXRhcmcgOmpvYi1zdGF0dXMgOmFjY2Vzc29y IGpvYi1zdGF0dXMgOmluaXRmb3JtIDpuZXcKPj4gICAgICAgICAgICAgICAgIDp0eXBlIGtleXdv cmQpCj4+Cj4+IFRoaXMgdXNlZCB0byBtYXAgYmFjayBhbmQgZm9ydGggZnJvbSBrZXl3b3JkcyBm aW5lIGZvciBtYW55IHllYXJzLCBidXQKPj4gaW4gdGhlIGxhdGVzdCBDTFNRTCB2ZXJzaW9ucyBp dCB0cmllcyB0byBzdG9yZSB0aGUga2V5d29yZHMgd2l0aCBjb2xvbi4KPj4gICBTb21lIHRoaW5n cyB3b3JrIGFzIGV4cGVjdGVkOgo+Pgo+PiAqIChzZWxlY3QgLi4uIDp3aGVyZSBbPSBbam9iLXN0 YXR1c10gOm5ld10pCj4+Cj4+IDs7IDIwMTYtMDgtMTFUMTM6MjQ6MzUgLi4uID0+IFNFTEVDVCAu Li4gRlJPTSAuLi4gV0hFUkUgKEpPQl9TVEFUVVMgPSAnTkVXJykKPj4KPj4gQnV0IGZvciBleGFt cGxlIFVQREFURS1SRUNPUkRTLUZST00tSU5TVEFOQ0UgdHJpZXMgdG8gc3RvcmUgd2l0aCBjb2xv bjoKPj4KPj4gICAgRXJyb3IgMjJQMDIgLyBpbnZhbGlkIGlucHV0IHZhbHVlIGZvciBlbnVtIGpv Yl9zdGF0dXM6ICI6RkFJTEVEIgo+Pgo+PiBJIGRvbid0IGtub3cgaWYgdGhpcyBpcyBhIGJ1ZyBv ciB3aGV0aGVyIGl0IHdhcyBuZXZlciBzdXBwb3NlZCB0byB3b3JrCj4+IGxpa2UgdGhpcywgaWYg c28gSSdkIGFwcHJlY2lhdGUgYW55IHRpcHMgb24gaG93IGl0IHNob3VsZCBiZSBkb25lLgo+Pgo+ IAo+IAoKCi0tIApTdGlhbiBTbGV0bmVyClQuICs0NyAyMSA1MyA2OSA0MApDb3B5bGVmdCBTb2x1 dGlvbnMKd3d3LmNvcHlsZWZ0c29sdXRpb25zLmNvbQpfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXwpDTFNRTCBtYWlsaW5nIGxpc3QKQ0xTUUxAbGlzdHMua3Bl LmlvCmh0dHA6Ly9saXN0cy5rcGUuaW8vY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2Nsc3FsCg==