[BUGS] Crash when calling a pl/pgsql function with no row to pass as an argument

2004-02-17 Thread Chris Campbell
POSTGRESQL BUG REPORT TEMPLATE Your name : Chris Campbell Your email address : [EMAIL PROTECT

[BUGS] memory does not return back

2004-02-17 Thread hessam
I'm using freeradius 0.9.3 with postgresql 7.3.2. All I do is just inserting some h323 accounting data into my tables. After a couple of hours the memory reaches to about 1G and then Linux starts using swap file.I lose some of my records and PC becomes very slow. Even if I restart postgresql , th

[BUGS] pg_autovacuum bug with temp tables?

2004-02-17 Thread Jeff Boes
[Apologies to anyone who is seeing this for the second time; the author of pg_autovacuum suggested it belonged here, so I am reposting.] Recently I installed and started pg_autovacuum against my new Pg 7.4.1 installation. We use a fairly large number of temporary tables within an application (tha

[BUGS] Crash when calling a pl/pgsql function with no row to pass as an argument

2004-02-17 Thread Chris Campbell
(Attempting to send this to pgsql-bugs a second time without Cc:'ing pgsql-patches, since it doesn't appear that my February 15 message got through.) POSTGRESQL BUG REPORT TEMPLATE ==

Re: [BUGS] Default Timestamp 'Now' bug with 7.4 on Panther.

2004-02-17 Thread Harry Hochheiser
Ok, thanks. that's what i get for using a premade package, I guess. -harry On Feb 15, 2004, at 1:31 PM, Tom Lane wrote: Harry Hochheiser <[EMAIL PROTECTED]> writes: Running Postgres 7.4 on Panther, there seems to be a problem with setting a timestamp column to have a default of 'now': There was

Re: [BUGS] plpgsql - variable's names conflict with table field

2004-02-17 Thread Pavel Stehule
On Tue, 17 Feb 2004, Tom Lane wrote: > Pavel Stehule <[EMAIL PROTECTED]> writes: > > When I declare variable with same name as field of table, then I > > have a problem with insert cmd in plpgsql procedure. > > Don't do that. > > > Is it plpgsql error or my bug? > > You could argue it eith

Re: [BUGS] plpgsql - variable's names conflict with table field names

2004-02-17 Thread Tom Lane
Pavel Stehule <[EMAIL PROTECTED]> writes: > When I declare variable with same name as field of table, then I > have a problem with insert cmd in plpgsql procedure. Don't do that. > Is it plpgsql error or my bug? You could argue it either way, perhaps, but it's unlikely to get changed. In

[BUGS] plpgsql - variable's names conflict with table field names

2004-02-17 Thread Pavel Stehule
Hello When I declare variable with same name as field of table, then I have a problem with insert cmd in plpgsql procedure. I can't use this name of columns list in insert cmd; I get syntax error. When I use equal names in SELECT cmd, I didn't get error msg, but stored prodedure don't