Can't edit tables with timestamps

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

In response to

Browse pgadmin-support by date

  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

Browse pgsql-hackers by date

  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

Browse pgsql-odbc by date

  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