Re: Re-2: Problem with SqlState=23505 when inserting rows

2020-01-16 Thread Adrian Klaver
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

Re-2: Problem with SqlState=23505 when inserting rows

2020-01-16 Thread Werner Kuhnle
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

Re: Problem with SqlState=23505 when inserting rows

2020-01-15 Thread Michael Lewis
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

Re: Problem with SqlState=23505 when inserting rows

2020-01-15 Thread Adrian Klaver
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

Problem with SqlState=23505 when inserting rows

2020-01-15 Thread Werner Kuhnle
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