SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 08:29 AM
| ||||
| ||||
 BUG #1437: converting column from text to int4 requires USING The following bug has been logged online: Bug reference: 1437 Logged by: Kim Hansen Email address: k@oek.dk PostgreSQL version: 8.0.0 Operating system: Windows Description: converting column from text to int4 requires USING Details: When running the input below the 3rd line gives an error but the 4th line works. I would expect that a::int4 was applyed by default and because of that the USING shouldn't be nessesary. == Input == CREATE TABLE test ( a text ); INSERT INTO test VALUES ( '1' ); ALTER TABLE test ALTER COLUMN a TYPE int4; ALTER TABLE test ALTER COLUMN a TYPE int4 USING (a::int4); DROP TABLE test; == Output== public=> \i bug.txt CREATE TABLE INSERT 25508 1 psql:bug.txt:3: ERROR: column "a" cannot be cast to type "int4" ALTER TABLE DROP TABLE public=> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org      |
 |
« BUG #1414: DOC - pl/Perl hash tags missing
|
Re: BUG #1437: converting column from text to int4 requires USING »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:23 AM.
