Can't edit tables with timestamps
От | Thomas Sandford |
---|---|
Тема | Can't edit tables with timestamps |
Дата | |
Msg-id | 004301c1d5ce$6d5ee780$0300000a@paradise обсуждение исходный текст |
Ответ на | pgAdmin users upgrading to PostgreSQL 7.2 (Dave Page <dpage@vale-housing.co.uk>) |
Список | pgadmin-support |
Given a database created from the following SQL: CREATE TABLE "testtable" ( "id" integer NOT NULL, "mytext" character varying(32), "mytime" timestamp with time zone, Constraint "testtable_pkey" Primary Key ("id") ); COPY "testtable" FROM stdin; 1 \N 2002-03-27 20:15:52.000000+00 2 \N 2002-03-27 20:16:05.187532+00 \. You will find that whilst the 1st record can be edited using pgadmin, any attempt to edit the 2nd results in the message "Could not locate the record for updating in the database!" when you attempt to save your changes. Presumably this is something to do with the non-integer seconds part of the timestamp in the 2nd record. Unfortunately the timestamp in this record is a "real" timestamp created using the now() function, ie typical of real-world data... -- Thomas Sandford | thomas@paradisegreen.co.uk
В списке pgadmin-support по дате отправления: