[BUGS] Unable to make DBD-Pg-2.13.1

2009-05-01 Thread Mark
the cause might be? Or better still, how to fix it? :) Thanks, - Mark Vmware: {root} % /usr/local/bin/perl Makefile.PL Configuring DBD::Pg 2.13.1 PostgreSQL version: 80307 (default port: 5432) POSTGRES_HOME: /usr/local/PostgreSQL POSTGRES_INCLUDE: /usr/local/PostgreSQL/include POSTGRES_LIB: /usr/l

Re: [BUGS] Unable to make DBD-Pg-2.13.1

2009-05-01 Thread Mark
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: vrijdag 1 mei 2009 16:37 To: Craig Ringer Cc: Mark; pgsql-bugs@postgresql.org Subject: Re: [BUGS] Unable to make DBD-Pg-2.13.1 Craig Ringer writes: >> Mark wrote: >>> Until I tried to install DBD-Pg-2

Re: [BUGS] BUG #4787: Hardlink (ln) causes startup failure with bizarre "timezone_abbreviations" error

2009-05-01 Thread Mark
-Original Message- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane Sent: vrijdag 1 mei 2009 17:46 To: Mark Kramer Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4787: Hardlink (ln) causes startup failure with bizarre

Re: [BUGS] BUG #4787: Hardlink (ln) causes startup failure with bizarre "timezone_abbreviations" error

2009-05-02 Thread Mark
-Original Message- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane Sent: vrijdag 1 mei 2009 23:57 To: Mark; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4787: Hardlink (ln) causes startup failure with bizarre

Re: [BUGS] BUG #4787: Hardlink (ln) causes startup failure with bizarre "timezone_abbreviations" error

2009-05-02 Thread Mark
On Sat, 02 May 2009 14:47:48 GMT, Tom Lane wrote > Mark writes: > > I understand the rationale for relocatable packages. So, > > I guess hardlinks are out. But, barring hardlinks, > > perhaps, in the existence of a symlink, a simple 'readlink' > > f

[BUGS] Bug: 8.0.0b5 Win Server Installer

2004-11-30 Thread Mark
Test platform = Win 2000 plus all service packs, hotfixes. No previous PostgreSQL ever installed on the machine before. 8.0.0 beta 5 installation executable from http://pgfoundry.org/projects/pginstaller Installed NOT AS A SERVICE, repeat NOT as a WinNT/2K service. Told installer to put installat

[BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-01-26 Thread Mark
The following bug has been logged online: Bug reference: 5851 Logged by: Mark Email address: dvlh...@gmail.com PostgreSQL version: 9.0.2 x86_64 Operating system: CentOS release 5.5 (Final) | 2.6.18-194.17.1.el5 #1 SMP X86_64 Description:ROHS (read only hot standby

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-01-28 Thread mark
urately ? (or a value that high isn't be accepted?) I have reloaded configs and still seeing 0's I assume you would suggest I turn that number down... a lot. ..: Mark > -Original Message- > From: Robert Haas [mailto:robertmh...@gmail.com] > Sent: Friday, Januar

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-01-30 Thread mark
> -Original Message- > From: Robert Haas [mailto:robertmh...@gmail.com] > Sent: Sunday, January 30, 2011 12:19 PM > To: mark > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be > restarted manually in somecases

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-02-08 Thread mark
On Sun, Jan 30, 2011 at 12:45 PM, mark wrote: > > >> -Original Message- >> From: Robert Haas [mailto:robertmh...@gmail.com] >> Sent: Sunday, January 30, 2011 12:19 PM >> To: mark >> Cc: pgsql-bugs@postgresql.org >> Subject: Re: [BUGS] BUG #5851

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-02-08 Thread mark
> -Original Message- > From: Fujii Masao [mailto:masao.fu...@gmail.com] > Sent: Tuesday, February 08, 2011 4:00 PM > To: mark > Cc: Robert Haas; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be > restarted manually

Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

2011-03-03 Thread mark
> -Original Message- > From: Robert Haas [mailto:robertmh...@gmail.com] > Sent: Thursday, March 03, 2011 9:04 AM > To: mark > Cc: Fujii Masao; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be > restarted manually

[BUGS] BUG #6029: packaged installer fails to configure ldap

2011-05-17 Thread mark
The following bug has been logged online: Bug reference: 6029 Logged by: mark Email address: m...@remidata.com PostgreSQL version: 9.0.2 Operating system: RHEL 6.0 x86_64 Description:packaged installer fails to configure ldap Details: The source code installation

[BUGS] pgbench -T isn't a hard cutoff.

2011-08-26 Thread mark
indefinitely if the transactions never complete due to pooler issues.) Expected behavior would be -T would mean a hard cut off. Thoughts ? -Mark -- 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] question/suggestion Message-id: <493823b5.1030...@hogranch.com>

