Re: [HACKERS] VACUUM FULL Error

2016-12-29 Thread Hayes, Patrick
Hi there Can this be forwarded to someone who can assist with this query? Thank you, Patrick Hayes From: Hayes, Patrick Sent: 29 December 2016 12:26 To: 'pgsql-hackers@postgresql.org' Subject: FW: VACUUM FULL Error Hi there Any suggestion how to get around this issue I am having w

[HACKERS] FW: VACUUM FULL Error

2016-12-29 Thread Hayes, Patrick
and start with a blank canvas. Not an option I want to take as I am not postgre SQL expect. Help!!! From: Hayes, Patrick Sent: 29 December 2016 10:53 To: 'pgadmin-supp...@postgresql.org' Subject: VACUUM FULL Error Hi pgAdmin support, Recently truncated tables in Postgre SQL DB and now

Re: [HACKERS] PostgreSQL for VAX on NetBSD/OpenBSD

2014-06-30 Thread Patrick Finnegan
Last I checked, NetBSD doesn't support any sort of multiprocessor VAX. Multiprocessor VAXes exist, but you're stuck with either Ultrix or VMS on them. Pat On Sun, Jun 29, 2014 at 2:06 PM, Tom Lane wrote: > Dave McGuire writes: > > On 06/29/2014 10:54 AM, Andres Freund wrote: > >> Maybe I'm j

Re: [HACKERS] PostgreSQL for VAX on NetBSD/OpenBSD

2014-06-30 Thread Patrick Finnegan
On Sun, Jun 29, 2014 at 3:01 PM, Dave McGuire wrote: > On 06/29/2014 02:58 PM, Patrick Finnegan wrote: > > Last I checked, NetBSD doesn't support any sort of multiprocessor VAX. > > Multiprocessor VAXes exist, but you're stuck with either Ultrix or VMS > > on t

Re: [HACKERS] PostgreSQL for VAX on NetBSD/OpenBSD

2014-06-30 Thread Patrick Finnegan
On Sun, Jun 29, 2014 at 3:12 PM, Dave McGuire wrote: > On 06/29/2014 03:10 PM, Patrick Finnegan wrote: > > And it also runs on the 11/780 which can have multiple CPUs... but I've > > never seen support for using more than one CPU (and the NetBSD page > > still says &qu

Re: [HACKERS] Static Code Analysis Exploits.

2014-03-08 Thread Patrick Curran
On 03/07/2014 07:19 PM, Tom Lane wrote: Patrick Curran writes: We use Postgres in our product and we have a client that requires a static code analysis scan to detect vulnerabilities. They are concerned because the tool (Veracode) found several flaws in Postgres and they believe there might

[HACKERS] Static Code Analysis Exploits.

2014-03-07 Thread Patrick Curran
on 9.3.2.1 was scanned. Please let me know if there is a better place to ask this kind of question. Thanks, Patrick Stack-based Buffer Overflow (CWE ID 121)(13 flaws): There is a potential buffer overflow with these functions. If an attacker can contro

Re: [HACKERS] Full GUID support

2011-07-11 Thread Patrick Earl
t would be handy to be able to generate these without having to load in special extensions. It's not the biggest deal though since we can run initialization code to get the database set up... just more effort. Patrick Earl On Mon, Jul 11, 2011 at 11:19 AM, Joshua D. Drake wrote:

Re: [HACKERS] Select For Update and Left Outer Join

2011-07-10 Thread Patrick Earl
for your consideration in this matter. Patrick Earl -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Select For Update and Left Outer Join

2011-05-01 Thread Patrick Earl
lected rows. select * from pet left join cat ... for update of pet, cat; On a conceptual level, I still tend to think of select for update as "locking the data returned by the query." If no data is returned by the query, I don't get a lock on that non-data. Is this an area

Re: [HACKERS] Select For Update and Left Outer Join

