How do I install PostgreSQl 8 on Debian? Any help will be appreciated. Thanks

Whitehorseq

03-17-2005 07:00 AM
Whitehorseq

I define a function CREATE OR REPLACE FUNCTION my_function(n varchar) RETURNS void AS $$ DECLARE ... BEGIN ... END; $$ LANGUAGE plpgsql;

autogoor@yahoo.com

03-17-2005 02:42 AM
autogoor@yahoo.com

Here is a old, but well written comparsion between Oracle and PostgreSQL: http://det-dbalice.if.pw.edu.pl/ttraczyk/db_compare/db_compare.html

Alfred R. Baudisch

03-16-2005 12:02 PM
Erwin Moller

Hello. I have installed a PostgreODBC version 8.00.0100 on a Windows 2000 machine. I am using this driver to acess a PostgreSQL 7.3.4 database on a...

Killerman

03-14-2005 07:33 AM
Killerman

Hi, I tried to install Postgresql 8.0-beta2-dev3 on Windows 2000. Already during installation i got messages like that: Failed to connect to...

Gerhard Würth

03-12-2005 07:24 PM
Gerhard Würth

I'm really confused. I had a server to my localhost Win2k machine (8.0.0-rc5.2) in pgAdminIII earlier this evening. I monkeyed with the password...

Randy Yates

03-09-2005 09:47 PM
Randy Yates

New type of data mining Run URL's in every combination lost infromation in every infinte order of numbers letters - and _ .org ..net .com .tv .mil...

zetasum

03-07-2005 03:46 PM
zetasum

Can I use XPath queries in any form to retrive data from XML documents and 'transfer' them to table-like sets? Something as MSSQL's OPENXML...

Mario Splivalo

03-03-2005 02:59 AM
Mario Splivalo

Dear group, I got excellent help here a while back in optimizing a slow query, so I thought I'd try again with another one... I have a small table,...

rdnews@dahlsys.com

02-23-2005 07:01 PM
rdnews@dahlsys.com

Hello, I am trying to get a trigger to fire when a record is deleted that will record the deleted record in a history file. Here is the trigger...

Rick Casey

02-23-2005 04:42 PM
Rick Casey

Hey all, First off I am new to postgres and multi-lingual development so pardon me if the answer is overly obvious. We our database is setup for...

Douglas Lochart

02-23-2005 09:17 AM
Douglas Lochart

i am using a regular expression in a select statement inside a function. how do i dynamically insert a variable into the regexp? eg. SELECT string...

-

02-19-2005 05:45 AM
Stu

Gary L. Burnore <gburnore (AT) databasix (DOT) com> wrote in news:co0b1q$5n5$2 (AT) blackhelicopter (DOT) databasix.com: Gary, why do your posts...

Marc G. Fournier

01-30-2005 01:40 PM
Randy Yates

Hi All! I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro) but I'm not quite sure which way to go. I have a few books on...

SmoothJazz

01-29-2005 01:17 PM
SmoothJazz

Hi, First of all I'd like to say that 8.0 is a great piece of software, and I've been looking forward to installing 8.0 for quite some time...

Jan Szumiec

01-25-2005 06:32 PM
Jan Szumiec

hi, could someone please tell me how do I get a query to show the (*) fields in table2 only when table2.field1 exist in table1.field1 thanks in...

Jenny

01-21-2005 11:52 AM
Jenny

I just installed postgresql 7.4.5 and pgadmin3 1.0.2 on FreeBSD and noticed that pgadmin allows the pgsql user to log in while ignoring the...

John French

01-16-2005 01:41 PM
Nikolay A Mirin

I'm just learning the libpqxx library and it appears to say that it is built on top of libpq. So I'm trying to locate libpq so I'll have access to...

Randy Yates

01-13-2005 02:21 AM
Randy Yates

I searched for the latest on adding the Oracle-like feature called partitioning - a nice feature for tables that grow and grow, when you still need...

boyd

12-20-2004 11:24 AM
boyd

hello! does anybody know how well the pg extension in PHP for PostgreSQL supports UTF-8 character sets? functions such as pg_escape_string would be...

Mark

12-15-2004 07:17 PM
Mark

Hi, i'm trying to save images on a postgres db. I created a table like this: CREATE TABLE image(name text, image oid); and I inserted in it a file...

Luca

12-12-2004 01:02 PM
Luca

My company has a product in beta which uses Postgres 7.4.3. We expect to have a code freeze for our 1.0 product in March 2005. I'd really like to use...

jao@geophile.com

12-10-2004 11:42 PM
Bo

In news.groups, Gary L Burnore <gburnore (AT) databasix (DOT) com> writes: I'm not completely sure you understand what effect this has. Note...

Russ Allbery

11-23-2004 08:16 PM
Kenneth Downs

Hi, struggling around with this for some time: How can I use a table name as a parameter in a PL/pgSQL function ?? I tried this but it didn't...

Alexander Pucher

11-23-2004 04:16 PM
Timothy Perrigo

Ennio-Sr <nasr.laili (AT) tin (DOT) it> writes: It's pretty much impossible to believe that that's what came out of pg_dump originally, because "-"...

Tom Lane

11-23-2004 02:37 PM
Tom Lane

