* Adarsh Sharma wrote:
Today I am facing a simple problem that I fail to solve after 2 day try.
I have a places table in database whose structure is as :
CREATE TABLE places
(
woe_id character varying(15) NOT NULL,
iso character varying(6),
"name" text,
"language" character varying(6),
place_t
hello !
I
having an issue with my postgres database installed on a windows xp. For some
reason, I can no longer start the postgres service through pgadmin or the
services window. I get the following error:
Error 1053: The service did not
respond to the start or control request in a timely fas
BangarRaju Vadapalli writes:
> The select query for creating the view is executing fine in 8.4.2. But
> not in 9.1 beta2. The issue is forward referencing of table aliases in
> subqueries is not working fine in 9.1 beta2.
This complaint is unintelligible. Please provide a self-contained
test cas
Hi Everybody,
We have a view defined like below.
CREATE OR REPLACE VIEW dim_agg_instr_actuals_view AS SELECT
dbai.dim_base_agg_instr_key AS instr_key, dba.dim_base_key AS basekey,
dl.datamart_letter, dba.agg_number AS aggnum, dl.enabled, dba.dim_base_agg_key,
dbai.dim_base_name, d
Answers Below
-Original Message-
From: Craig Ringer [mailto:cr...@postnewspapers.com.au]
Sent: Sunday, June 19, 2011 3:03 PM
To: BangarRaju Vadapalli
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] random backend crashes - how to debug ( Is crash dump
handler released ? )
On
[...]
> I need to search a table to find sets of rows that have a column
matching
> itself for the whole set and another column matching row for row with a
> list I am going to supply. The result I should receive should be
value of
> the column that matches itself.
[...]
How about:
DROP TAB
On Mon, Jun 20, 2011 at 1:43 AM, Alexander Farber <
alexander.far...@gmail.com> wrote:
> Hello Cedric and others,
>
> On Sun, Jun 19, 2011 at 9:56 PM, Cédric Villemain
> wrote:
> > 2011/6/19 Alexander Farber :
> >> [pgbouncer]
> >> logfile = /var/log/pgbouncer.log
> >> pidfile = /var/run/pgbounce
2011/6/19 Alexander Farber :
> Hello Cedric and others,
>
> On Sun, Jun 19, 2011 at 9:56 PM, Cédric Villemain
> wrote:
>> 2011/6/19 Alexander Farber :
>>> [pgbouncer]
>>> logfile = /var/log/pgbouncer.log
>>> pidfile = /var/run/pgbouncer/pgbouncer.pid
>>> listen_port = 6432
>>> unix_socket_dir = /t
Hello Cedric and others,
On Sun, Jun 19, 2011 at 9:56 PM, Cédric Villemain
wrote:
> 2011/6/19 Alexander Farber :
>> [pgbouncer]
>> logfile = /var/log/pgbouncer.log
>> pidfile = /var/run/pgbouncer/pgbouncer.pid
>> listen_port = 6432
>> unix_socket_dir = /tmp
>> auth_type = md5
>> auth_file = /var/
2011/6/19 Alexander Farber :
> Hello everyone,
>
> after the suggestion from this mailing list,
> I have installed pgbouncer at my
> CentOS 5.6 / 64 bit server and
> activated its transaction mode:
>
> [databases]
> pref = host=/tmp user=pref password=XXX dbname=pref
>
> [pgbouncer]
> logfile = /va
Le 18/06/2011 23:51, Daron Ryan a écrit :
Hello,
I need to search a table to find sets of rows that have a column
matching itself for the whole set and another column matching row for
row with a list I am going to supply. The result I should receive should
be value of the column that matches it
Hi
Le 19/06/2011 04:27, lover boi a écrit :
> SELECT
>MY_FUNCTION(...) AS my_function,
>CASE WHEN my_function = '...' THEN '...' ELSE '...' END
> ...
> ...
WITH
T AS
(SELECT MY_FUNCTION(...) AS my_function, ...
)
SELECT CASE WHEN my_function = '...' THEN '...' ELSE '...' END
...
...
A +
Hello everyone,
after the suggestion from this mailing list,
I have installed pgbouncer at my
CentOS 5.6 / 64 bit server and
activated its transaction mode:
[databases]
pref = host=/tmp user=pref password=XXX dbname=pref
[pgbouncer]
logfile = /var/log/pgbouncer.log
pidfile = /var/run/pgbouncer/p
On Jun 19, 2011, at 12:33 AM, David Boreham wrote:
> One thing I don't understand is why is the BBU option never available with
> "integrated" LSI controllers?
Because "integrated" means it's on the mobo to save costs.
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303
On 06/19/2011 08:35 PM, David Resnick wrote:
Thanks a lot for your reply!
OK, the source and destination parameters were not intended to hide
anything. Setting them like that got the same results in the iptables
status output as when not specifying --source and --destination at all.
Whoops, I
Thanks a lot for your reply!
OK, the source and destination parameters were not intended to hide
anything. Setting them like that got the same results in the iptables status
output as when not specifying --source and --destination at all. Does
--source need to be set to the address the machine is
This message has been digitally signed by the sender.
Re___GENERAL__Referencing_function_value_inside_CASE__WHEN.eml
Description: Binary data
Hi-Tech Gears Ltd, Gurgaon, India
Sent using "PostMaster" by QuantumLink Communications
G
On Sun, Jun 19, 2011 at 10:45:12AM +0800, lover boi wrote:
> In the following statement, does the custom function get executed twice?
>
> SELECT
> MY_FUNCTION(...),
> CASE WHEN MY_FUNCTION(...) = '...' THEN '...' ELSE '...' END
Yes
> If so, is there a way I can make it execute once? I tried
On 06/14/2011 10:26 PM, BangarRaju Vadapalli wrote:
Hi Everybody,
We are using PostGRE 8.4 version and experiencing random backend
crashes. We have enabled logging and are able to see some logging
happening in pg_log directory but not of much use. Here are the logs.
- Examination of the full l
On 06/19/2011 12:07 PM, David Resnick wrote:
Hi,
I have a posgres instance configured to listen at the localhost default.
I'm trying to enable port forwarding via iptables. I set up the
following rule:
iptables -t nat -I PREROUTING --source 0/0 --destination 0/0 -p tcp
--dport 5432 -j REDIRECT
Hello
2011/6/19 lover boi :
> Hi,
>
> In the following statement, does the custom function get executed twice?
>
> SELECT
> MY_FUNCTION(...),
> CASE WHEN MY_FUNCTION(...) = '...' THEN '...' ELSE '...' END
> ...
> ...
>
>
> If so, is there a way I can make it execute once? I tried this but it
21 matches
Mail list logo
