Ygthkb

multiple null checks in Java8

Is there a way to pause a running process on Linux systems and resume later?

Why is Shelob considered evil?

Is it possible to detect 100% of SQLi with a simple regex?

Will linear voltage regulator step up current?

How to achieve physical gender equality?

Buying a "Used" Router

How can a kingdom keep the secret of a missing monarch from the public?

Is Apex Sometimes Case Sensitive?

Stream.findFirst different than Optional.of?

Why does finding small effects in large studies indicate publication bias?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Ramanujan's radical and how we define an infinite nested radical

Reading source code and extracting json from a url

How does the income of your target audience matter for logo design?

Have the conservatives lost the working majority and if so, what does this mean?

Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Why didn't Lorentz conclude that no object can go faster than light?

TikZ-Tree with asymmetric siblings

Is Screenshot Time-tracking Common?

The Longest Chess Game

In a world with multiracial creatures, what word can be used instead of mankind?

Which was the first story to feature space elevators?

What is the optimal pipeline for updating table on FK value in Postgresql?

How do I insert a row which contains a foreign key?Inserting into related tablesPostgres multiple joins slow query, how to store default child recordWhat happens to the index of a primary key after a DROP CONSTRAINT?PostgreSQL - insert/update violates foreign key constraintsPossible to have nested inserts in Postgres 8.4?Simple PostgreSQL lookup table is inexplicably slowType of an id field that references another id fieldInserting in PostgreSQL Foreign Table Violates Primary Key Constraint10postgres: Upgraded RDS Postgres from 9.4 - 9.6, id fields went from SERIAL to INTPostgreSQL 9.5 query performance depends on JOINed column in SELECT clauseStandard behaviour in executing multiple alter statements in Postgres

0

Hi I have the following schema in my app.

-- Table: Investment_round

CREATE TABLE Investment_round (

    id serial  NOT NULL,

    round_type varchar(50)  NOT NULL,

    money bigint  NOT NULL,

    Project_id int  NOT NULL,

    CONSTRAINT Investment_round_pk PRIMARY KEY (id)

);



-- Table: Investor

CREATE TABLE Investor (

    id serial  NOT NULL,

    name int  NOT NULL,

    url int  NULL,

    Investment_round_id int  NOT NULL,

    CONSTRAINT Investor_pk PRIMARY KEY (id)

);



-- Reference: Investment_round_startups_page (table: Investment_round)

