[GENERAL] Allowing Other Users to Alter a Table

2012-03-13 Thread Jerry Richards
I'm getting this error: Error executing SQL ALTER TABLE ts_core.calls ALTER COLUMN call_uuid TYPE VARCHAR(255): ERROR: must be owner of relation calls Is there a way that I can configure postgresql so that it allows other users to alter this table? Thanks Much, Jerry -- Sent via

[GENERAL] Why Hard-Coded Version 9.1 In Names?

2012-01-30 Thread Jerry Richards
I just installed postgreSQL 9.1 and noticed it hard-codes the folder /var/lib/pgsql/9.1 and it hard-codes the service name to be postgresql91. My previous version of 8.4.4 uses the generic folder /var/lib/pgsql/data and the generic service name postgresql. This causes a problem for me because

[GENERAL] Is Synchronous Postgresql Replication Slower Than Asynchronous?

2012-01-20 Thread Jerry Richards
Is synchronous postgresql replication slower than asynchronous? If so, how much? I am looking into database replication for a phone system, so the response time is of concern. Thanks, Jerry

Re: [GENERAL] Is Synchronous Postgresql Replication Slower Than Asynchronous?

2012-01-20 Thread Jerry Richards
Replication Slower Than Asynchronous? On 20 January 2012 21:17, John R Pierce pie...@hogranch.com wrote: On 01/20/12 12:31 PM, Jerry Richards wrote: Is synchronous postgresql replication slower than asynchronous?  If so, how much?  I am looking into database replication for a phone system

[GENERAL] Does Version 9.1 Streaming Replication Supports Multi-Master?

2012-01-17 Thread Jerry Richards
I know PostgreSQL version 9.1 supports built-in streaming replication. Just wondering if that supports only a single-master or also multi-master implementation? Thanks, Jerry Sample disclaimer text

[GENERAL] Does Version 9.1 Streaming Replication Supports Multi-Master?

2012-01-17 Thread Jerry Richards
I know PostgreSQL version 9.1 supports built-in streaming replication. Just wondering if that supports only a single-master or also multi-master implementation? Thanks, Jerry Sample disclaimer text

[GENERAL] Trouble Accessing Schema-Qualified Table

2010-11-15 Thread Jerry Richards
Hello, I need to access a database using two different schemas. During initialization the default schema is set as follows: set schema 'ucm'; Then later, I need to get data from a table in another schema 'ts_sofia_internal', so I tried the following, but it returns an error as shown: teo=#

[GENERAL] Want FUNCTION to return argv[0] thru argv[6]

2010-07-28 Thread Jerry Richards
Hello, I am using postgres-odbc and I created the following function which is called from a C-application. This function returns a single argv[0] of the form (a,b,c,d,e,f,g). CREATE OR REPLACE FUNCTION PresRoute(int, int) RETURNS TABLE(d1 text, d2 text, d3 text, d4 text, r1 bigint, r2 bigint,

[GENERAL] Must be owner of function

2010-07-27 Thread Jerry Richards
I am using postgresql-odbc and trying to CREATE OR REPLACE FUNCTION... from my C-Application, however, I get must be owner of function ... error. If I execute the command logged in as postgres (i.e. su postgres), then I can execute the command. I think I tried to grant privileges to public for