Hi I have a form that inserts data to the DB. One field is timestamp type this field is not always filled out but postgres wont accept '' or null and...

Robert Morgan

05-21-2004 02:12 AM
Colin Gillespie

Hi, I've heard about PGSQL for years but I just have the chance to try it out. My major problem is working with functions. (previously I use...

hendro

05-20-2004 09:37 PM
hendro

Hi all, We are trying to do a dump of our database using the command line. However, the dump falls over during a dump of a particular...

Noel Faux

05-19-2004 08:20 PM
Noel Faux

I am running Suse 9.0 and have been working with postgresql 7.3.3 When I run psql as psql -v or psql -V and even psql --help I get a relocation...

w00t

05-19-2004 01:51 AM
w00t

I am getting the following error on my server psql: relocation error: /usr/lib/libreadline.so.4: undefined symbol: BC I have a symbolic for...

Chris

05-18-2004 07:53 PM
Chris

I am getting the following error on my server psql: relocation error: /usr/lib/libreadline.so.4: undefined symbol: BC I have a symbolic for...

Chris Odle

05-18-2004 07:52 PM
Chris Odle

Hello, I have been installing version 7.4.2 of postgresql through different channels on my PowerBook G4 (OS X 10.2.8). The installation was each...

Philippe VERSCHOOTEN

05-17-2004 03:11 PM
Andrew Hammond

Hi, I've upgraded to SuSE9.1 which installs PostgreSQL 7.4.2. I cannot seem to connect to a local database using DBVisualizer, which worked...

Bob Jarman

05-17-2004 08:44 AM
Andrew Hammond

TIA to anyone who reads all the way through this. I'm continuing to work on the database design for my super-, duper-, uber-web jukebox. One of my...

Ian Pilcher

05-15-2004 02:49 PM
Ian Pilcher

Hello Forum, I am having a table with UNIQUE constraints defined on three columns. Also I have UNIQUE user defined INDEX with the same columns on...

Rajan Bhide

05-14-2004 07:45 AM
Oliver Fromme

I have to rewrite a query after beeing parsed by gram.y but before any transformations are applied to my SelectStmt structure in analyze.c. Therefore...

Matthias Lenz

05-13-2004 06:10 AM
Matthias Lenz

Hello, I am currently working on a solution to set up PostgreSQL on Mac OS X Server 10.3.3 and I want to enable ODBC support so that our client...

Stephan Hochhaus

05-12-2004 08:51 PM
Ted Thibodeau Jr

Saludos!!! Quisiera que alguien me ayudara a resolver el problema de concectar el PgAccess a Postgresql en Mandrake Linux 10.... así como un sitio...

Sandro Martinez

05-12-2004 11:34 AM
joseph speigle

