Search Discussions

288 discussions - 1,656 posts

  • Hello All, I prepared patch for renaming postgreSQL script tools like createdb, createuser, etc. to pg_createdb, pg_creteuser. Original names will be kept for 2 or 3 following versions. The main ...
    Zdeněk KotalaZdeněk Kotala
    Mar 26, 2008 at 2:25 pm
    Apr 1, 2008 at 3:38 am
  • Hi, I am a database professional but have never used Postgre. My client was exploring the posiblity of using Postgre instead of Mysql and wnated to know the comments from the community. I waned you ...
    Mar 11, 2008 at 1:48 pm
    Mar 17, 2008 at 4:10 pm
  • is the query I am running , and it takes over 10 seconds to complete this query... update users set number_recieved=number_recieved+1 where uid=738889333; table has about 1.7 million rows.. i have an ...
    Mar 31, 2008 at 7:16 pm
    Apr 5, 2008 at 9:39 am
  • I work at a fairly large company 2000 people just at my site alone. I've been given access to a new database which will be used for source data for some software that the company just purchased. Now ...
    Pettis, BarryPettis, Barry
    Mar 27, 2008 at 12:02 am
    Apr 1, 2008 at 8:25 pm
  • Lewis, all you have to do is this: Log in to blogger. Select Settings Select Site Feed Change Allow Blog Feeds to short Problem solved. You owe me a beer. I didn't have a blogger account until this ...
    Joshua D. DrakeJoshua D. Drake
    Mar 8, 2008 at 2:48 am
    Mar 10, 2008 at 9:17 am
  • I'm getting the back end closing connections early for some reason. Here is an exception report from my servlet. This first started happening with my instance of Trac, but now it's happening to my ...
    Alex TurnerAlex Turner
    Mar 6, 2008 at 8:50 pm
    Mar 8, 2008 at 9:21 pm
  • Hi! I want to set up a trigger (somehow) that, whenever someone connects database my_db, will fire and thereby run a stored PLPERL procedure perl_setup() in the new connection's environment. (BTW, ...
    Kynn JonesKynn Jones
    Mar 10, 2008 at 8:07 pm
    Mar 16, 2008 at 9:13 pm
  • It is close, but has limitations that will be problematic for our environment, such as: Replicator will not replicate the schema. You must restore your schema to th e slaves from the master before ...
    Keaton AdamsKeaton Adams
    Mar 25, 2008 at 8:31 pm
    Mar 31, 2008 at 7:45 pm
  • The table I have in MySQL is similar to below: 0 SET FOREIGN_KEY_CHECKS=0; 1 CREATE TABLE products ( 2 product_id integer(11) not null auto_increment, 3 product_name varchar(255) not null, 4 ...
    Edward BlakeEdward Blake
    Mar 21, 2008 at 4:06 pm
    Mar 23, 2008 at 2:32 am
  • I have a table with about 15 million rows which is constantly having tuples added to the head and deleted in blocks from the tail to maintain the size. The dead tuple count in pg_stat_user_tables ...
    Stuart BrooksStuart Brooks
    Mar 31, 2008 at 9:26 am
    Apr 7, 2008 at 8:11 am
  • This is 8.2.6 in Fedora 8 and the same database with which there were performance problems when migrating to 8.3. The migration was not done. The thread was this: ...
    Mar 13, 2008 at 1:12 pm
    Mar 26, 2008 at 2:15 pm
  • Hi, I am trying to set up a PostGreSQL database to send asynchronous notifications when certain inserts or updates are performed on the tables. The idea is I want to have publish / subscirbe model ...
    Tyler, MarkTyler, Mark
    Mar 17, 2008 at 10:19 pm
    Mar 20, 2008 at 1:43 pm
  • Hello List, I am running 8.3.1 on FreeBSD 6.2 patch-7. The ports for Freebsd turn on --enable-thread-safety during configure of pg. When running my app after some time I have been getting a core dump ...
    Steve ClarkSteve Clark
    Mar 21, 2008 at 8:10 pm
    Mar 23, 2008 at 5:30 pm
  • Dear Sirs, it is possible to connect to PostgreSQL server from a client with a dynamic IP (or from an unknown IP)? How I have to configure pg_hba.conf (and/or eventually my router, where the server ...
    Mar 3, 2008 at 10:06 am
    Mar 4, 2008 at 3:21 am
  • The help is not real clear nor can i find examples how to write an aggregate function. I searched the archive of the mail list and did not find anything I need to write Weighted Average function so ...
    Mar 4, 2008 at 4:48 pm
    Mar 11, 2008 at 2:16 pm
  • Hi! My database cluster has just stopped working. I get the following message: psql: FATAL: Datenbank nimmt keine Befehle an, um Datenverlust in Datenbank »postgres« wegen Transaktionsnummernüberlauf ...
    Markus WollnyMarkus Wollny
    Mar 21, 2008 at 9:08 pm
    Mar 8, 2010 at 8:36 am
  • Hello, is there a Way to install PostgreSQL ( 8.3.1 ) on a Win2000 Maschine without Admin Rights? Thanks for your Help, Stefan Sturm
    Stefan SturmStefan Sturm
    Mar 25, 2008 at 6:25 am
    Mar 26, 2008 at 12:05 pm
  • I was wondering if anyone knows of any good ER Diagram tools for Postgres that run on Linux. I have been using DBDesigner by FabForce for a couple of years, but development has stopped while MySQL ...
    Conor McTernanConor McTernan
    Mar 6, 2008 at 3:33 am
    Mar 9, 2008 at 4:08 pm
  • Hi all, I am trying to backup a large table with about 6 million rows. I want to export the data from the table and be able to import it into another table on a different database server (from pgsql ...
    Mar 28, 2008 at 6:05 am
    Mar 28, 2008 at 3:59 pm
  • Was there something wrong with the tzdata distributed in 8.2.7? current_timestamp is still using EST, but the date command run from the command line is correctly returning EDT [local]:owl=# select ...
    Joseph SJoseph S
    Mar 25, 2008 at 8:51 pm
    Mar 27, 2008 at 4:28 pm
  • I have some users that need "select any table" but they should not be superusers. How can this be done? I need a "grant select on <dbname to <rolename ". Jon
    Roberts, JonRoberts, Jon
    Mar 25, 2008 at 2:54 pm
    Mar 26, 2008 at 12:56 pm
  • Ugh. I am attempting to move from 8.2.6 to 8.3, and have run into a major problem. The build goes fine, the install goes fine, the pg_dumpall goes fine. However, the reload does not. I do the initdb ...
    Karl DenningerKarl Denninger
    Mar 2, 2008 at 8:10 pm
    Mar 3, 2008 at 2:26 pm
  • Hi, I'm running into a problem importing some MS Access tables into PostgreSQL using mdbtools. The schema is exported effectively with mdb-schema, but several tables have boolean columns. To deal ...
    Mar 26, 2008 at 9:58 pm
    Mar 27, 2008 at 2:26 pm
  • Hi! When it comes to programming SQL, my newbie approach is to write my code in a file test.sql, which I test from within psql by using my_db= \i /some/path/test.sql ...and (once I'm satisfied with ...
    Kynn JonesKynn Jones
    Mar 10, 2008 at 3:50 pm
    Mar 21, 2008 at 1:20 am
  • Is there a method available for triggering a function after an update on a particular column in a table? The only way that I have found is to trigger after an update on the whole table, which of ...
    Bob PawleyBob Pawley
    Mar 16, 2008 at 10:36 pm
    Mar 18, 2008 at 12:33 am
  • Hi all, I think the title says everything:-) I just what a way to create a TEMP for the current transaction only. If possible I don't want to create the TEMP table first, specify all column types, ...
    David GagnonDavid Gagnon
    Mar 13, 2008 at 12:02 pm
    Mar 13, 2008 at 11:10 pm
  • Hello all, It was running fine initially and the database was lying idle for a few days. Today I looged into the machine and restarted the server by killing the process by 'kill -9 pid'. And then ...
    Kakoli SenKakoli Sen
    Mar 12, 2008 at 5:25 am
    Mar 13, 2008 at 12:35 pm
  • I have a postgres server for which du reports 1188072 /var/lib/postgresql/8.2/main on Linux system. The server has only one real database, which is for bacula. When I dump the database, it's 73Mg. ...
    Ross BoylanRoss Boylan
    Mar 30, 2008 at 5:31 pm
    Apr 5, 2008 at 3:43 pm
  • Suppose I have a database with $PGDATA on /dev/sda, and a tablespace directory on /dev/sdb. Will Postgres start successfully if /dev/sda is mounted and /dev/sdb is not? If not, why not? Morris
    Morris GoldsteinMorris Goldstein
    Mar 31, 2008 at 5:55 pm
    Apr 2, 2008 at 7:36 pm
  • Hi, i have a problem solving my function trouble. this function should return an email address stored in a table (tmp_newsletterreg) based on a number (sessions ID). if the session id is not find it ...
    Alain RogerAlain Roger
    Mar 27, 2008 at 7:43 pm
    Mar 29, 2008 at 5:39 pm
  • According to Slashdot IBM is investing in EnterpriseDB. What does it mean for Postgresql? Regards, Clodoaldo Pinto Neto
    Mar 26, 2008 at 2:19 pm
    Mar 27, 2008 at 1:13 am
  • guys, how many min. floating-points must a server hardware support for postgresql+postgis? does postgresql+postgis do much floating-point math to make a difference? can someone give ...
    John SmithJohn Smith
    Mar 20, 2008 at 7:19 pm
    Mar 21, 2008 at 9:26 pm
  • hi, i have an issue with tseach2, i just installed postgresql 8.3.1 on windows using UTF8 server encoding / client encoding and LOCALE Canada / French. CREATE DATABASE mydbWITH OWNER = me ENCODING = ...
    Mar 19, 2008 at 5:08 am
    Mar 20, 2008 at 2:40 pm
  • Hello, I'm currently camping with a bit of a problem -- i have a common requests table, and based on an entry's type, I need to join a specific other table. Consider this database layout: ...
    Leon MergenLeon Mergen
    Mar 18, 2008 at 7:13 pm
    Mar 19, 2008 at 9:24 pm
  • Hi I use postgres v 8.3 on a dual quad core, intel xeon e5405@2.00GHz, fedora core 8 x86_64, and 32GB RAM settings i changed on postgresql.conf: shared_buffers = 1000MB # min 128kB or ...
    Mar 15, 2008 at 11:21 pm
    Mar 16, 2008 at 5:16 pm
  • Hi, I am trying to configure Full Text Search on PostgreSQL 8.3 but I seem to be missing pg_catalog.english as I get the follow when I try and do this: ALTER TABLE useraccounts_contact ADD COLUMN ...
    Tim ChildTim Child
    Mar 11, 2008 at 5:04 pm
    Mar 12, 2008 at 6:41 pm
  • hi, i would like to know how can i control the returned value from a SQL statement ? for example, if i do an INSERT INTO... : 1. how can i know if the INSERT worked ? i mean i already trapped the ...
    Alain RogerAlain Roger
    Mar 27, 2008 at 9:30 am
    Mar 27, 2008 at 2:06 pm
  • Hi All, Does anyone know where I can download rmpbuild for RHEL 3? I tried to install postgresql-8.2.6-1PGDG.f8.src.rpm. I got error rpmbuild: command not found. rpmbuild --rebuild --define ...
    Tri QuachTri Quach
    Mar 20, 2008 at 2:12 am
    Mar 20, 2008 at 3:10 am
  • V8.2.0 on Linux Can't rename a db, complains that it doesn't exist. Yet psql -l shows that it does and I can connect to it ??? mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to ...
    Gauthier, DaveGauthier, Dave
    Mar 12, 2008 at 5:03 pm
    Mar 14, 2008 at 6:17 pm
  • Hello, I'm trying to perform some benchmarks using pgbench. I'm using the following rpm package: postgresql-contrib-8.3.0-2PGDG.rhel5 for x86_64, downloaded from the pgsql yum repository for ...
    Enrico SirolaEnrico Sirola
    Mar 14, 2008 at 9:04 am
    Mar 14, 2008 at 5:46 pm
  • Hi: Trying (and failing) to attach to my DBs. Getting... database "foo_standby" has disappeared form pg_database DETAIL: Database OID 2323523 now seems to belong to "foo" I have 2 dbs... foo and ...
    Gauthier, DaveGauthier, Dave
    Mar 11, 2008 at 1:45 pm
    Mar 11, 2008 at 5:14 pm
  • HELLO i have psql file which is to be used for loading a database it was downloaded from this link http://conceptnet.media.mit.edu/ the description says The ConceptNet 3 database, as a PostgreSQL ...
    Akshay bhatAkshay bhat
    Mar 8, 2008 at 7:46 pm
    Mar 10, 2008 at 12:34 pm
  • Hello, The project MyJSQLView will provided basic support for array types in PostgreSQL at the next release. Information is desired from anyone that uses arrays in PostgreSQL to effect this support. ...
    Mar 3, 2008 at 5:48 pm
    Mar 4, 2008 at 2:13 am
  • This is not a flame about current or previous release of Postgres. I have just gone through the awful experience of upgrading from Postgres 8.2 to 8.3 with a database that had one of the many ...
    David PottsDavid Potts
    Mar 12, 2008 at 3:03 pm
    Apr 9, 2008 at 11:03 pm
  • I have a client that experienced several Out Of Memory errors a few weeks ago (March 10 & 11), and I'd like to figure out the cause. In the logs it's showing that they were getting out of memory ...
    Alex AdriaanseAlex Adriaanse
    Mar 28, 2008 at 7:04 pm
    Apr 4, 2008 at 9:48 pm
  • Hi all, I was trying to find some way to implement multithreading into my postgreSQL stored functions. The thing is, that I have data stored in multiple tables - for each day one table - and I want ...
    Mar 30, 2008 at 3:13 pm
    Apr 2, 2008 at 9:20 am
  • We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN switch out while it was under load), which caused the DB to crash. It started up fine, when I vacuumed the DB, I saw the ...
    Brad NicholsonBrad Nicholson
    Mar 26, 2008 at 7:18 pm
    Mar 30, 2008 at 9:46 am
  • Hello, I have a scenario with two tables, one with 5M rows and the other with about 3.7M (a subset taken from the first table). Each is clustered using its primary key (a single bigint column), and ...
    Chris MayfieldChris Mayfield
    Mar 27, 2008 at 8:23 pm
    Mar 29, 2008 at 4:28 pm
  • Hi, i'm learning how to work with rows (rowtype) , but I cannot find a way to insert one, once i filled up the fields, in a table. the thing is: I have some rows filled up with execute commands as ...
    Josep porresJosep porres
    Mar 26, 2008 at 11:59 am
    Mar 26, 2008 at 2:11 pm
  • Hello, I want to sort strings containing a dot but by taking care of this dot like any other character. example : Currently, I get this after the sort : co.aaa co.abb co.cab com co.ment com.enta But ...
    Pierre LEBRECHPierre LEBRECH
    Mar 25, 2008 at 3:29 pm
    Mar 25, 2008 at 6:09 pm
Group Navigation
period‹ prev | Mar 2008 | next ›
Group Overview
grouppgsql-general @

359 users for March 2008

Tom Lane: 138 posts Joshua D. Drake: 42 posts Richard Huxton: 41 posts Craig Ringer: 35 posts Scott Marlowe: 35 posts Alvaro Herrera: 34 posts Erik Jones: 30 posts Bruce Momjian: 23 posts Greg Smith: 22 posts Ivan Sergio Borgonovo: 21 posts Martijn van Oosterhout: 21 posts Sam Mason: 21 posts Albe Laurenz: 20 posts Justin: 20 posts Raymond O'Donnell: 20 posts Adrian Klaver: 19 posts Colin Wetherbee: 19 posts Andrej Ricnik-Bay: 18 posts Andreas Kretschmer: 17 posts Devrim GÃNDÃZ: 17 posts
show more