The following bug has been logged online:
Bug reference: 1325
Logged by: gregory
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 Beta
Operating system: win2000
Description:like error
Details:
I create a table
CREATE TABLE tbinvoicerows
(
invoicecd
PostgreSQL Bugs List wrote:
The following bug has been logged online:
Bug reference: 1325
Logged by: gregory
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 Beta
Operating system: win2000
Description:like error
after
I copy 5 millions lignes on the table
sele
On Thu, 18 Nov 2004, PostgreSQL Bugs List wrote:
> select * from tbinvoicerows
> where invoicecd = 'FLOCAA0025'
>
> result in 0 seconde with 2 records NO BUG
>
> select * from tbinvoicerows
> where invoicecd like '%FLOCAA0025%'
>
> result in 40 secondes with 2 records NO BUG
>
> selec
hi,
I created this table:
CREATE TABLE public.stresslog(
"AbfrageId" int8 NOT NULL DEFAULT
nextval('public."stresslog_AbfrageId_seq"'::text),
"AbfrageTyp" varchar(50) NOT NULL,
"Abfrage" varchar(300),
"AnzZeilen" int8 DEFAULT 0,
"ZeitVerbrauch" int8 DEFAULT 0,
"AnzCon" int4 DEFAULT 0,
On Thu, 18 Nov 2004, Cao Duy wrote:
> hi,
>
> I created this table:
> CREATE TABLE public.stresslog(
> "AbfrageId" int8 NOT NULL DEFAULT
> nextval('public."stresslog_AbfrageId_seq"'::text),
> "AbfrageTyp" varchar(50) NOT NULL,
> "Abfrage" varchar(300),
> "AnzZeilen" int8 DEFAULT 0,
> "Ze
O Cao Duy έγραψε στις Nov 18, 2004 :
> hi,
>
> I created this table:
> CREATE TABLE public.stresslog(
> "AbfrageId" int8 NOT NULL DEFAULT
> nextval('public."stresslog_AbfrageId_seq"'::text),
> "AbfrageTyp" varchar(50) NOT NULL,
> "Abfrage" varchar(300),
> "AnzZeilen" int8 DEFAULT 0,
> "
On Thu, Nov 18, 2004 at 03:47:16PM +0100, Cao Duy wrote:
> "AbfrageTyp" varchar(50) NOT NULL,
[snip]
> select AbfrageTyp from stresslog
> ->ERROR: Column abfragetyp doesn't exist
Read the "Identifiers and Key Words" section of the "SQL Syntax"
chapter in the documentation, especially the part
John Hansen <[EMAIL PROTECTED]> writes:
> The following function:
> ...
> creashes the backend, UNLESS it's executed in the same session where it was
> created.
Got it ...
RCS file: /cvsroot/pgsql/src/pl/plperl/plperl.c,v
***
*** 659,665
--- 655,664
int
On Thu, Nov 18, 2004 at 04:37:42PM -0500, Tom Lane wrote:
> Got it ...
Excellent -- I get no crashes with the test cases. Thanks.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
TIP 8: explain analyze is your friend
