sir/madam please, help me to get hold of postgres software for my new installation. .......How to install postgress .......How to install the server...

Justus Mugbeh

06-23-2004 01:15 PM
Josh Berkus

From what I've read, Postgres stores plenty of precision to contain milliseconds. My question is, how do I see the milliseconds? Just doing...

Christopher.Becker@apcc.com

06-21-2004 09:48 PM
Tom Lane

I suppose this is actually an OpenGroupware question, but nothing at that site seems to adequately address the issue. I run Debian, and it kind of...

ghaverla@freenet.edmonton.ab.ca

06-20-2004 07:08 PM
ghaverla@freenet.edmonton.ab.ca

I was reading the o'reilly practical PostgreSQL book and came across the chapter that mentioned the Array Column. I fail to see the scenarios where...

jarednevans@yahoo.com

06-20-2004 03:29 PM
Joe Conway

Hello, I created a database and I would like to know how can I make a copy (on a memory stick) of that database and transfer it on another PC. It's...

Alain-Serge Nagni

06-20-2004 11:58 AM
Alain-Serge Nagni

Is this message the sign of trouble, or is it harmless? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill...

Michael Guerin

06-18-2004 11:17 AM
Tom Lane

I'm tying to estimate the expense of migrating some application from Oracle to PostgreSQL I'm happy to see, that there are many simmilarities in SQL...

Michael Kleiser

06-18-2004 11:06 AM
Bruno Wolff III

Hi, I m porting stored procedures from SQL to PGSQL. I dont know much about PGSQL. I have problems in returning affected rows from the function. I...

Pradeepkumar, Pyatalo

06-18-2004 02:42 AM
Pradeepkumar, Pyatalo

Hi there, My database was created with Unicode encoding, as a fair number of the artists and exhibitions have French names, and thus include...

Lynna Landstreet

06-17-2004 01:32 PM
Lynna Landstreet

Hi I try to do the following in a table that has 4 columns, id - month - day- time The column id is the primary key, for example id - month . day...

Eduardo V. Rodríguez

06-16-2004 03:12 PM
Eduardo V. Rodríguez

hi! I'm trying to make a select query which displays the entries in my table by week of month, each week beginning on a monday and ending on a...

crystal clear

06-14-2004 11:48 AM
crystal clear

Michael Guerin <guerin (AT) rentec (DOT) com> writes: Right, which would make vacuum happy, but you'd be missing some data. (Unless you're fortunate...

Michael Guerin

06-12-2004 03:38 PM
Tom Lane

Hi the "insert into" syntax can degrade a performance in a table whit a big number of row? Or insert 1 row in a table whit 0 row make the same time...

Andreuzza

06-12-2004 11:27 AM
Andreuzza

I downloaded the RPMs for RHLinux9 and have run the upgrade, but now I receive an error about the database format needing to be upgraded when...

Michael A Weber

06-11-2004 03:11 AM
Markus Bertheau

Hi Simple question How do I know the size (in megabytes, gigabytes)of a table? Thank you in advanced ---------------------------(end of...

Eduardo V. Rodríguez

06-10-2004 06:35 PM
Eduardo V. Rodríguez

Hello, I am having problems connecting to postgreSQL from my JSP page. I have followed the instructions from other mailing lists and have started the...

Edgar Saenz

06-10-2004 01:15 PM
Eduardo V. Rodríguez

hi all, I've constructed a simple query which takes too long to finish. EXPLAIN ANALYZE ( all data shown below ) reports that at one stage there are...

Dmitry Karasik

06-10-2004 11:53 AM
Tom Lane

In many other db systems you can use built in functions to check to see if an object exists in the db... For example, in Sybase, you can use the...

Loftis, Charles E

06-08-2004 03:42 PM
Bruno Wolff III

Hi does postgresql have a similar command to SHOW in MySQL. I want to select all tables that match a criteria then select all columns. from those...

Robert Morgan

06-08-2004 09:06 AM
Loftis, Charles E

Ilya, Regrettably, the Wikipedia article is incorrect. It might be nice to have such a feature, but we don't actually have it. I'm not sure...

Josh Berkus

06-07-2004 04:10 PM
Josh Berkus

Hi, Does anyone know of a way to perform an insert that does not abort the transaction if it fails? I am trying to implement a rule that will allow...

Shawn Chisholm

06-07-2004 04:03 PM
Josh Berkus

What's the appropiate command to shut down the Postgres server (postmaster)? Charles Loftis celoftis (AT) unity (DOT)...

celoftis@unity.ncsu.edu

06-07-2004 03:57 PM
Scott Marlowe

On Fri, 4 Jun 2004, Lynna Landstreet wrote: You can drop the constraint and add it again with the additional clause using ALTER TABLE. One warning...

Stephan Szabo

06-06-2004 02:54 AM
Stephan Szabo

Hi there, Does anyone know if it's possible to modify an existing table constraint - for example, to add "ON DELETE CASCADE" to an existing foreign...

Lynna Landstreet

06-05-2004 12:46 AM
Tom Lane

Hi there, I am a newbie, trying to move a pg db from PostgreSQL 7.13 on RedHat 7.3 to PostgreSQL 7.42 on FreeBSD 4.9. The db has one table with...

Chris McCormick

06-04-2004 11:00 AM
Tom Lane

I'm trying to debug some problem in my database that is resulting in an error of the form "Cannot insert a duplicate key into unique index". The...

kynn@panix.com

06-03-2004 11:40 PM
joseph speigle

I want to execute the sql stored in a directory on my system. How do I submit this file, in batch, to pgsql to be...

Loftis, Charles E

06-03-2004 04:58 PM
Joe Erickson

Dear All, I which to insert text (more than 1000 lines) into a single cell of my table, should I use COPY here or INSERT? My reading seems to...

Colin Gillespie

06-03-2004 04:23 PM
Bryan Irvine

"Rajan Bhide" <rbhide (AT) nulinkinc (DOT) com> writes: I'm suspicious that that index is corrupted. Does reindexing it make the problem go...

Tom Lane

06-03-2004 10:43 AM
Tom Lane

Hi there, I am a newbie, trying to move a pg db from PostgreSQL 7.13 on RedHat 7.3 to PostgreSQL 7.42 on FreeBSD 4.9. The db has one table...

Chris McCormick

06-03-2004 09:14 AM
Chris McCormick

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...

Derrick Betts

06-01-2004 08:59 PM
derrick@grifflink.com

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...

Martin Hampl

05-30-2004 06:30 AM
Martin Hampl

Eduardo Vázquez Rodríguez wrote: In recent versions you can specify the columns to import. COPY "Example" ("Name", "Adress") FROM ... or somethign...

Nabil Sayegh

05-30-2004 01:39 AM
Oliver Elphick

Alain-Serge Nagni <akenaton (AT) freesurf (DOT) ch> writes: If you're using IDENT authentication then you can't log in under a Postgres username...

Tom Lane

05-28-2004 04:29 PM
Alain-Serge Nagni

hi, thank you very much for your tips! As your tip: use a char() field instead of a varchar() field. The problem is solved. Thanks! have a good...

xier@in.tum.de

05-28-2004 11:58 AM
Manuel Sugawara

Its ok figured it out was an error in my sql, I had single quotes around the ServicedDate value. Bob ---------------------------(end of...

Robert Morgan

05-27-2004 05:16 PM
Robert Morgan

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...

Robert Morgan

05-27-2004 06:02 AM
Oliver Elphick

hi list, i have a table that is laid out like this: student_id | tally | org_id --------------+------------------ 1 | 0 | 1 2 | 0...

percy

05-26-2004 07:03 AM
Nabil Sayegh

INFO: analyzing "pg_catalog.pg_type" INFO: "pg_type": 5731 pages, 265 rows sampled, 265 estimated total rows INFO: vacuuming...

Michael Guerin

05-26-2004 12:36 AM
Michael Guerin

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,...

hendro

05-25-2004 09:07 PM
Gaetano Mendola

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...

Aarni Ruuhimäki

05-25-2004 02:53 PM
Tom Lane

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...

Glenn_Wiens@via-christi.org

05-24-2004 05:24 PM
Glenn_Wiens@via-christi.org

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...

Rajan Bhide

05-24-2004 03:11 AM
Rajan Bhide

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...

Robert Morgan

05-23-2004 09:34 PM
Manuel Sugawara

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...

ghaverla@freenet.edmonton.ab.ca

05-23-2004 07:31 PM
ghaverla@freenet.edmonton.ab.ca

"Michael A Weber" <mweber (AT) 4wre (DOT) com> writes: And you think this is wrong why? You haven't mentioned creating such a table in schema...

Tom Lane

05-21-2004 10:52 PM
Jeffrey Melloy

I followed your advice (Andrew Hammond), but I was confronted with another problem: I got no prompt … Here follows the output: philippev%...

Philippe Verschooten

05-21-2004 11:20 AM
Tom Lane

How i can transport my postgre database to mysql?

Bizio

05-21-2004 11:11 AM
Manuel Sugawara

Theo Dickinson <Theo.Dickinson (AT) unv (DOT) org> writes: You can compare OLD value with the NEW's one: IF ( NEW.modified_by <> OLD.modified_by )...

Manuel Sugawara

05-21-2004 11:10 AM
Manuel Sugawara

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...

Nick Allan

05-21-2004 11:05 AM
Manuel Sugawara