2011-05-01 Thread Patrick Earl
On Sun, May 1, 2011 at 4:05 PM, Tom Lane wrote: > Patrick Earl writes: >> The query to get all the pets is as follows: > >> select * from Pet >> left join Dog on Dog.Id = Pet.Id >> left join Cat on Cat.Id = Pet.Id > >> Now suppose you want to lock

[HACKERS] Select For Update and Left Outer Join

2011-05-01 Thread Patrick Earl
char" which defaults to zero doesn't work on PostgreSQL because it's apparently still using zero-terminated string functions. :( Aside from those two things, it looks like PostgreSQL is going to be passing all the tests soon, so that's good news. :) Patrick Earl -- Se

Re: [HACKERS] quoting bug?

2008-02-09 Thread Patrick Welche
On Sat, Feb 09, 2008 at 12:29:10PM -0500, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > I am surprised to see > > > NOTICE: (1,two,"Sat 09 Feb 16:47:44.514503 2008") > > This is the expected formatting for a composite type. Read >

[HACKERS] quoting bug?

2008-02-09 Thread Patrick Welche
;Sat 09 Feb 16:47:44.514503 2008') INSERT 0 0 i.e., a row whose columns look as though they went through quote_literal rather than through quote_ident. This is with yesterday's 8.3.0 (Feb 8 17:24 GMT) Thoughts? Cheers, Patrick ---(end of broadcast)-

Re: [HACKERS] Password policy

2008-01-22 Thread Patrick McPhee
to fit in the extra data. D'Arcy, if you're interested I'll send you a patch. -- Patrick TJ McPhee <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

[HACKERS] autoconf

2007-12-05 Thread Patrick Welche
oconf version, instead of a lower bound only. a good idea? Cheers, Patrick ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[HACKERS] write past chunk end in ExprContext / to_char

2007-06-28 Thread Patrick Welche
-- ##,###,###,### (1 row) So strangely, to get the worrying WARNING, I seem to need >INT_MAX with a format string with 1 less positions than necessary - no wonder I seemed to only see it randomly... Thoughts? Cheers, Patrick ---(end of broadcast)-

Re: [Monotone-devel] Re: [HACKERS] SCMS question

2007-02-22 Thread patrick
ose). there was once some work on msvc support, but I have no idea what happened to that. patrick georgi ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining colum

Re: [HACKERS] coalesce and aggregate functions

2006-12-12 Thread Patrick Welche
On Tue, Dec 12, 2006 at 03:33:04PM +, Heikki Linnakangas wrote: > BTW: This type of questions really belong to pgsql-general or > pgsql-novice, this list is for discussing development of PostgreSQL itself. ^^ Indeed - I am truly feeling like a novice now... Cheers, P

[HACKERS] coalesce and aggregate functions

2006-12-12 Thread Patrick Welche
t the constant. I would have expected it only in the case where sum() returns null.. What am I missing? Cheers, Patrick (PostgreSQL 8.2devel of 21st November 2006) ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] inet increment with int

2006-05-01 Thread Patrick Welche
On Sat, Apr 29, 2006 at 10:24:48PM -0400, Bruce Momjian wrote: > > FYI, 8.2 will have this and more based on this applied patch: > > Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inet > minus inet. I know, I'm already using it :

Re: [HACKERS] float8 regression test failure in head

2006-04-20 Thread Patrick Welche
- PostgreSQL 8.2devel on i386-unknown-netbsdelf3.99.17, compiled by GCC gcc (GCC) 3.3.3 (NetBSD nb3 20040520) (1 row) 1e-400 wasn't rounded down to 0. Cheers, Patrick ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Summer of Code Preparation

2006-04-06 Thread Patrick Welche
uldn't count. :) ) Was that throw out names for projects? How about Postgres-R for PostgreSQL-8? Even if nothing comes out of it, both databases and group communications are excellent CS topics for a student. Cheers, Patrick ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] float8 regression test failure in head

2006-04-05 Thread Patrick Welche
float8-small-is-zero_1.out probably needs it too, float8.out and float8-exp-three-digits-win32.out already look OK. Cheers, Patrick Index: float8-small-is-zero.out === RCS file: /projects/cvsroot/pgsql/src/test/regress/expected/float8-

