I'm running PostgreSQL 8.3 on Kubuntu 8.04. My goal is to create a
database with one user as its owner, and another as a user with
non-administrative access to this database that I'll use as the runtime
user for a web application. As the user "postgres", I executed the
following commands in p
Hello when i connect to my database using PgAdmin· I get this message:
Server lacks of instrumentation functions.
I know That i need to run the admin81.sql script, but I don't know if my
distribution has compiled postgresql to support that functions.
I installed the postgresql-contrib, but I don't
On 2008-07-19, at 10:00, Govind wrote:
Hi all,
Like oracle dblink, is it possible to connect two database's in
greenplum??? If yes please pass the command how to create the dblink
to connect two databases.
Regards
Govindarajan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.o
On Sat, Jul 19, 2008 at 04:29:00PM +0530, Kartik wrote:
> hello there,i am new to postgresql
> i am using postgresql 8.3.3 and i am writing one whole transaction. i want
> to know how to set auto commit off
> because if any error occours i want the whole transaction to be rolled back.
> when i trie
Hi all,
Like oracle dblink, is it possible to connect two database's in
greenplum??? If yes please pass the command how to create the dblink
to connect two databases.
Regards
Govindarajan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
ht
hello there,i am new to postgresql
i am using postgresql 8.3.3 and i am writing one whole transaction. i want
to know how to set auto commit off
because if any error occours i want the whole transaction to be rolled back.
when i tried alter database dbname set autocommit = off
then it gives me erro
[EMAIL PROTECTED] ("ria ulfa") writes:
> i want to copy table from file with command:
> COPY log FROM '/tmp/logfile.txt';
> but there is error:
> ERROR: could not open file "/tmp/logfile.txt" for reading: Permission
> denied
> what can i do for repair this error??
> thanks for the answer
I use 8.03.02.00 version driver.
> On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI
> <[EMAIL PROTECTED]> wrote:
>> Hi all,
>> I have a problem with dblink from oracle to postgresql.
>>
>> I cannot read varchar colums from postgresql db, in the trace file the
>> message is in the trace file is
