[BUGS] BUG #2783: insufficient base table information for updating or refreshing

2006-11-27 Thread mike
The following bug has been logged online: Bug reference: 2783 Logged by: mike Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: windows 2000 Description:insufficient base table information for updating or refreshing Details: if using

Re: [BUGS] No error when FROM is missing in subquery

2006-12-18 Thread mike
this case. Mike On Tue, 2006-12-19 at 06:01 +0100, Thomas H. wrote: > >> >> SELECT * FROM movies.names WHERE mov_id IN (SELECT DISTINCT mov_id > >> >> WHERE > >> >> mov_name like '%, %' LIMIT 2) > >> > >> IF the subquery wo

Re: [BUGS] No error when FROM is missing in subquery

2006-12-18 Thread mike
You are right as usual My apologies yet again. I have wrongly assumed that the lower statement would run first since it is enclosed in parenthesis. On Tue, 2006-12-19 at 00:48 -0500, Tom Lane wrote: > mike <[EMAIL PROTECTED]> writes: > > Pgsql does not throw an error (at lea

[BUGS] BUG #2855: SEGV on PL/PGSQL function

2006-12-21 Thread Mike
The following bug has been logged online: Bug reference: 2855 Logged by: Mike Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: RHEL AS 4.3 x86_64 Description:SEGV on PL/PGSQL function Details: (retyping this by hand ... forgive any

[BUGS] BUG #3746: installation fails

2007-11-14 Thread Mike
The following bug has been logged online: Bug reference: 3746 Logged by: Mike Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Win2003/WinXP Description:installation fails Details: I tried to install PostgreSQL two times on different

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-24 Thread mike
Hi, I should state that I use 7.4beta1 under FreeBSD -current. On Thu, 21 Aug 2003, mike wrote: > Date: Thu, 21 Aug 2003 18:28:53 +0200 (CEST) > From: mike <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: index not used afer VACUUM ANALYZE > > Hi, > I hav a

[BUGS] index not used afer VACUUM ANALYZE

2003-08-24 Thread mike
Hi, I hav a db as specified in nit.sql flows has 763488 entries. After dropping/creating/loading the db and running auswert.sh I get the attached result from query1.txt. After 'VACUUM ANALYZE' I get the results from query2.txt As you can see, the indexes are not used any longer. Why? Bye/2 --- M

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-25 Thread mike
On Mon, 25 Aug 2003, Stephan Szabo wrote: > Date: Mon, 25 Aug 2003 00:43:56 -0700 (PDT) > From: Stephan Szabo <[EMAIL PROTECTED]> > To: mike <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] index not used afer VACUUM ANALYZE > > On Thu, 21 Aug

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-27 Thread mike
On Mon, 25 Aug 2003, Stephan Szabo wrote: > Date: Mon, 25 Aug 2003 08:52:34 -0700 (PDT) > From: Stephan Szabo <[EMAIL PROTECTED]> > To: mike <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] index not used afer VACUUM ANALYZE > > On Mon, 25 Aug 2

Re: [BUGS] index not used afer VACUUM ANALYZE

2003-08-28 Thread mike
Hi, On Tue, 26 Aug 2003, Stephan Szabo wrote: ... > But does it change the amount of time the query actually takes to run? > seqscans are not always slower nor are they necessarily the actual problem > here. The problem seems to be choosing a group aggregate + sort which is > taking alot of time,

[BUGS] Backups with pg_dumpall do not restore all data

