Re: [BUGS] Function COPY

2000-11-23 Thread Tom Lane
"DaviS Quirico" <[EMAIL PROTECTED]> writes: > CopyReadAttribute: end of record marker corrupted This message comes out if the COPY data contains \. not immediately followed by newline (\n). I'm guessing that you have some backslashes that need to be doubled --- backslash is an escape character f

Re: [BUGS] Comparison of Strings

2000-11-23 Thread Tom Lane
Mike Schulte <[EMAIL PROTECTED]> writes: > If I run the following command, I get [the string matches the first two > entries in the table]: > cs302=# select * from author where isbn = '1565921941'; > isbn | author > --+ > (0 rows) Ugh :-(. This looks like a corrupted-index problem

Re: [BUGS] Bug report

2000-11-23 Thread Tom Lane
IIRC, the temp-table support was new and still a little flaky in 6.5.*. I'd suggest updating to 7.0.3. regards, tom lane

Re: [INTERFACES] Re: [BUGS] no meaningful way to determine fe or be version?

2000-11-23 Thread Joseph Shraibman
Try submitting it to the psgsl-patches list. Anders Bengtsson wrote: > > Bruce Momjian wrote: > > > > > sorry, yes. the client-side interfaces (DatabaseMetaData.getDriver*) > > > are actually fine - they return a major/minor version that have been > > > getting manually updated (they're much mo

[BUGS] Function COPY

2000-11-23 Thread DaviS Quirico
Hi, I use postgresql 7.0.3 in redhat 6.2. I installed .rpm binary and work good. But i find a problem during import text file Using the function copy from a text file (about 250Mb of size) i can see this error: CopyReadAttribute: end of record marker corrupted So, i can't import my data. I try

[BUGS] Comparison of Strings

2000-11-23 Thread Mike Schulte
I am running PostgreSQL 7.0.2 on sparc-sun-solaris2.8, compiled by gcc 2.95.2 I have a database table whose contents are cs302=# select * from author; isbn | author --+- '1565921941' | 'Meyer, Jon' '1565921941' | 'Downing, Troy' '0201

[BUGS] Bug report

2000-11-23 Thread Andrea Baldoni
To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] POSTGRESQL BUG REPORT TEMPLATE Yo

Re: [INTERFACES] Re: [BUGS] no meaningful way to determine fe or beversion?

2000-11-23 Thread Anders Bengtsson
I think Peter Mount looked at it, but there where some big changes to the JDBC driver going on at that time. When I look at the code in CVS now it looks nothing like what it did when I did the patch against it. Anyway, I found my old patch in the archives: http://www.postgresql.org/mhonarc/pgsql-

Re: [BUGS] error weil dumping

2000-11-23 Thread Tom Lane
"aixit" <[EMAIL PROTECTED]> writes: > getInherits(): SELECT failed. Explanation from backend: 'ERROR: Attribute > 'inhrel' not found > any idea whats my mistake? I think this is what you see if you run a 6.5 pg_dump against a 7.0 database, or was it the other way around? Anyway, check your P

[BUGS] error weil dumping

2000-11-23 Thread aixit
Hello pgsql team, using redhat 6.1 on intel pIII using pgsql 7.02 or pgsql 7.03 pg_dump and pg_dumpall will produce an error like this: NOTICE: Unrecognized variable client_encoding NOTICE: Unrecognized variable client_encoding NOTICE: Unrecognized variable client_encoding NOTICE: Unrecog