I need to update the database schema to add a new table based on an original table. The existing table is the following: create table shop_image ( id SERIAL UNIQUE primary key, shop_fk int references vsm_shop (id) on delete cascade, path varchar(255), title varchar(80), sentence text, placement varchar(6), sequence int2 ); and the new table is the following: create table shop_image_narrative ( image_fk int references shop_image (id) on delete cascade, lang char(2) not null, title varchar(80), sentence text, placement varchar(6) ); When I run the following query INSERT INTO shop_image_narrative (image_fk,title,sentence,placement) select (id,title,sentence,placement) from shop_image; to move data from the existing table to the new one, I run into the following error 22:08:06 [INSERT - 0 row(s), 0.000 secs] [Error Code: 0, SQL State: 42804] ERROR: column "image_fk" is of type integer but expression is of type record It also said that I can resolve it by either casting and rewriting. I don't see how I can cast the integer since both data types are defined as integer. How to rewrite the query? My another question is how to insert a constant to a field while the rest data from the data in another table? Thanks for your information in advance. - v -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