2008-12-06 Thread Mark Kirkwood
'm not sure that counts as cloud-like in its architecture... regards Mark -- 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 #4584: PostgreSQL service doesn't start

2008-12-16 Thread Mark Muzenhardt
The following bug has been logged online: Bug reference: 4584 Logged by: Mark Muzenhardt Email address: mark.muzenha...@arcor.de PostgreSQL version: 8.3.5-2 Operating system: Windows XP professional Description:PostgreSQL service doesn't start Details: I

[BUGS] BUG #4612: lc_numeric setting ignored

2009-01-12 Thread Mark Hayen
The following bug has been logged online: Bug reference: 4612 Logged by: Mark Hayen Email address: mark.ha...@atosorigin.com PostgreSQL version: 8.3.5 Operating system: Ubuntu 8.10 Description:lc_numeric setting ignored Details: When setting the LC_NUMERIC to

Re: [BUGS] BUG #4612: lc_numeric setting ignored

2009-01-13 Thread Mark Hayen
He Bruce, Thank you for replying. Does this mean that there is no way to do a "\copy from" using CSV files containing decimals with a comma? Mark Hayen ÿþDit bericht is vertrouwelijk en kan geheime informatie bevatten

[BUGS] BUG #4787: Hardlink (ln) causes startup failure with bizarre "timezone_abbreviations" error

2009-05-01 Thread Mark Kramer
The following bug has been logged online: Bug reference: 4787 Logged by: Mark Kramer Email address: r...@asarian-host.net PostgreSQL version: 8.3.7 Operating system: FreeBSD 7.1 Description:Hardlink (ln) causes startup failure with bizarre "timezone_abbrevia

[BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7

2009-06-08 Thread Mark Kirkwood
eration program for this dataset if required. regards Mark cursor-bug.tar.gz Description: GNU Zip compressed data -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [HACKERS] [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7

2009-06-10 Thread Mark Kirkwood
three-line patch. The question of how cursors should behave with respect to volatile functions can be documented and left for another time. Sounds like a good approach. Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.post

[BUGS] BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH

2009-09-02 Thread Mark Douglas
The following bug has been logged online: Bug reference: 5031 Logged by: Mark Douglas Email address: m...@steelhousemedia.com PostgreSQL version: 8.4.0 Operating system: Ubunto Linux Description:DATE_TRUNC returns the wrong value when specifying MONTH Details: The

Re: [BUGS] BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH

2009-09-02 Thread Mark Douglas
I have my timezone set to GMT so there really shouldn't be any time zone adjustments. Mark On 9/2/09 10:01 PM, "Tom Lane" wrote: "Mark Douglas" writes: > The following use of DATE_TRUNC returns the wrong value. I called the > function on 2009-09-02. It sho

Re: [BUGS] BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH

2009-09-03 Thread Mark Douglas
You're correct. When I run this from psql it returns the correct result. When I run it from DBVisualizer, which I normally use, it adjust the result to my local time zone. Thanks for looking into it. Sorry about bugging you with that. Thanks, Mark On 9/2/09 10:24 PM, "Tom Lane"

Re: [BUGS] BUG #5054: PDO -> Query returns "" from Boolean type field, if it has false value.

2009-09-14 Thread Mark Kirkwood
sult[0] . "\n"); reproduces what Yujin is seeing, whereas replacing $sql with: $sql = "SELECT false::int4"; gives a 0 in the result array. I guess it must be something funny with how PDO represents the bool type...(will have a look at the PDI code). But this needs to be raised

Re: [BUGS] BUG #5054: PDO -> Query returns "" from Boolean type field, if it has false value.

2009-09-14 Thread Mark Kirkwood
Mark Kirkwood wrote: I guess it must be something funny with how PDO represents the bool type...(will have a look at the PDO code). But this needs to be raised on bugs.php.net. FYI - a related bug is : http://bugs.php.net/bug.php?id=33876 -- Sent via pgsql-bugs mailing list (pgsql-bugs

Re: [BUGS] BUG #5054: PDO -> Query returns "" from Boolean type field, if it has false value.

2009-09-15 Thread Mark Kirkwood
sql version of this example returns a string "0" from PDO, so gives a 0 for false in a more expected/intuitive way... regards Mark -- 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 #5096: Error installing edb_apachephp.bin

2009-10-04 Thread Mark Kirkwood
t include where gatenforce lives. regards Mark -- 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 #5150: math bug

2009-11-01 Thread Mark Kirkwood
oper subset, is countable and hence has Lebesgue measure zero on the real line. ;) LOL - fortunately (going by the bug) he is not trying to compute a measure (i.e integrate) from a set of 'em. Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to you

