Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA07803; Tue, 18 Aug 92 04:30:57 -0700 Message-Id: <9208181130.AA07803@postgres.Berkeley.EDU> From: "Schenkelaars.V.F" Subject: Strange replace behaviour (BUG) To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu To: postgres@postgres.berkeley.edu (Postgres mailing list) Date: Tue, 18 Aug 92 13:36:05 MET DST X-Mailer: ELM [version 2.3 PL11] I'v encountered a strange bug in postgres. I've defined a function as follows: define function reactinsert (language = "c", returntype = int4) as "/fusr/vfsj3/postgres/reactive/reactree.o" This results in the following tuple: Query sent to backend is "retrieve (pg_proc.all) where pg_proc.proname ~ "react"" --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | proname | proowner | prolang | proisinh | proistrusted| proiscachable| pronargs | proretset | prorettype | proargtypes | probyte_pct | properbyte_cpu| propercall_cpu| prooutin_ratio| prosrc | probin | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | reactinsert | 123 | 13 | f | f | f | 0 | f | 23 | 0 0 0 0 0 0 0 0| 100 | 10 | 100 | 1 | - | /fusr/vfsj3/postgres/reactive/reactree.o| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- but when I replace the pronargs atrtribute like: replace pg_proc (pronargs = 2) where pg_proc.proname = "reactinsert" And I look in the pg_proc table I get: Query sent to backend is "retrieve (pg_proc.all) where pg_proc.proname ~ "react"" --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | proname | proowner | prolang | proisinh | proistrusted| proiscachable| pronargs | proretset | prorettype | proargtypes | probyte_pct | properbyte_cpu| propercall_cpu| prooutin_ratio| prosrc | probin | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | reactinsert | 123 | 13 | f | f | f | 2 | f | 23 | 0 0 0 0 0 0 0 0| 100 | (null) | (null) | (null) | (null) | (null) | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- A number of attributes has changed too. Is this a bug or something else? Greetings ____________________ \ / . _ _ _ _ | \/ ( ( \ (_ (-' ( \ | -------------------------------------------------------------------------------- Vincent F. Schenkelaars | Company: FEL-TNO | Private: Email : V.F.Schenkelaars@tnofel.fel.tno.nl | address: Oude Waalsdorperweg 63 | Groenhovenstraat 12 Postbus 96864 | 2509 JG Den Haag | 2311 BT Leiden The Netherlands | The Netherlands Phone : Holland 070-3264221 | Holland 071-125576 Fax : Holland 070-3280961 | -------------------------------------------------------------------------------- We apologize for the inconvenience.