Search Discussions

141 discussions - 789 posts

  • Hello, My objective is to work with postgres from my linux box using C. Am not sure whether psqlODBC or libpq<http://www.postgresql.org/docs/9.2/static/libpq.html should be used. I was playing and ...
    Dev KumkarDev Kumkar
    May 21, 2013 at 12:45 am
    May 23, 2013 at 7:14 am
  • Hello. We're intending to deploy PostgreSQL on Linux with SSD drives which would be in a RAID 1 configuration with Hardware RAID. My first question is essentially: are there any issues we need to be ...
    Matt BrockMatt Brock
    May 10, 2013 at 2:14 pm
    May 21, 2013 at 11:40 am
  • I have an app that we have a number of tables that all have FK relationships with the account table. We did a massive (2900+ account, probably multi-thousand rows) delete from all the tables, and the ...
    Larry RosenmanLarry Rosenman
    May 1, 2013 at 3:17 pm
    May 17, 2013 at 10:12 pm
  • Hi, this question isn't technical, but is very important for me to know. Currently, here in El Salvador our company brings PostgreSQL support, but Oracle and SQL Server are more popular here. Even ...
    Oscar CalderonOscar Calderon
    May 23, 2013 at 9:36 pm
    May 28, 2013 at 11:31 am
  • Good morning list, I am designing a system that will have a table for security badges, and we want to store the ID badge photo. These are small files, averaging about 500K in size. We have made the ...
    Nelson GreenNelson Green
    May 9, 2013 at 3:04 pm
    May 10, 2013 at 1:25 pm
  • Dear PostgreSQL gurus, It seems that the comparison operator "=" is functioning as the assignment operator ":=" in this plpgsql trigger script I wrote. I was under the impression that "=" is only for ...
    Moshe JacobsonMoshe Jacobson
    May 28, 2013 at 7:53 pm
    Jun 1, 2013 at 9:27 pm
  • Hi All, I am observing some weird errors in the postgres logs after upgrading to Postgres 9.2.4. FATAL: database "a/system_data" does not exist We do have a user named "system_data" and a schema with ...
    May 9, 2013 at 11:28 am
    May 17, 2013 at 10:22 am
  • On most nested loops that I do explain/explain analyze on, the row estimation for the nested-loop itself is a product of the inner nodes of the nested loop. However in this case, I am stumped! ...
    Jeff AmielJeff Amiel
    May 17, 2013 at 4:25 pm
    May 20, 2013 at 3:49 pm
  • i want to convert numbers into words in postgresql.is there any query for it? if yes please reply soon -- View this message in context ...
    May 14, 2013 at 6:27 am
    May 15, 2013 at 9:24 am
  • Greetings, I have a domain specific language implementation that ends up as sql after an automatic transformation/code generation phase. The complexity of the generated sql queries can be ...
    Seref ArikanSeref Arikan
    May 8, 2013 at 1:40 pm
    May 9, 2013 at 3:43 pm
  • Hi all, I have a production database that sometimes runs out of memory=at nightly vacuum. The application runs typically with around 40 post=res connections but there are times when the connections ...
    Ioana DanesIoana Danes
    May 14, 2013 at 1:55 pm
    May 16, 2013 at 1:27 pm
  • The SARS_ACTS table currently has 37,115,515 rows we have = indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree (sars_run_id)
    May 21, 2013 at 9:53 pm
    May 29, 2013 at 2:44 pm
  • Hi, I have my database in which i am executing vacuuming running manually in one hour. In my production database sometime when vacuuming is running it is taking long time in opening connection. My ...
    S HS H
    May 13, 2013 at 2:05 pm
    May 19, 2013 at 1:14 am
  • Hello, I have a 9.1 cluster with 50 databases, only one table per db with 2000 rows only, but a lot of schema around each one (postgis databases) The old cluster size is 1GB du -chs ...
    Fabio Rueda CarrascosaFabio Rueda Carrascosa
    May 16, 2013 at 5:42 pm
    May 21, 2013 at 9:16 pm
  • Hi everyone: I have a question. I think it's so simple to answer but I don't know anything about that. I want to know what is the comunication protocol among PostgreSQL database server and an ...
    Karel Riveron EscobarKarel Riveron Escobar
    May 17, 2013 at 2:54 pm
    May 17, 2013 at 7:50 pm
  • By doing insert into a table using a query, it seems that all records of consultation were included bypassing the AFTER INSERT triggers and as few as after all the records already included, the ...
    Juliano Amaral ChavesJuliano Amaral Chaves
    May 24, 2013 at 7:26 pm
    Jun 1, 2013 at 5:41 pm
  • I would think this would be possible. I'm on 9.0.8 I have a reference between two tables, and want to populate a field in one table with a value that's in the referenced table ( based on the FK ...
    David SalisburyDavid Salisbury
    May 31, 2013 at 9:37 pm
    Jun 1, 2013 at 4:15 am
  • Hi, Currently, our application is still using PG 8.2 and we are trying to use 9.2 but there are some problems related with the implicit casts removed on 8.3. Example: 1) select 'teste'||1; 2) select ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    May 15, 2013 at 7:17 pm
    May 15, 2013 at 9:36 pm
  • How can I show the value of search_path for the database, the user and the session? I ask because I cannot explain the following: $ psql -U postgres -d ises psql (9.1.4) Type "help" for help ...
    Moshe JacobsonMoshe Jacobson
    May 27, 2013 at 6:29 pm
    May 28, 2013 at 1:31 pm
  • I am wanting to partition my data based on a mod of one of the bigint columns, but when I run my insert test all the data goes into the base table and not the partitions. Here is what the table looks ...
    Richard OnoratoRichard Onorato
    May 21, 2013 at 5:34 pm
    May 23, 2013 at 2:17 am
  • Hi folkes, I'm looking for a nice way to build this scenario: I've got a lot of locations with some special types. For example I've got workplaces, places like real laboratories and virtual places ...
    Frank LanitzFrank Lanitz
    May 17, 2013 at 12:47 pm
    May 19, 2013 at 1:44 pm
  • Hi all, I've downloaded PLJava, the latest version, which doesn't seem to have a binary distribution at all for 9.2, so I'm trying to build it from the source for Postgres 9.2. I have the DB itself ...
    Paul HammondPaul Hammond
    May 16, 2013 at 9:59 pm
    May 17, 2013 at 11:05 am
  • Hi, I have a query that uses a PL/R function to run a statistical model on data in a postgresql table. The query runs the function 4 times, each of which generates about 2 million lines of results, ...
    David M. KaplanDavid M. Kaplan
    May 16, 2013 at 12:47 pm
    May 17, 2013 at 10:19 am
  • Hi, How can I upgrade to latest postgresql version 9.2 from my current version 7.4.3? How complicated this will be as the db contains large amount of data? I have installed the latest version 9.2 in ...
    Arun P.LArun P.L
    May 9, 2013 at 9:02 am
    May 10, 2013 at 5:04 am
  • Hello, On the same station, i have 2 postgresql server: one for my postgis db (v9.1) and so another installed with opener^7 (9.2). Unfortunalty, i noticed i'm obliged to stop service for my ...
    May 28, 2013 at 9:54 am
    May 28, 2013 at 5:35 pm
  • Hello. I have some data that was accidently deleted. I have not done a vacuum etc. I know the raw text of the data should be in the xlog file. However when using xlogdump of pg_filedump I am not able ...
    Ash DamleAsh Damle
    May 27, 2013 at 2:27 am
    May 27, 2013 at 3:34 am
  • Hello list, I want to generate random numbers in Pl/pgSQL. How can I do this? To be more specific, I have to generate random numbers among 0 and 5. Thanks in advance. Regards, Karel Riverón Student ...
    Karel Riveron EscobarKarel Riveron Escobar
    May 25, 2013 at 3:45 pm
    May 25, 2013 at 4:20 pm
  • Hi there. This may be the wrong forum to inquire in, but I'd be grateful if I could directed in the right direction if that is the case. I am currently using Postgresql 9.1. I have a table in which I ...
    Rebecca ClarkeRebecca Clarke
    May 14, 2013 at 5:05 pm
    May 15, 2013 at 10:04 am
  • Hi, We are developing a solution which will run in thousands of small cash till machines running Linux and we would like to use PostgreSQL but there is a insecurity feeling regarding the solution ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    May 10, 2013 at 1:43 pm
    May 12, 2013 at 4:59 am
  • If I have a simple table with an id as a primary key that is a serial column and a column to keep track of a total_count for a particular id, what method would provide the fastest way to increment ...
    Tyson MalyTyson Maly
    May 8, 2013 at 1:45 pm
    May 9, 2013 at 12:50 pm
  • A minor detail in 9.2.4, but I noticed that the pg_upgrade flag for superuser, -u, does not get carried to a -U flag on the vacuumdb commands written to analyze_new_cluster.sh.
    Ray StellRay Stell
    May 8, 2013 at 9:05 pm
    May 29, 2013 at 3:17 pm
  • I've two distant servers I would like to configure async replication between. Servers are running 9.2.4. Since 9.0 days I do use script with rsync for transfer. And sometimes the servers get out of ...
    Edson RichterEdson Richter
    May 28, 2013 at 12:09 am
    May 28, 2013 at 5:23 am
  • Hello, I have a question for which I am unable to find an answer in the documentation, if y'all don't mind, I will ask here and hope for an answer. After installing PostgreSQL and logging in as the ...
    Melvin CallMelvin Call
    May 23, 2013 at 9:02 pm
    May 24, 2013 at 1:29 am
  • hello , I'm restoring a 7 days ago full backup + wal files. I have to recover more than 6k wal files and I have no time, I would accept to work with a ~ 3 days ago snapshot, can I stop the recovery ...
    Fabio Rueda CarrascosaFabio Rueda Carrascosa
    May 22, 2013 at 10:09 am
    May 22, 2013 at 12:06 pm
  • Hi all, I have a production database that sometimes runs out of memory at nightly vacuum. The application runs typically with around 40 postgres connections but there are times when the connections ...
    Ioana DanesIoana Danes
    May 14, 2013 at 1:37 pm
    May 16, 2013 at 9:02 pm
  • If I have this: CREATE OR REPLACE VIEW Link.Foo AS select * from dblink( 'hostaddr= dbname=KitchenPC user=Website password=secret', 'select * from Foo') as ... Then it works. However, ...
    Mike ChristensenMike Christensen
    May 15, 2013 at 4:17 am
    May 15, 2013 at 2:25 pm
  • I saw on the mailing list that back in 2010 there was some discussion of using Zorba to add xquery capabilities to postgres. I was wondering if any progress had been made on this and what the current ...
    Kristian kvilekvalKristian kvilekval
    May 14, 2013 at 4:31 am
    May 14, 2013 at 3:22 pm
  • Let's say you have a database which is owned (as well as all the contents within it) by the postgres internal user. Having created or inherited a mess, how do you fix it? database1=# REASSIGN OWNED ...
    Jeff JanesJeff Janes
    May 8, 2013 at 9:11 pm
    May 13, 2013 at 11:05 pm
  • I don't know whether anybody active on the list has R (and in particular PL/R) experience, but just in case... :-) i) Something like APL can operate on an array with minimal regard for index order, ...
    Mark Morgan LloydMark Morgan Lloyd
    May 10, 2013 at 9:42 am
    May 10, 2013 at 8:22 pm
  • On OSX terminal, when I try and access psql history the historical line is only partially visible sometimes mixed with the last line executed, and the start position of the cursor moves about 15-20 ...
    Brett HaydonBrett Haydon
    May 10, 2013 at 12:37 am
    May 10, 2013 at 3:38 am
  • I've tried several times to upgrade a test database (with real data, ~500 GB) from 9.1 to 9.2 using pg_upgrade and every time it fails with the same error. I've tried a few different options to ...
    Evan D. HoffmanEvan D. Hoffman
    May 8, 2013 at 6:27 pm
    May 8, 2013 at 8:31 pm
  • Hello everyone, I have a problem with Pl/PgSQL function. I need to pass it as parameter an associative array. I have no idea how to do that. C an s omebody help me? To be more specific, I have an ...
    Karel Riveron EscobarKarel Riveron Escobar
    May 4, 2013 at 11:41 pm
    May 6, 2013 at 4:03 pm
  • Hello, colleagues ! I have to write random number generator state into database table Table structure is table rand_state { id serial not null primary key, state_rand bytea }; In C-function I do ...
    Yuriy RusinovYuriy Rusinov
    May 3, 2013 at 9:19 am
    May 5, 2013 at 8:22 pm
  • Client reported an issue where it appears a foreign key has been violated prod=#\d rma_items [snip] rma_items_rma_id_status_fk" FOREIGN KEY (rma_id, rma_status) REFERENCES rmas(id, status) ON UPDATE ...
    Keith FiskeKeith Fiske
    May 23, 2013 at 2:15 pm
    Jun 4, 2013 at 4:23 pm
  • i use postgresql-9.2.4 install on ubuntu11.04(natty) and i use the command: *postgres@ubuntu:/$ postgres -D /usr/local/pgsql/data* or use *postgres@ubuntu:/$ /usr/local/pgsql/bin/postmaster -D ...
    May 24, 2013 at 7:35 am
    May 29, 2013 at 8:57 am
  • Folks, I was using PostgreSQL 8.x in development environment when one day I started getting all kinds of low-level errors while running queries and eventually had to reinstall. Maybe it was ...
    Nikhil G DaddikarNikhil G Daddikar
    May 28, 2013 at 4:48 am
    May 28, 2013 at 12:37 pm
  • Hello, I set enable_seqscan=off and also accidentally dropped the only index on a table (actually, drop extension pg_bigm cascade) and observe following: postgres=# explain select * from testdata ...
    Amit LangoteAmit Langote
    May 27, 2013 at 7:42 am
    May 27, 2013 at 8:15 am
  • Hello, guys Yesterday I identified the following messages in my log file (slave): user=,db= WARNING: page 6629 of relation base/20449/24818 is uninitialized user=,db= CONTEXT: xlog redo vacuum: rel ...
    May 16, 2013 at 2:12 pm
    May 24, 2013 at 12:46 pm
  • Hi, I am in the process of creating a rule that provides upsert functionality for all the tables which has primary key. The issue here is we have some 50 to 60 odd tables and have to write a ...
    Sajeev MayandiSajeev Mayandi
    May 23, 2013 at 5:34 am
    May 23, 2013 at 5:46 pm
  • I have a database that is on a RAID5 machine that is almost out of memory (277GB of 330GB used). I have deleted some data and run the VACUUM FULL command, but after a few hours gave me the error ...
    May 22, 2013 at 2:49 pm
    May 23, 2013 at 12:05 pm
Group Navigation
period‹ prev | May 2013 | next ›
Group Overview
grouppgsql-general @

209 users for May 2013

Tom Lane: 46 posts John R Pierce: 32 posts Merlin Moncure: 30 posts Dev Kumkar: 21 posts Amit Langote: 20 posts Scott Marlowe: 18 posts Larry Rosenman: 15 posts Raghavendra: 15 posts Jeff Janes: 13 posts Adrian Klaver: 12 posts Moshe Jacobson: 12 posts Alvaro Herrera: 10 posts Igor Neyman: 10 posts Ioana Danes: 9 posts Karel Riveron Escobar: 9 posts Nelson Green: 9 posts S H: 9 posts Yang Zhang: 9 posts AI Rumman: 8 posts Chris Travers: 8 posts
show more