[BUGS] statement_timeout is not cancelling query

2009-12-14 Thread Mark Williamson
not allow one customer to impact others. That's it for now. Hope someone can provide helpful answers. Thanks, Mark W.

[BUGS] Optimal platform for pg?

2009-12-15 Thread Mark Williamson
What is the most ideal/optimal platform for postgresql? Linux (distro?), freebsd, windows, etc. consider memory management, file system performance, threading model etc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgre

Re: [BUGS] BUG #5244: Attempting to rollback to a savepoint after receiving an error with state 55000 the process hangs

2009-12-16 Thread Mark Kirkwood
= 0; } echo 'Cur Id: ',$curId,"\n"; Running this code it hangs after echoing 'Rolling back', but only hangs every other execution (assuming the sequence was deleted first). I think you need to be using $pdo->exec instead of $pdo->query for everythi

[BUGS] remove

2009-12-30 Thread Mark Williamson

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

2010-01-07 Thread Mark Kirkwood
cally 'postgres' to eliminate this possibility. With respect to the libpq source, it is in the source tarball from the Postgresql website (directory src/interfaces/libpq ). regards Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes t

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

2010-01-07 Thread Mark Kirkwood
ld produce different answers. I suspect they do not. Its all in the permissions. Cheers Mark -- 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 #5268: PQgetvalue incorrectly returns 0

2010-01-07 Thread Mark Kirkwood
obert suggested, try doing 'SELECT user' in both. Also note that Pgadmin user PQexec and PQgetValue... Cheers Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Foreign key constaint can be broken

2010-01-26 Thread Mark Kazemier
: DELETE FROM b WHERE id = 1; The record from table a disappears, but the record in table b is still there. Of course this is a very stupid construction, but I would expect some kind of error / warning message instead. Now it is possible to corrupt your data. Best regards, Mark Kazemier

Re: [BUGS] BUG #5312: I NEED HELP

2010-02-04 Thread Mark Kirkwood
e you using pgAdmin? If so, just right-click on the database and select "delete/drop". Probably too late to be mentioning this... but Daniel, are you sure that the database is not needed by anything? regards Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

[BUGS] Cluster fails

2000-05-10 Thread Mark Kirkwood
Your name :Mark Kirkwood Your email address :[EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) :Intel Pentuim Operating System (example: Linux 2.0.26 ELF) :Linux 2.2.14-5.0 ELF (Redhat 6.2) PostgreSQL

[BUGS] select cash_out('2'); crashes backend on 7.0.2

2000-12-12 Thread Mark Stosberg
-linux-gnu, compiled by gcc 2.96 I'm sure if what I tried is even valid input, but I'm guessing this is not a desired result in any case. :) Thanks for the great software and good luck with this! A frequent Postgres user, -mark personal website } Sum

[BUGS] possible mis-handling of nulls in views in 7.0.2

2001-03-12 Thread Mark Stosberg
--- || | || | | (1 row) # It returns a row with a null shipment id! I'm not sure what's happening here-- I tried to simplify this to a simple case, but I couldn't reproduce t

Re: [BUGS] possible mis-handling of nulls in views in 7.0.2

2001-03-12 Thread Mark Stosberg
, so perhaps my oddity would be repaired anyway. Thanks for checking it out. -mark http://mark.stosberg.com/ Tom Lane wrote: > > Mark Stosberg <[EMAIL PROTECTED]> writes: > >I'm running Postgres 7.0.2 and have run into a curious situation. I > > got a back a nu

[BUGS] Using nulls with earthdistance operator crashes backend

2001-07-31 Thread Mark Stosberg
o be returned as the result. I can work around this by including an extra step to make sure that my data is not null before it's passed off a SQL statement like this. Thanks! -mark http://mark.stosberg.com/ ---(end of broadcast)--- T

Re: [BUGS] Using nulls with earthdistance operator crashes backend

2001-07-31 Thread Mark Stosberg
I'll give it a shot and post the patch or let you know I'm stuck. :) Thanks! -mark Tom Lane wrote: > > Mark Stosberg <[EMAIL PROTECTED]> writes: > > * Install earthdistance operator from the contrib directory. > > * try this: > > cascade=> select

Re: [BUGS] Using nulls with earthdistance operator crashes backend (patch)

2001-08-20 Thread Mark Stosberg
> Tom Lane wrote: > > > > Mark Stosberg <[EMAIL PROTECTED]> writes: > > > * Install earthdistance operator from the contrib directory. > > > * try this: > > > cascade=> select null <@> '1,1'::point; > > > > >

[BUGS] Error Restoring Large Database

2002-01-24 Thread Mark Rae
rts -b -Fc core4 > core4.dump gives these errors when trying to restore pg_restore: [archiver (db)] could not execute query: ERROR: insert_fsm_page_entry: failed to insert entry! and ERROR: insert_fsm_page_entry: failed to insert entry! in the logfile

Re: [BUGS] Error Restoring Large Database

2002-01-25 Thread Mark Rae
Tom Lane wrote: > > Mark Rae <[EMAIL PROTECTED]> writes: > > ERROR: copy: line 26501638, insert_fsm_page_entry: failed to insert entry! > > Ugh. I think I see the problem: silly oversight in this routine. > Please apply the attached patch and see if it fixes the f

[BUGS] PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly

2002-02-01 Thread Mark Jeacocke
POSTGRESQL BUG REPORT TEMPLATE Your name : Mark Jeacocke Your email address : [EMAIL PROTECTED] System

Re: [BUGS] postmaster 8.2 eternally hangs in sempaphore lock acquiring

2007-04-02 Thread Mark Shuttleworth
Martin Pitt wrote: > Hi Tom, hi Mark, > > Tom, thank you for having a look into this! > > Tom Lane [2007-03-29 13:49 -0400]: > >> Martin Pitt <[EMAIL PROTECTED]> writes: >> >>> https://launchpad.net/bugs/93042 has symbolic gdb backtraces

[BUGS] BUG #3847: plpython trigger caches table structure - doesn't see new / changed columns

2007-12-31 Thread Mark Reid
The following bug has been logged online: Bug reference: 3847 Logged by: Mark Reid Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Debian Linux Description:plpython trigger caches table structure - doesn't see new / changed co

Re: [BUGS] BUG #3847: plpython trigger caches table structure - doesn't see new / changed columns

2008-01-01 Thread Mark Reid
The trigger function does not recognize the "test4" column the second time it is added - the update throws an error. On Jan 1, 2008 11:17 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Mark Reid" <[EMAIL PROTECTED]> writes: > > If a column is added, dropped

Re: [BUGS] BUG #3847: plpython trigger caches table structure - doesn't see new / changed columns

