From: | "Thomas Sandford" <thomas(at)paradisegreen(dot)co(dot)uk> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Can't edit tables with timestamps |
Date: | 2002-03-27 20:31:51 |
Message-ID: | 004301c1d5ce$6d5ee780$0300000a@paradise |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-hackers pgsql-odbc |
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(at)paradisegreen(dot)co(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Revista Melhor Vida & Trabalho | 2002-03-27 21:40:26 | |
Previous Message | Dave Page | 2002-03-27 15:28:14 | Re: Quotes and functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-03-27 20:54:39 | Problem with do_quote_ident() |
Previous Message | Stephan Szabo | 2002-03-27 18:40:43 | Re: RI triggers and schemas |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2002-03-27 20:37:25 | Re: psqlODBC ODBC3.0/Column Names |
Previous Message | Thomas Sandford | 2002-03-27 15:21:08 | Quotes and functions |