Re: [BUGS] SELECT updatability clause defective.

2001-05-09 Thread Stephan Szabo
On Wed, 9 May 2001, Peter Eisentraut wrote: > > Jerome O\'Neil ([EMAIL PROTECTED]) reports a bug with a severity of 2 > > > SELECT updatability clause defective. > > Nope. > > > The syntax for select updatability clause is non-standard. > > That's not a bug. > > > While SQL-92 BNF describes

[BUGS] Better dump of foreign key data

2001-05-09 Thread pgsql-bugs
Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Better dump of foreign key data Long Description When you dump a database wich has tables that have foreign keys, it dumps a lot of things regarding foreign keys that

[BUGS] SELECT updatability clause defective.

2001-05-09 Thread pgsql-bugs
Jerome O\'Neil ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description SELECT updatability clause defective. Long Description The syntax for select updatability clause is non-standard. Postgres describes select updatability as SELEC

Re: [BUGS] Another plpgsql crash

2001-05-09 Thread Tom Lane
[EMAIL PROTECTED] writes: > The function crashes, when the corresponding user is not found. If this is 7.1.1, then that's an already-known problem (I broke plpgsql's SELECT for the case of no rows found :-(). It'll be fixed in 7.1.2, or you can get the source-code patch from techdocs.postgresql.

Re: [BUGS] PostgreSQL 7.1.1: Backend crash when calling plpgsql function

2001-05-09 Thread Tom Lane
[EMAIL PROTECTED] writes: > Hi, while porting a 6.5 app to 7.1.1 i found a plpgsql function that > crashes the backend. Other functions work though. When i rewrite the > function to be more sane, the crash doesnt happen anymore. Still the > backend shouldnt crash (and it didnt in 6.5 btw). > The w

Re: [BUGS] PostgreSQL 7.1.1: Backend crash when calling plpgsql function

2001-05-09 Thread Robert Hentosh
This looks similar to the issue I reported. Tom has already placed a patch in CVS that works for me. fetch the latest pgsql/src/pl/plpgsql/src/pl_exec.c file from CVS in the REL7_1_STABLE branch. Going back to 7.1 also fixes this problem. On Wed, May 09, 2001 at 08:54:03AM -0400, [EMAIL PRO

Re: [BUGS] Another plpgsql crash

2001-05-09 Thread Robert Hentosh
See reply to your previous bug report. 7.1 doesn't have this problem or fetch the latest from CVS's REL7_1_STABLE branch. On Wed, May 09, 2001 at 09:15:16AM -0400, [EMAIL PROTECTED] wrote: > ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. >

[BUGS] Another plpgsql crash

2001-05-09 Thread pgsql-bugs
([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Another plpgsql crash Long Description Ok, just found another one: The function crashes, when the corresponding user is not found. This one just looks too common, so i guess i m

[BUGS] PostgreSQL 7.1.1: Backend crash when calling plpgsql function

2001-05-09 Thread pgsql-bugs
([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description PostgreSQL 7.1.1: Backend crash when calling plpgsql function Long Description Hi, while porting a 6.5 app to 7.1.1 i found a plpgsql function that crashes the backend. Other fu