FAQ

PostgreSQL > pgsql-general > July 2010

Search Discussions

193 discussions - 1,038 posts

  • Hi, I am new to the mailing list (as a writer ... reading since a long time), but am using PostgreSQL in our company for quite some time now. Lately, we rolled out some new servers with vastly ...
    Andras FabianAndras Fabian
    Jul 9, 2010 at 11:54 am
    Jul 18, 2010 at 2:39 pm
  • hi, The question is very simple - which CMS/Shopping cart/Ecommerce solution are people using in conjunction with Postgresql ? Except for Drupal's partial support, I cant find any which has a ...
    Sandeep SrinivasaSandeep Srinivasa
    Jul 28, 2010 at 5:57 am
    Aug 2, 2010 at 7:03 am
  • Thanks to some very helpful input here in earlier threads, I was finally able to pull together a working prototype Full Text Search 'engine' on PostgreSQL and compare it directly to the way the ...
    Howard RogersHoward Rogers
    Jul 28, 2010 at 2:05 am
    Aug 12, 2010 at 5:28 am
  • Suppose 1=Red, 2=Yellow, 4=Green and 8=Orange. Now suppose the following data structures and rows exist: create table coloursample (recid integer, colour integer, descript varchar); insert into ...
    Howard RogersHoward Rogers
    Jul 21, 2010 at 4:05 am
    Jul 23, 2010 at 4:52 pm
  • We are implementing Nagios on Space Station and want to use PostgreSQL to store the data on orbit and then replicate that db on the ground. The problem is, most people use MySQL with Nagios. We need ...
    Duncavage, Daniel P. (JSC-OD211)Duncavage, Daniel P. (JSC-OD211)
    Jul 13, 2010 at 4:35 pm
    Jul 19, 2010 at 8:26 pm
  • I can't figure out the correct syntax... I have this, but it just keeps complaining about the IF IF NOT EXISTS (SELECT table_name FROM information_schema.tables where table_name = 'post_codes') THEN ...
    Jennifer TreyJennifer Trey
    Jul 19, 2010 at 4:33 pm
    Jul 21, 2010 at 1:58 am
  • Hello, I was trying to use GIN index, but the results seem be incorrect. 1. QUERY WITHOUT INDEX select count(*) from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', ...
    Artur DabrowskiArtur Dabrowski
    Jul 15, 2010 at 1:10 pm
    Jul 28, 2010 at 6:00 pm
  • I'm building a national database of agricultural information and one of the layers is a bit more than a gigabyte per state. That's 1-2 million records per state, with a mult polygon geometry, and ...
    Bill ThoenBill Thoen
    Jul 28, 2010 at 4:56 pm
    Jul 29, 2010 at 3:59 pm
  • Hi, I went looking at why some of our queries using some custom functions were a bit sluggish. usercandoonobject(integer, integer, character, integer) does this: IF (isSuperuser(p_user_id)) THEN ...
    Josip RodinJosip Rodin
    Jul 9, 2010 at 2:42 pm
    Jul 13, 2010 at 7:56 am
  • Is there a way to find last checkpoint time via SQL command? I know I can grep xlogs by turning on log_checkpoints, but I'd prefer an SQL solution. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, ...
    Devrim GündüzDevrim Gündüz
    Jul 20, 2010 at 7:24 pm
    Aug 11, 2010 at 5:12 pm
  • I've been using MySQL for years. I switched (er, mostly) to PostgreSQL recently because I need to use PostGIS. It is all working now for the most part, and PostGIS is absolutely wonderful. I run ...
    Michael A. PetersMichael A. Peters
    Jul 23, 2010 at 10:52 pm
    Jul 25, 2010 at 3:59 pm
  • Hi, Is it possible to configure postgres from SQL? I am interested in turning off fsync for a set of queries (that take ages to run) and then turn fsync back on again afterwards. Cheers, Tom
    Tom WilcoxTom Wilcox
    Jul 12, 2010 at 1:29 pm
    Jul 12, 2010 at 8:31 pm
  • We need to locate all cities within a certain distance of a single city. We have longitude and latitude data for all cities. I was thinking postGIS was a viable solution, but I don't see a way to use ...
    GeoffreyGeoffrey
    Jul 21, 2010 at 1:01 pm
    Jul 22, 2010 at 7:23 pm
  • Hi all, Our project has been running for 10 years now. We have a large number of orphaned or redundant tables, views, and functions, due to many years of inadequate source management. We are running ...
    Andrew BartleyAndrew Bartley
    Jul 12, 2010 at 9:47 pm
    Jul 15, 2010 at 9:02 am
  • Hello people of the Postgresql world! I am wondering if Postgresql would a great choice for my database needs. I would like to create a db with dynamic data model. I would like to be able to add ...
    Pierre ThibaultPierre Thibault
    Jul 28, 2010 at 11:12 pm
    Aug 3, 2010 at 5:29 pm
  • Hi there. I have a huge database with several tables. Some tables have statistics information. And it's very huge. I don't want to loose any of this data. But hard drives on my single server are not ...
    AlannYAlannY
    Jul 26, 2010 at 11:02 am
    Jul 26, 2010 at 9:10 pm
  • Hi, the explanation of the --inserts option of pg_dumps states that "The --column-inserts option is safe against column order changes, though even slower." The way I read this is, that INSERT INTO ...
    Thomas KellererThomas Kellerer
    Jul 16, 2010 at 8:36 am
    Jul 19, 2010 at 2:13 pm
  • Is there a way to select a list of column values directly into an array? create table foo (col1 text); insert into foo (col1) values ('aaa'),('bbb'),('ccc'),('ddd'),('eee'); I'd like to load up an ...
    Gauthier, DaveGauthier, Dave
    Jul 27, 2010 at 1:03 pm
    Jul 31, 2010 at 7:36 pm
  • It seems no secret that a child table will not fire a trigger defined on it's parent table. Various posts comment on this. But nowhere could I find a reason for this. Now, I just wonder whether the ...
    Davor J.Davor J.
    Jul 15, 2010 at 8:23 am
    Jul 29, 2010 at 9:37 am
  • Hi! I have a problem with the max postgres connections on SCO Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 but this version comes in 2 editions: Starter and Enterprise. If ...
    Edmundo Robles L.Edmundo Robles L.
    Jul 22, 2010 at 9:24 pm
    Jul 25, 2010 at 5:14 am
  • I think that something bad has happened to Fedora 13 this week. This morning when I tried the following: select dblink_connect('host=mbp user=levan dbname=levan password=xxxxxx') I got the following ...
    Jerry LeVanJerry LeVan
    Jul 17, 2010 at 1:11 pm
    Jul 17, 2010 at 10:37 pm
  • Hello! I use Postgres 8.4.1 as service, with Windows 7. It seems to me the same situation will take place with Vista. I've notice that in some special cases PG uses folder %APPDATA% for Windows user ...
    El doradoEl dorado
    Jul 7, 2010 at 8:30 am
    Jul 8, 2010 at 8:43 pm
  • I'd like to convert a small database to UTF8 before it becomes too large. I'm running on 8.3.x on Windows. It doesn't seem that pgAdmin has any native way of doing this, what's the easiest way to go ...
    Mike ChristensenMike Christensen
    Jul 1, 2010 at 4:09 pm
    Jul 1, 2010 at 5:14 pm
  • Is there anyway to rescue data afer power off. I have postgres database version 8.3.9 on windows 2003. Yesterday my server is power off, when i start server, some of table is blank. Is there anyway ...
    TuanhoanganhTuanhoanganh
    Jul 19, 2010 at 9:16 am
    Jul 19, 2010 at 7:16 pm
  • Hi, I'm trying pg_upgrade on my Windows installation and I have two suggestions for the manual regarding pg_upgrade: When specifying directories, pg_upgrade *requires* a forward slash as the path ...
    Thomas KellererThomas Kellerer
    Jul 12, 2010 at 9:30 pm
    Jul 13, 2010 at 8:05 pm
  • Hi, I am having some uncertainty while designing the following structure: I have two sets of data: * arqueology sites (can be natural): id name description id_category id_period x y * natural sites ...
    Miguel VazMiguel Vaz
    Jul 9, 2010 at 1:41 am
    Jul 9, 2010 at 6:47 pm
  • Hi, I'am using rules in views, but I'am not sure about how the rules work... let me explain... For example, I have this table: [code] CREATE TABLE "atau_utilizadores" ( "id" int4 NOT NULL, "group_id" ...
    Andre LopesAndre Lopes
    Jul 6, 2010 at 10:34 am
    Jul 6, 2010 at 2:09 pm
  • Hello! Can someone help me to develop a query? Things are more complex than this example, but with this simple example I can explain what I need and get an answer. Table: "diagnose_logs" Fields: - id ...
    Pedro Zorzenon NetoPedro Zorzenon Neto
    Jul 5, 2010 at 2:55 pm
    Jul 6, 2010 at 5:39 am
  • Hello Guys, We are trying to migrate from Oracle to Postgres. One of the major requirement of our database is the ability to generate XML feeds and some of our XML files are in the order of 500MB+. ...
    Zeeshan GhalibZeeshan Ghalib
    Jul 5, 2010 at 10:19 am
    Jul 5, 2010 at 3:49 pm
  • Hi, I have a function, at the end I need to know if the INSERTS have run successfully or not. Here is the function: [code] CREATE OR REPLACE FUNCTION "apr_insert_utilizador_ap" (IN ppgroup_id int4, ...
    Andre LopesAndre Lopes
    Jul 4, 2010 at 10:02 am
    Jul 5, 2010 at 1:29 am
  • Hi, System information: - psql 8.4.4 on a client with CentOS 5.5 (64 bits) - postgres 8.4.4 on the server with CentOS 5.5 (64 bits) - the client is connected with vpn I have a script to create a ...
    Gary FuGary Fu
    Jul 22, 2010 at 9:25 pm
    Jul 28, 2010 at 1:26 pm
  • Hi all, I've noticed that an insert command with returning clause returns an empty result set if done on a master table. Instead the same insert with returning on partitioned tables works correctly. ...
    PdoveraPdovera
    Jul 20, 2010 at 2:06 pm
    Jul 21, 2010 at 10:32 am
  • Hi, I have a DUMP file with INSERT's commands. I need to import this data to postgresql database with the "psql" command. How can I do this task? Best Regards,
    Andre LopesAndre Lopes
    Jul 18, 2010 at 8:06 pm
    Jul 18, 2010 at 11:10 pm
  • Hi, I have two tables each with nearly 300M rows. There is a 1:1 relationship between the two tables and they are almost always joined together in queries. The first table has many columns, the ...
    Joshua RubinJoshua Rubin
    Jul 13, 2010 at 9:24 pm
    Jul 17, 2010 at 7:18 am
  • I have 10 million rows in a table, with full text index created on one of the columns. I submit this query: ims=# select count(*) from search_rm ims-# where to_tsvector('english', textsearch) ims-# ...
    Howard RogersHoward Rogers
    Jul 15, 2010 at 11:20 pm
    Jul 16, 2010 at 8:58 pm
  • Hello. I propose 2 features for planner: 1. Planner will estimate 2 x statistics: time of query with cache empty and with cache filled. 2. Two levels of plannig: standard and long. Long planning may ...
    Pasman PasmańskiPasman Pasmański
    Jul 13, 2010 at 11:49 am
    Jul 15, 2010 at 9:59 am
  • Hi All I am using a cluster setup with two nodes in it. Replication between two nodes is being done through slony. Postgres version is 8.1.2 and slony version is 1.1.5 . I am running an operation ...
    Tamanna madaanTamanna madaan
    Jul 9, 2010 at 5:12 am
    Jul 14, 2010 at 9:22 pm
  • Hi all, We tend to do a lot of lookups on our database that look something like: select e.id from employee e ,app_user au where au.id=user_id and au.corporation_id=$1 and e.ssn is not null and ...
    Anthony PresleyAnthony Presley
    Jul 14, 2010 at 7:23 pm
    Jul 14, 2010 at 9:00 pm
  • Hello, I'm facing a strange problem where the optimizer does pick the wrong index. Im using postgres 8.4, and my schema look like this: client_id | character varying(36) | not null key | character ...
    Martin BelowMartin Below
    Jul 7, 2010 at 11:49 am
    Jul 8, 2010 at 7:23 pm
  • Hi, I need to use an Forum Software. There is any Open Souce Forum Script using PostgreSQL? Best Regards, André.
    Andre LopesAndre Lopes
    Jul 4, 2010 at 2:10 pm
    Jul 4, 2010 at 3:51 pm
  • Hi all. I'd like to convert an 8-bytes BYTEA into a BIGINT and possibly vice versa. Is there any way to do it? -- Vincenzo Romano NotOrAnd Information Technologies NON QVIETIS MARIBVS NAVTA PERITVS
    Vincenzo RomanoVincenzo Romano
    Jul 26, 2010 at 9:32 am
    Jul 27, 2010 at 9:35 am
  • Hi all, Is it possible to perform an SQL Dump without using pg_dump? I have a special case situation wherein my application has access to a remotely-hosted PG (8.3) database, but does not have access ...
    Scott FrankelScott Frankel
    Jul 26, 2010 at 3:59 pm
    Jul 26, 2010 at 5:19 pm
  • I am working on shipping WAL files, can WAL files do one-to-many shipping? The target PG instances are running in the recovery mode waiting for the WAL files. also, once the target PG database ...
    SteelesSteeles
    Jul 23, 2010 at 4:29 pm
    Jul 23, 2010 at 10:43 pm
  • Hello, I have strange problem. I test/optimize my queries with EXPLAIN ANALYZE. I get for example: Total runtime: 40.794 ms But when I run query without EXPLAIN ANALYZE i get, for example: Time: ...
    Piotr GasidłoPiotr Gasidło
    Jul 22, 2010 at 7:30 pm
    Jul 23, 2010 at 12:47 pm
  • Hi. It's not clear to me if the "simple" dictionary uses stopwords or not, does it? Can someone please post a complete description of what the "simple" dict. does? -- Andreas Joseph ...
    Andreas Joseph KroghAndreas Joseph Krogh
    Jul 22, 2010 at 2:15 pm
    Jul 22, 2010 at 7:38 pm
  • Hi all, I'm bordering on insanity, trying to track down an IDLE in transaction problem. This started a few weeks ago, and we are using a Java application, running Spring 2.0, Hibernate 3.2 (with L2 ...
    Anthony PresleyAnthony Presley
    Jul 13, 2010 at 8:02 pm
    Jul 15, 2010 at 4:58 pm
  • Hi List, I have trouble using XPath name() function in a XML field. For example, when I execute the following query : SELECT XPATH('name(/*)', XMLPARSE(DOCUMENT '<unit value</unit ')) I would like to ...
    Ced45Ced45
    Jul 13, 2010 at 8:03 am
    Jul 14, 2010 at 5:37 pm
  • Hi lists ! We ran into a problem after restoring a database dump. Postgesql version is 8.4.3 on Win32. The tables are linked with psqlODBC (v8.03.0400) and have SERIAL primary keys (that's why I ...
    Arnaud LesauvageArnaud Lesauvage
    Jul 6, 2010 at 10:02 am
    Jul 7, 2010 at 7:41 am
  • I belong to MANY email listservers, probably like all of us. All of them, I am on digest. The CONTENT from all of you contributors is superior, more mature, and more directly helpful than all the ...
    Dennis GearonDennis Gearon
    Jul 5, 2010 at 9:44 pm
    Jul 7, 2010 at 2:51 am
  • Hello, I've got a problem with user defined functions in C using SPI. Using: PostgreSQL 8.3.7, Codeblocks (GNU GCC Compiler), Windows Server 2003 R2 I compiled the file "pgExampleSPI.c" with the ...
    SaitenheiniSaitenheini
    Jul 2, 2010 at 1:45 pm
    Jul 2, 2010 at 3:52 pm
Jul 2010
1234
Group Navigation
period‹ prev | Jul 2010 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions193
posts1,038
users274
websitepostgresql.org
irc#postgresql

274 users for July 2010

Craig Ringer: 57 posts Tom Lane: 44 posts Scott Marlowe: 30 posts Greg Smith: 28 posts Alban Hertroys: 23 posts Sam Mason: 21 posts Andras Fabian: 20 posts Merlin Moncure: 20 posts Thom Brown: 19 posts Howard Rogers: 18 posts Joshua D. Drake: 18 posts Pavel Stehule: 18 posts Thomas Kellerer: 16 posts Tim Landscheidt: 15 posts Andre Lopes: 14 posts Vincenzo Romano: 13 posts Andreas Kretschmer: 12 posts Joe Conway: 11 posts Alvaro Herrera: 10 posts Devrim Gündüz: 10 posts
show more
Archives