Hi All, I am trying to load a file into a database. The file in part looks like this. 10000,Citizens Bank Checking Account,0,TRUE 10001,Peoples...

Keith Worthington

10-15-2004 11:07 AM
Keith Worthington

Hi all, I have 3 tables like the following: sample_table: samp_id samp_desc samp_data

Kumar S

10-15-2004 10:29 AM
Tom Lane

Hi, I'm struggling for some time with the following problem: I have a table like this: name key value ------------------------- andi...

Alexander Pucher

10-14-2004 04:02 PM
Michael Fuhr

I'm not sure if there is a way to do this without using a programming language/function ie a for loop for example. Ideally I would like to do it all...

Jake Stride

10-13-2004 07:06 PM
Ron St-Pierre

Hi All, I am running pgAdmin3 and PostgreSQL 7.3.6. How can I tell what users are connected and to what database(s)? Kind...

Keith Worthington

10-13-2004 10:03 AM
Keith Worthington

I have a big MSSQL database, how can I import it into PostgreSQL? I've found that utility PDAdmin has an import plugin but it doesn't work for...

Aleksandar Dezelin

10-13-2004 02:53 AM
Aleksandar Dezelin

Hi All, I need to write a shell script that can be run by cron to automatically load data into a PostgreSQL database. I have been experimenting...

Keith Worthington

10-12-2004 04:21 PM
Ron St-Pierre

Hi All, When using pgadmin I recieved an error that suggest I check the postmaster log for more information. This I would happily do if I could...

Keith Worthington

10-12-2004 05:24 AM
Oliver Elphick

Dear Group, I have two tables: 1. exp_id | exp_name | exp_type | exp_desc |...

Srinivas Iyyer

10-11-2004 04:19 PM
Srinivas Iyyer

Hi all, I have a table something like this.... table Alarm( AlarmId integer, AlarmName varchar, Sentflag smallint, AckFlag smallint, RTNFlag...

Pradeepkumar, Pyatalo

10-11-2004 03:27 PM
Kumar S

Hello all, I am new to postgresql, and have few questions to ask which I hope some kind souls out there willing to help :) 1. How are parameters...

Number One

10-11-2004 04:10 AM
Number One

Hi, I've just started to use PgSQL, and having some trouble with aggregation in SQL. I have a huge-and-growing table described as: current_traffic...

Tamas MEZEI

10-10-2004 08:06 PM
Tamas MEZEI

Dear All, Kindly suggest for following What are the possibilities of having a field with default value from 1. Function 2. Views 3. Rules If ...

V i s h a l Kashyap @ [Sai Hertz And Control Systems]

