Re: [ADMIN] Ghost insert

1999-12-23 Thread Jan Kim
On Wed, Dec 22, 1999 at 07:51:28PM +0100, Enrique Rodriguez Lazaro wrote: > Hi. > > I am trying to do a interface from a web over my database postgresql > whit libpq. > > I can't do a simple 'insert' from libpq. > > I'm doing this: > > sprintf(temp_string,"insert into clientes > values('fff'

Re: [ADMIN] Getting table structure from script

1999-05-27 Thread Jan Kim
On Thu, May 27, 1999 at 03:46:48PM +0400, @ mdpei Mnbhjnb wrote: > Is there any way to get table structure from perl script > (for instance using Pg). I need it very much, but now have > to use copy/paste algorythm :) Since I don't use Perl, I cannot offer a perl specific solution. General

Re: [ADMIN] PostgreSQL 6.4.2 won't compile on Digital Unix V4.0d

1999-03-11 Thread Jan Kim
On Wed, Mar 10, 1999 at 02:36:46PM +0100, Reiner Dassing wrote: > Jan Kim wrote: [failing int regression tests] > > This looks strange to me -- from replies, which I got from this list > > some time ago, I know that a failing int8 test is not necessarily a > > problem, bu

Re: [ADMIN] configure error with C compiler

1999-03-11 Thread Jan Kim
On Thu, Mar 11, 1999 at 04:50:08PM -0800, Daniel wrote: > I've just downloaded the 6.4.2 source and was trying to install it on RedHat > 5.2 running on Pentium system. When I did > ./configure --with-perl --with-odbc, it failed during compiler check: > >checking whether the C compiler (gcc -O

Re: [ADMIN] PostgreSQL 6.4.2 won't compile on Digital Unix V4.0d

1999-03-08 Thread Jan Kim
On Mon, Mar 08, 1999 at 03:07:09PM +0100, Reiner Dassing wrote: > Hello! > Thank you very much all of you who have given me some hints for solving > my problem of the compilation of PostgreSQL under Digital UNIX V4.0D > > Here are the steps of the successful compilation: > > 1. The option "-E" o

Re: [ADMIN] large database problems

1999-03-05 Thread Jan Kim
On Fri, Mar 05, 1999 at 01:08:21PM -0700, hal Lynch wrote: > I have a tabel I am trying to use but it won't work. Here are the > particulars: > > Digital Unix 4.0E > Postgres 6.3 > DEC 3000 400s > 100M+ memory > 500M swap > 8 gig drive reserved for postgres > With the full 22M records it s

Re: [ADMIN] PostgreSQL 6.4.2 won't compile on Digital Unix V4.0d

1999-03-05 Thread Jan Kim
On Fri, Mar 05, 1999 at 04:10:58PM +0100, Reiner Dassing wrote: > Hello! > As I am new to postgreSQL but not to OSF I do not understand why > PostgreSQL > will not be compiled successfully: > > Here is the excerpt of the Make-Process: > > Starting in ../postgresql-6.4.2/src/interfaces/libpq with

Re: [ADMIN] flex

1999-02-24 Thread Jan Kim
On Wed, Feb 24, 1999 at 03:14:29PM +0100, Isabelle REGINSTER wrote: > I am trying to install postgreSQL. And I have a problem with the > up-dating of flex. My old-version is 2.5.3 and I upgrade with 2.5.4a. > I did'nt find the 2.5.4 version as indicated in the admin guide. > When I run the ma

Re: [ADMIN] Memory fault on Irix 6.4 machines?

1999-02-11 Thread Jan Kim
On Thu, Feb 11, 1999 at 09:26:45AM +0100, Tobias Lehtipalo wrote: > I recently compiled Postgresql 6.4.2. on an SGI machine running > IRIX 6.4. When I tried to initialize the database I got a core dump due to > memory fault. It seems that other people running IRIX 6.4 has had similiar > pro

Re: [ADMIN] maximum attribute record.

1999-02-02 Thread Jan Kim
On Tue, Feb 02, 1999 at 07:33:48PM +0800, Vikrant Rathore wrote: > If your query is bigger than 8192 bytes then libpq simply truncates it > without giving any warning I've read that in the docs, too (while back, didn't try it out). I have to say, though, that I think this behaviouur is somewhat

Re: [ADMIN] [postgresql] problems compiling 6.4.2 on Solaris 2.6 :-(

1999-01-27 Thread Jan Kim
On Wed, Jan 27, 1999 at 02:48:37PM +0100, Nico De Ranter wrote: > I'm trying to install PostgreSQL 6.4.2 on a SUN Ultra-10 > running Solaris 2.6. > > Unfortunately I get the following errors: > > make[2]: Entering directory >`/usr/people/nico.nba/postgresql-6.4.2/src/interfaces/libpq++' > CC

Re: [ADMIN] pgsql 6.4.2 build error

1999-01-13 Thread Jan Kim
On Wed, Jan 13, 1999 at 06:48:54PM +0100, Vincent RUIZ wrote: > ./configure --with-template=linux_ppc --with-tcl --with-perl --with-odbc > -- with-x > gmake all > gcc -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes > -I. -DHAVE_CONFIG_H -fpic -c mis > c.c -o misc.o > misc.c:61

[ADMIN] int8 regression fails on Irix 6.4

1999-01-12 Thread Jan Kim
Dear Postgres Admins, failing to install PostgreSQL 6.4.2 on our Digital Alpha workstations, I tried to get it running on a Silicon Graphics Octane running Irix 6.4. Here, I managed to compile, install and test the basic backend function, but the regression test revealed that the int8 type is bro

[ADMIN] Still no luck on Digital OSF/1 4.0

1999-01-12 Thread Jan Kim
Dear PostgreSQLers, I just installed PostgreSQL 6.4.2 on a Digital Alpha workstation running OSF/1 4.0, but I still have no luck getting the system to run properly. I configured with % ./configure --prefix=/home/zwdv/postgres/postgresql-6.4.2 --with-perl --with-odbc --with-CC='cc -std1' Th

[ADMIN] Cannot run destroydb: ERROR: typeidTypeRelid: Invalid type - oid = 0

1998-12-08 Thread Jan Kim
Hi again, After failing to compile PostgreSQL on our Alpha workstations with egcs, I now switched to the "native" compiler and got a somewhat running system. I can create a database and put something in it (just tried a few numbers), but I cannot destroy it. I get this error message: ERROR:

[ADMIN] Compilation problems on Digital OSF1 4.0

1998-12-08 Thread Jan Kim
Dear PostgreSQLers, I try to build the new PostgreSQL v6.4 on our Alpha workstations running OSF/1 4.0 with egcs-2.91.57 19980901 (egcs-1.1 release). The INSTALL file says there are "minor patchable problems". However, I'm not sure how to patch this one: The sources seem to assume that slock_t c