Re: [SQL] Problems with ODBC connections

2012-03-04 Thread Jasen Betts
On 2012-03-02, Sandeep Reddy  wrote:
> --e89a8ffba9b7723ad004ba47c368
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi, The Error message is like this
>
> "Could not connect to server; A connection attempt failed because the
> connected party did not properly respond after a periord..."
> I have run postgres with option -i and changed the pg_hba.conf the IPv4
> details to 0.0.0.0.0/0 to accept form all clients still facing the same
> issues.
> Any suggestions?

listen_addresses in postgresql.conf

-- 
⚂⚃ 100% natural


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


Re: [SQL] date arithmetic with columns

2012-03-04 Thread hari . fuchs
Peter Faulks  writes:

> I have two columns in two distinct tables, one is the starting time of
> an event, timestamp without time zone. Data is the utc datetime (for
> sorting across time zones), the other is the number of minutes to add.

Maybe I'm missing something, but why don't you just use timestamp with
timezone instead?


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql