Re: [SQL] How to find out if an index is unique?

don't want to insert data to try. Greetings, Dirk ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi

Re: [SQL] Cascading deletions does not seem to work inside PL/PGSQL functions.

the recored in the master (M). so that i do not have to explicitly delete from each of the tables x,y,z, etc. actually i want to reinsert the records in the table x,y,z as well as M with some modification. sorry for my english. regds mallah. I'm not sure what you mean by this. -- Rajesh Kumar Mallah

[SQL] Cascading deletions does not seem to work inside PL/PGSQL functions.

--- -- 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. -- W A R N I N G --- scripts will delete tables t_master and t_slave and a function

Re: [SQL] INSERT only under certain conditions (SELECT)

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 Leading B2B eMarketplace

Re: [SQL] Can this be done with sql?

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. ---(end of broadcast

Re: [SQL] Is Dropping a column CHECK constraint possible?

Hi , i want to enforce that a coulumn 'imp' shud either contain valid data or no data at all. by valid data i mean data having at least one non whitespace character. will this constraint be approprote for accomplishing it? tradein_client= ALTER TABLE t_a ADD CHECK ( length( btrim(imp) )

[SQL] Is Dropping a column CHECK constraint possible?

] table DROP CONSTRAINT constraint { RESTRICT | CASCADE } 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

Re: [SQL] Is Dropping a column CHECK constraint possible?

or similar commands. I have read the docs for ALTER TABLE but the command described is not working for me. This should work, so long as you're using postgres 7.2+ ALTER TABLE t_a DROP CONSTRAINT aq RESTRICT; Chris -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network

Re: [SQL] how to write procedures

)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- 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

Re: [SQL] sequence chages after firing update

!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11

[SQL] Efficient Query For Mapping IP Addresses To Country Code.

: Seq Scan on ip_country_map (cost=0.00..1356.83 rows=5428 width=6) EXPLAIN access_log=# IS THERE ANYTHING woring with my database schema? how shud i be storing the the data of ipranges and country for efficient utilization in this problem. regds Rajesh Kumar Mallah, Project Manager

<    1   2