Re: [GENERAL] Disconnected but query still running

2015-07-13 Thread Venkata Balaji N
On Sat, Jul 11, 2015 at 8:53 AM, Eduardo Piombino wrote: > > I've read that that a query still running after a disconnection is > normal, since the server won't realize about this disconnection until > it needs to send some data back to the client, which is ok and > understandable. But my questio

Re: [GENERAL] [ADMIN] could not create shared memory segment: Invalid argument

2015-07-13 Thread Scott Whitney
What is your kernel SHMMAX? Usually somewhere under /etc/sysconfig. Depends on your distro. This is telling you that your kernel does not have sufficient resources. Original message From: Ryan King - NOAA Affiliate Date: 07/13/2015 7:10 PM (GMT-06:00) To: pgsql-general@postgre

Re: [GENERAL] could not create shared memory segment: Invalid argument

2015-07-13 Thread Ryan King - NOAA Affiliate
Apologies ahead of time for not knowing which group to send to, but I wanted to see if anyone has encountered and resolved this type of error. I'm setting up postgresql 9.2 streaming replication on RH and after copying the master data directory over to the slave, the psql service refuses start and

Re: [GENERAL] Obtaining advisory lock using ORDER BY

2015-07-13 Thread Andreas Joseph Krogh
På mandag 13. juli 2015 kl. 16:22:28, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Andreas Joseph Krogh writes: > I have this "dequeue" query which is working: > > select qe.entity_id, qe.queue_id, qe.sequence_id, qe.tx_id , qe.payload_string > fromorigo_queue_entry qe WHERE qe.queue_id = 2 AN

Re: [GENERAL] Obtaining advisory lock using ORDER BY

2015-07-13 Thread Tom Lane
Andreas Joseph Krogh writes: > I have this "dequeue" query which is working: >   > select qe.entity_id, qe.queue_id, qe.sequence_id, qe.tx_id , > qe.payload_string > fromorigo_queue_entry qe WHERE qe.queue_id = 2 AND pg_try_advisory_xact_lock( > sequence_id) LIMIT 1 FOR UPDATE ; > I'm not sure

[GENERAL] Obtaining advisory lock using ORDER BY

2015-07-13 Thread Andreas Joseph Krogh
Hi all.   I have this "dequeue" query which is working:   select qe.entity_id, qe.queue_id, qe.sequence_id, qe.tx_id , qe.payload_string fromorigo_queue_entry qe WHERE qe.queue_id = 2 AND pg_try_advisory_xact_lock( sequence_id) LIMIT 1 FOR UPDATE ; I'm not sure is this is guaranteed to lock in AS

Re: [GENERAL] timestamp check

2015-07-13 Thread Raymond O'Donnell
On 11/07/2015 17:11, Ramesh T wrote: > okay,i'm executing a query from pgadmin3. > > i want display time with timezone.But above query displaying date and > time not timezone... > > On Sat, Jul 11, 2015 at 9:34 PM, David G. Johnston > mailto:david.g.johns...@gmail.com>> wrote: > > On Fri, J

Re: [GENERAL] timestamp check

2015-07-13 Thread Adrian Klaver
On 07/11/2015 11:21 PM, Ramesh T wrote: postgres query select current_timestamp- TO_TIMESTAMP(to_char(DATE1, '-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name=DATETIMEZOZE1) , ''-MM-DD HH24'||' '||'MI'||' '||'SS')::timestamptz

Re: [GENERAL] xmltable in postgres like in oracle..?

2015-07-13 Thread Ramesh T
i got function select regexp_split_to_table('2,1', E',')::bigint thanks On Mon, Jul 13, 2015 at 4:13 PM, Ramesh T wrote: > WITH idtable AS ( > SELECT '2342,8766' id > ) > > select * from inv where id in( > SELECT id > FROM idtable) > > But in query need seperate row by row > like 2342 >

Re: [GENERAL] xmltable in postgres like in oracle..?

2015-07-13 Thread Ramesh T
WITH idtable AS ( SELECT '2342,8766' id ) select * from inv where id in( SELECT id FROM idtable) But in query need seperate row by row like 2342 8766 using these idtable id i'm checking in inv table id, if same id then return result from inv table how to seperate row by row from temp tab

Re: [GENERAL] timestamp check

2015-07-13 Thread Ramesh T
any help..? On Sun, Jul 12, 2015 at 11:51 AM, Ramesh T wrote: > postgres query > select current_timestamp- > TO_TIMESTAMP(to_char(DATE1, '-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' > '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names > WHERE name=DATETIMEZOZE1) , ''-MM-DD HH24'||' '

Re: [GENERAL] xmltable in postgres like in oracle..?

2015-07-13 Thread Ramesh T
xml table is the oracle function ..thank you sir On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver wrote: > On 07/11/2015 08:32 AM, Ramesh T wrote: > >> Hi, >>is xmltable available in postgres..?,if not please give me a >> advice to replace the xmtable in postgres..? >> > > What is xmltabl

Re: [GENERAL] timestamp check

2015-07-13 Thread Ramesh T
okay,i'm executing a query from pgadmin3. i want display time with timezone.But above query displaying date and time not timezone... On Sat, Jul 11, 2015 at 9:34 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T > wrote: > >> >> select curre

Re: [GENERAL] timestamp check

2015-07-13 Thread Ramesh T
postgres query select current_timestamp- TO_TIMESTAMP(to_char(DATE1, '-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name=DATETIMEZOZE1) , ''-MM-DD HH24'||' '||'MI'||' '||'SS')::timestamptz getting result.. [image: Inline image 1]