FAQ

Search Discussions

70 discussions - 311 posts

  • I was under the impression that Postgres did not need explicit descending order indexes created and that standard indexes would work fine. I am noticing a significant speed difference between the ...
    Alasdair YoungAlasdair Young
    Apr 11, 2006 at 6:07 pm
    Apr 12, 2006 at 6:16 pm
  • Hi all, Is it possible, given the following table: cod_rif | titolo | quantity | cmf | u_qq | mont | vend | sum ---------+--------+----------+---------+--------+---------+------+------- 26 | aaa | ...
    Ennio-SrEnnio-Sr
    Apr 25, 2006 at 8:08 pm
    Apr 26, 2006 at 2:52 pm
  • Hi all! This is just a peregrine thought: is it at all possible to print (on screen) in bold chars/or colour the lines of a select result that satisfy a certain condition? Regards, Ennio -- [Perche' ...
    Ennio-SrEnnio-Sr
    Apr 13, 2006 at 6:09 pm
    Apr 21, 2006 at 5:22 pm
  • Hi I have a website that has multilingual text stored in the database. Currently I just have a flat table (lets called it "translations"), one row per text item, one column per language. This works ...
    DanmcbDanmcb
    Apr 8, 2006 at 3:37 pm
    Apr 12, 2006 at 6:05 am
  • **I apologize in advance if this is a familiar question, but I couldn't find an answer** I am attempting to copy a csv file into a table, but no matter what I can think of I get one of two errors. I ...
    E. Matthew FinninE. Matthew Finnin
    Apr 12, 2006 at 6:52 pm
    Apr 18, 2006 at 7:27 pm
  • Suppose I have a table "foo" with columns a b and c. A is a serial unique key. What's a good way to copy a record to a temp table, and then append it back in as a new record, automatically assigning ...
    James LongJames Long
    Apr 5, 2006 at 7:37 am
    Apr 11, 2006 at 2:43 pm
  • Hello community! When I type a query in postgresql, like select id,imdb_id,count(imdb_id) from "Movies" where id<10 group by imdb_id; it says: column "Movies.id" must appear in the GROUP BY clause or ...
    Ntina PapadopoulouNtina Papadopoulou
    Apr 10, 2006 at 5:28 am
    Apr 10, 2006 at 5:51 pm
  • Hello, I've created my referential integrity with "REFERENCES TABLE..." directly into "CREATE TABLE" statements. I don't have used "ALTER TABLE" with "ADD CONSTRAINT constraint_name..." so I have ...
    Vincent FrisonVincent Frison
    Apr 17, 2006 at 12:40 am
    Apr 17, 2006 at 6:17 pm
  • Dear All. When i am trying to insert bytea with size of escape-coded data less than 16785346 bytes it works fine. But for more than 16785346 bytes it causes an error with dropping connection. Please, ...
    DmitryDmitry
    Apr 4, 2006 at 10:19 am
    Apr 4, 2006 at 9:23 pm
  • Hi all of you PostGreSQL fans, I need to run a query like SELECT users from userlog where lastlogindate is less than one month or SELECT users from userlog where lastlogindate is less than 15 days ...
    Shakil tanvirShakil tanvir
    Apr 4, 2006 at 6:58 am
    Apr 4, 2006 at 3:22 pm
  • Hi, I have found Oracle analytic functions very useful. They are so convenient to calculate running totals, moving averages, ranks, order data in buckets... and so on. I have found in the archives a ...
    Jean-Christophe RouxJean-Christophe Roux
    Apr 21, 2006 at 8:58 pm
    Apr 23, 2006 at 5:45 pm
  • Is there any way to prevent the thing telling you that it/whatever is in the public schema? I find this intrusive. If I were running a seat/flight bookings/reservations system for Japan Airlines ...
    Michael Talbot-WilsonMichael Talbot-Wilson
    Apr 19, 2006 at 4:27 am
    Apr 19, 2006 at 5:42 am
  • I was trying to backup a database called "old_db".The following lines inserted into either root crontab file or postgres crontab file failed either to produce any output or created an empty file ...
    KirtiKirti
    Apr 15, 2006 at 2:37 am
    Apr 17, 2006 at 2:10 pm
  • Hello, I have a table with an UNIQUE constraint. Is it possible to have something like a trigger (or error handler) which is called every time a insert statement would break this constraint? Or in ...
    Verena RuffVerena Ruff
    Apr 27, 2006 at 1:56 pm
    Apr 30, 2006 at 7:36 am
  • hi all, i'm in the process of moving my development (or at least some of it, long story), over to linux. i'm using simply mepis (debian based). postesql and pgadmin were installed. root owns pgadmin ...
    Operationsengineer1Operationsengineer1
    Apr 29, 2006 at 9:33 pm
    Apr 29, 2006 at 10:08 pm
  • hi list i've noticed a problem with an index, where the index wouldn't be used anymore as soon as a partial condition is added. here's the setup: table: "oldtables.movies" containing around 50'000 ...
    MeMe
    Apr 28, 2006 at 1:30 am
    Apr 28, 2006 at 1:49 am
  • Hi I am currently running a Perl script once a month which in turn uses a sql script file to extract info from a postgres database. I would like to automate this perl script, but the problem that I ...
    Mark CampbellMark Campbell
    Apr 26, 2006 at 12:06 pm
    Apr 27, 2006 at 9:23 am
  • Hello all, I am having a hard time finding all foreign keys on my database trough a script and then removing them. The reason I need to do this is that the application I am using has data that has ...
    Robert LandsmeerRobert Landsmeer
    Apr 18, 2006 at 2:31 pm
    Apr 19, 2006 at 9:09 am
  • Hi, I have a table with time stamps in it . These timestamp represent a event count. I just wanted to know how could I query such that I get a count of event per hour. Table structure is my_table(id ...
    Vishal KashyapVishal Kashyap
    Apr 11, 2006 at 9:04 pm
    Apr 12, 2006 at 1:07 pm
  • This is probably a FAQ, but I've googled the question and haven't found an answer. What is the internal format of numerics? I have a situation where I'm dealing with monetary values (so I want to use ...
    Brian HurtBrian Hurt
    Apr 25, 2006 at 3:24 pm
    Apr 25, 2006 at 6:10 pm
  • Hello All, I am attempting to access postgresql on another machine through PGAdmin III. I filled out the defaults in the "New Server Registration" dialog and when I hit "OK" I get an error stating ...
    Frances CollierFrances Collier
    Apr 18, 2006 at 11:41 pm
    Apr 20, 2006 at 3:48 pm
  • How do you do this? I guess it may require heroic methods such as the editing of dumps. Or it is easy? I'd like to do this because the \d is complicated. I've prototyped this thing in a temp database ...
    Michael Talbot-WilsonMichael Talbot-Wilson
    Apr 19, 2006 at 4:16 am
    Apr 19, 2006 at 8:58 pm
  • To all, what is the biggest size a Postgres database can get? I might have to deal with data in the order of 8 tera bytes. Is that doable? Reza
    Reza RazavipourReza Razavipour
    Apr 18, 2006 at 9:12 pm
    Apr 19, 2006 at 2:50 am
  • Let's say I have the following contrived schema: TRANSPORTATION_MODE modeID serial model_number text AIRPLANE airplaneID serial operational_ceiling int modeID int FK AUTOMOBILE automobileID serial ...
    Olinga K. AbbottOlinga K. Abbott
    Apr 12, 2006 at 9:21 pm
    Apr 13, 2006 at 5:06 pm
  • I know I've seen this somewhere, but I've searched the docs and can't seem to find it. I know that := is assignment, and, from the docs, (and experience), know that it does a "SELECT" to return the ...
    DavidDavid
    Apr 13, 2006 at 12:37 am
    Apr 13, 2006 at 4:24 am
  • Hi all, I have installed a precompiled package of postgresql 8.1 recently and would like to install server instrumentation bundled with pgadmin. I found that I need to configure the pgsql source tree ...
    Jonathan TseJonathan Tse
    Apr 12, 2006 at 7:03 am
    Apr 13, 2006 at 1:47 am
  • I'm looking for a curses tools to enter data into a PostgreSQL database. Insert and delete tuples change the values of columns, that sort of things. Detecting REFERENCES columns and presenting me ...
    Andre MajorelAndre Majorel
    Apr 11, 2006 at 7:11 pm
    Apr 12, 2006 at 5:04 am
  • Just curious whether there is such feature in postgres that allows you to encrypt the trigger function. I don't want to expose the trigger function content to the curious mind. Any suggestion will be ...
    Winson YungWinson Yung
    Apr 5, 2006 at 9:22 pm
    Apr 11, 2006 at 12:37 pm
  • Hi all, My present project requirement is to make an automatic interactivity which will check the database at pgsql on a scheduled time and email the result to an admin. Similar functionality can be ...
    Shakil tanvirShakil tanvir
    Apr 7, 2006 at 4:54 am
    Apr 7, 2006 at 3:33 pm
  • I would like to be able to define the type of column A in table T to be the same as the type of column B in table U, *whatever this type may be*. In particular, if later I change the type of column ...
    KynnKynn
    Apr 6, 2006 at 9:12 pm
    Apr 7, 2006 at 6:42 am
  • Hello All I am implementing a system in PostresQL but I am pretty new to db design in general so I don't really know how the type thing I am trying to achieve is done (or that it can be done) in the ...
    K992637K992637
    Apr 30, 2006 at 11:36 pm
    May 3, 2006 at 1:49 pm
  • hi all, i'm looking at ksysguard and i notice that 4 instances of postmaster are up and running. is this normal? i believe the system is automatically starting them up - b/c i sure did nothing to ...
    Operationsengineer1Operationsengineer1
    Apr 29, 2006 at 10:07 pm
    Apr 29, 2006 at 11:58 pm
  • Suppose I have a bunch of fields in different tables which I'd like to always force to lowercase (since they represent case-insensitive data). Suppose I want to do it at SQL level, not application ...
    Leonardo BoikoLeonardo Boiko
    Apr 26, 2006 at 7:53 pm
    Apr 29, 2006 at 8:19 pm
  • Hello, I want to get the indexes that are installed in one table. I looked at the information_schema but there was nothing to use. I am looking for something like SELECT column_name, index_name FROM ...
    Christian HofmannChristian Hofmann
    Apr 27, 2006 at 4:56 pm
    Apr 27, 2006 at 5:35 pm
  • Hello, I want to use PostgresQL as a back-end for my program. What I'm looking for is something similar to sqlite, as in being able to compile a dll/so and use/call it from my program. Are there any ...
    Amadeus ZilfinskiAmadeus Zilfinski
    Apr 22, 2006 at 7:58 pm
    Apr 23, 2006 at 4:26 am
  • Hi all, We've got postgresql 7.4 and a few views. I'm using pg_dump to backup the database and everything is ok. Recently, we added 5 new views - but when I restore the dump with psql, out of 5 new ...
    Wang, MarcusWang, Marcus
    Apr 20, 2006 at 2:29 am
    Apr 20, 2006 at 5:13 am
  • I have installed PostgreSQL 8.1.3 on Macintosh OS X.4. I'm seeing this: protoaddress=# \q could not save history to file "/Users/qdu/.psql_history": Unknown error: 0 In fact the session is written to ...
    Michael Talbot-WilsonMichael Talbot-Wilson
    Apr 19, 2006 at 12:08 am
    Apr 19, 2006 at 4:07 am
  • Hello everyone, I am using tsearch2 to create a search engine for our website. I am using the tsearch2 guide as my reference and am adapting it to fit our requirements: ...
    Matt Arnilo S. BaluyosMatt Arnilo S. Baluyos
    Apr 18, 2006 at 5:37 pm
    Apr 18, 2006 at 5:46 pm
  • I have been looking at documentation on inheritance and am not overly clear on all aspects of it. Fortunately, the examples in 'PostgreSQL' from 'Developers Library' showed examples which were ...
    Martin FosterMartin Foster
    Apr 14, 2006 at 10:08 pm
    Apr 15, 2006 at 12:03 am
  • Twice a year we import class information into table class. My first time doing this was with the spring import in August and the import failed because the Current Value was less than the Max ID in ...
    Douglas DoolittleDouglas Doolittle
    Apr 4, 2006 at 6:34 pm
    Apr 11, 2006 at 11:54 pm
  • My desire is to have a table auto update an "id" sequence on every insert, relieving the front end program of the responsibility. I've never written a trigger. I imagine that there may be a contrib ...
    Lan BarnesLan Barnes
    Apr 11, 2006 at 1:05 am
    Apr 11, 2006 at 5:27 am
  • I thought I had understood the question of primary key and foreign keys in the context of inheritance, but it seems I don't, and I would appreciate some light over this situation. Here's the setup: I ...
    Pierre ThibaudeauPierre Thibaudeau
    Apr 7, 2006 at 2:35 am
    Apr 8, 2006 at 3:02 am
  • Hello all, I need some advice on how to design some tables. I'm new at this SQL stuff. I lack the experience to know how a decision will affect me down the road.. I have a table containing "files", ...
    Jan DanielssonJan Danielsson
    Apr 6, 2006 at 12:04 pm
    Apr 7, 2006 at 4:18 am
  • Hi, I have installed postgre-sql in directory /usr/local1/postgres Now, I am trying to run /usr/local1/postgres/bin/initdb -D /usr/local1/postgres/data I got following error. The files belonging to ...
    Yadnyesh JoshiYadnyesh Joshi
    Apr 2, 2006 at 6:48 am
    Apr 4, 2006 at 9:55 pm
  • Hi, I installed PostgreSQL in my PC (windows XP) a few weeks ago and I can´t remember the password for the user 'postgres' so I can't access the local database. I can uninstall PostgreSQL but I don't ...
    Juan Pablo HernandezJuan Pablo Hernandez
    Apr 29, 2006 at 11:42 pm
    May 3, 2006 at 1:39 pm
  • Hi all I am trying to run pg_dumpall as a cron job. I find that while pg_dump has an option -f to name a file for output this is not available for pg_dumpall. After reading the manual, my guess is ...
    RichardRichard
    Apr 29, 2006 at 8:19 am
    Apr 29, 2006 at 8:18 pm
  • I am running PostgreSQL version 8.0.3 on Windows 2003. We have an application where it was not our intention to run WAL, since a little data loss is not critical to us. Nevertheless, we want to ...
    Lane Van IngenLane Van Ingen
    Apr 28, 2006 at 3:27 pm
    Apr 28, 2006 at 4:59 pm
  • Hello List, After upgrading to 8.1 we've been having problems with input data having invalid byte sequences. There are some data that we need to input at the moment and it would be helpful to ...
    Matt Arnilo S. BaluyosMatt Arnilo S. Baluyos
    Apr 24, 2006 at 12:01 am
    Apr 24, 2006 at 5:41 am
  • Hello pg_dump: server version: 8.1.3; pg_dump version: 8.1.0 pg_dump: proceeding despite version mismatch pg_dump: DEBUG: StartTransactionCommand pg_dump: DEBUG: StartTransaction pg_dump: DEBUG: ...
    AntsumeesAntsumees
    Apr 21, 2006 at 8:51 pm
    Apr 21, 2006 at 9:49 pm
  • Does anyone have an elegant way (sql) to query: select (various columns) from (several joined tables) where (resultset_row_numbers is between specified_first_row and specified_last_row) This would be ...
    KadilKadil
    Apr 21, 2006 at 8:18 am
    Apr 21, 2006 at 8:27 am
Group Navigation
period‹ prev | Apr 2006 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions70
posts311
users101
websitepostgresql.org
irc#postgresql

101 users for April 2006

Tom Lane: 34 posts Richard Broersma Jr: 20 posts Operationsengineer1: 19 posts Bruce Momjian: 9 posts Ennio-Sr: 9 posts Relaxin: 9 posts Andreas Kretschmer: 8 posts Bruno Wolff III: 7 posts Alasdair Young: 6 posts Michael Talbot-Wilson: 6 posts Me: 5 posts Chris Browne: 5 posts Frank Bax: 5 posts George Young: 5 posts John DeSoi: 5 posts Luis Silva: 5 posts Alan Hodgson: 4 posts Andrew Chambers: 4 posts Eric Matthew Finnin: 4 posts Ntina Papadopoulou: 4 posts
show more
Archives