[HACKERS] recover without $PGDATA/global

2006-04-05 Thread patrick
here's a resume of what i am doing. note that i don't have the global direcotry of $PGDATA. first of all reinstall a new hard-drive and installed the same version of postgresql (8.0.4) with the same configuration. now doing a initdb somewhere on the new hd. then createdb the

Re: [HACKERS] PostgreSQL roadmap for 8.2 and beyond.

2005-10-17 Thread Patrick Bakker
It would be useful if you could toggle SQL statement logging without restarting PostgreSQL and additionally if you could turn on selective SQL logging. Additionally, it would be great if you could log SQL statements to a separate file from the main log and in such a way that the statements are sepe

Re: [HACKERS] postmaster core dump

2005-09-19 Thread Patrick Welche
On Mon, Sep 19, 2005 at 03:59:35PM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > I seem to have an unhappy postgresql: > > Let's see a test case, not a stack trace. I haven't set up the minimalist test case yet, but the 2 tables involved

Re: [HACKERS] postmaster core dump

2005-09-19 Thread Patrick Welche
On Mon, Sep 19, 2005 at 06:12:54PM +0100, Patrick Welche wrote: > #15 0x081a4c2f in exec_simple_query ( > query_string=0x834501c "select timesliced, count(stats_id) from trans > left j I just truncated one line early.. the query was: # explain select timesliced, count(stats_

[HACKERS] postmaster core dump

2005-09-19 Thread Patrick Welche
hashCxt = 0x835a648, batchCxt = 0x835a6d4} cvs of 1 Sept, nodeHash.c v 1.94 Any thoughts? Cheers, Patrick ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] C trigger problem

2005-09-17 Thread Patrick Welche
cache lookup failed for type 4664 I haven't seen anything similar in the documentation.. What is wrong / the correct way of extracting values from the old/new rows in a C trigger fn? Cheers, Patrick ---(end of broadcast)--- TIP 9: In versions

Re: [HACKERS] inet increment with int

2005-09-16 Thread Patrick Welche
ad and make a patch for the function as a built-in... Cheers, Patrick ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] uuid type for postgres

2005-09-07 Thread Patrick Welche
builder chose to include; I > build from source and my only dependencies are bison, flex, gcc and perl. Still seems odd to me: I would expect psql to have readline, not postgres. Cheers, Patrick ---(end of broadcast)--- TIP 1: if posting/reading

Re: [HACKERS] inet increment with int

2005-09-07 Thread Patrick Welche
On Wed, Sep 07, 2005 at 02:48:00AM -, Andrew - Supernews wrote: > On 2005-09-06, Patrick Welche <[EMAIL PROTECTED]> wrote: > > Now with: > > > > test=# select '192.168.0.0/24'::inet + 1; > > ERROR: Trying to increment a network (192.168.0.

Re: [HACKERS] inet increment with int

2005-09-06 Thread Patrick Welche
On Mon, Sep 05, 2005 at 08:10:16PM +0100, Patrick Welche wrote: > On Mon, Sep 05, 2005 at 03:02:55PM -0400, Tom Lane wrote: > > Patrick Welche <[EMAIL PROTECTED]> writes: > > > * Allow INET + INT4 to increment the host part of the address, or > > > throw an err

Re: [HACKERS] inet increment with int

2005-09-05 Thread Patrick Welche
On Mon, Sep 05, 2005 at 03:02:55PM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > * Allow INET + INT4 to increment the host part of the address, or > > throw an error on overflow > > > I think that the naively coded function attached does w

Re: [HACKERS] Proof of concept COLLATE support with patch

2005-09-05 Thread Patrick Welche
.4 => /usr/local/pgsql/lib/libpq.so.4 -lintl.0 => /usr/lib/libintl.so.0 -licudata.34 => /usr/local/lib/libicudata.so.34 -licuuc.34 => /usr/local/lib/libicuuc.so.34 -licui18n.34 => /usr/local/lib/libicui18n.so.34 -licuio.34 => /usr/local/li