10-09-2004 12:15 PM
V i s h a l Kashyap @ [Sai Hertz And Control Syste

Hi All, I've just gotten PostgreSQL installed. The problem is now that I have started the postmaster (incorrectly it appears) how do I stop it? I...

Keith Worthington

10-08-2004 04:14 PM
Tom Lane

John Browne wrote: address situations in foreign countries, AFAIK. We use this on some of our databases, but we don't have enough foreign data yet...

John Browne

10-07-2004 02:47 PM
Ron St-Pierre

---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send...

Pradeepkumar, Pyatalo

10-07-2004 04:36 AM
Pradeepkumar, Pyatalo

I'm running postgresql-7.4.3. I have a table that resembles: create table foo ( event_id integer primary key, start timestamp, finish...

Todd Kover

10-06-2004 05:54 PM
Todd Kover

Hello, I've just purchased SuSE 9.1 Professional which uses the YaST package manager to install software and was wondering if anyone has...

phil

10-06-2004 04:16 PM
Joe Erickson

The documentation says: User-defined functions can be written in C (or a language that can be made compatible with C, such as C++). So I suppose...

Zhenchang Xing

10-06-2004 03:42 PM
Tom Lane

i'm new to linux. i started the postgresql 7.3 server in the root using red hat 9 and it says that Postmaster already running. but when i used...

Ramon Orticio

10-05-2004 10:27 AM
stig erikson

I have a need to have an auto increasing field, but I don't think I can use the serial type. I have a table similar to: Jobs ==== Id...

Jake Stride

10-05-2004 09:31 AM
Andreas

The idea is to write it without creating a function... Just as a quick script. Not possible? :( On Sun, 3 Oct 2004 11:21:50 -0400, John DeSoi <jd...

Vitaly Belman

10-03-2004 09:41 PM
John DeSoi

hi every body here is my function to get last day of the month. but it causes error while executing. please help /* This function returns the...

Rajesh nalankal

10-03-2004 10:44 AM
Michael Fuhr

Hi In my crossing from FileMaker to Postgresql, I have a question that so far I can't answer from reading the O'Reilly book. BTW: most of...

Neacal

10-03-2004 10:16 AM
Neacal

Hi I am working on a real time application. I have a table which has 10000 rows and 31 columns.It is updated every 5 secs.But only a max of 5000...

Madhukar Gole

10-02-2004 11:12 PM
Madhukar Gole

On Mon, Sep 27, 2004 at 19:14:09 -0500, "D. Duccini" <duccini (AT) backpack (DOT) com> wrote: The reason this doesn't work is that the timestamp to...

Bruno Wolff III

10-01-2004 05:17 PM
Tom Lane

I'm not sure that pg_ctl is bright enough to handle multiple -o options. You might need -o "-N 40 -B 80" instead. Having said that, though, I think...

Tom Lane

10-01-2004 02:52 PM
Tom Lane

I want to be able to update a value in a table to the existing value plus or minus a value set in a variable without having to read in the...

Christopher A. Goodfellow

09-30-2004 12:58 PM
Oliver Fromme

i'm new to linux. i started the postgresql 7.4 server in the root using red hat 9 and it says that Postmaster already running. but when i used...

Ramon Orticio

09-29-2004 09:56 PM
Ramon Orticio

Hello, This is my first message to pgsql-novice. I create plpgsql function "myfunc(integer)" thats returns of type record with values from table X...

Paulo Nievierowski

09-29-2004 12:57 PM
Devrim GUNDUZ

Dear Group, I have 3 tables where : f_huge = a table with variations. Strictly speaking, the data is not identical, however, keeping aside...

Kumar S

09-28-2004 02:16 PM
Kumar S

I do not seem to be able to get into psql after installing. I am unable to authenticate for user 'postgres.' I am using the password I created...

Taber, Mark

09-28-2004 02:16 PM
Taber, Mark

Hi, I neec help on record-locks and adodb-timeouts. Server: Postgresql 7.4.3 on Cygwin while playing around pg-odbc driver: 7.03.02.09 windows...

Andreas

09-28-2004 12:03 PM
Andreas

PostGreSQL 7.4.5 Not sure if this is the correct list .... We were moving a database between two laptops and used pg_dump / pg_restore to copy a...

Steve Tucknott

09-28-2004 10:25 AM
Steve Tucknott

I have been workong with postgresql for months without problem and did not change anything (I hope so). But now i cannot restart it. Starting...

Reinhard Hnat

09-28-2004 10:04 AM
Tom Lane

Last night our server crashed and now we're getting these cache lookup errors. I've rebuilt the indexes on pg_attribute and pg_class, plus all the...

Michael Guerin

09-28-2004 08:38 AM
Michael Guerin

---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Shawn Chisholm

09-27-2004 10:53 PM
Michael Fuhr

Sorry if this is a re-post, but my posts don't seem to get through ... Hi, I am trying to create a really simple pl/pgsql based function to...

mail

09-27-2004 07:17 PM
Gaetano Mendola

I am having trouble installing PostgreSQL-7.4.5 on Redhat V 8.0. I extracted the files with tar into the directory /usr/local/pgsql When I run the...

Wayne Unruh

09-26-2004 05:04 AM
Kaloyan Iliev Iliev

Dear Group, I have 13 tables with duplication of elements and 14th tables that has all the unique elements of 13 tables. What I do not have in 14th...

Kumar S

09-24-2004 10:11 PM
Kumar S

Dear all This is a quick one. Please guide me to the list of supported PL langauages in PostgreSQL. -- With Best Regards, Vishal Kashyap. Sai Hertz...

V i s h a l Kashyap @ [Sai Hertz And Control Systems]

09-24-2004 05:49 PM
V i s h a l Kashyap @ [Sai Hertz And Control Syste

hi, I am a newcomer to PostgreSQL and SQL as well. I am doing my thesis in university. My topic is about software evolution. So I am often faced...

Zhenchang Xing

09-24-2004 01:34 PM
Zhenchang Xing

Hi Group, I want to copy a view to a output file. => copy test_uniqueprobeset to '/temp/test_uniqueprobeset_focus'; ERROR: cannot copy from...

Kumar S

09-24-2004 12:49 PM
Kumar S

Dear group, I am using COPY for mass upload of my data. I created a table with one coulmn as Create table...

Kumar S

09-22-2004 02:01 PM
Kumar S

In article <414F2471.9050104 (AT) insys-corp (DOT) com.mx>, Eduardo Vázquez Rodríguez <evazquez (AT) insys-corp (DOT) com.mx> wrote: Hola...

Neacal

09-22-2004 12:09 PM
Frank Bax

Hi All.. I am looking into setting up a multi-database system with Postgres7.3.4. In this case all the databases will be on the one server. Initial...

Jonathon Batson

09-22-2004 11:00 AM
brew@theMode.com

On a table update, I want to check for certain conditions in a trigger function, and if a condition is met, NOT ALLOW the update. Not a...

derrick@grifflink.com

09-20-2004 11:05 PM
derrick@grifflink.com

Hi I would like to try and export the db at work (oracle 9i) and use it at home with postgres. I am still a complete noob with both (pretty much with...

Antoine

09-20-2004 07:13 PM
Tom Lane

Hi, any pointers on where I can find information on ECPG and how it functions in a multi threaded environment? thanks - Martin...

Martin Atukunda

09-20-2004 07:06 AM
Bruce Momjian

Hi group, I have an existing table with data loaded. Now I wanted to create a column with SERIAL data type and want to make that coulmn values as...

Kumar S

09-20-2004 12:18 AM
Kumar S