On 6/18/2011 1:22 AM, Greg Smith wrote:
That said, the card itself looks like plain old simple LSI MegaRAID.
Get the battery backup unit
Thanks. Dell's web site drives me insane, and it appears I can save 20%
or more by going white-box.
One thing I don't understand is why is the BBU option
Thanks.
On 19/06/2011 8:09 AM, David Johnston wrote:
An alternative approach would be to select using a IN condition on the where
clause and group by column 1 and column 2. Then, using this as a sub-select
group by the resultant column 1 and a count on column two. The matching
identifiers a
You can try using a CTE/With clause. Failing that use a function with SELECT
INTO...
On Jun 18, 2011, at 22:45, lover boi wrote:
> Hi,
>
> In the following statement, does the custom function get executed twice?
>
> SELECT
> MY_FUNCTION(...),
> CASE WHEN MY_FUNCTION(...) = '...' THEN '..
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
and can see that it is redirecting packets rec
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 gave me
a "Column my_function does not exist" e
On Sat, Jun 18, 2011 at 6:12 PM, Dave Thompson wrote:
> Hi,
>
> I have a table that will be updated frequently. Each row will be
> updated at least once during it's lifetime, and most rows will be
> updated ~10 times in their first 2 weeks of existence, and then
> relatively rarely after that. The
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 gave me
a "Column my_function does not exist" e
Hi,
I have a table that will be updated frequently. Each row will be
updated at least once during it's lifetime, and most rows will be
updated ~10 times in their first 2 weeks of existence, and then
relatively rarely after that. The rows are being updated by a prepared
statement that gets executed
An alternative approach would be to select using a IN condition on the where
clause and group by column 1 and column 2. Then, using this as a sub-select
group by the resultant column 1 and a count on column two. The matching
identifiers are those with a count equal to the number of entries in
Untested approach
Use array_agg on column 2 along with group by on column 1 to build check arrays
and then use equals to compare with an array of your desired input values.
You should omit duplicates and order ascending both the data and the input to
ensure you are matching canonical forms.
Dav
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 itself.
For example given the following
On Thu, 16 Jun 2011, David Johnston wrote:
The only way to feed another relation into a function is to place the
function in the SELECT list. If you then want to expand the result of the
function call you alias the function result and then ".*" against it.
WITH feeder AS (
SELECT f(var) AS res
On 06/18/2011 05:22 AM, Nithya Rajendran wrote:
We are doing Master/Standby setup, We unplugged the master server,
then the standby server became the master (by creating trigger file).
While converting the old master to new slave server, We are getting
the following error in old master,
On Jun 17, 2011, at 11:23 PM, Greg Smith wrote:
> I guess you could call Highpoint a RAID manufacturer, but I wouldn't do so.
> They've released so many terrible problems over the years that it's hard to
> take the fact that they may have something reasonable you can buy now (the
> 43XX cards
Thanks!
2011/6/14 Darren Duncan
> Alpha Beta wrote:
>
>> Hi list, (newbie with databases)
>>
>> I was looking out in net about how can we determine or find all functional
>> dependencies in a relational database, but didn't find.
>>
>> So can please anyone here tell me if functional dependecie
On Sat, Jun 18, 2011 at 10:57, Sanjay Rao wrote:
> Hi,
>
> I am running a test setup for verifying the warm standby feature in Postgres
> 9.0 release. Both my Master (Win 7 Professional, 64 bit) & Standby (Win 7
> Professional, 64 bit) machines are having Postgres 9.0
> (postgresql-9.0.4-1-windows
On Thu, Jun 16, 2011 at 06:07:50PM -0400, Bruce Momjian wrote:
> Noah Misch wrote:
> > On Sun, Apr 17, 2011 at 04:55:51PM +0100, Jack Douglas wrote:
> > > I discovered the 'fields' option of 'interval', but i can't figure out
> > > from the docs how it is supposed to work. Are "hour to minute" an
Hi,
We are doing Master/Standby setup, We unplugged the master server, then the
standby server became the master (by creating trigger file).
While converting the old master to new slave server, We are getting the
following error in old master,
FATAL: the database system is starting up
FATAL:
Hi,
I am running a test setup for verifying the warm standby feature in
Postgres 9.0 release. Both my Master (Win 7 Professional, 64 bit) &
Standby (Win 7
Professional, 64 bit) machines are having Postgres 9.0
(postgresql-9.0.4-1-windows) installed & both are in our LAN environment.
After ta
On 06/18/2011 02:46 AM, David Boreham wrote:
We're looking to deploy a bunch of new machines.
Our DB is fairly small and write-intensive. Most of the disk
traffic is PG WAL. Historically we've avoided
RAID controllers for various reasons, but this new deployment will be
done with them (also for
Hi Mr. David,
Thanks for the comment. I understood, its more difficult to mange the schema;
when schema itself written in jig jack.
Vikram
From: David Johnston
To: 'Vikram A'
Cc: pgsql-general@postgresql.org
Sent: Friday, 17 June 2011 7:00 PM
Subject: RE: [GEN
21 matches
Mail list logo
