[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: [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

[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 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] 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
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

[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] 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] 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] 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

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

[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] 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

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] 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:

[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)-

[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

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] 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] 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 >

Re: [HACKERS] Documentation on page files

2002-04-22 Thread Patrick Macdonald
Martijn, It may be useful to look at the pg_filedump utility located at http://sources.redhat.com/rhdb/tools.html This utility dumps out information at the page level and is commented to help the user understand the format/content of PostgreSQL heap/index/control files. Cheers, Patrick

Re: [HACKERS] PostgreSQL mission statement?

2002-05-12 Thread Patrick Welche
On Thu, May 02, 2002 at 01:14:34PM -0300, Marc G. Fournier wrote: > On 2 May 2002, Hannu Krosing wrote: ... > > BTW, I think PostgreSQL does _not_ need any mission statement. > > Nope, it doesn't ... never did before, don't know why it does suddenly ... > do any other open source projects have on

Re: [HACKERS] Issues Outstanding for Point In Time Recovery (PITR)

2002-07-06 Thread Patrick Macdonald
stamp encountered. . forward recover stop Stop the current forward recovery session. Undo all in-flight transactions and bring the databases down in a consistent state. No other external user actions should be required. Looking forward to reading draft 2. Cheers, Patrick -- Patrick Macd

Re: [HACKERS] Issues Outstanding for Point In Time Recovery (PITR)

2002-07-08 Thread Patrick Macdonald
gt; log needs to at least be replayed to regain a consistent state. This is a nicety but not a necessity. If you have a backup end log record, you just have to enforce that the PIT recovery encounters that particular log record on forward recovery. Once encountered, you

Re: [HACKERS] Open 7.3 issues

2002-08-15 Thread Patrick Welche
gborg - cd ../.. - configure --with-CXX or would libpq++ become more removed.. (configure options to libpq++ to point to the rest or pgsql?) Cheers, Patrick (prefer former) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] mac typo prob?

2002-10-13 Thread Patrick Welche
ead of "0". I can see how that happened - should it be "notify"ed against? (pre-25 Sept code, 7.3b1) Cheers, Patrick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] RC1?

2002-11-14 Thread Patrick Welche
On Thu, Nov 14, 2002 at 06:13:56PM +, Patrick Welche wrote: > On Wed, Nov 13, 2002 at 07:53:00PM +0100, Peter Eisentraut wrote: > > Tom Lane writes: > > > > > We can't just wait around indefinitely for port reports that may or may > > > not ever a

[HACKERS] Debian build prob

2002-11-14 Thread Patrick Welche
sume it must be the same as for /usr/lib/libc.a. Have any of you managed to compile postgresql on an oldstable Debian system? Cheers, Patrick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] RC1?

