Re: [SQL] [PERFORM] Performance Problem With Postgresql!

Arash, > We are having a performance problem with our database. The problem > exists when we include a constraint in GCTBALLOT. The constraint is as > follows: You posted twice, to three different mailing lists each time. This is discourteous. Please do not do so again, as people may not help

Re: [SQL] Wierd Error on update

Thomas Seeber <[EMAIL PROTECTED]> writes: >>> I am getting two errors which are a bit confounding. >>> ERROR: pg_class_aclcheck:relation 474653086 not found >> How about triggers? Foreign keys? Rules? > Neither of the updates touch any rules. > sis_system_id has a foreign key constaint to an

Re: [SQL] Wierd Error on update

> Original 7.3 release, or (I hope) 7.3.something? Red Hat 7.3.2.96-113 Linux Version 2.4.20-20.7custom from cat /proc/version > > I am getting two errors which are a bit confounding. > > ERROR: pg_class_aclcheck:relation 474653086 not found > > Are there any views involved? No views. Is the

Re: [SQL] function expression in FROM may not refer to other relations of same query level

Thanks a lot for your support. With a subselect and offset 0, the function is called only once per row, that's fine. Here is the final test code, in case it can help anyone. --- CREATE TYPE public.lines AS ( line1 varchar(10), line2 varchar(10) );