d so much in 9.2.
Thanks,
--
William
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The following bug has been logged online:
Bug reference: 6148
Logged by: william wei
Email address: wei_jie...@founder.com
PostgreSQL version: 8
Operating system: linux
Description:unterminated CSV quoted field
Details:
error: unterminated CSV quoted field. when
The following bug has been logged online:
Bug reference: 5610
Logged by: William Wei
Email address: william@tsx.com
PostgreSQL version: AS8.4.4
Operating system: 64-bit Linux 2.6.18-164.6.1.el5
Description:Extremely slow bulk insert performance
Details:
We now
The following bug has been logged online:
Bug reference: 4963
Logged by: William Crawford
Email address: will...@ezyield.com
PostgreSQL version: 8.3.7
Operating system: Gentoo
Description:Selecting timestamp without timezone at timezone gives
wrong output
Details
Tom,
What's odd is after the DBA added the proper IP address entries to the
pg_hba.conf I was able to connect properly.
Regards,
Wil
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, June 25, 2009 4:27 PM
To: Chu, William
Cc: pgsql-bugs@postgresq
The following bug has been logged online:
Bug reference: 4884
Logged by: William Chu
Email address: w...@facorelogic.com
PostgreSQL version: 7.4.5
Operating system: RedHat Enterprise 5.3
Description:Misleading error message
Details:
The following error message
Begin forwarded message:
From: William Davis <[EMAIL PROTECTED]>
Date: November 6, 2008 6:46:42 PM EST
To: [EMAIL PROTECTED]
Subject: postgresql83 and ossp/uuid
I just did yhe new upgrade on ossp-uuid [ from 1.6.1_0 to
1.6.2_0 ] . Since it has 1 dependent I then did u
On Jul 28, 2008, at 3:35 PM, Tom Lane wrote:
"William Kyngesburye" <[EMAIL PROTECTED]> writes:
When connection with the Bonjour name of the postgres server, it
ignores the
md5 setting and always trusts the connection. I tried with other
auth
methods with the same effect
The following bug has been logged online:
Bug reference: 4330
Logged by: William Kyngesburye
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: Mac OS X 10.4.11
Description:Bonjour connections ignore hba config METHOD and always
trusted
The following bug has been logged online:
Bug reference: 3532
Logged by: James William Pye
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: FreeBSD
Description:Can't rollup array of arrays
Details:
Dunno about the spec, but I would
that would behave in a more expected manner, or at
> least document precisely the current behaviour in the documentation.
>
> Best regards,
> Laurent
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an a
mber($1,$2);
END;
$$ LANGUAGE PLPGSQL IMMUTABLE;
Tests...
=# select my_to_number('123.0','99');
ERRO: TEXT 123.0 is not a valid NUMBER
=# select my_to_number('1230','99');
my_to_number
------
1230
(1 registro)
Tempo: 0,734 ms
--
William Leite Araújo
DBA - QualiConsult
2007/8/3, William Leite Araújo <[EMAIL PROTECTED]>:
>
> CREATE OR REPLACE my_to_number(text,text) RETURNS number AS
OOOps... CREATE OR REPLACE FUNCTION ...
$$
> BEGIN
> IF NOT textregexeq($1,'[0-9]{'||length($2)||'}') THEN
> RAISE EXCEPTION &#x
d 1 =
> any (objects.field3)", not return the register.
>
> all these commands when i execute in "execute query" of pgadminIII not
> have
> problem.
>
> -------(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
>
--
William Leite Araújo
Estudante de paternidade - 17a semana
In the modified version of ECPG that we used for our benchmark, we
PREPARE'd all statements.
-Original Message-
From: Michael Meskes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 24, 2007 12:45 AM
To: William Lawrance
Cc: Tom Lane; pgsql-bugs@postgresql.org; [EMAIL PROTECTED]
Su
epared", using the array of parameters built
in the first step above.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 22, 2007 7:53 PM
To: William Lawrance
Cc: pgsql-bugs@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [BUGS] BUG
The following bug has been logged online:
Bug reference: 3244
Logged by: William Lawrance
Email address: [EMAIL PROTECTED]
PostgreSQL version: cvs HEAD
Operating system: Linux
Description:problem with PREPARE
Details:
This program that does "PQprepare"
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
Tom Lane wrote:
> William Gray <[EMAIL PROTECTED]> writes:
>
>> I'm not sure how I'd go about determining that. I don't recall messing
>> with any of my system's .h files. Do you know where I might look?
>>
>
> grep th
Tom,
I'm not sure how I'd go about determining that. I don't recall messing
with any of my system's .h files. Do you know where I might look?
Thanks!
Billy
Tom Lane wrote:
> "William Gray" <[EMAIL PROTECTED]> writes:
>
>> When I run the mak
The following bug has been logged online:
Bug reference: 2457
Logged by: William Gray
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Mac OS X Tiger 10.4.6 (PowerPC)
Description:Make fails at copydir.c / copydir.o
Details:
When I run
s automatically, and works fine...
-- William Leite Araújo
s
for users to view).Thanks,Stephen-BEGIN PGP SIGNATURE-Version: GnuPG v1.4.2 (GNU/Linux)iD8DBQFEMZPKrzgMPqB3kigRAkjsAJwJjASObN0lMkuO8w5qbolAxOImlACfTjJ4
HNN2dVp6S6ng5Fc9yIsxGSE==akx8-END PGP SIGNATURE--- William Leite Araújo
The following bug has been logged online:
Bug reference: 2372
Logged by: William Leite Araújo
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.7
Operating system: i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5
(Debian 1:3.3.5-13)
Description:dblink_exec
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
hat way? If yes, why?
Yes.
You specified your path as a closed path. With its "loopback", it's twice as
long.
To specify it as an open path, do path('[(0,0),(2,0)]').
SELECT length(path('[(1,0),(0,0)]')) = '1';
SELECT length(path('(1,0),(0,0)&#
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
Hi,
I have managed to install the service
on my windows XP box, but when I try to create a database I get:
Creating database 'test' . . .
E_LQ0001 Failed to connect to DBMS session.
E_LC0001 GCA protocol service (GCA_REQUEST)
failure.
Internal service status
E_GC0135 -- A default server cl
"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
Thanks, Bruce. I have a 7.3.4 install in my current path when running the
regression tests. I will try rebuilding and retesting with a modified
path.
Lane Hoy
[EMAIL PROTECTED]
On Sat, 6 Dec 2003, Bruce Momjian wrote:
> [EMAIL PROTECTED] wrote:
> > /usr/local/src/postgresql-7.4/src/test/regres
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
unsubscribe
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
it has already been fixed in 7.3b2
-ÓʼþÔ¼þ-
·¢¼þÈË: [EMAIL PROTECTED]
[mailto:pgsql-bugs-owner@;postgresql.org] ´ú±í [EMAIL PROTECTED]
·¢ËÍʱ¼ä: 2002Äê11ÔÂ14ÈÕ 21:50
ÊÕ¼þÈË: [EMAIL PROTECTED]
Ö÷Ìâ: [BUGS] Bug #818: There are no aggregate functions for type RELTIME
Paul Mamin ([EMAIL PR
Unfortunately, I can't tell you how the exact problem ocurred. All I
know is after checking my logs, I see the following:
ERROR: DeleteTypeTuple: type "tmp_clm_empl" does not exist
Server process (pid 18240) exited with status 256 at Fri Dec 21 23:00:01
2001
Terminating any active server process
Hi. I was running a postgres script that made modifications to a database
with a column tagged as UNIQUE, and in the middle ran "vacuumdb --analyze"
from another console. "vacuumdb" reported an error along the lines of "duplicate
key" (sorry, I did not save the exact error!). After that, all att
Gonzalo Arana wrote:
>
>
> POSTGRESQL BUG REPORT TEMPLATE
>
>
> Your name : Gonzalo Arana
> Your email addres
45 matches
Mail list logo
