FAQ

Search Discussions

317 discussions - 1,354 posts

  • Hello All, We have a project which is built on postgresql and freeradius on debian system. I have installed postgresql-8.1 on the Debian system, and lately freeradius-1.1.0 also. Things seems ok, but ...
    LmyhoLmyho
    Apr 6, 2006 at 5:27 pm
    Apr 22, 2006 at 6:03 pm
  • Hello all, I'm working on a CMS which requires an open source database capable of handling hundreds of thousands of users simultaneously, with a high rate of database writes, and without buckling. ...
    Tony LausinTony Lausin
    Apr 30, 2006 at 11:01 am
    May 4, 2006 at 10:13 pm
  • Hello all, I created two web database applications - first one is the company news system (as part of the company web pages), second one is the company main data system (part of the company pages, ...
    IvoDIvoD
    Apr 24, 2006 at 8:21 am
    Apr 27, 2006 at 9:08 am
  • Hi, i don't know much about hard disks and raid controllers but often there is some discussion about which raid controller rocks and which sucks. my hosting company offers me a raid 10 with 4 ...
    Janning VygenJanning Vygen
    Apr 12, 2006 at 3:46 pm
    Apr 16, 2006 at 2:38 am
  • Hi all, Short background: postgres does not support very well queue type tables in an environment where these queue tables are small in size but heavily inserted/updated/deleted, while there are ...
    Csaba NagyCsaba Nagy
    Apr 28, 2006 at 12:40 pm
    May 4, 2006 at 8:42 pm
  • It seems that all the postgresql mailing lists don't allow you to automatically reply to the list only the sender. I don't get this with all my other mailings list. Who I contact to have this ...
    Chris VelevitchChris Velevitch
    Apr 27, 2006 at 6:52 am
    Apr 27, 2006 at 3:00 pm
  • I was trying to dump all my databases: su - postgres /usr/local/bin/pg_dumpall /Volumes/Space/postgresql_060425.dump I get: " does not exist database "foodmartto database "foodmart ", exiting: ...
    Ari KahnAri Kahn
    Apr 25, 2006 at 7:14 am
    Apr 25, 2006 at 3:59 pm
  • i have heard somewhere that writing a stored procedure, is much better than firing a sql query(such as select * from table_name) onto the database. is it true and if yes how? also i want to know that ...
    Surabhi.ahujaSurabhi.ahuja
    Apr 6, 2006 at 4:08 am
    Apr 11, 2006 at 6:48 am
  • I want to execute a command line from trigger function. The reason is I want to execute my perl script from stored procedure. any idea? Yudie
    Yudie PgYudie Pg
    Apr 6, 2006 at 7:48 pm
    Apr 7, 2006 at 8:06 pm
  • hi all, 1) do backup always... on cd, tape, raid. my hd just burn. there is hope for me, in lost+found there is a directory called base with multiples sub-direcotry (403274 for example). is this my ...
    PatrickPatrick
    Apr 4, 2006 at 8:19 am
    Apr 5, 2006 at 1:10 pm
  • Hello, I have written a crontab-like daemon which accepts jobs from users through a table and executes SQL statements after certain events or intervals. This daemon maintains a persistent connection ...
    A.M.A.M.
    Apr 20, 2006 at 8:06 pm
    Apr 23, 2006 at 7:12 pm
  • Hello All I have only recently started to use Postgresql and have a problem. I am using v8.1 on windows. I cannot seem to get the DB to accept either INT or INTEGER as a type when using the admin ...
    Zahir LalaniZahir Lalani
    Apr 13, 2006 at 1:27 pm
    Apr 17, 2006 at 8:19 pm
  • hi. basic information: machine: desktop computer, with sata hard drive, no bad blocks. 2g ram.AMDSempron(tm) Processor 2600+ system: linux debian testing, using 2.6.11 kernel. postgresql: 8.1.3 ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Apr 13, 2006 at 9:35 am
    Apr 14, 2006 at 6:38 pm
  • hi, is it possible for postmaster to go doen on its own? all what the logs say is FATAL: terminating connection dur to administrator's command. thanks, regards Surabhi
    Surabhi.ahujaSurabhi.ahuja
    Apr 7, 2006 at 12:16 pm
    Apr 10, 2006 at 7:08 am
  • I'd like to be able to connect to postgres, and automatically assume a specific role. I imagine something like create role myuser ; create role dev noinherit ; create role admin noinherit superuser ; ...
    Florian G. PflugFlorian G. Pflug
    Apr 22, 2006 at 6:24 pm
    Apr 26, 2006 at 10:24 am
  • Hello, I have about 100 000 records, which need about 30 minutes to write them with single INSERTs into PostgreSQL. If I go through these 100 000 records and make an UPDATE on each record, it takes 1 ...
    MGMG
    Apr 11, 2006 at 9:08 am
    Apr 12, 2006 at 9:52 pm
  • Hi. Is there any way (or working solution) to extend PostgreSQL to accept Oracles outer join syntax with '(+)'? Any pointers to docs on how to do this myself are also appreciated. -- Until the next ...
    Stefan NobisStefan Nobis
    Apr 5, 2006 at 12:47 pm
    Apr 5, 2006 at 9:19 pm
  • Hello, I'm designing a database and I'm having some problems, so I ask you a suggestion. 1) The database I'm going to develop is a big list with a catalog of items and I want to store subsets of this ...
    Ottavio CampanaOttavio Campana
    Apr 3, 2006 at 2:36 pm
    Apr 5, 2006 at 7:33 am
  • Is there a reason many of the most useful autovacuum.c elog statements are set to DEBUG2? It seems to me that these should be set to LOG. I used autovacuum when it was a contrib module, and it failed ...
    Will ReeseWill Reese
    Apr 27, 2006 at 3:47 am
    Apr 28, 2006 at 7:56 pm
  • I have table of reports CREATE TABLE report ( ReportName CHAR(5) not null check (reportname< ''), < a lot of other fields , id serial primary key ) I want to duplicate report so that id order is ...
    AndrusAndrus
    Apr 26, 2006 at 6:56 pm
    Apr 27, 2006 at 2:58 am
  • Is it possible to have a superuser who could do CHECKPOINT, BACKUP and whatever but could not see any user data? Regards, Qingqing
    Qingqing ZhouQingqing Zhou
    Apr 24, 2006 at 5:27 pm
    Apr 25, 2006 at 12:29 pm
  • Yesterday ltree was mentioned to be a good system for tree structured table data. I and a colleague of mine have been playing around with the examples and the (rather sparse) documentation, but we're ...
    Alban HertroysAlban Hertroys
    Apr 21, 2006 at 1:37 pm
    Apr 24, 2006 at 5:38 pm
  • Hi Newsgroup, I need a query which can check for the existence of a certain stored procedure. (The pendant for MS SQL is IF EXISTS (SELECT * FROM "sysobjects" WHERE "id" = ...
    Alexander ScholzAlexander Scholz
    Apr 18, 2006 at 6:26 am
    Apr 21, 2006 at 11:49 am
  • Hi - I have two tables, one of them has names of people and an associated integer ID. The other table is a list of the people (from the first table) by their ID number that have signed up for a ...
    Jim FitzgeraldJim Fitzgerald
    Apr 30, 2006 at 6:32 pm
    May 2, 2006 at 2:14 pm
  • Hi list I have a table construction like the one seen below, when i am updating or inserting i get a recurion, logical. But how to manage it that the rule is just doing it one time. Or is it possible ...
    BertBert
    Apr 25, 2006 at 9:27 pm
    Apr 27, 2006 at 11:05 am
  • Right now Sequence by default uses bigint which supports upto 19bit numbers but I want to use a 21bit that can be supported by NUMERIC datatype. Is there any way I can sepcify while creating a ...
    Shoaib MirShoaib Mir
    Apr 15, 2006 at 5:25 am
    Apr 18, 2006 at 11:32 am
  • I have a simple benchmark which runs too slow on a 100M row table, and I am not sure what my next step is to make it faster. It's a simple setup, part of a larger system. There are three data tables, ...
    FelixFelix
    Apr 10, 2006 at 6:24 am
    Apr 15, 2006 at 4:22 pm
  • Hi Listers, I have the following problem (OS= RHELU2 , PG version= 8.1.3) when I try to Create a database : postgres=# CREATE DATABASE world3 TEMPLATE=template1 ENCODING='UTF8' TABLESPACE=tbs1 ; ...
    Milen KulevMilen Kulev
    Apr 9, 2006 at 10:51 am
    Apr 11, 2006 at 4:53 pm
  • Hi, I'm working with postgres and I have a question regarding a self-join on my table (se below for table definition and testdata): I want to retrieve all depths that have either a measuretype=1040 ...
    Jonas F. HenriksenJonas F. Henriksen
    Apr 5, 2006 at 2:39 pm
    Sep 24, 2007 at 1:15 pm
  • Hello, everybody! How can I view deleted records in table? -- Verba volent, scripta manent Dan Black
    Dan BlackDan Black
    Apr 29, 2006 at 7:49 pm
    May 4, 2006 at 9:30 pm
  • Hi, I have a set of functions for a data type that return small integers (i.e. [0..12]). I can, of course, represent it as a char, short or long (CHAR, INT16 or INT32). re there any ...
    Don YDon Y
    Apr 30, 2006 at 11:42 pm
    May 2, 2006 at 6:09 pm
  • I'm using 7.4.5 on win XP Pro SP1. I'm getting:- ERROR: syntax error at or near "(" at character 155 from the query:- select dummy_records.sequence_nr,timesheets.weekending,timesheets.timesheet_id ...
    Chris VelevitchChris Velevitch
    Apr 26, 2006 at 6:25 am
    Apr 27, 2006 at 4:07 pm
  • Hello all, I wanted to verify what we are seeing. Select a, aggregate(b) from c group by a order by a,b Is not accepted by postgres. This will only work if you order by a. But, this means that the ...
    Chris KratzChris Kratz
    Apr 26, 2006 at 1:46 pm
    Apr 26, 2006 at 4:11 pm
  • Hello All, We are getting very strange problem .. Scenario.. ******************************************************** We Have one data field in some table..type of this field Is *TEXT*. We are ...
    Mavinakuli, Prasanna (STSD)Mavinakuli, Prasanna (STSD)
    Apr 14, 2006 at 4:08 am
    Apr 22, 2006 at 10:39 am
  • Hi, i have run into the following problem. Let me describe the context first. When i joined the company(ies) i work for (a group of Shipping Mgmt/ Owenship/Agent companies), the only thing i was told ...
    Achilleus MantziosAchilleus Mantzios
    Apr 18, 2006 at 9:36 am
    Apr 19, 2006 at 6:55 am
  • Hi All, I am having the clipid field in my table.In my application i am taking Max(clipid) and inserting it into the table by incrementing that max value. so there is a problem when 2 users click ...
    V SuryaprabhaV Suryaprabha
    Apr 10, 2006 at 12:03 pm
    Apr 11, 2006 at 9:23 pm
  • I hate ILIKE. it's abnormal, as there is no way to forget it and use standard things (I can hardly wait collation support). So, every time I type 'ILIKE' I think: I DON'T LIKE ILIKE. In other words, ...
    Nikolay SamokhvalovNikolay Samokhvalov
    Apr 1, 2006 at 12:28 pm
    Apr 2, 2006 at 10:57 am
  • Help! I was trying to make an installation of PHP 5.1.2 + Apache 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I got PHP to work with Apache quite smoothly, so did I marry PHP with ...
    KrzysieqKrzysieq
    Apr 26, 2006 at 7:50 pm
    Jun 5, 2006 at 8:04 pm
  • What resource do I need to increase to avoid the error above? Trying to do a straight select against a table with 6 million records. So far tried increasing SHMMAX to 512MB
    Francisco ReyesFrancisco Reyes
    Apr 22, 2006 at 6:41 pm
    May 3, 2006 at 7:13 pm
  • I want to create portable code which runs in other dbms without modification. Unfortunately this other dbms uses + for string concatenation and has no way to define operators. How to define + ...
    AndrusAndrus
    Apr 28, 2006 at 10:08 am
    May 1, 2006 at 4:28 pm
  • It is a possible?
    Stanislaw TristanStanislaw Tristan
    Apr 27, 2006 at 12:34 am
    Apr 28, 2006 at 5:03 pm
  • Hi, I have a client who has a 25 million row table that is used to keep track of financial security info. So far it has worked great, but today someone wanted to get all the tax codes(there are lot's ...
    Tony CadutoTony Caduto
    Apr 25, 2006 at 8:10 pm
    Apr 28, 2006 at 7:51 am
  • hello guys, what do u think about the near future of postgre? what is the latest version of postgre? and how it differ from the oldone? who is the leading person on postgre?
    Karthick muthuKarthick muthu
    Apr 24, 2006 at 7:17 am
    Apr 25, 2006 at 5:31 am
  • I want to replace ( delete and insert) records in master table . I delete and insert record with same primary key. I want that foreign key records are not deleted. I tried begin; create temp table t1 ...
    AndrusAndrus
    Apr 20, 2006 at 2:57 pm
    Apr 21, 2006 at 2:41 pm
  • I just added a new table to a slony relication set. The new table seems to have a really high tab_reloid value of 94,198,669 I'm using Slon 1.1.5 with pg 7.4.6 and 7.4.11 on unix On the master I see ...
    John Sidney-WoollettJohn Sidney-Woollett
    Apr 13, 2006 at 9:07 am
    Apr 17, 2006 at 4:01 pm
  • I'm stumped on this one... I have a table defined thusly: create table items ( id serial, category integer not null references category(id), name varchar not null, price real, unique(category, ...
    Benjamin SmithBenjamin Smith
    Apr 13, 2006 at 1:44 am
    Apr 17, 2006 at 10:58 am
  • Hi, Does the ilike operator work fine with cyrillic text put in a UTF-8 encoded database? I've had remarks of a user (of http://myowndb.com, a web database) with text in cyrillic that his searches ...
    Raphael BauduinRaphael Bauduin
    Apr 14, 2006 at 1:16 pm
    Apr 14, 2006 at 5:16 pm
  • Hello, I am trying to import an Excel file in my database (8.0.7). I think I am supposed to create an CSV file out of my Excel file and somehow, feed the database with it. My pronblem is that I don't ...
    Daniel TourdeDaniel Tourde
    Apr 11, 2006 at 8:10 am
    Apr 13, 2006 at 12:14 am
  • Hello everyone: I have a systems admin that is backing up our Linux computers (postgres) by backing up the directory structure. This of course includes all the files that pertain to my postgres ...
    Bob PowellBob Powell
    Apr 5, 2006 at 7:43 pm
    Apr 6, 2006 at 10:24 pm
  • Remote install of Postgres 8.1.3 using Windows installer binary package is not working (says that console mode is required) even when RDP client is started with mstsc /console switch. However, using ...
    AndrusAndrus
    Apr 4, 2006 at 9:07 pm
    Apr 6, 2006 at 1:40 pm
Group Navigation
period‹ prev | Apr 2006 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions317
posts1,354
users352
websitepostgresql.org
irc#postgresql

352 users for April 2006

Tom Lane: 136 posts Martijn van Oosterhout: 55 posts Jim Nasby: 35 posts Scott Marlowe: 24 posts Alban Hertroys: 23 posts Richard Huxton: 23 posts Andrus: 21 posts Chris smith: 21 posts Dave Page: 17 posts Surabhi.ahuja: 17 posts Andreas Kretschmer: 16 posts Florian G. Pflug: 16 posts Terry Lee Tucker: 15 posts Douglas McNaught: 13 posts Bruno Wolff III: 12 posts Chris Velevitch: 12 posts Merlin Moncure: 12 posts Teodor Sigaev: 12 posts Tyler MacDonald: 12 posts Brendan Duddridge: 11 posts
show more
Archives