2004-04-08 Thread mike
POSTGRESQL BUG REPORT TEMPLATE Your name : Mike Martin Your email address : [EMAIL

[BUGS] Backups with pg_dumpall do not restore all data

2004-04-08 Thread mike
POSTGRESQL BUG REPORT TEMPLATE Your name : Mike Martin Your email address : [EMAIL

[BUGS] Log entry asking to contact support

2005-12-30 Thread mike
y to vacuum (full) again? I want to assume it got corrupted during the original vacuum attempt. I have been starting the vacuum from the database name level in pgadmin. I would be happy to try and give more info if I can. I initially posted this to pgadmin-support but was asked to post here. M

Re: [BUGS] BUG #2145: FTP Mirror to download is not found

2006-01-04 Thread mike
them worked. The steps I took are listed in the pgsql-www mailing list someplace. Mike On Wed, 2006-01-04 at 16:10 +, Glenn Gentry wrote: > The following bug has been logged online: > > Bug reference: 2145 > Logged by: Glenn Gentry > Email address: [

[BUGS] BUG #7846: Documentation: Should FOUND be documented as an output of UPDATE statement?

2013-02-04 Thread mike
The following bug has been logged on the website: Bug reference: 7846 Logged by: Mike Sherrill Email address: m...@fontling.com PostgreSQL version: 9.1.6 Operating system: Ubuntu Linux 12.04 Description: Documentation for the SQL UPDATE statement doesn't mention

[BUGS] BUG #4406: silent install error

2008-09-06 Thread Mike Gagnon
The following bug has been logged online: Bug reference: 4406 Logged by: Mike Gagnon Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows XP Description:silent install error Details: Hi, When I try to do a silent install, I have

[BUGS] BUG #4411: One click install broken

2008-09-08 Thread Mike Tegtmeyer
The following bug has been logged online: Bug reference: 4411 Logged by: Mike Tegtmeyer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: MacOS10.5 Description:One click install broken Details: During one click install on clean MacOS 10.5.4

[BUGS] BUG #5093: Prepared query gives different PGresult than exec'd equivalent

2009-10-02 Thread Mike Pomraning
The following bug has been logged online: Bug reference: 5093 Logged by: Mike Pomraning Email address: m...@pilcrow.madison.wi.us PostgreSQL version: 8.4.1 Operating system: Linux i686 2.6.18-128.7.1.el5 Description:Prepared query gives different PGresult than exec&#

[BUGS] BUG #5160: complex query parsing bug

2009-11-02 Thread Mike Landis
The following bug has been logged online: Bug reference: 5160 Logged by: Mike Landis Email address: mlan...@pnmx.com PostgreSQL version: 1.8.4 Operating system: Vista Description:complex query parsing bug Details: The SQL parser in pgAdmin III v1.8.4 build 7358

[BUGS] getting libpqd.lib and libpqd.dll for postgesql 8.4.1 on Vista with VS8 or cygwin g++

2009-12-09 Thread Mike Landis
ograms\cygwin\usr\include VS8 produces many errors indicating that winsock2.h, unistd.h, ws2tcpip.h (possibly other header files) are being included multiple times. What include path(s) should I be using with these compilers (cygwin make/g++ or nmake/cl from VS8? Thanks, Mike Landis

[BUGS] BUG #5268: PQgetvalue incorrectly returns 0

2010-01-06 Thread Mike Landis
The following bug has been logged online: Bug reference: 5268 Logged by: Mike Landis Email address: mlan...@pnmx.com PostgreSQL version: 8.4.1 Operating system: Vista Description:PQgetvalue incorrectly returns 0 Details: When I execute the following SQL: "S

[BUGS] email addresses

2010-01-06 Thread Mike Landis
Can you please stop displaying the email addresses on bug reports?  It's one thing to require an email address - it's another thing entirely to publish it for spam address harvesting bots. This is an example page... http://archives.postgresql.org/pgsql-bugs/2009-12/msg00092.php

Re: [BUGS] BUG #5268: PQgetvalue incorrectly returns 0

2010-01-07 Thread Mike Landis
ote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Jan 07, 2010 at 04:11:03AM +, Mike Landis wrote: > > The following bug has been logged online: > > Bug reference:  5268 > Logged by:  Mike Landis > Email address:  mlan...@pnmx.com > Postgre

Re: [BUGS] BUG #5268: PQgetvalue incorrectly returns 0

2010-01-07 Thread Mike Landis
Pick a database and table that exists, configure the string cconstants, compile and run the attached cpp, get 0 instead of 1 (that you get in pgAdmin... Where's can I download the libpq source?  Maybe I can find and/or fix the problem myself. #include #include // on Vista #include// f

[BUGS] Comparison of Strings

2000-11-23 Thread Mike Schulte
I am running PostgreSQL 7.0.2 on sparc-sun-solaris2.8, compiled by gcc 2.95.2 I have a database table whose contents are cs302=# select * from author; isbn | author --+- '1565921941' | 'Meyer, Jon' '1565921941' | 'Downing, Troy' '0201

[BUGS] Referencial integerity problem

2001-02-12 Thread Mike Howard
s) test=> insert into bar values ('foo', 1); ERROR: foo: Permission denied. test=> -- Mike Howard <[EMAIL PROTECTED]>

Re: [PHP] [BUGS] PostgreSQL / PHP Overrun Error

2001-11-16 Thread Mike Rogers
Well it really isn't your code (true), but the only thing that is changed is the 7.0-7.1- Was a data length changed on the return or something that could affect this? -- Mike - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Mike Rogers"

Re: [PHP] [BUGS] PostgreSQL / PHP Overrun Error

2001-11-16 Thread Mike Rogers
Sorry: PHP 4.0.6 (with memory leak patch [download listed right below php-4.0.6.tar.gz download- It was a problem]) PostgreSQL 7.1.3 Apache 1.3.20 (with mod_ssl- but it does the same thing without mod_ssl) -- Mike - Original Message - From: "mlw" <[EMAIL PROTECTE

Re: [PHP] [HACKERS] [BUGS] PostgreSQL / PHP Overrun Error

2001-11-16 Thread Mike Rogers
There is a problem in PHP-4.0.6. Please use PHP4.0.7 or 4.0.8 and the problem will be solved. This can be obtained from CVS -- Mike - Original Message - From: "Christopher Kings-Lynne" <[EMAIL PROTECTED]> To: "Mike Rogers" <[EMAIL PROTECTED]>; "

Re: [BUGS] [HACKERS] [PG MAIL LISTS] SEND OUT ALL????

2001-11-16 Thread Mike Rogers
if you look at the originating time for all of the messages that got sent out of when it was sent from the host machine (with HELO host). Clearly it was done on an admin side. -- Mike - Original Message - From: "Marc G. Fournier" <[EMAIL PROTECTED]> To: "Mike Roge

[BUGS] [PG MAIL LISTS] SEND OUT ALL????

2001-11-16 Thread Mike Rogers
Why did it just send out tons of mail since September of this year- every message? -- Mike ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] pg_restore --data-only ignored

2001-11-26 Thread Mike Finn
store --dbname=${dbName}2 --data-only -v --superuser=postgres $dbDump I could get around this by using a list file and then editing it to only include data lines, but thought it should be reported as a bug. -- = Mike Finn Tactical Executive Sy

[BUGS] PostgreSQL / PHP Overrun Error

2001-09-26 Thread Mike Rogers
ghts? I can provide any further system information if needed. I have tried recompiling pgsql, php and apache with different optimizations [including none at all and debug mode on as i have now] with little change in the result. Thanks in advance; -- Mike cc: pgsql-hackers; p

[BUGS] case sensititvity bug in foreign keys on cygwin

2001-12-03 Thread Mike Smialek
Configuration: Windows 2000 Server cygwin 2.78.2.9 PostgreSQL 7.1.3 psqlODBC 7.1.8 pgAdmin II 1.1.66 Bug: Capital letters cannot be used in column names used in foreign key constraints All Smalls succeeds: -- Table: significance CREATE TABLE "signific

[BUGS] case-sensitivity inconsistency in quoted column aliases in FROM subselects

2002-01-09 Thread Mike Hoolehan
POSTGRESQL BUG REPORT TEMPLATE Your name : Mike Hoolehan Your email address : [EMAIL PROTECTED

[BUGS] Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands

2002-01-31 Thread Riendeau, Mike
Your name : Mike Riendeau Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Sun Sparc 20 Operating System (example: Linux 2.0.26 ELF) : Solaris 2.5.1 PostgreSQL version (example

Re: [BUGS] Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com

2002-02-01 Thread Riendeau, Mike
Your name : Mike Riendeau Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Sun Sparc 20 Operating System (example: Linux 2.0.26 ELF) : Solaris 2.5.1 PostgreSQL version (example

Re: [BUGS] Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com

2002-03-04 Thread Riendeau, Mike
on the older systems. Regards, M Riendeau -Original Message- From: Riendeau, Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 4:04 PM To: Tom Lane; Riendeau, Mike Cc: [EMAIL PROTECTED] Subject: RE: [BUGS] Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com

[BUGS] PG_DUMP Load

2002-04-19 Thread Mike Rogers
s and processes time out and fail. Has anyone else has similar problems with pg_dump 7.1.3? -- Mike ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] gmake does not work for Postgresql-8.1.4

2006-09-27 Thread Mike Bassett
hen tried ./configure –prefix=c:/mingw/local –with-includes=c:/mingw/local/include –with-libs=c:/mingw/local/lib make && make install but it had an issue with make. Mike Bassett e-mail [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend

[BUGS] BUG #2815: Editing / Creating ODBC on Windows fails libintl-2.dll not found

2006-12-06 Thread mike godshall
The following bug has been logged online: Bug reference: 2815 Logged by: mike godshall Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows 2003 webserver edition Description:Editing / Creating ODBC on Windows fails libintl-2.dll not

Re: [BUGS] BUG #3752: query yields "could not find block containing chunk", then server crashes

2007-11-20 Thread Mike Charnoky
when the query is run. BTW- PG8.3 seriously rocks! We've got some large tables that had very poor performance in PG8.1... things are really snappy now, HOT usage really helps our app (as shown by the handy pg_stat_all_tables). Mike Zdenek Kotala wrote: > Mike Charnoky wrote: >>

[BUGS] BUG #3790: pg_restore error canceling statement due to user request

2007-11-30 Thread Mike C.
The following bug has been logged online: Bug reference: 3790 Logged by: Mike C. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta3 Operating system: Linux 2.6.16.21-0.8-xen #1 SMP Mon Jul 3 18:25:39 UTC 2006 i686 i686 i386 GNU/Linux Description:pg_restore

[BUGS] Vers. 8.3.0: "make check" fails dismally

2008-02-06 Thread Mike Dowling
$ export LD_LIBRARY_PATH=/usr/src/postgresql-8.3.0/src/test/regress/tmp_check/install/usr/local/lib before "make check" and all the tests are then successful. Cheers, Mike Dowling -- Dr. Michael L. Dowling Gaußstr. 27 38106 Braunschweig Germany

[BUGS] BUG #3983: pgxs files missing from binary installation

2008-02-22 Thread Mike Leahy
The following bug has been logged online: Bug reference: 3983 Logged by: Mike Leahy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: Win32 Description:pgxs files missing from binary installation Details: I've tried to compile the

Re: [BUGS] BUG #3983: pgxs files still missing in win32 install (8.3.1)

2008-03-17 Thread Mike Leahy
and any related files. Mike -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #4166: Alter table add column from PgAdminIII

2008-05-14 Thread Mike Gagnon
The following bug has been logged online: Bug reference: 4166 Logged by: Mike Gagnon Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1-1 Operating system: Windows XP Description:Alter table add column from PgAdminIII Details: Hi Postgres Experts, I used

[BUGS] Large PG_DUMPs going into memory?

2002-05-05 Thread Mike Rogers
rather than load the entire result set into memory? It's not sorting it or anything. Any help would be appreciated. -- Mike ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] pg_ctl failure with older Bourne shells (use ${1:+"$@"})

2002-07-19 Thread Mike Coleman
Your name : Mike Coleman Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) :alpha Operating System (example: Linux 2.0.26 ELF) :Tru64 5.1 PostgreSQL version (example: PostgreSQL

[BUGS] ON DELETE triggers don't work as documented

2002-12-11 Thread Mike Glover
this form. POSTGRESQL BUG REPORT TEMPLATE Your name : Mike Glover Your email address : [EMAIL PROTECTED] System Con

Re: [BUGS] Bug #856: coredump

2003-01-02 Thread Mike Pechkin
On Thu, Dec 26, 2002 at 12:01:02PM -0500, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > postgresql=# CREATE USER mpech777; > > CREATE USER > > postgresql=# alter USER mpech777 password ''; > > server closed the connection unexpectedly > > Hm, it works fine here. You'll need to give more de

[BUGS] pg_tables view definition incorrect??

2003-07-09 Thread Mike Quinn
version --- PostgreSQL 7.3.2 on i586-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) View "pg_catalog.pg_tables" Column| Type | Modifiers -+-+---

[BUGS] SysV startup script name in binary RPM distribution

2003-08-14 Thread Mike Nerone
such as NAME=`basename $0` NAME=${NAME#[SK][0-9][0-9]} which I know works with bash, but I'm not sure if it will work with an old-style Bourne shell. Incidentally, is there any strong reason it doesn't just standardize and become the following? NAME=postgresql Thanks. Please s

Re: [BUGS] buglet in 7.1.4

2004-03-09 Thread Mike Mascari
.1 installation that requires dumping for migration, but no binaries due to compilation errors? Isn't that a rather low-probability scenario? Mike Mascari ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] make check regression "test stats" failed

2004-05-03 Thread Mike Quinn
n and a "failed" run and the only difference was the date/time, so there was no indication there of this type of problem there. Thanks, Mike Quinn >>> Tom Lane <[EMAIL PROTECTED]> 4/27/04 9:38:58 PM >>> "Mike Quinn" <[EMAIL PROTECTED]> writes: >

[BUGS] make check regression "test stats" failed

2004-04-26 Thread Mike Quinn
Postgresql Version 7.4.2 Slackware 9.1 kernel 2.4.26 I did: ./configure make make check Here is the regression.diffs file: *** ./expected/stats.outFri Oct 31 19:18:20 2003 --- ./results/stats.out Wed Apr 21 09:41:57 2004 *** *** 62,68 WHERE st.relname='tenk2' AND cl.

[BUGS] postgres-win32

2004-07-16 Thread Mike Evans
B.EXE but was not the same version as " INITDB.EXE". Check your installation. C:\> -- *** Mike Evans Dept of Chemistry UMIST P.O. Box 88 Manchester M60 1QD Mobile: 07790 67 47 18 *** -

[BUGS] beta - win32, restore from pg_dump not possible

2004-08-09 Thread Mike G
ile is the command I am executing. Even if I use the -U option it still prompts for a password and then automatically jumps to the next step without me having a chance to enter the password. Mike ---(end of broadcast)--- TIP 6: Have you searched

[BUGS] 8.0 beta service won't start

2004-09-10 Thread Mike Hornick
Hi,   We’ve been using Postgres for about a year.  I recently installed the beta 8.0 Windows version on my XP laptop.  It worked fine for about a week, but now the service will not start.   Here’s the message I receive:       Any ideas?     Michael Hornick Insurance Systems I

Re: [BUGS] 8.0 beta service won't start

2004-09-22 Thread Mike Hornick
Thanks guy's - I'll try it. Michael Hornick Insurance Systems Inc. [EMAIL PROTECTED] -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: September 11, 2004 11:43 AM To: Bruce Momjian Cc: Mike Hornick; [EMAIL PROTECTED] Subject: SV: [BUGS] 8.0 beta service w

[BUGS] Substring function incorrect when searching for '@.'

2004-10-12 Thread Mike G.
followed by a period. 7.3.4 using psql via pgadminIII under cygwin. Mike ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [BUGS] solaris 10 with gcc 3.3.2

2004-12-18 Thread Mike Mascari
10/3.3.2/install-tools # ./mkheaders and they should be good to go Mike Mascari ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] solaris 10 with gcc 3.3.2

2004-12-18 Thread Mike Mascari
Mike Mascari wrote: Tom Lane wrote: I wrote: This is standard practice for gcc: it tries to use "cleaned up" versions of system headers that will not elicit useless warnings from gcc. It's a good idea, actually, because the degree of insanity in vendor-supplied system he

[BUGS] BUG #1414: DOC - pl/Perl hash tags missing

2005-01-20 Thread Mike Blackwell
The following bug has been logged online: Bug reference: 1414 Logged by: Mike Blackwell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: N/A Description:DOC - pl/Perl hash tags missing Details: In the pl/Perl section of the 8.0.0 manual

Re: [BUGS] /df doesn't work with pg_autovacuum

2005-01-21 Thread Mike Cox
Mike Cox <[EMAIL PROTECTED]> writes: > When I have pg_autovacuum on, df doesn't work. When I turn it off, > /df works. ^ I have a typo in this message. \df doesn't work, when pg_autovacuum is on. ---(end of broadcast)--

[BUGS] /df doesn't work with pg_autovacuum

2005-01-21 Thread Mike Cox
When I have pg_autovacuum on, df doesn't work. When I turn it off, /df works. The error message I get is "less is not found". In the pg_postgresql.conf I have these set as the README suggests: stats_start_collector = true stats_row_level = true Hope that helps. ---(

[BUGS] BUG #1629: subquery IN returns incorrect results

2005-04-27 Thread mike g
The following bug has been logged online: Bug reference: 1629 Logged by: mike g Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:subquery IN returns incorrect results Details: If I run this query: SELECT distinct

Re: [BUGS] BUG #1629: subquery IN returns incorrect results

2005-04-27 Thread Mike G.
Sorry, I used the online bug reporting form and it doesn't have an option to attach a file to it. If it had I would have attached a pg_dump file. Mike On Wed, Apr 27, 2005 at 10:57:42AM -0400, Tom Lane wrote: > "mike g" <[EMAIL PROTECTED]> writes: > > Descripti

Re: [BUGS] BUG #1629: subquery IN returns incorrect results

2005-04-27 Thread Mike G.
[snip] You are correct about the comma missing between the B and C in the query. It is turning it into B'C. I can't think of a good way for postgres to try and generate a warning in case a typo like this is made. Thank you. Mike > > Unless this is a copy/paste error, y

Re: [BUGS] BUG #1635: Failed to create process for initdb

2005-04-28 Thread Mike G.
Did you remove the postgres user account before reinstalling? On Wed, Apr 27, 2005 at 06:49:59PM +0100, Tom wrote: > > The following bug has been logged online: > > Bug reference: 1635 > Logged by: Tom > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating sy

Re: [BUGS] BUG #1638: ODBC driver problem

2005-04-29 Thread Mike G.
I believe the ODBC package is managed by a different group. Bugs can be viewed and added here: http://gborg.postgresql.org/project/psqlodbc/bugs/buglist.php Mike On Fri, Apr 29, 2005 at 04:31:02PM +0100, Vig Sandor wrote: > > The following bug has been logged online: > > B

[BUGS] BUG #1988: keygen not implemented

2005-10-23 Thread Mike Clements
The following bug has been logged online: Bug reference: 1988 Logged by: Mike Clements Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: WinXP Description:keygen not implemented Details: Create a table with an integer primary key using a

Re: [BUGS] BUG #1988: keygen not implemented

2005-10-24 Thread Mike Clements
nday, October 23, 2005 2:24 PM > To: Mike Clements > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #1988: keygen not implemented > > Mike Clements wrote: > > > Insert a row into the table using: > > Connection.prepareStatement(sql, Statement.RETURN_GENERATED

Re: [BUGS] BUG #2000: psql does not prompt for password

2005-10-28 Thread Mike Grant
I get the same thing with 8.0.4, on Windows XP Professional. ~Mike Bruce Momjian wrote: > Todd wrote: > > > > The following bug has been logged online: > > > > Bug reference: 2000 > > Logged by: Todd > > Email address: [EMAIL PROTEC

[BUGS] BUG #2354: No admin rights, but still refuses to run

2006-03-22 Thread Mike Haller
The following bug has been logged online: Bug reference: 2354 Logged by: Mike Haller Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3-1 Operating system: Windows 2000 Description:No admin rights, but still refuses to run Details: Hi Postgres-People, i

Re: [BUGS] BUG #5532: Valid UTF8 sequence errors as invalid

2010-06-30 Thread Mike Lewis
> > > > It is not valid. See http://tools.ietf.org/html/rfc3629 --- a sequence > beginning with ED must have a second byte in the range 80-9F to be > legal, and this doesn't. The example you give would decode as U+DF2D, > ie part of a surrogate pair, which is specifically disallowed in UTF8 > ---

[BUGS] BUG #5534: IS DOCUMENT predicate errors instead of returning false

2010-07-01 Thread Mike Fowler
The following bug has been logged online: Bug reference: 5534 Logged by: Mike Fowler Email address: m...@mlfowler.com PostgreSQL version: 9.0beta2 Operating system: Linux 2.6.31-14-generic #48-Ubuntu SMP Description:IS DOCUMENT predicate errors instead of returning

Re: [BUGS] BUG #5534: IS DOCUMENT predicate errors instead of returning false

2010-07-02 Thread Mike Fowler
Quoting Mike Fowler : The following bug has been logged online: Bug reference: 5534 Logged by: Mike Fowler Email address: m...@mlfowler.com PostgreSQL version: 9.0beta2 Operating system: Linux 2.6.31-14-generic #48-Ubuntu SMP Description:IS DOCUMENT predicate

[BUGS] BUG #5587: Installer non-default file association problem

2010-08-02 Thread Mike Parfitt
The following bug has been logged online: Bug reference: 5587 Logged by: Mike Parfitt Email address: m_parf...@hotmail.com PostgreSQL version: 8.4.4.1 Operating system: Windows XP SP3 Description:Installer non-default file association problem Details: When the

Re: [BUGS] LINE COMMAND

2010-08-16 Thread Mike Fowler
html Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5623: xml2 and uuid-ossp contribs fail to compile

2010-08-18 Thread Mike Fowler
you build postgres with xml support? As in: path/to/pgsql/src> ./configure --with-libxml path/to/pgsql/src> make && make check Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to

Re: [BUGS] BUG #5745: geometry bug?

2010-11-10 Thread Mike Fowler
lated against the midpoint of the line instead? Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5859: XML result in line and column

2011-02-14 Thread Mike Fowler
.0 and PostgreSQL won't support XQuery any time soon (http://wiki.postgresql.org/wiki/XML_Support#Future_Projects). Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #5974: UNION construct type cast gives poor error message

2011-04-14 Thread Mike Fowler
L | NULL 1 | | 2 | 3 | 3 | | 4 In Oracle I get a delicious error message: Error: ORA-00923: FROM keyword not found where expected SQLState: 42000 ErrorCode: 923 Position: 19 Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-bugs mailing list (

Re: [BUGS] BUG #5974: UNION construct type cast gives poor error message

2011-04-14 Thread Mike Fowler
inues. Patch attached. Regards, -- Mike Fowler Registered Linux user: 379787 *** a/src/backend/parser/parse_coerce.c --- b/src/backend/parser/parse_coerce.c *** *** 1161,1167 select_common_type(ParseState *pstate, List *exprs, const char *context, (er

[BUGS] BUG #6056: sorting issues

2011-06-13 Thread Mike Hepworth
The following bug has been logged online: Bug reference: 6056 Logged by: Mike Hepworth Email address: michael.w.hepwo...@gmail.com PostgreSQL version: 8.4 Operating system: Ubuntu 10.4 Description:sorting issues Details: Have database that is utf-8 encoding so that

[BUGS] BUG #6122: Installation fails: "database cluster initialisation failed"

2011-07-19 Thread Mike Holywell
The following bug has been logged online: Bug reference: 6122 Logged by: Mike Holywell Email address: m...@segment8.co.uk PostgreSQL version: 9.0.4 Operating system: Mac OSX 10.7 (Lion) Description:Installation fails: "database cluster initialisation failed&quo

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-12 Thread Mike Wilson
This can be closed. I figured out what I was doing wrong, which was after the conversion I was cleaning up the old datadir by deleting it, which destroyed the hard links to the data since I am using pg_upgrade --link Mike Wilson On Jul 12, 2012, at 3:49 PM, Bruce Momjian wrote: > On

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-15 Thread Mike Wilson
trying to get the non-link version of the upgrade working. That would be relatively painful though as this upgrade will be for a commercial internet site that can't easily tolerate a long down and the production DB is over a TB in size. I am really looking forward to 9.2's index o

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-16 Thread Mike Wilson
s () + 116 0040ae62 main () + 106 0040580c () As to the ownership, the bash script I am testing 9.1.4 and 9.2.0 with recursively chowns the directory that owns the old and the new PGDATA directory before running pg_upgrade. Mike Wilson mfwil...@gmail.com On Jul 15, 2012,

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-16 Thread Mike Wilson
and re-compiled. Still have the problem unfortunately. Cheers. Mike Wilson mfwil...@gmail.com On Jul 15, 2012, at 2:45 PM, Tom Lane wrote: > Mike Wilson writes: >> I've had some time to examine this closer over the weekend. It >> appears that pg_upgrade for 9.2b2 segf

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-17 Thread Mike Wilson
ke to make sure that I'm using the same version as your successful test. Thanks. Mike Wilson mfwil...@gmail.com On Jul 17, 2012, at 4:39 PM, Bruce Momjian wrote: > On Tue, Jul 17, 2012 at 04:01:08PM -0700, Mike Wilson wrote: >> Please find below the full pg_upgrade output. Let

Re: [BUGS] BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

2012-07-18 Thread Mike Wilson
Tom, after patching pg_upgrade now runs successfully. I noticed that this patch had been applied since yesterday to the REL9_2_STABLE so I also tested with a git pull without the patch that appears to work also. I think issue has been resolved for me, thanks so much! You guys rock! Mike

[BUGS] initdb.exe changes --locale option

2012-09-10 Thread Mike Toews
rance where it appears that the value after "=" is used to populate the drop-down menu. -Mike -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] initdb.exe changes --locale option

2012-09-10 Thread Mike Toews
Furthermore, to compare with initdb.exe from 9.1 on the same computer, here are the key : value pairs from the --locale="key" and locale used. >"C:\Program Files\PostgreSQL\9.1\bin\initdb.exe" --version initdb (PostgreSQL) 9.1.4 C : C English : English French : French nonsense : English_United Ki

Re: [BUGS] BUG #7530: initdb.exe ignores --locale option, uses "English_United States.1252"

2012-09-11 Thread Mike Toews
b.exe changes --locale option" http://archives.postgresql.org/pgsql-bugs/2012-09/msg00083.php -Mike -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] initdb.exe changes --locale option

2012-09-11 Thread Mike Toews
ew Zealand.1252 Interestingly, this OS displays "initdb: invalid locale name" (six times), whereas I don't recall seeing that message with Vista. But it doesn't tell me that "English, New Zealand" is invalid, while it changes the locale to "English_United

Re: [BUGS] initdb.exe changes --locale option

2012-09-12 Thread Mike Toews
.c, which appears to assume only POSIX locale of the format: [language[_territory][.codeset][@modifier]] E.g., see find_matching_ts_config, which assumes this locale format: http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/initdb/initdb.c;h=824c7fa7e4c76e0a3b8204ce0cdd21564f23d5df;hb=HEAD#l886 It

[BUGS] Mixed newlines in Windows installer files

2012-09-18 Thread Mike Toews
at ends with lots of extra whitespace, but no line ending.) Note that mixed newlines do not appear to change their behaviour, but I could be mistaken. -Mike -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs