Search Discussions

103 discussions - 322 posts

  • X-No-Archive: true Hi again, My test database is taking shape, and I'm starting to get the hang of it, but there's one concept that I just can't get my head around, and it is this: if I do .. test= ...
    May 16, 2005 at 7:16 am
    May 17, 2005 at 4:46 pm
  • Thanks Jaime! Using pgAdmin III selected all rows: SELECT aid,num,name30 FROM nod ORDER BY num; First rows from result in a CSV file: aid;num;name30 "374";"0";"2181 " "371";"0";"2178 " ... Is this a ...
    May 23, 2005 at 9:33 pm
    May 24, 2005 at 5:21 pm
  • Hi folks, After searching for a while as to how to transfer data from machine to machine, I came across the 'pg_dump' and 'pg_restore' commands. On machine 'A', I did .. /usr/local/pgsql/bin/pg_dump ...
    May 12, 2005 at 8:05 pm
    May 12, 2005 at 8:54 pm
  • All, I'm trying to figure out how functions work in PGSQL. I've got a sample here but I keep getting an error and I'm not sure why. CREATE FUNCTION test2(VARCHAR) RETURNS SETOF TEXT AS ' DECLARE r ...
    Nick JonesNick Jones
    May 26, 2005 at 8:07 pm
    Jun 1, 2005 at 3:45 pm
  • Hi all, I'm having major problems trying to get 8.0.2 installed on Windows XP, SP2... I have never had a PostgreSQL install on this machine. I have uninstalled completely my McAfee virus scan, and ...
    Postgresql OrgPostgresql Org
    May 13, 2005 at 12:38 pm
    May 17, 2005 at 5:52 pm
  • since i'm having very strange problems with my database, i want to create a new db and use the problem db as a template. this allows me to keep th eproblem db in an unaltered state in case someone ...
    May 3, 2005 at 5:18 pm
    May 4, 2005 at 1:42 pm
  • Hi all, I am a beginner in Linux and Postgres too, so take this into consideration. I have installed Fedora Core 3, and PostgreSQL 8.0.2 from source on it. All right so far. Now I would like to have ...
    Havasvölgyi OttóHavasvölgyi Ottó
    May 1, 2005 at 6:33 pm
    May 2, 2005 at 9:15 pm
  • dear all, I have a question about creating a database. I can create a database easily using pgAdminiii, but I am trying to get it done using psql. When I try to start the psql editor using psql I get ...
    Danny GaethofsDanny Gaethofs
    May 30, 2005 at 9:51 am
    May 30, 2005 at 4:41 pm
  • I am running Postgres v8.0.1 on Win XP Pro. When I try to delete a record, which I know exists, I simply get 'DELETE 0' as a response. Please Help! Here is a little more info: DELETE FROM CONTACTS ...
    Kevin CrenshawKevin Crenshaw
    May 25, 2005 at 2:27 pm
    May 30, 2005 at 1:53 pm
  • I don't know where to go with this question. If this is the wrong place, please disregard. I'm trying to learn more about how to connect to the backend with perl, not using DBI, just straight perl ...
    Tom PfeiferTom Pfeifer
    May 15, 2005 at 12:04 am
    May 15, 2005 at 5:51 pm
  • Hi All, I have a quick question. Is there a simple way to access the returned record number? I want to be able to do something like SELECT record AS record_no, column1, column2 FROM table1 WHERE ...
    Keith WorthingtonKeith Worthington
    May 6, 2005 at 7:45 pm
    May 9, 2005 at 8:43 pm
  • Hi, I know people have asked about this before but I can't find a working solution on the web - I've found code for specific instances of calculating medians but I need a general aggregate function ...
    David OrmeDavid Orme
    May 17, 2005 at 3:48 pm
    May 17, 2005 at 5:01 pm
  • Hi all, I have tried a lot to search info available on Google, but still I have trouble!, I have installed the 8.0.2 version on Win2000, I have installed as a program (not as service) I am not able ...
    Vyom AVyom A
    May 12, 2005 at 1:43 pm
    May 16, 2005 at 11:12 am
  • I discovered today that when I create a function in a schema that another user has "grant usage" on, they are able to execute the function even though I've not granted them "execute" on the function. ...
    Walker, Jed SWalker, Jed S
    May 5, 2005 at 7:53 pm
    May 6, 2005 at 3:43 pm
  • i have the following code... ------------- $assembly = $_POST['product_base']; $assembly_notes = $_POST['assembly_notes']; $db = &ADONewConnection('postgres'); $db - ...
    May 2, 2005 at 6:41 pm
    May 3, 2005 at 7:44 pm
  • Creating/adding a "FOREIGN KEY" creates any "real" key sequencies? Foreign key constraint became a key - seem to me, but what about the foreign table, there is also created a "seemless" key or I ...
    May 1, 2005 at 2:15 pm
    May 3, 2005 at 12:08 pm
  • [Running PG 7.4.7-5 on GNU-Linux Debian Sarge] Hi all, I'm wondering if it is possible to run a query from a .sql file, so as to automate certain searches from console. I've been unsuccessfully ...
    May 1, 2005 at 4:24 pm
    May 2, 2005 at 1:34 pm
  • Hello, Just beginning... winXPsp2/home PostgreSQL 8.0.2 Was unable to successfully install pgsql manually. Removed install and reinstalled making pgsql start as a service. This was successful. ...
    David SadlerDavid Sadler
    May 25, 2005 at 5:21 pm
    May 28, 2005 at 11:49 pm
  • Hi, Does anyone knows some tool to migrate data from MySQL to PostgreSQL WIN ? Regards.
    Glauter Moulin CoelhoGlauter Moulin Coelho
    May 25, 2005 at 2:41 pm
    May 25, 2005 at 5:30 pm
  • Hi All, I need to generate a column representing the interval passed in months and restrict the returned data to those intervals matching 12, 24, 36 and 48. So far by reading the documentation I have ...
    Keith WorthingtonKeith Worthington
    May 4, 2005 at 8:44 pm
    May 5, 2005 at 3:19 pm
  • I have PostgreSQL setup and everything is working fine when I use "psql -d <dbName " on the command line or when I use mod_python to connect. However I when I use "psql -h localhost <dbName postgres" ...
    Wayne PierceWayne Pierce
    May 2, 2005 at 1:03 pm
    May 2, 2005 at 4:03 pm
  • hi all, my users enter a note. i would like to keep carriage returns intact. however, when i display the data, the two carriage returns are lost and replaced with two spaces. i use adodb's qstr() ...
    May 26, 2005 at 8:16 pm
    May 31, 2005 at 7:25 pm
  • Hi All, I am banging my head againset the wall trying to figure out how to do a JOIN within an UPDATE. Can someone please help me out? Here is what I have. Of course it does not work. :-( UPDATE ...
    Keith WorthingtonKeith Worthington
    May 24, 2005 at 6:02 pm
    May 31, 2005 at 1:01 pm
  • Hi everybody! I'm using PostgreSQL 7.4.7 on Debian Testing (Kernel 2.4.27 SMP) with winXP application (Clarion 6.1 RAD) through ODBC Unicode 3.0(?) Beta. Currently I'm converting my existing database ...
    May 23, 2005 at 9:10 pm
    May 24, 2005 at 1:02 am
  • thank you guys i'll try your suggestions. but i see the commands are in linux how about in windows platform how do you do that will it be the same? thanks again. mon
    Ramon OrticioRamon Orticio
    May 23, 2005 at 9:17 am
    May 23, 2005 at 6:19 pm
  • Hi! I'm new at using postgreSQL, andI have the following error: [postgres@nodo2 ~]# /etc/init.d/postgresql restart Parando el servicio postgresql: [FALLÓ] rm: no se puede borrar ...
    Agustín Caminero HerráezAgustín Caminero Herráez
    May 23, 2005 at 9:04 am
    May 23, 2005 at 5:53 pm
  • Hi (not sure if the Subject: field is correct, but here goes ..), I'm trying to build some more complexity into the db that I mentioned recently. If in the 'clients' table, I have client_id int NOT ...
    May 21, 2005 at 12:08 pm
    May 21, 2005 at 6:20 pm
  • I have been investigating this error message for several days now but am unable to find anything useful--perhaps someone will be able to assist me? Thanks in advance for your assistance! ...
    McCormick, BillMcCormick, Bill
    May 13, 2005 at 5:39 pm
    May 17, 2005 at 6:46 pm
  • Hello. I am new to Postgresql and I am having a problem with starting it in FreeBSD at boot time. (Also, my user account is pgsql not postgresql) Presently, I have this command in my /etc/rc.conf ...
    Buddy ShearerBuddy Shearer
    May 17, 2005 at 2:48 pm
    May 17, 2005 at 4:45 pm
  • I read that the "autocommit" setting doesn't exist in the new versions of PostgreSQL. Is there another way to do it? I am using pgAdmin and it is quite annoying to remember to open a transaction ...
    Vitaly BelmanVitaly Belman
    May 12, 2005 at 7:31 am
    May 12, 2005 at 2:43 pm
  • Hi, Quick question for 10 points! Is there a way to write the output of a select query to a file (I'm on a linux platform)? For example: SELECT name, age, address from employee; gives the result that ...
    SG EdwardsSG Edwards
    May 11, 2005 at 1:15 pm
    May 11, 2005 at 1:59 pm
  • Forgot to remove "OR" here IF NEW.indexed != true Hello, I have the following trigger on the table "records": CREATE OR REPLACE FUNCTION records_update_trigger() RETURNS TRIGGER AS ' BEGIN ...
    Bendik Rognlien JohansenBendik Rognlien Johansen
    May 24, 2005 at 8:54 am
    May 24, 2005 at 7:28 pm
  • Does sparse data cause significant space wastage or performance issues in PostgreSQL? We are building an application that stores assets. Each different type of asset has different attributes and in ...
    Walker, Jed SWalker, Jed S
    May 24, 2005 at 3:58 pm
    May 24, 2005 at 6:43 pm
  • Hello, I have the following trigger on the table "records": CREATE OR REPLACE FUNCTION records_update_trigger() RETURNS TRIGGER AS ' BEGIN NEW.updated = now(); IF OLD.address1 != NEW.address1 OR ...
    Bendik Rognlien JohansenBendik Rognlien Johansen
    May 24, 2005 at 8:48 am
    May 24, 2005 at 12:34 pm
  • hello! postgresql database files is quite complicated for me. how can one transfer a postgressl database file from one computer to another. in access dbms, this can be easily done by locating the ...
    Ramon OrticioRamon Orticio
    May 23, 2005 at 1:36 am
    May 23, 2005 at 6:35 am
  • I'm very new to postgres but not to databases. I'm currently working on a back end platform of Adaptive Server Anywhere 9.0 (Sybase) and would like to move to Postgres. I have a total of 6 production ...
    Jeff DykeJeff Dyke
    May 18, 2005 at 10:23 pm
    May 19, 2005 at 3:27 pm
  • dear people, Let's say i am using a database in a postgresql system, how do i check the location of the tablespace where it is kept in the filesystem ? thanks in advanced.
    Low Kian SeongLow Kian Seong
    May 19, 2005 at 5:16 am
    May 19, 2005 at 5:40 am
  • Hello, I am using PostgreSQL 8.0 as a data repository for a Java based system and I now want to add users to my java program with usernames and passwords. Is their an encrypted password field I can ...
    William ShatnerWilliam Shatner
    May 18, 2005 at 10:40 am
    May 18, 2005 at 1:02 pm
  • Hi everybody, the other day i used the cluster-command to cluster my data on a previosly created index. i did this on a postgreSQL-server (v.8) via SSH. the clustering took the whole night.... when i ...
    Timo RoessnerTimo Roessner
    May 17, 2005 at 6:56 pm
    May 18, 2005 at 11:56 am
  • The problem... From the table below I want to select distinct clus_id and the data in 3 db columns, even if that data is null. When there are multiple contigs for a clus_id I want to select the row ...
    Ann hedleyAnn hedley
    May 14, 2005 at 10:45 am
    May 16, 2005 at 8:37 am
  • Hi all. This might be OT, especiallz since I do not have the actual data for volume and throughput, but can give only "bystander" impression. I might get on-board a project that deals with a high ...
    Nikola MilutinovicNikola Milutinovic
    May 12, 2005 at 5:37 am
    May 12, 2005 at 7:29 pm
  • Hi All, I believe I need to use a serial column in two tables and keep then synched. I am thinking that I could use an AFTER INSERT trigger and INSERT currval() into the second table to keep them ...
    Keith WorthingtonKeith Worthington
    May 12, 2005 at 5:48 pm
    May 12, 2005 at 6:16 pm
  • pglista=# CREATE OR REPLACE FUNCTION teste(int,float) pglista-# RETURNS record AS ' pglista'# DECLARE pglista'# numero ALIAS FOR $1; pglista'# margem ALIAS FOR $2; pglista'# retorno record; pglista'# ...
    Roberto Rezende de AssisRoberto Rezende de Assis
    May 5, 2005 at 12:36 pm
    May 5, 2005 at 3:00 pm
  • Hi All, Is it possible to change a table from 'WITH OIDS' to 'WITHOUT OIDS' and vice versa or must I DROP TABLE and CREATE TABLE using the desired attributes? Kind Regards, Keith
    Keith WorthingtonKeith Worthington
    May 2, 2005 at 9:09 pm
    May 2, 2005 at 9:27 pm
  • Good day I am an IT student in Switzerland and I am programming on MacOsx. I am intending on building a project with Interface-builder(Cocoa) + Java + Postgres. My question is , what driver / ...
    May 26, 2005 at 8:10 am
    Jun 16, 2005 at 6:39 pm
  • Hi, I do understand the reasons to use transactions and what they do. My problem is the actual usage of transactions in a complex client application. Suppose there are tables: customers (cus_id, ...
    May 31, 2005 at 5:24 pm
    May 31, 2005 at 5:35 pm
  • Hi, after having created my own variable length data type I did not encounter problems... until now: I have two structures: typedef struct statistics { float8 avg; /* average value of timeseries */ ...
    Jessica DittJessica Ditt
    May 31, 2005 at 9:16 am
    May 31, 2005 at 1:56 pm
  • Hello everybody, I have little problems with a function/trigger in Pl/pgSQL. I want to call this function with 2 arguments: - the name of a table - the name of a column So it looks like : CREATE ...
    Vincent CARONVincent CARON
    May 31, 2005 at 10:42 am
    May 31, 2005 at 11:04 am
  • Hi. My question is very simple: How to install under Windows only a "Postgres DBEngine", if exists the possibility, or Postgres without PGAdmin? Bye Francesco.
    May 29, 2005 at 12:20 pm
    May 29, 2005 at 12:28 pm
  • hi all, when i run a pgadmin3 query and select * from a table, shouldn't the " mark appear like this : \" ? right now it is appearing as it is entered. i'm using adodb's qstr() function and i thought ...
    May 26, 2005 at 9:18 pm
    May 26, 2005 at 9:52 pm
Group Navigation
period‹ prev | May 2005 | next ›
Group Overview
grouppgsql-novice @

105 users for May 2005

Tom Lane: 29 posts John DeSoi: 18 posts Operationsengineer1: 17 posts Keith Worthington: 14 posts Tövis: 14 posts D.C.: 13 posts Bruno Wolff III: 12 posts Sean Davis: 8 posts Volkan YAZICI: 8 posts Andreas Kretschmer: 6 posts Celia McInnis: 6 posts Ennio-Sr: 6 posts Walker, Jed S: 6 posts Postgresql Org: 5 posts Bendik Rognlien Johansen: 5 posts Buddy Shearer: 4 posts Frank Bax: 4 posts Havasvölgyi Ottó: 4 posts Kevin Crenshaw: 4 posts Tim Goodaire: 4 posts
show more