[BUGS] BUG #1366: spam from yourselves

2004-12-29 Thread keith berrington
The following bug has been logged online: Bug reference: 1366 Logged by: keith berrington Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: not applicable Description:spam from yourselves Details: I have been trying unsuccessfully for over 2

Re: [BUGS] BUG #1364: using field names or table names with blanks

2004-12-29 Thread Tom Lane
"Pit Mueller" <[EMAIL PROTECTED]> writes: > MS SQL Server uses a quite elegant method for using field names and table > names: > select [field] from [table] > f.ex. select [my field] from [the big table] One man's "elegant" is another's "ugly and nonstandard". > PostgreSQL 8.0 should support th

Re: [BUGS] function return type for triggers in postgresql 8.0 rc2

2004-12-29 Thread Tom Lane
"PEDRO LOPEZ" <[EMAIL PROTECTED]> writes: > after struggling with 'function not defined errors', and unable to see what > was wrong I redefined the function as: > CREATE OR REPLACE FUNCTION currentstatus_dtrig() RETURNS opaque AS > ... > and got the message to the effect of 'redefining return ty

Re: [BUGS] plperl and pgport

2004-12-29 Thread Tom Lane
Nicolas Addington <[EMAIL PROTECTED]> writes: > Compiling 8.0.0RC2 on AIX 4.3 on an RS600 with gcc, in src/pl/plperl, got > the following error: > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing > -Wl,-bnoentry -Wl,-H512 -Wl,-bM:SRE -o libplperl.so libplperl.a > -L../../

[BUGS] connection error

2004-12-29 Thread Manish Patel
Hello   I am Manish.Well i configured Freeradius with Postgresql on Redhat Fedora.well when i start the freeradius i got this error as below: Couldn't connect socket to PostgreSQL server [EMAIL PROTECTED]:radius Error: rlm_sql_postgresql: Postgresql error 'could not connect to server

[BUGS] BUG #1362: Storing large object like 35mb files.

2004-12-29 Thread
The following bug has been logged online: Bug reference: 1362 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: linux Description:Storing large object like 35mb files. Details: There is problem how to store large files in postg

[BUGS] BUG #1364: using field names or table names with blanks

2004-12-29 Thread Pit Mueller
The following bug has been logged online: Bug reference: 1364 Logged by: Pit Mueller Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: WINXP Description:using field names or table names with blanks Details: MS SQL Server uses a quite elegant

[BUGS] function return type for triggers in postgresql 8.0 rc2