[HACKERS] inet increment with int

2005-09-05 Thread Patrick Welche
4'); select host+1 from list where host+1 <<= '192.168.1.0/24' and not exists ( select 1 from list where host=host+1 and host << '192.168.1.0/24' ) limit 1; If you agree that this is the right thing, I can code it l

Re: [HACKERS] upgrade path / versioning roles

2005-09-02 Thread Patrick Welche
On Thu, Sep 01, 2005 at 02:59:37PM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > I tried the fix mentioned in the earlier message to encourage > > validation. Now dumping this "fixed" database, and loadinging it into the > > new

Re: [HACKERS] upgrade path / versioning roles

2005-09-01 Thread Patrick Welche
On Thu, Sep 01, 2005 at 02:31:15PM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > I think we still recommend using *new* pg_dump to dump *old* server when > > upgrading. If one tries that with today's pg_dump (8.1beta1) against > >

[HACKERS] upgrade path / versioning roles

2005-09-01 Thread Patrick Welche
ation "pg_catalog.pg_roles" does not exist pg_dump: The command was: SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) as rolname, nspacl FROM pg_namespace Cheers, Patrick ---(end of broadcast)--- TI

Re: [HACKERS] escape string syntax and pg_dumpall

2005-07-19 Thread Patrick Welche
oes pg_tablespace, > so that seems OK. The ESCAPE version which you commited works, thanks! > Or perhaps better, use a regular regex: spcname !~ '^pg_'. The > majority of the comparable cases in psql's describe.c do it this > way, and they seem more readable to me ... Lik

[HACKERS] escape string syntax and pg_dumpall

2005-07-18 Thread Patrick Welche
te code to use E'' when escapes are used. My version of the server predates those GUC settings - could the code be assuming that my server can cope with something it can't? (Normally I would just upgrade everything - and I bet it will work - but, I th

Re: [HACKERS] inet increment w/ int8

2005-04-19 Thread Patrick Welche
loop over ip numbers in a class C looking for a free one to allocate. So, from here there is interest.. Cheers, Patrick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Cannot link to postgres 8.0.0 databases using ODBC from Access

2005-02-23 Thread Patrick Welche
On Mon, Feb 21, 2005 at 12:50:44PM +, [EMAIL PROTECTED] wrote: > host all all 127.0.0.1/0 trust Should that not be 127.0.0.1/32 ? or even host all all 127.0.0.1 255.255.255.255trust ? Patrick ---(end of broadcast)---

Re: [HACKERS] Goals for 8.1

2005-01-25 Thread Patrick Welche
On Mon, Jan 24, 2005 at 05:21:35PM -0400, Marc G. Fournier wrote: > On Sun, 23 Jan 2005, Benjamin Arai wrote: > > >What are the goals for 8.1? > > Replace ARC ... anything else is a bonus ... So the betting is that the patent will be granted.. Patrick

Re: [HACKERS] Call for port reports