2008-01-02 Thread Mark Reid
Works perfectly on my test case. Thanks! On Jan 1, 2008 8:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Mark Reid" <[EMAIL PROTECTED]> writes: > > The trigger function does not recognize the "test4" column the second > time > > it is adde

Re: [BUGS] BUG #3847: plpython trigger caches table structure - doesn't see new / changed columns

2008-01-02 Thread Mark Reid
We've run our real-life test cases and they've all worked properly using this patch too. Thanks again. -Mark. On Jan 1, 2008 8:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Mark Reid" <[EMAIL PROTECTED]> writes: > > The trigger function does not recog

Re: [BUGS] BUG #3833: Index remains when table is dropped

2008-01-03 Thread Mark Kirkwood
objects?) Now, I'm conscious that there could be other show stopper reasons for *not* doing this that I have not thought of, but figured I'd post in case the idea was useful. Thoughts? Cheers Mark *** src/backend/commands/tablecmds.c.orig Wed Jan 2 13:58:05 2008 --- src/backend/com

[BUGS] BUG #4059: Vacuum full not always cleaning empty tables

2008-03-25 Thread Mark Steben
The following bug has been logged online: Bug reference: 4059 Logged by: Mark Steben Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux redhat Description:Vacuum full not always cleaning empty tables Details: I sent an email to

Re: [BUGS] BUG #4059: Vacuum full not always cleaning empty tables

2008-03-26 Thread Mark Steben
Yes, there are transactions that predate the start time of the vacuum full. However those transactions do not touch the table being vacuumed, they have nothing to do with it. Is this the expected behavior? Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company

Re: [BUGS] BUG #3833: Index remains when table is dropped

2008-04-28 Thread Mark Kirkwood
there was probably a reason why this had not been tried!). Best wishes Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] 7.3b2 initdb fails with semaphore error

2002-10-01 Thread Mark Stosberg
on bug-- the location of that documentation should be spit out along with the above error message, along with being accessible through "initdb --help" and perhaps elsewhere. I look forward to another great release. Thanks! -mark http://mark.stosber

Re: [BUGS] 7.3b2 initdb fails with semaphore error (solved)

2002-10-02 Thread Mark Stosberg
On Tue, 1 Oct 2002, Tom Lane wrote: > Mark Stosberg <[EMAIL PROTECTED]> writes: > > I think the bug here is that this message advertises that I can change > > the "max_connections" parameter to address this, but there does not > > appear to be a way to do

[BUGS] Problem with building PostgreSQL 7.4 from source

2003-11-28 Thread Mark Iszler
puter as I write this and I don't remember the error message. I will send more info on that later.) I hope this all helps. Let me know if you need any more info. Mark Iszler ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[BUGS] SELECT FOR UPDATE differs inside and outside a pl/pgsql function (7.4)

2003-12-17 Thread Mark Shewmaker
ly test for problems like this.) 3. If there's some really elegant solution out there, such as a way to do a "select for update where not locked" to search for rows no one has a conflicting lock on. (To me this would seem to be the best of all possible solutio

Re: [BUGS] SELECT FOR UPDATE differs inside and outside a pl/pgsql

2003-12-17 Thread Mark Shewmaker
On Wed, 2003-12-17 at 14:02, Tom Lane wrote: > Mark Shewmaker <[EMAIL PROTECTED]> writes: > > In other words: Is this a bug or a user misunderstanding: > > You've got the function doing > > > LOOP > > select * into myrow from mytable limit 1

Re: [BUGS] SELECT FOR UPDATE differs inside and outside a pl/pgsql

2003-12-18 Thread Mark Shewmaker
On Wed, 2003-12-17 at 19:57, Tom Lane wrote: > Mark Shewmaker <[EMAIL PROTECTED]> writes: > > If a "FOR UPDATE executes before LIMIT" rule stopped the function > > from ever locking a row, it's still curious why didn't it stop the > >

[BUGS] ecpg c++ scope operator lost

