Search Discussions

44 discussions - 158 posts

  • I am trying to create and index that will prevent a seq scan table. The querey that is causing the seq scan is this SELECT COUNT(*) FROM issuetracking where (issue_target='david' OR manager='david') ...
    Jan 14, 2008 at 4:21 pm
    Jan 14, 2008 at 7:31 pm
  • Hello, Given this SQL: SELECT c.name AS Customer, sum(rc.days_total) AS Days, count(distinct(rc.id)) AS Cages FROM customers c INNER JOIN reserved_cages rc ON c.ID=rc.customer_id GROUP BY c.name Now ...
    Raimon FernandezRaimon Fernandez
    Jan 23, 2008 at 8:10 am
    Feb 2, 2008 at 6:42 pm
  • PG 8.2 Red Hat Linux Hello - When I execute the following query, select A.domain_name_dom, A.word_wdl, A.count_ofi, A.total_quality_ofi, A.avg_quality_ofi from zzz_brand2domain_step2_bs2 as A join ...
    David MonarchiDavid Monarchi
    Jan 15, 2008 at 12:00 am
    Jan 24, 2008 at 1:39 pm
  • Hi pgsql experts; I've been a little surprised at the high knowledge level of the "novices" on this list, so if this isn't a novice question, let me know and I'll send it to the regular list. I'm ...
    Isaac VetterIsaac Vetter
    Jan 11, 2008 at 5:08 pm
    Jan 12, 2008 at 6:24 am
  • Hello, I am looking at options to chart dynamic data held in the PostgreSQL database pushed out to the web 'pages' via PHP, time series data in a scientific setting such as groundwater levels from a ...
    Greg CocksGreg Cocks
    Jan 25, 2008 at 9:01 pm
    Jan 29, 2008 at 7:28 pm
  • I'm having trouble with types and domains. I can create a type, but then when I try to create constraints using the components of the type, I get syntax errors. I've read through the pdf several ...
    Andrew WinklerAndrew Winkler
    Jan 16, 2008 at 4:22 am
    Jan 22, 2008 at 7:06 pm
  • I was in an academic meeting where a professor was preaching the reasons why not to use a stored procedure. He advised to always use SQL instead of a procedural language. Can someone please shed some ...
    Mag GamMag Gam
    Jan 22, 2008 at 2:17 pm
    Jan 22, 2008 at 6:36 pm
  • Hi, I've got a table with a couple of boolean columns which represent attributes of entities. Now I need to list those entities with the attributes cumulated into one text-column. How could I do ...
    Jan 23, 2008 at 4:20 am
    Jan 23, 2008 at 7:52 pm
  • I have an old postgres 7.1 data base that I must migrate to a new server running 8.2.6. The problem is everything I have tried has failed. The database has blobs in it but other than that it is ...
    Jan 10, 2008 at 3:49 pm
    Jan 11, 2008 at 4:00 pm
  • Hi all, I have a web app I would like to protect against postgreSQL injection. What characters should I be on the lookout for? Any Any suggestions for enhancing the security of my app are welcome. ...
    Mary AndersonMary Anderson
    Jan 30, 2008 at 9:49 pm
    Feb 1, 2008 at 5:56 am
  • Readers, I want to store data in a database. Do I have to perform mathematical functions within the database, or can I use a spreadsheet (e.g. calc)? For example: spreadsheet with cells of a formula ...
    Jan 28, 2008 at 8:42 pm
    Jan 29, 2008 at 5:44 pm
  • I think I got the data moved over from my old server. Now I am trying to connect to the server with pgadminIII I went into the postgers.conf and made these the changes I thought I needed for me to ...
    Jan 11, 2008 at 4:22 pm
    Jan 11, 2008 at 9:53 pm
  • I'm trying to create a CRLF record separator using the following syntax: psql -R "\r\n" dbname username -c "select * from foo" data_file.txt But, no matter what I do, it only outputs a newline (\n). ...
    Charley TiggsCharley Tiggs
    Jan 9, 2008 at 10:06 pm
    Jan 10, 2008 at 1:58 pm
  • Dear Pg experts; I'd like to get a (rough) count of the numbers of rows across all tables in a given database. I understand that I could write a script to run count(*) on each table and then sum the ...
    Isaac VetterIsaac Vetter
    Jan 30, 2008 at 8:10 pm
    Jan 30, 2008 at 10:06 pm
  • I am using PostgreSQL through the command line. I have written a small application that retrieves me information from a database. I have figured most things I need to know out. But I have two ...
    Sdger ergerSdger erger
    Jan 28, 2008 at 1:07 am
    Jan 28, 2008 at 8:28 pm
  • I'm cleaning up a database that someone else made and have a couple questions. When I look at a table in pgAdmin it shows the DDL below. Do I need an index on the groupid_seq sequence? Doesn't the ...
    Jeff WilldenJeff Willden
    Jan 19, 2008 at 10:04 pm
    Jan 20, 2008 at 9:31 pm
  • I'm new to the list and new to postgreSQL. I usually work in mySQL. I'm using NaviCat to manipulate my postgreSQL db. QUESTION: What is the best way for a novice like me to make my primary key ID ...
    Jack AlbrightJack Albright
    Jan 7, 2008 at 8:58 pm
    Jan 7, 2008 at 10:52 pm
  • Hi - I've been having some problems where we have a nightly script to replicate data which fails because of an <IDLE in transaction process. I figured I should kill any of the processes before doing ...
    Mija LeeMija Lee
    Jan 25, 2008 at 5:55 pm
    Jan 30, 2008 at 6:00 pm
  • I was performing a reindex yesterday when it failed stating a duplicate primary key violation. I looked into the database and found 3 tables with duplicate rows. How reliable is PostgreSQL in ...
    Jason Tan Boon TeckJason Tan Boon Teck
    Jan 18, 2008 at 2:33 am
    Jan 18, 2008 at 4:47 am
  • OK I'm currently trying to get my head around postgre, sql in general and php. So if this question seems easy dont mind me. What I wish to do is move several ms access dbases to postgre using ODBC ...
    Peter JacksonPeter Jackson
    Jan 15, 2008 at 1:12 pm
    Jan 15, 2008 at 11:58 pm
  • I just started a distributed database class. Where can I see what work has been done with regards to postgre and distributed databases? Thanks, Mike Be a better friend, newshound, and know-it-all ...
    Mike DorinMike Dorin
    Jan 13, 2008 at 2:27 am
    Jan 13, 2008 at 4:06 am
  • Hi, I have a big problem restoring a database. I have two backups, one made with pgadmin from my client, and one that is made nightly on the server with the local pg_dump. The PG version is 7.4.17 on ...
    Oeschey, Lars (I/EK-142, extern)Oeschey, Lars (I/EK-142, extern)
    Jan 8, 2008 at 9:55 am
    Jan 10, 2008 at 3:29 pm
  • Hi, I am attaching a PID of the a psql to the gdb debugger. However, I am unable to see the code location by the "where" command in gdb. I am of the feeling that postgres that is running doesn't have ...
    Kenneth d'souzaKenneth d'souza
    Jan 9, 2008 at 11:53 am
    Jan 10, 2008 at 12:15 pm
  • When I retrieve SQL queries through the command line I get outputs like: *Code:* Title ------- value (1 row) Is there anything I can do, any option I can choose, to retrieve only the value? *Code* ...
    Sdger ergerSdger erger
    Jan 6, 2008 at 9:54 am
    Jan 9, 2008 at 10:04 pm
  • I am having trouble using the Create_Tablespace command to create a tablespace on a mapped drive. The reason I am attempting to do this has to do with the storage capacity of my primary server, which ...
    Michael SmithMichael Smith
    Jan 9, 2008 at 12:16 am
    Jan 9, 2008 at 10:02 pm
  • In the following query: SELECT name, contact, phone, email FROM eforward.address WHERE gsb IN ( SELECT gsb FROM eforward.ibox WHERE ibx IN ( SELECT DISTINCT ibx FROM eforward.partner WHERE pibx = ...
    Daniel T. StaalDaniel T. Staal
    Jan 9, 2008 at 5:12 pm
    Jan 9, 2008 at 6:10 pm
  • A while ago I heard about a postgres addon that would allow a postgres database to treat tables in any other database as part of its own schema. The way I understood it, I could update a table in ...
    Michael LushMichael Lush
    Jan 31, 2008 at 1:16 pm
    Jan 31, 2008 at 1:32 pm
  • This question is so silly, that I must hang my head in shame and admit it's a novice question. Frequently on our DB we need to run large updates on a table, typically involving over 100K rows. These ...
    Carlo StonebanksCarlo Stonebanks
    Jan 29, 2008 at 1:17 am
    Jan 29, 2008 at 2:56 am
  • Readers, I've created a database. I couldn't find any documentation to help me with the following questions. How do I see a list of the names of databases that I've created? How do I see the name of ...
    Jan 27, 2008 at 9:25 am
    Jan 27, 2008 at 9:54 am
  • In other DBMSs indexes speed the process of sorting on a field in an ORDER BY clause if the same conditions for WHERE and JOIN clauses are met. I didn't see this mentioned in the docs on indexes ...
    Jeff WilldenJeff Willden
    Jan 26, 2008 at 4:21 pm
    Jan 27, 2008 at 2:20 am
  • I am currently developing an application. When I make database schema changes how can I apply these changes to production? How do application developers accomplish this task? BTW, I am using ...
    Mag GamMag Gam
    Jan 25, 2008 at 4:08 am
    Jan 26, 2008 at 1:11 pm
  • Hi, In my database, I am creating several triggers, some tables have more than one trigger for the same Fire/Event (ie BEFORE INSERT) combination. How can I know in which order the triggers will fire ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Jan 24, 2008 at 2:50 pm
    Jan 24, 2008 at 3:06 pm
  • Hello, I have a single database running an on-line application, we would like to take this and setup an intranet version to run at a exhibition/event where users will be able to add/modify records. ...
    Jan 18, 2008 at 5:55 pm
    Jan 18, 2008 at 8:48 pm
  • Hi All, Is it possible to set a default values as 'timestamp without time zone' in a column ? I'd like to insert automatically insert the date of insertion... Thanks Cedric
    Jan 15, 2008 at 8:28 am
    Jan 15, 2008 at 8:50 am
  • Hi, I hope this is the right place to ask about this: I'm building a simple eshop for a restaurant that should allow its users to order meals over the Internet, and also add some goodies to their ...
    Adam ŠindelářAdam Šindelář
    Jan 10, 2008 at 8:16 pm
    Jan 11, 2008 at 7:50 am
  • This system has been running postgresql 8.2.5 without problems. I wanted to try an install 8.3 from tarball while I had the chance. In preparation, I removed all postgresql files and services from ...
    G. J. WalshG. J. Walsh
    Jan 10, 2008 at 4:52 am
    Jan 10, 2008 at 5:48 am
  • I'm looking at what I want to do with backups, and from where I sit, there are two options: 1) WAL logging/PITR 2) pg_dump using the binary protocol The first allows me to recreate the database as it ...
    Brian HurtBrian Hurt
    Jan 2, 2008 at 5:33 pm
    Jan 2, 2008 at 5:49 pm
  • Hello all, I have searched the documentation and other web articles and can find no mention of limiting the size of databases at all(I would *really* love to be able to limit schema or user owned ...
    Jan 31, 2008 at 8:30 pm
    Jan 31, 2008 at 8:30 pm
  • Hello I need to log the changes to a table record in an update trigger. that is easy to achieve. the problem is that I cannot use a straight recording of the Old record in a log table as my users ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Jan 31, 2008 at 9:07 am
    Jan 31, 2008 at 9:07 am
  • I have a special requirement which I am told is addressed with string arrays in the upcoming release, where I will be able to establish, for example 192 nulls within a string. Downloaded the tarball ...
    G. J. WalshG. J. Walsh
    Jan 31, 2008 at 3:38 am
    Jan 31, 2008 at 3:38 am
  • Hello, I am looking at options to chart dynamic data held in the PostgreSQL database pushed out to the web 'pages' via PHP, time series data in a scientific setting such as groundwater levels from a ...
    Greg CocksGreg Cocks
    Jan 25, 2008 at 9:00 pm
    Jan 25, 2008 at 9:00 pm
  • Hello, I set up various FK constraints to various reference / look-up tables with 'On Update' = 'NO ACTION' After working with the data, I would like some in particular to 'On Update' = 'CASCADE' I ...
    Greg CocksGreg Cocks
    Jan 16, 2008 at 5:38 pm
    Jan 16, 2008 at 5:38 pm
  • Just want to say thanks for all the help. The new database server went live today with 8.2.6 and a newer old machine. It is running much faster now and the everybody is happy. Now I need to start ...
    Jan 16, 2008 at 3:22 pm
    Jan 16, 2008 at 3:22 pm
  • Hi, I have a table with 4 columns (a,b,c,d). 1. Earlier I had defined a UNIQUE constraint on all 4 columns (hence creating a composite index on all 4 columns) and the CPU utilization was ~1/2% during ...
    Durgaprasad PawarDurgaprasad Pawar
    Jan 16, 2008 at 6:22 am
    Jan 16, 2008 at 6:22 am
Group Navigation
period‹ prev | Jan 2008 | next ›
Group Overview
grouppgsql-novice @

61 users for January 2008

Tom Lane: 21 posts LWATCDR: 11 posts Sean Davis: 8 posts Andreas Kretschmer: 7 posts Isaac Vetter: 7 posts Andrej Ricnik-Bay: 6 posts Greg Cocks: 6 posts Andrew Winkler: 5 posts Charley Tiggs: 4 posts Daniel T. Staal: 4 posts Brian Hurt: 3 posts E-letter: 3 posts Jonah H. Harris: 3 posts Andreas: 2 posts Didier Gasser-Morlay: 2 posts Frank Bax: 2 posts G. J. Walsh: 2 posts Ilan Volow: 2 posts Jason Tan Boon Teck: 2 posts Jeff Willden: 2 posts
show more