> -Original Message-
> From: Thomas Sandford [mailto:[EMAIL PROTECTED]]
> Sent: 28 March 2002 12:11
> To: Dave Page
> Subject: Re: [pgadmin-support] Can't edit tables with timestamps
>
>
> [ ... problems editing tables containing timestamps ... ]
> >
> -Original Message-
> From: Thomas Sandford [mailto:[EMAIL PROTECTED]]
> Sent: 28 March 2002 11:33
> To: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Can't edit tables with timestamps
>
>
> "Dave Page" <[EMAIL PROTECTED]> wrote:
"Dave Page" <[EMAIL PROTECTED]> wrote:
> Thomas Sandford [mailto:[EMAIL PROTECTED]] wrote:
> > [... database table using timestamp field ...]
> > COPY "testtable" FROM stdin;
> > 1 \N 2002-03-27 20:15:52.00+00
> > 2 \N 2002-03-27 20:16:05.187532+00
> > \.
> >
> > You will
Le Mercredi 27 Mars 2002 22:56, Dave Page a écrit :
> Yes, this is a bizarre 'feature' that's been bugging me on and off for
> years now. Currently, pgAdmin builds an update query by generating a WHERE
> clause using all available data. Unfortunately it periodically fails when
> there are timestam
> -Original Message-
> From: Thomas Sandford [mailto:[EMAIL PROTECTED]]
> Sent: 27 March 2002 20:32
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Can't edit tables with timestamps
>
>
> Given a database created from the following SQL:
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 200