ALTER TABLE Investment_round ADD CONSTRAINT Investment_round_startups_page

    FOREIGN KEY (Project_id)

    REFERENCES startups_page (angel_id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;



-- Reference: Investor_Investment_round (table: Investor)

ALTER TABLE Investor ADD CONSTRAINT Investor_Investment_round

    FOREIGN KEY (Investment_round_id)

    REFERENCES Investment_round (id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;

I'm a bit confused about optimal pipeline of inserting the data. Suppose that firstly I need to insert the data to Investment_round table.
Then I need to insert the data to Investor table with corresponding Investment_round_id

It seems that the reasonable way is to store Investment_round_id and then to update Investor table. But how can I achieve that without making an external request?

postgresql

share|improve this question

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You can insert into both tables in one statement in Postgres. See a similar question: dba.stackexchange.com/questions/46410/…
  
  – ypercubeᵀᴹ
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How can I do it? Could you elaborate, please?
  
  – Daniel Chepenko
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, this is a better example: dba.stackexchange.com/questions/89451/…
  
  – ypercubeᵀᴹ
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ANd this: stackoverflow.com/questions/22775109/…
  
  – ypercubeᵀᴹ
  3 hours ago
  

  
  
  
  

add a comment | 

0

Hi I have the following schema in my app.

-- Table: Investment_round

CREATE TABLE Investment_round (

    id serial  NOT NULL,

    round_type varchar(50)  NOT NULL,

    money bigint  NOT NULL,

    Project_id int  NOT NULL,

    CONSTRAINT Investment_round_pk PRIMARY KEY (id)

);



-- Table: Investor

CREATE TABLE Investor (

    id serial  NOT NULL,

    name int  NOT NULL,

    url int  NULL,

    Investment_round_id int  NOT NULL,

    CONSTRAINT Investor_pk PRIMARY KEY (id)

);



-- Reference: Investment_round_startups_page (table: Investment_round)

ALTER TABLE Investment_round ADD CONSTRAINT Investment_round_startups_page

    FOREIGN KEY (Project_id)

    REFERENCES startups_page (angel_id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;



-- Reference: Investor_Investment_round (table: Investor)

ALTER TABLE Investor ADD CONSTRAINT Investor_Investment_round

    FOREIGN KEY (Investment_round_id)

    REFERENCES Investment_round (id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;

I'm a bit confused about optimal pipeline of inserting the data. Suppose that firstly I need to insert the data to Investment_round table.
Then I need to insert the data to Investor table with corresponding Investment_round_id

It seems that the reasonable way is to store Investment_round_id and then to update Investor table. But how can I achieve that without making an external request?

postgresql

share|improve this question

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You can insert into both tables in one statement in Postgres. See a similar question: dba.stackexchange.com/questions/46410/…
  
  – ypercubeᵀᴹ
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How can I do it? Could you elaborate, please?
  
  – Daniel Chepenko
  4 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, this is a better example: dba.stackexchange.com/questions/89451/…
  
  – ypercubeᵀᴹ
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  ANd this: stackoverflow.com/questions/22775109/…
  
  – ypercubeᵀᴹ
  3 hours ago
  

  
  
  
  

add a comment | 

Hi I have the following schema in my app.

-- Table: Investment_round

CREATE TABLE Investment_round (

    id serial  NOT NULL,

    round_type varchar(50)  NOT NULL,

    money bigint  NOT NULL,

    Project_id int  NOT NULL,

    CONSTRAINT Investment_round_pk PRIMARY KEY (id)

);



-- Table: Investor

CREATE TABLE Investor (

    id serial  NOT NULL,

    name int  NOT NULL,

    url int  NULL,

    Investment_round_id int  NOT NULL,

    CONSTRAINT Investor_pk PRIMARY KEY (id)

);



-- Reference: Investment_round_startups_page (table: Investment_round)

ALTER TABLE Investment_round ADD CONSTRAINT Investment_round_startups_page

    FOREIGN KEY (Project_id)

    REFERENCES startups_page (angel_id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;



-- Reference: Investor_Investment_round (table: Investor)

ALTER TABLE Investor ADD CONSTRAINT Investor_Investment_round

    FOREIGN KEY (Investment_round_id)

    REFERENCES Investment_round (id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;

I'm a bit confused about optimal pipeline of inserting the data. Suppose that firstly I need to insert the data to Investment_round table.
Then I need to insert the data to Investor table with corresponding Investment_round_id

It seems that the reasonable way is to store Investment_round_id and then to update Investor table. But how can I achieve that without making an external request?

postgresql

share|improve this question

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083

-- Table: Investment_round

CREATE TABLE Investment_round (

    id serial  NOT NULL,

    round_type varchar(50)  NOT NULL,

    money bigint  NOT NULL,

    Project_id int  NOT NULL,

    CONSTRAINT Investment_round_pk PRIMARY KEY (id)

);



-- Table: Investor

CREATE TABLE Investor (

    id serial  NOT NULL,

    name int  NOT NULL,

    url int  NULL,

    Investment_round_id int  NOT NULL,

    CONSTRAINT Investor_pk PRIMARY KEY (id)

);



-- Reference: Investment_round_startups_page (table: Investment_round)

ALTER TABLE Investment_round ADD CONSTRAINT Investment_round_startups_page

    FOREIGN KEY (Project_id)

    REFERENCES startups_page (angel_id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;



-- Reference: Investor_Investment_round (table: Investor)

ALTER TABLE Investor ADD CONSTRAINT Investor_Investment_round

    FOREIGN KEY (Investment_round_id)

    REFERENCES Investment_round (id)  

    NOT DEFERRABLE 

    INITIALLY IMMEDIATE

;

share|improve this question

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083

share|improve this question

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083

asked 4 hours ago

Daniel ChepenkoDaniel Chepenko

1083