public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Jeff MacDonald <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: [GENERAL] a bug, the bugs list, and how to break the website search.
Date: Tue, 04 Oct 2005 19:10:13 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Jeff MacDonald <[email protected]> writes:
> 1: Go to the website and type in "now()" into the search box, it will break
> Error in query: Unmatched parenthesis

> 2: On the support page beside pgsql-bugs, it tells us to post in the
> bug reporting form, AND signup for 2 mailing lists. I can't possibly
> see how this would encourage anyone to want to report a bug if they
> have to jump thru these hoops. Just my 2 cents.

The above would better be reported to pgsql-www; perhaps the website
maintainers will notice it here, or perhaps they won't.  (But I've
cc'd that list, so you need not report it again.)

As for the second point, you can *either* subscribe to pgsql-bugs (and
email your report) or use the report form; you need not do both.  If
the website gives the wrong impression then it should be fixed.

> Lets say i have a table with a row that looks something like this..

> articleposted timestamp default now(),

> And yesterday afternoon I did a dump/restore. Now my table reads

> article posted  | timestamp with time zone | default '2005-10-03
> 17:14:25.581388-04'::timestamp with time zone

I don't believe that your default was now().  It was probably more
like
	articleposted timestamp default 'now'
which is a thinko specifically warned against in the documentation.

			regards, tom lane

view thread (4+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: [GENERAL] a bug, the bugs list, and how to break the website search.
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox