[GENERAL] Unable to Increase the column which was part of Primary key

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,

[GENERAL] deployment query

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

Re: [GENERAL] deployment 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

Re: [GENERAL] deployment query

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, Please give some suggestion

[GENERAL] Database separation for backup

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

Re: [GENERAL] Database separation for backup

, 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. I would like

Re: [GENERAL] postgres deployment

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

[GENERAL] postgres deployment

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

[GENERAL] postgresql with storage

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

Re: [GENERAL] postgresql with storage

the 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 karthikeyan.nagalin...@netapp.com

[GENERAL] What is the difference between rule and triggers

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.

Re: [GENERAL] [ADMIN] How to get the DML Commands exceuted from functions

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'