I'm converting all my yesql code to hugsql, and I've run into this very strange bug. N

Here is the sql table, if it helps: <div class="snippet-clipboard-content notransl

Cryptic no hstore extension installed exception about hugsql HOT 4 CLOSED

layerware commented on July 24, 2024

Cryptic no hstore extension installed exception

from hugsql.

Comments (4)

csummers commented on July 24, 2024

That is strange. Can you show the output of the -sqlvec version of the function with the data you are passing in?

from hugsql.

robinheghan commented on July 24, 2024

Tested with both clojure.jdbc and clojure.java.jdbc adapter.

Have also tried with and without the joda.time instance.

["INSERT INTO shows (tvdb_id, name, description, banner, poster, network, next_update)
VALUES (?, ?, ?, ?, ?, ?, ?);" 
278518 
"Last Week Tonight with John Oliver" 
"Last Week Tonight with John Oliver is an American late-night talk and news satire television program.  \nL.W.T draws its comedy and satire from recent news stories, political figures, media organizations, pop culture and often aspects of the show itself." 
"graphical/278518-g3.jpg" 
"posters/278518-2.jpg" 
"HBO" 
#object[org.joda.time.DateTime 0xef92810 "2015-11-09T00:00:00.000Z"]]

from hugsql.

robinheghan commented on July 24, 2024

Here is the sql table, if it helps:

--:name m-setup-shows! :!
CREATE TABLE shows (
       id SERIAL PRIMARY KEY,
       tvdb_id int UNIQUE NOT NULL,
       name text NOT NULL,
       description text,
       banner text,
       poster text,
       network text,
       next_update timestamp with time zone
);

from hugsql.

robinheghan commented on July 24, 2024

So sorry about this. I read the stacktrace wrong. The problem was another query where I passed a map instead of a value. HugSQL could probably use better error-handling, but I see you already have that on your todo-list :)

from hugsql.

Recommend Projects