Search Postgresql Archives

a bug, the bugs list, and how to break the website search.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I very rarely have reason to post to this list so I was reluctant to
sign up for such heavy traffic, but I have a few things to bring up
and they're all 'general'

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.

3: An actual but that I'll repeat here even tho I've already posted it
as bug # 1938

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

Which means it's interpreting the now() instead of just copying it.

Kind of a pain when I just restored 75 databases with many many
"default now()'s" as you can imagine.

Thanks in advance.

--
Jeff MacDonald
http://www.halifaxbudolife.ca
http://www.nintai.ca

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux