FAQ

Search Discussions

60 discussions - 173 posts

  • Hi, I'm playing with the ODBC driver (which works fine) but I like passwords to travel encrypted, which is not supported at the moment. Is there any work being done on this? The TODO says (in 1998) ...
    Henk van LingenHenk van Lingen
    Apr 8, 2000 at 2:35 pm
    Apr 12, 2000 at 1:23 pm
  • hi, I'm looking to connect a Pg database to JDBC. Right now I am running Debian Linux 2.1r3 w/ JDK 1.2 and Postgres (not sure what V). If anyone can give me some tips on where to get the drives, or ...
    Jason C. LeachJason C. Leach
    Apr 4, 2000 at 3:14 am
    Apr 6, 2000 at 5:55 pm
  • I have written the following small piece of code to illustrate my problem. #include <pgsql/libpq++.h void callproc(){ PgDatabase* loStatsdb; PgEnv loEnv("","","","",""); loStatsdb = new ...
    Tim BrookesTim Brookes
    Apr 17, 2000 at 8:14 pm
    May 16, 2000 at 3:11 pm
  • Hi. Imagine the foolowing situation: i got one connection, and i have several preparedStatements to execute, each with different parameters. Is is good practice to close the connection in a finally() ...
    Guillaume RousseGuillaume Rousse
    Apr 18, 2000 at 12:28 pm
    Apr 19, 2000 at 6:50 am
  • I've been looking on the internet for 2 hours for information how to connect my SQL database to my website. I didn't find what I was looking for, this is my problem............ I have got a form on ...
    J.PostJ.Post
    Apr 17, 2000 at 2:17 pm
    Apr 18, 2000 at 4:16 pm
  • Hi, I have a JDBC aplication that actualy works with Oracle and I am porting it PostgreSQL. The trouble is that I have some rows with type "LONG" (in Oracle) where are stored strings with up to 20Kb ...
    Nelson Ferreira JuniorNelson Ferreira Junior
    Apr 17, 2000 at 8:11 pm
    Apr 19, 2000 at 5:59 pm
  • Hi, I just saw that the classes org.postgresql.* got checked in, but I'm missing org.postgresql.Driver. Did someone forget to commit them? I'm especially looking for org.postgresql.Field, because I'd ...
    Hakan TandoganHakan Tandogan
    Apr 18, 2000 at 2:24 pm
    Apr 19, 2000 at 3:30 pm
  • Using pgaccess: Is there a way of getting field value back to NULL once you have typed something into it? Simply erasing with backspace doesn't change it back and ESCape can't help, and you can't ...
    Ivo SimicevicIvo Simicevic
    Apr 19, 2000 at 7:54 am
    Apr 20, 2000 at 4:22 pm
  • Is it correct to use a preparedStatement with no variable element, as this: PreparedStatement stmp=conn.prepareStatement("delete from table where oid="+oid); stmt.excuteUpdate(); Or is it mandatory ...
    Guillaume RousseGuillaume Rousse
    Apr 19, 2000 at 9:45 am
    Apr 20, 2000 at 7:57 am
  • First my apologies if this is out of date. I'm working with PgSQL 6.5.2 and not the latest betas: a) through lack of time b) it's a production system, I can't really afford to be playing with a beta. ...
    Andrew C.R. MartinAndrew C.R. Martin
    Apr 11, 2000 at 11:55 am
    Apr 11, 2000 at 5:10 pm
  • hi , I have a table (USR_GROUP_TBL) with following attributes grp_name char(30) usr-name char(15) In my C program ( with embedded SQL using ecpg) I need to select the 'n'th user from the group. Where ...
    GanesanmGanesanm
    Apr 19, 2000 at 9:21 pm
    May 2, 2000 at 8:11 am
  • Ok, I've not played with servlets (had no need) but here goes (and someone correct me if I'm wrong): Java-Apache is the name of the project to integrate Java with Apache. JSERV is a web server that ...
    Peter MountPeter Mount
    Apr 18, 2000 at 5:21 pm
    Apr 19, 2000 at 6:47 am
  • Does anyone know how to get the OID of an INSERTed tuple when using PostgreSQL and ECPG? The documentation and the mail archives state that the OID of an INSERTed tuple is placed in sqlca.sqlerrd[1] ...
    Matthew DennyMatthew Denny
    Apr 18, 2000 at 5:06 am
    Apr 19, 2000 at 1:54 pm
  • Hi, I'm trying to write an script in Perl5 that do an lo_import, but using the one that the perl interface offers returns an oid equal to zero: ... $conn = Pg::connectdb("dbname=test"); $lobjId = ...
    Igor GavriloffIgor Gavriloff
    Apr 18, 2000 at 10:36 pm
    Apr 19, 2000 at 8:51 am
  • Hello Community, In several articles (I read the digest) was mentioned, that gaining connectivity from StarOffice to PGSQL is an already achieved solution. Is there any kind of a recipe available HOW ...
    H.P.HeidingerH.P.Heidinger
    Apr 17, 2000 at 4:32 pm
    Apr 18, 2000 at 7:39 pm
  • Hello I've downloaded the pgsql_perl5-1.9.0. I've decompressed, unpacked, and tried to install, but in the way, I found some errors. The process and errors are listed below ------------ Configuring ...
    Rodrigo Verón De Astrada W.Rodrigo Verón De Astrada W.
    Apr 17, 2000 at 8:10 pm
    Apr 18, 2000 at 3:10 pm
  • I know this question is probably fairly elementary, but I could not find the answer in the docs or mailing list archives. How does one handle NULL values in the embedded SQL interface? For example, ...
    Matthew DennyMatthew Denny
    Apr 16, 2000 at 6:57 pm
    Apr 16, 2000 at 9:04 pm
  • OK, I see. You've got a function that accepts an entire tuple and has hard-wired assumptions about which fields to extract from the tuple. Certainly there are cases where that's what's needed, but ...
    Tom LaneTom Lane
    Apr 11, 2000 at 5:34 pm
    Apr 13, 2000 at 9:40 am
  • I created a programme in Visual Basic(IIS Application) to create a table in the Access Database based on inputs from the user. However I am not able to find out a way to" make the code check for ...
    D.N.MURTYD.N.MURTY
    Apr 10, 2000 at 7:23 pm
    Apr 11, 2000 at 3:52 am
  • Hi, referential integrity seems to have a new behaviour in 7.0 versus 6.5.2 via the Borland Database Engine - ODBC - pgsql connection. This error occurs when inserting into the foreign table an ...
    Zoltan KovacsZoltan Kovacs
    Apr 4, 2000 at 4:11 pm
    Apr 5, 2000 at 3:36 pm
  • PGSQL 7.0beta5, freebsd 4.0 MS WinNT ODBC driver 6.50.00.00 Seems like there is a problem in the way RI violations are reported through ODBC. If I execute the following query in psql, I get an error ...
    Gene SokolovGene Sokolov
    Apr 19, 2000 at 1:39 pm
    Apr 19, 2000 at 6:43 pm
  • I an using Postgresql-6.5.3 with jdbc6.5-1.2 and jdk1.2.2 on redhat linux 6.2 . I have tried to check the jdbc link using JDBCtest.java. Here is the info. my classpath is ...
    Nick RathkeNick Rathke
    Apr 18, 2000 at 5:25 am
    Apr 18, 2000 at 7:21 am
  • Hi, I'am using a PGSQL DB on Linux, and I'm writing a Connection Servlet to that DB. Everything is fine when using simple statements, but I can't use any CallableStatement to execute stored ...
    Bruno FaureBruno Faure
    Apr 17, 2000 at 2:18 pm
    Apr 17, 2000 at 2:45 pm
  • Does PGSQL ODBC exist for the Macintosh?
    Ed LoehrEd Loehr
    Apr 12, 2000 at 5:00 pm
    Apr 13, 2000 at 5:23 am
  • ------------- Begin Forwarded Message ------------- Date: Tue, 11 Apr 2000 10:58:50 +1000 From: Joe Shevland <shevlandj@kpi.com.au Subject: Re: Why fields order is wrong ? To: EJBoss ...
    Paolo SommarugaPaolo Sommaruga
    Apr 11, 2000 at 2:18 pm
    Apr 12, 2000 at 12:38 am
  • I have the following table structure: +----------+-----------------------------+-------+ +----------+-----------------------------+-------+ Trying to create an index like create unique index ...
    Constantin TeodorescuConstantin Teodorescu
    Apr 11, 2000 at 1:37 pm
    Apr 11, 2000 at 2:09 pm
  • I use Borland Jbuilder 3 Standard to create an applet that connects to a postgress database via ODBC. In the Jbuilder I have to configure where the postgresql.jar file is located. But is it really ...
    Oscar SerranoOscar Serrano
    Apr 6, 2000 at 8:50 am
    Apr 6, 2000 at 10:31 am
  • I have noticed that setBinaryStream is not implemented in PreparedStatement class. 7.0 Beta does not have that either. Does anybody know whether this development is on the table and what kind of ...
    Nikolai TurchanikovNikolai Turchanikov
    Apr 6, 2000 at 12:03 am
    Apr 6, 2000 at 6:57 am
  • I'm sorry, but I don't understand the examples in pg_hba.conf file. The file contains only these non-commented lines: local all trust host all 127.0.0.1 255.255.255.255 trust host all 0.0.0.0 0.0.0.0 ...
    Frank BaxFrank Bax
    Apr 1, 2000 at 10:28 pm
    Apr 3, 2000 at 7:17 am
  • Hello all, Whenever I try and use ODBC to access my Postgres database through MS Access (or anything else), I am getting "Error #210 - Unsupported Front End Protocol". Any ideas? Thanks in advance... ...
    Albert J. InsognaAlbert J. Insogna
    Apr 2, 2000 at 7:55 am
    Apr 2, 2000 at 3:26 pm
  • Some suggestion to make current ODBC driver better: 1. Postgres backend now has an autocommit feature, I think that this will remain the default for some time. Now the fact is that each INSERT, ...
    Zoltan KovacsZoltan Kovacs
    Apr 20, 2000 at 11:54 am
    Apr 20, 2000 at 11:54 am
  • Hello. I have problem with accesing fields defined as NUMERIC(14,2) from Wndows applications. I use ODBC v. 6.5 and Postgresql 7.0b5 (I'm also using Borland Builder 5.0). When reffering fields ...
    Mirek HankusMirek Hankus
    Apr 19, 2000 at 11:39 am
    Apr 19, 2000 at 11:39 am
  • Is there a way of limiting autoloading of data while opening table in pgaccess? It would be better to have chance to enter filter before loading data, specially with larger tables. Regards, Ivo.
    Ivo SimicevicIvo Simicevic
    Apr 19, 2000 at 7:48 am
    Apr 19, 2000 at 7:48 am
  • Warning : My permanent email is MailTo:PhilC@writeme.com (DO NOT USE "PCoval@transiciel.com" or any other ones, thanx) --- did u solve this problem ? if yes how ? :) thanx you binary insert with JDBC ...
    Philippe COVALPhilippe COVAL
    Apr 18, 2000 at 7:01 pm
    Apr 18, 2000 at 7:01 pm
  • Can you please take me off of this email list. Thanks. Get Your Private, Free Email at http://www.hotmail.com
    Zubair SaifullahZubair Saifullah
    Apr 18, 2000 at 3:44 pm
    Apr 18, 2000 at 3:44 pm
  • Callable statements are not supported at all. I was planning on including them in 7.0, but the amount of work needed means it's not going to be ready in time, hence it's going to be a 7.1 item. PS: ...
    Peter MountPeter Mount
    Apr 17, 2000 at 3:22 pm
    Apr 17, 2000 at 3:22 pm
  • Although the code in the examples RPM is helping me a lot with learning ECPG, these examples do not cover nearly all of the interesting features of ECPG. Would there happen to be any sort of code ...
    Matthew DennyMatthew Denny
    Apr 17, 2000 at 6:42 am
    Apr 17, 2000 at 6:42 am
  • Could someone tell me where the header file is located that defines the data types used in C/C++ when calling the libpq/libpq++ methods/functions that return fields of built-in data types when using ...
    Matthew DennyMatthew Denny
    Apr 14, 2000 at 9:25 am
    Apr 14, 2000 at 9:25 am
  • Hi Everyone, I'm not seeing posts from March 10 to March 29th. Is the problem on my end? Rick
    Rick SmithRick Smith
    Apr 12, 2000 at 3:24 pm
    Apr 12, 2000 at 3:24 pm
  • Hi, I've just compiled psql.exe & libpq.dll using MS Visual C++ 6.0 SP3 on Windows 2000 Professional. Any action I take that would cause the prompt to be printed a second time results in an ...
    Dave PageDave Page
    Apr 12, 2000 at 2:15 pm
    Apr 12, 2000 at 2:15 pm
  • I just downloaded the latest ODBC driver from ftp://ftp.postgresql.org/pub/odbc/latest/ I executed it and it popped up the message: "This will install PostgreSQL ODBC Driver 6.50.0000. Do you wish to ...
    BrianbBrianb
    Apr 12, 2000 at 3:17 am
    Apr 12, 2000 at 3:17 am
  • Help !!! I changed something and can't figure out what : - ) I had a PostgreSQL database on FreeBSD 4.0 Stable, Linked to a Microsoft Access/97 (Win/95) DB via the PostgreSQL ODBC 6.5.00 driver and ...
    Jeffrey SilberbergJeffrey Silberberg
    Apr 11, 2000 at 10:04 pm
    Apr 11, 2000 at 10:04 pm
  • Hi, in fact this is a resent bug report. The Windows ODBC driver doesn't detect that a reference integrity violation occured. It realizes the fact that there was an error, but doesn't abort the ...
    Kovacs Zoltan SandorKovacs Zoltan Sandor
    Apr 11, 2000 at 11:04 am
    Apr 11, 2000 at 11:04 am
  • hi, I am using the pgadmin windows tool with the latest PsqlODBC drivers. The problem seems to be, that running a query with escaped quotes like [Select * from test where xyz like 'pete\'s cafe'] ...
    Walter, GregorWalter, Gregor
    Apr 11, 2000 at 9:34 am
    Apr 11, 2000 at 9:34 am
  • I just downloaded the latest ODBC driver from ftp://ftp.postgresql.org/pub/odbc/latest/. I executed it and it popped up the message: "This will install PostgreSQL ODBC Driver 6.50.0000. Do you wish ...
    BrianbBrianb
    Apr 11, 2000 at 1:02 am
    Apr 11, 2000 at 1:02 am
  • Is there any possibilities to remove fields in an existing table and if so may that be included in the interfaces down the road. Reason, you make a table and err on type of field(s) resulting in ...
    Aage J. SkjolingstadAage J. Skjolingstad
    Apr 10, 2000 at 8:52 pm
    Apr 10, 2000 at 8:52 pm
  • Can somebody please forward me the previous message from Peter on this list about getting the oid after a sucesful insert ? I got some problems with my mailbox, and list archive seems to be broken... ...
    Guillaume RousseGuillaume Rousse
    Apr 8, 2000 at 4:34 pm
    Apr 8, 2000 at 4:34 pm
  • [snip] Thanks Peter, and also Iwan Vosloo who also answered my question. Sorry for the delayed response; I've temporarily been without net access at work. -Robin Barooah
    RobinRobin
    Apr 6, 2000 at 7:16 pm
    Apr 6, 2000 at 7:16 pm
  • Anyone play with this? http://ksql.sourceforge.net/ Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
    The Hermit HackerThe Hermit Hacker
    Apr 6, 2000 at 2:03 pm
    Apr 6, 2000 at 2:03 pm
  • After creating the following trigger and function, no more records are added to the datbase, with no visible errors, exceptions, etc. Does anyone see my mistake? Thanks in advance. CREATE FUNCTION ...
    Michael ForkMichael Fork
    Apr 5, 2000 at 11:58 pm
    Apr 5, 2000 at 11:58 pm
Group Navigation
period‹ prev | Apr 2000 | next ›
Group Overview
grouppgsql-interfaces @
categoriespostgresql
discussions60
posts173
users73
websitepostgresql.org
irc#postgresql

73 users for April 2000

Peter Mount: 20 posts Tom Lane: 15 posts Thomas Lockhart: 9 posts Guillaume Rousse: 8 posts Zoltan Kovacs: 6 posts Andrew C.R. Martin: 5 posts Lamar Owen: 5 posts Matthew Denny: 5 posts Ivo Simicevic: 4 posts Joe Shevland: 4 posts Joseph Shraibman: 4 posts Oscar Serrano: 4 posts Dave Page: 3 posts Frank Bax: 3 posts Henk van Lingen: 3 posts Ken J. Wright: 3 posts Moray McConnachie: 3 posts Nelson Ferreira Junior: 3 posts Tim Brookes: 3 posts Brianb: 2 posts
show more
Archives