FAQ

PostgreSQL > pgsql-sql > July 2009

Search Discussions

39 discussions - 176 posts

  • Postgres kills a transaction when an error happens. This is a pain; it assumes that all SQL errors are unexpected and fatal to the transaction. There's a very simple case where it's not: UNIQUE ...
    Glenn MaynardGlenn Maynard
    Jul 23, 2009 at 5:06 am
    Jul 27, 2009 at 12:40 pm
  • One of our programmers has come to me with a problem. On 3 new Centos 5.3 servers running Postgres 8.2.13 query's are taking 3500ms-5000ms to complete, where the same query on an older server (same ...
    JacobJacob
    Jul 7, 2009 at 11:06 pm
    Jul 9, 2009 at 6:44 pm
  • I have a problem where I want to tweak a simple select in an "unobtrusive way". Imagine I have the following select statement: "SELECT name FROM customer LIMIT 1" and I get a normal result set from ...
    AxeAxe
    Jul 28, 2009 at 9:18 pm
    Aug 3, 2009 at 11:19 am
  • Hi, The source select counts log-events per user. All is well when a user has at least one event per log_type in the log within a given timespan. If one log_type is missing COUNT() has nothing to ...
    AndreasAndreas
    Jul 23, 2009 at 5:01 am
    Jul 25, 2009 at 8:46 pm
  • I have the following senario. I have a tracking system. The system will record the status of an object regularly, all the status records are stored in one table. And it will keep a history of maximum ...
    WkipjohnWkipjohn
    Jul 30, 2009 at 2:49 am
    Jul 31, 2009 at 3:50 pm
  • Good morning, I have a currency table (code, description). Example values: ADF | Andorran Franc ... ... ANG | NL Antillian Guilder AON | Angolan New Kwanza AUD | Australian Dollar AWG | Aruban Florin ...
    Emi LuEmi Lu
    Jul 30, 2009 at 7:51 pm
    Jul 31, 2009 at 2:10 pm
  • Hi, I'm playing with the new "WITH RECURSIVE" feature of 8.4. I'm trying to figure out how to use it with trees. Here is the test code I use: --------------------------------------------------------- ...
    Philippe LangPhilippe Lang
    Jul 10, 2009 at 9:46 am
    Jul 10, 2009 at 1:20 pm
  • Dear anyone, I have the following query: select v.id, array_to_string(array_accum(s.name),', ') as sector , array_to_string(array_accum(p.name),', ') as provincie from tblvacature v, tblaccount a , ...
    David WeilersDavid Weilers
    Jul 22, 2009 at 4:22 pm
    Jul 23, 2009 at 8:05 am
  • within a trigger need to know if the UPDATE statement set a column. the column might be set to the old value or a different value. (want to make sure the app is sending all necessary values) thanks
    Chester c youngChester c young
    Jul 20, 2009 at 1:19 pm
    Jul 23, 2009 at 1:43 am
  • Is there a difference in the order of execution between an ascii dump and one using the "custom" format? Or any difference in the general operation? I need to know if I can rely on the ascii version ...
    Rob SargentRob Sargent
    Jul 21, 2009 at 4:27 pm
    Jul 21, 2009 at 5:29 pm
  • Good morning, I googled to find that "on commit drop" does not support: (a) create temp table as select * from table1 where 1< 2; http://archives.postgresql.org/pgsql-sql/2005-09/msg00153.php If ...
    Emi LuEmi Lu
    Jul 14, 2009 at 4:30 pm
    Jul 14, 2009 at 6:52 pm
  • hi folks i have the following: select o_ord_date as o_date, count(o_id) as orders from orders where o_de_id in (5,6) and o_ord_date CURRENT_DATE-'1 month'::interval group by o_ord_date order by ...
    Gary StainburnGary Stainburn
    Jul 13, 2009 at 11:15 am
    Jul 13, 2009 at 2:02 pm
  • I know, I know, PostgreSQL has Booleans that work very nicely. Unfortunately, I have to create a schema that will work on Oracle as well as PostgreSQL, by which I mean that a single set of Java/JDBC ...
    Peter HeadlandPeter Headland
    Jul 7, 2009 at 1:23 am
    Jul 7, 2009 at 9:27 am
  • Hi! Where are stored the sequence information? How I can query the properties of a sequence like increment, max/min value, cache? I'm looking for a table like user_sequences in Oracle, where I can ...
    Andre RotheAndre Rothe
    Jul 3, 2009 at 1:12 pm
    Jul 4, 2009 at 9:12 pm
  • hi, i have to create a aggregate function which evaluates a maximum text value but with some conditions i have to take care of. is there a way to access a value set of each group? e.g.: customer ; ...
    Jasmin DizdarevicJasmin Dizdarevic
    Jul 2, 2009 at 2:48 pm
    Jul 3, 2009 at 7:14 am
  • hello list, i have some problems with an sql-statement which runs on oracle but not on postgresql (i want update only if result of SELECT is not empty, the SELECT-queries are identical): UPDATE ...
    Gau, Hans-JürgenGau, Hans-Jürgen
    Jul 28, 2009 at 10:28 am
    Jul 29, 2009 at 1:44 pm
  • The Subject: is somewhat imprecise, but here's what I'm trying to do. For some reason, my brain is locking up over it. I'm moving a 7.2 (yes) database to 8.4. In the table in question, the structure ...
    ChristopheChristophe
    Jul 17, 2009 at 3:14 am
    Jul 17, 2009 at 3:33 pm
  • hi, can i use savepoints to realize something like "on error resume next"? i've got the following situation: begin; 1. create view user001.accounts as select * from base.accounts; 2. grant select on ...
    Jasmin DizdarevicJasmin Dizdarevic
    Jul 31, 2009 at 3:24 pm
    Jul 31, 2009 at 6:52 pm
  • Sorry, it's a lapse by copying and simplification the original version. that is correct: UPDATE table1 t1 SET (t1.id) = (SELECT t3.id FROM table2 t2,table3 t3, table1 t1 WHERE t3.field = t2.field AND ...
    Gau, Hans-JürgenGau, Hans-Jürgen
    Jul 29, 2009 at 9:48 am
    Jul 29, 2009 at 11:05 am
  • Hi, I made up a query to make a count for each item for each month/year: SELECT"Artnr_ID", to_char("Date_plan","YYYY") AS "Jaar", to_char("Date_plan","MM") AS "Maand", Count("tblArtnrs"."Artikelnr") ...
    BartjoosenBartjoosen
    Jul 23, 2009 at 9:59 am
    Jul 24, 2009 at 11:14 pm
  • is there a way for COPY FROM to ignore unused columns in CSV? in other words, if table t1 has columns c1, c2, and if csv has columns c1, c3, c2, could I do something like COPY t1( c1, null, c2 ) FROM ...
    Chester c youngChester c young
    Jul 20, 2009 at 1:23 pm
    Jul 21, 2009 at 12:31 am
  • Hi all, how can I define a column of timestamp with timezone type...with a default value? Thanks
    Gianvito PioGianvito Pio
    Jul 18, 2009 at 8:20 am
    Jul 19, 2009 at 1:00 pm
  • I am new to Postgresql and am trying to write a function which will do a search and return the first page of results along with the total number of matches. How can I make my function return a cursor ...
    Surajit BhattacharjeeSurajit Bhattacharjee
    Jul 13, 2009 at 3:33 am
    Jul 14, 2009 at 4:18 pm
  • Hi list, I was wondering if it was possible for a field in SQL query to return NULL if latter value is exactly the same ? - for given ORDER BY clause, I guess. For example, query returns: xxyy 1 4 ...
    Marcin KrawczykMarcin Krawczyk
    Jul 10, 2009 at 7:23 am
    Jul 10, 2009 at 7:46 am
  • Hi all. Take this example from src/test/regress/sql/with.sql: WITH RECURSIVE subdepartment(level, id, parent_department, name) AS ( -- non recursive term SELECT 1, * FROM department WHERE name = 'A' ...
    Andreas Joseph KroghAndreas Joseph Krogh
    Jul 7, 2009 at 1:44 am
    Jul 7, 2009 at 2:06 am
  • Hi I am running the following query again a partitioned table in 8.2.7. It does index scans which is unexpected as there are indexes for the log_date column. min(log_date) from data.table "Aggregate ...
    Tim HaakTim Haak
    Jul 1, 2009 at 5:16 pm
    Jul 2, 2009 at 9:31 am
  • Hi, how can I fetch multiple rows into one text-field? I need the contents of some log-infos condensed into a single text to show in a report. There is a log with a single record per event. The log ...
    AndreasAndreas
    Jul 31, 2009 at 8:03 pm
    Jul 31, 2009 at 11:30 pm
  • hi, I have table CREATE TABLE table ( id integer NOT NULL, timest timestamp with time zone NOT NULL, db_time timestamp with time zone NOT NULL DEFAULT now(), "values" text[], CONSTRAINT table_pkey ...
    Heigo NiilopHeigo Niilop
    Jul 30, 2009 at 9:38 am
    Jul 31, 2009 at 12:48 am
  • Hello, I'm having a problem using foreign keys, or at least in a way i find good. Basicly I have a table I wish to use as a foreign key with lookup "id" and "code", like: 1,a 1,b 1,c 2,a 2,d I have ...
    Kjell Rune SkaaraasKjell Rune Skaaraas
    Jul 29, 2009 at 8:23 pm
    Jul 30, 2009 at 3:35 pm
  • Hi, I've a big/complex database (Adempiere - www.adempiere.org ) where I'd like to delete some rows from some tables (delete a client and its data from the ERP database). All tables are in one schema ...
    Akos GabrielAkos Gabriel
    Jul 28, 2009 at 6:28 pm
    Jul 28, 2009 at 8:09 pm
  • I am parsing a map file and storing the hi, mid and low byte values of symbol addresses in a comma separated value (.csv) file. I am then importing this data into a PostgreSQL database with the copy ...
    JJJJ
    Jul 20, 2009 at 8:16 pm
    Jul 21, 2009 at 11:33 am
  • Hello, I have 3 tables: persons, operators and persons_position. This is a semplified examples of their structures: CREATE TABLE persons (id varchar NOT NULL, CONSTRAINT "PK_Persons" PRIMARY ...
    Gianvito PioGianvito Pio
    Jul 18, 2009 at 5:09 pm
    Jul 20, 2009 at 1:33 pm
  • Hi, how would I update a table within a join in a more efficient way? E.g. the folowing case: table_a holds abstract elements. One column represents "priority" which can be based on information of ...
    AndreasAndreas
    Jul 10, 2009 at 8:14 am
    Jul 10, 2009 at 8:22 am
  • I have to restructure some tables, coalescing common elements from three tables (sub-classes) into a single table (super-class). Each source table has a text field which actually gets stuffed with a ...
    Rob SargentRob Sargent
    Jul 8, 2009 at 9:19 pm
    Jul 9, 2009 at 8:09 am
  • I've seen this asked in the archives, but there was never any answer. Supposed I have this table: create temp table tempa (ids int[]); insert into tempa SELECT ARRAY[1 , 2, 3]; Now how do I get ...
    Joseph SJoseph S
    Jul 9, 2009 at 1:43 am
    Jul 9, 2009 at 1:59 am
  • hi, I have table CREATE TABLE table ( id integer NOT NULL, timest timestamp with time zone NOT NULL, db_time timestamp with time zone NOT NULL DEFAULT now(), "values" text[], CONSTRAINT table_pkey ...
    Heigo NiilopHeigo Niilop
    Jul 30, 2009 at 9:27 am
    Jul 30, 2009 at 9:27 am
  • it runs without alias t1. before fieldname id after SET, so: UPDATE table1 t1 SET id = (SELECT t3.id FROM table2 t2,table3 t3, table1 t1 WHERE t3.field = t2.field AND t2.id = t1.id AND t1.id < t3.id) ...
    Gau, Hans-JürgenGau, Hans-Jürgen
    Jul 29, 2009 at 4:09 pm
    Jul 29, 2009 at 4:09 pm
  • Hi, I'm trying to check whether a given string is part of an XPath result set. I have encountered some performance prob- lems in the process, but before I track those down further, I'd like to see if ...
    Tim LandscheidtTim Landscheidt
    Jul 16, 2009 at 11:40 pm
    Jul 16, 2009 at 11:40 pm
  • Hi, I have been developing in postgresql for a very short time. I am currently having problems that I believe can be resolved with the right query structure but as of yet have not been able to figure ...
    Tamayo, Damian-p65828Tamayo, Damian-p65828
    Jul 1, 2009 at 4:51 pm
    Jul 1, 2009 at 4:51 pm
Jul 2009
Group Navigation
period‹ prev | Jul 2009 | next ›
Group Overview
grouppgsql-sql @
categoriespostgresql
discussions39
posts176
users65
websitepostgresql.org
irc#postgresql

65 users for July 2009

Nha: 16 posts Tom Lane: 14 posts Rob Sargent: 9 posts Jasmin Dizdarevic: 7 posts Tena Sakai: 7 posts Jacob: 6 posts Glenn Maynard: 5 posts Richard Huxton: 5 posts Andreas: 4 posts Emi Lu: 4 posts Philippe Lang: 4 posts Scott Marlowe: 4 posts Wkipjohn: 3 posts Axe: 3 posts Chester c young: 3 posts Craig Ringer: 3 posts Daryl Richter: 3 posts Gau, Hans-Jürgen: 3 posts Greg Stark: 3 posts Joshua Tolley: 3 posts
show more
Archives