[GENERAL] SIGSEGV when trying to start in single user mode

2009-09-19 Thread Björn Häuser
Hello List, I have a problem with my PostgreSQL 8.3.4 installation. We had some problems with our storage subsystem and it seems postgresql suffered a little bit from it. Here are some log excerpts: When trying to start postgesql: --- # /etc/init.d/postgresql-8.3 start Starting PostgreSQL 8.3 da

Re: [GENERAL] SIGSEGV when trying to start in single user mode

2009-09-19 Thread Björn Häuser
Hello Tom, thank you for your help. I resetted the xlog and the server started again. Regards, Björn 2009/9/19 Tom Lane : > =?UTF-8?B?QmrDtnJuIEjDpHVzZXI=?= writes: >> I have a problem with my PostgreSQL 8.3.4 installation. > >> We had some problems with our storage subsystem and it seems >> p

Re: [GENERAL] counterintuitive behaviour in pl/pgsql

2011-05-21 Thread Björn Häuser
Hello, seems like you cannot name your input parameters the same as your tableoutputcolumns? Rename one of them and it works. Something like: RETURNS TABLE (j int) Regards Am 21.05.11 16:25, schrieb Pavel Stehule: Hello yes, this behave is strange, and should be fixed Regards Pavel Steh

Re: [GENERAL] Alter column...using failure under 9.0.4

2011-09-25 Thread Björn Häuser
Hello, you could check for indices or something like that. Björn Am 25.09.2011 um 17:17 schrieb Edson Carlos Ericksson Richter: > Dear list, > > I’ve a strange issue here. I’ve a table that I’m sure the column type is > boolean. I can see the datatype is boolean on PgAdmin. > > Nevertheles