The following bug has been logged online:
Bug reference: 2970
Logged by: William ZHANG
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.2
Operating system: i686-pc-linux-gnu
Description:"FETCH ABSOLUTE -1" from a holdable cursor failed
Details:
The following bug has been logged online:
Bug reference: 2835
Logged by: William ZHANG
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: Linux
Description:Table inheritance and statement level trigger.
Details:
create language plpgsql
g the following statement via psql will cause the similar error
you got:
PREPARE foo (VARCHAR) AS INSERT INTO "junk" ( "preis" ) VALUES ( $1 )
Can you change the parameter "log_error_verbosity" to "verbose", and
send me the log file?
Regards,
William ZHA
Can you set "log_statement" in postgresql.conf and post the logged
statements?
--
With regards,
William ZHANG
- Original Message -
From: ""Heinz-Peter Heidinger"" <[EMAIL PROTECTED]>
Newsgroups: pgsql.bugs
Sent: Saturday, June 24, 2006 3:44 PM
Sub
ect.)
Steps:
1. Fix your pg_hba.conf according to the document mentioned above.
2. Use psql to test if you can connect to the database server.
If not, goto step 1, else goto step 3.
3. Use your application to run tests.
> ""qinyan"" <[EMAIL PROTECTED]>
o it in two steps, assuming that
> orderby is > 0 for all rows you are changing:
>
> BEGIN;
> UPDATE mytable SET orderby = -orderby WHERE groupid = 1;
> UPDATE mytable SET orderby = -orderby+10 WHERE groupid = 1;
> COMMIT;
Should we invent something to d
There must be some error caused by the SQL statements sent by the
application or driver.
You can log the SQL statements by setting log_statement to true in
postgres.conf.
Regards,
William ZHANG
---(end of broadcast)---
TIP 3: Have you checked our
It looks strange. Can you show us more information:
1. Database encoding: show server_encoding;
2. SQL scripts do create and insert the values.
""wally"" <[EMAIL PROTECTED]> wrote
>
> The following bug has been logged online:
>
> Bug reference: 1908
> Logged by: wally
> Email addr
Also reported on
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00841.php.
""zhangsijing"" <[EMAIL PROTECTED]> wrote
>
> The following bug has been logged online:
>
> Bug reference: 1932
> Logged by: zhangsijing
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8
mismatch is a problem on all platforms, it is more common
> on Win32 where the FILE structure changes for debug, for example.
>
> --
-
>
> Michael Meskes wrote:
> > On Mon, Aug 15, 2005 at 07:39:42PM +0800
"Oliver Jowett" <[EMAIL PROTECTED]>
wrote:[EMAIL PROTECTED]
> Bernard wrote:
>
>> The majority of JDBC users trying to bulk load tables would not want
>> to send the data through their connection. This connection is designed
>> to send commands and to transfer only as much data as necessary and a
Yes. It is reproducible. But it works well in MinGW.
Is there sth. wrong with the import library lib\ms\libecpg.lib or
lib\libecpg.dll?
"Joshua Masiko" <[EMAIL PROTECTED]>
wrote:[EMAIL PROTECTED]
>
> ntdll.dll!7c918fea()
> ntdll.dll!7c9106eb()
> ntdll.dll!7c90104b()
> msvcrt.dll!77c3b90d()
>
Make sure the lib directory is in the PATH.
I tested it in MinGW.
$ ecpg main.pgc
$ gcc main.c -I../include -L../lib -lecpg
$ export PATH=$PATH:"/c/Program Files/PostgreSQL/8.0/lib"
$ ./a.exe
[1772]: ECPGdebug: set to 1
""joshua masiko"" <[EMAIL PROTECTED]> wrote
news:[EMAIL PROTECTED]
>
> The f
Bruce said:
> How do other databases handle this?
I have tried on MS SQL Server 2000 and Oracle 9i for Windows.
SQL Server doesn't like character_length and || , so use len and + instead.
Oracle doesn't like character_length either, use length.
Hope the result may help.
create table chartest(col
14 matches
Mail list logo
