Tatsuo Ishii wrote:
> > After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA
>columns the parser rejects insert queries with binary data because they're not UTF8
>encoded (escaping doesn't help ;-).
>
> I don't kno how exactly escaped them, but you need to escape b
This seems unusual. Would you send us a sample of a string that is
rejected?
---
[EMAIL PROTECTED] wrote:
> Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more severe it is.
Sir,
I am using postgresql driver version 7.2 . The getImportedKey() fails to retrieve more than one foreign key. It gives only one, eventhough it has 2. What to do ?
Waiting for the result,
With r
I have a DB where
this:
select 1 into
temporary table x;
runs quickly,
but
drop table
x;
takes many seconds
to run.
I don't know
why.
But:
begin;
select 1 into
temporary table x;
abort;
is very
quick.
Note the slow
dropping applies to automatic dropping of temporary tab
And
when I do drop a table CPU usage goes to 99% on one CPU.
Sam
-Original Message-From: Sam Liddicott
Sent: 31 May 2002 10:57To:
'[EMAIL PROTECTED]'Subject: drop tempoary table VERY
slow
I have a DB where
this:
select 1 into
temporary table x;
runs quickly
Hi
I wonted use comment for tables and columns (by COMMENT (TABLE|COLUMN)
IS). I need show tables to other users with Access 2000. I use ODBC. But
link tables hasn't description in Access (description of columns, tables).
Is it a bug?
I have PostgreSQL 7.2.1 (Linux) and ODBC drivers for window
Hi
I can't connect the server by Microsoft ODBC, message "packet length too
long"
Thank for your help
Bye
Guillaume sala
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
see attachment
--
Christian Zagrodnick
gocept gmbh & co. kg - schalaunische strasse 6 - 06366 koethen/anhalt
fon. +49 3496 3099114
fax. +49 3496 3099118
mob. +49 173 9078826
mail [EMAIL PROTECTED]
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be speci
Hi,
I have found a bug in PostgreSQL 7.2.1.
I am trying to use plpgsql to run a simple INSERT on a table, and it always
comes up with an error saying "mismatched parentheses"
I firstly store the SQL in a TEXT variable:
a_sql := ''INSERT INTO mytable(theid,thenumber) VALUES(1,2);'';
Then i run
