Hi,
I am trying to increase size of the column which was/is part of the Primary.
Exiting table
CREATE TABLE test_dim_store
(
storek integer NOT NULL DEFAULT
nextval('dim_store_storek_seq1'::regclass),
retailerk character varying(10) NOT NULL,
store_nbr character varying(5) NOT NULL,
store
2009 1:53 AM
To: Nagalingam, Karthikeyan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] deployment query
Nagalingam, Karthikeyan wrote:
> Hi,
> we are in the process of finding the best solution for Postgresql
> deployment with storage controller. I have some query,
Thanks for your reply john.
Regards
Karthikeyan.N
-Original Message-
From: John R Pierce [mailto:pie...@hogranch.com]
Sent: Monday, March 16, 2009 11:08 PM
To: Nagalingam, Karthikeyan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] deployment query
Nagalingam, Karthikeyan
Hi,
we are in the process of finding the best solution for Postgresql
deployment with storage controller. I have some query, Please give some
suggestion for the below
1) Can we get customer deployment scenarios for postgresql with storage
controller. Any flow diagram, operation diagram and im
, 2009 4:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database separation for backup
On Thu, Mar 12, 2009 at 04:18:50PM +0530, Nagalingam, Karthikeyan wrote:
> Is there any way to keep each database in separate partition ie)
> separate folder for each database.
>
>
Hi,
Is there any way to keep each database in separate partition ie)
separate folder for each database.
I would like to do the dabase level backup in storage side, for that If
I am able to separate the database in folderwise, I can allocate
separate partition for each database. Then I can take
Thanks Simon Riggs, I am following the same.
Can I get some real time backup solution in production.
Regards
Karthikeyan.N
-Original Message-
From: Simon Riggs [mailto:si...@2ndquadrant.com]
Sent: Tuesday, March 10, 2009 2:25 PM
To: Nagalingam, Karthikeyan
Cc: pgsql-general
Hi,
Can I know the effective solution to do the backup and recovery
for Postgres in storage environment.
Please share Any existing deployment and solution for backup and
recovery for Postgres in storage
Any suggestion and recommendation are welcome.
Regards
Karthikeyan.N
data from
different database like MySQL, Oracle
What do the servers look like
The servers are IBM X86[32bit ]
To name a few questions that come to mind
Hope this helps
Regards,
Serge Fonville
On Thu, Feb 26, 2009 at 1:06 PM, Nagalingam, Karthikeyan
wrote:
Hi
Hi,
I have some basic query in postgresql with storage, Please help me for
the following
1. What is the best practice to use postgresql with storage.
2. Which are the files and folders we can keep them in storage.
Regards
Karthikeyan.N
Hi Everybody,
What is the difference between creating a rule and a trigger?
Regards
skarthi
_
i'm making a difference. Make every IM count for the cause of your choice. Join
Now.
http://clk.atdmt.com/MSN/go/msnnkwme00800
CREATE OR REPLACE FUNCTION xyz() returns int4 as
$body$
DECLARE
BEGIN
IF (TG_OP = 'DELETE') THEN n_id = OLD.campaign_id;
EXECUTE 'DELETE FROM cn_mapping WHERE campaign_id = '||quote_literal(n_id);
RETURN 0; END IF;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE;
12 matches
Mail list logo