Ufdjrw

The most efficient algorithm to find all possible integer pairs which sum to a given integer

Freedom of speech and where it applies

I2C signal and power over long range (10meter cable)

Does "Dominei" mean something?

Perfect riffle shuffles

Simple image editor tool to draw a simple box/rectangle in an existing image

Blender - show edges angles “direction”

Can the harmonic series explain the origin of the major scale?

Giant Toughroad SLR 2 for 200 miles in two days, will it make it?

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Is there an wasy way to program in Tikz something like the one in the image?

Java - What do constructor type arguments mean when placed *before* the type?

Word describing multiple paths to the same abstract outcome

My boss asked me to take a one-day class, then signs it up as a day off

Lifted its hind leg on or lifted its hind leg towards?

Is infinity mathematically observable?

Meta programming: Declare a new struct on the fly

Can a malicious addon access internet history and such in chrome/firefox?

Teaching indefinite integrals that require special-casing

What is the opposite of 'gravitas'?

Proof of Lemma: Every integer can be written as a product of primes

Simulating a probability of 1 of 2^N with less than N random bits

How to color a zone in Tikz

What will be the benefits of Brexit?

ScalikeJDBC: How to do select or insert query aginst a Postgresql db?

PostgreSQL “DESCRIBE TABLE”Show tables in PostgreSQLInsert, on duplicate update in PostgreSQL?How can I drop all the tables in a PostgreSQL database?postgresql: INSERT INTO … (SELECT * …)How to start PostgreSQL server on Mac OS X?How to exit from PostgreSQL command line utility: psqlHow to change PostgreSQL user password?Which version of PostgreSQL am I running?Insert query in PostgreSQL

1

1

I have the following SQL code I would to execute against a Postgresql db:

 sql"""WITH s AS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 ), i AS (
 INSERT INTO $tableName ($columnName)
 SELECT $value
 WHERE NOT EXISTS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 )
 RETURNING id
 )
 SELECT id
 FROM i
 UNION ALL
 SELECT id
 FROM s
 """

If I use update or updateAndRetrieveGeneratedKey within a localTx I get org.postgresql.util.PSQLException: A result was returned when none was expected.. If I use single within readOnly I get something like ... cannot perform an insert in a read only query.
What is the proper way to go about this?

postgresql scala scalikejdbc

share|improve this question

asked Mar 7 at 10:20

zaxmezaxme

389214

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  will discuss this question here: github.com/scalikejdbc/scalikejdbc/issues/996
  
  – Kazuhiro Sera
  Mar 9 at 0:32
  

  
  
  
  

add a comment | 

1

1

I have the following SQL code I would to execute against a Postgresql db:

 sql"""WITH s AS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 ), i AS (
 INSERT INTO $tableName ($columnName)
 SELECT $value
 WHERE NOT EXISTS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 )
 RETURNING id
 )
 SELECT id
 FROM i
 UNION ALL
 SELECT id
 FROM s
 """

If I use update or updateAndRetrieveGeneratedKey within a localTx I get org.postgresql.util.PSQLException: A result was returned when none was expected.. If I use single within readOnly I get something like ... cannot perform an insert in a read only query.
What is the proper way to go about this?

postgresql scala scalikejdbc

share|improve this question

asked Mar 7 at 10:20

zaxmezaxme

389214

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  will discuss this question here: github.com/scalikejdbc/scalikejdbc/issues/996
  
  – Kazuhiro Sera
  Mar 9 at 0:32
  

  
  
  
  

add a comment | 

I have the following SQL code I would to execute against a Postgresql db:

 sql"""WITH s AS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 ), i AS (
 INSERT INTO $tableName ($columnName)
 SELECT $value
 WHERE NOT EXISTS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 )
 RETURNING id
 )
 SELECT id
 FROM i
 UNION ALL
 SELECT id
 FROM s
 """

If I use update or updateAndRetrieveGeneratedKey within a localTx I get org.postgresql.util.PSQLException: A result was returned when none was expected.. If I use single within readOnly I get something like ... cannot perform an insert in a read only query.
What is the proper way to go about this?

postgresql scala scalikejdbc

share|improve this question

asked Mar 7 at 10:20

zaxmezaxme

389214

 sql"""WITH s AS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 ), i AS (
 INSERT INTO $tableName ($columnName)
 SELECT $value
 WHERE NOT EXISTS (
 SELECT id
 FROM $tableName
 WHERE $columnName = $value
 )
 RETURNING id
 )
 SELECT id
 FROM i
 UNION ALL
 SELECT id
 FROM s
 """

share|improve this question

asked Mar 7 at 10:20

zaxmezaxme

389214

share|improve this question

asked Mar 7 at 10:20

zaxmezaxme

389214

asked Mar 7 at 10:20

zaxmezaxme

389214

asked Mar 7 at 10:20

zaxmezaxme

389214