[GENERAL] Driver

I'm searching for the SOURCES of JDBC DRIVER (for 7.02), precompiled driver have a bug. Thanks, Enrico

[GENERAL] JDBC

Scuse me I am interesting in a COMPILED debugged version of JDBC driver for 7.02 (driver for J 1.2,1.2 and1.3). Thanks,     Enrico

Re: [GENERAL] Indexes not working (bug in 7.0.2?)

Manual says you should use it after initial data entry, after entering a large amount of rows and periodically. At 23:02 4.9.2000 , Zlatko Calusic wrote: >Tom Lane <[EMAIL PROTECTED]> writes: > >> Zlatko Calusic <[EMAIL PROTECTED]> writes: >> > It is now NOT using the index, and I don't understan

[GENERAL] VACUUM Error

I tried to vaccum a table but get the following error : NOTICE : Child itemid in update-chain marked as unused - can't continue vc_repair frag. VACUUM What is the problem, and how do I over come it?? Thanks Hoosain Madhi Bsc. Engineering Elec. Switching Engineering VODACOM CORPORATE PARK T

Re: [GENERAL] JDBC

Due to me moving home and my day job taking precedence, I've not had chance to do anything since 7.0, so there is no difference between  7.0, and 7.0.2.   I'm working though the backlog of patches & bug fixes at the moment. I had hoped to have something online last night, but I'm still havin

[GENERAL] Re: system catalog question

I'm not familiar with oracle but the command I think you're looking for is explain. Eugene <[EMAIL PROTECTED]> wrote in message news:8m9o4o$9c4$[EMAIL PROTECTED]... > > Hi all, > > I want to know if there is anything in PostgreSQL like 'DESCRIBE' > in Oracle. Thanks. > > Eugene

[GENERAL] JDBC and Unicode problem

Hello, I'm trying to store / retrieve data from UNICODE database, but without success. I installet PostgreSQL 7.02 binaries for RedHat Linux on RH 6.2 I created database with UNICODE as charset (createdb -E UNICODE name) I can establish JDBC connection and everything works fine when I use ASCII

Re: [GENERAL] 7.1 Release Date

Hi Lamar, > I was afraid you'd say that. :-) As long as I can get questions > answered here about the gory details, and without laughing too hard at > my missteps, I'll see if I can tackle this. I think you would make a lot of people very happy with this! Sander.

[GENERAL] Sequences: How do I set a sequence value?

Given a sequence n created by creat sequence, how do I set n so that nextval() will return a specific number on its next call? -- David Steuber | "Are you now, or have you ever been, a member NRA Member| of the NRA?" --- HUAC, 2004 Happiness is a SAAB Gripen in

[GENERAL] initlocation - server restart

hi i have the following problem on my Linux, PostgreSQL 6.5.1: postgres@vogon:~ > export PGDATA2="/home/jochen/data" postgres@vogon:~ > initlocation $PGDATA2 We are initializing the database area with username postgres (uid=26). This user will own all the files and must also own the server proce

[GENERAL] That killer 3rd join...

In order to explore some postgres performance options with table collation, I decided to use a little experimental dabase to try out some of the options I saw. What I want to create queries to combine data from 2+ tables into individual rows. So - being a bit of an EQ player, I cobbled together a

[GENERAL] Column name case conversion

Hello, I'm getting strange length results for columns with UNICODE data. I entered following string into database: abcüäöèæž First three characters are ASCII, second three are German and third three are Croatian. When I execute: select name, length(name), character_length(name), octet_length(na

Re: [GENERAL] PL/Perl compilation errorRe: [GENERAL] PL/Perl compilation error

Tom Lane wrote: > Alex Guryanow <[EMAIL PROTECTED]> writes: > > [root@eaccess plperl]# perl Makefile.PL > > For recent Perl versions you need to do > perl Makefile.PL POLLUTE=1 > instead. The src/pl Makefile would've done it that way for you, > but it looks like that code patch didn't mak

Re: [GENERAL] 7.1 Release Date

Trond Eivind Glomsrød wrote: > No, it's not - it's just not making assumptions like "enough space is > present to dump everything somewhere" (if you have a multiGB database, > dumping it to upgrade sounds like a bad idea), "the database server is > running, so I can just dump the data" etc. On e

Re: [GENERAL] Upper and Lower case sensitivities

Try using ~* Her are the General Operators: http://www.postgresql.org/docs/user/x2125.htm "Campbell, Scott" wrote: > Hey, > > Is there a function within postgres that lets you search for both upper and > lower case at the same time? > I know of the upper() and lower() functions but if a word ha

[GENERAL] Instability in copying large quantities of data

Hi all... I've a big thorne in my side at the moment. I'developing a web app based essentially on a set of report. This reports are generated from queryes on my client's legacy system. For obviuos security reason, my app doesn't interacts directly with the main server, but is built around a P

[GENERAL] Sorting Order NULL values

