<phoe>
iissaacc: what do you mean by seemingly not releasing it?
<iissaacc>
well, I used a couple of functions with a with-connection in them, they ended, but then i go to try and drop the test database that i created and i get an error telling me it is in use
<iissaacc>
checking pg_stat_activity shows 2 idle connections from the user i specified in the with-connection parameters
<phoe>
hmmm
<iissaacc>
*database* is nil, as expected
<no-defun-allowed>
Could there be another meaning of "in use", like that the table is being used by a view or something? I haven't gotten deep into SQL to say anything for sure.
<phoe>
can you try to reproduce it? are you sure that you did not do any toplevel connections from the REPL, or that you reassigned the value of POSTMODERN:*DATABASE*?
<phoe>
did you use the :POOLED-P parameter to CONNECT?
<iissaacc>
yep i used pooled-p
<phoe>
there you go
<phoe>
docstring for method DISCONNECT (DATABASE-CONNECTION): "Disconnects a normal database connection, or moves a pooled connection into the pool."
<no-defun-allowed>
Yeah, pooling would cause Postmodern to stash connections for reuse.
<iissaacc>
ahhhhhhhh
<no-defun-allowed>
You might want CLEAR-CONNECTION-POOL
<phoe>
call (pomo:clear-connection-pool)
<iissaacc>
thank you phoe and no-defun-allowed
<phoe>
yes, this
<iissaacc>
im not very au fait with postgres itself
<no-defun-allowed>
But I still wonder if that's the problem; if the connections aren't being used for anything, why would they prevent a table from being dropped?
treflip has joined #lisp
<iissaacc>
*database being dropped
<phoe>
no-defun-allowed: you can't pull a rug on which you are standing
<phoe>
you connect to a particular database, so you can't destroy the database while there's still something connected to it
<no-defun-allowed>
A database, eh? That would probably be different then, sure.
wxie has joined #lisp
jonatack has joined #lisp
<pve>
iissaacc: in case your wondering about the quality of postmodern, I've used it quite a bit and found it very reliable
<phoe>
^
<iissaacc>
it's the first time i've done any sql really so im working on the theory that any problems are probably the result of my own ignorance
<iissaacc>
its neat how you can build little mini languages that compile to sql queries
<pve>
when it comes to postmodern (and postgresql for that matter), any weirdness has always been my own fault
libertyprime has quit [Quit: leaving]
<iissaacc>
ive been writing my own migrations library to try get a better handle on it
yitzi has quit [Quit: yitzi]
iAmDecim has quit [Ping timeout: 256 seconds]
mangul has joined #lisp
shangul has quit [Ping timeout: 260 seconds]
nicktick has quit [Ping timeout: 240 seconds]
heisig has quit [Quit: Leaving]
jesse1010 has joined #lisp
davepdotorg has quit [Remote host closed the connection]
davepdotorg has joined #lisp
Alloc has joined #lisp
jw4 has quit [Read error: Connection reset by peer]
mseddon_ has quit [Remote host closed the connection]
dmiles has joined #lisp
mseddon has quit [Ping timeout: 240 seconds]
cosimone has joined #lisp
cosimone_ has joined #lisp
cosimone has quit [Read error: Connection reset by peer]
davepdot_ has joined #lisp
cosimone_ has quit [Remote host closed the connection]
cosimone_ has joined #lisp
davepdotorg has quit [Ping timeout: 260 seconds]
ebrasca has joined #lisp
iAmDecim has joined #lisp
davepdot_ has quit [Remote host closed the connection]
iissaacc has quit [Ping timeout: 265 seconds]
iAmDecim has quit [Ping timeout: 246 seconds]
bitmapper has quit [Ping timeout: 265 seconds]
Oddity has joined #lisp
X-Scale` has joined #lisp
Oddity__ has quit [Ping timeout: 240 seconds]
X-Scale has quit [Ping timeout: 240 seconds]
X-Scale` is now known as X-Scale
cosimone has joined #lisp
cosimone_ has quit [Ping timeout: 240 seconds]
mseddon has joined #lisp
wxie has quit [Ping timeout: 264 seconds]
wxie has joined #lisp
mseddon_ has joined #lisp
mseddon has quit [Ping timeout: 240 seconds]
cosimone has quit [Read error: Connection reset by peer]
cosimone has joined #lisp
jonatack has quit [Ping timeout: 260 seconds]
zooey_ has quit [Remote host closed the connection]
zooey has joined #lisp
EvW1 has joined #lisp
Alloc has quit [Ping timeout: 240 seconds]
davepdotorg has joined #lisp
Alloc has joined #lisp
cosimone has quit [Remote host closed the connection]
davepdotorg has quit [Ping timeout: 240 seconds]
CrazyEddy has joined #lisp
Alloc has quit [Ping timeout: 246 seconds]
Alloc has joined #lisp
wxie has quit [Ping timeout: 240 seconds]
Alloc has quit [Ping timeout: 258 seconds]
davepdotorg has joined #lisp
Alloc has joined #lisp
mseddon_ is now known as mseddon
wsinatra has quit [Ping timeout: 260 seconds]
mseddon_ has joined #lisp
davepdotorg has quit [Remote host closed the connection]
davepdotorg has joined #lisp
mseddon has quit [Ping timeout: 258 seconds]
cosimone has joined #lisp
wxie has joined #lisp
mseddon has joined #lisp
mseddon_ has quit [Ping timeout: 246 seconds]
Bike has joined #lisp
jibanes has quit [Ping timeout: 258 seconds]
jibanes has joined #lisp
wsinatra has joined #lisp
wsinatra_ has joined #lisp
nicktick has joined #lisp
mokulus has quit [Quit: WeeChat 2.9]
hendursa1 has quit [Quit: hendursa1]
hendursaga has joined #lisp
ggole has joined #lisp
EvW1 has quit [Ping timeout: 240 seconds]
notzmv` has joined #lisp
Alloc has quit [Ping timeout: 265 seconds]
Alloc has joined #lisp
notzmv has quit [Ping timeout: 256 seconds]
jonatack has joined #lisp
rumbler31 has joined #lisp
rumbler31 has quit [Remote host closed the connection]
gko_ has joined #lisp
_jrjsmrtn has quit [Ping timeout: 240 seconds]
__jrjsmrtn__ has joined #lisp
wxie has quit [Ping timeout: 244 seconds]
davepdot_ has joined #lisp
davepdotorg has quit [Ping timeout: 258 seconds]
rumbler31_ has joined #lisp
Alloc has quit [Ping timeout: 260 seconds]
davepdot_ has quit [Remote host closed the connection]
davepdotorg has joined #lisp
X-Scale` has joined #lisp
X-Scale has quit [Ping timeout: 256 seconds]
X-Scale` is now known as X-Scale
Alloc has joined #lisp
treflip has quit [Quit: WeeChat 2.6]
yitzi has joined #lisp
Alloc has quit [Ping timeout: 260 seconds]
jackdaniel has quit [Disconnected by services]
narimiran has quit [Ping timeout: 256 seconds]
gko_ has quit [Ping timeout: 264 seconds]
gko_ has joined #lisp
mseddon_ has joined #lisp
orivej has quit [Ping timeout: 260 seconds]
brj has quit [Ping timeout: 260 seconds]
mseddon has quit [Ping timeout: 240 seconds]
brj has joined #lisp
rogersm has joined #lisp
treflip has joined #lisp
sjl_ has joined #lisp
<treflip>
mseddon_: Hi! You was right, it looks like semantic grammar is what I need. Do you know any software that uses this approach or maybe publications that have any code examples? I found only 2 kinds of publications on this topic. The first one is academic stuff that takes a lot of time to grok, and the other one is super simple articles on medium that give only vague understanding of this concept and
<treflip>
don't provide any code examples or guidelines.
<warweasle>
Can I use drakma to fill out a login form? I have to access a vendor site (with permission) to check for new data daily.
<warweasle>
I see a field for :form-data but no examples... or much explaination.
CrazyEddy has quit [Ping timeout: 240 seconds]
cosimone has joined #lisp
<Josh_2>
yes, you send the post params to wherever the form would
<jmercouris>
You can also just uiop and run curl
<jmercouris>
or wget, or whatever other utility you would like
bocaneri has quit [Ping timeout: 258 seconds]
karlosz has quit [Quit: karlosz]
<warweasle>
Josh_2: Would that be in alist form?
<warweasle>
'((:name "joe") (:password "mamma"))?
<warweasle>
I'm confused about uiop
<warweasle>
Oh, run as a shell.
shangul has joined #lisp
hiroaki has joined #lisp
cosimone has quit [Remote host closed the connection]
<jmercouris>
uiop:run-program
<aeth>
warweasle: Depends on what you want with the alist. The alist is actually (foo . bar) to store bar while (foo bar) stores (bar) but you often see that.
Alloc has joined #lisp
shangul has quit [Ping timeout: 265 seconds]
dra_ has joined #lisp
karlosz has joined #lisp
karlosz has quit [Remote host closed the connection]
karlosz has joined #lisp
dra_ is now known as dra
dbohdan has joined #lisp
dbohdan has left #lisp [#lisp]
narimiran has joined #lisp
cosimone has joined #lisp
Lycurgus has quit [Quit: Exeunt]
ggole has quit [Quit: Leaving]
anewuser has joined #lisp
rumbler31 has joined #lisp
<warweasle>
jmercouris: Thanks for reminding me of wget. You just saved me a ton of time.
anewuser has quit [Quit: anewuser]
msk__ has quit [Read error: Connection reset by peer]
msk__ has joined #lisp
msk__ has quit [Max SendQ exceeded]
msk__ has joined #lisp
msk__ has quit [Max SendQ exceeded]
RandoNewbie has quit [Quit: Leaving]
rumbler31 has quit [Remote host closed the connection]
rumbler31 has joined #lisp
rumbler31_ has quit [Ping timeout: 256 seconds]
rumbler31 has quit [Ping timeout: 240 seconds]
brj has quit [Ping timeout: 258 seconds]
<jmercouris>
no problem
narimiran has quit [Quit: leaving]
RandoNewbie has joined #lisp
RandoNewbie has quit [Client Quit]
Jesin has quit [Quit: Leaving]
RandoNewbie has joined #lisp
simendsjo has joined #lisp
liberliver1 has joined #lisp
liberliver has quit [Ping timeout: 244 seconds]
liberliver1 is now known as liberliver
dyelar has quit [Quit: Leaving.]
dyelar has joined #lisp
aeth_ has joined #lisp
aeth has quit [Ping timeout: 240 seconds]
bsd4me has joined #lisp
aeth_ is now known as aeth
bsd4me has quit [Remote host closed the connection]
bsd4me has joined #lisp
yitzi has quit [Read error: Connection reset by peer]