2012-05-12 06:29 keltezéssel, Alexander Farber írta:
Or should I edit pg_hba.conf and restart the process?
hostallpostgres127.0.0.1/32md5
hostallall 0.0.0.0/0reject
Only postgres user is allowed to connect. You don't need
to restart the server, one of th
On 05/11/2012 11:43 PM, Frank Lanitz wrote:
> Hi folks,
>
> I did check the documentation but seem to didn't found the best way to
> use plpythonu with a variable inside a query.
> Let's say I want to run this query
> SELECT id FROM some_table WHERE date=
> How a CREATE FUNCTION stateent have to l
On Sat, 12 May 2012 07:11:08 -0700
Adrian Klaver wrote:
> Something like this?:
>
> create or replace function date_test(some_date date) returns void as
> $Body$
> date_plan = plpy.prepare("select id_fld from date_test where date_fld
> = $1", ["date"]) date_rs = plpy.execute(date_plan,[some_date
On 2012-05-02, Matrix Guy wrote:
>
> I'm referring to US time zones here.=A0 I'd like to output a time stamp field
> in a specified time zone.=A0 I'd also like to display the time zone
(e.g. EDT) at the end.=A0 Ideally,
trivially this is done by issuing set commands
set session timezone to 'ame
On 2012-05-12, Alexander Farber wrote:
> Hello,
>
> In PostgreSQL 8.4.9 with pgbouncer 1.3.4 in
> pool_mode = session (but some users connect to the
> database directly) - when I login as "super user" with
>
>psql -U postgres -W postgres
>
> What is the command please to disconnect all
> "norm
On 2012-05-04, John R Pierce wrote:
> On 05/03/12 10:18 PM, David Johnston wrote:
>> On May 3, 2012, at 20:20, EllyR wrote:
>>
>>> > Yes you are right, I have read that it is not that reliable, but I have
>>> > to do
>>> > something for that, what would be your suggestion for this case? Thanks
