[ADMIN] 8.3 and 8.4 feature list

Hi, I am migrating from Sybase to Postgres. trying to get a hold on the issue of future releases feature list. 1. Where can I find the feature list for 8.3 ? When is it expected? 2. And for 8.4? 3. Who is the guy to ask about a feature like "startup migrate" in ORACLE? Thanks Danny -

[ADMIN] anonymous block in Postgres - Hello World

#!/bin/sh psql --quiet -t << EOF declare x varchar(80); begin x:='Hello World'; raise notice x; end; \q EOF == Hi, This code is my first "like Oracle anonymous blocl". It does not go through. Can anyone help? Thanks Danny

[ADMIN] Windows 8.2.4 installation

Hi, I am building a Windows installation by copying all the .exe and .dll files to a single \bin file. I am, then, testing by running "pg_ctl -help" and nothing comes out. The Path is set properly. Thanks Danny Abraham BMC Software CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

[ADMIN] Bug #2993 on PG 8.2.4

Does anybody know a workaround for it? Is there a place where I can look up this bug? Thanks Danny Abraham [EMAIL PROTECTED]

[ADMIN] Tablespace on Windpws

How can I use Tablespaces on Windows? Danny Abraham CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

[ADMIN] How can I tell that the underlying OS is Windows?

[ADMIN] plpgsql debugger

Can someone help? Need a plpgsql debugger. Thanks Danny Abraham CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

[ADMIN] "CREATE TABLESPACE" cannot run within a Stored Procedure - "Inside a transaction bloc"

Hi, Is there a way to run CREATE TABLESOACE,DATABASE etc. winthin a stored procedure? Thanks Danny

[ADMIN] My mails to the forum get garbled, and a new line is being inserted. Why? How?

Thanks Danny Abraham [EMAIL PROTECTED]

[ADMIN] Is there a way to run CREATE TABLESPACE within a stored procedure?

Fails on: Cannot run inside a transaction block. Thanks Danny ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

[ADMIN] Running "create database" using dblink_exe and gets locked forever

The statement is perfectly legal. Danny Abraham CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

[ADMIN] Can I retrieve NOTICE info from within a Stored Procedure?

Thanks Danny Abraham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] How do I run OS commands (like df -k) from within PLPGSQL

Thanks Danny Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

[ADMIN] How do I do a dynamic - select now() + interval X days ?

Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] ---(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

[ADMIN] initdb fails on Windows - some shared memory problem

And here are the logs 2007-11-08 15:25:39.493 DEBUG: invoking IpcMemoryCreate(size=67633152) 2007-11-08 15:25:39.493 DEBUG: mapped win32 error code 161 to 2 2007-11-08 15:25:39.493 FATAL: could not create shared memory segment: No such file or directory 2007-11-08 15:25:39.493 DETAI

[ADMIN] pg_ctl fails: ISTFATAL: could not open lock file "/tmp/.s.PGSQL.5433.lock": Permission denied

Linux -SUSE 9 05.02.2008-18.03.26 failed starting PG server 05.02.2008-18.03.26 server starting 05.02.2008-18.03.26 2008-02-05 17:59:41.831 ISTLOG: could not bind IPv4 socket: Address already in use 05.02.2008-18.03.26 2008-02-05 17:59:41.831 ISTHINT: Is another postmaste

[ADMIN] Looking for performance monitoring tool for PG

Any ideas or refeneces? Can be either for Unix or Windows Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [EMAIL PROTECTED] -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-adm

[ADMIN] winsock error 10061 on Vista

Application cannot connect to PG after successful recovery. Happens on both Vista and Server 2008. never happens on XP/2003. 2008-08-27 14:05:03.484 FATAL: the database system is starting up 2008-08-27 14:05:03.609 LOG: database system is ready 2008-08-27 14:05:10.218 LOG: could not receive da

[ADMIN] Can't install PG on a Windows Domain Controller

Hi, Can anybody help with this Windows question? Since PG requires a local (weak) user to own the service, And since a DC cannot have local user, Can I assume that we cannot install PG on a Windows DC? We are on PG V8.2.4. Thanks Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 [

[ADMIN] initdb --encoding=LATIN1 fails on Windows

The same command worked fine on PG 8.2.4. Now, using 8.3.7, we are forced into WIN1252. Thanks Danny -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] WHo is locking me?

Hi, A process hangs forever. When using this query... SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s where pg_stat_get_backend_activity(s.backendid) not like

[ADMIN] How do I elimitae ANY loggin to Windows Eventlog - event the logger shutdown msg? 8.2.4.

Danny Abraham BMC Software CTM&D Business Unit 972-52-4286-513 danny_abra...@bmc.com