ge-
From: Robert Haas [mailto:robertmh...@gmail.com]
Sent: Monday, March 21, 2011 11:50 AM
To: j...@blackskytech.com
Cc: Tom Lane; Kevin Grittner; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] TO_CHAR(timestamptz,datetimeformat) wrong after DST
change
On Mon, Mar 21, 2011 at 9:13 AM, Jonathan
1 row)
bucardo@Cloud-DB1:~$ psql beta_cms_main -c "select now();"
now
---
2011-03-21 09:23:03.079692-04
(1 row)
bucardo@Cloud-DB1:~$ logout
postgres@Cloud-DB1:~$ psql beta_cms_main -c "SHOW TIME ZONE;"
TimeZone
--
EST
mailto:t...@sss.pgh.pa.us]
Sent: Friday, March 18, 2011 12:47 PM
To: Kevin Grittner
Cc: j...@blackskytech.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] TO_CHAR(timestamptz,datetimeformat) wrong after DST
change
"Kevin Grittner" writes:
> "Jonathan Brinkman" wrote:
ne 'America/New_York'; and retried the select
now(), and now it is correct.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, March 18, 2011 11:42 AM
To: j...@blackskytech.com
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] TO_CHAR(timestamptz,dat
My TO_CHAR function is now an hour off thanks to Daylight Savings Time.
The dates are correct (I'm in EST: TZ=-04) but my function now returns TIME
an hour early.
(prior to DST we were TZ=-05).
TIMESTAMPTZ data (v_dt): 2011-03-17 18:21:50-04
FUNCTION SNIPPET: to_char(v_dt, 'mm/dd/ hh:mi AM')
> I just made the wording more generic
Thanks much.
ˉ
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
!
JB
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Friday, February 25, 2011 11:15 AM
To: j...@blackskytech.com; pgsql-bugs@postgresql.org; 'Tom Lane'
Subject: RE: [BUGS] LOCALTIMESTAMP has wrong time zone
"Jonathan Brinkman" wrote:
>
0) WITHOUT TIME ZONE DEFAULT
'now'::text::timestamp without time zone,
CONSTRAINT "pk_general_comments_commentid" PRIMARY KEY("commentid"),
) WITH OIDS;
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, February 24, 201
35 PM
To: Kevin Grittner
Cc: j...@blackskytech.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] LOCALTIMESTAMP has wrong time zone
"Kevin Grittner" writes:
> "Jonathan Brinkman" wrote:
>> My default timestamps in my database all are +5 hours in the future
> Can you c
Greetings
I'm in Florida (Eastern Time Zone / New York), using Ubuntu 10.04LTS /
Postgresql 8.4.7.
My default timestamps in my database all are +5 hours in the future
(probably GMT), unless I code the 'EST' time zone into the field's default
(timezone('EST'::text, now())).If I use now() it is +5 h
Chapter 35.4, paragraph 4, of the PostgreSQL 9.0.1 Documentation says:
Any collection of commands in the SQL language can be packaged together and
defined as a function. Besides SELECT queries, the commands can include data
modification queries (INSERT, UPDATE, and DELETE), as well as other SQL
age put out by configure.
I totally agree with you that clarity of error messages are very
important. I think a hybrid approach will work well: first check for
Perl 5, then use the proposed method by Tim. If Perl 5 is not found,
then some loud message can be printed out, like:
Postgres only works
Howdy,
On Mon, Feb 22, 2010 at 12:07 PM, Tom Lane wrote:
> Alex Hunsaker writes:
>> On Mon, Feb 22, 2010 at 10:57, Jonathan wrote:
>>> This is perl 5, version 11, subversion 4 (v5.11.4-114-ga4cc961*) built for
>>> x86_64-linux
>
> Ugh. Can't they
The following bug has been logged online:
Bug reference: 5339
Logged by: Jonathan "Duke" Leto
Email address: jonat...@leto.net
PostgreSQL version: master 0f50d482
Operating system: CentOS 5.4 (Linux kernel 2.6.18)
Description:Version of Perl detected i
The following bug has been logged online:
Bug reference: 5148
Logged by: Jonathan Hayward
Email address: jonathan.hayw...@pobox.com
PostgreSQL version: 8.1.x
Operating system: Gentoo
Description:Email to pgsql-bugs@postgresql.org bounces:
Details:
I sent the
The following bug has been logged online:
Bug reference: 4891
Logged by: Jonathan Camilleri
Email address: camilleri@gmail.com
PostgreSQL version: 8.3
Operating system: Windows Server 2008
Description:postgresql-8.3-604.jdbc4.jar - failed to load manifest
Details
The following bug has been logged online:
Bug reference: 4738
Logged by: Jonathan Barnhart
Email address: jdbarnh...@yahoo.com
PostgreSQL version: 8.3.7
Operating system: WinXP, Vista
Description:Cannot reconnect to shared memory
Details:
This bug seems to have
The following bug has been logged online:
Bug reference: 4027
Logged by: Jonathan Guthrie
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.0
Operating system: Debian Gnu/Linux "unstable" 2.6.24
Description:backslash escaping not disabled in plpgs
The following bug has been logged online:
Bug reference: 3234
Logged by: Jonathan Vanasco
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: freebsd 6.1 , osx 10.4.9
Description:pg_dump uses the first version of a primary key's name
The following bug has been logged online:
Bug reference: 2873
Logged by: Jonathan Hull
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1 / 8.2
Operating system: Linux
Description:Function that returns an empty set with a 'not null'
domain errors in 8
On 4/2/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jonathan Ellis" <[EMAIL PROTECTED]> writes:> I have many many instances of these two problems in pg_dump's output:> 1) function code don't seem to be taken into account for dependencies
No, it isn't, and t
The following bug has been logged online:
Bug reference: 2369
Logged by: Jonathan Ellis
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: linux
Description:pg_dump function dependencies
Details:
I have many many instances of these two
The following bug has been logged online:
Bug reference: 2288
Logged by: Jonathan Albert C. Vallar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Centronix Linux
Description:bad value for type timestamp using JDBC Type2 Driver
version
The following bug has been logged online:
Bug reference: 1452
Logged by: Jonathan Chen
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows Server 2003
Description:psql and other programs don't offer a password prompt,
so I can&#x
The following bug has been logged online:
Bug reference: 1425
Logged by: Jonathan Pool
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.0
Operating system: Red Hat Enterprise Linux 3
Description:False failure message on boot start
Details:
When /etc/init.d
Not sure if I am writing to the correct list but this was the address it
gave at the top of the "Supported Platforms" in the docs.
when I run: ./configure --without-readline, I get the following error that
aborts the config process:
"checking types of arguments for accept()... configure: error: c
Not sure if I am writing to the correct list but this was the address it
gave at the top of the "Supported Platforms" in the docs.
when I run: ./configure --without-readline, I get the following error that
aborts the config process: "checking types of arguments for accept()...
configure: error: co
The JDBC driver that ships with PostgreSQL 7.4.1 doesn't insert floats
of value NaN. As it uses Float.toString(x) to convert the value for
insertion into the database, it tries to insert NaN instead of 'NaN' and
gets the error "Attribute 'nan' not found". The same bug occurs for
doubles and w
is a strange race condition in the make process. Of
course, the recent power outage in the area (that didn't affect us)
might've been a cause as well.
I apologize that I couldn't ease your pain, Tom. I know how it feels to see
the same bug pop up occasionally, only to be so
Y );
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pkey'
for table 'test'
ERROR: relation named "test_pkey" already exists
- --
Jonathan Gardner
[EMAIL PROTECTED]
Live Free, Use Linux!
-BEGIN PGP SIGNATURE-
Ver
> A lot of this looks like problems with configure using the wrong cpp
> to do C preprocessor tests. In particular the syntax errors in the
I tried setting it manually and that fixed it. I couldn't get configure
to work using either method of getting at MIPSpro's preprocessor (/lib/cpp
and /usr
ble? Did you reload a dump file (like the one that
> referenced it)?
I'm afraid I don't understand the question. I dropped it with drop table.
Although thinking back on it, the drop may have been on 7.0.2. Can't
remember whether that was before or after upgrading.
ger RI_ConstraintTrigger_44349 on users; ERROR:
DropTrigger: there is no trigger ri_constrainttrigger_44349 on relation
users
It's in pg_trigger all right -- and with tgrelid = (select relfilenode from
pg_class where relname = 'users') -- but it won't drop.
33 matches
Mail list logo
