Search Discussions

269 discussions - 1,214 posts

  • I have the exact same table of data in both MySQL and Postgresql. In Postgresql: tpcc=# \d metarelcloud_transactionlog Table "public.metarelcloud_transactionlog" Column | Type | Modifiers ...
    Yang ZhangYang Zhang
    Feb 22, 2010 at 6:11 pm
    Feb 24, 2010 at 4:08 am
  • Hi, we have latest PostGreSQL setup and it allows everyone to connect. When I do \du, it gives following output and it is same for all users. TechDB=# \du List of roles Role name | Superuser | Create ...
    Dipti shahDipti shah
    Feb 1, 2010 at 8:16 am
    Feb 5, 2010 at 8:42 pm
  • I have a character field I want to change to a number. The values in that field are all numbers that may or may not be padded with spaces or 0's. What is the best way to do that? Christine Penner ...
    Christine PennerChristine Penner
    Feb 24, 2010 at 7:36 pm
    Feb 24, 2010 at 10:16 pm
  • Hello, At the moment my pg client application (running 8.4) transfers data from several remote DBs (that run 8.3) via dblink, using cursors where appropriate, and reporting back progress to users ...
    Peter GeogheganPeter Geoghegan
    Feb 16, 2010 at 12:06 am
    Feb 17, 2010 at 2:39 pm
  • Hi, I need an hosting account with PostgreSQL and PHP. I have signed an account with HostNine.com, but the PostgreSQL is the 8.1, and don't allow to create Languages and Triggers, so I can't get the ...
    Andre LopesAndre Lopes
    Feb 13, 2010 at 9:09 pm
    Feb 16, 2010 at 8:06 am
  • Greetings, Is there a way of configuring PostgreSQL so that one specific table would use, say, 4GB of buffer cache while other tables would use the rest? I would like to keep the table and its ...
    Alexei VladishevAlexei Vladishev
    Feb 5, 2010 at 9:59 pm
    Feb 9, 2010 at 8:09 pm
  • Hello. I'm putting together a database to store the readings from various measurement devices for later processing. Since these things (water pressure monitors attached to very large water pipes) ...
    Feb 9, 2010 at 6:10 pm
    Feb 10, 2010 at 4:40 pm
  • Hello, I am looking for a way to copy all the data from one table to another on a regular basis, every 5 minutes let's say. INSERT INTO table2 SELECT * FROM table1; The above will copy all the data ...
    Feb 28, 2010 at 9:56 pm
    Mar 1, 2010 at 3:39 pm
  • I'm getting error: When I try vacuumdb -z assessment or vacuumdb assessment I get: vacuumdb: vacuuming of database "assessment" failed: ERROR: out of memory DETAIL: Failed on request of size ...
    David KerrDavid Kerr
    Feb 9, 2010 at 12:41 am
    Feb 9, 2010 at 9:12 pm
  • How to save 2 GB or more text string in Postgresql? Which data type should I use? Please any suggestion.
    AI RummanAI Rumman
    Feb 10, 2010 at 4:38 am
    Feb 10, 2010 at 4:26 pm
  • Hi there, gush, shouldn't be that complicated. But neither in Postgres, nor in Access I succeed in getting the result I wish. I have a couple of times for the Environmental Conventions (Kyoto, ...
    Stefan SchwarzerStefan Schwarzer
    Feb 23, 2010 at 11:44 am
    Feb 23, 2010 at 2:43 pm
  • Hi All, I have just started with postgres and after going through manual nearly for 2 hours, I need help. I have created a database, which I plan to load with several tables. I am trying to find the ...
    Dhimant PatelDhimant Patel
    Feb 17, 2010 at 4:59 pm
    Feb 19, 2010 at 7:25 pm
  • I've got a database that holds a bunch of articles in a table called 'article'. It has a bunch of columns, and each row might hold a few KB of data, say. I'm maintaining a separate fulltext database, ...
    Ben CampbellBen Campbell
    Feb 9, 2010 at 7:33 pm
    Feb 11, 2010 at 5:49 pm
  • Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This ...
    Christine PennerChristine Penner
    Feb 1, 2010 at 5:05 pm
    Feb 2, 2010 at 3:22 am
  • Hello, I have an application that is doing something stupid in that it is tacking on its own order clause at the end of the statement I am providing. For example, I am putting this statement in: ...
    Feb 25, 2010 at 3:50 am
    Mar 5, 2010 at 3:20 pm
  • How do I create a procedure using plpgsql cursors to print the output of the query in the cursor (using for loop) ? In all docs I found, it seems to be a must to return data to the call which is not ...
    Nilesh GovindarajanNilesh Govindarajan
    Feb 20, 2010 at 8:56 am
    Feb 20, 2010 at 2:00 pm
  • I have a function A1 that returns setof records, and I use it in two ways: 1) from function A2, where I need results from A1 2) from function A3, where I don't need these results, all I need is to ...
    Feb 18, 2010 at 12:15 pm
    Feb 19, 2010 at 11:13 am
  • I have a strange problem we noticed the other day with triggers. We're running 8.3.3 on Solaris 10 (intel) and have a feed that comes in regularly to populate a table we're working on. The feed works ...
    Feb 11, 2010 at 4:17 am
    Feb 12, 2010 at 4:25 am
  • Hello everybody, I am quite a novice in using the extension features of the PostgreSQL database. Actually, I have to do this for work at the university. At the moment, I am trying around a little bit ...
    Carsten KropfCarsten Kropf
    Feb 10, 2010 at 8:41 am
    Feb 11, 2010 at 4:44 pm
  • Hi, Hmm. Things are still getting interesting around here. Here is my complicated problem. I tried to delete a user from my users table, but it said "ERROR: bug_assigned_to_fk referential integrity ...
    Wang, Mary YWang, Mary Y
    Feb 11, 2010 at 12:56 am
    Feb 11, 2010 at 4:42 am
  • By referring to article at : http://blogs.msdn.com/miah/archive/2008/02/17/sql-if-exists-update-else-insert.aspx I try to implement as follow : CREATE OR REPLACE FUNCTION ...
    Yan Cheng CheokYan Cheng Cheok
    Feb 19, 2010 at 5:42 am
    Dec 20, 2010 at 2:32 pm
  • We recently upgraded to 8.4.2 and I'm trying to make sure our bgwriter is working as well as it can. Based on: # select * from pg_stat_bgwriter ; checkpoints_timed | checkpoints_req | ...
    Ben ChobotBen Chobot
    Feb 14, 2010 at 6:25 pm
    Feb 23, 2010 at 5:21 pm
  • I've installed postgreSQL 8.4 on a Windows XP machine, and I can't get it to start. Choosing Start Server from the menu produces a DOS box that remains blank for about 3 minutes, then comes up with ...
    Heddon's Gate HotelHeddon's Gate Hotel
    Feb 19, 2010 at 5:32 pm
    Feb 21, 2010 at 2:49 am
  • Maybe I'm getting too old to SQL anymore, but I ran across something yesterday in a machine generated query that took me over an hour to figure out. Here's a little testcase. Maybe somebody can ...
    Eric B. RidgeEric B. Ridge
    Feb 18, 2010 at 8:53 pm
    Feb 19, 2010 at 7:24 pm
  • Hi, Is it possible to define the permissions at database level such that no users(except postgres) can execute DROP, ALTER, TRUNCATE commands directily? Users have to use the given stored procedures. ...
    Dipti shahDipti shah
    Feb 18, 2010 at 8:53 am
    Feb 18, 2010 at 11:09 am
  • Hello, The db in the application I maintain but didn't write (it obviously makes use of PG, v 8.3), has been systematically growing in size from about 600M to 1.6G. At the same time, the performance ...
    Marcin KrolMarcin Krol
    Feb 12, 2010 at 5:10 pm
    Feb 13, 2010 at 8:39 am
  • I have just installed 8.4 on an XP. My intent is to use it with Trac and Apache. I would like to validate the installation of pgsql. What would be a good method to make sure that pgsql is in there ...
    Feb 1, 2010 at 1:19 am
    Feb 1, 2010 at 4:17 pm
  • This may belong in a bug report, but I'll post it here first... There appears to be a **SERIOUS** problem with using pg_compresslog and pg_uncompresslog with Postgresql 8.4.2. Here's my configuration ...
    Karl DenningerKarl Denninger
    Feb 7, 2010 at 8:03 pm
    Apr 19, 2010 at 1:43 pm
  • Ran into this switching a DBI based thing into a plperl function. The root cause is probably a perl variable scope thing, but still this is very interesting behavior and may trip up others. Given ...
    Feb 24, 2010 at 1:45 pm
    Feb 25, 2010 at 5:04 pm
  • Hi all, I am dumping both schema and data from old database to new one. The new database schema is somehow contain slightly different schema then the old one. When I do restore it shown alot errors ...
    Net Tree Inc.Net Tree Inc.
    Feb 23, 2010 at 4:50 am
    Feb 24, 2010 at 4:50 am
  • Hi, I'm trying to have this table ignored by the autovacuum process. It wasn't created with this in mind, hoping there is still a way? Thanks, Chris alter table schema.table SET (autovacuum_enabled = ...
    Chris BarnesChris Barnes
    Feb 18, 2010 at 5:21 pm
    Feb 19, 2010 at 2:03 pm
  • Hi, While copying a large'ish file (~ 7.6 million rows) into a table with: \copy [tablename] ([columns]) FROM '/path/to/large/file' NULL AS '' The command stopped running after a few minutes with the ...
    Feb 9, 2010 at 5:03 pm
    Feb 9, 2010 at 8:56 pm
  • Hi, I managed to restore my database. However, one table is not restored. The error message that I was received was "copy: line 3057, Cannot insert a duplicate key into unique index users_pkey..." ...
    Wang, Mary YWang, Mary Y
    Feb 3, 2010 at 9:35 am
    Feb 3, 2010 at 10:42 pm
  • Hello, I'm currently running on pg8.4 and I have a trigger with a loop : FOR ventilation_local IN (SELECT * FROM XXX) LOOP IF (mytest) THEN ventilation_local.myfield:=mynewvalue; END IF; END LOOP; my ...
    Florent THOMASFlorent THOMAS
    Feb 2, 2010 at 11:24 pm
    Feb 3, 2010 at 1:39 pm
  • Please have a look at http://en.wikipedia.org/wiki/Talk:PostgreSQL#License.3F This guy is insisting that PostgreSQL is NOT released under the BSD licence, a directly contradiction of the PostgreSQL ...
    Thom BrownThom Brown
    Feb 2, 2010 at 1:13 pm
    Feb 3, 2010 at 3:19 am
  • In one of my new roles, one of my projects has been to setup a proof of concept solution using PostgreSQL, which one emphasis being on performance monitoring during testing / dev ... We are mainly a ...
    Marc G. FournierMarc G. Fournier
    Feb 26, 2010 at 9:52 pm
    Mar 3, 2010 at 10:26 pm
  • Hi, I got this error: "-bash-2.05b$ /usr/local/pgsql/bin/pg_ctl start server starting -bash-2.05b$ FATAL: database files are incompatible with server DETAIL: The data directory was initialized by ...
    Wang, Mary YWang, Mary Y
    Feb 26, 2010 at 6:44 am
    Feb 26, 2010 at 9:44 am
  • Hi, I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process of restoring the databases in Postgres 8.3.8. There were lots errors showed on the screen when I ran this command ...
    Wang, Mary YWang, Mary Y
    Feb 23, 2010 at 7:19 am
    Feb 26, 2010 at 5:25 am
  • Hello All, I have been writing a function with SECURITY DEFINER enabled. Basically, I am looking for ways to override the users SET option settings while executing my function to prevent the ...
    Jignesh ShahJignesh Shah
    Feb 22, 2010 at 11:16 am
    Feb 22, 2010 at 6:42 pm
  • Hi, I have googled, but I can't find how to count the number of items in an Array in Plpgsql. Someone can give me a clue on that? Best Regads,
    Andre LopesAndre Lopes
    Feb 21, 2010 at 3:20 am
    Feb 21, 2010 at 3:46 pm
  • I have to write a 700 GB large database to a dump to clean out a lot of dead records on an Ubuntu server with postgres 8.3.8. What is the proper procedure to succeed with this - last time the dump ...
    Karsten vennemannKarsten vennemann
    Feb 10, 2010 at 6:53 am
    Feb 17, 2010 at 11:11 pm
  • Hi. I am running Postgres 8.2.7 on a Linux system for over a year now with no problems. Today one of the database users reported the following error: psql: FATAL: could not read block 0 of relation ...
    Janet JacobsenJanet Jacobsen
    Feb 13, 2010 at 2:07 am
    Feb 13, 2010 at 6:58 pm
  • Hi, I have been written several psql functions, tiggers and defined several tables over time for a database application I have been developing. The application has evolved as I have gained better ...
    Allan KamauAllan Kamau
    Feb 12, 2010 at 12:32 pm
    Feb 12, 2010 at 7:21 pm
  • Hi, A long-standing problem we've had with PostgreSQL queries in PHP is that the returned data for boolean columns is the string 'f' instead of the native boolean value of false. An obvious example ...
    Thom BrownThom Brown
    Feb 10, 2010 at 12:04 pm
    Feb 11, 2010 at 7:50 am
  • Let's say you have a table: CREATE TABLE t ( time date, data integer ) Suppose you want a new table that has columns similar to the following: "(x.time, x.data, y.time, y.data, z.time, z.data)" where ...
    Davor J.Davor J.
    Feb 8, 2010 at 7:20 pm
    Feb 10, 2010 at 10:20 am
  • Hi! New to the list with a question that I cannot find the answer to in the manual or on the internet but I suspect is trivial. If somebody could point me in the correct direction I would be ...
    Fredric FredricsonFredric Fredricson
    Feb 9, 2010 at 12:48 am
    Feb 9, 2010 at 11:38 am
  • Hi PostgreSQL Community, Are there any good PostgreSQL courses offered in the US Westcoast area? Would be great if there is one in California. Company's budget is tight. However, if the course is ...
    Wang, Mary YWang, Mary Y
    Feb 4, 2010 at 4:28 pm
    Feb 4, 2010 at 7:19 pm
  • Hi, I restored my database. However, I noticed performance is poor as compared to before. Are there some easy things that I can do to improve the performance (besides rewriting the code)? My ...
    Wang, Mary YWang, Mary Y
    Feb 4, 2010 at 3:55 pm
    Feb 4, 2010 at 6:48 pm
  • Hi, I am prototyping a system which sends all INSERT/UPDATE/DELETE events to a third party software, I do: CREATE TABLE data (id Serial PRIMARY KEY, data VARCHAR(255)); CREATE TABLE log (op CHAR(6), ...
    Gavin MuGavin Mu
    Feb 1, 2010 at 1:38 am
    Feb 2, 2010 at 3:24 pm
  • Good Evening, Good Morning Wherever you are whenever you may be reading this. I am new to this email group and have some good experience with SQL and PostgreSQL database. I am currently working on a ...
    Neil StlyzNeil Stlyz
    Feb 1, 2010 at 8:16 am
    Feb 1, 2010 at 8:43 pm
Group Navigation
period‹ prev | Feb 2010 | next ›
Group Overview
grouppgsql-general @

279 users for February 2010

Tom Lane: 75 posts Scott Marlowe: 54 posts Richard Huxton: 36 posts Greg Smith: 35 posts Dipti shah: 33 posts Alvaro Herrera: 27 posts Wang, Mary Y: 24 posts Andreas Kretschmer: 23 posts John R Pierce: 23 posts AI Rumman: 17 posts Ben Chobot: 17 posts Bruce Momjian: 17 posts Pavel Stehule: 17 posts Yang Zhang: 17 posts Alban Hertroys: 16 posts Adrian Klaver: 15 posts David Kerr: 15 posts Albe Laurenz: 14 posts Andre Lopes: 14 posts Raymond O'Donnell: 14 posts
show more