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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Quotes and functions
Следующее
От: "Revista Melhor Vida & Trabalho"
Дата:
Сообщение: