Jakub Hamadej
Jakub Hamadej
I am currently facing this issue as well. Some of the queries take a long time to complete, so users are tempted to close/duplicate application windows or move through the...
You can define multiple **with** clauses in the Knex builder and access them however you wish, for example using the **crossJoin**, if desired. ```javascript knex .with('aCTE', knex.raw('...')) .with('bCTE', knex.raw('...')) .select()...
Hi damaon, are you sure the query is not taking so long by itself? I would not necessarily bring the pool into this yet. Have you tried running the query...
Hi pokhiii. You are actually creating an invalid query. The following is invalid SQL code in postgres: ```sql select nextval("serial") ``` To make the query valid, you need to use...
Hi Linksku! By using `?` characters in a raw query, you are actually binding them as parameters - effectively not interpreting them as raw in the said query. You can't...
Hi eyea. I am not sure what you are referring to. Knex is very much able to connect to a remote database, as well as a container, by including the...
Hi eugenelet. Actually, you are not allowed to use `?` just like that. On its own, it has a special meaning in a `Knex raw` query - that of a...
We've just upgraded to a newer version of Node and Knex along with it. Can confirm that the issue originates from the reported version **0.14.5** and [#1390](https://github.com/tgriesser/knex/pull/1390/commits/50f2752b4927eda1279fbc130667cfed6c2fad7f). It caused us...
Either way, the behavior is inconsistent right now. We allow our application to be run above Oracle or Mssql databases, but this issue is not present with Oracle - not...
Fair enough, you make a valid point. In that case throwing an error sounds indeed like the desired behavior.