FAQ

Search Discussions

40 discussions - 113 posts

  • Hi, I'd like to limit the values that can be added to a field. The field is of type 'point', and I'd like it to reject any values less than 0 or bigger than 1 (i.e., accept only points with values ...
    JillJill
    Jul 24, 2007 at 7:59 pm
    Jul 25, 2007 at 6:00 am
  • Hello all, I created a table where I used a timestamp type column and after inserting about 300 entries into this table I would now rather have two separate columns for that data: one for just the ...
    Bill TotmanBill Totman
    Jul 29, 2007 at 6:35 pm
    Jul 30, 2007 at 3:15 am
  • Hi all, I'm new to postgresql programming and I'd like to understand what a datum is (what is its purpose); I guess it is a kind of OID for customized data type created by users, but I'm not sure. ...
    Luca FerrariLuca Ferrari
    Jul 30, 2007 at 6:22 am
    Aug 6, 2007 at 3:36 pm
  • I have a database that can be accessed and used correctly via ODBC and MS-Access. But when I try to do a simple SQL SELECT query in psql, I get an error that the table can't be found: Relation ...
    Dale SeaburgDale Seaburg
    Jul 30, 2007 at 2:34 pm
    Jul 30, 2007 at 4:21 pm
  • Hello, I'm encountering a performance issue with insert statements. I push to Postgres an xml file with 2460 objects representing 2460 insert statements in a single transaction commited when the xml ...
    Christian LeclercChristian Leclerc
    Jul 24, 2007 at 10:37 am
    Jul 25, 2007 at 5:40 pm
  • Hi, I have managed to install postgres (Yea me!).. But I need to install tsearch2.. I'm trying to complie it, but I get this error (using gmake) Makefile:31: ../../src/Makefile.global: No such file ...
    David WessellDavid Wessell
    Jul 21, 2007 at 9:00 pm
    Jul 21, 2007 at 10:27 pm
  • Hi, I am new to postgresql and trying to figure out postgres.config file. There are few variables that I need an understanding about. shared_buffers, temp_buffers, work_mem maintenance_work_mem Can ...
    Shreya BhargavaShreya Bhargava
    Jul 12, 2007 at 8:08 pm
    Jul 12, 2007 at 8:58 pm
  • has anyone successfully configure pam with PostgreSQL? i am using Fedora Core 6 and i am in need of help on this matter.
    Yanot panaraYanot panara
    Jul 10, 2007 at 12:52 pm
    Jul 11, 2007 at 1:41 pm
  • Hello, Is het possible tot REVOKE the ALTER USER command? In such a way that users cannot change their password and username? And also cannot delete themeself with DROP USER? Now I solve the problem ...
    TjibbeTjibbe
    Jul 8, 2007 at 8:52 am
    Jul 8, 2007 at 9:24 pm
  • The two queries blow require radically different query times 1600ms vs 10ms: select * from test where ock in (1800,1810); select * from test where ock = 1800 or ock = 1810; The first query does not ...
    S anwarS anwar
    Jul 4, 2007 at 10:44 pm
    Jul 5, 2007 at 8:35 pm
  • Hello everyone, I would like to use PostgreSQL with the SmartyPaginate plugin of the Smarty template engine. In the examples on the documentation, the following two queries are used: SELECT ...
    Matt Arnilo S. BaluyosMatt Arnilo S. Baluyos
    Jul 31, 2007 at 1:29 am
    Jul 31, 2007 at 2:32 pm
  • Hi, Anybody knows how to add column with reference to BEFORE or AFTER any given column? Let say here's my table structure: Column | Type | Modifiers ----------+-------------------+----------- surname ...
    Ronald RojasRonald Rojas
    Jul 31, 2007 at 4:20 am
    Jul 31, 2007 at 6:25 am
  • Hello, I will be switching from PostgreSQL 7.4 to 8.2 operationally. So far, the transition goes smoothly but one thing is giving me headache when trying to make some pieces of code work on my newer ...
    Claude ChalouxClaude Chaloux
    Jul 24, 2007 at 6:23 pm
    Jul 24, 2007 at 7:47 pm
  • I am in the computer forensic business and need to restore a dump file and stand up the data base. I've never worked nor seen PostgreSQL before. Will the restored database need a user name and ...
    Brian P Ford SrBrian P Ford Sr
    Jul 12, 2007 at 7:48 pm
    Jul 13, 2007 at 9:50 pm
  • I am trying to run pg_dump from a perl script. I do this: system("pg_dump -U postgres eventOrganizer"); and it fires it up but it then wants me to manually enter the password. I couldn't find any ...
    StephenStephen
    Jul 10, 2007 at 4:15 pm
    Jul 11, 2007 at 6:57 am
  • Hi I am doing this: SELECT distinct cc.trader_id, t.credit_card_number, t.expiry_date, t.name_on_card, sum(to_number(cc.debit_credit,'999999.99')),cc.approval_number, t.business_name FROM ...
    StephenStephen
    Jul 6, 2007 at 4:28 pm
    Jul 8, 2007 at 7:46 pm
  • Hi I have 2 tables, one containing unique filenames, the other containing paths to those files. Paths are spread over multiple hosts (SMB shared files). The layout is like this: Column | Type | ...
    Tiemo KieftTiemo Kieft
    Jul 3, 2007 at 10:17 am
    Jul 3, 2007 at 8:48 pm
  • Hi everybody, I created the following function: CREATE OR REPLACE FUNCTION GetReminderServices( varchar ) RETURNS SETOF reminder_services AS' BEGIN SELECT dblink_connect(''dbname=''||$1); SELECT * ...
    Loredana CurugiuLoredana Curugiu
    Jul 3, 2007 at 9:03 am
    Jul 3, 2007 at 1:08 pm
  • Hello All, I am trying to create databse with script. I run this script from root prompt with command $ su - postgres -c 'path to script.sql' In the script I follow following steps 1) create user xyz ...
    Ashish KaralkarAshish Karalkar
    Jul 2, 2007 at 8:49 am
    Jul 2, 2007 at 3:12 pm
  • Hi everyone. For a long time I've been an Oracle developer and administrator but recently I became seduced by what I read about Postgresql. So I downloaded and installed a server and I'm reading the ...
    Dale CooperDale Cooper
    Jul 1, 2007 at 9:19 pm
    Jul 1, 2007 at 10:19 pm
  • Hi there, well, maybe I'm not total PgSQL noob, but I rather ask here if my weekend Google-Fu skills are weak and problem is trivial. My problem is like that: I took over old project by my ex ...
    Emil Oppeln-BronikowskiEmil Oppeln-Bronikowski
    Jul 29, 2007 at 12:50 pm
    Jul 31, 2007 at 10:20 am
  • Hi, I am trying to understand the function of spool structure in btree. I understand that there are 2 of them, one for the itups to be sorted and the other for dead tuples. Now, if I want to see all ...
    TejuTeju
    Jul 22, 2007 at 1:58 am
    Jul 22, 2007 at 2:39 am
  • Hi, Thanks for the suggestions provided for my question regarding postgres.config file last time. I am trying to see how these memory parameters affect time taken to build indexes. I understood that ...
    Shreya BhargavaShreya Bhargava
    Jul 14, 2007 at 5:23 pm
    Jul 14, 2007 at 9:27 pm
  • Hi guys! I plan to install postgres automatically and think about the following question: is it really necessary that postgres has a user WITH a home directory? Thanks for reading & answering, Peter
    Peter ElmersPeter Elmers
    Jul 13, 2007 at 1:11 pm
    Jul 14, 2007 at 12:54 am
  • hi all, i'm trying to install pgsql 8.2.4-1 on my windows xp pro system at work. i get the following error in an "Account Error" titled dialogue box when i try and submit the Service Configuration ...
    Operationsengineer1Operationsengineer1
    Jul 9, 2007 at 6:55 pm
    Jul 10, 2007 at 5:25 am
  • I have been trying to get postgresql 8.2 to create sql insert commands which, for a field of type byteA with back-slashes, are in the form E'xxx\yy\zz' I assume that the same cannot be done with ...
    Mike laneMike lane
    Jul 5, 2007 at 10:38 am
    Jul 9, 2007 at 10:25 pm
  • Hello, I have searched unsuccessfully for the answer to this so I hope that one of you may be able to help me. I am using the new RETURNING functionality but can't make it work in a trigger. In psql ...
    Doug JohnsonDoug Johnson
    Jul 7, 2007 at 9:21 pm
    Jul 7, 2007 at 9:46 pm
  • Hello All, I want to run few DDL's from scripts and want the script to halt if any error ocuurs, this can be done by on_error_stop But what I want to do is to display a message something like If ...
    Ashish KaralkarAshish Karalkar
    Jul 3, 2007 at 6:25 am
    Jul 5, 2007 at 9:48 pm
  • Hello all - I'm trying to find a way to simply some code, and I have an idea that I can't quite hatch. It might be too complex for SQL. I'm trying to do something like UPDATE first_table SET latitude ...
    Steve LefevreSteve Lefevre
    Jul 5, 2007 at 1:36 pm
    Jul 5, 2007 at 2:35 pm
  • PG 8.2.4 Hello - I need to append rows to an existing table that is in a production db. There are 60 fields in the table and 17 indexes, including the primary key. I cannot drop the indexes because ...
    David MonarchiDavid Monarchi
    Jul 4, 2007 at 8:23 pm
    Jul 4, 2007 at 8:57 pm
  • hi, i am stuck on a problem in plpgsql where in i have to take the values from user through keyboard. these values are to be stored in a particular row and have to be operated on by a trigger. ...
    Saumya goelSaumya goel
    Jul 2, 2007 at 5:56 am
    Jul 2, 2007 at 1:42 pm
  • Moving to -novice. Did you try just going with the defaults to all the questions? That normally works for me. -- Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com ...
    Decibel!Decibel!
    Jul 31, 2007 at 5:19 am
    Jul 31, 2007 at 5:19 am
  • Moving to -novice. 1) This isn't a bug, so you're not going to get much help from submitting a bug 2) Is there a reason you're using an ancient version? 3) See the docs on data type formatting ...
    Decibel!Decibel!
    Jul 31, 2007 at 5:19 am
    Jul 31, 2007 at 5:19 am
  • Hello, I thought I set up correctly the pg_autovacuum daemon on according to the documentation available at the following URL: <http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html ...
    Christian LeclercChristian Leclerc
    Jul 30, 2007 at 4:40 pm
    Jul 30, 2007 at 4:40 pm
  • Hi all, a little question about explain when analyzing an INSERT query: explain provides information about how the planner plan(s) and thus information about how a query costs. But in the case of an ...
    Luca FerrariLuca Ferrari
    Jul 30, 2007 at 6:22 am
    Jul 30, 2007 at 6:22 am
  • Trying to plan and get a bit of a jump on 8.3 I see an original project description for Updateable cursors at: http://archives.postgresql.org/pgsql-hackers/2007-01/msg01014.php I'm wondering if there ...
    Mike EllsworthMike Ellsworth
    Jul 23, 2007 at 1:40 pm
    Jul 23, 2007 at 1:40 pm
  • In the following insert_oicc function I need to replace and embedded ascii character back into a comma. The following code seems to work. However, I need to do this same thing on another table that ...
    Phillip NelsonPhillip Nelson
    Jul 12, 2007 at 6:47 pm
    Jul 12, 2007 at 6:47 pm
  • I have a one to many relationship and I am working with the 'many table'. I want to be able to identify an entry I might have just have made in the 'many table'. Is there some transaction id I can ...
    StephenStephen
    Jul 6, 2007 at 4:31 pm
    Jul 6, 2007 at 4:31 pm
  • Hi list, I am wondering if there are any good books available for novices about triggers / stored procedures. Thanks !
    Callewaert NicoCallewaert Nico
    Jul 3, 2007 at 7:19 am
    Jul 3, 2007 at 7:19 am
  • Hi everybody, I have the following 3 tables: sent_messages uid | receiver | theme | date -----+----------------------+-------------+------------------------------- 1 | +40741775630 | CAND1 | ...
    Loredana CurugiuLoredana Curugiu
    Jul 2, 2007 at 8:24 am
    Jul 2, 2007 at 8:24 am
Group Navigation
period‹ prev | Jul 2007 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions40
posts113
users52
websitepostgresql.org
irc#postgresql

52 users for July 2007

Tom Lane: 13 posts Michael Glaesemann: 9 posts Christian Leclerc: 4 posts David Wessell: 4 posts Jim Nasby: 4 posts Loredana Curugiu: 4 posts Ashish Karalkar: 3 posts Bill Totman: 3 posts Luca Ferrari: 3 posts Oliver Elphick: 3 posts Raimon Fernandez: 3 posts Sean Davis: 3 posts Shreya Bhargava: 3 posts Stephen: 3 posts Tjibbe: 3 posts Yanot panara: 3 posts Andrej Ricnik-Bay: 2 posts Dale Cooper: 2 posts Dale Seaburg: 2 posts Jill: 2 posts
show more
Archives