2002-11-14 Thread Patrick Welche
unt? PostgreSQL 7.3b1 on i386-unknown-netbsdelf1.6H, compiled by GCC 2.95.3 (I'm trying to build bison at the mo to have a go with whatever is in cvs tip at the moment.) Cheers, Patrick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Debian build prob

2002-11-17 Thread Patrick Welche
On Thu, Nov 14, 2002 at 08:55:22PM +, Patrick Welche wrote: > Believe it or not, I'm trying to compile today's cvs pgsql on a > Debian 2.2.19 system. Compilation dies while compiling pg_dump with > > ../../../src/interfaces/libpq/libpq.so: undefined reference to `at

Re: [HACKERS] RC1?

2002-11-19 Thread Patrick Welche
os geometry/hppa.*-hpux10=geometry-positive-zeros geometry/.*-irix6=geometry-positive-zeros as this acorn32 is running on a StrongARM processor, so has nothing to do with libm387. Maybe get rid of the geometry-positive-zeros and see if someone complains and tells me otherwise? Cheers, Pat

Re: [HACKERS] RC1?

2002-11-19 Thread Patrick Welche
On Tue, Nov 19, 2002 at 10:53:59AM -0500, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > [remove this:] > > -geometry/.*-netbsd=geometry-positive-zeros > > > as this acorn32 is running on a StrongARM processor, so has nothing to do > > with li

Re: [HACKERS] RC1?

2002-11-20 Thread Patrick Welche
er 7.3rcN are smaller than the chances of it working under 7.3rcN and not under 7.4devel, no?) Patrick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PORTS] Geometry test on NetBSD (was Re: [HACKERS] RC1?)

2002-11-20 Thread Patrick Welche
result. Fixes printing -0.0, and thus PR lib/3137. NetBSD 1.5 has revision 1.32, NetBSD 1.6 has revision 1.42 Well spotted, Patrick ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [PORTS] Geometry test on NetBSD (was Re: [HACKERS] RC1?)

2002-11-20 Thread Patrick Welche
On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: ... > > NetBSD 1.5 has revision 1.32, NetBSD 1.6 has revision 1.42 > > Ah-hah, so it is a version issue --- we could make the resultmap line > something like >

Re: [PORTS] Geometry test on NetBSD (was Re: [HACKERS] RC1?)

2002-11-20 Thread Patrick Welche
On Wed, Nov 20, 2002 at 01:51:28PM -0500, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > On Wed, Nov 20, 2002 at 01:21:47PM -0500, Tom Lane wrote: > >> Ah-hah, so it is a version issue --- we could make the resultmap line > >> something l

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

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

[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

[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 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] 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] 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] 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)

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

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: > > 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-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: 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] 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
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: [HACKERS] Call for platforms

2001-04-12 Thread Patrick Welche
Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's patch should be applied? Cheers, Patrick (just checked, it isn't in today's cvs) On Thu, Mar 22, 2001 at 10:27:44PM +0200, Marko Kreen wrote: > On Thu, Mar 22, 2001 at 07:58:04PM +,

[HACKERS] Re: Call for platforms

2001-04-13 Thread Patrick Welche
ecee type thing has a fpu (as in the sysctl machdep.fpu_present returns 1), then libm387.so is used, and you get differences in the (from memory 44th insignificant figure?) otherwise it just uses libm.so and you get what is currently correct in resultmap. Cheers, Patrick -

Re: [HACKERS] Re: Call for platforms

2001-04-22 Thread Patrick Welche
0 => /usr/lib/libm387.so.0 -lm.0 => /usr/lib/libm.so.0 -lutil.5 => /usr/lib/libutil.so.5 -ledit.2 => /usr/lib/libedit.so.2 -ltermcap.0 => /usr/lib/libtermcap.so.0 -lc.12 => /usr/lib/libc.so.12 -ltermcap is missing from arm32 - it's nece

[HACKERS] shared library strangeness?

2001-05-21 Thread Patrick Welche
001/02/10 02:31:30 1.10 +++ pgconnection.h 2001/05/09 17:29:10 1.11 - int ConnectionBad(); ... + bool ConnectionBad() const; So I would suggest that the major number be bumped, leaving a small window since 9 May with a problem.. Cheers, Patrick --

Re: [HACKERS] 7.2 items

2001-05-14 Thread Patrick Welche
; BSD license lib -lc.12 => /usr/lib/libc.so.12 % env LANGUAGE=fr gmake gmake: *** Pas de cibles spécifiées et aucun makefile n'a été trouvé. Arrêt. Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 7.2 items

2001-05-14 Thread Patrick Welche
On Mon, May 14, 2001 at 09:36:56PM +0200, Peter Eisentraut wrote: > Patrick Welche writes: > > > > I have no objection to the gettext API, but I was and still am concerned > > > about depending on GNU gettext's code, because of license conflicts. > > >

Re: [HACKERS] cvs snapshot compile problems

2001-05-21 Thread Patrick Welche
n /usr/include/dlfcn.h ie., system header file, not postgresql. Hope that helps, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] iconv?

2001-07-13 Thread Patrick Welche
mentation of the iconv API for character set conversions. A free one can be found under the following URL: http://clisp.cons.org/~haible/packages-libiconv.html Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Idea: recycle WAL segments, don't delete/recreate 'em

2001-07-18 Thread Patrick Macdonald
hen a database is created, the creator selects which type of logging to perform. The log segments are exactly the same, only the recycling method is different. Hmmm... the more I look at this, the more interested I become. Cheers, Patrick ---(end of broadcast)

Re: [HACKERS] Idea: recycle WAL segments, don't delete/recreate 'em

2001-07-23 Thread Patrick Macdonald
Tom Lane wrote: > > Patrick Macdonald <[EMAIL PROTECTED]> writes: > > I understand your solution is for the existing architecture which does > > not support point-in-time recovery. If this item is picked up, your > > solution will become a stumbling block due the

Re: [HACKERS] Idea: recycle WAL segments, don't delete/recreate 'em

2001-07-23 Thread Patrick Macdonald
where an overwritten log extent (as you describe) is acceptable. I think it would be useful to be able to define which logging method you require for a database. This way, you incur the I/O hit only when forward recovery is a requirement. Thoughts/comments? Cheer, Patrick Tom Lane wrote

Re: [HACKERS] Idea: recycle WAL segments, don't delete/recreate 'em

2001-07-18 Thread Patrick Macdonald
ht? Am I missing something here? Ok... I wasn't thinking of having a point-in-time daemon. Some other databases provide, for lack of a better term, user exits to allow user defined scripts or programs to be called to perform log segment archiving. This archiving is somewhat orthogonal to p

Re: [HACKERS]

2001-07-26 Thread Patrick Welche
undefined reference to `PQerrorMessage' Did you link libpq as well as libpq++ ? ie something like -L/usr/local/lib/pgsql -Wl,-R/usr/local/lib/pgsql -lpq++ -lpq Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Idea: recycle WAL segments, don't delete/recreate 'em

2001-07-18 Thread Patrick Macdonald
configured. I think a > PIT logger daemon is the only solution, especially since tape/network > transfer could take a long time. It would be forked by the postmaster > so would cover all users and databases. Actually, it would be better if the entire logger was split out into it's own process like the large commercial databases. Archiving the log segments would just be one of the many functions of the logger process. Just a thought. Cheers, Patrick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] backend hba.c prob

2001-09-07 Thread Patrick Welche
t cr_uid; /* effective user id */ gid_t cr_gid; /* effective group id */ short cr_ngroups; /* number of groups */ gid_t cr_groups[NGROUPS]; /* groups */ }; Thoughts? Cheers, Patrick ---(end of

Re: [HACKERS] backend hba.c prob

2001-09-07 Thread Patrick Welche
On Fri, Sep 07, 2001 at 10:14:27AM -0400, Tom Lane wrote: > Patrick Welche <[EMAIL PROTECTED]> writes: > > hba.c: In function `ident_unix': > > hba.c:923: sizeof applied to an incomplete type > > > Now, the problem is sizeof(Cred), typedef struct cmsgcred Cr

Re: [HACKERS] backend hba.c prob

2001-09-12 Thread Patrick Welche
OpenBSD > doesn't support creds as far as I can tell. > > To test, define 'ident sameuser' for 'local' in pg_hba.conf and restart > postmaster. Then connect as local user. All tested OK under NetBSD :) Cheers, Patrick ---(end of broadcast

Re: [HACKERS] factorial doc bug?

2001-09-12 Thread Patrick Welche
t behaviour is probably the most > intuitive for the vast majority of users. I would be happy with with exp(lgamma(x+1)) as a synonym for x! (So 4.3!=38.078 as far as I'm concerned :) ) Cheers, Patrick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Major change to CVS effective immediately ...

2001-09-19 Thread Patrick Welche
geLogs/libpqpp.h cannot create_adm_p /tmp/cvs-serv27285/ChangeLogs Cheers, Patrick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Further CVS errors

2001-09-21 Thread Patrick Welche
On Fri, Sep 21, 2001 at 07:27:10PM +0200, Horák Daniel wrote: ... > but still I am getting > > > cannot create_adm_p /tmp/cvs-serv24877/ChangeLogs > > Permission denied Me Too! ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [HACKERS] anoncvs failure...

2001-09-24 Thread Patrick Welche
find . -name Root -print > allroots grep -v CVS allroots foreach i ( `cat allroots`) echo ":pserver:[EMAIL PROTECTED]:/projects/cvsroot" > $i end and CVSROOT is not set as an environment variable... Also odd that it appears there and there is no sign of &q

Re: [HACKERS] anoncvs failure...

2001-09-25 Thread Patrick Welche
On Mon, Sep 24, 2001 at 06:04:17PM +0100, Patrick Welche wrote: ... > and CVSROOT is not set as an environment variable... Also odd that it > appears there and there is no sign of "home" anywhere.. Got it: had /home/... in pgsql/src/backend/access/heap/CVS/Repository (!) All

Re: [HACKERS] anoncvs failure...

2001-09-24 Thread Patrick Welche
orks. Still no good for me: protocol error: directory '/home/projects/pgsql/cvsroot/pgsql/src/backend/access/heap' not within root '/projects/cvsroot' Checking: % pwd /usr/src/local/pgsql/src/backend/access/heap % cat CVS/Root :pserver:[EMAIL PROTEC

Re: [HACKERS] failed runcheck

2000-10-25 Thread Patrick Welche
dump) Cheers, Patrick

[HACKERS] Digest subscription

2000-12-15 Thread Patrick Dunford
How do I change to digest? The instructions on the website are wrong. === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Rejoice with those who rejoice; mourn with those who mourn. -- Romans 12:15

[HACKERS] Connecting across internet

2000-12-28 Thread Patrick Dunford
If I want to connect to a Postgresql server on the internet, how do I do it? What protocol do I use? How do I send commands? etc. === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Therefore, since we

Re: [HACKERS] GNU readline and BSD license

2000-12-29 Thread Patrick Welche
manpage, > or go to: > >http://www.freebsd.org/cgi/man.cgi?query=editline&apropos=0&sektion=0&manpath=FreeBSD+4.2-RELEASE&format=html Good plan - AFAIK there isn't anything gnu readline can do that libedit can't.. Patrick

[HACKERS] Ignored PostgreSQL SET command

2001-01-01 Thread Patrick Dunford
ates returned that I can ALWAYS rely on? 2. Why is the command ignored? === Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ There is no wisdom, no insight, no plan that can succeed against the LORD. --

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Patrick Welche
ue hooks are there to use NetBSD libedit ;) Cheers, Patrick

Re: [HACKERS] GNU readline and BSD license

2001-01-02 Thread Patrick Welche
x27;ll commit a fix to NetBSD within days! Happy New Year, Patrick

[HACKERS] global/pg_database ?

2001-01-06 Thread Patrick Welche
r -D /usr/local/pgsql/data or /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start Any ideas? Cheers, Patrick

[HACKERS] initdb prob

2001-01-06 Thread Patrick Welche
Please ignore last 2 messages re psql: FATAL 1: cannot open /usr/local/pgsql/data/global/pg_database: No such file or directory - I had another old postmaster running... Cheers, Patrick

[HACKERS] initdb prob

2001-01-06 Thread Patrick Welche
se server using: /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data or /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start Any ideas? Cheers, Patrick

[HACKERS] test/locale broken

2001-01-18 Thread Patrick Welche
Just tried it for the first time: % cd src/test/locale % gmake all gmake: Circular test-pgsql-locale <- all dependency dropped. cd: can't cd to pgsql-locale gmake: *** [test-pgsql-locale] Error 2 I think the next stage is gmake test-koi8.. Cheers, Patrick

Re: [HACKERS] Autoconf version discrepancies

2001-01-18 Thread Patrick Welche
nvoker's use of the temporary name. A link-time warning will be issued advising the use of mkstemp() or mkdtemp() instead. Cheers, Patrick

[HACKERS] charset.htm

2001-01-18 Thread Patrick Welche
you start the postmaster. Is that still true? I seem to remember something about the postmaster using whatever initdb set.. Cheers, Patrick

[HACKERS] FW: User management

2001-01-18 Thread Patrick Dunford
> -Original Message- > From: Patrick Dunford [mailto:[EMAIL PROTECTED]] > Sent: Friday, 19 January 2001 15:19 > To: [EMAIL PROTECTED] > Subject: User management > > > What commands in SQL enable administrators to view user / group > information? > Are

Re: [HACKERS] Re: Getting configure to notice link-time vs run-time failures

2001-01-19 Thread Patrick Welche
; > I'd say, you're stuck. > > -- > Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ > Wouldn't a -Wl,-R/usr/local/lib have helped? Cheers, Patrick

Re: [HACKERS] Possible performance improvement: buffer replacement policy

2001-01-19 Thread Patrick Welche
On Fri, Jan 19, 2001 at 12:03:58PM -0500, Bruce Momjian wrote: > > Tom, did we ever test this? I think we did and found that it was the > same or worse, right? (Funnily enough, I just read that message:) To: Bruce Momjian <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Possibl

Re: [HACKERS] test/locale broken

2001-01-22 Thread Patrick Welche
On Fri, Jan 19, 2001 at 08:52:13PM +0100, Peter Eisentraut wrote: > Patrick Welche writes: > > > Just tried it for the first time: > > % cd src/test/locale > > % gmake all > > gmake: Circular test-pgsql-locale <- all dependency dropped. > > cd: can't c

Re: [HACKERS] C++ interface build on FreeBSD 4.2 broken?

2001-01-23 Thread Patrick Welche
On Sat, Jan 20, 2001 at 08:06:51PM -0500, Tom Lane wrote: > What I've done to solve the immediate C++ problem is to take the > declaration of sys_nerr out of c.h entirely, and put it into the > two C modules that actually need it. However, I'm still wondering > whether we should not drop the rang

[HACKERS] Strange..

2001-01-23 Thread Patrick Welche
-- id| bigint| surname | character(20) | firstname | character(30) | email | character(30) | phone | character(16) | rfbdate | date | Index: name_idx (in fact no 'suject' in any table anywhere) Am I going spare? Cheers, Patri

[HACKERS] Strange.. solved

2001-01-23 Thread Patrick Welche
7;, 'subjectid', 'id'); Don't know where that came from, but probably operator error.. There isn't an easy way of scrubbing an unnamed trigger is there? (I dump/edit/reloaded) Cheers, Patrick

Re: AW: [HACKERS] like and optimization

2001-01-24 Thread Patrick Welche
issue. The "Citrus Project" is coming up with with i18n for BSD. FYI Patrick

Re: AW: [HACKERS] like and optimization

2001-01-24 Thread Patrick Welche
ls (where > they exist) to dump an existing locale, edit it a bit, and build a more > PG-friendly locale. Is there really a standard format for locales? Apparantly there are 3 different ways of doing LC_COLLATE ?! Cheers, Patrick

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-26 Thread Patrick Welche
interprocess locking problem. But we haven't heard about any such issue > on Solaris. Or simply running out of processes - check maxproc? (Deleted beginning of this thread, so may have missed something) Cheers, Patrick

[HACKERS] ODBC driver issue in MS Access

2001-02-10 Thread Patrick Dunford
get any errors from Access. Should my database create its own key values and store them itself? ======= Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ In this way, love is made complete among us so that we

  1   2   >