n
id values are not given explicitly in the INSERT statement)
already whend defining(!) the table in the CREATE TABLE statement ?
Original Message processed by davidĀ® <https://david.tobit.software>
*Re: Problem with SqlState=23505 when inserting rows*15. Januar
2020, 17:51 Uh
statement)
already whend defining(!) the table in the CREATE TABLE statement ?
Original Message processed by davidĀ®
Re: Problem with SqlState=23505 when inserting rows 15. Januar 2020, 17:51 Uhr
Von Michael Lewis
An Werner Kuhnle
Cc PostgreSQL General
On Wed, Jan 15, 2020
On Wed, Jan 15, 2020 at 9:41 AM Werner Kuhnle wrote:
> I've tried to using the newer definition:
> id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
> but that does not solve the problem.
>
> Is there a way to define id columns to that when the database provides
> values,
> it recognizes alread
On 1/15/20 8:40 AM, Werner Kuhnle wrote:
Hi,
I'm new to pg and want to port an application and database from ms sql to pg
v12.
Together with my application a database containing initial standard data
which is needed by the application is also installed.
This is done via execution of SQL scri
Hi,
I'm new to pg and want to port an application and database from ms sql to pg
v12.
Together with my application a database containing initial standard data
which is needed by the application is also installed.
This is done via execution of SQL scripts.
Every table of the db has an id col