Search Discussions

81 discussions - 245 posts

  • Hi: I'm an accountant, not a programmer, but I've written a time keeping application using Visual Basic for Applications and Microsoft Access. I've also done some VBA programming in Microsoft Excel. ...
    Bill DikaBill Dika
    Nov 12, 2005 at 6:58 pm
    Nov 22, 2005 at 1:15 am
  • select drug_name from drug, target, comb where drug.drug_id=comb.drug_id and comb.target_id=target.target_id and target_name='T3'; select target_name from drug, target, comb where ...
    Sean DavisSean Davis
    Nov 30, 2005 at 11:46 am
    Dec 1, 2005 at 3:33 am
  • Hello everybody I'm giving my first steps with postgresql. I installed it on a gentoo box and it's working fine. I can connect to it via pgadmin3 with server: localhost (or tux, as it's configured in ...
    Sebastian ScaranoSebastian Scarano
    Nov 13, 2005 at 4:57 am
    Nov 15, 2005 at 4:52 pm
  • Is there an easy way to save a series of queries and query results to a single file like /tee in MySQL? I am running version 8.-beta4 on windows XP.
    T. LackeyT. Lackey
    Nov 29, 2005 at 4:35 pm
    Dec 3, 2005 at 1:37 am
  • Hi ALL I´m trying to test OO concepts using postgres. I took an Oracle example, extracted from http://savtechno.com/ViewOfORDBMS.html As I know Oracle has more OO mature concepts, and Postgres? Where ...
    Nov 23, 2005 at 4:50 pm
    Nov 28, 2005 at 4:58 pm
  • i have the following code... // start $db = &ADONewConnection('postgres'); $db - Connect($db_string,$db_owner,$db_pw,$db_name); // $db - debug=true; $customer_name = $form- ...
    Nov 30, 2005 at 9:35 pm
    Dec 1, 2005 at 6:23 pm
  • Can anybody please tell me all the WinXP services that need to be run when someone is trying to install the Database? The reason I am asking this is because I can not install the database. I tried ...
    Ilias GoudaropoulosIlias Goudaropoulos
    Nov 28, 2005 at 12:05 am
    Nov 29, 2005 at 11:19 am
  • Hi, I have some problems with the upgrading from 8.0 to 8.1. I uninstalled the old version first and then i installed the 8.1 release with an error message about ssleay32 library and some error ...
    Nov 10, 2005 at 10:07 pm
    Nov 25, 2005 at 10:33 pm
  • According to my reading of the pgsql documentation, the two basic backup scripts are pg_dump and pg_dumpall. pg_dump allows you to dump a single database to a file, while pg_dumpall dumps all of the ...
    Thomas HaroldThomas Harold
    Nov 24, 2005 at 4:07 pm
    Nov 25, 2005 at 5:13 pm
  • Hello, Am seeking for a reliable PGSQL DB Designer wich will be : 1.GPL 2.Good gui 3.Work under linux 4.export model to sql code 5.optionally do reverse engeneering by importing a model from the sql ...
    Zouari FouratZouari Fourat
    Nov 23, 2005 at 5:52 pm
    Nov 24, 2005 at 6:46 am
  • Hi all, I'm a PostgreSQL novice (obviously)... I' trying to write some test functions to iterate over recordsets... this is one: CREATE OR REPLACE FUNCTION "public"."new_allarma" (soglia name) ...
    Emiliano AmilcarelliEmiliano Amilcarelli
    Nov 11, 2005 at 6:58 pm
    Nov 19, 2005 at 7:41 am
  • I've been doing web apps for about 8 years now and just to add to some of what William said. One of the key benefits of a web app is that as long as you stick with W3 compliance, your web app will ...
    Obe, Regina DND\\MISObe, Regina DND\\MIS
    Nov 16, 2005 at 10:12 pm
    Nov 18, 2005 at 1:08 pm
  • i have the following adodb code (which shouldn't be too hard to figure out for those not familiar with adodb): $db = &ADONewConnection('postgres8'); $db- ...
    Nov 14, 2005 at 5:41 pm
    Nov 16, 2005 at 5:42 pm
  • Hello I'm trying to create a simple database with PgAdmin3 but I got an error message: ERROR: column "datpath" does not exist I had never get this kind type of error message. I've used PostgreSQL and ...
    Jarkko ElfvingJarkko Elfving
    Nov 6, 2005 at 9:59 am
    Nov 7, 2005 at 3:17 pm
  • Sorry everybody for the typo. I meant to write 8.1.0-2. I had installed PostgreSQL 8.0.4 and uninstalled it completely. For half a month now (or even more), I am trying a clean install of PostgreSQL ...
    Ilias GoudaropoulosIlias Goudaropoulos
    Nov 29, 2005 at 8:40 am
    Nov 30, 2005 at 5:42 am
  • Greetings! I am starting to learn Java, and starting to use PostGreSQL too. I need some major help here. I am working under Windows XP Home Edition, and working with: PostgreSQL 8.0. pgAdmin III, v. ...
    Bernardo LópezBernardo López
    Nov 18, 2005 at 2:51 am
    Nov 20, 2005 at 11:32 pm
  • How does one create a BLOB in postgres? V. 8.0.3 I have read about cio's and lo in previous versions, but cannot find detail about how to do it in pg8. I would like to store different report layouts ...
    Roland GieslerRoland Giesler
    Nov 18, 2005 at 8:08 pm
    Nov 20, 2005 at 10:41 am
  • Hi everibody, a plpython function i'm writing fail with a strange ( to me ) message error: ..... plan=ply.prepare("intert into text,text1,integer1,text" ...
    Emiliano AmilcarelliEmiliano Amilcarelli
    Nov 17, 2005 at 7:54 am
    Nov 18, 2005 at 5:06 am
  • hi i have a column that is declared as: datum timestamp DEFAULT ('now'::text)::timestamp(6) with time zone then i do: SELECT datum from table; and get something like: 2005-11-13 00:00:00 i would like ...
    Stig eriksonStig erikson
    Nov 13, 2005 at 10:32 am
    Dec 11, 2005 at 2:38 am
  • Downloaded postgresql-8.0.2.zip from http://www.postgresql.org/ftp/ binary/v8.0.2/win32/ , attempted install on Windows XP. Received following error immediately after the Postgresql installer ...
    Peter GeorgePeter George
    Nov 24, 2005 at 4:07 pm
    Nov 30, 2005 at 1:16 am
  • dear friends, i created a bedrock sample database and put an employee table in it. i just can't find the file for the database so that i can transfer it to another computer. where is the file of ...
    Ramon OrticioRamon Orticio
    Nov 29, 2005 at 8:52 am
    Nov 29, 2005 at 6:52 pm
  • If I create a table with an OID field type, how do I set that field type? That is, I have to look up the OID value in another table somewhere to set my OID field and I don't know how to do that. (I'm ...
    Scott SimpsonScott Simpson
    Nov 26, 2005 at 9:04 pm
    Nov 29, 2005 at 1:55 pm
  • Hi, As you'll realise I'm new to all things Postgresql (& Gambas). I'm following Dr Bain's article in LXF71. Everything has gone ok (now) up until the introduction of "< data.sql" as per below. Can ...
    John HedgeJohn Hedge
    Nov 24, 2005 at 12:29 am
    Nov 28, 2005 at 11:58 am
  • can i create a new local db by copying an existing remote db or do i have to manually create the db locally and then pg_dump from the remote db and pg_restore into the local db? if i can create a db ...
    Nov 15, 2005 at 11:45 pm
    Nov 16, 2005 at 10:14 pm
  • Another Postgre noob here. I've used MySQL for some time and am trying to learn Postgre. Before axing the 8.0 installation I used "backup" from pgAdmin III (v1.4 w32) of my database to restore into ...
    Wes WilliamsWes Williams
    Nov 7, 2005 at 10:15 pm
    Nov 8, 2005 at 12:58 pm
  • I there, I'm trying to work with postgre, but i'm having a problem with inherits. I have a table (parent) that as an fk to another table. When i create a child, i loose the connection to the other ...
    Luis SilvaLuis Silva
    Nov 30, 2005 at 6:51 pm
    Dec 1, 2005 at 2:33 pm
  • Hi, I created a plpgsql function in pgAdmin III and it will insert a record into a table. I am not ready to test it with my App. Can I test it first with pgAdmin III Query window? What would be the ...
    Charles BaiCharles Bai
    Nov 23, 2005 at 3:22 pm
    Nov 23, 2005 at 4:03 pm
  • Hello. I am brand new to PostgreSQL and I need someone to point me in the right direction on how to write the results of a function to a text file. Is it possible to do this within the PostgreSQL ...
    William GerberWilliam Gerber
    Nov 16, 2005 at 7:38 pm
    Nov 16, 2005 at 8:01 pm
  • We are in the process of converting a legacy application to PostgreSQL, using Windows 2003, version 8.0.1. We have been noticing (via pgAdmin) that when we create a view, PostgreSQL appears to ...
    Lane Van IngenLane Van Ingen
    Nov 15, 2005 at 9:46 pm
    Nov 16, 2005 at 12:20 am
  • This is on NetBSD 2.0.2 and PostgreSQL 8.0.3 I made a not-so-wise move... I had run out of space on Unix directory /var and had decided to move it. I not so cleverly used 'tar -cf' and 'tar -xf' to ...
    Gan Uesli StarlingGan Uesli Starling
    Nov 14, 2005 at 1:14 am
    Nov 14, 2005 at 10:11 am
  • Hi guys, I am new to this database, so forgive me if this is too novice. I would like to know if there is any way to set the psql command output horizontal scrollable ? I mean sometimes when the ...
    Frank HuFrank Hu
    Nov 11, 2005 at 5:03 pm
    Nov 11, 2005 at 5:53 pm
  • Hi, Can anyone give some pointers on how to construct a query to do the following: I have a table like this: create temp table array_test (node integer, members integer[], var numeric); insert into ...
    David OrmeDavid Orme
    Nov 9, 2005 at 8:51 pm
    Nov 10, 2005 at 7:02 pm
  • I'm assuming no dump/restore cycle is needed for 8.1b1 to 8.1.0 upgrade? Just wanted to be absolutely sure. Thanks, Sean
    Sean DavisSean Davis
    Nov 9, 2005 at 4:25 pm
    Nov 9, 2005 at 6:07 pm
  • Hi, I'm running version 8.0 on Windows XP on a laptop. This morning while trying to generate a file of metadata I found that most of the views in Information_Schema are empty, for example ...
    George WeaverGeorge Weaver
    Nov 2, 2005 at 5:57 pm
    Nov 2, 2005 at 7:19 pm
  • XML2 is not included in the windows postgresql installer. So I googled and downloaded a windows binary from http://www.u-moe.org/pgxml/. I tried to install it: C:\Program Files\PostgreSQL\8.1\bin ...
    T j i b b eT j i b b e
    Nov 25, 2005 at 11:04 am
    Nov 29, 2005 at 1:29 pm
  • Hello, I have a table with two columns (id, names). At this time there is no index, because i have not needed any one. There are about 120 million rows. Now I want to delete all duplicate rows. I ...
    Christian HofmannChristian Hofmann
    Nov 27, 2005 at 9:51 pm
    Nov 27, 2005 at 10:22 pm
  • 1) I'm assuming that there's no issue with putting PostgreSQL on the same Windows 2003 server as our current MSSQL during the migration? (The box is not overloaded and I can't think of a reason not ...
    Thomas HaroldThomas Harold
    Nov 27, 2005 at 5:33 am
    Nov 27, 2005 at 6:58 am
  • Hello, group's users, I would like to know how i can select all the database from the server. It's like below: select database (in mysql) since naw, tanks! MSN Messenger: instale grátis e converse ...
    Jovito BalsamXo dos SantosJovito BalsamXo dos Santos
    Nov 21, 2005 at 4:08 pm
    Nov 27, 2005 at 6:28 am
  • Hi, I can not get a procedure with output parameter created. Right now, I am getting error on the line of "uid := newid;". If I remove the line, I got error saying that "Function myuser_insert(...) ...
    Charles BaiCharles Bai
    Nov 23, 2005 at 5:59 pm
    Nov 23, 2005 at 7:18 pm
  • Hi, I'm looking for a way to sort the output rows of a SELECT expressions by the maximum of three virtual columns of the output. Sorting it by one virtual column seems to be no problem: SELECT (<some ...
    Guido WinkelmannGuido Winkelmann
    Nov 13, 2005 at 8:13 pm
    Nov 23, 2005 at 12:20 pm
  • I installed version 8.1-beta4 using from the ".msi" file. It seems to be working fine. I want to develop a very simple application in C or C++ using embedded SQL. What else needs to be installed? In ...
    T. LackeyT. Lackey
    Nov 22, 2005 at 8:10 pm
    Nov 22, 2005 at 8:26 pm
  • hi list coming from the MS-SQL Server world, we're migrating our applications slowly to pgsql 8.1. now we thumbled on a problem with different sort-order behaviours: we got a table with dated ...
    Nov 20, 2005 at 12:33 am
    Nov 20, 2005 at 9:01 am
  • I'm using VB.NET beta 2 over a Postgres DB. Whenever I read the log files created by PG, I never see the parameterized queries. I only see $1 and $2 and so forth. Example: "SELECT * FROM Accounts ...
    Nov 13, 2005 at 9:03 pm
    Nov 19, 2005 at 7:42 am
  • Hello, Im having problems trying to concatenate two arrays in a plpgsql function. Doing the following : -- CREATE TABLE t1 ( id1 int, id2 int ); INSERT INTO t1 (id1, id2) VALUES (1,3); INSERT INTO t1 ...
    A GilmoreA Gilmore
    Nov 19, 2005 at 4:53 am
    Nov 19, 2005 at 4:59 am
  • Hello all, I'm trying to access my Postgres data base in perl Using DBI- connect ...
    Ryan millerRyan miller
    Nov 17, 2005 at 11:53 pm
    Nov 19, 2005 at 12:03 am
  • Hello! Is there any way to restore the value of sequences when using pg_restore on a custom format (pg_dump -c) dump file? Also is there an easy way to copy a database from one machine to another? I ...
    Bendik Rognlien JohansenBendik Rognlien Johansen
    Nov 17, 2005 at 5:40 pm
    Nov 17, 2005 at 5:58 pm
  • Hi, I have used the xml2 contrib module successfully with postgresql versions starting with 7.3, although installing the module at times has proven challenging. I have been using the xml2 contrib ...
    George WeaverGeorge Weaver
    Nov 16, 2005 at 10:58 pm
    Nov 17, 2005 at 4:54 pm
  • Dear Friends How can I call a function into a function? My problem is: I'm trying to calculate a tax(inss) over a employee salary. I created a function called inss that do it correctly, but when I ...
    Flávio BritoFlávio Brito
    Nov 16, 2005 at 8:39 pm
    Nov 17, 2005 at 4:15 am
  • I'm trying to install PostgreSQL from the RPM for Fedora 4 I am getting an error: Package not found. Unlocatable package - PostgreSQL. I don't understand - I'm trying to install PostgreSQL but it ...
    Kevin LippiattKevin Lippiatt
    Nov 13, 2005 at 6:02 pm
    Nov 13, 2005 at 10:14 pm
  • I have a table of items with about 50 columns, one of which is 'owner'. I would like to run several queries where the items for several 'owners' are to be treated as one owner. I have considered ...
    Frank BaxFrank Bax
    Nov 11, 2005 at 5:06 pm
    Nov 12, 2005 at 11:33 pm
Group Navigation
period‹ prev | Nov 2005 | next ›
Group Overview
grouppgsql-novice @

87 users for November 2005

Operationsengineer1: 19 posts Tom Lane: 13 posts Jaime Casanova: 10 posts Andreas Kretschmer: 8 posts Andreas Kretschmer: 8 posts Sean Davis: 8 posts Bill Dika: 7 posts Ilias Goudaropoulos: 7 posts Oliver Elphick: 7 posts Sebastian Scarano: 7 posts Me: 6 posts Marcus Engene: 6 posts Michael Fuhr: 6 posts Dawizz: 5 posts Emiliano Amilcarelli: 5 posts George Weaver: 5 posts Srinivas Iyyer: 5 posts Announce: 4 posts Charles Bai: 4 posts Chris Browne: 4 posts
show more