[GENERAL] HOWTO document

2001-04-16 Thread Justin Clift
Hi all, Has anyone stepped up to review and re-work the present English HOWTO document, the one that has been removed due to the misinformation and inaccuracies in it? If not, I'm going to start on it, with a view to have it ready in the next month or two. Regards and best wishes, Justin Clift

RE: [GENERAL] Benchmarking PostgreSQL

2001-04-16 Thread Riebs, Andy
Ned Lilly wrote: > Don't know of any other widely-available implementations > besides Quest's, but some engineers in the Alpha group at > Compaq had done some work on an open source > implementation of the AS3AP ... don't have the URL handy, but > you ought to be able to find it in the archives

[GENERAL] insert-select once more

2001-04-16 Thread Gyozo Papp
Hello, I realised what I wrote in my last message was really confused. You are absolutely right, I try to describe the whole situation. 1) There is a table which stores the goods of the vendors: =#CREATE TABLE device (device_id serial, vendor_id integer, ... and some other columns); 2) there i

RE: [JDBC] RE: fastpath error?

2001-04-16 Thread chris markiewicz
Hello. I'm still having problems with this FastPath error. As I mentioned, autoCommit is always set to 'false' in our system, so could there be another source of this? Another angle - Can it be ignored? For example, if I get the error during lo_close and ignore it, am I okay? If so, what exce

[GENERAL] Re: Access 97/Postgres migration

2001-04-16 Thread Patrick Dunford
will come, when he hands over the kingdom to God the Father after he has destroyed all dominion, authority and power. -- 1 Corinthians 15:24 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010416 ===

[BUGS] Re: Possible ODBC driver error

2001-04-16 Thread Patrick Dunford
On Mon, 16 Apr 2001 17:21:16 +1200 AD in comp.databases.postgresql.bugs, Patrick Dunford said: >On Mon, 16 Apr 2001 17:18:02 +1200 AD in comp.databases.postgresql.general, >Patrick Dunford said: > >>I recently copied five tables to the server using the Postgres ODBC driver >>with MS Access.

[BUGS] Re: Possible ODBC driver error

2001-04-16 Thread Patrick Dunford
On Mon, 16 Apr 2001 17:18:02 +1200 AD in comp.databases.postgresql.general, Patrick Dunford said: >I recently copied five tables to the server using the Postgres ODBC driver >with MS Access. > >The tables can be viewed in MS Access but not using PHP or Zeos Database >Explorer, which both retu

[GENERAL] Possible ODBC driver error

2001-04-16 Thread Patrick Dunford
I recently copied five tables to the server using the Postgres ODBC driver with MS Access. The tables can be viewed in MS Access but not using PHP or Zeos Database Explorer, which both return the same error message: ERROR: Relation 'adweb_servinf1' does not exist The tables are visible in ZDO

[GENERAL] Re: Table names / mixed case / Postgresql 7.0.3

2001-04-16 Thread Patrick Dunford
n't bother changing the case and then you are stuck with it :( -- === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Then the end will come, when he hands over the kingdom to God the Father after he has destroyed all dominion, authority and power. -- 1 Corinthians 15:

[GENERAL] Problem with function invocation

2001-04-16 Thread DaVinci
Hello. When I create next function: create function pilpot() returns integer as ' declare foo integer; begin foo = insert into aviso(user) values(1); return foo; end;

[GENERAL] bpchar type

2001-04-16 Thread Patrick Dunford
I have some tables that I copied to a Postgres server from MS Access. The original tables were Paradox. In fields that were originally Paradox Logical type, MS Access shows in the ODBC linked Postgres tables that the datatype of these fields is Text with a length of 1 character (Text being the

[GENERAL] Re: Access 97/Postgres migration

2001-04-16 Thread Patrick Dunford
=== Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Then the end will come, when he hands over the kingdom to God the Father after he has destroyed all dominion, authority and power. -- 1 Corinthia

RE: [GENERAL] Re: Load Text File into DB

2001-04-16 Thread Jeff Eckermann
COPY expects tab delimiters by default, so specifying them is not strictly necessary in this case. Specifying "null as xxx" is a good idea, because COPY interprets an empty field as an empty string, which will cause failure for non text-type fields. A couple of other things to watch out for when b

[GENERAL] Driver ODBC postdrv.exe fails on 7.1

2001-04-16 Thread Tulio Oliveira
Dear List, I upgrade to PostgreSQL 7.1, and so my clients machines with Windows doesn´t more connect with databases. When I try make a new ODBC connection on Windows, all works fine, but I can´t see the tables list for import to Access Database. Please, is any configuration more to make on 7.1

[GENERAL] Re: Success: PostgreSQL 7.1 on MacOS X (Darwin 1.3)

2001-04-16 Thread Justin Clift
Hi Dieter, Yes, definitely interested. What I will do is forward your email to the guys in the PostgreSQL mailing lists, as it's those guys who would probably make a mirror or your packages for everyone to use if they like it. The other thing I can do is make a link to your packages from the te