2004-12-29 Thread PEDRO LOPEZ
I am porting an existing database to postgresql and am translating some triggers. I have the following objects: A table named 'currentstatus' a function which I orignally defined as: CREATE OR REPLACE FUNCTION "CurrentStatus_DTrigx"() RETURNS opaque AS $BODY$ Begin if (select COUNT(*) FROM del

[BUGS] BUG #1363: Loose connection in idle mode

2004-12-29 Thread Jean Claude
The following bug has been logged online: Bug reference: 1363 Logged by: Jean Claude Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: W2K Description:Loose connection in idle mode Details: I didn't found any related topic about timeout conn

[BUGS] German Win32 Setup (V8 RC2)

2004-12-29 Thread Pit Müller
The password hint is not written in correct german : Better: Das angegebene Kennwort ist nicht sicher genug. Soll das Installationsprogramm es durch ein sichereres, zufälliges ersetzen? Regards, Pit PS: The setup seems to have problems displaying german umlauts. Please see attached screenshot <>

[BUGS] BUG #1359: there is a problem in "SELECT ....GROUP BY"

2004-12-29 Thread jingold chen
The following bug has been logged online: Bug reference: 1359 Logged by: jingold chen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: window xp home edition Description:there is a problem in "SELECT GROUP BY" Details: I have install a

[BUGS] PostgreSQL 8.0.0 Release Candidate 2 announcement

2004-12-29 Thread John Summerfield
pls, link to the most important info - the release notes detailing what's changed since a) RC1 abd b) 7.4. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[BUGS] German Setup Win32 (V8 RC2)

2004-12-29 Thread Pit Müller
Dear Win32-Setup team, I have a few comments concerning the german setup. There are some small typos in the wizard Step "Dienste-Konfiguration". 1. "Bitte hiere einen..." -> "Bitte hier einen..." 2. "abbrechen" -> "Abbrechen" 3. "zurück" -> "Zurück" 4. "nächster" -> "Weiter" 5. The Labels (static

[BUGS] BUG #1357: Installation via Terminal Service

2004-12-29 Thread Winfried Maus
The following bug has been logged online: Bug reference: 1357 Logged by: Winfried Maus Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows Server 2003 Description:Installation via Terminal Service Details: When trying to install Postgr

[BUGS] BUG #1361: errors in install

2004-12-29 Thread
The following bug has been logged online: Bug reference: 1361 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Linux Description:errors in install Details: Hi, I have two errors : * When i want to create a DB, he replies : "

[BUGS] BUG #1360: Use PostgreSQL OLE DB Provider in VS.NET 2003

2004-12-29 Thread Tran Duc Khoa
The following bug has been logged online: Bug reference: 1360 Logged by: Tran Duc Khoa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows Advance Server 2000 Description:Use PostgreSQL OLE DB Provider in VS.NET 2003 Details: Hi all In

[BUGS] postgresql-8.0.0-rc2.msi failed to install on Dynamic NTFS Partition

2004-12-29 Thread Egon Phillips
POSTGRESQL BUG REPORT TEMPLATE Your name : Egon Phillips Your email address : [EMAIL PROTECTED] System Configur

[BUGS] compiling on AIX

2004-12-29 Thread Nicolas Addington
Hi, Compiling 8.0.0RC2 on AIX 4.3 on an RS600 with gcc, in src/backend, got the following error: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -L../../src/port -L/usr/local/lib -L/da23/d56/croquet/readline/lib access/SUBSYS.o bootstrap/SUBSYS.o catalog/SUBSYS.o parser/

[BUGS] plperl and pgport

2004-12-29 Thread Nicolas Addington
Hi, Compiling 8.0.0RC2 on AIX 4.3 on an RS600 with gcc, in src/pl/plperl, got the following error: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -Wl,-bnoentry -Wl,-H512 -Wl,-bM:SRE -o libplperl.so libplperl.a -L../../../src/port -L/usr/local/lib -L/da23/d56/croquet/rea

Re: [BUGS] BUG #1365: Loose connection in idle mode

2004-12-29 Thread Tom Lane
"Jean Claude" <[EMAIL PROTECTED]> writes: > I didn't found any related topic about timeout connection with a non > activity of clients. In fact the server disconnect any client after ~10 > minutes of inactivity. There is no disconnect timeout in Postgres. This sort of thing has been reported befo

Re: [BUGS] ECPG CONNECT TO DEFAULT segfault

2004-12-29 Thread Michael Fuhr
On Wed, Dec 29, 2004 at 10:32:21AM +0100, Michael Meskes wrote: > On Tue, Dec 28, 2004 at 11:15:52PM -0700, Michael Fuhr wrote: > > > > ECPG's CONNECT TO DEFAULT causes a segmentation fault. This > > originally came up in the "Connection without database name" thread > > in pgsql-hackers: > > Th

Re: [BUGS] RC2 on OS X can not make check

2004-12-29 Thread Theodore Petrosky
I'll try again this morning without the diable-shared. However, I tried this because of a recomendation for using libpq. When I tried to compile my app (using xcode on OS X) it complained about the dylib I will try again in a little while and let you know. Ted --- Tom Lane <[EMAIL PROTECTED

[BUGS] unpredictable cost in explain

2004-12-29 Thread Ruslan A Dautkhanov
Hello ! Please help me, I tried to make request run faster 1st request (original): SELECT dy.*, sat.dton as satdton FROM dyBilling dy, saType sat WHERE dy.dt>='20-12-2004' AND dy.dt<='20-12-2004' AND dy.servid=sat.servid AND dy.dt BETWEEN sat.dton AND sat.dtoff it have execution time 4174

[BUGS] BUG #1365: Loose connection in idle mode

2004-12-29 Thread Jean Claude
The following bug has been logged online: Bug reference: 1365 Logged by: Jean Claude Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: W2K Description:Loose connection in idle mode Details: I didn't found any related topic about timeout conn

Re: [BUGS] ECPG CONNECT TO DEFAULT segfault

2004-12-29 Thread Michael Meskes
On Tue, Dec 28, 2004 at 11:15:52PM -0700, Michael Fuhr wrote: > PostgreSQL 8.0.0rc2, 7.4.6 > Solaris 9, FreeBSD 4.11-PRERELEASE > > ECPG's CONNECT TO DEFAULT causes a segmentation fault. This > originally came up in the "Connection without database name" thread > in pgsql-hackers: > This i