Hi everybody! I just set up a 7.0.2 server with german (de_DE) locale support enabled, sorting works fine now. However NULL values are always the largest values and thus beeing sorted to the end of a column. Is there a possibility to change the sorting order such that NULL values are considered

[GENERAL] PostgreSQL slow on Reiserfs?

Hello all. I'm trying PostgreSQL 7.02 on Linux with Reiserfs, but I found it A LOT slower than with Ext2! Are there some know issues or tips to speed up this configuration? Read you soon \ Davide G. Borin \\ !!Anti-spam shield active!! Cut x's and "eliminami" from address \\\__

Re: [GENERAL] [Solved] SQL Server to PostgreSQLRe: [GENERAL] [Solved] SQL Server to PostgreSQL

Tom Lane wrote: > Now that you mention it, though, doesn't TOAST break heapam's assumption > that char(n) is fixed length? Seems like we'd better either remove that > assumption or mark char(n) nontoastable. Any opinions which is better? Is the saved overhead from assuming char(n) is fixe

[GENERAL] Error building JDBC Driver

When attempting to build JDBC 7.0 driver with "make jdbc2 jar", the following error occurs: org.postgresql.Connection.java: Can't find class org/postgresql/Field Any ideas? Thanks.

Re: [GENERAL] JDBC

The problem could be in incorrectly implemented getTables. PostgreSQL JDBC returns null. It's not defined that this column may be null, like TABLE_CAT and TABLE_SCHEM. Actually, it returns just names, null for everything else and "no remarks" for remarks. From JDBC documentation: 4. TABLE_TY

[GENERAL] Re: images

You sure can by using BLOBS. You can do that by reading the perl module docs for Pg; Read the section on large objects. >From experience, I would definitely recommend that you store the reference to the file, like a URL or something. That is defiantly the faster way. Loading things off the file s

[GENERAL] pq_recvbuf: unexpected EOF on client connection

Does anyone know this error? Need I be concerned, and what can I do about it?

Re: [GENERAL] postgresql 7 user passwords dont work ?????

su - postgres chmod u+w ~/data/pg_hba.conf vi ~/data/pg_hba.conf chmod u-w ~/data/pg_hba.conf Eric Webber wrote: > > users dont seem to need password in postgres 7 on red hat linux > 6.2, compiled from source. > > I do an: > > alter user nsadmin with password 'whatever'; > > And then when

Re: [GENERAL] C++ Example

On Tue, 29 Aug 2000 (Yesterday), Miguel Omar Carvajal wrote: MOC> Hi there, MOC>I can't find the c++ example in the postgresql distribution. Where can I MOC> find it on the web? in PostgreSQL distribution: src/interfaces/libpq++/examples/ MOC> MOC> Thanks in advance, MOC> Miguel

[GENERAL] Re: uninstall

"Dave @ kexis" <[EMAIL PROTECTED]> writes: ' Is there any easy way to uninstall postgresql? I tried gmake uninstall in ' /usr/src/postgresql-7.0.2/src but thats to uninstall utils ? See if this works for you: rm -rf /usr/local/pgsql rm -rf /var/lib/pgsql Don't forget the database directory if

[GENERAL] initlocation - server restart: sorry, found my mistake

just a sorry, found my $ mistake a minute after I send my last request to the list. jochen -- .* . . Dipl. Geogr. Jochen Schmidt

[GENERAL] VACUUM database gives error

I tried to vacuum a database but get the following error. I also tried to vacuum the individual table tbl_c7links and I get the same error. What is the problem? The other tables vacuum fine There are +- 12,000 records in this table

Re: [GENERAL] plpgsql function

Hello Marcin, Once, Tuesday, September 05, 2000, 8:42:59 PM, you wrote: MM> Hi, MM> creation of following function works just fine but usage not:): MM> mtldb=# select mtldb_wykonane(0); MM> ERROR: unexpected SELECT query in exec_stmt_execsql() MM> Can You help me find an error? MM> tia MM> CRE

Re: [GENERAL] psql: FATAL 1: Index pg_class_relname_index is not a btree

[ Sorry for slow response, but this just arrived here. Are you subscribed to pgsql-general? It looks to me like Marc just got round to approving a week or so's worth of nonmember submissions to the lists... ] Karl DeBisschop <[EMAIL PROTECTED]> writes: > I came in this morning to find my networ

Re: [GENERAL] Large selects handled inefficiently?

"Andrew Snow" <[EMAIL PROTECTED]> writes: > > I believe I can work around this problem using cursors (although I > > don't know how well DBD::Pg copes with cursors). However, that > > doesn't seem right -- cursors should be needed to fetch a large query > > without having it all in memory at onc

[GENERAL] ODBC problems solved with latest drivers

Hello, A little piece of information that might come in handy. Just finished installing 7.0.2. Everything worked fine, but couldn't connect via ODBC. Had all sorts of problems: couldn't insert recs in a table, indexes were unusable, data was invisible etc. (working with BC++ builder). After insta