Re: [SQL] inheritance problems

On Fri, 14 Jun 2002, Matt wrote: > I have a parent with two columns, the primary key; several children > inherit these columns. > > I can see all the childrens primary keys in the parent. however I can't > reference data in the parent table that was entered into a child. I get > a referential int

Re: [SQL] function not running after upgrade from 7.03 to 7.2

[EMAIL PROTECTED] wrote: > > Hello > > I have three functions running under 7.03, Now, after the Upgrade to 7.2 > these functions are not working. > What has changed in version 7.2 that causes this problem. > > Function : > > CREATE FUNCTION "buildUmfang"("bpchar") RETURNS "text" AS 'DECLARE >

[SQL] function not running after upgrade from 7.03 to 7.2

Hello I have three functions running under 7.03, Now, after the Upgrade to 7.2 these functions are not working. What has changed in version 7.2 that causes this problem. Function : CREATE FUNCTION "buildUmfang"("bpchar") RETURNS "text" AS 'DECLARE list text; rec r

Re: [SQL] ON DELETE CASCADE question

Josh Berkus wrote: > > Wei, > > > Does ON DELETE CASCADE attribute you specify in CREATE TABLE > > statement > > actually create triggers for every foreign key it refers to? > > > > Yes. Two triggers for each key, I think. Three, one for INSERT OR UPDATE on the FK table, one for UPDAT

Re: [SQL] ON DELETE CASCADE question

Wei, > Does ON DELETE CASCADE attribute you specify in CREATE TABLE > statement > actually create triggers for every foreign key it refers to? > Yes. Two triggers for each key, I think. -Josh ---(end of broadcast)--- TIP 4: Don't 'kill -9' the p

[SQL] ON DELETE CASCADE question

Does ON DELETE CASCADE attribute you specify in CREATE TABLE statement actually create triggers for every foreign key it refers to? Thanks! -- Wei Weng Network Software Engineer KenCast Inc. ---(end of broadcast)--- TIP 5: Have you checked our

Re: [SQL] Function not running after upgrade 7.03 to 7.2

> Query : > > SELECT *, > (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang > FROM zylinder; > > Thank's in advance for any help jr Try this: SELECT *, (SELECT rtrim("buildUmfang"(zylinder.z_typ), ','::text) AS rtrim) AS umfang FROM zylinder; I think it's because yo

[SQL] Function not running after upgrade 7.03 to 7.2

I have three functions running under 7.03, Now, after the Upgrade to 7.2 these functions are not working. What has changed in version 7.2 that causes this problem. Function : CREATE FUNCTION "buildUmfang"("bpchar") RETURNS "text" AS 'DECLARE list text; rec record;