FAQ

Search Discussions

46 discussions - 148 posts

  • Hi all, We are trying to do a dump of our database using the command line. However, the dump falls over during a dump of a particular table. blast= \d psiblast_round Table "public.psiblast_round" ...
    Noel FauxNoel Faux
    May 12, 2004 at 7:00 am
    May 20, 2004 at 1:20 am
  • I looked around for an example of how I might accomplish this, but couldn't find anything. Perhaps I'm using the wrong search words. I want to input dynamic values into a function, with one of those ...
    Derrick BettsDerrick Betts
    May 31, 2004 at 5:31 am
    Jun 1, 2004 at 6:19 am
  • Hi, I'm new here. My major problem is working with functions. (previously I use SQL Server) For instance, I haven't find a way to alter a function, or to view function list. (any keystroke like \d ...
    HendroHendro
    May 21, 2004 at 7:48 am
    May 26, 2004 at 1:21 am
  • Hi Oliver, Thanks, for your reply. Even I was thinking, VACCUM ANALYSE <table-name is jes enough but following discussion on forum forced me to add reindexing as I also saw similar error msgs from my ...
    Rajan BhideRajan Bhide
    May 17, 2004 at 5:48 am
    May 24, 2004 at 7:11 am
  • Hello, I am have been installing version 7.4.2 of postgesql through different channels on my PowerBook G4 (OS X 10.2.8). The installation was each time succesfull, but I am having problems to ...
    Philippe VERSCHOOTENPhilippe VERSCHOOTEN
    May 17, 2004 at 11:02 am
    May 21, 2004 at 3:20 pm
  • Hello people, Can I Commit a transaction without closing my cursors?? How can I do that??!! I would be great to be able to do it. Thanks for your answers!! Regards, Gastón.
    Gastón SimoneGastón Simone
    May 5, 2004 at 6:07 pm
    May 6, 2004 at 1:22 pm
  • Hi I try to "copy from" a plain text file that looks someting like this: John Red (\t) Garden Grove (\t) jwayne@garden.com Jessie Rodriguez (\t) West Beach Jane Harrison (\t) Malibu (\t) ...
    Eduardo Vázquez RodríguezEduardo Vázquez Rodríguez
    May 24, 2004 at 5:51 pm
    May 30, 2004 at 5:40 am
  • Hello All, I am getting following error msgs from my PostgreSQL server: I am using PostgreSQL server as my database server (version 7.4.1) After getting the error messages, the PostgreSQL server ...
    Rajan BhideRajan Bhide
    May 28, 2004 at 8:23 am
    May 31, 2004 at 12:30 pm
  • Hello, I installed Postgresql on my machine under Mandrake 10.0. I'm using unixODBC front end to create a database. I defined a User DSN and here is what I got from the .odbc.init file: ...
    Alain-Serge NagniAlain-Serge Nagni
    May 28, 2004 at 4:05 pm
    May 28, 2004 at 8:44 pm
  • hello, my Name is Rong. I am student at TU-Munich. I have some questions for Postgresql7.2 under SuSe Linux. Postgresql7.2 under SuSe Linux8.0. I use PostgreSQL7.2 with PGAdminII1.4.2 under ...
    XierXier
    May 28, 2004 at 10:36 am
    May 28, 2004 at 4:01 pm
  • Apologies in advance if this is a dupe.... Sorry if this is a FAQ. My Google skills are failing me. I'm in the initial stages of designing a database for my super-, ultra-, uber-web jukebox ...
    Ian PilcherIan Pilcher
    May 11, 2004 at 1:48 pm
    May 12, 2004 at 2:51 pm
  • My first post! Hello to all. I'm using Postgres 7.4.2. I compiled it without changing any server parameter. I'm trying to do a bulk of 90 inserts in one table, commiting at the end. My problem is ...
    Carlos BarrosoCarlos Barroso
    May 7, 2004 at 3:14 pm
    May 7, 2004 at 5:20 pm
  • INFO: analyzing "pg_catalog.pg_type" INFO: "pg_type": 5731 pages, 265 rows sampled, 265 estimated total rows INFO: vacuuming "pg_catalog.pg_attribute" ERROR: failed to re-find parent key in ...
    Michael GuerinMichael Guerin
    May 26, 2004 at 1:36 am
    May 26, 2004 at 4:37 am
  • Hi, And thanks for the tip Tom. There was a slight contradiction in this: "country" integer DEFAULT '' NOT NULL, Best regards, Aarni ---------- Forwarded Message ---------- Subject: Re: [NOVICE] ...
    Aarni RuuhimäkiAarni Ruuhimäki
    May 25, 2004 at 3:58 pm
    May 25, 2004 at 6:54 pm
  • I have a table where I have stored plain text passwords in a varchar field. I would like to convert these to an encoded field. I have been able to insert values into a test table using this syntax ...
    Glenn_wiensGlenn_wiens
    May 21, 2004 at 7:51 pm
    May 24, 2004 at 10:00 pm
  • I have close to a virgin install of postgresql and phppgadmin, but can't get phppgadmin to allow any kind of login and the logs aren't showing anything useful. I did give the postgres user a password ...
    GhaverlaGhaverla
    May 23, 2004 at 10:39 pm
    May 23, 2004 at 11:31 pm
  • I am attempting to change my schema search path to my newly-created schema, which isn't functioning correctly. When I initially show search_path, it gives me $Users, public, which is expected. When I ...
    Michael A WeberMichael A Weber
    May 16, 2004 at 5:34 pm
    May 22, 2004 at 2:53 am
  • How i can transport my postgre database to mysql?
    BizioBizio
    May 19, 2004 at 5:49 pm
    May 21, 2004 at 3:14 pm
  • Hi I have a form that inserts data to the DB. One field is timestamp type this field is not always filled out but postgres wont accept '' or null and gives the error (or maybe php gives the error).. ...
    Robert MorganRobert Morgan
    May 20, 2004 at 9:56 pm
    May 21, 2004 at 7:13 am
  • Hello Forum, I am having a table with UNIQUE constraints defined on three columns. Also I have UNIQUE user defined INDEX with the same columns on the table. The postgres documentation mentions that ...
    Rajan BhideRajan Bhide
    May 14, 2004 at 9:57 am
    May 14, 2004 at 12:46 pm
  • I have to rewrite a query after beeing parsed by gram.y but before any transformations are applied to my SelectStmt structure in analyze.c. Therefore I wrote a function that creates a new SelectStmt ...
    Matthias LenzMatthias Lenz
    May 10, 2004 at 2:54 pm
    May 13, 2004 at 11:07 am
  • Hello everyone! My name is David Cruz, and I'm from Bogota, Colombia. I'm Beggining with PostgreSQL, so I've been doing just a few simple things. I have a problem, in my database there is a table ...
    David CruzDavid Cruz
    May 7, 2004 at 4:56 am
    May 10, 2004 at 3:44 pm
  • Hi! Is there somewhere statistical extensions to postgresql? -- Tomka Gergely Tudom, anyu. Sapka, sál, doksi.
    Tomka GergelyTomka Gergely
    May 9, 2004 at 10:26 am
    May 9, 2004 at 2:58 pm
  • This seems pretty clear, but I wanted to ask in case I'm missing something. Given a pg_hba.conf with the single entry of local all md5 and the desire to call vacuumdb via cron, is my only hope of ...
    Andrew KellyAndrew Kelly
    May 5, 2004 at 11:17 am
    May 5, 2004 at 1:49 pm
  • I'm updating a table that has a field which is datatype 'date' this field maybe filled out or not before update. If the field is left blank I get an error, if I test to see if the field is empty and ...
    Robert MorganRobert Morgan
    May 27, 2004 at 4:32 am
    May 27, 2004 at 10:01 am
  • hi list, i have a table that is laid out like this: student_id | tally | org_id --------------+------------------ 1 | 0 | 1 2 | 0 | 1 3 | 0 | 1 4 | 0 | 1 5 | 0 | 1 1 |8367220 | 2 3 |7561391 | 2 5 ...
    PercyPercy
    May 26, 2004 at 8:17 am
    May 26, 2004 at 11:04 am
  • Hi, Trying to import data from a dump into 7.4.1 Here's the dump: ------snip------- CREATE SEQUENCE "users_id_seq" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1; -- -- TOC Entry ...
    Aarni RuuhimäkiAarni Ruuhimäki
    May 25, 2004 at 12:19 pm
    May 25, 2004 at 3:46 pm
  • Is it possible to change an existing field to a sequence? I have a field that contains ID numbers and I want this field to autoincrement evrytime a new row is inserted. The existing field is int8, ...
    Robert MorganRobert Morgan
    May 23, 2004 at 9:53 pm
    May 24, 2004 at 1:37 am
  • Within an update row level trigger how can I detect which field[s] has been effected by an update ? As I'm not concerned with the OLD field name values, comparisons against them are not important. ...
    Theo DickinsonTheo Dickinson
    May 14, 2004 at 3:18 pm
    May 21, 2004 at 3:12 pm
  • Hi all I've just started using postgres and have all my tables defined in the public schema. For some reason I'm being forced to use sql like the following select * from public."tblCategory"; instead ...
    Nick AllanNick Allan
    May 20, 2004 at 12:28 am
    May 21, 2004 at 3:07 pm
  • I am getting the following error on my server psql: relocation error: /usr/lib/libreadline.so.4: undefined symbol: BC I have a symbolic for that file to the actual one that is installed. What do I ...
    Chris OdleChris Odle
    May 19, 2004 at 12:52 am
    May 19, 2004 at 12:54 am
  • Hi, I've upgraded to SuSE9.1 which installs PostgreSQL 7.4.2. I cannot seem to connect to a local database using DBVisualizer, which worked fine pre-7.4.2 (7.3.3 IIRC). I keep getting a variation of ...
    Bob JarmanBob Jarman
    May 17, 2004 at 3:17 am
    May 17, 2004 at 1:44 pm
  • Saludos!!! Quisiera que alguien me ayudara a resolver el problema de concectar el PgAccess a Postgresql en Mandrake Linux 10.... así como un sitio donde se pueda descargar la última versión de ...
    Sandro MartinezSandro Martinez
    May 12, 2004 at 7:30 am
    May 12, 2004 at 4:35 pm
  • Hi, I have a problem with running a psql command from within my java application. I am pretty sure it is a syntax problem, but the same command run at the sql interface works. Here is my syntax: ...
    Pei-Chieh ShenPei-Chieh Shen
    May 6, 2004 at 4:21 am
    May 7, 2004 at 1:03 am
  • Trying to run this query: UPDATE tblMonitor SET Make = 'Phillips' WHERE Make = 'Ph*'; get the error message that " Error: relation "tblMonitor" does not exist" yet when I look at the relations it is ...
    Robert MorganRobert Morgan
    May 4, 2004 at 1:53 am
    May 4, 2004 at 2:44 am
  • Hello, I am currently working on a solution to set up PostgreSQL on Mac OS X Server 10.3.3 and I want to enable ODBC support so that our client PCs can continue using their MS-Access GUI which they ...
    Stephan HochhausStephan Hochhaus
    May 1, 2004 at 11:32 am
    May 1, 2004 at 2:49 pm
  • Hi, I am sorry if this question has been asked before hundreds of times, but I couldn't find an answer in the archive. I want to bulk load several GBs of data to an empty table. My concerns are time ...
    Martin HamplMartin Hampl
    May 30, 2004 at 10:30 am
    May 30, 2004 at 10:30 am
  • Its ok figured it out was an error in my sql, I had single quotes around the ServicedDate value. Bob
    Robert MorganRobert Morgan
    May 27, 2004 at 9:18 pm
    May 27, 2004 at 9:18 pm
  • Afternoon everyone, I´m needing to check some info in order to decide on whether postgres will meet my needs as a database, so if anyone could kindly inlighten me, i would be very grateful, At ...
    Iandé CoutinhoIandé Coutinho
    May 27, 2004 at 6:18 pm
    May 27, 2004 at 6:18 pm
  • --------------------------------- Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now
    Dcon crossDcon cross
    May 26, 2004 at 3:54 am
    May 26, 2004 at 3:54 am
  • Hi, I've heard about PGSQL for years but I just have the chance to try it out. My major problem is working with functions. (previously I use SQL Server) Can anybody suggest a nice place to start? An ...
    HendroHendro
    May 21, 2004 at 2:36 am
    May 21, 2004 at 2:36 am
  • I am running Suse 9.0 and have been working with postgresql 7.3.3 When I run psql as psql -v or psql -V and even psql --help I get a relocation error psql: relocation error: ...
    W00tW00t
    May 19, 2004 at 7:19 pm
    May 19, 2004 at 7:19 pm
  • TIA to anyone who reads all the way through this. I'm continuing to work on the database design for my super-, duper-, uber-web jukebox. One of my goals is to have a very flexible data model that ...
    Ian PilcherIan Pilcher
    May 16, 2004 at 5:01 pm
    May 16, 2004 at 5:01 pm
  • This is a pretty specific scenario, so I'm not sure if anyone has anythoughts or not. I've got a delphi app connecting to a postgres server (with MicroLap PostgresDAC)... My app is doing a continuous ...
    Christopher BeckerChristopher Becker
    May 5, 2004 at 3:22 pm
    May 5, 2004 at 3:22 pm
  • Im trying to create a function and i just cant get it right. So I've made a "basic" function which works: CREATE FUNCTION test(integer) RETURNS integer AS' DECLARE input integer; tablename text; ...
    Ed&Debbie van HekEd&Debbie van Hek
    May 5, 2004 at 1:19 pm
    May 5, 2004 at 1:19 pm
  • Is there any way to restore a SQL Server 2000 database for use on PostGreSQL? Thanks, Chari L. Clark Database Administrator National Background Data, LLC
    Chari ClarkChari Clark
    May 3, 2004 at 8:27 pm
    May 3, 2004 at 8:27 pm
Group Navigation
period‹ prev | May 2004 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions46
posts148
users62
websitepostgresql.org
irc#postgresql

62 users for May 2004

Tom Lane: 18 posts Rajan Bhide: 8 posts Manuel Sugawara: 7 posts Oliver Fromme: 7 posts M. Bastin: 5 posts Oliver Elphick: 5 posts Robert Morgan: 5 posts Derrick Betts: 4 posts Joseph speigle: 4 posts Stephan Szabo: 4 posts Xier: 3 posts Alain-Serge Nagni: 3 posts Andrew Hammond: 3 posts Ian Pilcher: 3 posts Martin Hampl: 3 posts Noel Faux: 3 posts Ghaverla: 2 posts Glenn_wiens: 2 posts Aarni Ruuhimäki: 2 posts Andrew Kelly: 2 posts
show more
Archives