Re: hi can u give solution to this query

________________________________

From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Penchalaiah P.
Sent: 23 May 2006 13:41
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] hi can u give solution to this query

Hi sir...

If u don't mind can u reply for this question

This is one table... it has one primary key.......so I can
insert the values from data edit...

1)...CREATE TABLE "ADV"

(

"T-Section_Id" varchar(10) NOT NULL,

"CDA_No" varchar(7) NOT NULL,

"Imp_Schedule_Id" int4 NOT NULL,

"Sanction_No" varchar(20) NOT NULL,

"Sanction_Date" date NOT NULL,

"Station_From" varchar(20) NOT NULL,

"Station_To" varchar(20) NOT NULL,

"Amt_Claimed" int4,

"Amt_Admitted" int4,

"Dak_Id" varchar(20) NOT NULL,

"Refund_Dak_Id" int4 NOT NULL,

"T-Wing_Allowance_Id" varchar(10) NOT NULL,

CONSTRAINT "ADV_pkey" PRIMARY KEY ("T-Section_Id")

)

WITHOUT OIDS;

ALTER TABLE "ADV" OWNER TO postgres;

2) this table doesn't contain primary key ... but I cant insert
values from data edit...

CREATE TABLE "ADV_LTC"

(

"T-Section_Id" varchar(20) NOT NULL,

"Ltc_Block_Year" date NOT NULL,

"Ltc_Type" varchar(10) NOT NULL,

"Leave_Period_From" date NOT NULL,

"Leave_Period_To" date NOT NULL,

"Date_Journey" date NOT NULL,

"Travelling" varchar(10) NOT NULL,

"No_Child" int4,

"No_Adult" int4,

"Child_Fare" int4,

"Adult_Fare" int4,

"Journey_Fare" int4,

"Amt_Clm" int4 NOT NULL,

"Amt_Adm" int4,

"Remarks" varchar(40)

)

WITHOUT OIDS;

ALTER TABLE "ADV_LTC" OWNER TO postgres;

Can u check it y I am unable to insert values to 2nd
table..........

You have answered your own question. pgAdmin won't allow you to edit a
table without either OIDs or a Primary Key because it has no way to
identify a row (which many would say is a broken design).

Regards, Dave.