Impossible to specify different port number in open-database with CCL1.10
Using CCL on a Mac (Version 1.10-r16196 (DarwinX8664)), when I try to open a connection specifying a port: (cl-postgres:open-database “database” "user” "pwd" "localhost" :port 5434) the following error is raised: value :PORT is not an integer from 1 to 65535 ((INTEGER 1 65535)) But even if I try to coerce it explicitly, with something like: (cl-postgres:open-database "database" "user" "pwd" "localhost" :port (coerce 5434 '(integer 1 65535))) the same error is raised. Maybe this depends on CCL, since when I write to the REPL: (type-of (coerce 5434 '(integer 1 65535))) the answer is: (INTEGER 0 1152921504606846975) So, may I suggest to change the parameter check to perform an explicit test on the limits? Thank you very much for your attention Renzo Orsini -- "Nota automatica aggiunta dal sistema di posta. Destina il 5 per mille per sostenere con borse di studio gli studenti meritevoli di Ca' Foscari. E' un atto volontario, non costa nulla e non sostituisce l'8 per mille. Scegli Ca' Foscari: codice fiscale 80007720271 Please note that the above message is addressed only to individuals filing Italian income tax returns."
These are optional, not keyword arguments. So leave off the :port argument, just pass a number as 5th argument. On Thu, May 21, 2015 at 3:03 PM, Renzo Orsini <orsini@unive.it> wrote:
Using CCL on a Mac (Version 1.10-r16196 (DarwinX8664)),
when I try to open a connection specifying a port:
(cl-postgres:open-database “database” "user” "pwd" "localhost" :port 5434)
the following error is raised:
value :PORT is not an integer from 1 to 65535 ((INTEGER 1 65535))
But even if I try to coerce it explicitly, with something like:
(cl-postgres:open-database "database" "user" "pwd" "localhost" :port (coerce 5434 '(integer 1 65535)))
the same error is raised.
Maybe this depends on CCL, since when I write to the REPL: (type-of (coerce 5434 '(integer 1 65535))) the answer is: (INTEGER 0 1152921504606846975)
So, may I suggest to change the parameter check to perform an explicit test on the limits?
Thank you very much for your attention
Renzo Orsini
-- "Nota automatica aggiunta dal sistema di posta. Destina il 5 per mille per sostenere con borse di studio gli studenti meritevoli di Ca' Foscari. E' un atto volontario, non costa nulla e non sostituisce l'8 per mille. Scegli Ca' Foscari: codice fiscale 80007720271 Please note that the above message is addressed only to individuals filing Italian income tax returns."
Thanks! I was stupid since I did not read with attention the slime suggestion in the mini-buffer. Renzo
On 21 May 2015, at 15:09 , Marijn Haverbeke <marijnh@gmail.com> wrote:
These are optional, not keyword arguments. So leave off the :port argument, just pass a number as 5th argument.
On Thu, May 21, 2015 at 3:03 PM, Renzo Orsini <orsini@unive.it> wrote:
Using CCL on a Mac (Version 1.10-r16196 (DarwinX8664)),
when I try to open a connection specifying a port:
(cl-postgres:open-database “database” "user” "pwd" "localhost" :port 5434)
the following error is raised:
value :PORT is not an integer from 1 to 65535 ((INTEGER 1 65535))
But even if I try to coerce it explicitly, with something like:
(cl-postgres:open-database "database" "user" "pwd" "localhost" :port (coerce 5434 '(integer 1 65535)))
the same error is raised.
Maybe this depends on CCL, since when I write to the REPL: (type-of (coerce 5434 '(integer 1 65535))) the answer is: (INTEGER 0 1152921504606846975)
So, may I suggest to change the parameter check to perform an explicit test on the limits?
Thank you very much for your attention
Renzo Orsini
-- "Nota automatica aggiunta dal sistema di posta. Destina il 5 per mille per sostenere con borse di studio gli studenti meritevoli di Ca' Foscari. E' un atto volontario, non costa nulla e non sostituisce l'8 per mille. Scegli Ca' Foscari: codice fiscale 80007720271 Please note that the above message is addressed only to individuals filing Italian income tax returns."
-- "Nota automatica aggiunta dal sistema di posta. Destina il 5 per mille per sostenere con borse di studio gli studenti meritevoli di Ca' Foscari. E' un atto volontario, non costa nulla e non sostituisce l'8 per mille. Scegli Ca' Foscari: codice fiscale 80007720271 Please note that the above message is addressed only to individuals filing Italian income tax returns."
participants (2)
-
Marijn Haverbeke -
Renzo Orsini