[GENERAL] Scanning the PGSQL DB

perfect ...I mean my DB is not corrupted. Are there any tools/commands to check whether my DB is not corrupted? Once I did a kill -9 and my DB got corrupted. I am looking for some tools that will say the status of my DB. Thanks in advance, Anil. ---(end of broadcast

Re: [GENERAL] Scanning the PGSQL DB

Thanks for the reply. I can do a select of some basic tables, but I was looking for some scanner sort of thing. I am not running with the disabled sync. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://arch

[GENERAL] SQL Help

1031 06-30-1998 06-23-1998 2077 1055 06-30-1998 01-01-1998 987 How do I do this?? Thank you very much in advance for any thoughts. Cheers Anil

[GENERAL] Strange behavior of insert CTE with trigger

Hi, I am trying to wrap my head around a strange problem I am having. I have double checked the documentation but I could not find anything on this. I am attaching a simplified version of my problem. I my TEST 4 I expect 1 row but I get nothing. The test is with I(id) as ( insert into abc(colD

Re: [GENERAL] schema or database

In addition to all these comments - If you use multiple databases, if you want to keep some "common" tables (example counties_Table, My_company_details), its going to be a pain - if you want to access tables across databases - you might need to start using FDWs (which is going to be a administrati

Re: [GENERAL] [SQL] function to send email with query results

Using Apache camel Listen/notify ->PGEvent Component (http://camel.apache.org/pgevent.html) -> Mail Component (http://camel.apache.org/mail.html) You can also then handle all the exceptions of the email server easily. On Sun, Apr 19, 2015 at 6:42 AM, Jim Nasby wrote: > On 4/18/15 12:52 AM, Dav

[GENERAL] Why does this SQL work?

Hi, I have the following setup : manualscan=> set search_path=ver736,public; SET manualscan=> \d courier; Table "ver736.courier" Column | Type |Modifiers ---++---

Re: [GENERAL] Why does this SQL work?

Thank you very much - looks like I will have to prefix all cols. Regards AK On Tue, May 12, 2015 at 3:05 AM, Victor Yegorov wrote: > 2015-05-11 19:26 GMT+03:00 Anil Menon : > >> manualscan=> select count(*) From public.msgtxt where msgid in (select >> msgid From ver736.c

[GENERAL] Referencing serial col's sequence for insert

Hi, I have a question on the right/correct practice on using the serial col's sequence for insert. Best way of explanation is by an example: create table id01 (col1 serial, col2 varchar(10)); insert into id01(col2) values ( 'data'||currval('id01_col1_seq')::varchar); while I do get what I want

Re: [GENERAL] Referencing serial col's sequence for insert

Am a bit confused -which one comes first? 1) the 'data'||currval('id01_col1_seq') is parsed first : which means it takes the current session's currval 2) then the insert is attempted which causes a sequence.nextval to be performed which means that 'data'||currval('id01_col1_seq')will be different

Re: [GENERAL] Referencing serial col's sequence for insert

the inputs. Regards ​,​ A ​nil​ On 24 Jul 2014 02:03, "Francisco Olarte" wrote: > Hi Anil: > > On Tue, Jul 22, 2014 at 6:46 PM, Anil Menon wrote: > > Am a bit confused -which one comes first? > > 1) the 'data'||currval('id01_col1_seq') is parsed firs

[GENERAL] Basic question regarding insert

ultset in saved into the AUD table and this could be a few 100 to 1000s of records. Multiple instances of the MQ interceptor can be run - this would be like a new session to the database Thanks in advance Anil

Re: [GENERAL] Basic question regarding insert

Thank you John. That perfectly answered by question. Regards Anil On Sat, Nov 1, 2014 at 2:43 AM, John R Pierce wrote: > On 10/31/2014 3:24 AM, Anil Menon wrote: > > I have a very basic question on inserts - I tried to get a good > authoritative answer but could not really fi

[GENERAL] Performance question

sing exists if exists ( select 1 from table where <> ) then do x else do y end if My question is what would be the best (in terms of performance) method to use? My gut feeling is to use option 4 for PG. Am I right or is there any other method? Thanks in advance Anil

Re: [GENERAL] Performance question

Thanks Adrian On Thu, Nov 20, 2014 at 3:46 AM, Adrian Klaver wrote: > On 11/19/2014 08:26 AM, Anil Menon wrote: > >> Hello, >> >> I would like to ask from your experience which would be the best >> "generic" method for checking if row sets of a certain c

Re: [GENERAL] Performance question

is no impact on business Yours Anil On Fri, Nov 21, 2014 at 5:16 PM, Albe Laurenz wrote: > Anil Menon wrote: > > I would like to ask from your experience which would be the best > "generic" method for checking if row > > sets of a certain condition exists in a PLPG

[GENERAL] Mirror- unix.wizard.ca

Hi! The links that does not work on Canadian Mirror. Anil http://unix.wizard.ca/postgres/software/ gets directory Listing http://unix.wizard.ca/postgres/software/Overview.shtml - search All categories returns if you do not enter anything on the text boxes