Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Pavel Stehule
2009/10/25 Timothy Madden : > > > On Mon, Oct 26, 2009 at 12:13 AM, Tom Lane wrote: >> >> Timothy Madden writes: >> > Ok I get it. So Posgres also offers perl and python in addition to SQL. >> > But at least for SQL, which is included and defined in the standard, >> > could >> > the syntax be mad

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Pavel Stehule
2009/10/25 Timothy Madden : > > On Sun, Oct 25, 2009 at 6:17 PM, Pavel Stehule > wrote: >> >> 2009/10/25 Timothy Madden : >> > >> > >> > On Sun, Oct 25, 2009 at 12:42 PM, Peter Eisentraut >> > wrote: >> >> >> >> On lör, 2009-10-24 at 14:01 +, Timothy Madden wrote: >> >> > Can the string liter

Re: [BUGS] Postmaster hangs

2009-10-25 Thread Karen Pease
kill -9 does kill postmaster (or at least seems to). But I can't figure out a way to get it restarted without a reboot -- I don't know what I'm missing. The Fedora postgres restart scripts don't do the trick, and I couldn't get it to work with pg_ctl either. kill -9 doesn't work on the locked up

Re: [BUGS] Postmaster hangs

2009-10-25 Thread Tom Lane
Karen Pease writes: > It'll get through about three or four of them (out of hundreds) before > it locks up. Now, before lockup, postmaster is very active. It shows > up on top. The computer's hard drives clack nonstop. Etc. But once it > locks up (without warning), all of that stop. Postmast

[BUGS] Postmaster hangs

2009-10-25 Thread Karen Pease
I've been dealing with a postgres (8.3.8.1.fc10) problem for a while that has become quite frustrating in recent weeks. I have a set of tables, one of which (geonames) is very large. This contains the geonames geographical information database -- about 7 million records: CREATE TABLE geonames (

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Timothy Madden
On Mon, Oct 26, 2009 at 12:13 AM, Tom Lane wrote: > Timothy Madden writes: > > Ok I get it. So Posgres also offers perl and python in addition to SQL. > > But at least for SQL, which is included and defined in the standard, > could > > the syntax be made conforming ? > > I think you still haven'

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Tom Lane
Timothy Madden writes: > Ok I get it. So Posgres also offers perl and python in addition to SQL. > But at least for SQL, which is included and defined in the standard, could > the syntax be made conforming ? I think you still haven't got the point: there is *no* function language that we offer th

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Timothy Madden
On Sun, Oct 25, 2009 at 6:17 PM, Pavel Stehule wrote: > 2009/10/25 Timothy Madden : > > > > > > On Sun, Oct 25, 2009 at 12:42 PM, Peter Eisentraut > wrote: > >> > >> On lör, 2009-10-24 at 14:01 +, Timothy Madden wrote: > >> > Can the string literal syntax for CREATE FUNCTION please, please be

Re: [BUGS] BUG #5137: Upgrade policy clarification

2009-10-25 Thread Peter Eisentraut
On sön, 2009-10-25 at 13:52 +, Peter Bengtson wrote: > It would be good if you to the page describing how a db dump is required > only for major verson upgrades, e.g. from 8.3.x to 8.4.x but not from, say, > 8.3.7 to 8.3.8, could add a proviso: a DB dump *is* necessary when upgrading > from a s

[BUGS] BUG #5137: Upgrade policy clarification

2009-10-25 Thread Peter Bengtson
The following bug has been logged online: Bug reference: 5137 Logged by: Peter Bengtson Email address: pe...@peterbengtson.com PostgreSQL version: 8.3.8 Operating system: Debian, Mac OS X Description:Upgrade policy clarification Details: It would be good if you to t

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Pavel Stehule
2009/10/25 Timothy Madden : > > > On Sun, Oct 25, 2009 at 12:42 PM, Peter Eisentraut wrote: >> >> On lör, 2009-10-24 at 14:01 +, Timothy Madden wrote: >> > Can the string literal syntax for CREATE FUNCTION please, please be >> > dropped >> > ... ? > > [...] >> >> > It is not ANSI/ISO and so an

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Timothy Madden
On Sun, Oct 25, 2009 at 12:42 PM, Peter Eisentraut wrote: > On lör, 2009-10-24 at 14:01 +, Timothy Madden wrote: > > Can the string literal syntax for CREATE FUNCTION please, please be > dropped > > ... ? > [...] > > It is not ANSI/ISO and so annoying for compatibility. > > Whatever is insid

Re: [BUGS] BUG #5136: Please drop the string literal syntax for CREATE FUNCTION ...

2009-10-25 Thread Peter Eisentraut
On lör, 2009-10-24 at 14:01 +, Timothy Madden wrote: > Can the string literal syntax for CREATE FUNCTION please, please be dropped > ... ? > > http://www.postgresql.org/docs/8.4/interactive/plpgsql-structure.html > > It is not ANSI/ISO and so annoying for compatibility. Whatever is inside th