I know there is a command to add the column. I want to back up the table before I alter it. What is the best way. It has a couple indexes and...

Krause, Lewis

11-23-2004 02:16 PM
Krause, Lewis

Jerry LeVan <jerry.levan (AT) eku (DOT) edu> writes: Afraid not. When in doubt, the authoritative answer for such questions can be found by...

Tom Lane

11-23-2004 11:21 AM
Tom Lane

I guess the subject says it all, can I install the B5 release to a B4 db without starting from scratch? Jerry ---------------------------(end of...

Jerry LeVan

11-23-2004 11:04 AM
Michael Fuhr

Hello, I have a table with a timestamp column and I want to set this to a value of now() - a random number of days between 0 and 45 for each row......

Net Virtual Mailing Lists

11-23-2004 09:03 AM
John DeSoi

Hi all, I have three questions about 1 table CREATE TABLE public.logs ( rule_name varchar(32) NOT NULL, bytes int8 NOT NULL, pkts int8 NOT NULL,

Joost Kraaijeveld

11-23-2004 07:25 AM
Jim Seymour

Patrick May <pjm (AT) spe (DOT) com> wrote in news:m2r7mk24uv.fsf (AT) gulch (DOT) intamission.com: If they were to start their own hierarchy...

Woodchuck Bill

11-23-2004 06:50 AM
Woodchuck Bill

Hi, Is it possible for the COPY command to read data from a file, but skip specific columns? Thanks Adam

Adam Witney

11-23-2004 05:46 AM
Adam Witney

Robert McClenon <robert.mcclenon (AT) verizon (DOT) net> wrote in news:e385q09i20k6853s949t8pdfjr26u87ran (AT) 4ax (DOT) com: Have a...

Woodchuck Bill

11-23-2004 05:43 AM
Woodchuck Bill

Thanks for the insight Thomas and Gregory. I think I can make a work around. Phil ---------------------------(end of...

phil campaigne

11-23-2004 05:41 AM
Net Virtual Mailing Lists

I am currently creating a database with less than 20 simple tables (only SQL 92 types, simple constraints, no PostgreSQL specific stuff, no...

matthias@cmklein.de

11-23-2004 02:55 AM
Karsten Hilbert

On Saturday 20 November 2004 02:39, Marian D Marinov wrote: I am not sure about a SQL Query. But if you login to the database using the command...

Quinton Delpeche

11-23-2004 12:10 AM
John DeSoi

Its been almost 4 weeks since Beta4, and alot of work, involving alot of bug fixes, and documentation improvements, to the source tree, we have just...

Marc G. Fournier

11-22-2004 10:28 PM
Marc G. Fournier

Occasionally I want to store a null value for my java.sql.Time--> Time column in Postgresql. update event set game_clock=null where event_id=1; I...

phil campaigne

11-22-2004 05:32 PM
phil campaigne

I am trying to figure out how I can change the default operator class of the index created for my primary key field. Is it even possible since I am...

Sally Sally

11-22-2004 04:45 PM
Sally Sally

Hello all, I have a database system in which i truncate a main table to update the information. I would like to setup some foriegn keys referencing...

Dev

11-22-2004 04:38 PM
Dev

Hello all, Anyone has perl DBI working with Postgres 8-beta on Windows. I get the following error when i compile. I have POSTGRES_LIB...

Goutam Paruchuri

11-22-2004 04:33 PM
Goutam Paruchuri

Hi ! I've just inherited the responsibility of a postgresql database of roughly 480 tables and 6460 columns, mainly without constraints, not even...

David Pradier

11-22-2004 03:49 PM
Bill Harris

I've look for a solution to this, but have only been able to find solutions to delete duplicate entries in a table by deleting entries not returned...

Kall, Bruce A.

11-22-2004 01:14 PM
Edward Macnaghten

New to Postgres 7.3 from 7.0. Am having some trouble with a query that worked in 7.0 but not in 7.3.....can't seem to figure out the syntax or find...

Scott Nixon

11-22-2004 11:44 AM
Scott Nixon

Hi, Given the Oid restype of a Resdom "object", is there any system table I could query in order to retrieve the text representation of this...

Katsaros Kwn/nos

11-22-2004 11:00 AM
Tom Lane

Here's an interesting discussing about storing every possible scrabble board: http://www.livejournal.com/users/stenz/117914.html Note that PostgreSQL...

Jim C. Nasby

11-22-2004 10:58 AM
Jim C. Nasby

I'm trying to use tsearch2 with database which is in 'UNICODE' encoding. It works fine for English text, but as I intend to search Polish texts I...

Dawid Kuroczko

11-22-2004 08:48 AM
Oleg Bartunov

Hi, we saw the following problem: We deleted all rows from a table B referencing table A (~500000 records). No problem, but the following try to...

Cornelius Buschka

11-22-2004 06:33 AM
Cornelius Buschka

Suppose I have vacuum_values() function, which removes all "no longer referenced" by parent column. Kind of function to be run from time to time to...

Dawid Kuroczko

11-22-2004 05:30 AM
Dawid Kuroczko

Hi, I have windows app written in Borland C++ Builder 5.0. Using ODBC driver windows app connects to database on linux server. Database is created...

Alex Guryanow

11-22-2004 03:11 AM
Alex Guryanow