[ sorry if it is a repost, i am not sure if i am subscribed in -general ]
Dear List,
There are many opensource applications that support postgresql
(eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces)
as a result of which you are forced to use/create a new database and loose
have you tried Join using , eg
SELECT e.eid, e.name
FROM entry e join access a ON( e.eid = 120
AND (e.ownid = 66 OR e.aid = a.aid) ) ;
some sample data might also help in understanding the prob
more clrearly.
regds
rajesh kumar mallah.
On Fri, Feb 6, 2009 at 3:27 AM, Michael B Allen iop
On Jan 12, 2008 10:54 AM, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
Am I correct in understanding that the current behavior is inappropriate
and shall be corrected at some point of time in future versions ?
It's a bug, it's patched:
http
On Jan 12, 2008 1:26 AM, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
looks like constraint exclusion is being too aggressive in excluding null
values
Hmm, you're right. Looks like I broke it here:
http://archives.postgresql.org/pgsql-committers/2007-05
Hi ,
looks like constraint exclusion is being too aggressive in excluding null values
although its well known that check constraints apply on not null values only.
Hope the minimal test session below explains the problem we facing.
BTW: we are very impressed with the performance gains we achieved
Update the phenomenon does not exists in 8.2.0 but exists in 8.2.5.
On Jan 11, 2008 12:28 PM, Rajesh Kumar Mallah [EMAIL PROTECTED] wrote:
Hi ,
looks like constraint exclusion is being too aggressive in excluding null
values
although its well known that check constraints apply on not null
psql TRUNCATE TABLE tablename;
if you have too many tables , generate the above commands
by using a query on tables information schema table.
hope it helps.
On 3/29/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi list,
I have many tables with many constraints and I would like to empty all
the backup).
I think that's why pgAdmin does not work with plain backups on Restore.
What does occurs with the information schema when I restore from one database
with a name to other with another name ?
Regards
Ezequias
Em Thu, 29 Mar 2007 23:46:31 +0530
Rajesh Kumar Mallah [EMAIL PROTECTED
I dont think i clearly understand your requirement.
Are you wanting to restore the PLAIN backup of a database
with a different database name ?
Yes
Are you getting any particular error?
what platform are you in ?
what do you mean deleting information of current database ...
Clear all lines
On 2/24/07, Sumeet [EMAIL PROTECTED] wrote:
Hi all,
I'm trying to write a query to select random values from a set of 'GROUP
BY'
see the scenario below to understand the problem here (the actual
problem cannot be discussed here so i'm taking an example scenario)
Assume there is a table
:
Thanks Buddy, really appreciate ur help on this
problem solved...
Is there any way this query can be optimized...i'm running it on a huge
table with joins
- Sumeet
On 2/23/07, Rajesh Kumar Mallah [EMAIL PROTECTED] wrote:
On 2/24/07, Sumeet [EMAIL PROTECTED] wrote:
Hi all
Hi,
we know that rows in a table are not stored in any particular order
and explicit order by clause is required to get data in any particular
order.
but does it apply to select queries from ordered subselects also ?
eg
select id , name , expensive_func(name) from
( select id , name
On 12/11/06, Shoaib Mir [EMAIL PROTECTED] wrote:
I just noticed an abnormal behavior for the subquery:
create table myt1 (a numeric);
create table myt2 (b numeric);
select a from myt1 where a in (select a from myt2);
This should be giving an error that column 'a' does not exist in myt2
Hi,
I am trying to interate over column names of a table on which a C trigger
function is called on UPDATE/DELETE and INSERT. SPI function
char * SPI_fname(TupleDesc rowdesc, int colnumber)
is being used. looks like the function is returning column names like
pg.dropped.2 for
On 12/6/06, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
what is the proper way for iterating over column names of a table using
SPI_* functions.
You need to pay attention to the attisdropped field of the TupleDesc
entries.
thanks.
did the below
Hi ,
In certain C trigger function following code snippet causes ERROR:
---
elog (NOTICE , before calling DirectFunctionCall1);
data-time_stamp =
DirectFunctionCall1(timestamptz_in, CStringGetDatum(now));
elog (NOTICE , after calling
On 12/1/06, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
data-time_stamp =
DirectFunctionCall1(timestamptz_in, CStringGetDatum(now));
This code is incorrect, as timestamptz_in takes three arguments.
Dear Sir,
thanks for the kind reply.
field
On 12/1/06, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
data-time_stamp =
DirectFunctionCall1(timestamptz_in, CStringGetDatum(now));
This code is incorrect, as timestamptz_in takes three arguments.
replaced it with:
data-time_stamp
Hi ,
Is there any way to set a variable from a web application (using dbi/perl ,
libpq etc),
and access the same variable from a C trigger inside a transaction ?
the %_SHARED hash available in plperl provides only session level isolation
and
does not suit the requirement.
Original problem:
hi,
We do not want to modify our apps for doing auditing.
we are considering table level auditing
auditrail http://gborg.postgresql.org/project/audittrail/projdisplay.php
seems to be doing a good job. i just need to access the username
that starts the transaction in webapp from the trigger in
On 11/18/06, Volkan YAZICI [EMAIL PROTECTED] wrote:
Hi,
On Nov 18 06:00, Rajesh Kumar Mallah wrote:
Is there any way to set a variable from a web application (using
dbi/perl , libpq etc), and access the same variable from a C trigger
inside a transaction ?
Why don't you use a temporary
On 11/18/06, A. Kretschmer [EMAIL PROTECTED] wrote:
am Sat, dem 18.11.2006, um 23:02:33 +0530 mailte Rajesh Kumar Mallah
folgendes:
select bigint_column from your_table order by random() limit 1;
This query will tend to get slower as the table grows because of the
sorting.
Right
On 11/19/06, Tom Lane [EMAIL PROTECTED] wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
In our webapps, we use the same username to connect to the database
for all kind of updates. Hence we are not able to makeout whoo modified
what . However at application level we have different
On 10/26/05, Richard Huxton dev@archonet.com wrote:
Rajesh Kumar Mallah wrote:
Hi,
Can anyone tell me how to convert epoch to timestamp ?
ie reverse of :
SELECT EXTRACT( epoch FROM now() );
I'd start with either Google or the manuals.
http://www.postgresql.org/docs/8.0
Hi,
Can anyone tell me how to convert epoch to timestamp ?
ie reverse of :
SELECT EXTRACT( epoch FROM now() );
+--+
|date_part |
+--+
| 1130317518.61997 |
+--+
(1 row)
Regds
mallah.
---(end of
Basically, what I've got is the first person and the tag_type. I can do
it with a function from PHP:
function get_spouses($p) {
$handle = pg_query(select person from principals
where event in (select event from principals
where person = $p
On 9/23/05, Kenneth Hutchinson [EMAIL PROTECTED] wrote:
Hello,
I'm sorry if this has been sent to the community multiple times. I am
not able to determine whether my posts have gotten through. If you have
rec'd this multiple times, please let me know.
We have recently migrated to Postgres
Fuhr,Tom and Everyone
Extremely sorry for not consulting the docs.
I was doing this:
CREATE INDEX foo_name_idx ON foo (name)
WHERE name IS NOT NULL TABLESPACE testspace ;
Regds
Rajesh Kumar Mallah.
On 6/18/05, Michael Fuhr [EMAIL PROTECTED] wrote:
On Sat, Jun 18, 2005 at 10:24:06PM +0530
it in the TODO
Regds
Rajesh Kumar Mallah.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Ganesh,
Did you have a look at example Example 35-2. A PL/pgSQL
http://www.postgresql.org/docs/current/static/plpgsql-trigger.html
Regds
maLLAH
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi There,
We are using tsearch2 for FTS implementation. For highlighting the search term
in the result we are displaying the output of headline function which is
supposed to tag (mark up) those stemmed words in the text that match any of the
stemmed words in search term. The problem is that
. Is there any way to do such calculation using pgsql, i understand
bc is a better tool for it.
Warm Regards
Rajesh Kumar Mallah.
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered Users |
| Indias' Leading B2B
type casts.
tradein_clients=#
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered Users |
| Indias' Leading B2B eMarketPlace |
| http://www.tradeindia.com
and keywords).
So that the banners for the adword say 'incense exporter' is
shown even if 'incenses exporter' or 'incense exporters' is
searched.
I hope i am able to clarify.
Regds
Mallah.
Achilleus Mantzios wrote:
O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 :
Hi,
We want to compare
Achilleus Mantzios wrote:
O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 :
Dear Mantzios,
I have to get set of banners from database in
response to a search term. I want that the search term
be compared to the keyword corresponding to the
banners stored in database. current i am doing
)---
TIP 8: explain analyze is your friend
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered Users |
| Indias' Leading B2B eMarketPlace |
| http://www.tradeindia.com
Achilleus Mantzios wrote:
O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 :
Achilleus Mantzios wrote:
O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 :
Dear Mantzios,
I have to get set of banners from database in
response to a search term. I want that the search term
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
regds
Mallah.
Rajesh Kumar Mallah
+---+
| Tradeindia.com (3,11,246) Registered
Hi,
Is there any solution to this issue ? I am facing it every week.
Warm Regds
Mallah.
Rajesh Kumar Mallah wrote:
Tom Lane wrote:
[EMAIL PROTECTED] writes:
tradein_clients=# explain analyze select email_id ,email ,contact from
t_a a join email_source f using(email_id) join email_subscriptions
Tom Lane wrote:
[EMAIL PROTECTED] writes:
tradein_clients=# explain analyze select email_id ,email ,contact from
t_a a join email_source f using(email_id) join email_subscriptions h
using(email_id) where 1=1 and f.source_id =1 and h.sub_id = 3 ;
Runs for
Dear Darren,
Your question is not very clear to me.
On what columns do you want to aggregate?
suppose u want to aggregate on outsite and inside ip
you shud group by those columns and run a aggregate function
like sum or avg etc , suppose u want the total traffic for
every pair you can do this:
Even the first query used to run fine before but one fine day
it changed plans i think.
Regds
Mallah.
Rajesh Kumar Mallah wrote:
Tom Lane wrote:
[EMAIL PROTECTED] writes:
tradein_clients=# explain analyze select email_id ,email ,contact from
t_a a join email_source f using(email_id) join
Can you tell us about the postgresql versions in 7.3 and 9.0
also post the actuall error message from postgresql.
regds
mallah.
Ramesh Patel wrote:
Hi
i have one problem in Trigger.
this trigger alread work
on Red Hat Linux 7.3 but now i shift to RHL9.0
in RHL 9.0 not
working . in this problem
kumar wrote:
Dear Friends,
Postgres 7.3.2 on Linux 7.
I want to compare to columns and get the logical result as follows.
C1 is 'YNYNY' . C2 is 'NNYYY'.
I want to compare like AND and OR operators.
C1 AND C2 should give result like NNYNY.
C1 OR C2 should give result like YNYYY.
Bit
hi,
its not possible to join cross database tables .
you may keep tables in different schemas instead
of databases.
you may also try contrib/dblink to use tables from
different database.
Regds
mallah.
Pallav Kalva wrote:
Hi,
I am new to postgres and I need to do a query which joins two
Greetings!
My original problem is to de duplicate a list of around 0.3 million
company names.
Since a company name can be potentially (mis)spelt in numerous ways
exactmatch
obviously wont work.
To make the searches faster i am using tsearch. For each company name i
want to
search other
Greetings!
can anyone explain why
SELECT array_lower(array_prepend(0, ARRAY[1,2,3]), 1);
returns 0 not 1
because
tradein_clients=# SELECT array_prepend(0, ARRAY[1,2,3]);
+---+
| array_prepend |
+---+
| {0,1,2,3} |
+---+
(1 row)
and
tradein_clients=#
Dear PostgreSQL gurus,
How do people extend a parent view which has
lot of dependent views?
The parent view cannot be dropped because that will
require recreating a dozen of dependent views.
Is there any workaround.
Also is there an easy way of dumping the definitions
of all the dependent views
Rod Taylor wrote:
be recovered either. When committing a transaction the effects of all
operations that did not fail will be made permanent. This is how
transaction processing is described in the literature.
I would be interested in reading that (URLs please) as I didn't see
Hi Folks,
DELETE from eyp_listing where userid=t_a.userid and category_id=t_a.category_id;
such queries work perfectly.
but if t_a is a subquery how to accomplish the delete.
Regds
Mallah.
---(end of broadcast)---
TIP 5: Have you checked our
if the constraint are named $1 $2 etc you will need to quote them eg
ALTER TABLE xyz DROP CONSTRAINT $1 ;
in some version you may require
ALTER TABLE xyz DROP CONSTRAINT $1 RESTRICT;
What is ur version btw?
try to post the table structure also.
regds mallah.
Elielson Fontanezi wrote:
Hi
On Thursday 17 Jul 2003 8:21 am, Terence Kearns wrote:
select id from tablename where message like '%sql%';
If there any way to determine exactly how many times 'sql' is matched in
that search in each particular row, and then sort by the most matches,
or am I going to have to write a
Sir Devi,
This is PostgreSQL mailing List.
If you need help porting applications
from Oracle9i to PostgreSQL we might help.
Or if you have generic SQL question not specific
to any database we can also consider.
for help in Oracle specific problems there may
be more appropriate lists on the
Yes of course!
contrib/dbmirror does execute a procedure written in 'C'
called recordchange() ON update , insert , delete.
If you need help in getting its source lemme know.
regds
Mallah.
On Thursday 10 Jul 2003 11:10 am, adivi wrote:
hi,
can trigger proceedures ( procedures to be
Dear Bournon,
There are already good implementation of Tree
structures in databases ranging from using pure SQL
to PostgreSQL specfic methods , less point in
revinting wheel unless u really need.
Some Pointers:
Tree-structure functions
http://www.brasileiro.net:8080/postgres/cookbook/
Gist
dear ali,
something like
select machine,date_part('day' , date) , sum(withdrawals) from
Table where date_part('month' , date)='month in question' group by
machine,date_part('day' , date) ;
will give you agrregated withdrawals by machine and day,
use the frontend language for formatting it.
doesn't allow for 'replace everything NOT string';
Any Ideas?
Thanks in advance,
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace
?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast
'kill -9' the postmaster
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom
. Is there similar
in postgres ?
--
Popeanga Marian
DBA Oracle
CNLO Romania
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B
archives?
http://archives.postgresql.org
--
Regds
Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B
=#
tradein_clients=# SELECT count(*) from public.users where userid=-1;
count
---
0
(1 row)
tradein_clients=#
--
Regds
Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L
/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Regds
Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New
Thank you
i will look into its source code.
and try to find some solution for myself.
regds
mallah.
On Saturday 22 February 2003 07:40 am, Peter Eisentraut wrote:
Rajesh Kumar Mallah writes:
is it possible to get the function creation defination as produced by
pg_dump by some SQL
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast
: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Regds
Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading
Hi,
is it possible to get the function creation defination as produced by pg_dump
by some SQL queries on system catalogs?
pg_func stores procsrc but i am trying to get RETURNS and the arg part also.
--
Regds
Mallah
Rajesh Kumar Mallah,
Project
,
RI_ConstraintTrigger_29292779,
co_name_index_update,
last_updated,
set_category,
set_max_emails
tradein_clients=#
On Monday 03 February 2003 08:16 pm, Tom Lane wrote:
Rajesh Kumar Mallah. [EMAIL PROTECTED] writes:
tradein_clients=# explain SELECT
Thank you . But i have a problem ,
I think if i do that i will hve to immediately upgrade
all the 7.3.0 clients in other machines to 7.3.1 rite?
regds
Mallah.
On Monday 03 February 2003 09:10 pm, Tom Lane wrote:
Rajesh Kumar Mallah. [EMAIL PROTECTED] writes:
It is PostgreSQL 7.3.0
Thanks , if that is so i am upgrading it right away and posting
you the results. Its my live DB server :-)
Regds
mallah.
On Monday 03 February 2003 09:15 pm, Tom Lane wrote:
Rajesh Kumar Mallah. [EMAIL PROTECTED] writes:
I think if i do that i will hve to immediately upgrade
all
--
Regds Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)26152172 (221) (L) 9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast)---
TIP 5
Lane wrote:
Rajesh Kumar Mallah. [EMAIL PROTECTED] writes:
I think if i do that i will hve to immediately upgrade
all the 7.3.0 clients in other machines to 7.3.1 rite?
No.
regards, tom lane
pm, Wei Weng wrote:
Since which version PostgreSQL is able to do Vacuum Analyze even in the
middle of a transaction, namely, insert, delete, update?
Thanks
Wei
--
Regds Mallah
Rajesh Kumar Mallah,
Project
)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
--
Regds Mallah
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network
where id=2 will
not be accepted.
regds
mallah.
On Wednesday 01 January 2003 06:11 pm, Tomasz Myrta wrote:
Rajesh Kumar Mallah. wrote:
Hi we are working on re-structuring our database schemas and
intend to implement the functionality below at database level.
consider a master table
University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Rajesh Kumar
checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace
://cnx./rice.edu fax: 713-348-6182
Rice University MS-39
Houston, TX 77005
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91
YourEmailAddressHere to [EMAIL PROTECTED])
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast
an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's
)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace
| COIMBATORE
(4 rows)
Can anyone please explain the difference?
Regds
Mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace
group_id from eyp_listing group by group_id having count(distinct userid)
1 ;
always returns empty.
can it be done with some sort of UNIQUE INDEX?
Regds
MAllah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L
INDEX
regards,
bhuvaneswaran
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast
or was called by cascade trigger.
Regards,
wit
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91
with having the permission
can any one tell me how the prevention can be accomplished?
thanks in advance.
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com
in it,
I want to prevent DELETES on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table)
make superuser the database owner grant the rights needed to the users
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network
, Rajesh Kumar Mallah. wrote:
Hi ,
I have a created a database and a table in it,
I want to prevent DELETES on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table)
I have tried in many ways (ALTER TABLE REVOKE DELETE
??
regds
mallah.
I hope, it helps...
Dima
Rajesh Kumar Mallah. wrote:
Hi ,
I have a created a database and a table in it,
I want to prevent DELETES on the table in this
database by everyone except superuser postgres.
even by me (the creator of this database and table
Scan on eyp_rfi a (cost=0.00..17923.81 rows=5061 width=4)
EXPLAIN
tradein_clients=
==
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L
September 2002 12:07, Stephan Szabo wrote:
On Thu, 19 Sep 2002, Rajesh Kumar Mallah. wrote:
I am trying to improve a query to use existing indexes but facing
diffculty.
Looks like 'between' amd '=' are not using indexes althoug and does.
all my application code uses between and i am
).
is it just in terms of space requirements for performance too?
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace
=0.09..0.48 rows=50 loops=1)
- Index Scan using users_pkey on users b (cost=0.00..5.80 rows=1
width=29) (actual time=0.02..0.03 rows=1 loops=50)
Total runtime: 50.16 msec
EXPLAIN
tradein_clients=
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New
)
EXPLAIN
tradein_clients=#
Regards
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast
IF;
RETURN tmp_code;
END;
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
---(end of broadcast
~ '*.180.*' or path ~ '*.1.*'; is
better
written as
Qry3: SELECT path from unified_data where path ~ '*.180|1.*' ;
also is qry3 better to Qry2 in terms of performance?
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11
August 2002 22:30, Oleg Bartunov wrote:
On Fri, 2 Aug 2002, Rajesh Kumar Mallah. wrote:
Hi Oleg,
I am trying to use contrib/ltree for one of my applications.
the query below works fine for me.
Qry1: SELECT path from unified_data where path ~ '*.180.*' and path
~ '*.1
Hi
i did nothing but changed attribute name from 'login_cnt'
to 'cnt_login' and my update stmt started working?
I am using DBD::Pg + postgresql 7.2.1
i will try to produce a test case.
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
Thanks for your reply. Stephan.
On Thursday 18 July 2002 12:01, you wrote:
On Thu, 18 Jul 2002, Rajesh Kumar Mallah. wrote:
what if i do not want to fire sperate delete SQLs for the slave
tables ?
Hi ,
what is mean is that I a have many tables(x,y,z...) which reference
On Tuesday 16 July 2002 21:41, you wrote:
On Tue, 16 Jul 2002, Rajesh Kumar Mallah. wrote:
Hi folks,
This problem has been troubling me for quite sometime and
I would be very thankful for your help.
I have included the complete commented script to recreate the problem in
question
1 - 100 of 111 matches
Mail list logo