| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | pawel(dot)jan(dot)podgorski(at)gmail(dot)com |
| Subject: | BUG #17745: RETURNING after INSERT does not return the same structure of response |
| Date: | 2023-01-11 11:22:39 |
| Message-ID: | 17745-f71067ba7f24e1cb@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17745
Logged by: Paweł Podgórski
Email address: pawel(dot)jan(dot)podgorski(at)gmail(dot)com
PostgreSQL version: 14.5
Operating system: Windows 11
Description:
When I try to "INSERT INTO .... RETURNING (channel)" the output is:
channel
--------------
3o0mNjcS4CMr
(1 row)
But RETURNING multiple attributes produces another output:
"INSERT INTO .... RETURNING ( channel , last_processing_timestamp,
last_successful_processing_timestamp )"
row
--------------------------------------------------------------------------------
(3o0mNjcS4CMr,"2023-01-11 12:01:40.016988+01","2023-01-11
12:01:40.016988+01")
(1 row)
The output that is expected is similar to:
"INSERT INTO .... RETURNING channel , last_processing_timestamp,
last_successful_processing_timestamp "
channel | last_processing_timestamp |
last_successful_processing_timestamp
--------------+-------------------------------+--------------------------------------
3o0mNjcS4CMr | 2023-01-11 12:01:40.016988+01 | 2023-01-11
12:01:40.016988+01
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2023-01-11 13:22:26 | Re: BUG #17745: RETURNING after INSERT does not return the same structure of response |
| Previous Message | Julien Rouhaud | 2023-01-11 09:40:26 | Re: TR: Issue: --exclude-schema flag not working with pgrestore |