I understand that PostgreSQL has OO capabilities. Is it possible to store full-blown Perl objects in a PostgreSQL table? (I suppose that one can...

kynn@panix.com

05-12-2004 11:18 AM
joseph speigle

Apologies in advance if this is a dupe.... Sorry if this is a FAQ. My Google skills are failing me. I'm in the initial stages of designing a...

Ian Pilcher

05-12-2004 09:51 AM
Ian Pilcher

Hello everyone! My name is David Cruz, and I'm from Bogota, Colombia. I'm Beggining with PostgreSQL, so I've been doing just a few simple...

David Cruz

05-10-2004 10:38 AM
David Cruz

Hello, I just want to install the latest PostgeSQL database server (7.4.2). am running a Red Hat Fedora Core 1 OS, and I just found a...

MagnuM

05-10-2004 03:28 AM
MagnuM

On Sat, Feb 07, 2004 at 14:01:42 -0600, Reshat Sabiq <sabiq (AT) purdue (DOT) edu> wrote: You can make updateable views now using rules. There has...

Nabil Sayegh

05-09-2004 10:18 AM
Bruno Wolff III

Hi! Is there somewhere statistical extensions to postgresql? -- Tomka Gergely Tudom, anyu. Sapka, sál, doksi. ---------------------------(end of...

Tomka Gergely

05-09-2004 09:57 AM
Tomka Gergely

Dear All, I successfully installed 7.4.2. However when I was forced reboot my computer and tried to access a database I received the...

JamesW

05-08-2004 08:22 AM
JamesW

I've had a fair amount of experience with the old dBase programs and the Clipper programming language. Now I'm getting my feet wet with...

Gary G. Taylor

05-07-2004 11:22 PM
Gary G. Taylor

My first post! Hello to all. I'm using Postgres 7.4.2. I compiled it without changing any server parameter. I'm trying to do a bulk of 90 inserts in...

Carlos Barroso

05-07-2004 12:19 PM
Tom Lane

Hi, I have a problem with running a psql command from within my java application. I am pretty sure it is a syntax problem, but the same command run...

Pei-Chieh Shen

05-06-2004 08:03 PM
joseph speigle

=?iso-8859-1?Q?Gast=F3n_Simone?= <gaston (AT) apraful (DOT) com.uy> writes: It does. But see the WITH HOLD option of DECLARE CURSOR. Note using...

Oliver Fromme

05-06-2004 08:22 AM
Oliver Fromme

This is a pretty specific scenario, so I'm not sure if anyone has anythoughts or not. I've got a delphi app connecting to a postgres server (with...

Christopher.Becker@apcc.com

05-05-2004 10:21 AM
Christopher.Becker@apcc.com

This seems pretty clear, but I wanted to ask in case I'm missing something. Given a pg_hba.conf with the single entry of local all md5 and the...

Andrew Kelly

05-05-2004 08:48 AM
Andrew Kelly

Im trying to create a function and i just cant get it right. So I've made a "basic" function which works: CREATE FUNCTION test(integer) RETURNS...

Ed&Debbie van Hek

05-05-2004 08:23 AM
Ed&Debbie van Hek

Hi, I hope this message won't be sent several times to the list. If so, please accept my apologies. It would be very nice, if someone could have a...

Martin Hampl

05-05-2004 08:13 AM
M. Bastin

Trying to run this query: UPDATE tblMonitor SET Make = 'Phillips' WHERE Make = 'Ph*'; get the error message that " Error: relation "tblMonitor"...

Robert Morgan

05-03-2004 09:44 PM
Stephan Szabo

Is there any way to restore a SQL Server 2000 database for use on PostGreSQL? Thanks, Chari L. Clark Database Administrator National Background...

Chari Clark

05-03-2004 03:20 PM
Chari Clark

I posted this 3 hours ago but haven't seen it in the messages so am reposting( in case other post shows up) Thankyou to all the people who have...

Robert Morgan

05-01-2004 09:44 AM
David Filion

Jeff Deroshia <jeff (AT) hal (DOT) physast.uga.edu> writes: A persistent client connection. If you want to kick out active clients, you need (IIRC)...

Tom Lane

04-30-2004 11:08 PM
Tom Lane

Is there any possible way to do a SQL query to return some sort of representation of how large the entire db is? Or even how large a single table...

Christopher.Becker@apcc.com

04-30-2004 01:17 PM
Adam Witney

Back again,I still cant access the dbms I have created the user postgres and started postgres. # su postgres bash-2.05b$ /usr/local/pgsql/bin/pg_ctl...

Robert Morgan

04-29-2004 02:02 AM
Andrew Kelly

Thankyou to all the people who have taken the time to reply my posts, unfortunately nothing has worked. I have removed postgresql and reinstalled...

Robert Morgan

04-28-2004 11:40 PM
joseph speigle

This problem occurs when running postgres locally on win2k , psql was running ok but now when typing: c:\>psql psql -d template1 c:\>psql -U...

Carla

04-28-2004 10:06 PM
joseph speigle

Hi thanks for your previous replies, I decided to remove the RH embedded postgresql and install from source which I have done and as far as I can...

Robert Morgan

04-28-2004 09:15 AM
joseph speigle

I have the following scenario, and I'm sure many others have wished to do something similar. I perform an insert into a table where one field is...

Daniel Whelan

04-28-2004 02:09 AM
Bruno Wolff III

There are many posts about "...FATAL: Could not create shared memory segment. Function not implemented..." when trying initdb using cygwin, but...I...

Skidew8@cs.com

04-28-2004 12:00 AM
Tom Lane

David Ayers <d.ayers (AT) inode (DOT) at> writes: No, but it is dependent on the DateStyle configuration variable ... regards, tom...

Tom Lane

04-27-2004 11:55 PM
Tom Lane

Hi everyone, Probably a bit of a basic config problem but any help would be really appreciated I can currently log in fine to psql like so, #psql...

chrisstrachan_at_msn.com

04-27-2004 11:51 PM
Tom Lane

Hi have just installed postgres and tried to open it using: psql template1 postgres and get an error ident authentication failed. How do I open the...

Robert Morgan

04-27-2004 09:36 PM
joseph speigle

Hi I am running postgres locally. All was working well. I can start postgres using the command line which says: but when I type in the...

Carla

04-27-2004 06:10 PM
joseph speigle

Hi, I have a postgresql database with a web interface and I need to check that the data being entered is valid for the field. I am using PHP for...

Robert Morgan

04-27-2004 06:08 PM
joseph speigle

I have a table with a field set to character varying (255). When an insert is executed with a value for this field greater than 255 characters,...

Christopher A. Goodfellow

04-27-2004 12:38 PM
Bruno Wolff III

Hi, I successfully created my first db, a table and some data with psql 7.3.6. However, I can't access the information_schema. In psql I...

f.kater

04-26-2004 01:58 PM
Stephan Szabo

Martin Atukunda wrote: You didn't mention your Postgres version. If it's 7.4.x, this will work: create table filters (name varchar(64), filter...

Joe Conway

04-26-2004 12:31 PM
Joe Conway

Hi, I attempting to figure out how many connections are open to my database. I'm asking because I'd like to keep track of the connection...

John Fabiani

04-26-2004 02:20 AM
Oliver Fromme

I trie to run pgsql 7.3.4-11 with Fedora Core 1. When i updated to kernel-2.4.22.2188.nptl, postgresql dont run anymore. The services windows tell me...

ahermosi@lonquensur.cl

04-24-2004 11:16 AM
Devrim GUNDUZ

I have the following situation: Test database inside our network, accessed with pgAdminIII. When I INSERT records into a table (3000-5000 in one...

Derrick Betts

04-23-2004 02:44 PM
Josh Berkus