Search Discussions

291 discussions - 1,511 posts

  • Hi, I found this to create dynamic crosstabs (where the resulting columns are not known beforehand): http://www.ledscripts.com/tech/article/view/5.html (Thanks for Denis Bitouzé on ...
    Feb 13, 2008 at 7:38 am
    Feb 1, 2010 at 12:13 am
  • Well until now... i think i am the only venezuelan here.... i havent been able to locate Cesar Villanueva.... .< anyone knows other venezuelans arround? Btw... i've joined the cert list aswell ...
    Santiago ZarateSantiago Zarate
    Feb 1, 2008 at 4:48 pm
    Feb 4, 2008 at 11:20 pm
  • Hello, I think that I understand basic relational theory but then I had an idea. What I would like to know if this is sometimes done or that I am possibly mad... Also, I do not know the terminology ...
    Vladimir konradVladimir konrad
    Feb 2, 2008 at 12:05 pm
    Feb 12, 2008 at 11:21 pm
  • For sake of interoperability (and using an API that requires String-type hashtable keys), I'm trying to find a single CAST (int - var/char) syntax that works between the most databases. Only char ...
    Ken JohansonKen Johanson
    Feb 12, 2008 at 5:37 am
    Feb 16, 2008 at 9:17 pm
  • Hi, I have an index on the user_id field in the query below: myuser=# delete from clients where user_id like '64.22.91.%'; DELETE 22 Time: 220324.975 ms Is there any reason why it's taking 220 ...
    Phoenix KiulaPhoenix Kiula
    Feb 15, 2008 at 10:55 am
    Feb 18, 2008 at 4:22 pm
  • Greetings: We have been working diligently toward integrating Slony into our production databases. We've been having trouble with various tables, although being replicated perfectly in the initial ...
    Terry Lee TuckerTerry Lee Tucker
    Feb 21, 2008 at 3:20 pm
    Apr 9, 2008 at 10:44 pm
  • I am a bit puzzled by the output of ts_headline (V8.3) for different queries. I have one record in a test documentation table and am applying different queries against that table to check out the ...
    Stephen DaviesStephen Davies
    Feb 21, 2008 at 12:20 am
    Feb 23, 2008 at 12:02 pm
  • Hi, I installed today's release setup of PostgreSQL 8.3. Unfortunately Libpq.dll has a dependancy to msvcr80.dll, which can't be found on my system. I checked the msi installer file and found that ...
    Hermann MusterHermann Muster
    Feb 4, 2008 at 3:06 pm
    Feb 18, 2008 at 3:58 pm
  • Hi, I would like to store binary data in a PostgreSQL database. The size of the data is about 2 to 20 MB and is always stored or retrieved as a block (i.e., I do not need to get only part of the ...
    Koen VermeerKoen Vermeer
    Feb 12, 2008 at 10:41 pm
    Feb 14, 2008 at 3:09 pm
  • I'm running a simple query on 8.2. With this syntax, Explain indicate that the index is scanned: select * from eod where name = 'AA' However, when I change the query to use simple regex: select * ...
    Postgres UserPostgres User
    Feb 20, 2008 at 3:32 am
    Feb 24, 2008 at 12:05 pm
  • Hello, I'd like to perform linear algebra operations on float4/8 arrays. These tasks are tipically carried on using ad hoc optimized libraries (e.g. BLAS). In order to do this, I studied a bit how ...
    Enrico SirolaEnrico Sirola
    Feb 1, 2008 at 10:31 am
    Feb 3, 2008 at 4:35 pm
  • I'm glad I didn't go from 8.2.3 to 8.3 straight! http://ogasawalrus.com/blog/node/462
    Phoenix KiulaPhoenix Kiula
    Feb 15, 2008 at 2:21 pm
    Feb 19, 2008 at 10:26 am
  • I did manage to find an announcement about the support of pg for windows... but I wasn't able to see anything you'd have a summary of scheduled and planned EOL for various pg versions (on different ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Feb 11, 2008 at 1:04 pm
    Feb 12, 2008 at 11:52 pm
  • Hi, I started thinking that using dblink I could "easily" get some kind of read only multi-server partitioning, if only VIEWs could be declared with "INHERITS"... That way I think I could 1) add as ...
    Scara MaccaiScara Maccai
    Feb 28, 2008 at 8:20 pm
    Mar 22, 2008 at 10:06 pm
  • hi I used Postgresql7.4.3 with php for more than 3years. Now I want to change my database to Postgresql8.3. But I occur such problem ---------------------------------------------------------- ERROR: ...
    Bh yuanBh yuan
    Feb 8, 2008 at 7:17 am
    Feb 18, 2008 at 12:43 am
  • I acknowledge that from time to time we must accept changes in the 3rd party software that will break our apps if we (or customers) ever upgrade them (a compounded issue if we have heavily-used ...
    Ken JohansonKen Johanson
    Feb 9, 2008 at 5:20 pm
    Feb 12, 2008 at 2:28 am
  • It appears (and I am open to correction) that autovacuum is not operating correctly in 8.3.0. I have a vanilla installation where autovacuum is enabled, and is running with all the default settings. ...
    Stuart BrooksStuart Brooks
    Feb 25, 2008 at 7:02 am
    Feb 27, 2008 at 1:56 pm
  • Hi, I am trying to bring one of my Cocoa based Postgresql browsers up to date. I would like to create a "universal", ie works on PPC and Intel Macintosh platforms, version of the application. I guess ...
    Jerry LeVanJerry LeVan
    Feb 4, 2008 at 3:36 pm
    Feb 5, 2008 at 6:18 pm
  • (After dealing a while with this, and learning a little, I though of post this as comment in the docs, but perhaps someone who knows better can correct or clarify) ...
    Hernan gonzalezHernan gonzalez
    Feb 21, 2008 at 4:34 pm
    Mar 4, 2008 at 3:29 am
  • I continue to hope that 8.4 later (or 8.3 patched) will provide behavior / compatibility controls.. I personally have requested others in past, but one outstanding one now, seems to be an ability to ...
    Ken JohansonKen Johanson
    Feb 14, 2008 at 10:55 pm
    Feb 17, 2008 at 2:40 am
  • Hi guys :-), I am working on a personal project in which I am trying to make sense on a huge (at least for me) amount of data. I have approximately 150 million rows of unique words (they are not ...
    Mario LopezMario Lopez
    Feb 11, 2008 at 3:38 pm
    Feb 12, 2008 at 3:16 pm
  • Hi. Is it possible to reload only specific databases from a file created by pg_dumpall? Thanks, cug
    Guido NeitzerGuido Neitzer
    Feb 4, 2008 at 10:46 am
    Feb 7, 2008 at 5:51 pm
  • I seem to have some planner oddity, where it seems to completely mispredict the output after a regex compare. I've seem it on other occasions, where it completely screws up the join. You can note the ...
    Joris DobbelsteenJoris Dobbelsteen
    Feb 24, 2008 at 10:34 pm
    Mar 6, 2008 at 9:05 am
  • Hello. I'd like to use ORDER BY in any specified order and LIMIT, OFFSET for paging query results. The query is FULL OUTER JOIN of two tables by field id. I think the results of Merge Full Join to be ...
    Alexey NalbatAlexey Nalbat
    Feb 21, 2008 at 10:08 am
    Feb 26, 2008 at 6:44 pm
  • Hello list, Just joined, read the archives, but couldn't find a solution to my problem. My question is: 'How can I best determine when to delete data?'. Hopefully this is the right place to ask, ...
    Michiel HoltkampMichiel Holtkamp
    Feb 14, 2008 at 2:57 pm
    Feb 14, 2008 at 9:46 pm
  • reindex table user_profile; ERROR: deadlock detected DETAIL: Process 32450 waits for AccessExclusiveLock on relation 194689112 of database 163880909; blocked by process 31236. Process 31236 waits for ...
    Dave CramerDave Cramer
    Feb 12, 2008 at 1:24 pm
    Feb 12, 2008 at 10:28 pm
  • Hi All, I am currently running into an issue with a query and would like to get some assistance if possible. The PostgreSQL version I am running is 8.0.11 64-Bit, under SuSE Linux Enterprise Server 9 ...
    Chris BowlbyChris Bowlby
    Feb 29, 2008 at 5:39 pm
    Feb 29, 2008 at 7:54 pm
  • All, I've done some searching in the mailing list archives, and the Internet in general, and come up with a blank. Here's my setup: I'm working on setting up a replication system between two 8.1.11 ...
    John EvansJohn Evans
    Feb 28, 2008 at 6:30 pm
    Feb 29, 2008 at 7:25 am
  • I'm working on a CMS that, in addition to the database-stored version of articles for easy searching, sorting, etc, also stores a HTML file version so pages can be fetched with the minimum of ...
    Feb 26, 2008 at 11:11 am
    Feb 28, 2008 at 2:12 am
  • Hi, I am reindexing my 7.1.4 postgres database. The postmaster seems to create processes for each reindex request. Is there any way to find out more about the processes. ps -aef | grep postgres ...
    Feb 22, 2008 at 6:36 pm
    Feb 27, 2008 at 8:14 pm
  • Hi,Every body; I have a table contains 100,000 rows, and has a primary key(int). Now ,I need to execute sql command like "update .......... where id=*"(id is primary key). I expect execute 1200-1600 ...
    Feb 20, 2008 at 3:38 am
    Feb 24, 2008 at 12:34 pm
  • Hi all, I want to write a function in C which retrieves a large string from a table, does some work on it and returns the result to the surrounding SELECT. (e.g. SELECT my_c_func(text);) So far I ...
    Stefan NiantschurStefan Niantschur
    Feb 17, 2008 at 12:40 pm
    Feb 18, 2008 at 7:48 pm
  • I was playing around with the enum type today. I was toying around with a schema to model information about baseball, and decided to create an enum named position: tjhart=# create type position as ...
    Tim HartTim Hart
    Feb 18, 2008 at 4:32 am
    Feb 18, 2008 at 6:26 am
  • http://www.theserverside.com/news/thread.tss?thread_id=48339 The interesting part is where somebody asks why NOT use postgres, and it's answers could give some additional hints to those interested on ...
    Csaba NagyCsaba Nagy
    Feb 13, 2008 at 10:32 am
    Feb 15, 2008 at 12:45 am
  • I have the following function that returns the first day of the next month from whatever date is inserted. If I use this as part of a select statement then it takes almost twice as long to perform. ...
    Willem BuitendykWillem Buitendyk
    Feb 10, 2008 at 11:13 pm
    Feb 11, 2008 at 11:21 pm
  • Can anyone interpret this error message? It appears in response to each of the following queries in one instance of PostgreSQL 8.3: SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN ...
    Dave LivesayDave Livesay
    Feb 10, 2008 at 5:27 pm
    Feb 11, 2008 at 5:29 pm
  • hi list: im working in the setup of a warm standby server. im using postgres-8.2.5 in the slave and 8.2.4 in master right now, in production it will be only 8.2.5, everything in debian etch. we ...
    Roberto ScattiniRoberto Scattini
    Feb 9, 2008 at 3:07 am
    Feb 9, 2008 at 1:20 pm
  • hi, on the page: <http://www.postgresql.org/docs/8.3/static/release-8-3.html in point E.1.2.3: * Disallow database encodings that are inconsistent with the server's locale setting (Tom) does this ...
    Clemens SchwaighoferClemens Schwaighofer
    Feb 5, 2008 at 2:17 am
    Feb 5, 2008 at 8:04 am
  • Hi, This is my first message, and I need some help. I have just installed Postgresql 8.2. (Windows). At pgAdmin III Query, when I send SELECT * FROM USUARIOS, I get all columns correctly. But when I ...
    Aílsom F. HeringerAílsom F. Heringer
    Feb 2, 2008 at 5:43 pm
    Feb 3, 2008 at 12:10 am
  • Hello, I have asked the question on novice ML but it seems there is not much traffic there. I hope nobody minds I'm re-asking here, on a much more active list. The problem is as follows: There are 2 ...
    Maciej SieczkaMaciej Sieczka
    Feb 25, 2008 at 10:42 pm
    Mar 3, 2008 at 12:04 pm
  • When I do a ps -ef, in the command column, I see: postgres: postgres dbname idle I get all of this, except the "57413". What does this mean, and more importantly, how can I tie ...
    David JaquayDavid Jaquay
    Feb 22, 2008 at 4:18 pm
    Mar 2, 2008 at 12:37 pm
  • "Auto-incrementing" columns, typically implemented using the serial data type [1], employ sequences. From the manual: "To avoid blocking of concurrent transactions that obtain numbers from the same ...
    Paul BoddiePaul Boddie
    Feb 18, 2008 at 1:13 pm
    Feb 19, 2008 at 3:09 pm
  • Hello pgsql-general, Can send email from stored procedure in Postgres ? Best regards, william hewei@mango.cc 2008-02-15
    Feb 15, 2008 at 3:40 am
    Feb 18, 2008 at 4:19 pm
  • I am attempting to install the Fossology <http://fossology.org/ OSS license analysis software on a server running Ubuntu Linux and PostgreSQL. I have gotten to the point where I am at the final ...
    Kurt SchroederKurt Schroeder
    Feb 6, 2008 at 8:13 pm
    Feb 7, 2008 at 6:05 pm
  • Hello, this past weekend I received a couple of Out of Memory errors while running pg_dump for two different selects against the catalogs, one with pg_get_viewdef() and the other with one of the ...
    Erik JonesErik Jones
    Feb 4, 2008 at 5:24 pm
    Feb 6, 2008 at 4:01 am
  • Hello We are using different OS (Mac, win (with a small w!) and Linux). We had some problems when doing some ordering on names. I found that it seemed to be related on locale, While on Linux it used ...
    Pascal CohenPascal Cohen
    Feb 21, 2008 at 8:00 am
    Jan 15, 2009 at 5:06 pm
  • What are the permissions required to install postgres as a service on windows 2000/2003? I have followed the instructions, as I understand them, but the program will not install. It either fails with ...
    Feb 28, 2008 at 3:18 pm
    Mar 20, 2008 at 6:26 am
  • Hi, I urgently need a way to simply backup the database's data on win32 (e.g. the 'data' directory). As discussed earlier I can't use dump/dumpall since my data needs persistent tableoids which, ...
    Feb 26, 2008 at 9:17 pm
    Feb 27, 2008 at 3:14 pm
  • Hello ! I have a week number (ISO 8601) and a year, based on theses values, I would like to get the first and the last dates of that week. How I can do that ? The only solution is doing a big ...
    Bruno BaguetteBruno Baguette
    Feb 27, 2008 at 1:53 am
    Feb 27, 2008 at 9:16 am
  • I am considering how best to handle the issue of attribute encoding for an OLTP application conversion. The existing system, which does not employ a relational DBMS in the commonly accepted sense, ...
    James B. ByrneJames B. Byrne
    Feb 15, 2008 at 5:09 pm
    Feb 23, 2008 at 11:13 pm
Group Navigation
period‹ prev | Feb 2008 | next ›
Group Overview
grouppgsql-general @

357 users for February 2008

Tom Lane: 147 posts Alvaro Herrera: 53 posts Richard Huxton: 41 posts Scott Marlowe: 40 posts Erik Jones: 35 posts Ken Johanson: 24 posts Magnus Hagander: 24 posts Greg Smith: 23 posts Greg Stark: 22 posts Brian Ally: 19 posts Joshua D. Drake: 18 posts Martijn van Oosterhout: 18 posts Phoenix Kiula: 16 posts Andrew Sullivan: 15 posts Dave Page: 14 posts Hiroshi Saito: 14 posts Ivan Sergio Borgonovo: 14 posts Chris: 13 posts Andrej Ricnik-Bay: 12 posts Kynn Jones: 12 posts
show more