2004-12-10 Thread Patrick B Kelly
--(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html Patrick B. Kelly -- v: 484.557.0646

Re: [HACKERS] Bitmap index

2004-11-27 Thread Patrick B Kelly
data warehousing. Patrick B. Kelly -- http://patrickbkelly.org ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Trouble with plpgsql on 7.4.6

2004-11-23 Thread Patrick Welche
rors to stdout. e Log errors to stdout. L Do not log errors via syslogd(8). l Log errors via syslogd(8). Cheers,

Re: [HACKERS] [Pgsphere-dev] GIST index concurrency concern

2004-11-13 Thread Patrick Clery
being "paralyzed" somehow? Thanks in advance, Patrick On Tuesday 09 November 2004 22:08, Oleg Bartunov wrote: > Oleg Bartunov <[EMAIL PROTECTED]> > Daniel, > > concurrency is a big issue of current implementation of GiST. > But it should don't bite you for

Re: [HACKERS] multiline CSV fields

2004-11-12 Thread Patrick B Kelly
On Nov 12, 2004, at 12:20 AM, Tom Lane wrote: Patrick B Kelly <[EMAIL PROTECTED]> writes: I may not be explaining myself well or I may fundamentally misunderstand how copy works. Well, you're definitely ignoring the character-set-conversion issue. I was not trying to ignore the charac

Re: [HACKERS] multiline CSV fields

2004-11-11 Thread Patrick B Kelly
On Nov 11, 2004, at 10:07 PM, Andrew Dunstan wrote: Patrick B Kelly wrote: My suggestion is to simply have CopyReadLine recognize these two states (in-field and out-of-field) and execute the current logic only while in the second state. It would not be too hard but as you mentioned it is non

Re: [HACKERS] multiline CSV fields

2004-11-11 Thread Patrick B Kelly
On Nov 11, 2004, at 6:16 PM, Tom Lane wrote: Patrick B Kelly <[EMAIL PROTECTED]> writes: What about just coding a FSM into backend/commands/copy.c:CopyReadLine() that does not process any flavor of NL characters when it is inside of a data field? CopyReadLine has no business tracking that

Re: [HACKERS] multiline CSV fields

2004-11-11 Thread Patrick B Kelly
On Nov 11, 2004, at 2:56 PM, Andrew Dunstan wrote: Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Patrick B Kelly wrote: Actually, when I try to export a sheet with multi-line cells from excel, it tells me that this feature is incompatible with the CSV format and will not i

Re: [HACKERS] multiline CSV fields

2004-11-11 Thread Patrick B Kelly
caped. Actually, when I try to export a sheet with multi-line cells from excel, it tells me that this feature is incompatible with the CSV format and will not include them in the CSV file. Patrick B. Kelly --

Re: [HACKERS] Improvements to PostgreSQL

2004-07-26 Thread Patrick Welche
core > features of the Oracle Enterprise Manager (OEM). Is there more to "remote control" than setting GUC variables? Tell me more! Cheers, Patrick ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unr

Re: [HACKERS] Log rotation

2004-03-13 Thread Patrick Welche
th newsyslog, just like any other log file? I must be missing something.. I don't see why postgresql is different.. Cheers, Patrick ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] NetBSD/acorn32

2003-11-12 Thread Patrick Welche
On Sun, Nov 09, 2003 at 09:51:31PM +0100, Peter Eisentraut wrote: > Patrick Welche writes: > > > PostgreSQL 7.5devel on arm-unknown-netbsdelf1.6ZE, compiled by GCC gcc (GCC) > > 3.3.2-nb1 > > Can you test 7.4? Several days of compiling later.. All 93 tests passed.

[HACKERS] NetBSD/acorn32

2003-11-09 Thread Patrick Welche
gcc 3.3.2, so let me build the bison. (bison 1.75 was fine for both) This doesn't say anything about postgresql though, and I'm guessing that postgresql itself would be fine with the older NetBSD/acorn32... Cheers, Patrick ---(end of broadcast)---

Re: [HACKERS] Open items

2003-10-28 Thread Patrick Welche
o, but it still rubs me the wrong way. Can anyone offer new > arguments pro or con here? Not an argument.. I use gcc, and I configure --enable-debug --enable-cassert. I was surprised reading the discussion that the "--enable-debug" was superfluous and thought it did

Re: [HACKERS] ecpg doesn't compile (datetime.h/dtime_t)

2003-10-07 Thread Patrick Welche
On Fri, Oct 03, 2003 at 03:00:36PM +0100, Patrick Welche wrote: > On Fri, Oct 03, 2003 at 12:59:19PM +0200, Michael Meskes wrote: > > On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote: > > > Today's cvs doesn't compile. I think it is due to > > >

Re: [HACKERS] ecpg doesn't compile (datetime.h/dtime_t)

2003-10-03 Thread Patrick Welche
On Fri, Oct 03, 2003 at 12:59:19PM +0200, Michael Meskes wrote: > On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote: > > Today's cvs doesn't compile. I think it is due to > > cvs diff -r1.7 -r1.8 src/interfaces/ecpg/include/datetime.h > > I have dtime_t

Re: [HACKERS] 7.4 status

2003-10-01 Thread Patrick Welche
king? > > Yes, I think we're ready for a string freeze. Alvaro, do you have > anything you still want to submit in that area? Does this count a string change? :) Patrick ? psql Index: help.c === RCS file: /projects

Re: [HACKERS] ecpg doesn't compile (datetime.h/dtime_t)

2003-09-30 Thread Patrick Welche
On Mon, Sep 29, 2003 at 08:08:01PM +0200, Michael Meskes wrote: > On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote: > > Today's cvs doesn't compile. I think it is due to > > Forgot one question. WHich platform do you use? NetBSD - to quote cvs blame: 1.42

[HACKERS] ecpg doesn't compile (datetime.h/dtime_t)

2003-09-29 Thread Patrick Welche
, or would just performing the #define, i.e., the following patch be sufficient? It allows me to compile and install postgres.. (I don't use ecpg, so I really can't say..) Cheers, Patrick Index: src/interfaces/ecpg/compatlib/informix.c

Re: [HACKERS] 2-phase commit

2003-09-26 Thread Patrick Welche
g lag to > the mix with waiting for responses), you'd expect those #s to rise ... Which I thought was the whole point of using a group communication protocol such as spread in postgresql-r. It seemed solved there... Cheers, Patrick ---(end of broadcast)---

