The following bug has been logged online:
Bug reference: 1966
Logged by: Tony Caduto
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux
Description:Single OUT PARM does not return param name.
Details:
When creating a plpgsql function
s not seem to work exactly as expected, at
least with freshly restored functions from 7.x
I can run a SQL monitor that shows the exact SQL that is being sent to
the server, so I will do that and then
let you know.
Thanks for the response,
Tony Caduto
Peter Eisentraut wrote:
Tony Caduto wrote:
The following bug has been logged online:
Bug reference: 1375
Logged by: Tony Caduto
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Gentoo Linux
Description:Problem with Dollar qouting functions
Details:
I restored my 7.4.x database to
itself Explain
would always report the index being used, but when run in the context of
the function the indexes where not being used.
Thanks,
Tony Caduto
---(end of broadcast)---
TIP 8: explain analyze is your friend
varHoldingPercent );
END IF;
Thanks
Tony Caduto
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
not been changed or deleted. On
monday I am going to replace the count(*) with a for select and a
counter variable and see if the slowness goes away. It really does seem
to be some issue/bug maybe or just a difference in the 8.0 engine.
Thanks,
Tony Caduto
Tom Lane wrote:
Tony Caduto
Hi,
I just installed 8.0 RC1 and then restored my database which was working
perfectly on 7.4.5.
I have a function that imports rows from a comma seperated file and on
7.4.5 using this same function I could get around 1000 rows every 2.5
seconds, now with 8.0 RC1 this has gone way up and it seem
