[BUGS] POSTMASTER crashed when I execute a function

2003-03-24 Thread William.Jiang
Hi,all    the version is 7.3 .I post it to windows2000 and install the pl/pgsql language . I create a function like :  create function a() returns int as ' begin return 1; end; 'language 'pl/pgsql'; Everything is ok till now.but when I executed it :select a(), the postmaster crashed and restarted.E

[BUGS] STABLE functions

2003-03-24 Thread Joachim Wieland
Hi there, I'm using 7.3.2 and encounter the problem that a SELECT query that uses a function with a constant argument is quite slow. The function is declared STABLE. Here's an example: SELECT ... FROM table WHERE col = f('xyz'); >From what I read in the docs ( http://www.postgresql.org/docs/vi

R: [BUGS] Bug #917: SERVICE DENIAL ON XP

2003-03-24 Thread Diego Cattelan
I have 3 notebook with windows XP Home and 3 with windows 2000 professional that are using postgreSQL as database. Databases are running from about a year without a problem from release 7.1 to the last 7.3.2 now. I'm using the cygwin release from www.cygwin.com. -Messaggio originale- Da:

Re: [BUGS] Bug #917: SERVICE DENIAL ON XP

2003-03-24 Thread Bruce Momjian
We don't ship a version that runs on XP. Complain to whereever you got if rom. --- [EMAIL PROTECTED] wrote: > Oluwatope Akinniyi ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe

[BUGS] Bug #917: SERVICE DENIAL ON XP

2003-03-24 Thread pgsql-bugs
Oluwatope Akinniyi ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description SERVICE DENIAL ON XP Long Description 1. During Installation of Postgresql on Windows XP it defaults the service account to the Administrator which is not a pro

Re: [BUGS] FileSize limit not handled.

2003-03-24 Thread Tom Lane
"Frédéric SURLEAU" <[EMAIL PROTECTED]> writes: > On this system, the file size is limited using ulimit.=0D > =0D > When the limit is reached for a database file, Postgres does THIS :=0D > =0D > LOG: server process (pid 4820) was terminated by signal 25=0D > LOG: terminating any other active serve

[BUGS] FileSize limit not handled.

2003-03-24 Thread Frédéric SURLEAU
Hi, I had a problem with postgresql 7.3.2 running on a Linux RedHat system.   On this system, the file size is limited using ulimit.   When the limit is reached for a database file, Postgres does THIS :   LOG:  server process (pid 4820

[BUGS] POSTMASTER crashed when I execute a function

2003-03-24 Thread William.Jiang
I port postgres7.3 to windows 2k and install the pl\pgsql language . After I create a very simple function a like :  create function a() returns int as 'begin return 1;end;' language plpgsql; the creation is successful but when I execute the function  : select a(); The postmaster crashed and restar