Re: [HACKERS] missing pg_clog files ?

2003-09-23 Thread Patrick Welche
On Mon, Sep 22, 2003 at 02:21:43PM -0400, Alvaro Herrera wrote: > On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote: > > On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote: > > > Patrick Welche <[EMAIL PROTECTED]> writes: > > > &g

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Patrick Welche
On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > I hope I guessed the right syntax... > > % pg_filedump -R 71716 data/base/17148/283342 > > Yes, but this doesn't give all the available info. Add -i and -f &

Re: [HACKERS] missing pg_clog files ?

2003-09-22 Thread Patrick Welche
On Mon, Sep 22, 2003 at 10:50:22AM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > select * from olddata02_03vac offset 2573719 limit 1; > > ERROR: could not access status of transaction 1664158221 > > DETAIL: open of file "/usr/local/pgs

[HACKERS] missing pg_clog files ?

2003-09-22 Thread Patrick Welche
it? Known problem with beta1 which is now old? Cheers, Patrick ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] compile warnings in CVS HEAD?

2003-09-15 Thread Patrick Welche
oblems. At > this point, I think we should wait a while until the compiler becomes more > mature. Bother - I'm just upgrading from 2.95.3 to 3.3.1 as this will be default on NetBSD :/ Patrick ---(end of broadcast)--- TIP 3: if posting/readin

[HACKERS] PostgreSQL port from DBExperts anybody using it ?

2003-09-04 Thread Patrick
Hi, I was wondering if anybody here has any feedback on the windows version of PostgreSQL from DBExperts. Stability Speed Support Anything else I should know. Thanks -- Patrick McLaughlin Les Logiciels S.I.G.M. Inc. Programmeur analyste ---(end of broadcast

Re: [HACKERS] Upgrading my BSDI box, again

2003-07-30 Thread Patrick Welche
isks which had write cache enabled and tagged queueing. Disabling write cache has allowed them to function flawlessly since. The moral seems to be: write cache gives pretty performance figures, but you really want it swiched off. Cheers, Patrick ---(end of broadcast)--

Re: [HACKERS] cvs problem

2003-07-24 Thread Patrick Welche
On Wed, Jul 23, 2003 at 12:53:34PM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > On a different note, I also wonder about: > > > > M src/backend/parser/gram.c > > > > It seems that you checkout the source with no gram.c. Build it,

Re: [HACKERS] cvs problem

2003-07-23 Thread Patrick Welche
of cvs incorrect? (cvs -z3 update -P -d) What do you make of this bit? Cheers, Patrick ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] cvs problem

2003-07-23 Thread Patrick Welche
merged in :/ - or is my use of cvs incorrect? (cvs -z3 update -P -d) Cheers, Patrick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] backend/parser compile prob

2003-07-16 Thread Patrick Welche
On Wed, Jul 16, 2003 at 11:58:01PM +0900, [EMAIL PROTECTED] wrote: > could you try lex/scan.l 1.13 i just committed? Yes, that fixed it! Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] backend/parser compile prob

2003-07-16 Thread Patrick Welche
On Tue, Jul 15, 2003 at 12:42:45PM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: ... > > What string constant?! Will try again later... > > Which flex version are you using? You need 2.5.4 --- the most recent > versions have broken backwards compatib

Re: [HACKERS] backend/parser compile prob

2003-07-15 Thread Patrick Welche
On Tue, Jul 15, 2003 at 11:21:51AM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > I'm getting far too many errors while trying to compile gram.c in the > > backend/parser, that I must be missing something. > > I think you need to forc

[HACKERS] backend/parser compile prob

2003-07-15 Thread Patrick Welche
t' in declaration of `param' gram.y:109: warning: data definition has no type or storage class ... GNU Make version 3.79.1 % cvs diff src/backend/parser/gram.c % In other words, I'm not even regenerating gram.c with bison (GNU Bison) 1.875 flex version 2.5.4 Thoughts? Cheers, Patrick

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Patrick Welche
to hang the system, but if it reports swap failure, at least > the admin knows why it failed, rather than killing random processes. Yes! Patrick ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscr

Re: [HACKERS] Returning to the List

2003-06-10 Thread Patrick Macdonald
Excellent news. I picked up your patch but have not be able to devote a large amount of time to it. I'll send you a patch based on the cvs tip as well as some pointers to proposed changes. I'll contact you offlist about various workload proposals. Cheers, Patrick J.R. Nield wrote: I

Re: [HACKERS] request for sql3 compliance for the update command

2003-02-19 Thread Patrick Welche
I don't understand the original problem. What does informix give you? A text file full of "update table set ()=()" which you then try to feed into postgres? In that case, why not pass said text file through a sed or perl script first? Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] psql and readline

2003-02-16 Thread Patrick Welche
On Sat, Feb 15, 2003 at 03:10:19PM -0600, Ross J. Reedstrom wrote: > On Fri, Feb 14, 2003 at 11:32:02AM -0500, Tom Lane wrote: > > Patrick Welche <[EMAIL PROTECTED]> writes: > > > On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote: > > >> Well, is that a

Re: [HACKERS] psql and readline

2003-02-14 Thread Patrick Welche
On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > The sad thing is that my readline wrapper for libedit doesn't wrap > > replace_history_entry, > > Well, is that a bug in your wrapper? Or must we add a conf

Re: [HACKERS] Incremental backup

2003-02-13 Thread Patrick Macdonald
Bruce Momjian wrote: > > Patrick Macdonald wrote: > > > Yeah, it's a different method of producing a similar outcome. However, many > > companies do not want to be concerned with the management (and space) > > of archived logs. Incremental backup allows them the

Re: [HACKERS] Incremental backup

2003-02-13 Thread Patrick Macdonald
Bruce Momjian wrote: > > Patrick Macdonald wrote: > > Bruce Momjian wrote: > > > > > > Someone at Red Hat is working on point-in-time recovery, also known as > > > incremental backups. > > > > PITR and incremental backup are different beasts.

Re: [HACKERS] Incremental backup

2003-02-13 Thread Patrick Macdonald
So... it doesn't look like anyone is working on incremental backup at the moment. Cheers, Patrick > It will be in 7.4. > > --- > > Martin Marques wrote: > > How's this issue going on the 7.4 de

Re: [HACKERS] psql and readline

2003-02-13 Thread Patrick Welche
undefined reference to `replace_history_entry' ho hum.. Patrick On Wed, Feb 12, 2003 at 11:08:16PM -0500, Bruce Momjian wrote: > > Patch applied. Thanks. > > --- > > > Ross J. Reedstrom wrote: &g

Re: Changing the default configuration (was Re: [pgsql-advocacy] [HACKERS] PostgreSQL Benchmarks)

2003-02-11 Thread Patrick Welche
= 4k, and number of pages is correct in GENERIC kernel configs, SHMMAX=4M for NetBSD (8M for i386, x86_64) Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] FW: Duplicate oids!

2002-12-18 Thread Patrick Macdonald
Patrick Macdonald wrote: > > Tom Lane wrote: > > > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > > On Fri, Dec 13, 2002 at 09:43:19AM -0500, Tom Lane wrote: > > >> Actually, if you don't mind grabbing a copy of pg_filedump --- see > > &g

Re: [HACKERS] Big 7.4 items

2002-12-16 Thread Patrick Macdonald
Bruce Momjian wrote: > > Patrick Macdonald wrote: > > Bruce Momjian wrote: > > > > > > I wanted to outline some of the big items we are looking at for 7.4: > > > > > > [snip] > > > > > > Point-In-Time Recovery (PITR) > > &

Re: [HACKERS] FW: Duplicate oids!

2002-12-16 Thread Patrick Macdonald
; > Has this been updated for 7.3? Last time I looked it only did 7.2, and > > the site shows an old date. If it hasn't, are there plans to update it > > sometime soon? It would be very useful to me right now... > > AFAIK it has not been updated yet. Patrick, do you have

Re: [HACKERS] Big 7.4 items

2002-12-16 Thread Patrick Macdonald
Bruce Momjian wrote: > > I wanted to outline some of the big items we are looking at for 7.4: > > [snip] > > Point-In-Time Recovery (PITR) > > J. R. Nield did a PITR patch late in 7.3 development, and Patrick > MacDonald from Red Hat is working

[HACKERS] SIGSEGV

2002-12-09 Thread Patrick Welche
x8122e0b in ServerLoop () at postmaster.c:1002 #11 0x8122972 in PostmasterMain (argc=3, argv=0x8266030) at postmaster.c:781 #12 0x80fb135 in main (argc=3, argv=0xbfbfb4b4) at main.c:209 #13 0x8069e84 in ___start () Cheers, Patrick ---(end of broadcast)

[HACKERS] possible libpq++ prob

2002-12-06 Thread Patrick Welche
I have to leave now before figuring out what pg_config.h includes may be needed to define eg DLLIMPORT etc. More later no doubt... Cheers, Patrick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] 24:00:00 ?

2002-12-04 Thread Patrick Welche
d?), so both sides seem to be right, it's just the overall effect which seems bad. (sed s/24:00:00/23:59:59/g fixed the 5.6Gb data file..) Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] postgres core FALSE ALARM

2002-12-04 Thread Patrick Welche
I must have had an old object file in the build tree... It's all happy now. Sorry for the noise, Patrick (geometry fails just because of the ordering of the rows in "twenty") ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

[HACKERS] postgres core dump PS

2002-12-04 Thread Patrick Welche
urTuple = 0x0, hj_OuterHashKeys = 0x8454728, hj_InnerHashKeys = 0x84538d0, hj_OuterTupleSlot = 0x84527e0, hj_HashTupleSlot = 0x8452790, hj_NullInnerTupleSlot = 0x0, hj_NeedNewOuter = 1 '\001', hj_MatchedOuter = 0 '\000', hj_hashdone = 0 '\000'} of cou

[HACKERS] postgres core dump

2002-12-04 Thread Patrick Welche
nParamExec = 0} (gdb) print *node->hashjoinstate There is no member named hashjoinstate. ?? Cheers, Patrick ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PRO

Re: [HACKERS] RC1?

2002-11-20 Thread Patrick Welche
On Wed, Nov 20, 2002 at 09:33:41AM -0500, Bruce Momjian wrote: > Patrick Welche wrote: > > On Tue, Nov 19, 2002 at 06:22:08PM +0100, Peter Eisentraut wrote: > > > He was testing 7.4devel. That's not the right one. > > > > What's the difference? (Do I re

  1   2   >