[ADMIN] writing UPPER()

2000-03-29 Thread Max Pyziur
Greetings, I'm trying to write a function similar to "upper" and am trying to find the source code in the postgresql.6.5.3 tarball. Could someone who knows point me in the right direction? Thanks! -- Max Pyziur BRAMA - Gateway Ukraine [EMAIL PROTECTED]

[ADMIN] COPY problem

2000-03-29 Thread Gustavo Berns
Gustavo Berns wrote: I have a problem with the COPY maybe someone can help? The superuser is " webadmin" uid 504, then I did create a second user "aaadir" with superuser rights. When I try to insert data from a file, it give me the following message: ERROR: COPY command, running in backend with

RE: [ADMIN] query length

2000-03-29 Thread Michael Ansley
Title: RE: [ADMIN] query length You could recompile with a larger blocksize.  The query string length is linked to this, so with a block size of 8k, you get a query string length of 16k.  I think that the max block size is 32k, which will give you a query string length of 64k.  This is not a c

Re: [ADMIN] query length

2000-03-29 Thread Peter Eisentraut
On Tue, 28 Mar 2000, Walter M. Yuan wrote: > >PQsendQuery() -- query is too long. Maximum length is 16382 > >query buffer max length of 16384 exceeded > > Can anyone give me some quick advice on how to change this setting? Upgrade to 7.0. There isn't a way to change it. -- Peter Eisentraut