Tom Lane wrote:
> AGRE Enterprises <[EMAIL PROTECTED]> writes:
> > I have a Plpsgsql function that I have been using in 6.5.1 and it works fine.
> > The same function on 7.0.2 gives me an error. I have looked in the doc and haven't
> > seen any change in syntax but maybe Im blind.
>
> > The error
Marcin Mazurek wrote:
[Charset iso-8859-2 unsupported, filtering to ASCII...]
> Hi,
> why I can't use tabb variable in INSERT ?
> The error message I get is:
> ERROR: parser: parse error at or near "$1"
>
>DECLARE
> ids1 INTEGER;ids2 INTEGER;
>
Hi all,
Do I need to enable the locale support or --enable_multibyte=EUC_TW is
good enough, I would like to be able to do sorting and issue LIKE
command. Anyone can share your experience?
TIA
Douglas
Hello,
I would like to know if there is a release date fixed for the 7.1
version of the postgresql server...
I've compiled the 7.1 on cygnus and the new vacuum is a must for o
project I'm working in (especially because presumably the reindex thing is
coreected now : that bug that never
Hi,
I've got this very bad message with Apache 1.3.6 running mod_perl and
postgresql
6.3.2 with a site hosted by an ISP. They just allocate a max of 10 Mo of memory
for
each user.
For me this was a message coming from server resources. Not enougth memory.
At home with the same configuration I ne
Igor Khanjine <[EMAIL PROTECTED]> writes:
> select datop from mytable where date_trunc('month',datop)
> =date_trunc('month',abstime '02.05.00')
> it returns operations which were made in february !
> I'm running PGSQL 7.0 ,
> SET DATESTYLE ='GERMAN'
> SET TIME ZONE 'EUROPE/MOSCOW'
FWIW, I
Hi!
Help me please to resolve my problem.
I cann't understand why my query returns very strange results.
select datop from mytable where date_trunc('month',datop)
=date_trunc('month',abstime '22.05.00')
it returns a strings with operations which were made in May,
but similar query
se
Hi!
Just as a follow-up to my last posting - disregard my complaints ;-)
I've just checked under Linux - works fine. Then i went back to my WIN NT box,
and double checked libraries. See what i found: i actually used a WIN32 build
of the libpq - not the cygwin build. When using that, everything i
At 17:52 22.10.00 -0400, you wrote:
[...]
> > First effect I have noticed is that when I write more than a certain
> > amount of data at once using lo_write(), my application hangs
> > indefinitely (10K work perfect, 100K not). Is there a well-known
> > limit? On what does it depend? Or is it an
I recently ran into a big problems regarding blobs and rollback with postgreSQL 6.5.3
A table contains many entries and each entry includes a single
blob-oid. In a databaseprocessing perlscript I need to delete such a
blob and perform the lo_unlink and later I rollback the session without
commiti
Looks like I have turned off usecatupd in pg_shadow. Doh! Was mucking
around with permissions some time ago but not had any trouble up till now.
Any ideas how to switch it back? Update pg_shadow SET usecatupd . gives
me Permission denied!!!
Ben.
> -Original Message-
> From: Tom La
11 matches
Mail list logo
