Search Discussions

314 discussions - 1,408 posts

  • I have 10 CHARACTER columns in table mytable. Mytable is indexed by some of those columns. CREATE TABLE mytable ( col1 CHARACTER(10), col2 CHARACTER(10),col3 CHARACTER(10),col4 CHARACTER(10),col5 ...
    Andrus MoorAndrus Moor
    Nov 6, 2005 at 9:07 pm
    Nov 11, 2005 at 7:43 pm
  • Hi, I just had this error in my database: bugasbase2=# SELECT count(*) from mba_data_base; ERROR: invalid page header in block 597621 of relation "mba_data_base" Any ideas whats going on? Am a bit ...
    Adam WitneyAdam Witney
    Nov 23, 2005 at 8:40 pm
    Nov 28, 2005 at 10:27 pm
  • Hi, Is it OK to use PREPARE TRANSACTION and COMMIT PREPARED in order to have transactions that last longer than just a single web request? Previously it was usually a bad idea to keep database ...
    Lincoln YeohLincoln Yeoh
    Nov 10, 2005 at 8:28 pm
    Nov 17, 2005 at 4:32 pm
  • Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. Regards -Evandro -- Evandro M Leite Jr PhD Student & Software developer ...
    Nov 8, 2005 at 11:58 am
    Nov 23, 2005 at 8:15 pm
  • Guys, In our effort to distribute PostgreSQL to our customers, our higher ups would like to reduce the visibility that it is indeed PostgreSQL for a number of reasons at a few of our customer sites ...
    John BenderJohn Bender
    Nov 16, 2005 at 4:40 pm
    Nov 18, 2005 at 1:29 pm
  • 8.1 should be using the new shared row locks for doing the checks. This should fix the case mentioned. Up until now, we didn't have one to get on a per-record basis.
    Stephan SzaboStephan Szabo
    Nov 25, 2005 at 8:40 am
    Jan 11, 2006 at 3:48 pm
  • I could use some help with the following: I have a database of geographic entities with attributes spread across several tables. I need to determine which entities are unique with respect to some of ...
    John D. BurgerJohn D. Burger
    Nov 30, 2005 at 2:58 am
    Dec 1, 2005 at 8:09 pm
  • This has been done. I'm only using it in two other packages so far, but both those and it's own unit tests seem to work well. http://search.cpan.org/~CRAKRJACK/DBIx-Transaction-0.001/ I've got some ...
    Tyler MacDonaldTyler MacDonald
    Nov 29, 2005 at 9:57 pm
    Dec 1, 2005 at 6:36 pm
  • Hello, Currently our company has a lot of small stores distributed around the country and in the actual database configuration we have a central database and all the small stores accessing it ...
    Carlos BenkendorfCarlos Benkendorf
    Nov 2, 2005 at 12:06 pm
    Nov 6, 2005 at 7:11 pm
  • I'm using Postgres 8.1 in Windows XP Sometimes when using pgAdmin the following Guru hint appears suddenly: "Running VACUUM recommended The estimated rowcount on the table "firma1.algsa" deviates ...
    Andrus MoorAndrus Moor
    Nov 20, 2005 at 7:17 pm
    Nov 30, 2005 at 7:42 pm
  • Hi all, I have right now a locked backend, similar to what I had a few days ago. It won't answer to pg_cancel_backend. Is there a way to diagnoze what it is actually doing ? If you answer, please do ...
    Csaba NagyCsaba Nagy
    Nov 18, 2005 at 11:13 am
    Nov 19, 2005 at 1:14 pm
  • Hello, I get unpredictibale results selecting from a view depending on index-usage. Please see the attached script for details. Is it a bug or some "weird feature"? Any help appreciated to get ...
    Sebastian BöckSebastian Böck
    Nov 14, 2005 at 5:12 pm
    Nov 16, 2005 at 7:10 pm
  • Hello *, I have three Sun Server where I have reserved on each Server a Raid-5 of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running with a database of 150 GByte. Now I like to make ...
    Michelle KonzackMichelle Konzack
    Nov 14, 2005 at 9:41 pm
    Nov 18, 2005 at 5:54 pm
  • When I change an id (primary key serial) in a table, the next value returned by the sequence for the id can conflict with that id (e.g., change the id to be id + 1). MySQL seems to handle this ...
    Steven BrownSteven Brown
    Nov 3, 2005 at 2:21 am
    Nov 7, 2005 at 7:58 pm
  • I want to take the serial ID of several values in different rows in one table and insert them into a single row of another table. Would the 'group by' command be the best way to do this? Bob
    Bob PawleyBob Pawley
    Nov 21, 2005 at 11:53 pm
    Nov 29, 2005 at 12:17 am
  • I'm porting an application from Sybase and I've noticed that similar application functions take 2 to 3 times longer on postgres than they used to on the same machine running under Sybase. I've tried ...
    David RysdamDavid Rysdam
    Nov 17, 2005 at 3:39 pm
    Nov 17, 2005 at 5:38 pm
  • Hope someone can help me learn. Sample 1 below, does work. It transfers every serial number generated by table pr into table pi with no duplication. Sample 2 below, does not work. From a logical ...
    Bob PawleyBob Pawley
    Nov 15, 2005 at 5:28 pm
    Nov 15, 2005 at 8:45 pm
  • Hi, Is there any "rule of thumb" on when to (not) use clustered indexes? What appen to the table/index? (any change on the physical organisation?) I've seen speed improvement on some queries but I'm ...
    Nov 2, 2005 at 1:04 pm
    Nov 3, 2005 at 12:33 pm
  • First version of this I sent this morning did not appear to go through. Please disregard if you received the first one. ---------- Original Message ---------- Hello All, We have finally tracked down ...
    Chris KratzChris Kratz
    Nov 21, 2005 at 8:27 pm
    Nov 22, 2005 at 2:12 pm
  • This might have been discussed before but I wanted to know if clustering tables by partial indexes will be availble in a later release of pgSQL? For the record, this is the error I get in 8.1: ...
    Keith C. PerryKeith C. Perry
    Nov 9, 2005 at 1:08 am
    Nov 16, 2005 at 6:14 am
  • Hi Forum, Should autovacuum reclaim most of the free space of a database? We are trying to configure our database and running pg_autovacuum to streamline our database. We have increased the ...
    Carlos OlivaCarlos Oliva
    Nov 10, 2005 at 7:13 pm
    Nov 11, 2005 at 6:55 pm
  • Hello all, I would like a generic way to generate an md5 hash for each row of a table. Currently I do it thusly: select id, md5(col_a || col_b || col_c || col_d) from mytable; id | md5 ...
    Jon LaphamJon Lapham
    Nov 2, 2005 at 1:38 pm
    Nov 2, 2005 at 6:20 pm
  • Dear PSQL, I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command. I want to make the report using a database manager application, ...
    Peter FutaroPeter Futaro
    Nov 29, 2005 at 9:25 am
    Dec 1, 2005 at 6:21 pm
  • Hi, As a superuser I created a normal user: CREATE USER probauser NOCREATEDB NOCREATEUSER; ALTER GROUP eden_users ADD USER probauser; a function: CREATE OR REPLACE FUNCTION edenproc_usesysid(text) ...
    Együd CsabaEgyüd Csaba
    Nov 26, 2005 at 2:01 pm
    Nov 27, 2005 at 6:54 am
  • PostgreSQL 7.4.8 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.2 20050816 (prerelease) (Debian 4.0.1-5) Hopefully this is something simple -- I assume it's a problem with my SQL. But it looks ...
    Bill MoseleyBill Moseley
    Nov 16, 2005 at 7:35 am
    Nov 17, 2005 at 2:06 pm
  • Hello everyone! I've been assigned the task of choosing the database soloution for our next project and have two questions I need to figure out: 1. Replication - multimaster I'll try to explain the ...
    Johnny LjunggrenJohnny Ljunggren
    Nov 11, 2005 at 6:41 pm
    Nov 15, 2005 at 7:09 pm
  • Hi, I am writing a .sql file to create a database, connect to it and create tables etc. (basic db setup). But I cannot figure out how to connect to the server (what statement) in a .sql file. any ...
    Assad JarrahianAssad Jarrahian
    Nov 7, 2005 at 1:06 am
    Nov 8, 2005 at 9:14 pm
  • hi, My server is Postgres 8.0.1 on fedora core2. My clients are remote and interface with my server using .NET GUI. We are trying to store many images/icons/audio/video clips in our system. We expect ...
    Vishal saberwalVishal saberwal
    Nov 4, 2005 at 4:27 am
    Nov 4, 2005 at 8:03 pm
  • I'm interested in defining a covariance aggregate function. (As a refresher, remember that covariance is a little bit like variance, but is between two variables: cov(X,Y) = <XY - <X <Y , where the ...
    Berend ToberBerend Tober
    Nov 21, 2005 at 4:07 pm
    Nov 25, 2005 at 10:13 am
  • I guess to much information can be an overload. Been surfin' to find a decent book and don't really know which one to try. I have a um, not exactly vague understanding of a database. Meaning I can ...
    Dennis VeatchDennis Veatch
    Nov 11, 2005 at 2:03 am
    Nov 15, 2005 at 3:39 pm
  • Hello everyone, I reboot my machine while postmaster is up. after the m/c gets rebooted , I grep for the process "postmaster", and it does not find it. So, I try starting postmaster. and it displays ...
    Nov 9, 2005 at 2:28 pm
    Nov 14, 2005 at 5:39 am
  • Should I set the max_fsm_pages to the value reported (vacuum verbose) as pages stored or the value reported as total pages needed? I ran full + analyze vacuums in my database (vacuumdb -f -z -v ...
    Carlos OlivaCarlos Oliva
    Nov 6, 2005 at 2:49 am
    Nov 9, 2005 at 12:20 am
  • I'm trying to concatenate strings in variable orders using a custom aggregate. However, I'm having a difficult time figuring out the SQL I need to use to accomplish this. Here's a test case that ...
    Michael GlaesemannMichael Glaesemann
    Nov 7, 2005 at 8:12 am
    Nov 8, 2005 at 11:58 am
  • Hi I am going to be hosting a PostgreSQL database on a new server. We will be purchasing a server with the AMD Athlon 64 3200+ processor. We are now posed with a choice of "FreeBSD 5.4" or "FreeBSD ...
    Nov 1, 2005 at 8:00 pm
    Nov 2, 2005 at 7:15 pm
  • Please, suggest any free/opensource tool for DB design under Linux. I need following: ER (or UML)-diagram - physical diagram - SQL code (I don't even dream about reverse transformation...) Quite good ...
    Nikolay SamokhvalovNikolay Samokhvalov
    Nov 24, 2005 at 11:25 pm
    Dec 5, 2005 at 9:08 am
  • We just ran an OS update on an Xserve which runs our PostgreSQL server, and now it seems that pg_ctl status doesn't report the correct status. ~ postgres$ pg_ctl status pg_ctl: neither postmaster nor ...
    Timothy PerrigoTimothy Perrigo
    Nov 28, 2005 at 9:20 pm
    Nov 29, 2005 at 1:04 pm
  • Dear all, I've written a bash script that looks like the one below: #!/bin/bash DBuser='root' DBname='test' psql -q --username=$DBuser --dbname=$DBname -c "prepare test_statement (integer) as insert ...
    A.j. LangereisA.j. Langereis
    Nov 18, 2005 at 4:16 pm
    Nov 26, 2005 at 6:24 pm
  • I have several fields that needs to be within a table but not real sure the best way to represent this data. The scenario I'm trying to incorporate is a form that has to be filled out went a well is ...
    Dennis VeatchDennis Veatch
    Nov 22, 2005 at 12:47 am
    Nov 24, 2005 at 1:58 am
  • Is there something in tsearch2 that prevents more than one index per table? I would like an index on field A, and a separate index on field B. The index builds fine for A, but gives an error for B. ...
    Rick SchumeyerRick Schumeyer
    Nov 23, 2005 at 4:51 am
    Nov 23, 2005 at 3:21 pm
  • Hi all, In my database application, I've repeatedly encountered a particular issue, and I'm not sure I'm addressing it well, so I'd like suggestions on how to deal with it. The problem is that I need ...
    Eric EEric E
    Nov 17, 2005 at 6:19 pm
    Nov 22, 2005 at 6:38 pm
  • I need to generate a table of teachers, and the count of classes they taught in the past and are scheduled to teach in the future. id | last_name | total future_class_count | past_class_count ...
    Bill MoseleyBill Moseley
    Nov 21, 2005 at 1:40 pm
    Nov 22, 2005 at 12:49 am
  • Hi all, Recently our databases started to experience a significant slowdown. Queries that were taking 500ms now take up to 20 seconds. An insert can take 150ms or more. This is strange since we are ...
    David MitchellDavid Mitchell
    Nov 17, 2005 at 9:12 pm
    Nov 18, 2005 at 3:43 am
  • I am attempting to transfer the data in the fluid_id column of table process into column fluid_id of table pipe. This should happen only when column contain of table process holds the value 'ip'. ...
    Bob PawleyBob Pawley
    Nov 10, 2005 at 10:24 pm
    Nov 11, 2005 at 6:14 pm
  • Hi, have just a general question... I have a table of 10M records, unique key on 5 fields. I need to update/insert 200k records in one go. I could do a select to check for existence and then either ...
    Nov 9, 2005 at 2:52 pm
    Nov 10, 2005 at 2:38 am
  • Hi all, Sorry for the trouble but I am trying to use triggers inside transactions to perform some multiplicity checking on the data inserted onto the tables but I am having some problems retrieving ...
    Ledina HidoLedina Hido
    Nov 8, 2005 at 10:19 pm
    Nov 9, 2005 at 7:35 am
  • Hi again! I have a perl program running a query on FreeBSD under PostgreSQL 7.4.8 that has worked for some time. Converting the program to Linux under PostgreSQL 8.0.3 returns a database error. The ...
    Nov 7, 2005 at 10:01 pm
    Nov 8, 2005 at 9:15 pm
  • Hi, could anybody help me? The backend (8.0) complains about the syntax of the following command. (This row is from a dump created by pgadmin 1.4, using pg_dump.exe v8.0.0.5017) The syntax error is ...
    Együd CsabaEgyüd Csaba
    Nov 25, 2005 at 4:17 pm
    Nov 26, 2005 at 5:00 pm
  • Given the focus of Sun on fault-tolerance etc., one of THE projects that they should definitely sponsor is http://gborg.postgresql.org/project/pgreplication/projdisplay.php Sincerely, Wolfgang Keller
    Wolfgang KellerWolfgang Keller
    Nov 18, 2005 at 10:00 am
    Nov 19, 2005 at 8:08 pm
  • hi, i have some system where i show pages results on a web-page - the query that returns the paged result looks like this: (table has a few hundred thousand rows, result-set is ~30000) a) select ...
    Thies C ArntzenThies C Arntzen
    Nov 16, 2005 at 12:52 pm
    Nov 16, 2005 at 2:47 pm
  • Hello! I am going to be inspired into PostgreSQL community. So I need your advices, buddies. There are a number of different PL-languages. How do you select these languages? I think PL/SQL is more ...
    Nicolay A VasilievNicolay A Vasiliev
    Nov 10, 2005 at 9:20 am
    Nov 10, 2005 at 1:22 pm
Group Navigation
period‹ prev | Nov 2005 | next ›
Group Overview
grouppgsql-general @

337 users for November 2005

Tom Lane: 121 posts Jim Nasby: 60 posts Martijn van Oosterhout: 49 posts Richard Huxton: 46 posts Michael Fuhr: 36 posts Scott Marlowe: 27 posts Andrus Moor: 26 posts Bob Pawley: 23 posts Bruce Momjian: 22 posts Jaime Casanova: 21 posts Csaba Nagy: 19 posts Tino Wildenhain: 16 posts Magnus Hagander: 15 posts Michael Glaesemann: 15 posts Adam Witney: 13 posts Andreas Kretschmer: 13 posts Bruno Wolff III: 13 posts Surabhi.ahuja: 13 posts Andrew Sullivan: 11 posts Oleg Bartunov: 11 posts
show more