| From: | Aftab Hussain <aftab(dot)se(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Patch for PKST timezone |
| Date: | 2010-04-30 10:09:17 |
| Message-ID: | l2y1fe1c5a11004300309r2d510174nf83f7171c830a3e7@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
Please accept attached patch for the following problem.
aftab(at)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$
aftab(at)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./psql postgres
psql (9.0beta1)
Type "help" for help.
postgres=# SHOW timezone;
TimeZone
--------------
Asia/Karachi
(1 row)
postgres=#
postgres=# CREATE TABLE test_table (c1 INT, c2 TIMESTAMP DEFAULT
timeofday()::TIMESTAMP);
CREATE TABLE
postgres=# INSERT INTO test_table VALUES (1);
ERROR: invalid input syntax for type timestamp: "Fri Apr 30 15:36:43.906075
2010 PKST"
postgres=#
And here is a little bit information about the system I am using.
aftab(at)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ uname -a
Linux aftab-laptop 2.6.31-20-generic #58-Ubuntu SMP Fri Mar 12 05:23:09 UTC
2010 i686 GNU/Linux
aftab(at)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$
aftab(at)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./pg_config
--version
PostgreSQL 9.0beta1
aftab(at)aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$
Thanks,
--
Aftab Hussain,
EntepriseDB http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| pkst.patch | text/x-patch | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexey Klyukin | 2010-04-30 11:06:46 | missing file in git repo |
| Previous Message | zb | 2010-04-30 08:58:22 | Synchronous replication patch built on SR |