Re: [BUGS] BUG #2915: Not working: GRANT * TO GROUP *

2007-01-22 Thread Tom Lane
"Alvaro Alvarez" <[EMAIL PROTECTED]> writes: > I tried, using both the GUI and CLI: > GRANT CONNECT, TEMPORARY ON DATABASE db TO GROUP db_group; > But somehow the results was as if i had witten (even though there is no > db_group user): > GRANT CONNECT, TEMPORARY ON DATABASE db TO db_group; Since

Re: [BUGS] BUG #2914: SELECT query has no destination for result data

2007-01-22 Thread Tom Lane
"prasad" <[EMAIL PROTECTED]> writes: > i'm created a function > ... > Select * > from "vw_getAllMessages" > where "Message_Posted_To" = $1 > order by "Message_ID" desc; > ... > i get error > ERROR: SELECT query has no destination for result data > HINT: If you want to discard the results, use

[BUGS] BUG #2915: Not working: GRANT * TO GROUP *

2007-01-22 Thread Alvaro Alvarez
The following bug has been logged online: Bug reference: 2915 Logged by: Alvaro Alvarez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: Windows Vista Description:Not working: GRANT * TO GROUP * Details: Hello. I am trying to assign conn

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-22 Thread Adriaan van Os
Peter Eisentraut wrote: Adriaan van Os wrote: However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a result type. Yea, they are internally treated as very similar types. But "internally treated as very similar" is still not "same as argument type". Computing requires exactness. Asi

[BUGS] BUG #2916: SELECT query has no destination for result data

2007-01-22 Thread prasad mahit
The following bug has been logged online: Bug reference: 2916 Logged by: prasad mahit Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows Description:SELECT query has no destination for result data Details: Hi have created a function

Re: [HACKERS] [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-22 Thread Adriaan van Os
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: I presume the reason for that is that the first paramater can be qualified: select pg_get_serial_sequence('"public"."FOO"', 'Ff1'); Would someone explain why qualification makes us lowercase the first parameter by default? I don't und

[BUGS] BUG #2914: SELECT query has no destination for result data

2007-01-22 Thread prasad
The following bug has been logged online: Bug reference: 2914 Logged by: prasad Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: windows Description:SELECT query has no destination for result data Details: hi... i'm created a function --

Re: [BUGS] Troubles in Initializing Postgres Database 8.2

2007-01-22 Thread Maarten van der Heijden
Thanks for your answer. Manually starting InitDb causes the same error. I'll try starting InitDb with the pagefile enabled, let's see what happens. regards, maarten -Oorspronkelijk bericht- Van: Magnus Hagander [mailto:[EMAIL PROTECTED] Verzonden: zo 21-1-2007 18:23 Aan: Maarten van

[BUGS] BUG #2917: spi_prepare doesn't accept typename aliases such as 'integer'

2007-01-22 Thread Vlad Dan Dascalescu
The following bug has been logged online: Bug reference: 2917 Logged by: Vlad Dan Dascalescu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: RHEL AS 4 Description:spi_prepare doesn't accept typename aliases such as 'integer' Details: In

Re: [BUGS] BUG #2907: pg_get_serial_sequence quoting

2007-01-22 Thread Adriaan van Os
Bruce Momjian wrote: Strangely, this was reported before, but not until November of 2006: http://archives.postgresql.org/pgsql-general/2006-11/msg0.php That was a follow up on this thread . Regards, Adriaan van