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
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
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
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
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
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
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=#
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,
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