Re: Postgres enum problem
Russ Tyndall <[email protected]> Mon, 15 Aug 2016 12:47:56 -0400
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
SG93ZHkgU3RpYW4sCgpIZXJlIGFyZSB0aGUgcmVsZXZhbnQgZGlzY3Vzc2lvbnMgYXJvdW5kIHRo aXMgZnJvbSAyMDE0LTA0IHRoaXM6Cmh0dHA6Ly9saXN0cy5rcGUuaW8vcGlwZXJtYWlsL2Nsc3Fs LzIwMTQtQXByaWwvdGhyZWFkLmh0bWwKaHR0cHM6Ly9naXRodWIuY29tL1Vud2FzaGVkTWVtZS9j bHNxbC9jb21taXQvMzFhZTgyZjFlMGFlZmNkZDExYTI1MjM5YjZmYjIxYzEzZDM4ZDlmMgoKVGhl IGVhc2llc3Qgd2F5IHRvIGJ5cGFzcyB0aGlzIHdvdWxkIGJlIHRvIGNoYW5nZSB0aGUga2V5d29y ZHMgdG8gCnN5bWJvbHMgb3Igc3RyaW5ncy4gIFlvdSBjYW4gZG8gdGhpcyBkaXJlY3RseSB1c2lu ZyB0aGUgOmRiLXR5cGUgCmFyZ3VtZW50IGFuZCBzcGVjaWFsaXppbmcgdGhlIGZvbGxvd2luZyBm dW5jdGlvbnMuCgpgCihkZWZtZXRob2QgZGF0YWJhc2Utb3V0cHV0LXNxbC1hcy10eXBlICh0eXBl IHZhbCBkYXRhYmFzZSBkYi10eXBlKS4uLikKKGRlZm1ldGhvZCByZWFkLXNxbC12YWx1ZSAodmFs IHR5cGUgZGF0YWJhc2UgZGItdHlwZSkgLi4uKQpgCgpJZiB5b3UgdXNlIGEgYDpkYi10eXBlICAn ZW51bWAgd2UgY291bGQgdXNlIHRoYXQgdG8gZGlyZWN0IGNsc3FsIHRvIAp3cml0ZSAgdGhlIHNs b3QgY29udGVudHMgYXMgYSBzdHJpbmcgdmFsdWUgaW4geW91ciBhcHBsaWNhdGlvbiwgKG9yIHdl IApjb3VsZCBhZGQgaXQgdG8gY2xzcWwgZGlyZWN0bHkgYXMgdGhhdCBzZWVtcyBmYWlybHkgaW50 dWl0aXZlIC0gYWx0aG91Z2ggCmVudW1zIGNvdWxkIGFsc28gYmUgaW50ZWdlciB2YWx1ZWQgLSBl ZzogdHlwZXMgdGFibGVzKS4KCkV4YW1wbGU6CmAKKGRlZm1ldGhvZCBkYXRhYmFzZS1vdXRwdXQt c3FsLWFzLXR5cGUKICAgICAoKHR5cGUgJ2VudW0pICh2YWwgc3ltYm9sKSBkYXRhYmFzZSBkYi10 eXBlKQogICAgKHByaW5jLXRvLXN0cmluZyB2YWwpKQooZGVmbWV0aG9kIHJlYWQtc3FsLXZhbHVl CiAgICAgKCh0eXBlICdlbnVtKSAodmFsIHN0cmluZykgZGF0YWJhc2UgZGItdHlwZSkKICAgIChs ZXQgKCgqcGFja2FnZSogOmtleXdvcmQpKSAocmVhZC1mcm9tLXN0cmluZyB2YWwpKQpgCgoKVGhl IHByb2JsZW0gd2FzIHRoYXQgdGhhdCBhbGwgc3ltYm9scyB3ZXJlIGJlaW5nIHdyaXR0ZW4gdGhl IHNhbWUgCnJlZ2FyZGxlc3Mgb2YgcGFja2FnZSAobWFraW5nIHRoZW0gbm90IHJldmVyc2libGUg aW4gdGhlIGZhY2Ugb2YgCm11bHRpcGxlIHBhY2thZ2VzKSwgSUU6IHRoZXkgd2VyZSBub3Qgcm91 bmQgdHJpcCBzYWZlLiAgVGhlIHNvbHV0aW9uIAp3ZS9JIGNhbWUgdXAgd2l0aCB3YXMgdG8gd3Jp dGUgc3ltYm9scyB3aXRoIHRoZSBwYWNrYWdlIG5hbWUgaW5jbHVkZWQsIApzdWNoIHRoYXQgd2Ug Y291bGQgbG9vayB1cCB0aGUgY29ycmVjdCBzeW1ib2wgd2hlbiByZWFkaW5nIGZyb20gdGhlIApk YXRhYmFzZS4gIFRoaXMgc3lzdGVtIGlzIGZhaXJseSBjb21wbGV4IGFuZCBJIGFtIG5vdCBzdXJl IHRoYXQgYSAKc29sdXRpb24gZXhpc3RzIHRoYXQgc29sdmVzIHRoZSBjYXNlIGZvciBhbGwgdXNl cnMuICBJIHRoaW5rIApmdW5kYW1lbnRhbGx5IHJlYWRpbmcgYW5kIHdyaXRpbmcgdG8gdGhlIGRh dGFiYXNlIHNob3VsZCBiZSByZXZlcnNpYmxlLCAKd2hpY2ggcmVxdWlyZXMgcHJpbnRpbmcgdGhl IHBhY2thZ2UgbmFtZSBvZiBhIHN5bWJvbCBmb3IgYGRiLXR5cGUgJ3N5bWJvbGAuCgpJIGhhdmUg bmV2ZXIgdXNlZCBQb3N0Z3Jlc3FsIGVudW1zLCBhbmQgdGhlcmUgYXJlIG5vdCBpbiB0aGUgdGVz dHMsIHNvIAppdHMgZGVmaW5pdGVseSBzb21ldGhpbmcgdGhhdCBjb3VsZCBoYXZlIGJyb2tlbiB1 bm5vdGljZWQuICBUaGVyZSB3YXMgCnNvbWUgd29yayBxdWl0ZSBhIGZldyB2ZXJzaW9ucyBhZ28g dG8gbm9ybWFsaXplIGhhbmRsaW5nIG9mIHN5bWJvbHMsIHNvIAppdHMgcG9zc2libGUgc29tZXRo aW5nIGlzIHN0aWxsIG5vdCBxdWl0ZSByaWdodCwgYnV0IGl0IGhhcyBhIG11Y2ggbW9yZSAKbm9y bWFsaXplZCBoYW5kbGluZy4KCklmIHlvdSB0aGluayB0aGlzIHNob3VsZCBiZSByZWFzb25hYmxl IHN0YW5kYXJkIGJlaGF2aW9yIChJIGFtIG5vdCAKY29udmluY2VkIG9mIHRoaXMpIGFuZCBjYW4g Y29udmluY2UgbWUgb2YgdGhpcywgSSB3b3VsZCBiZSB3aWxsaW5nIHRvIAphZGQgaXQgYXMgc3Rh bmRhcmQuICBNeSBjb25jZXJuIGlzIHRoYXQgc29tZSBmb2xrcyB3aWxsIGludGVycHJldCAiZW51 bSIgCmFzIHN5bWJvbD0+aWQgbWFwIChhIGRhdGFiYXNlIHR5cGVzIHRhYmxlKSBpbnN0ZWFkIG9m IGEga2V5d29yZCA9PiAKc3RyaW5nIG1hcC4gIEFzIGJvdGggb2YgdGhlc2Ugc2VlbSByZWFzb25h YmxlIGludGVycHJldGF0aW9ucyBvZiB0aGUgCndvcmQsIGl0IG1pZ2h0IGJlIGJldHRlciB0byBs ZWF2ZSB0aGlzIGFzIGFwcGxpY2F0aW9uIHNwZWNpZmljIGJlaGF2aW9yLgoKQ2hlZXJzIGFuZCB0 aGFua3MgZm9yIHVzaW5nIENMU1FMLApSdXNzIFR5bmRhbGwKQWNjZWxlcmF0aW9uLm5ldAoKT24g MDgvMTIvMjAxNiAwNjoxMiBBTSwgU3RpYW4gU2xldG5lciB3cm90ZToKPiBbVHJ5aW5nIGFnYWlu LCB3YXMgc3Vic2NyaWJlZCB3aXRoIHRoZSB3cm9uZyBhZGRyZXNzLl0KPgo+IEhlbGxvLgo+Cj4g SSBuZWVkIHNvbWUgaGVscCB3aXRoIGEgQ0xTUUwgYmVoYXZpb3VyIGNoYW5nZS4gIFRoZSBpc3N1 ZSBpcyB0aGF0IEkKPiBoYXZlIGEgUG9zdGdyZXMgZW51bSB0eXBlIGxpa2Ugc286Cj4KPiBDUkVB VEUgVFlQRSBqb2Jfc3RhdHVzIEFTIEVOVU0gKAo+ICAgICAgJ05FVycsCj4gICAgICAnUlVOTklO RycsCj4gICAgICAnRE9ORScsCj4gICAgICAnRkFJTEVEJywKPiAgICAgICdBQk9SVEVEJwo+ICk7 Cj4KPiBUaGlzIGlzIHVzZWQgaW4gYSBjb2x1bW4gd2l0aCBhIHNsb3QgZGVmaW5pdGlvbiBsaWtl IHNvOgo+Cj4gICAgIChqb2Itc3RhdHVzIDppbml0YXJnIDpqb2Itc3RhdHVzIDphY2Nlc3NvciBq b2Itc3RhdHVzIDppbml0Zm9ybSA6bmV3Cj4gICAgICAgICAgICAgICAgIDp0eXBlIGtleXdvcmQp Cj4KPiBUaGlzIHVzZWQgdG8gbWFwIGJhY2sgYW5kIGZvcnRoIGZyb20ga2V5d29yZHMgZmluZSBm b3IgbWFueSB5ZWFycywgYnV0Cj4gaW4gdGhlIGxhdGVzdCBDTFNRTCB2ZXJzaW9ucyBpdCB0cmll cyB0byBzdG9yZSB0aGUga2V5d29yZHMgd2l0aCBjb2xvbi4KPiAgIFNvbWUgdGhpbmdzIHdvcmsg YXMgZXhwZWN0ZWQ6Cj4KPiAqIChzZWxlY3QgLi4uIDp3aGVyZSBbPSBbam9iLXN0YXR1c10gOm5l d10pCj4KPiA7OyAyMDE2LTA4LTExVDEzOjI0OjM1IC4uLiA9PiBTRUxFQ1QgLi4uIEZST00gLi4u IFdIRVJFIChKT0JfU1RBVFVTID0gJ05FVycpCj4KPiBCdXQgZm9yIGV4YW1wbGUgVVBEQVRFLVJF Q09SRFMtRlJPTS1JTlNUQU5DRSB0cmllcyB0byBzdG9yZSB3aXRoIGNvbG9uOgo+Cj4gICAgRXJy b3IgMjJQMDIgLyBpbnZhbGlkIGlucHV0IHZhbHVlIGZvciBlbnVtIGpvYl9zdGF0dXM6ICI6RkFJ TEVEIgo+Cj4gSSBkb24ndCBrbm93IGlmIHRoaXMgaXMgYSBidWcgb3Igd2hldGhlciBpdCB3YXMg bmV2ZXIgc3VwcG9zZWQgdG8gd29yawo+IGxpa2UgdGhpcywgaWYgc28gSSdkIGFwcHJlY2lhdGUg YW55IHRpcHMgb24gaG93IGl0IHNob3VsZCBiZSBkb25lLgo+CgoKX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX18KQ0xTUUwgbWFpbGluZyBsaXN0CkNMU1FMQGxp c3RzLmtwZS5pbwpodHRwOi8vbGlzdHMua3BlLmlvL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9j bHNxbAo=