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==