Bug? Insert into new Datatype 7.0.x
От | Michael Miyabara-McCaskey |
---|---|
Тема | Bug? Insert into new Datatype 7.0.x |
Дата | |
Msg-id | 007c01c0608a$6b6f1810$aa00a8c0@ncc1701e обсуждение исходный текст |
Ответы |
Re: Bug? Insert into new Datatype 7.0.x
|
Список | pgsql-general |
Hello all, I have been experiencing a strange problem. I did a import into "table1", and for the sake of not having complaints, all fields are set to "text". I then created a "table2" again with all types set to text, and inserted a distinct set of the records from table1 into table2. No problems. However, when I created "table3" which I used the correct data types (oid, float4, float4), and selected the 3 specific rows from table2, and inserted them into table3... The query ran for a little while, and then the backend crashes... I fumbled around for a while, but finally recreated table3 as (oid, text, text), and it worked fine... My question what caused the backend to crash? The data I was inserting into table3, was the actual oid from table2, column 2 and column 3 were number values of the form "x.xxx", or a null value. Any thoughts? -Michael Miyabara-McCaskey
В списке pgsql-general по дате отправления: