Martin Kuria ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
How to connect to a remote database
Long Description
This may be a dumb question, but how do I connect to a remote database
using postgresql, or rather psql?
I have
Hi,
this is probably not a bug.
with psql you have to use the -h option
e.g.: psql -h mypgserver.mydomain [mydatabase]
and on mypgserver.mydomain computer you have to launch postgresql with
the -i option, telling it to listen for TCP/IP connections, and check
pg_hba.conf for possible restrici
> >> Looks to me like an off-by-one kind of problem in deciding which
> >> timezone applies to midnight of a transition day.
> > The date->timestamp conversion code gets this right, so you might want
> > to look at that.
> Au contraire: the cited examples appear to prove that the
> date->timestamp
Kuba Ober ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Select from array slices doesn't work
Long Description
When I try to select from array slices it gives strange qrPgSql error. Normal array
indexing works, but slices do
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> Looks to me like an off-by-one kind of problem in deciding which
> timezone applies to midnight of a transition day.
> 2) Convert to an integer "Unix system time".
> 3) Rotate by 12 hours (to UTC noon!). This is supposed to ensure that we
> s
[EMAIL PROTECTED] writes:
>> select arr[1:2] from temp
> Error: qrPgSql: Parameter '2' not found
What client frontend are you using? It looks like the frontend is
trying to interpret :2 as a parameter. I seem to recall that
psql had such a bug for a while during 7.0 development, but I
don't thi
> Seems like you could just skip step 3 and call localtime() with fields
> indicating midnight of the specified date. Then use the complete
> localtime result (don't discard any fields) and you should be OK, no?
Pretty sure this won't work, since the complete localtime result will
not be local m
