[BUGS] BUG #3592: alter function rename to doesn't work

2007-09-02 Thread Ow 

The following bug has been logged online:

Bug reference:  3592
Logged by:  Ow
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system:   Linux (gentoo)
Description:alter function rename to doesn't work
Details: 

=> create or replace function dbo.test(AA text) returns varchar(4) as
-> $$
$> BEGIN
$>return AA;
$> END;
$> $$ language plpgsql;
CREATE FUNCTION

=> select dbo.test('text');
 test
--
 text
(1 row)

=> alter function dbo.test(text) rename to dbo.test_rename;
ERROR:  syntax error at or near "."
LINE 1: alter function dbo.test(text) rename to dbo.test_rename;
   ^

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [BUGS] BUG #3592: alter function rename to doesn't work

2007-09-02 Thread Devrim GÜNDÜZ 
Hi,

On Sun, 2007-09-02 at 03:45 +, Ow wrote:
> 
> => alter function dbo.test(text) rename to dbo.test_rename;
> ERROR:  syntax error at or near "."
> LINE 1: alter function dbo.test(text) rename to dbo.test_rename;

AFAIK, the correct syntax is:

ALTER FUNCTION dbo.test(text) RENAME TO test_rename;

You should not specify schema name in the function. The new function
will be created in the same schema that the original function is
created.

Regards,
-- 
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/




signature.asc
Description: This is a digitally signed message part

[BUGS] BUG #3593: Postgres Installer does not work

2007-09-02 Thread Omkar Patkar 

The following bug has been logged online:

Bug reference:  3593
Logged by:  Omkar Patkar
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2.4.1
Operating system:   Windows Vista Home Basic Edition
Description:Postgres Installer does not work
Details: 

I tried to install postgres on Windows Vista Home Basic. It gave me two
problems :-

1) The UAC (User Access Control) of Windows Vista was blocking the installer
from creating a user account by the name "postgres"

2) I some how managed to disable the UAC, and was the installer was able to
create the user account for postgres. But the installer halted at one point
and the installation could not be proceeded.

The logs mentioned following  :-

The program "postgres" is needed by initdb but was not found in the
same directory as "C:/Development/Data/Database/PostgreSQL/8.2/bin/initdb".
Check your installation.

Can someone please suggest me any workaround for this ?

Million thanks in advance.

Omkar Patkar.

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: [BUGS] BUG #3592: alter function rename to doesn't work

2007-09-02 Thread Tom Lane 
"Ow" <[EMAIL PROTECTED]> writes:
> => alter function dbo.test(text) rename to dbo.test_rename;
> ERROR:  syntax error at or near "."
> LINE 1: alter function dbo.test(text) rename to dbo.test_rename;
>^

This is not correct syntax --- leave off the second "dbo.".

regards, tom lane

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [BUGS] BUG #3593: Postgres Installer does not work

2007-09-02 Thread Chris Travers 

Omkar Patkar wrote:

The following bug has been logged online:

Bug reference:  3593
Logged by:  Omkar Patkar
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2.4.1
Operating system:   Windows Vista Home Basic Edition
Description:Postgres Installer does not work
Details: 


I tried to install postgres on Windows Vista Home Basic. It gave me two
problems :-

1) The UAC (User Access Control) of Windows Vista was blocking the installer
from creating a user account by the name "postgres"
  


Hmmm Last time I tried (8.2.4) I had no problems installing on Vista 
Basic once I disabled UAC.


See if the following whitepaper helps:

http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx

2) I some how managed to disable the UAC, and was the installer was able to
create the user account for postgres. But the installer halted at one point
and the installation could not be proceeded.
  

Try:
1)  Disabling UAC
2)  Rebooting
3)  If it says it is installed, remove it through the controll panel
4)  Remove the C:\Program Files\PostgreSQL\8.2 directory
5)  Try again.

Note that win32 and general are probably better lists for this sort of 
issue to start on.


Best WIshes,
Chris Travers
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
tel;work:509-888-0220
tel;cell:509-630-7794
x-mozilla-html:FALSE
version:2.1
end:vcard


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match