2003-12-19 Thread Mark Pether
ot; char bound_waiting_state = static_cast < char > ( Processor : : waiting ) ; /* exec sql end declare section */ #line 93 "Schedule.pgcc" The scope operator becomes space padded and compiler barfs. Work around is to initialise variables outside of declare sect

Re: [BUGS] ecpg c++ scope operator lost

2003-12-22 Thread Mark Pether
lt;mailto:[EMAIL PROTECTED]>>) and Michael Meskes (<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>). Regards, Mark Pether. Michael Meskes wrote: On Wed, Dec 17, 2003 at 03:14:31PM -0500, Mark Pether wrote: Ecpg pretty prints my code causing compile errors. Please note that ecpg

[BUGS] Bug report on Solaris 8/x86

2004-08-13 Thread Mark Round
e --with-CXX --with-includes=/opt/csw/include/openssl Any suggestions ? Thanks in advance, -Mark [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [BUGS] We are not following the spec for HAVING without GROUP

2005-03-09 Thread Mark Shewmaker
2 NULL (1 row affected) 1> select 2 as id, max(myfield) from mytable having 2=1 2> go id --- -- (0 rows affected) -- Mark Shewmaker [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3:

Re: [BUGS] [HACKERS] We are not following the spec for HAVING without GROUP BY

2005-03-10 Thread Mark Shewmaker
rows. A plain "select 1 from tab" returns zero rows when tab is empty. -- Mark Shewmaker [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] [HACKERS] We are not following the spec for HAVING without GROUP

2005-03-13 Thread Mark Kirkwood
Tom Lane wrote: Would those of you with access to other DBMSes try this: create table tab (col integer); select 1 from tab having 1=0; select 1 from tab having 1=1; insert into tab values(1); insert into tab values(2); select 1 from tab having 1=0; select 1 from tab having 1=1; I claim that a SQL-c

[BUGS] BUG #1671: Long interval string representation rejected

2005-05-16 Thread Mark Dilger
The following bug has been logged online: Bug reference: 1671 Logged by: Mark Dilger Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Mandrake Linux 9.1 (2.4.21-0.13mdkenterprise #1 SMP) Description:Long interval string representation

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-05-22 Thread Mark Shewmaker
poor schema design is a separate issue.) Are there any downsides to changing the order of pg_dump output with respect to constraints? (Versus requiring users to alter their schema design.) -- Mark Shewmaker [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[BUGS] pg_autovacuum: short, wide tables

2005-07-07 Thread mark reid
is a snippet of output from a run of vacuumdb --full --analyze --verbose that should illustrate the problem. -Mark. Table Def: Table "schema_name.properties" Column | Type| Modifiers +---+--- name | character varying | value | character

Re: [BUGS] pg_autovacuum: short, wide tables

2005-07-09 Thread Mark Reid
Matthew T. O'Connor wrote: Tom Lane wrote: I think Mark is probably on to something. The activity in the toast table will show as deletes *in the toast table* ... and that activity fails to show at all in the pg_stat_activity view, because it shows only plain relations! So unless autov

Re: [BUGS] pg_autovacuum: short, wide tables

2005-07-09 Thread Mark Reid
mizing the amount of work that needs to be done when a vacuum is necessary.  OTOH, you can't stop regular vacuum from including the toast table otherwise way more people would start bugging you :) -Mark.

[BUGS] BUG #1874: Non-Execute Privileges enforced on grant

2005-09-10 Thread Mark Diener
The following bug has been logged online: Bug reference: 1874 Logged by: Mark Diener Email address: [EMAIL PROTECTED] PostgreSQL version: 8.03 Operating system: linux-i686 Description:Non-Execute Privileges enforced on grant Details: It seems the EXECUTE privilege

[BUGS] suggestion: fix 'now' -> CURRENT_TIMESTAMP

2005-09-23 Thread Mark Stosberg
using 'now' and timestamp() are not recommended practices anyway ? I have seen that PostgreSQL has already taken the liberty to rewrite "serial" and other schema constructions when they are dumped or imported, so I see no problem with rewriting code to equ

Re: [BUGS] suggestion: fix 'now' -> CURRENT_TIMESTAMP

2005-09-24 Thread Mark Stosberg
On 2005-09-23, Tom Lane <[EMAIL PROTECTED]> wrote: > Mark Stosberg <[EMAIL PROTECTED]> writes: >> Why not make the translation on the fly, since using 'now' and >> timestamp() are not recommended practices anyway ? > > Because we can't retroactivel

[BUGS] BUG #1970: Existing /etc/pam.d/postgresql clobbered by RPM install

2005-10-18 Thread Mark Gibson
The following bug has been logged online: Bug reference: 1970 Logged by: Mark Gibson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Redhat Enterprise Linux 4 Description:Existing /etc/pam.d/postgresql clobbered by RPM install Details

[BUGS] BUG #2031: Patch also required prior to ML3

2005-11-09 Thread Mark Gibson
The following bug has been logged online: Bug reference: 2031 Logged by: Mark Gibson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: AIX 5.3 (5300-01) Description:Patch also required prior to ML3 Details: Hello, I've just downloade

Re: [BUGS] BUG #2031: Patch also required prior to ML3

2005-11-10 Thread Mark Gibson
Seneca Cunningham wrote: Mark Gibson wrote: AIX hasn't had any maintence levels applied yet, so oslevel -r returns: 5300-01. _SS_MAXSIZE has been set to 1025 manually, this was required for 8.0.4. But with 8.1.0 the patch for dynahash.c had to be applied before the regression tests woul

[BUGS] xml data type implications of no =

2010-05-24 Thread Mark Kirkwood
g at least an "=" operator to enable some minimal stats to be available for xml columns. regards Mark

Re: [BUGS] BUG #5469: regexp_matches() has poor behaviour and more poor documentation

2010-05-25 Thread Mark Kirkwood
misleading (e.g user error or not reading the docs), but I don't think we should try (too hard anyway) to smother any strong criticism. regards Mark -- 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] xml data type implications of no =

2010-05-26 Thread Mark Kirkwood
On 25/05/10 16:43, Mark Kirkwood wrote: Today I ran into some interesting consequences of the xml data type being without an "=" operator. One I thought I'd post here because it has a *possible* planner impact. I'm not sure it is actually a bug as such, but this seemed th

Re: [BUGS] Bad optimizer data for xml (WAS: xml data type implications of no =)

2010-06-03 Thread Mark Kirkwood
On 27/05/10 13:37, Mark Kirkwood wrote: On 25/05/10 16:43, Mark Kirkwood wrote: Today I ran into some interesting consequences of the xml data type being without an "=" operator. One I thought I'd post here because it has a *possible* planner impact. I'm not sure it is act

Re: [BUGS] Bad optimizer data for xml (WAS: xml data type implications of no =)

2010-06-08 Thread Mark Kirkwood
On 09/06/10 15:22, Robert Haas wrote: On Thu, Jun 3, 2010 at 7:16 PM, Mark Kirkwood wrote: Maybe I gave this guy a bad title - is it a concern that the 'width' estimate is so far off for xml datatypes (because of no = op)? It seemed to me that this could result in some bad pl

Re: [BUGS] Bad optimizer data for xml (WAS: xml data type implications of no =)

2010-06-08 Thread Mark Kirkwood
alculation. However the system allows only the first, so if you don't (or can't) have one then you lose some possibly important optimization data. regards Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [BUGS] Bad optimizer data for xml (WAS: xml data type implications of no =)

2010-06-09 Thread Mark Kirkwood
On 10/06/10 02:17, Tom Lane wrote: Mark Kirkwood writes: It seems that the nub of this issue is that there are conceptually two types of =, one for datatype specific comparison, and one for optimizer statistical information calculation. However the system allows only the first, so if you

Re: [BUGS] DETAIL: Failed on request of size 8

2010-07-22 Thread Mark Kirkwood
On 23/07/10 14:34, vamsi krishna wrote: Hi I am running a query on postgres and got the following error: ERROR: out of memory DETAIL: Failed on request of size 8 Hmm - looks like your system needs more memory to complete the query (ahem - would help to see the query, plus EXPLAIN outp

Re: [BUGS] BUG #5595: Documentation is not installs from VPATH build.

2010-08-03 Thread Mark Kirkwood
f a downloaded one then it work work fine (suspect Tom used a checked out tree) Tom? Cheers Mark -- 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 #5595: Documentation is not installs from VPATH build.

2010-08-04 Thread Mark Kirkwood
iner-clean' removes then, but any lesser level of clean doesn't. Hmm - shouldn't a VPATH build look at its *own* doc/src/sgml/*-stamp files to see if it needs to build the docs? Note that it does *create* them in there after a successful build... Cheers Mark -- Sent via pgsql

[BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running

2010-09-09 Thread Mark Llewellyn
The following bug has been logged online: Bug reference: 5650 Logged by: Mark Llewellyn Email address: mark_llewel...@adp.com PostgreSQL version: 9.0 RC1 Operating system: Windows XP Description:Postgres service showing as stopped when in fact it is running Details

Re: [BUGS] BUG #5665: VPATH catalog/schemapg.h

2010-09-20 Thread Mark Kirkwood
here like to fix stuff - but cannot fix your bug unless you help by supplying what has been asked for. Best wishes Mark On 21/09/10 08:37, Graham Swallow wrote: Noone else has missing files, in the wrong places, Its not their problem. All of the files on all of your machines, are in the right

[BUGS] src/tools/fsync/test_fsync.c does not compile

2010-09-30 Thread Mark Kirkwood
it fix it for me. regards Mark diff --git a/src/tools/fsync/test_fsync.c b/src/tools/fsync/test_fsync.c index 3c9c6b6..28c2119 100644 --- a/src/tools/fsync/test_fsync.c +++ b/src/tools/fsync/test_fsync.c @@ -63,7 +63,7 @@ main(int argc, char *argv[]) for (i = 0; i < XLOG_SEG_SIZE

[BUGS] Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby

2010-10-27 Thread Mark Kirkwood
ifact of log shipping? The is 8.3.11 on Debian Lenny x86-64. Thanks Mark -- 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] Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby

2010-10-28 Thread Mark Kirkwood
On 29/10/10 04:32, Alvaro Herrera wrote: Excerpts from Mark Kirkwood's message of jue oct 28 02:20:56 -0300 2010: I'm guessing the index error is due to the uninitialized table pages (the index "content_node_node_type_id_inserted_idx" is on the "node" table).

Re: [BUGS] Btree index left link changed unexpectedly after bringing up 8.3.11 warm standby

2010-10-28 Thread Mark Kirkwood
t happens if we start it up and try a VACUUM - however the dbas may have set the box up as a slave again before we noticed the memory errors (so possibly deleted the old master). Cheers Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your sub

[BUGS] BUG #5734: autovacuum_enabled input should be validated, standardized.

2010-10-30 Thread Mark Stosberg
The following bug has been logged online: Bug reference: 5734 Logged by: Mark Stosberg Email address: m...@summersault.com PostgreSQL version: 9.0.1 Operating system: FreeBSD Description:autovacuum_enabled input should be validated, standardized. Details: The

Re: [BUGS] BUG #5862: Postgres dumps core upon a connection attempt

2011-02-08 Thread Mark Kirkwood
PATH=/usr/local/pgsql/bin:$PATH $ export LD_LIBRARY_PATH=/usr/local/pgsql/lib $ initdb -D /data/postgres $ pg_ctl -D /data/postgres start; $ psql I'm guessing that there are older libraries or binaries earlier in your various env paths, and these are tripping up postgres. Cheers Mark -- Se

[BUGS] Hung Vacuum in 8.3

2011-02-21 Thread Mark Kirkwood
vacuum, but any suggestions for getting more diag info for next time? regards Mark -- 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] Hung Vacuum in 8.3

2011-02-21 Thread Mark Kirkwood
site, there is no call for queries that run this long (i.e way longer than the timeout for the respective page rendering). Thanks for the clarification (assuming I've understood correctly of course...). Cheers Mark -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To

  1   2   >