Search Discussions
-
Perhaps this is just what you are looking for, right? Recover Data from Android Phone <http://www.ipubsoft.com/recovery/recover-deleted-data-from-android-phone.html ...
Walerina
Aug 30, 2013 at 8:55 am
Aug 30, 2013 at 8:55 am -
Does anyone know if there are any CTAGS extensions or variants that support PL/pgSQL ? I use exuberant-ctags which does not support it, and a web search does not return anything promising. (I sent ...
Charles Sheridan
Aug 28, 2013 at 3:08 pm
Aug 29, 2013 at 2:17 pm -
Hello. I want to run an automatic archiving SQL script, that looks at a meta-table containing data about the tables to be archived. Basically, suppose I have this data in the meta-table: table_name ...
Herouth Maoz
Aug 28, 2013 at 10:07 am
Aug 28, 2013 at 10:45 am -
Hello When I run : SELECT array_to_string(array_agg(CONCAT(CAST (ltrv1.val_min AS CHAR), '-', CAST(ltrv1.val_max AS CHAR), ' ', ltrv1.comentarii))) FROM lab_tests_reference_values ltrv1 GROUP BY ...
Victor Sterpu
Aug 25, 2013 at 12:15 pm
Aug 25, 2013 at 1:19 pm -
I have a table containing tasks completed in a game I'm playing. The game includes an extra BINGO Challenge where each cell of standard BINGO card contains a particular task to be completed. The goal ...
F Bax
Aug 3, 2013 at 1:26 pm
Aug 5, 2013 at 4:01 am -
I have a table with fields as follows: * sag_id * sag_header * sag_comments * sag_date * sag_section_id (**) * sag_artist_id (**) * sag_author_id (**) * sag_producer_id (**) As you can see, fields ...
JORGE MALDONADO
Jul 26, 2013 at 11:10 pm
Jul 27, 2013 at 12:31 am -
I guess I am understanding that it is possible to set a unique index or a unique constraint in a table, but I cannot fully understand the difference, even though I have Google some articles about ...
JORGE MALDONADO
Jul 26, 2013 at 9:44 pm
Jul 27, 2013 at 7:13 am -
Hi folks, I need help please. I have a table of trip section details which includes a trip ID, start time as an offset, and a duration for that section. I need to extract the full trip duration by ...
Gary Stainburn
Jul 25, 2013 at 5:45 pm
Jul 26, 2013 at 8:18 am -
I have 2 tables, a parent (tbl_persons) and a child (tbl_languages_per_person) as follows (a language table is also involved): ------------------ tbl_persons ------------------ * per_id * per_name * ...
JORGE MALDONADO
Jul 23, 2013 at 9:44 pm
Jul 24, 2013 at 10:12 am -
Postgres 9.2.4. I have two columns, approved and comments. Approved is a boolean with no default value and comments is a character varying (255) and nullable. I am trying to create a constraint that ...
Ldrlj1
Jul 22, 2013 at 2:05 pm
Jul 22, 2013 at 2:53 pm -
Hi I would like to list the definition of all user tables by only one command. Is there a way to *not* show pg_catalog tables when using "\d ." in PostgreSQL 9.1.9? Thanks.
Carla Goncalves
Jul 17, 2013 at 3:29 pm
Jul 24, 2013 at 10:00 am -
Dear list, This might be a postgis-specific question, but I could not get access to the postgis mailing list so I will have a try here as my problem might be related to SQL: I need to update a column ...
Stefan Sylla
Jul 16, 2013 at 2:53 am
Jul 17, 2013 at 9:58 am -
Hi Guys We are migrating to Postgres. In the current system, we use datediff() function to get the difference between two dates, e.g. datediff (month, cast('2013-01-01' as timestamp), ...
Huan Ruan
Jul 11, 2013 at 5:17 am
Jul 11, 2013 at 6:19 am -
If I have two tables, T1 and T2, such that both have the same primary key of "user_id". What is the SQL I would use to delete all rows from T1 that are not in T2? This is one way to write the SQL but ...
Campbell, Lance
Jul 9, 2013 at 7:25 pm
Jul 14, 2013 at 7:25 am -
I'm writing a system with havy use of composite types. I have a doubt. I'm writing all in functions with language plpgsql. When I read a field from a composite type I must write something like this ...
Luca Vernini
Jul 8, 2013 at 1:11 pm
Jul 8, 2013 at 11:25 pm -
Hi, I need to show a moving statistic of states of objects for every month since beginning of 2013. There are tables like objects ( id integer, name text ); state ( id integer, state text ); 10=A, ...
Andreas
Jul 8, 2013 at 12:17 pm
Jul 24, 2013 at 11:27 am -
Hello, All unquoted identifiers are assumed by PostgreSQL to be lower case by default. This means - SELECT MY_COLUMN FROM my_table - SELECT my_column FROM my_table - SELECT my_column as MY_COLUMN ...
Dev Kumkar
Jul 3, 2013 at 9:12 am
Jul 3, 2013 at 11:29 pm -
Hi all I just want to confirm something regarding UNNEST function used with arrays. I cannot see that it is specifically mentioned in the documentation , but maybe because it is obvious. Is the order ...
Gmb
Jun 20, 2013 at 10:41 am
Jun 20, 2013 at 1:34 pm -
Working on Ubuntu 13.04 64bit (raring) I red, that Pitti-PPA will be discontinued in the future, so we should make the switch to apt.postgresql.org. But trying to "aptitude install postgresql-9.3" ...
Rawi
Jun 18, 2013 at 10:12 am
Jun 18, 2013 at 11:31 am -
Is it valid to specify a SELECT statement as part of a JOIN clause? For example: SELECT table1.f1, table1.f2 FROM table1 INNER JOIN (SELECT table2.f1, table2.f2 FROM table2) table_aux ON table1.f1 = ...
JORGE MALDONADO
Jun 13, 2013 at 10:40 pm
Jun 14, 2013 at 7:16 am -
Hi I tested the following: CREATE TABLE t1 ( id serial NOT NULL, a character varying(125), a_tsvector tsvector, CONSTRAINT t1_pkey PRIMARY KEY (id) ); INSERT INTO t1 (a, a_tsvector) VALUES ...
Rawi
Jun 13, 2013 at 11:39 am
Jun 21, 2013 at 9:31 am -
I need to insert records into a table where one value is fixed and 2 values come from a SELECT query, something like the following example: INSERT INTO table1 fld1, fld2, fl3 VALUES value1, (SELECT ...
JORGE MALDONADO
Jun 7, 2013 at 1:59 pm
Jun 7, 2013 at 2:25 pm -
I have an update query that I'm not sure if I am taking a good approach or a naive one. It works but seems ugly. I have a table named "contacts". Contacts have a user_id and an owner_id. There is ...
Robert DiFalco
Jun 2, 2013 at 8:39 pm
Jun 2, 2013 at 8:39 pm -
Sorry, I wasn't sure what list I should be sending this question to... I have a multi-tenant-like application. We have a fields tree that we call a template, with something like this: fields(id, ...
Rodrigo Rosenfeld Rosas
May 29, 2013 at 1:58 pm
May 29, 2013 at 4:14 pm -
I have a query like this: SELECT lpt_titulo AS tmt_titulo, tmd_nombre AS tmt_nombre, tmd_album AS tmt_album SUM(lpt_puntos) AS tmt_puntos, lpt_fuente AS tmt_fuente FROM listas_pre_titulos, ...
JORGE MALDONADO
May 25, 2013 at 5:17 pm
May 25, 2013 at 5:52 pm -
Dear all, I am trying to translate a code written in php to C++. So, I am now using lipq in order to access my postgresql database from C++. As performance is an important feature, I am using ...
Brice André
May 25, 2013 at 11:07 am
May 27, 2013 at 7:06 am -
Here is a boiled down example of a scenario which I am having a bit of difficulty solving. This is a catchall table where all the rows are related to the "id" but are entered by different unrelated ...
Bill MacArthur
May 25, 2013 at 7:19 am
May 29, 2013 at 3:07 pm -
I have one SELECT statement as follows: SELECT lpt_titulo as tmt_titulo, tmd_nombre as tmt_nombre, tmd_album as tmt_album, SUM(lpt_puntos) AS tmt_puntos FROM listas_pre_titulos INNER JOIN ...
JORGE MALDONADO
May 23, 2013 at 6:11 pm
May 24, 2013 at 6:15 pm -
I am running postgresql 9.2. I am assuming it would be a function of psql to right justify text, but I can't find any way to do this. Is there a way to right justify just one text column? Thanks Brian
Brian Sherwood
May 17, 2013 at 3:27 pm
May 18, 2013 at 5:28 am -
To summarize my question at the top, why is it that when I did the JOIN, the array_agg results reversed order? I had a function that ran the following query: SELECT timeslot, pollgrpid, ...
George Woodring
May 14, 2013 at 2:09 pm
May 14, 2013 at 7:38 pm -
Hi list, I have some problems with SERIALIZABLE isolation level, namely my users are plagued with concurrency errors. As of postgres 9.1 (which I'm running) there has been a change to SERIALIZABLE ...
Marcin Krawczyk
May 13, 2013 at 9:22 am
May 13, 2013 at 10:26 pm -
I have an UPDATE query which performs several opertions in one table. UPDATE table01 SET field1 = (query1 may contain any field), field2 = (query1 may contain any field), field3 = (query1 may contain ...
JORGE MALDONADO
May 6, 2013 at 12:04 am
May 6, 2013 at 9:32 am -
It hit me today that a 1:n relationship can't be implemented just by a single foreign key constraint if n 0. I must have been sleeping very deeply not to notice this. E.g. if there is a table "list" ...
Wolfgang Keller
Apr 30, 2013 at 2:39 pm
May 14, 2013 at 6:33 pm -
3
execute
Hi every one, I'm trying to do the follow: declare aCad text[][] begin ... execute 'aCad:=aCad array[['||var1||','||var2||']]' ... end; language plpgsql but I get the follow error: sintax erro near ...Mauricio Cruz
Apr 25, 2013 at 4:17 pm
Apr 27, 2013 at 7:01 am -
Hi, When i tried to delink the old tables i'm getting the following error NOTICE: SELECT COUNT(*) AS count from pg_tables where schemaname='fr' and tablename='check_deny_2013_04_17' CONTEXT: PL/pgSQL ...
Shabeer ece
Apr 23, 2013 at 8:01 am
Apr 23, 2013 at 8:01 am -
Hi, I am on postgresql 9.1 and use at table like CREATE TABLE timetable( tid INTEGER PRIMARY KEY, gid INTEGER REFERENCES groups(gid), day DATE, s TIME NOT NULL, --- start e TIME NOT NULL, --- end ...
Wolfgang Meiners
Apr 22, 2013 at 10:19 am
Apr 22, 2013 at 6:06 pm -
Let´s suppose that I have a SELECT statement that joins more than one table and such a statement is order by fields that belong not only to the table in the FROM but also by fields in the tables that ...
JORGE MALDONADO
Apr 20, 2013 at 4:32 pm
Apr 20, 2013 at 4:59 pm -
I have a temporary table with columns zone_name, nodeid, nodelabel, nodegainedservice, nodelostservice Zone1, 3, Windows-SRV1, "2012-11-27 13:10:30+08", "2012-11-27 13:00:40+08" Zone1, 5, ...
Chinnaobi
Apr 19, 2013 at 3:41 am
Apr 19, 2013 at 3:41 am -
Hi, I am using Postgres DB with stand by database, configured with streaming in synchronized mode (each commit on primary DB waits for commit on secondary DB). Sometimes we suffer from network issues ...
Sofer, Yuval
Apr 18, 2013 at 3:41 pm
Apr 18, 2013 at 4:38 pm -
Hi, I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpassword it changes ok but then I can't login with my newpassword... It says authetication failed. My pg_hba.conf has ...
Marcin Krawczyk
Apr 18, 2013 at 11:00 am
Apr 19, 2013 at 8:13 am -
Hello, i have try the following: -- Function: wetter.copy_ignore_duplicate(character varying) -- DROP FUNCTION wetter.copy_ignore_duplicate(character varying); CREATE OR REPLACE FUNCTION ...
Basti
Apr 18, 2013 at 7:26 am
Apr 18, 2013 at 1:48 pm -
Hello, I'm trying to put together a fully contained runtime environment and am having trouble with fully qualified path names to dynamic library being included in _psycopg2.so (I'm on a Mac). See ...
Thomas Burnett
Apr 16, 2013 at 6:42 pm
Apr 16, 2013 at 6:42 pm -
Hello, I'm working on designing a soft-delete scheme for our key entity-- there are 17 other tables that reference our key table via RI. Let's call the table "foo". I understand there are a couple ...
Mark Stosberg
Apr 16, 2013 at 4:24 pm
Apr 18, 2013 at 12:01 pm -
The following is my code and results: select '1' "num_ads", (case when r.region_code = 1000 then ( select count(*) from ( select userid from user_event_stg2 where userid in ( select userid from ...
Tony Capobianco
Apr 12, 2013 at 9:14 pm
Apr 13, 2013 at 10:05 pm -
Hi, The following when run in PostgreSQL 9.2.x seems to tell that if I have two tables A and B, such that if B inherits A, then, even if I don't have any rights on A, I can get an ACCESS EXCLUSIVE ...
Robins Tharakan
Apr 12, 2013 at 8:59 pm
Apr 12, 2013 at 9:09 pm -
UPDATE tbl SET city=s.city_name FROM shp AS s WHERE ST_CONTAINS(s.city_geom,geom); With the code above i can add exact city to a GPS point. It runs about 45-50 min on 50 million rows. There are about ...
Androclos
Apr 11, 2013 at 4:38 pm
Apr 11, 2013 at 4:38 pm -
Hello, is there any best practice method how to create a foreign key that only allows values from those rows in the referenced table that fulfill an additional condition? First I present two pseudo ...
Matthias Nagel
Apr 11, 2013 at 7:55 am
Apr 12, 2013 at 7:52 pm -
I have a table of artists with fields like the ones below: * Name * Birthday * Sex (male/female) Our application offers a catalog of artists where a user can select a range of birthdays and/or sex ...
JORGE MALDONADO
Apr 10, 2013 at 10:30 pm
Apr 12, 2013 at 1:31 pm -
Hi all, Can someone please point me to detailed documentation on how to secure/encrypt connections between PGBouncer and Postgresql database (version 8.4.3)? Thanks in advance! Bhanu M. Gandikota ...
Bhanu Murthy
Apr 10, 2013 at 6:06 pm
Apr 10, 2013 at 6:17 pm
Group Overview
group | pgsql-sql |
categories | postgresql |
discussions | 11,964 |
posts | 44,015 |
users | 6,062 |
website | postgresql.org |
irc | #postgresql |
Top users
Archives
- August 2013 (17)
- July 2013 (71)
- June 2013 (27)
- May 2013 (36)
- April 2013 (57)
- March 2013 (42)
- February 2013 (97)
- January 2013 (68)
- December 2012 (34)
- November 2012 (46)
- October 2012 (58)
- September 2012 (67)
- August 2012 (29)
- July 2012 (34)
- June 2012 (80)
- May 2012 (109)
- April 2012 (71)
- March 2012 (80)
- February 2012 (105)
- January 2012 (121)
- December 2011 (111)
- November 2011 (86)
- October 2011 (88)
- September 2011 (84)
- August 2011 (131)
- July 2011 (102)
- June 2011 (102)
- May 2011 (182)
- April 2011 (37)
- March 2011 (45)
- February 2011 (126)
- January 2011 (129)
- December 2010 (111)
- November 2010 (98)
- October 2010 (87)
- September 2010 (119)
- August 2010 (91)
- July 2010 (128)
- June 2010 (117)
- May 2010 (146)
- April 2010 (123)
- March 2010 (220)
- February 2010 (116)
- January 2010 (55)
- December 2009 (101)
- November 2009 (84)
- October 2009 (151)
- September 2009 (136)
- August 2009 (151)
- July 2009 (176)
- June 2009 (132)
- May 2009 (115)
- April 2009 (144)
- March 2009 (103)
- February 2009 (108)
- January 2009 (53)
- December 2008 (133)
- November 2008 (165)
- October 2008 (145)
- September 2008 (187)
- August 2008 (136)
- July 2008 (256)
- June 2008 (162)
- May 2008 (133)
- April 2008 (226)
- March 2008 (211)
- February 2008 (237)
- January 2008 (239)
- December 2007 (161)
- November 2007 (162)
- October 2007 (156)
- September 2007 (160)
- August 2007 (274)
- July 2007 (203)
- June 2007 (245)
- May 2007 (213)
- April 2007 (278)
- March 2007 (365)
- February 2007 (296)
- January 2007 (187)
- December 2006 (195)
- November 2006 (297)
- October 2006 (270)
- September 2006 (178)
- August 2006 (254)
- July 2006 (381)
- June 2006 (337)
- May 2006 (210)
- April 2006 (220)
- March 2006 (467)
- February 2006 (332)
- January 2006 (221)
- December 2005 (247)
- November 2005 (288)
- October 2005 (400)
- September 2005 (303)
- August 2005 (324)
- July 2005 (250)
- June 2005 (379)
- May 2005 (283)
- April 2005 (419)
- March 2005 (415)
- February 2005 (364)
- January 2005 (331)
- December 2004 (168)
- November 2004 (301)
- October 2004 (214)
- September 2004 (260)
- August 2004 (349)
- July 2004 (240)
- June 2004 (313)
- May 2004 (222)
- April 2004 (343)
- March 2004 (285)
- February 2004 (389)
- January 2004 (305)
- December 2003 (230)
- November 2003 (347)
- October 2003 (417)
- September 2003 (423)
- August 2003 (363)
- July 2003 (498)
- June 2003 (354)
- May 2003 (594)
- April 2003 (463)
- March 2003 (650)
- February 2003 (638)
- January 2003 (532)
- December 2002 (283)
- November 2002 (446)
- October 2002 (424)
- September 2002 (444)
- August 2002 (426)
- July 2002 (473)
- June 2002 (413)
- May 2002 (331)
- April 2002 (367)
- March 2002 (390)
- February 2002 (448)
- January 2002 (358)
- December 2001 (267)
- November 2001 (450)
- October 2001 (426)
- September 2001 (301)
- August 2001 (395)
- July 2001 (439)
- June 2001 (574)
- May 2001 (402)
- April 2001 (461)
- March 2001 (700)
- February 2001 (470)
- January 2001 (501)
- December 2000 (336)
- November 2000 (296)
- October 2000 (300)
- September 2000 (242)
- August 2000 (363)
- July 2000 (285)
- June 2000 (289)
- May 2000 (230)
- April 2000 (267)
- March 2000 (103)
- February 2000 (253)
- January 2000 (282)
- December 1999 (272)
- November 1999 (236)
- October 1999 (219)
- September 1999 (246)
- August 1999 (292)
- July 1999 (310)
- June 1999 (312)
- May 1999 (258)
- April 1999 (207)
- March 1999 (257)
- February 1999 (231)
- January 1999 (179)
- December 1998 (113)
- November 1998 (111)
- October 1998 (114)
- September 1998 (151)
- August 1998 (156)
- July 1998 (137)
- June 1998 (160)
- May 1998 (108)