Re: [BUGS] psql missing feature: show permissions for functions]

2004-09-20 Thread Bruce Momjian
Jorge Godoy wrote: > > Hi, > > > I was trying to check some permissions on functions and then I noticed > that there's no command in psql to show that information. I've tried > using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5. > > It would be an interesting addition to have tha

Re: [BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread Alvaro Herrera
On Mon, Sep 20, 2004 at 07:35:58PM -0300, Jorge Godoy wrote: > testbase=# SELECT proacl, proargtypes FROM pg_proc WHERE proname='to_ascii'; > proacl | proargtypes > ---+- > {=X/postgres} | 25 > {=X/postgres} | 25 19 > {=X/postgres} | 25 23 >

Re: [BUGS] Backend with closed connection at 99% CPU

2004-09-20 Thread Tom Lane
Guy Thornley <[EMAIL PROTECTED]> writes: > Postgres 7.4.1. (Yes I know, we _should_ upgrade). Yup. > As the subject says, it is spinning at 99% CPU. ... > This backend has recently lost its client connection, ... > You can even have a backtrace, how about that: > (gdb) bt > #0 0

[BUGS] Backend with closed connection at 99% CPU

2004-09-20 Thread Guy Thornley
First, I better let you know that we have an in-house patch already on our postgres, so this may be our breakage. It only started happening recently, though, and our patch is quite old, so it is very unlikely. I thought I'd ask here anyway, incase this was a known bug that was fixed already. I cou

Re: [BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread Jorge Godoy
"John R Pierce" <[EMAIL PROTECTED]> writes: >> I was trying to check some permissions on functions and then I noticed >> that there's no command in psql to show that information. I've tried >> using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5. >> It would be an interesting addition

Re: [BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread John R Pierce
I was trying to check some permissions on functions and then I noticed that there's no command in psql to show that information. I've tried using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5. It would be an interesting addition to have that, as we do have the commands to show permiss

Re: [BUGS] Error starting service on Win2k

2004-09-20 Thread Magnus Hagander
>> You need two accounts. One administrator account that starts the >> installer (this could be "Administrator" or cours e- >definitly no need >> to create a special user for this). Another account which is >> used to run >> the eventual installed postgres. This is the account that you >> specif

Re: [BUGS] psql can not connect to the server on Win2000 NT

2004-09-20 Thread Magnus Hagander
>> Maybe you're right that there's something installed on my >computer that's >> bugging the postmaster. The only networking tool that I have >installed is >> NetLimiter > >This is a good example of a misleading error message, probably >resulting >from examining errno. Using GetLastError() on t

[BUGS] psql missing feature: show permissions for functions

2004-09-20 Thread Jorge Godoy
Hi, I was trying to check some permissions on functions and then I noticed that there's no command in psql to show that information. I've tried using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5. It would be an interesting addition to have that, as we do have the commands to show

Re: [BUGS] psql can not connect to the server on Win2000 NT

2004-09-20 Thread Andreas Pflug
Kouber Saparev wrote: This sounds a lot like FAQ item 3.2 on http://pginstaller.projects.postgresql.org/FAQ_windows.html. Check those instructions as a first step. Maybe you're right that there's something installed on my computer that's bugging the postmaster. The only networking tool that I have

Re: [BUGS] Error starting service on Win2k

2004-09-20 Thread Conal Tuohy
Magnus Hagander wrote: > >Firstly, I couldn't install postgresql as a Windows service > >using the installer - using the installer, I couldn't add > >postgresql as a Windows service without being a local > >administrator. However, if I was logged on as a local admin > >then the service would i

Re: [BUGS] psql can not connect to the server on Win2000 NT

2004-09-20 Thread Kouber Saparev
> This sounds a lot like FAQ item 3.2 on > http://pginstaller.projects.postgresql.org/FAQ_windows.html. Check those > instructions as a first step. Maybe you're right that there's something installed on my computer that's bugging the postmaster. The only networking tool that I have installed is Ne

[BUGS] BUG #1260: standard compilation

2004-09-20 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1260 Logged by: Blazej Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.3 Operating system: Red Hat 9.0 (without updates) Description:standard compilation Details: Posiible bug in contrib/intarray

Re: [BUGS] Money type not gone?

2004-09-20 Thread Andreas Pflug
Karel Zak wrote: On Mon, 2004-09-20 at 08:36 +, Andreas Pflug wrote: Karel Zak wrote: On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote: I want to rewrite it for 8.1 as numeric based datetype with some formatting extension probably with some internal stuff from to_char() familly. How about a t

Re: [BUGS] Money type not gone?

2004-09-20 Thread Karel Zak
On Mon, 2004-09-20 at 08:36 +, Andreas Pflug wrote: > Karel Zak wrote: > > On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote: > > > > > I want to rewrite it for 8.1 as numeric based datetype with some > > formatting extension probably with some internal stuff from to_char() > > familly. > >

Re: [BUGS] psql can not connect to the server on Win2000 NT

2004-09-20 Thread Magnus Hagander
> > This sounds a lot like FAQ item 3.2 on > > http://pginstaller.projects.postgresql.org/FAQ_windows.html. Check > > those instructions as a first step. > > Maybe you're right that there's something installed on my > computer that's bugging the postmaster. The only networking > tool that I ha

Re: [BUGS] Money type not gone?

2004-09-20 Thread Andreas Pflug
Karel Zak wrote: On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote: I want to rewrite it for 8.1 as numeric based datetype with some formatting extension probably with some internal stuff from to_char() familly. How about a type that is also able to hold an ISO currency identifier? After a long p

Re: [BUGS] Money type not gone?

2004-09-20 Thread Karel Zak
On Sun, 2004-09-19 at 15:29 -0400, Tom Lane wrote: > Josh Berkus <[EMAIL PROTECTED]> writes: > > Pardon me if this is redundant, but I've just noticed that the MONEY type > > still exists in 8.0b2.Didn't we say that we were getting rid of it? > > No, we never actually said we would get rid of