Re: [BUGS] BUG #4890: Allow insert character has no equivalent in "LATIN2"

2009-06-29 Thread Craig Ringer
On Sat, 2009-06-27 at 19:20 +, saint wrote: > set client_encoding to 'WIN1250'; > insert into public.test(col) values('‰'); You're lying to the server about the client encoding in one or both cases. I can't know which without knowing what program you're talking to the server with and how it's

Re: [BUGS] BUG #4875: /etc/init.d/postgresql status shows postmaster is stopped when executed as user

2009-06-29 Thread Craig Ringer
On Sun, 2009-06-28 at 00:32 -0400, Tom Lane wrote: > "Armin Jenewein" writes: > > When i run "/etc/init.d/postgresql status" as a non-root user, it shows > > "postmaster is stopped" while it actually is running. If i run it as root it > > reports correctly. > > AFAICS this just depends on "pidof

Re: [BUGS] BUG #4892: postmaster died and didn't restart

2009-06-29 Thread Craig Ringer
On Sun, 2009-06-28 at 22:54 +, Rikard Pavelic wrote: > log of death [i hate automatic translation feature :(] On UNIX, it's so easy to change what language PostgreSQL uses that it's generally considered very helpful - the only time you really want to disable it is when posting to mailing list

Re: [BUGS] BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed

2009-06-29 Thread Tom Lane
"Vladimir Lavrentiev" writes: > Description:Grants on inherited tables checks before constraint > exclusion see, that table not needed This is not a bug. Sorry, but that's just the way it works: you need suitable permission on every table referenced by the query. Constraint exclusion is

Re: [BUGS] BUG #4870: don't start service

2009-06-29 Thread Kevin Grittner
"Luis angel camacho" wrote: > the service can't start How are you starting it? What error messages, if any, do you see? (Copy/paste if possible; failing that, please give exact text.) What is in the logs from around the time of the failed attempt to start the service? -Kevin -- Sent

[BUGS] BUG #4894: [patch] documentation bug on 'include' directive

2009-06-29 Thread Peter Schuller
The following bug has been logged online: Bug reference: 4894 Logged by: Peter Schuller Email address: peter.schul...@infidyne.com PostgreSQL version: CVS Operating system: N/A Description:[patch] documentation bug on 'include' directive Details: The documentation s

Re: [BUGS] BUG #4894: [patch] documentation bug on 'include' directive

2009-06-29 Thread Tom Lane
"Peter Schuller" writes: > The documentation says to use: > include 'filename' > Which fails with a generic error. What generic error? > Correct syntax is: > include = 'filename' The stated syntax should work just fine. regards, tom lane -- Sent via pgsql-bugs mai