pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed help
22+ messages / 15 participants
[nested] [flat]
* Need help
@ 2001-05-22 12:02 Hitesh Shah <hitesh_scjp@yahoo.com>
2001-05-22 20:59 ` Re: Need help Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 22+ messages in thread
From: Hitesh Shah @ 2001-05-22 12:02 UTC (permalink / raw)
To: pgsql-admin
Dear Sir,
I am working in private limited company in
Ahmedabad,Gujarat,India.In a company we have a network
of linux operating system & generally development is
on Java web and application side.We are using
postgresql as a backend in our esteemed
organisation,but we could not able to make that all
the database is available on server and user can
access those database.So to remove this type of
difficulty we need ur help?
Please kindly reply me on my e-mail address.My name
is Hitesh Shah and the address of a company is:
ZEN SOLUTIONS
9th floor,THE CHAMBERS
Gandhinagar-Sarkhej Highway
Oppo.Gurudwara
Ahmedabad
GUJARAT
INDIA
Thanks in advance.
Hitesh SHah
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help
2001-05-22 12:02 Need help Hitesh Shah <hitesh_scjp@yahoo.com>
@ 2001-05-22 20:59 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 22+ messages in thread
From: Peter Eisentraut @ 2001-05-22 20:59 UTC (permalink / raw)
To: Hitesh Shah <hitesh_scjp@yahoo.com>; +Cc: pgsql-admin
Hitesh Shah writes:
> I am working in private limited company in
> Ahmedabad,Gujarat,India.In a company we have a network
> of linux operating system & generally development is
> on Java web and application side.We are using
> postgresql as a backend in our esteemed
> organisation,but we could not able to make that all
> the database is available on server and user can
> access those database.So to remove this type of
> difficulty we need ur help?
Look into the pg_hba.conf file in your data directory, and in the
administrator's guide, chapter on client authentication, to enable access
to non-local hosts.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
^ permalink raw reply [nested|flat] 22+ messages in thread
* Need help
@ 2002-01-01 11:51 Shamik Majumder <shamik.majumder@wipro.com>
2002-01-08 15:17 ` Re: Need help Holger Krug <hkrug@rationalizer.com>
2002-01-08 17:17 ` Re: [GENERAL] Need help Jason Earl <jason.earl@simplot.com>
0 siblings, 2 replies; 22+ messages in thread
From: Shamik Majumder @ 2002-01-01 11:51 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Hi ,
We are facing some problems with the creation of tables of same name but
owned by different user .
We followed the following steps .
Lets say, we have a database DBTest and this database was created by the
user postgres.
We created tables - Table1, Table2 and Table3 in it.
Now, by using the createuser command - one more database user is
created, say dbuser1.
Now, when I login as dbuser1 on the DBTest database, I can see all the
tables Table1, Table2 and Table3 by /dt command.
Even, I am able to create new tables ( i.e table with new names ) in the
same database DBTest but with the owner dbuser1.
Now, when I try to create the same table like Table1 ( which has been
created by the
postgress user previously ) as dbuser1 user - the create table command
fails with the following o/p :
ERROR: Relation 'Table1' already exists
My question - is it possible in Postgres, to create the tables with
same name but with different users ?
i.e we create Table1 table both as postgres as well as dbuser1 .
Is it possible kindly let me know .
Thanks and Regards,
Shamik
Attachments:
InterScan_Disclaimer.txt (text/plain, 854B) download
-------------------------------------------------------------------------------------------------------------------------
Information transmitted by this E-MAIL is proprietary to Wipro and/or its Customers and
is intended for use only by the individual or entity to which it is
addressed, and may contain information that is privileged, confidential or
exempt from disclosure under applicable law. If you are not the intended
recipient or it appears that this mail has been forwarded to you without
proper authority, you are notified that any use or dissemination of this
information in any manner is strictly prohibited. In such cases, please
notify us immediately at mailto:mailadmin@wipro.com and delete this mail
from your records.
----------------------------------------------------------------------------------------------------------------------
* Re: Need help
2002-01-01 11:51 Need help Shamik Majumder <shamik.majumder@wipro.com>
@ 2002-01-08 15:17 ` Holger Krug <hkrug@rationalizer.com>
1 sibling, 0 replies; 22+ messages in thread
From: Holger Krug @ 2002-01-08 15:17 UTC (permalink / raw)
To: Shamik Majumder <shamik.majumder@wipro.com>; +Cc: pgsql-general@postgresql.org
On Tue, Jan 01, 2002 at 05:21:12PM +0530, Shamik Majumder wrote:
> My question - is it possible in Postgres, to create the tables with
> same name but with different users ?
No.
--
Holger Krug
hkrug@rationalizer.com
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [GENERAL] Need help
2002-01-01 11:51 Need help Shamik Majumder <shamik.majumder@wipro.com>
@ 2002-01-08 17:17 ` Jason Earl <jason.earl@simplot.com>
2002-01-08 20:23 ` Re: [SQL] Need help Bill Cunningham <billc@ballydev.com>
1 sibling, 1 reply; 22+ messages in thread
From: Jason Earl @ 2002-01-08 17:17 UTC (permalink / raw)
To: Shamik Majumder <shamik.majumder@wipro.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Why do you want a database where two tables have the same name? When
you do a "SELECT * from Table1" what table do you expect PostgreSQL to
use?
Now, that being said, it's possible to create temporary tables in
different connections with the same name. These tables will dissapear
when the connection is terminated, however. For example you could
have something like this:
conn1: CREATE TEMP TABLE foo (bar text);
conn2: CREATE TEMP TABLE foo (bar text);
conn1: INSERT INTO foo (bar) VALUES ('baz');
conn2: SELECT * from foo; [returns zero rows]
conn1: SELECT * from foo; [returns 'baz']
If you actually want two permanent tables with the same name, you are
going to have to put them in separate databases. Otherwise use
temporary tables.
Jason
Shamik Majumder <shamik.majumder@wipro.com> writes:
> Hi ,
>
> We are facing some problems with the creation of tables of same name
> but owned by different user .
>
> We followed the following steps .
>
> Lets say, we have a database DBTest and this database was created by
> the user postgres. We created tables - Table1, Table2 and Table3 in
> it. Now, by using the createuser command - one more database user
> is created, say dbuser1. Now, when I login as dbuser1 on the DBTest
> database, I can see all the tables Table1, Table2 and Table3 by /dt
> command. Even, I am able to create new tables ( i.e table with new
> names ) in the same database DBTest but with the owner dbuser1.
> Now, when I try to create the same table like Table1 ( which has
> been created by the postgress user previously ) as dbuser1 user -
> the create table command fails with the following o/p :
>
> ERROR: Relation 'Table1' already exists
>
> My question - is it possible in Postgres, to create the tables with
> same name but with different users ?
>
> i.e we create Table1 table both as postgres as well as dbuser1 .
>
> Is it possible kindly let me know .
>
> Thanks and Regards,
> Shamik
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [SQL] Need help
2002-01-01 11:51 Need help Shamik Majumder <shamik.majumder@wipro.com>
2002-01-08 17:17 ` Re: [GENERAL] Need help Jason Earl <jason.earl@simplot.com>
@ 2002-01-08 20:23 ` Bill Cunningham <billc@ballydev.com>
2002-01-09 00:04 ` Re: [SQL] Need help Doug McNaught <doug@wireboard.com>
0 siblings, 1 reply; 22+ messages in thread
From: Bill Cunningham @ 2002-01-08 20:23 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Actually this concept is used in production environments or classes for
seperating student's school work.
I can see the need to create a Table1 under several different names.
Does postgresql have a schema concept like so:
dbuser1.Table1
postgres.Table1
This is how DB2 does it.
- Bill Cunningham
Technical Lead
Bally Gaming and Systems
Jason Earl wrote:
>Why do you want a database where two tables have the same name? When
>you do a "SELECT * from Table1" what table do you expect PostgreSQL to
>use?
>
>Now, that being said, it's possible to create temporary tables in
>different connections with the same name. These tables will dissapear
>when the connection is terminated, however. For example you could
>have something like this:
>
>conn1: CREATE TEMP TABLE foo (bar text);
>conn2: CREATE TEMP TABLE foo (bar text);
>conn1: INSERT INTO foo (bar) VALUES ('baz');
>conn2: SELECT * from foo; [returns zero rows]
>conn1: SELECT * from foo; [returns 'baz']
>
>If you actually want two permanent tables with the same name, you are
>going to have to put them in separate databases. Otherwise use
>temporary tables.
>
>Jason
>
>Shamik Majumder <shamik.majumder@wipro.com> writes:
>
>>Hi ,
>>
>>We are facing some problems with the creation of tables of same name
>>but owned by different user .
>>
>>We followed the following steps .
>>
>>Lets say, we have a database DBTest and this database was created by
>>the user postgres. We created tables - Table1, Table2 and Table3 in
>>it. Now, by using the createuser command - one more database user
>>is created, say dbuser1. Now, when I login as dbuser1 on the DBTest
>>database, I can see all the tables Table1, Table2 and Table3 by /dt
>>command. Even, I am able to create new tables ( i.e table with new
>>names ) in the same database DBTest but with the owner dbuser1.
>>Now, when I try to create the same table like Table1 ( which has
>>been created by the postgress user previously ) as dbuser1 user -
>>the create table command fails with the following o/p :
>>
>>ERROR: Relation 'Table1' already exists
>>
>>My question - is it possible in Postgres, to create the tables with
>>same name but with different users ?
>>
>>i.e we create Table1 table both as postgres as well as dbuser1 .
>>
>>Is it possible kindly let me know .
>>
>>Thanks and Regards,
>>Shamik
>>
>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [SQL] Need help
2002-01-01 11:51 Need help Shamik Majumder <shamik.majumder@wipro.com>
2002-01-08 17:17 ` Re: [GENERAL] Need help Jason Earl <jason.earl@simplot.com>
2002-01-08 20:23 ` Re: [SQL] Need help Bill Cunningham <billc@ballydev.com>
@ 2002-01-09 00:04 ` Doug McNaught <doug@wireboard.com>
0 siblings, 0 replies; 22+ messages in thread
From: Doug McNaught @ 2002-01-09 00:04 UTC (permalink / raw)
To: Bill Cunningham <billc@ballydev.com>; +Cc: pgsql-general@postgresql.org
Bill Cunningham <billc@ballydev.com> writes:
> Actually this concept is used in production environments or classes
> for seperating student's school work.
>
> I can see the need to create a Table1 under several different
> names. Does postgresql have a schema concept like so:
> dbuser1.Table1
> postgres.Table1
>
> This is how DB2 does it.
I understand that schemas are tentatively planned for 7.3, but they
are not currently available.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [GENERAL] Need help
@ 2002-01-09 09:47 Maarten.Boekhold@reuters.com
0 siblings, 0 replies; 22+ messages in thread
From: Maarten.Boekhold@reuters.com @ 2002-01-09 09:47 UTC (permalink / raw)
To: Jason Earl <jason.earl@simplot.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org; shamik.majumder@wipro.com
On 01/08/2002 09:17:03 PM Jason Earl wrote:
> Why do you want a database where two tables have the same name? When
> you do a "SELECT * from Table1" what table do you expect PostgreSQL to
> use?
I suspect Shamik is trying to do something like having a separate 'schema'
(Oracle) for every user, and in Oracle it is possible to create tables
with the same name but in different schemas.
Maarten
----
Maarten Boekhold, maarten.boekhold@reuters.com
Reuters Consulting / TIBCO Finance Technology Inc.
Dubai Media City
Building 1, 5th Floor
PO Box 1426
Dubai, United Arab Emirates
tel:+971(0)4 3918300 ext 249
fax:+971(0)4 3918333
mob:+971(0)505526539
-------------------------------------------------------------- --
Visit our Internet site at http://www.reuters.com
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Need help
@ 2004-10-20 18:57 Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 19:41 ` Re: Need help Joshua D. Drake <jd@commandprompt.com>
2004-10-20 21:53 ` Re: Need help Scott Marlowe <smarlowe@qwest.net>
0 siblings, 2 replies; 22+ messages in thread
From: Chris White (cjwhite) @ 2004-10-20 18:57 UTC (permalink / raw)
To: pgsql-admin
I am running 7.4.2 and I am seeing a strange error. I am using jdbc to
update a table with the following statement:
update vm_message set usecount=4 where messsage id='1234567';
this statements generates a PSQLException with the following message:
ERROR: duplicate key violates unique constraint "vm_message_pkey"
I don't understand why I am getting this message because the primary key for
table vm_message is messageid and this is not being changed
Any body have any ideas?
Chris White
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help
2004-10-20 18:57 Need help Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-10-20 19:41 ` Joshua D. Drake <jd@commandprompt.com>
2004-10-20 20:31 ` Re: Need help Chris White (cjwhite) <cjwhite@cisco.com>
1 sibling, 1 reply; 22+ messages in thread
From: Joshua D. Drake @ 2004-10-20 19:41 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-admin
> ERROR: duplicate key violates unique constraint "vm_message_pkey"
>
> I don't understand why I am getting this message because the primary key
> for table vm_message is messageid and this is not being changed
>
> Any body have any ideas?
7.4.2 is know to have index issues. Try reindexing the primary key and
executing the query again.
Sincerely,
Joshua D. Drake
>
> Chris White
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Attachments:
jd.vcf (text/x-vcard, 638B) download
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
* Re: Need help
2004-10-20 18:57 Need help Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 19:41 ` Re: Need help Joshua D. Drake <jd@commandprompt.com>
@ 2004-10-20 20:31 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 20:41 ` Re: Need help Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 22+ messages in thread
From: Chris White (cjwhite) @ 2004-10-20 20:31 UTC (permalink / raw)
To: 'Joshua D. Drake' <jd@commandprompt.com>; +Cc: pgsql-admin
That doesn't help me because this is running in an embedded system that
should have little or no db admin. Anybody suggest what version I should be
running?
Chris
-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Wednesday, October 20, 2004 12:42 PM
To: cjwhite@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need help
> ERROR: duplicate key violates unique constraint "vm_message_pkey"
>
> I don't understand why I am getting this message because the primary
> key for table vm_message is messageid and this is not being changed
>
> Any body have any ideas?
7.4.2 is know to have index issues. Try reindexing the primary key and
executing the query again.
Sincerely,
Joshua D. Drake
>
> Chris White
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help
2004-10-20 18:57 Need help Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 19:41 ` Re: Need help Joshua D. Drake <jd@commandprompt.com>
2004-10-20 20:31 ` Re: Need help Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-10-20 20:41 ` Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 22+ messages in thread
From: Joshua D. Drake @ 2004-10-20 20:41 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-admin
Chris White (cjwhite) wrote:
> That doesn't help me because this is running in an embedded system that
> should have little or no db admin. Anybody suggest what version I should be
> running?
7.4.5.
Sincerely,
Joshua D. Drake
>
> Chris
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Wednesday, October 20, 2004 12:42 PM
> To: cjwhite@cisco.com
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Need help
>
>
>>ERROR: duplicate key violates unique constraint "vm_message_pkey"
>>
>>I don't understand why I am getting this message because the primary
>>key for table vm_message is messageid and this is not being changed
>>
>>Any body have any ideas?
>
>
> 7.4.2 is know to have index issues. Try reindexing the primary key and
> executing the query again.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>>
>>Chris White
>
>
>
> --
> Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
> Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Attachments:
jd.vcf (text/x-vcard, 638B) download
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
* Re: Need help
2004-10-20 18:57 Need help Chris White (cjwhite) <cjwhite@cisco.com>
@ 2004-10-20 21:53 ` Scott Marlowe <smarlowe@qwest.net>
2004-10-20 23:09 ` Re: Need help Chris White (cjwhite) <cjwhite@cisco.com>
1 sibling, 1 reply; 22+ messages in thread
From: Scott Marlowe @ 2004-10-20 21:53 UTC (permalink / raw)
To: cjwhite@cisco.com; +Cc: pgsql-admin
On Wed, 2004-10-20 at 12:57, Chris White (cjwhite) wrote:
> I am running 7.4.2 and I am seeing a strange error. I am using jdbc to
> update a table with the following statement:
>
> update vm_message set usecount=4 where messsage id='1234567';
Is that really your query, cut and pasted? Is that space between
message and id supposed to be there? Just wondering.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help
2004-10-20 18:57 Need help Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 21:53 ` Re: Need help Scott Marlowe <smarlowe@qwest.net>
@ 2004-10-20 23:09 ` Chris White (cjwhite) <cjwhite@cisco.com>
0 siblings, 0 replies; 22+ messages in thread
From: Chris White (cjwhite) @ 2004-10-20 23:09 UTC (permalink / raw)
To: 'Scott Marlowe' <smarlowe@qwest.net>; +Cc: pgsql-admin
It was a mistype, it was not a cut and paste, as I do not have email on the
system that has access to the system running the DB. There is meant to be no
space in messageid
-----Original Message-----
From: Scott Marlowe [mailto:smarlowe@qwest.net]
Sent: Wednesday, October 20, 2004 2:53 PM
To: cjwhite@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need help
On Wed, 2004-10-20 at 12:57, Chris White (cjwhite) wrote:
> I am running 7.4.2 and I am seeing a strange error. I am using jdbc to
> update a table with the following statement:
>
> update vm_message set usecount=4 where messsage id='1234567';
Is that really your query, cut and pasted? Is that space between message
and id supposed to be there? Just wondering.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Need Help
@ 2005-08-26 12:23 Gourish Singbal <gourish@gmail.com>
0 siblings, 0 replies; 22+ messages in thread
From: Gourish Singbal @ 2005-08-26 12:23 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I was going through pg_resetxlog manual page.
and found the following line confusing.
"For example, if 000000FF0000003A is the largest entry in pg_xlog, -l
0xFF,0x3B will work. " with respect to calculating the -l value for
pg_resetxlog .
please could someone explain this calculation in simple terms.
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 22+ messages in thread
* Need help...
@ 2015-09-23 22:52 Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
2015-09-23 23:27 ` Re: Need help... David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 22+ messages in thread
From: Tirumalaraju, Ravikumar (GE Corporate, consultant) @ 2015-09-23 22:52 UTC (permalink / raw)
To: pgsql-admin
Hi Team,
I am trying to use postgresql (greenplum) connection to OBIEE application. My application server is linux ( Red Hat Enterprise Linux Server release 5.4.)
Please let me know if I need to install postgresql driver in my linux box. Appreciate your help.
Thanks,
Ravi.
Cell: 4758820029
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help...
2015-09-23 22:52 Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
@ 2015-09-23 23:27 ` David G. Johnston <david.g.johnston@gmail.com>
2015-09-24 00:38 ` Re: Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
0 siblings, 1 reply; 22+ messages in thread
From: David G. Johnston @ 2015-09-23 23:27 UTC (permalink / raw)
To: Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>; +Cc: pgsql-admin
On Wed, Sep 23, 2015 at 6:52 PM, Tirumalaraju, Ravikumar (GE Corporate,
consultant) <ravikumar.tirumalaraju@ge.com> wrote:
> Hi Team,
>
> I am trying to use postgresql (greenplum) connection to OBIEE application.
> My application server is linux ( Red Hat Enterprise Linux Server release
> 5.4.)
>
> Please let me know if I need to install postgresql driver in my linux box.
> Appreciate your help.
>
> Thanks,
>
> Ravi.
>
> Cell: 4758820029
>
>
>
Are you sure you sent this to the right location?
David J.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help...
2015-09-23 22:52 Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
2015-09-23 23:27 ` Re: Need help... David G. Johnston <david.g.johnston@gmail.com>
@ 2015-09-24 00:38 ` Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
2015-09-24 01:52 ` Re: Need help... David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 22+ messages in thread
From: Tirumalaraju, Ravikumar (GE Corporate, consultant) @ 2015-09-24 00:38 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-admin
Sorry I am not sure. Just checked this address in google and tried to reach out.
Please suggest if you have any idea.
Thanks,
Ravi.
From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Wednesday, September 23, 2015 7:28 PM
To: Tirumalaraju, Ravikumar (GE Corporate, consultant)
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need help...
On Wed, Sep 23, 2015 at 6:52 PM, Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com<mailto:ravikumar.tirumalaraju@ge.com>> wrote:
Hi Team,
I am trying to use postgresql (greenplum) connection to OBIEE application. My application server is linux ( Red Hat Enterprise Linux Server release 5.4.)
Please let me know if I need to install postgresql driver in my linux box. Appreciate your help.
Thanks,
Ravi.
Cell: 4758820029<tel:4758820029>
Are you sure you sent this to the right location?
David J.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Need help...
2015-09-23 22:52 Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
2015-09-23 23:27 ` Re: Need help... David G. Johnston <david.g.johnston@gmail.com>
2015-09-24 00:38 ` Re: Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
@ 2015-09-24 01:52 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 22+ messages in thread
From: David G. Johnston @ 2015-09-24 01:52 UTC (permalink / raw)
To: Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>; +Cc: pgsql-admin
On Wednesday, September 23, 2015, Tirumalaraju, Ravikumar (GE Corporate,
consultant) <ravikumar.tirumalaraju@ge.com> wrote:
> Sorry I am not sure. Just checked this address in google and tried to
> reach out.
>
>
>
> Please suggest if you have any idea.
>
>
>
> Thanks,
>
> Ravi.
>
>
>
> *From:* David G. Johnston [mailto:david.g.johnston@gmail.com
> <javascript:_e(%7B%7D,'cvml','david.g.johnston@gmail.com');>]
> *Sent:* Wednesday, September 23, 2015 7:28 PM
> *To:* Tirumalaraju, Ravikumar (GE Corporate, consultant)
> *Cc:* pgsql-admin@postgresql.org
> <javascript:_e(%7B%7D,'cvml','pgsql-admin@postgresql.org');>
> *Subject:* Re: [ADMIN] Need help...
>
>
>
> On Wed, Sep 23, 2015 at 6:52 PM, Tirumalaraju, Ravikumar (GE Corporate,
> consultant) <ravikumar.tirumalaraju@ge.com
> <javascript:_e(%7B%7D,'cvml','ravikumar.tirumalaraju@ge.com');>> wrote:
>
> Hi Team,
>
> I am trying to use postgresql (greenplum) connection to OBIEE application.
> My application server is linux ( Red Hat Enterprise Linux Server release
> 5.4.)
>
> Please let me know if I need to install postgresql driver in my linux box.
> Appreciate your help.
>
> Thanks,
>
> Ravi.
>
> Cell: 4758820029
>
>
>
>
>
> Are you sure you sent this to the right location?
>
>
>
> David J.
>
>
>
>
>
I'd suggest you ask whomever provides this OBIEE application (whatever that
is).
David J.
^ permalink raw reply [nested|flat] 22+ messages in thread
* need help
@ 2020-04-22 14:44 Ashok kumar Mani <amani@accelaero.com>
2020-04-22 14:50 ` Re: need help David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 22+ messages in thread
From: Ashok kumar Mani @ 2020-04-22 14:44 UTC (permalink / raw)
To: pgsql-admin; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Classification: Internal
Dear All
Could you please some one help on this below issue ? I could n;t able to find any meaning on this below?
test=# drop user amosuser_test;
ERROR: role "amosuser_test" cannot be dropped because some objects depend on it
DETAIL: privileges for database test
test=#
Best Wishes,
Ashok
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: need help
2020-04-22 14:44 need help Ashok kumar Mani <amani@accelaero.com>
@ 2020-04-22 14:50 ` David G. Johnston <david.g.johnston@gmail.com>
2020-04-22 14:53 ` RE: need help Ashok kumar Mani <amani@accelaero.com>
0 siblings, 1 reply; 22+ messages in thread
From: David G. Johnston @ 2020-04-22 14:50 UTC (permalink / raw)
To: Ashok kumar Mani <amani@accelaero.com>; +Cc: pgsql-admin; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Wed, Apr 22, 2020 at 7:45 AM Ashok kumar Mani <amani@accelaero.com>
wrote:
> Classification: Internal
>
> Dear All
>
>
>
> Could you please some one help on this below issue ? I could n;t able to
> find any meaning on this below?
>
>
>
> test=# drop user amosuser_test;
>
> ERROR: role "amosuser_test" cannot be dropped because some objects depend
> on it
>
> DETAIL: privileges for database test
>
> test=#
>
>
>
^ permalink raw reply [nested|flat] 22+ messages in thread
* RE: need help
2020-04-22 14:44 need help Ashok kumar Mani <amani@accelaero.com>
2020-04-22 14:50 ` Re: need help David G. Johnston <david.g.johnston@gmail.com>
@ 2020-04-22 14:53 ` Ashok kumar Mani <amani@accelaero.com>
0 siblings, 0 replies; 22+ messages in thread
From: Ashok kumar Mani @ 2020-04-22 14:53 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-admin; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Classification: External
Dear David,
I fixed the issue as below which worked for me . thanks for your quick help
test=# DROP OWNED BY amosserver_test;
DROP OWNED
test=# DROP OWNED BY amosuser_test;
DROP OWNED
test=# drop role amosserver_test;
DROP ROLE
test=# drop role amosuser_test;
DROP ROLE
test=#
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Wednesday, April 22, 2020 6:51 PM
To: Ashok kumar Mani <amani@accelaero.com>
Cc: pgsql-admin@postgresql.org; pgsql-admin@lists.postgresql.org
Subject: Re: need help
Information Security Email Alert: This email is from an EXTERNAL source. Please use caution when clicking on links or opening attachments from an unknown or suspicious sender. To report a suspected phishing email, Send us an Email on Servicedesk@accelaero.com<mailto:Servicedesk@accelaero.com>
On Wed, Apr 22, 2020 at 7:45 AM Ashok kumar Mani <amani@accelaero.com<mailto:amani@accelaero.com>> wrote:
Classification: Internal
Dear All
Could you please some one help on this below issue ? I could n;t able to find any meaning on this below?
test=# drop user amosuser_test;
ERROR: role "amosuser_test" cannot be dropped because some objects depend on it
DETAIL: privileges for database test
test=#
^ permalink raw reply [nested|flat] 22+ messages in thread
end of thread, other threads:[~2020-04-22 14:53 UTC | newest]
Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-22 12:02 Need help Hitesh Shah <hitesh_scjp@yahoo.com>
2001-05-22 20:59 ` Peter Eisentraut <peter_e@gmx.net>
2002-01-01 11:51 Need help Shamik Majumder <shamik.majumder@wipro.com>
2002-01-08 15:17 ` Holger Krug <hkrug@rationalizer.com>
2002-01-08 17:17 ` Jason Earl <jason.earl@simplot.com>
2002-01-08 20:23 ` Bill Cunningham <billc@ballydev.com>
2002-01-09 00:04 ` Doug McNaught <doug@wireboard.com>
2002-01-09 09:47 Re: [GENERAL] Need help Maarten.Boekhold@reuters.com
2004-10-20 18:57 Need help Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 19:41 ` Joshua D. Drake <jd@commandprompt.com>
2004-10-20 20:31 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-10-20 20:41 ` Joshua D. Drake <jd@commandprompt.com>
2004-10-20 21:53 ` Scott Marlowe <smarlowe@qwest.net>
2004-10-20 23:09 ` Chris White (cjwhite) <cjwhite@cisco.com>
2005-08-26 12:23 Need Help Gourish Singbal <gourish@gmail.com>
2015-09-23 22:52 Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
2015-09-23 23:27 ` Re: Need help... David G. Johnston <david.g.johnston@gmail.com>
2015-09-24 00:38 ` Re: Need help... Tirumalaraju, Ravikumar (GE Corporate, consultant) <ravikumar.tirumalaraju@ge.com>
2015-09-24 01:52 ` Re: Need help... David G. Johnston <david.g.johnston@gmail.com>
2020-04-22 14:44 need help Ashok kumar Mani <amani@accelaero.com>
2020-04-22 14:50 ` Re: need help David G. Johnston <david.g.johnston@gmail.com>
2020-04-22 14:53 ` RE: need help Ashok kumar Mani <amani@accelaero.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox