From: Stef <svb@ucs.co.za>
To: pgsql-sql@postgresql.org
Subject: 'invalid' value in timestamp with timezone.
Date: Mon, 3 Nov 2003 16:58:04 +0200
Message-ID: <20031103165804.4aab8385.svb@ucs.co.za> (raw)
Hi all,
I've noticed for the first time in some 7.1.2 databases that
I use, that somebody/something managed to insert a literal
alpha value of 'invalid' into 'timestamp with timezone' columns.
I tested it myself, and it worked :
test712=# create table bob (field timestamp);
CREATE
test712=# \d bob
Table "bob"
Attribute | Type | Modifier
-----------+--------------------------+----------
field | timestamp with time zone |
test712=# insert into bob values('invalid');
INSERT 3885934 1
On 7.3.4 it gives me :
test734=> insert into bob2 values('invalid');
ERROR: TIMESTAMP WITH TIME ZONE 'invalid' no longer supported
but other strings gave me the same error on both db's :
test734=> insert into bob2 values('valid');
ERROR: Bad timestamp external representation 'valid'
I looked in the documentation and on the net, but cannot find
much reference to this "ex-feature"
I'm 80% sure no one actually inserted these 'invalid' values into tables,
and what I need to know is :
What else can insert a value of 'invalid' into a 7.1.2
"timestamp with timezone" type column.
Was there a function or something similar?
Regards
Stef
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: svb@ucs.co.za
Subject: Re: 'invalid' value in timestamp with timezone.
In-Reply-To: <20031103165804.4aab8385.svb@ucs.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox