FAQ

Search Discussions

242 discussions - 1,233 posts

  • Hello, I'm trying to implement the front-end protocol with TCP from REALbasic to PostgreSQL. The docs from PostgreSQL, well, I understand almost, but there are some points that maybe need more ...
    Raimon FernandezRaimon Fernandez
    Oct 26, 2009 at 10:44 pm
    Dec 9, 2010 at 11:12 pm
  • I couldn't find the operator '@' for intervals and found this thread from over six years ago: http://archives.postgresql.org/pgsql-general/2003-09/msg00292.php Is this is the case now? I have some ...
    Joshua BerryJoshua Berry
    Oct 27, 2009 at 2:27 pm
    Nov 10, 2009 at 6:43 pm
  • You may have nailed it. Everythig would have been indexed I. The order it was grouped by, so perhaps the order in which things are indexed and accesse is the kicker, or perhaps we've been ...
    Corey TisdaleCorey Tisdale
    Oct 3, 2009 at 11:12 pm
    Oct 31, 2009 at 1:58 pm
  • I've noticed that while you can perform various calculations on a column of type money, you can't use it or cast it as any other numeric type directly. Furthermore, it appears that since the locale ...
    Thom BrownThom Brown
    Oct 3, 2009 at 10:34 am
    Oct 13, 2009 at 3:03 am
  • (Sorry for the super-easy question) I want to store sales tax (as a percent) in the DB, such as 9.5%. What's the best data type for this? I'm guessing numeric(2,3) should be fine, yes? I'm not too ...
    Mike ChristensenMike Christensen
    Oct 8, 2009 at 10:26 pm
    Oct 13, 2009 at 4:49 pm
  • Hello Can the string literal syntax for the function body in a CREATE FUNCTION statement please, please be dropped ? http://www.postgresql.org/docs/8.4/interactive/plpgsql-structure.html It is so ...
    Timothy MaddenTimothy Madden
    Oct 24, 2009 at 2:56 pm
    Oct 26, 2009 at 7:54 pm
  • hi, some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL. there is no other option than constructing an HTML with forms, ...
    Pere rocaPere roca
    Oct 6, 2009 at 7:47 pm
    Oct 11, 2009 at 4:37 am
  • Hi, Are there any test guides/plans generated for alpha releases, or are such things only distributed to other developers? I've seen postings which mention what the new features are, and links to ...
    Thom BrownThom Brown
    Oct 28, 2009 at 1:34 pm
    Nov 1, 2009 at 11:10 am
  • PGDay.EU 2009 is approaching fast - have you registered yet? Europe's premier PostgreSQL conference organised by PostgreSQL Europe and PostgreSQLfr will be held on November 6th and 7th at ParisTech ...
    Dave PageDave Page
    Oct 26, 2009 at 9:05 pm
    Oct 27, 2009 at 12:51 am
  • If you issue an immediate shutdown to the database, autovacumm will not process tables that should be vacuumed until manually re-analyzed. PG 8.3.8 Relevant settings: autovacuum = on ...
    Brad NicholsonBrad Nicholson
    Oct 19, 2009 at 3:59 pm
    Oct 19, 2009 at 7:20 pm
  • Hi all, I've got a weird thing on one of my databases this night: - I've a monthly partition for storing activity logs defined as this: - mother log table - one child partition for each month - Last ...
    JC PraudJC Praud
    Oct 27, 2009 at 2:15 pm
    Oct 28, 2009 at 4:33 pm
  • Hi all! I have an UTF8 encoded shapefile, and an UTF8 encoded postgis-enabled database. I want my shapefile to be encoded in WIN1252, and a particular field to be in uppercase. Since I am on windows, ...
    Arnaud LesauvageArnaud Lesauvage
    Oct 16, 2009 at 10:01 am
    Oct 21, 2009 at 7:14 am
  • I'm running our products test suite against PostgreSQL 8.4.1. The test suite runs fine against 8.3.7. With 8.4.1, some of our tests are failing with the exception 'attempted to lock invisible tuple'. ...
    Stuart BishopStuart Bishop
    Oct 5, 2009 at 6:58 am
    Oct 7, 2009 at 6:53 am
  • an oracle guy wrote an sql statement that solves a sudoku puzzle...using an oracle specific feature. Still, it's pretty neat, and an absolute gem of lateral thinking. ...
    Merlin MoncureMerlin Moncure
    Oct 31, 2009 at 1:32 pm
    Nov 5, 2009 at 5:38 pm
  • Hello All, I'm new to postgres and it seems my server is unable to fork new connections. Here is the log: LOG: could not fork new process for connection: Not enough space LOG: could not fork new ...
    Brooks LyretteBrooks Lyrette
    Oct 28, 2009 at 7:23 pm
    Nov 3, 2009 at 1:01 am
  • Hey list, After some downtime of my site while completing rigorous database maintenance, I wanted to make sure all the databases were fully vacuumed and analyzed. I do run autovacuum, but since I ...
    APseudoUtopiaAPseudoUtopia
    Oct 1, 2009 at 7:32 pm
    Oct 7, 2009 at 1:12 am
  • Hi, I'm a new user... First of all excuse me for the bad english... :confused: I have a great problem! I have to do some little query with views, but the views contain thousand and thousand of ...
    Fox7Fox7
    Oct 27, 2009 at 10:11 pm
    Oct 29, 2009 at 8:48 am
  • Hello, I'm having a problem with the following: CREATE TYPE Sums AS (sum_m1 double precision, sum_m2 double precision); CREATE TYPE date_m1_m2 AS (cur_date date, sum_m1 double precision, sum_m2 ...
    Gerhard WiesingerGerhard Wiesinger
    Oct 18, 2009 at 8:07 pm
    Oct 21, 2009 at 3:43 pm
  • Hi, I'am searching for a free tool to design a Postgre Database. There is something similar to MySQL Workbench? Best Regards, Andre.
    Andre LopesAndre Lopes
    Oct 19, 2009 at 7:19 pm
    Oct 21, 2009 at 7:18 am
  • If I move any file from the \PostgreSQL\8.4\data\pg_xlog\ then postgres services are stopped & I cannot start them. I need to reinstall the postgres. -- View this message in context: ...
    Mitesh51Mitesh51
    Oct 13, 2009 at 4:59 am
    Oct 15, 2009 at 7:24 am
  • Hi, is there a way to rank the search results based on multiple fields in postgreSQL? For example, i have *title*, *abstract*, *summary*, *body* as fields/columns in my database. When user searches ...
    Gaini RajeshwarGaini Rajeshwar
    Oct 12, 2009 at 1:16 pm
    Oct 13, 2009 at 6:13 am
  • I'm planning to work with Andrew Dunstan on some enhancements to PL/Perl for PostgreSQL 8.5. I've written up some initial proposals here: ...
    Tim BunceTim Bunce
    Oct 5, 2009 at 10:25 pm
    Oct 6, 2009 at 8:34 pm
  • What is the "correct" behavior of a serial column when a table is created with LIKE? The manual is silent on this. What appears to be happening with 8.2 is that the column in the new table refers to ...
    Mark Morgan LloydMark Morgan Lloyd
    Oct 30, 2009 at 12:44 pm
    Oct 30, 2009 at 10:48 pm
  • If anyone has a moment, could they review the PostgreSQL driver I wrote for Joomla's next major release? The developers at Joomla have listened to the persistent noise created about only having MySQL ...
    Thom BrownThom Brown
    Oct 20, 2009 at 12:03 pm
    Oct 21, 2009 at 9:18 am
  • I want to have the server do this: If the query has no where clause, use a where clause of "where 1=0". Is this possible? Why would I want to do this? Because a third party library (ArcGIS) has a ...
    Phil CairnsPhil Cairns
    Oct 30, 2009 at 8:20 pm
    Nov 2, 2009 at 7:53 pm
  • On my primary DB I'm observing random slowness which just doesn't make sense to me. The I/O system can easily do 40MB/sec writes, but I'm only seeing a sustained 5MB/sec, even as the application is ...
    Vivek KheraVivek Khera
    Oct 29, 2009 at 6:46 pm
    Oct 30, 2009 at 2:30 pm
  • If I have a table with fields A, B, C and D how could I do something such that if I insert values in fields A, B and C field D would be auto-filled with the value A||B||C? Just a pointer of where to ...
    Semi-ambivalentSemi-ambivalent
    Oct 22, 2009 at 2:26 am
    Oct 25, 2009 at 1:20 pm
  • I've followed this list for quite a long time, and I think that I've discovered a pattern that I would like to discuss. It seems like there are two camps considering EAV models. On the one hand, ...
    Leif B. KristensenLeif B. Kristensen
    Oct 23, 2009 at 9:53 pm
    Oct 24, 2009 at 4:39 pm
  • I'm using 8.2.4 Numeric with scale precision always shows the trailing zeros. Numeric plain only shows numbers after the decimal point that are being used. I would like to have the data in my table ...
    Sim ZacksSim Zacks
    Oct 19, 2009 at 4:04 pm
    Oct 22, 2009 at 1:05 am
  • Hi, Is it better to create multi databases or create multi schemas? I am writing a program that can have multi instances. Sort like a finanical accounting system that can have multiable companies. ...
    JohnJohn
    Oct 20, 2009 at 1:50 pm
    Oct 21, 2009 at 4:43 pm
  • The video archive for the 10/13 SFPUG meeting, "The Mighty GUCS: A guide to the essential PostgreSQL settings you need to know," is now available: http://thebuild.com/blog/2009/10/16/the-mighty-gucs/ ...
    Christophe PettusChristophe Pettus
    Oct 17, 2009 at 6:55 am
    Oct 20, 2009 at 4:43 pm
  • I've noticed that if I just log in to my server, I don't su to root, or become the postgres user, I can get straight into the database as the postgres user merely with "psql -U postgres -h ...
    Thom BrownThom Brown
    Oct 15, 2009 at 10:38 am
    Oct 15, 2009 at 2:32 pm
  • I am porting some code from Perl to Python; in the Perl original I use either DBI::do or a rickety home-built module to pass multiple SQL statements (as one single block of SQL) to the Pg server. The ...
    Kynn JonesKynn Jones
    Oct 10, 2009 at 7:09 pm
    Oct 11, 2009 at 10:45 pm
  • Hi, in my database I store RTF files inside a Bytea field. Now a customer is requesting a search inside RTF fields and I'm trying to implement it by issuing this query: select * from my_table where ...
    "Leonardo M." Ramé"Leonardo M." Ramé
    Oct 8, 2009 at 2:29 pm
    Oct 8, 2009 at 9:09 pm
  • Hello, After a series of sessions to search the web for information, I am asking the help of people having a bit more knowledge of the internals of pg_dump to try to solve a performance problem I ...
    Loic d'AnterrochesLoic d'Anterroches
    Oct 7, 2009 at 10:51 am
    Oct 7, 2009 at 5:52 pm
  • ZsoltZsolt
    Oct 7, 2009 at 7:26 pm
    Aug 16, 2011 at 8:56 am
  • Hello all, I am trying to write a function that takes one source and one target data type identifiers, each as a '/text/' variable, as arguments and return true if the cast can be made, false ...
    Kareem SedkiKareem Sedki
    Oct 23, 2009 at 8:39 am
    Oct 23, 2009 at 8:58 pm
  • Hi, I am trying to code Postgres external C function in windows XP and am using Postgres 8.3 version. However I have included all the required things in the code to run (Please find below the example ...
    A BhattacharyaA Bhattacharya
    Oct 22, 2009 at 5:31 am
    Oct 23, 2009 at 4:45 pm
  • Sorry guys, I know this is very off-track for this list, but google hasn't been of much help. This is my raid array on which my PG data resides. I have a 4 disk Raid10 array running on linux MD raid. ...
    Ow Mun HengOw Mun Heng
    Oct 20, 2009 at 7:25 am
    Oct 21, 2009 at 9:16 am
  • Hi We have an Postgresql 8.2.5 installation on a Windows server 2003 that have worked perfectly for our Mediawiki until we tried to update to 8.4. Before the update we took a backup, stopped the ...
    AndaleAndale
    Oct 14, 2009 at 1:42 pm
    Oct 20, 2009 at 11:23 am
  • Hello, Could somebody please try to help me with this problem? So, let’s say that I have the query: CREATE SEQUENCE c START 1; SELECT a, nextval('c') as b FROM table1 ORDER BY a DESC LIMIT 5; I.e., I ...
    JosipJosip
    Oct 14, 2009 at 5:07 pm
    Oct 20, 2009 at 1:40 am
  • Does PostgreSQL support nested transactions as shown below? BEGIN; ...do some stuff... BEGIN; ...more stuff... COMMIT; COMMIT; Bill
    Bill ToddBill Todd
    Oct 12, 2009 at 2:42 am
    Oct 13, 2009 at 5:11 am
  • Hi, I have a plpgsql function called irq(IN ulist integer[], .....) It works fine on 8.1 Linux On 8.4 on windows XP running the function gives an error message (Undefined column: 7 ERROR: record ...
    SunWuKungSunWuKung
    Oct 11, 2009 at 9:20 pm
    Oct 12, 2009 at 3:08 pm
  • By setting postgres.conf params...log files are generated of 16 MB each. How can I reduce the size of this files? & can I force the log files to switch with any command as we do in mysql like flush ...
    Mitesh51Mitesh51
    Oct 8, 2009 at 8:57 am
    Oct 9, 2009 at 3:41 pm
  • I just did an upgrade on two of my servers (the main and the failover). The main went OK but the postgres on the failover won't start. Unfortunately there is nothing anywhere telling me what the ...
    Tim UckunTim Uckun
    Oct 5, 2009 at 5:00 am
    Oct 6, 2009 at 10:14 pm
  • Hi, As postgres now has enum type, does npgsql driver support the enum type? I use c# and npgsql as databse driver. One of the database stored procedure takes enum as its parameter. What will be the ...
    DanclemsonDanclemson
    Oct 15, 2009 at 4:32 pm
    Nov 6, 2009 at 7:13 pm
  • i want to create a type for an email field but i'm not good with regx can some one help me?
    XaiXai
    Oct 28, 2009 at 12:58 pm
    Nov 1, 2009 at 10:26 am
  • Hi, I've to generate unique password and associate them with emails. Association with emails is just to mail the password, email + password aren't "the password", just the password is. So a bunch of ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Oct 27, 2009 at 9:06 am
    Oct 28, 2009 at 3:49 pm
  • Hey all, I have the following table: data(pnum text, distance float8, route text). I would like to remove the outliers in distance, i.e. lets say i get the avg dist of pnum for each route and the std ...
    Rhys A.D. StewartRhys A.D. Stewart
    Oct 27, 2009 at 9:36 pm
    Oct 28, 2009 at 12:34 pm
  • Hello ! I'm trying to write a little trigger function with variable arguments quantity (at least one, but can be 2,3,4 arguments). Theses arguments are fields name, so only varchar variable. Since it ...
    Bruno BaguetteBruno Baguette
    Oct 24, 2009 at 4:24 am
    Oct 26, 2009 at 2:40 am
Group Navigation
period‹ prev | Oct 2009 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions242
posts1,233
users287
websitepostgresql.org
irc#postgresql

287 users for October 2009

Tom Lane: 101 posts Alvaro Herrera: 56 posts Sam Mason: 45 posts Scott Marlowe: 41 posts Thom Brown: 41 posts Merlin Moncure: 30 posts Greg Smith: 25 posts Craig Ringer: 24 posts Christophe Pettus: 23 posts Raymond O'Donnell: 21 posts Adrian Klaver: 18 posts Pavel Stehule: 17 posts David Fetter: 15 posts Grzegorz Jaśkiewicz: 15 posts Richard Huxton: 15 posts Tim Landscheidt: 15 posts Gerhard Wiesinger: 13 posts John R Pierce: 13 posts Alban Hertroys: 12 posts Joshua D. Drake: 12 posts
show more
Archives