Search Discussions

92 discussions - 329 posts

  • Hi All, I have a number of tables in my database where the key is an int4 into which I place a unique sequential number. I have learned from part experience (although not on pgsql) not to use ...
    Gary StainburnGary Stainburn
    Dec 6, 1999 at 5:52 pm
    Dec 10, 1999 at 3:10 am
  • Howdy, We're haing fun creating rdo dsnless connections in Visual Basic. Works really cool cept for one itsy problem... What is the flag that tuns off the read only attributes of the odbc driver? ...
    Robert HiltibidalRobert Hiltibidal
    Dec 20, 1999 at 7:49 pm
    Jan 7, 2000 at 2:09 pm
  • Howdy, This sounds simple yet i haven't found a way to do this except thru perl scripts.... I have two databases, crossover and crbak crossover is the production database and crbak is the development ...
    Robert HiltibidalRobert Hiltibidal
    Dec 3, 1999 at 2:21 pm
    Dec 3, 1999 at 3:12 pm
  • For the past few weeks we've been developing an open source Java transaction monitor. Our RDBMS of choice is PostgreSQL and we're using Peter's JDBC driver, which works for us. In order to use JDBC ...
    Assaf ArkinAssaf Arkin
    Dec 8, 1999 at 12:54 am
    Dec 10, 1999 at 7:30 am
  • Hi all, I'm relatively new to postgres amd I'm attempting to use large objects to store and play-back messages directly from the database . I have a number of problems/questions/issues : 1) Whenever ...
    Charles RandleCharles Randle
    Dec 6, 1999 at 9:37 am
    Dec 6, 1999 at 4:09 pm
  • I just installed pgadmin 6.5.4. When I start it it asks for a Datasource where I choose the postgresql ODBC driver. I also enter my postgres user as user. With M$ Access this setup works. However, ...
    Michael MeskesMichael Meskes
    Dec 22, 1999 at 2:49 pm
    Dec 23, 1999 at 8:40 am
  • 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 ...
    Enrique Rodriguez LazaroEnrique Rodriguez Lazaro
    Dec 23, 1999 at 9:01 am
    Dec 23, 1999 at 6:38 pm
  • Hello, I am using Postgres-6.5 as my database. I have to create and query db using Java (with JDBC). I am using P-III with 128 MB of RAM. Consider that following data structure is being stored in db. ...
    Dec 4, 1999 at 3:11 am
    Jan 7, 2000 at 1:26 pm
  • Hi folks, is anyone able to explain the following error-message extracted from the "server.log"? -- ERROR: AllocateFile: too many private FDs demanded -- pq_recvbuf: unexpected EOF on client ...
    Rolf LütteckeRolf Lüttecke
    Dec 1, 1999 at 8:42 am
    Dec 6, 1999 at 9:54 am
  • subsribe end
    Dec 1, 1999 at 2:45 pm
    Dec 27, 1999 at 11:41 am
  • I'm not sure if I'll get that one sorted for 7.0, but I was planning on rewriting the JDBC2 version of ResultSet to use cursors, and reducing the fetch size from the current "All Rows in the result". ...
    Peter MountPeter Mount
    Dec 7, 1999 at 8:03 am
    Dec 8, 1999 at 8:28 pm
  • Morning, Our Crossover project seems to have presented another test production error. Last I wrote was how does one get data from one database to another from within Postgres. This time I have data ...
    Robert HiltibidalRobert Hiltibidal
    Dec 3, 1999 at 3:34 pm
    Dec 3, 1999 at 4:28 pm
  • Hi, I am using ecpg to manipulate the whole row in a table,and I have a problem in array, can anybody give me a hint or a small test program to process array? First of all , I create a table(trdday) ...
    S.F. LeeS.F. Lee
    Dec 27, 1999 at 8:02 am
    Dec 29, 1999 at 8:26 pm
  • Hi, Some people asked me to build PostgreSQL binaries for Windows NT. The binaries(PostgreSQL-6.5.3) are now available at: Please go to my page if ...
    Kevin LoKevin Lo
    Dec 21, 1999 at 3:30 pm
    Dec 22, 1999 at 8:04 am
  • Hi, I know you've read this all before, as I went through most postings concerning this issue. But I haven't found a reply that helped me, so I hope I'll get one this way. I want to hook up Microsoft ...
    Christian HangChristian Hang
    Dec 7, 1999 at 9:54 pm
    Dec 9, 1999 at 2:52 pm
  • This is what I am trying to do: 1) I am using Linux (RH 6.1 kernel 2.2.12-20) 2) I have a StarOffice running installation, which has been successful in connecting to a commercial SQL database using ...
    Franz FortunyFranz Fortuny
    Dec 2, 1999 at 6:16 pm
    Dec 7, 1999 at 7:07 am
  • Hi, Is there any example code that I can look at to see how to use PostgreSQL's JDBC Object Serialization extensions? Would some one also please tell me where I can find the source code for the JDBC ...
    Dec 22, 1999 at 9:10 am
    Dec 23, 1999 at 12:04 pm
  • I just used pgaccess for the first time and i have to say I'm impressed. But there is one problem I have encountered. Why isn't it possible to create a report from a view? I defined the query I like ...
    Michael MeskesMichael Meskes
    Dec 13, 1999 at 11:08 am
    Dec 13, 1999 at 4:46 pm
  • Hi all, I'm trying to persist some Java objects in a PostgreSQL database using JDBC (2.0). I get the following error: Fri Dec 10 11:26:15 PST 1999 - [copyright] EJBoss - The EJB Open Source Server ...
    Joe ShevlandJoe Shevland
    Dec 10, 1999 at 12:33 am
    Dec 10, 1999 at 12:00 pm
  • PQftype and FieldType libpq/libpq++ functionsd return the field type. The documentation refers to the return value as being an internal coding of the type. Is there a list of internal codes so it is ...
    Dec 6, 1999 at 2:02 pm
    Dec 6, 1999 at 3:46 pm
  • It seems someone is resending messages to the list. Is anyone else seeing this? I have an extra Delivered-To: line in my headers on the second message: Delivered-To: co_force-comodo-stuart@comodo.net ...
    Vince GonzalezVince Gonzalez
    Dec 6, 1999 at 9:42 am
    Dec 6, 1999 at 9:42 am
  • Hello world, I'm developing a library database with 6.5.3, frontend is Access. I use Massimo Lambertini's functions for referential integrity. My problem is: How can I find out what went wrong, if ...
    Christian UllrichChristian Ullrich
    Dec 3, 1999 at 3:12 pm
    Dec 3, 1999 at 3:12 pm
  • I'm new to both PostgreSQL and ecpg (Embedded SQL), and examinig ecpg example programs. I can see such lines like below in test2.pgc: As far, I know the differences between the normal one and the ...
    Dec 3, 1999 at 2:29 pm
    Dec 3, 1999 at 2:29 pm
  • Is there a category 4 driver (pure java) available for postgres? Thanks! Phillip
    Phillip RhodesPhillip Rhodes
    Dec 31, 1999 at 6:59 pm
    Dec 31, 1999 at 10:37 pm
  • Hi, I am porting an application from Win NT to Linux. It is an application for storing, querying, subsetting and exporting geographic data. On NT the data is stored in MS SQL Server, database access ...
    Eliot ClineEliot Cline
    Dec 21, 1999 at 7:47 am
    Dec 22, 1999 at 11:00 pm
  • I have installed onshore-timesheet on my machine. It works like a char. No I tried to access the database via M$ Access and found some problems. The ODBC connection is up and running. However, Access ...
    Michael MeskesMichael Meskes
    Dec 20, 1999 at 2:28 pm
    Dec 21, 1999 at 11:05 am
  • I am using the current psqlodbc driver (6.40.0007) with Access97 to communicate with a Postgresql server (6.5.3) running on a Solaris platform. The Postgres server has been working fine; I have a ...
    Kelvin O. LimKelvin O. Lim
    Dec 13, 1999 at 4:54 pm
    Dec 20, 1999 at 5:05 pm
  • Hello all, I wonder if anyone could help me. I'm currently working on a project where it is essential that we have some kind of replication of our production database. I've found a number of 'near' ...
    Paul BreenPaul Breen
    Dec 16, 1999 at 2:34 pm
    Dec 16, 1999 at 5:27 pm
  • I asked about this on the PHP list but no-one seemed to know what could be causing the problem. I'm setting up a Web-enabled database using PostgreSQL 6.5.3 and communicating with it via PHP 3.0.12 ...
    David OsborneDavid Osborne
    Dec 13, 1999 at 10:11 am
    Dec 14, 1999 at 2:24 pm
  • Hello all, I am looking for examples of working ECPG code. Partly I would like to see for myself how it works, but I would also be willing to write some documentation on it, which I would be willing ...
    Martin JacksonMartin Jackson
    Dec 11, 1999 at 8:32 pm
    Dec 13, 1999 at 8:53 pm
  • Has the "can't open table in datasheet view" problem with Access 2000 been fixed? I'm using the most current ODBC driver I can find (x.y.0006) from the insightdist.com site, but I still get this ...
    Brune, CharlieBrune, Charlie
    Dec 12, 1999 at 8:18 pm
    Dec 13, 1999 at 5:59 pm
  • Hello I wanted to be sure that a table exist before making a request such as "select * from $table" because it display something like Warning: PostgresSQL query failed: ERROR: prout: Table does not ...
    Edouard DESSIOUXEdouard DESSIOUX
    Dec 13, 1999 at 4:21 pm
    Dec 13, 1999 at 5:09 pm
  • Hi! I'm considering using postgreSQL via the libpq interface with an application I'm developing in C. I tried compiling one of the example programs (the first one) from the libpq documentation. I ...
    Emil MalmbergEmil Malmberg
    Dec 13, 1999 at 9:03 am
    Dec 13, 1999 at 9:46 am
  • WinNT 4.0, ODBC 6.40.0007. I have a table create table test ( a decimal(9,2), b decimal(9,2) ); Now, if I do select a-b as c from test; ODBC driver returns 255 for column width. Same thing for any ...
    Gene SokolovGene Sokolov
    Dec 9, 1999 at 10:06 am
    Dec 10, 1999 at 1:16 pm
  • I have followed the steps and created the jar file. I have changed classpath to use the current directory and the postgresql.jar file. I am able to compile the example (JDK 1.1.7) but when I invoke ...
    Balajee ShrikanthBalajee Shrikanth
    Dec 5, 1999 at 3:18 pm
    Dec 6, 1999 at 9:42 am
  • Jeroen Schellart UnO Automatiseringdiensten BV 1e van der Kunstraat 292 2521 AV Den Haag tel: 070-3300502 fax: 070-3300489
    Jeroen SchellartJeroen Schellart
    Dec 2, 1999 at 11:58 am
    Dec 31, 1999 at 8:31 pm
  • Howdy, I'm try to do a search on users from one database against a table in another. Both databases have a mixture of upper and lowercase characters. Is there a way to tell postgres to consider a ...
    Robert HiltibidalRobert Hiltibidal
    Dec 29, 1999 at 3:09 pm
    Dec 29, 1999 at 4:01 pm
  • How come boolean values return by the jdbc drivers come as a String of value "t" instead of a Boolean?
    Joseph ShraibmanJoseph Shraibman
    Dec 28, 1999 at 12:46 am
    Dec 28, 1999 at 12:07 pm
  • All, When writing apps using 'c' and the preprocessor, I always get a "NOTICE: BeginTransactionBlock not in default state" with my first BEGIN statement. I've tried placing a COMMIT and END at the ...
    Robert RotheRobert Rothe
    Dec 23, 1999 at 8:53 pm
    Dec 24, 1999 at 10:03 am
  • In light of the problems discovered with today's release of pgAdmin 6.5.4 when running under Windows NT, I have released v6.5.5 at http://www.pgadmin.freeserve.co.uk/ If you have v6.5.4 running ...
    Dave PageDave Page
    Dec 22, 1999 at 8:17 pm
    Dec 23, 1999 at 8:40 am
  • Hi all, when I call the update method of my recordset, I receive the following error message: "Only SQL_POSITION/REFRESH is supported for SQLSetPos". Help me, please... thanks in advance. Ericson ...
    Ericson Nunes FerreiraEricson Nunes Ferreira
    Dec 21, 1999 at 7:32 am
    Dec 21, 1999 at 7:37 am
  • Hello, I just thought I should bring this to the attention of the mailing list. About a week ago I posted a problem I was having with Microsoft Access 97 and the PostgreSQL ODBC driver (6.40.0006) ...
    Mike MascariMike Mascari
    Dec 20, 1999 at 7:11 am
    Dec 20, 1999 at 1:18 pm
  • I'm putting together my first C++ pgsql client program and have run into a snag. I #include <pgdatabase.h , but when I compile, I get a message saying /usr/include/pgsql/libpq++/pgconnection.h:24: ...
    Dec 15, 1999 at 6:45 pm
    Dec 15, 1999 at 9:10 pm
  • In the process of cleaning up some memory leaks in the cvs tree, I discovered that the checked in version of ecpg interperates < as =: For example, if you run ecpg on the following: test() { exec sql ...
    Stephen BirchStephen Birch
    Dec 14, 1999 at 8:21 pm
    Dec 15, 1999 at 9:42 am
  • I'm seeing a few intermittent show-stopper errors (some of which I've asked about previously in these forums) which go away after vacuum is run. Pgsql documentation recommends to vacuum nightly or ...
    Ed LoehrEd Loehr
    Dec 13, 1999 at 6:36 pm
    Dec 13, 1999 at 11:23 pm
    Dec 12, 1999 at 7:27 pm
    Dec 12, 1999 at 8:48 pm
  • This probably sounds horribly trivial, but still... I've managed to get some duplicate records in a table and am having problems getting rid of them (as there's nothing unique to SELECT on). Any ...
    Paul S. GanneyPaul S. Ganney
    Dec 7, 1999 at 4:46 pm
    Dec 7, 1999 at 6:02 pm
  • Hi, Having just read the results of the post concerning INSERT times, I thought I should ask a related question that has been causing me some problems. I have a servlet which performs a SELECT which ...
    Simon HardinghamSimon Hardingham
    Dec 6, 1999 at 2:35 pm
    Dec 6, 1999 at 3:06 pm
  • A while ago I asked about enabling locale for the paostmaster: Somehow I seem to have missed the answer. Or no one answered. :-) But since I got a bounce message from one address it may be this mail ...
    Michael MeskesMichael Meskes
    Dec 3, 1999 at 4:17 pm
    Dec 3, 1999 at 4:17 pm
  • I noted on the Postgresql JDBC web site that the latest JDBC driver appeared to work with Borland JBuilder 3, so I downloaded the latest jdbc6.5-1.2.jar and fired it up. However, I got the same ...
    Mark DzmuraMark Dzmura
    Dec 3, 1999 at 3:13 pm
    Dec 3, 1999 at 3:13 pm
Group Navigation
period‹ prev | Dec 1999 | next ›
Group Overview
grouppgsql-interfaces @

113 users for December 1999

Tom Lane: 37 posts Michael Meskes: 32 posts Peter Mount: 14 posts Douglas Thomson: 12 posts Robert Hiltibidal: 11 posts Joseph Shraibman: 9 posts Dave Page: 8 posts Stuart: 7 posts Thomas Lockhart: 7 posts Mike Mascari: 6 posts Ross J. Reedstrom: 6 posts Assaf Arkin: 5 posts Enrique Rodriguez Lazaro: 5 posts Peter Mount: 5 posts Adolfo Diaz: 4 posts Charles Randle: 4 posts Christian Ullrich: 4 posts "D'Arcy" "J.M." Cain: 4 posts Gary Stainburn: 4 posts Hiroki Kataoka: 4 posts
show more