Re: [HACKERS] Stuff running slooow

2005-08-26 Thread Chris Browne
[EMAIL PROTECTED] (Alvaro Herrera) writes: > On Thu, Aug 25, 2005 at 02:45:02PM -0700, Joshua D. Drake wrote: >> >> >If y'all would like, I can eliminate the anti-virus/anti-spam checks and >> >just let it all go through though ... *evil grin* >> >> Would not bother me in the least. I have prote

[HACKERS] Interesting COPY edge case...

2005-07-26 Thread Chris Browne
Just ran into a fascinating edge case. One of our folks was building a stored function, and ran into an odd error when trying to COPY to stdout. Here's a characteristic example: create or replace function build_table (integer) returns integer as ' begin execute ''copy foo to stdout;''; retur

Re: [HACKERS] question on some code.

2005-07-19 Thread Chris Bowlby
Hi Tom, good to hear from you. It was my miss-understanding of what the code was doing, not the issue with the compiler :> At 03:22 PM 7/19/2005, Tom Lane wrote: Chris Bowlby <[EMAIL PROTECTED]> writes: > I understand the concept of the code, to append binary values to a str

Re: [HACKERS] question on some code.

2005-07-19 Thread Chris Bowlby
Ahh, so it's not attempting to turn it into an "acsii" string, just storing raw binary data... Ok that makes sense now, thanks for the help. At 02:54 PM 7/19/2005, Korry wrote: If I understand the code right, your trying to pass in to appendBinaryStringInfo an "address" or reference to the n8

[HACKERS] question on some code.

2005-07-19 Thread Chris Bowlby
Hi All, I've been doing a code audit (review) for my own personal use of the 7.4.x series code base and have come across something that I'd like to get more details on, if it is possible to do so. I've been going over the communications section and am curious how this segment of code is ac

Re: [HACKERS] Implementing SQL/PSM for PG 8.2

2005-06-28 Thread Chris Browne
Christopher Browne <[EMAIL PROTECTED]> writes: > There are essentially four choices: Aside: I suppose there are as many possible choices as there are bytecode compiled systems out there. One could consider Icon, CLISP, Python, PHP, OCAML, CMU/CL, all of which have bytecode compilers. But none o

Re: [HACKERS] Problem with dblink regression test

2005-06-22 Thread Chris Campbell
.1.dylib (compatibility version 1.0.0, current version 1.0.0) /usr/lib/libncurses.5.dylib (compatibility version 5.0.0, current version 5.0.0) /usr/lib/libresolv.9.dylib (compatibility version 1.0.0, current version 324.9.0) /usr/lib/libSystem.B.dylib (compatibility vers

Re: [HACKERS] Learning curves and such

2005-05-19 Thread Chris Browne
[EMAIL PROTECTED] (Stephen Frost) writes: > * Tom Lane ([EMAIL PROTECTED]) wrote: >> I think most of the real advantages of bug trackers that have been >> mentioned in this thread have to do with history and searchability. >> We have the raw info for that, in the pgsql-bugs and >> pgsql-commmitters

Re: [HACKERS] pgFoundry

2005-05-06 Thread Chris Browne
[EMAIL PROTECTED] (Russell Smith) writes: > Because it's not the hub of PostgreSQL development. I think it will > be difficult to build a culture of "This" is the place to be unless > we actually kill gborg totally. Currently there are still projects > there, I'm personally never sure where to lo

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

2005-05-02 Thread Chris Travers
e of development. Maybe have it divided into two sections: Bids and Bounties. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] New wal_sync_method for Darwin?

2005-04-15 Thread Chris Campbell
ync() matches the semantics on other platforms. And conscientious users could specify the F_FULLFSYNC fcntl() method if they want to make sure it goes through the write cache. Comments? Thanks! - Chris smime.p7s Description: S/MIME cryptographic signature

Re: [HACKERS] TODO item: support triggers on columns

2005-03-13 Thread Chris Mair
O, and can bail out if > it gets over my head? Ok! Keep us up to date. Bye, Chris :) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] TODO item: support triggers on columns

2005-03-11 Thread Chris Mair
ause? I think there was a partial patch > submitted already for this. Those are two different things: http://www.postgresql.org/docs/8.0/static/sql-createtrigger.html#SQL-CREATETRIGGER-COMPATIBILITY Bye, Chris. ---(end of broadcast)--- T

[HACKERS] TODO item: support triggers on columns

2005-03-10 Thread Chris Mair
Hello, I'd like to start working on the following TODO item: Referential Integrity / Support triggers on columns Is somebody else already working on this? Bye :) Chris. ---(end of broadcast)--- TIP 6: Have you searched our list arc

Re: [HACKERS] [GENERAL] PostgreSQL 8.0.0 Release Candidate 4

2005-01-09 Thread Chris Mair
2) Gnu C library to be broken? I wonder how many implementations of strtod behave this way? On a few other boxes of mine I've seen versions that accept 'Infinity' as a whole or reject it as a whole Bye, Chris. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Adding Reply-To: to Lists configuration ...

2004-12-01 Thread Chris Green
On Wed, Dec 01, 2004 at 02:02:41AM -0600, Bruno Wolff III wrote: > On Mon, Nov 29, 2004 at 12:49:46 +, > Chris Green <[EMAIL PROTECTED]> wrote: > > > > This is a perpetual problem, if people all used the same MUA and > > (assuming it has the capability) all us

Re: [HACKERS] Adding Reply-To: to Lists configuration ...

2004-11-29 Thread Chris Green
On Mon, Nov 29, 2004 at 07:35:41AM -0500, Jim Seymour wrote: > > Chris Green <[EMAIL PROTECTED]> wrote: > > > > On Sun, Nov 28, 2004 at 07:34:28PM -0400, Marc G. Fournier wrote: > > > > > > What is the general opinion of this? I'd like to implemen

Re: [HACKERS] Adding Reply-To: to Lists configuration ...

2004-11-29 Thread Chris Green
I'll often get two replies when people reply to my postings. However it's not a big issue for me. -- Chris Green ([EMAIL PROTECTED]) "Never ascribe to malice, that which can be explained by incompetence." ---(end of broadcast)--

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

2004-11-13 Thread Chris Albertson
ystems to gemerate enough data to get you into trouble But I run low-end stuff on my very old 500Mhz PIII = Chris Albertson Home: 310-376-1029 [EMAIL PROTECTED] Cell: 310-990-7550 Office: 310-336-5189 [EMAIL PROTECTED] KG6OMK __ Do

[HACKERS] Slony-I 1.0.4 Released

2004-10-23 Thread Chris Browne
The Slony-I team is proud to present the 1.0.4 release of the most advanced replication solution for the most advanced Open Source Database in the world. The release tarball is available for download http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.4.tar.gz There are a limite

Re: [HACKERS] plans for bitmap indexes?

2004-10-12 Thread Chris Browne
[EMAIL PROTECTED] (Yann Michel) writes: > On Fri, Oct 08, 2004 at 10:09:18AM +0100, Dave Page wrote: >> I think what Reini was asking was why do you think you need bitmap >> indexes as opposed to any existing type? > > due to I'm developing a datawarehousing application we have lots of > fact-data

Re: [HACKERS] plans for bitmap indexes?

2004-10-12 Thread Chris Browne
[EMAIL PROTECTED] (Josh Berkus) writes: >> > Lots of people have talked about it but I don't know anyone coding it. > > I would love to have bitmap indexes in Postgres, as would a lot of other > community members. However, they are far from trivial to code. Are you > offering to help? I'm cur

Re: [HACKERS] AIX and V8 beta 3

2004-10-02 Thread Chris Browne
[EMAIL PROTECTED] (Darcy Buskermolen) writes: > On September 30, 2004 05:55 pm, Bruce Momjian wrote: > > To me it looks like all you need to do is add -pthreads or maybe > -lpthreads depending on exact system to your compile line.. -lpthreads does the trick, indeed. (-lpthread also does the job,

Re: [HACKERS] AIX and V8 beta 3

2004-10-01 Thread Chris Browne
[EMAIL PROTECTED] (Bruce Momjian) writes: > Have you tried using cc_r for that compile line? Does that help? Alas, that is not an option available. cc_r is specific to the AIX "xlc" compiler; we're using GCC, and xlc is not available to us. bash-2.05a$ gcc -v Reading specs from /usr/local/lib/g

[HACKERS] pg_dump --exclude-schema=foo

2004-09-15 Thread Chris Browne
We have discovered an interesting locking scenario with Slony-I that is pointing to a use for the ability to exclude certain schemas from pg_dump. The situation is that when a "full" pg_dump kicks off, a Slony-I "create sync" event, which expects to "LOCK slony_schema.sl_event;", is blocked from g

Re: [HACKERS] Statement parsing problem ?

2004-09-15 Thread Chris Dunlop
Replying to my own post, thanks to the assistance of Paul Bort... On Wed, Sep 15, 2004 at 11:43:47PM +1000, Chris Dunlop wrote: > There seems to be a kind of statement parsing problem in 7.4.5 > (from debian postgresql-7.4.5-3, i386). > > Either that, or I'm missing someth

[HACKERS] Statement parsing problem ?

2004-09-15 Thread Chris Dunlop
quot;t3", which is not part of JOIN slightly different error, using a table alias psql:/tmp/test.sql:46: ERROR: relation "a" does not exist -- So is it me, or is this just a bit borken ?

Re: [HACKERS] AIX and v8 beta1

2004-09-10 Thread Chris Browne
[EMAIL PROTECTED] (Rod Taylor) writes: > On Sun, 2004-09-05 at 13:43, Tom Lane wrote: >> Rod Taylor <[EMAIL PROTECTED]> writes: >> > collect2: ld returned 254 exit status >> >> That's a fairly unhelpful error message, isn't it? >> >> I'm thinking that this may be due to having added the timezone

Re: [HACKERS] 8.0 beta 1 on linux-mipsel R5900

2004-08-30 Thread Chris Mair
linux.or.jp/lc2001/papers/tas-ps2-paper.pdf See also this releated thread on the linux-mips list: http://www.linux-mips.org/archives/linux-mips/2002-01/msg00278.html I'm not fluent in Japanese or MIPS assembly, so I won't comment on these. Just posting the links :) Bye, Chris. --

[HACKERS] 8.0 beta 1 on linux-mipsel R5900

2004-08-23 Thread Chris
y spinlock code for the R5900? If that's not worth the trouble, would it be a good idea to have configure disable spinlocks automagically on unsupported platforms? Or is it to hard to autodetect this? Bye, Chris. PS: I've compiled using gcc 2.95.2 and with CFLAGS -O0 -g. *** ./exp

[HACKERS] Asserting existing key to be primary

2004-08-13 Thread Chris Browne
I have a table that has a candidate primary key (e.g. - unique, not null) that I wish to actually assert _is_ a primary key. Is there a way to do that without too much (mwahahhaha! fiddling with pg_class!!!) trickery? -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "acm.org") http://cbbrowne.com/in

Re: [HACKERS] why is postgres-R not in standard dev Path.

2004-08-01 Thread Chris Browne
[EMAIL PROTECTED] (chinni) writes: > Postgres-R is a multi server (write anywhere) replication tool > which is possibly important for any enterprise if they want to shift > to postgres. > > Did you guys debate on merging it. I seem to recall there being a licensing issue; Postgres-R uses the

[HACKERS] psql support for "DSNs"

2004-07-25 Thread Chris Browne
I just had a thought; was looking at a script where I'd rather invoke using psql than using a Perl module (since Pg/DBD that might very well not be available on AIX, HP/UX, Solaris, or such). What would be very nice would be for there to be a psql command option that would accept a "DSN" as oppose

Re: [HACKERS] email browser?

2004-06-18 Thread Chris Browne
"Santo Quartarone" <[EMAIL PROTECTED]> writes: > What's the safest email browser? less is pretty safe, more or less ;-). You didn't specify what sort of platform you wanted to use; the choices vary, considerably, between platforms. -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "cbbrowne.com") ht

Re: [HACKERS] pg_restore recovery from error.

2004-06-15 Thread Chris Bowlby
In that table I'm pretty sure there are no other records, but I'm hoping there are some records for the tables stored after that particular table.. At 05:48 PM 6/15/2004, Tom Lane wrote: Chris Bowlby <[EMAIL PROTECTED]> writes: > pg_restore: restoring data for table "

Re: [HACKERS] pg_restore recovery from error.

2004-06-15 Thread Chris Bowlby
that offending block (including the offending record). At 02:46 PM 6/15/2004, V i s h a l Kashyap @ [Sai Hertz And Control Systems] wrote: Dear Chris , pg_restore: [custom archiver] could not read data block -- expected 4096, got 3870 pg_restore: *** aborted because of error It appears some of

[HACKERS] pg_restore recovery from error.

2004-06-15 Thread Chris Bowlby
Hi All, I've been attempting to recover some data from a data file that was dumped and compressed using pg_dump. I've noticed that the pg_restore application was supposed to have some work put into place to help it continue of it ran into an error, but I've run into an issue here it is not con

Re: [HACKERS] [GENERAL] CREATE DATABASE on the heap with PostgreSQL?

2004-06-07 Thread Chris Travers
worms regarding these topics which is best left untouched. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] pg_dump --comment?

2004-05-31 Thread Chris Campbell
dified? Given those requirements, building a commenting mechanism into the custom format would work out very nicely, I think. Thanks! - Chris smime.p7s Description: S/MIME Cryptographic Signature

[HACKERS] pg_dump --comment?

2004-05-27 Thread Chris Campbell
(pg_comment?) that does that. Is this a desirable feature? Should I work it up like described and submit a patch? Any comments/suggestions? Thanks! - Chris smime.p7s Description: S/MIME Cryptographic Signature

[HACKERS] AIX Compilation Fun with 7.5 CVS

2004-05-19 Thread Chris Browne
I was wanting to check out what was up with timezone handling with the latest changes that were committed, as there had been some "biting" on AIX. To wit, notice the default time zone on one of our AIX boxes: bash-2.05a$ date Tue May 18 21:47:37 GDT 2004 bash-2.05a$ echo $TZ CUT0GDT bash-2.05a$

[HACKERS] dead index nodes...

2004-05-13 Thread Chris Bowlby
Hi Everyone, Is there a way to find out how many dead index nodes are in a btree based index? I'm attempting to track down how much of my index is bloated because of dead nodes... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe comman

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-05-03 Thread Chris Browne
[EMAIL PROTECTED] ("Jim C. Nasby") writes: > I would still argue that if any language should be installed by > default it should be plpgsql and not java. As I mentioned, everyone > using a database already knows SQL; not nearly as many know java. A vital factor is indeed that pl/pgsql does not req

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-27 Thread Chris Travers
for that feature. As the lead in a project whose roadmap has changed many times due to paid contracts, I don't really see the value of published roadmaps in general. Best Wishes, Chris Travers ---(end of broadcast)--- TIP 3: if posting/rea

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-27 Thread Chris Travers
tabase (yes, the Cygwin installer because of the ipc stuff is a reasonable barrier to entry). Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] pg_clog question.

2004-04-27 Thread Chris Bowlby
Ahh, perfect, thank you.. On Tue, 2004-04-27 at 16:18, Alvaro Herrera wrote: > On Tue, Apr 27, 2004 at 09:26:38AM -0300, Chris Bowlby wrote: > > > I've been noticing that files in the pg_clog directory test to stay > > around forever, I know they are used to

[HACKERS] pg_clog question.

2004-04-27 Thread Chris Bowlby
storage method for pg_clog: it is no longer necessary to keep old pg_clog entries around forever.)" How does one determine which files are no longer neccessary? Is the system configured to clear out stale ones during startup/shutdown? -- Chris Bowlby <[EMAIL PRO

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-26 Thread Chris Travers
llation isntructions is enough to give you second thoughts MS SQL does have a nice installer, however, as do most binary open source products for Windows. I am completely confident that PostgreSQL for Windows, when it arrives, will have a nice GUI-based installer. Best Wishes, Chris Travers M

Re: [HACKERS] pl/j looking for alpha testers

2004-04-26 Thread Chris Browne
[EMAIL PROTECTED] (Dave Cramer) writes: > Pl/J is a java procedural language for postgres. We are looking for > alpha testers to help us find bugs, and get feedback. > > The project can be found at > > http://plj.codehaus.org/ > > Bugs can be reported at > > http://jira.codehaus.org/secure/BrowsePr

[HACKERS] sql_sizing

2004-04-15 Thread Chris Bowlby
t. That was when I noticed that these ones did not. Has anyone else run into this problem?, is it safe to remove these tables from the pg_class table or is it safe to create the tables themselves? -- Chris Bowlby <[EMAIL PROTECTED]> PostgreSQL Inc. ---(end of broa

[HACKERS] The Tomb of the Unknown Type?

2004-04-08 Thread Chris Browne
We have encountered a pretty oddball situation involving an "unknown" type. mydb=# select version(); version -

Re: [HACKERS] Update on PITR

2004-04-05 Thread Chris Browne
[EMAIL PROTECTED] ("Marc G. Fournier") writes: > On Thu, 1 Apr 2004, Christopher Kings-Lynne wrote: >> > Is your timeline based on the assumption of doing all the work >> > yourself? If so, how about farming out some of it? I'd be >> > willing to contribute some effort to PITR. (It's been made c

[HACKERS] Row sampling..

2004-03-29 Thread Chris Bowlby
s on optimizing? -- Chris Bowlby <[EMAIL PROTECTED]> PostgreSQL Inc. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get t

Re: [HACKERS] COPY formatting

2004-03-19 Thread Chris Browne
[EMAIL PROTECTED] (Andrew Dunstan) writes: > Karel Zak wrote: > >> Hi, >> >> in TODO is item: "* Allow dump/load of CSV format". I don't think >> it's clean idea. Why CSV and why not something other? :-) >> >> A why not allow to users full control of the format by they own >> function. It means som

Re: [pgsql-www] [HACKERS] The Name Game: postgresql.net vs. pgfoundry.org

2004-03-19 Thread Chris Ryan
making the decision on which route to go. Chris Ryan __ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] Issue with 7.1.3 - regressions and such

2004-03-09 Thread Chris Browne
I recently had the 'joy' of needing to compile a copy of 7.1, to support a fairly crusty application where we'd have to do more testing than we can justify in order to upgrade to some (vastly) newer generation. Ran into a couple of things worth mentioning: 1. Had a whole lot of gory problems due

Re: [SQL] User defined types -- Social Security number...

2004-03-02 Thread Chris Browne
"Greg Patnude" <[EMAIL PROTECTED]> writes: > It would be really sweet in postgreSQL if we could apply the > equivalent of a printf(columnname) to the table definition -- MS > Access has what they call an "input mask" and it comes in really > handy -- however -- I havent used Access for anthing seri

Re: [HACKERS] RFC: Very large scale postgres support

2004-02-09 Thread Chris
=cern+event+database+postgresql or even http://www.google.com/search?q=cern+event+database You might find some inspiration there! Bye, Chris. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.or

Re: [HACKERS] Stupid question on Read Committed Isolation Level

2004-01-29 Thread Chris Bowlby
regards, tom lane > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings -- Chris Bowlby <[EMAIL PROTECTED]> PostgreSQL Inc. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] lock related issues...

2004-01-28 Thread Chris Bowlby
Hi Simon, Thanks for the confirmation, I just wanted to make sure I was not going ape over it and getting confused. At 08:04 PM 1/28/04, Simon Riggs wrote: >Chris Bowlby writes > I'm looking for some details on how the locking system works in > relation to transactions dealin

[HACKERS] lock related issues...

2004-01-28 Thread Chris Bowlby
otion (unlike the updates, which do show up). If the transaction is closed and a new one is reopened, after all of the inserts have been completed, then we can see them. Is this the standard behaviour associate to transactions? -- Chris Bowlby <[EMAIL PROTECTED]> Pos

Re: [HACKERS] Announce: Search PostgreSQL related resources

2004-01-06 Thread Chris
> http://www.pgsql.ru/ > We are welcome your feedback and comments. Very nice work! I've just found some docs I was looking for a long time :) Bye, Chris. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] [GENERAL] Should we consider empty fields as NULL values when

2003-12-11 Thread Chris Travers
e values and substitute as appropriate. That is not the answer you were looking for, but... For example (PHP): function db_quote($db_var){ if ($db_var === NULL){ return 'NULL'; } else { return "'$db_var'"; } } T

[HACKERS] Schema boggle...

2003-11-05 Thread Chris Bowlby
s for. If I've got 10,000 clients, that's going to take a ton of time to get the results I'm looking for... Does anyone know if any of these issues have been addressed in 7.4? I see some references to schema based changes, but no details on what those changes were. If not, a

Re: [HACKERS] [GENERAL] Extracting time from timestamp

2003-03-23 Thread Chris Gamache
phd=# select version(); > >version > > Try: > > select "time"(abstime(timestamp 'now')) from bookings; > select "time"(timestamp 'now') from bookings; > > Chris > > > ---

[HACKERS] Best setup for RAM drive

2003-03-04 Thread Chris Sutton
ture while putting the rest on disk where it's safer? Should we just put pgsql/data/pg_xlog on the RAM drive? Also, in the very near future we will be upgrading to another server, pg7.3.2 with dual P4 2.4 xenon's. The RAM drive will go into this new server. Any suggest

Re: [HACKERS] JDBC drivers and streaming content

2003-01-29 Thread Chris Smith
. Then again, if you've already got it done (but, it seems, not released) then I won't do so. -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere. Chris Smith - Lead Software Developer/Technical Trainer MindIQ Corporation ---(end of

[HACKERS] JDBC drivers and streaming content

2003-01-28 Thread Chris Smith
This is more intrusive, but I'll go whichever way makes it more likely for the patch to be committed. - Am I missing anything? Is this harder than it seems? Seems like someone would have done it already... -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere. Chris Smith - L

[HACKERS] JDBC drivers and streaming content

2003-01-24 Thread Chris Smith
This is more intrusive, but I'll go whichever way makes it more likely for the patch to be committed. - Am I missing anything? Is this harder than it seems? Seems like someone would have done it already... -- www.designacourse.com The Easiest Way to Train Anyone... Anywhere. Chris Smith - L

[HACKERS] InitDB Failure - PostgreSQL 7.2, RedHat 7.3, compile from source

2002-11-27 Thread chris
an anyone shed some light on this just by looking at it? Two of us have wasted basically an entire day getting to this point and would appreciate any assistance. We may end up having to settle with 64 characters and install the latest RC :-) However ideall

[HACKERS] serial datatype changes for v7.3?

2002-09-02 Thread Chris
Hi, I'm playing around with the CVS version and noticed a change from 7.2 in regards to serial datatypes - they no longer automatically have an index. Is this a deliberate thing? I did a search in the archives but didn't come across mention of the change. A pointer to discussion on this would

Re: [HACKERS] @(#)Mordred Labs advisory 0x0007: Remove DoS in PostgreSQL

2002-08-26 Thread Chris Humphries
than postgresql, it is the dumbass factor of people that try to run a db, and are vuln to anything... and then complain about it... i find this very annoying. know what you are doing, or stfu is my opinion -chris ps -> note this was not directed at any one person, but to the mass of

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-29 Thread Chris Humphries
> "Open Source Software - Sometimes you get more than you paid for..." > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Chris Humphries Development InfoStructure 540.366.98

Re: [HACKERS] Oracle Decode Function

2002-07-25 Thread Chris Humphries
aid, there is case, if you need it. good luck! -chris Marc Lavergne writes: > That would get ugly in a real hurry! Oracle does get around the issue of > parameter datatypes by having automatic datatype conversions, more or > less, everything becomes a varchar2. The only

[HACKERS] Definite bug in JDBC

2002-06-25 Thread Chris Bitmead
If you define a database field like this with the "without time zone" clause. created timestamp(6) without time zone DEFAULT 'now' NOT NULL, Then the current postgresql jdbc driver falls over in a heap when trying to select and retrieve this field. ---(end of

[HACKERS] FEATURE REQUEST - More dynamic date type?

2002-06-14 Thread Chris McCormick
one day serve as a great working example of what pg can do. Any help would be greatly appreciated. Thanks in advance, Chris McCormick ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [HACKERS] Null values in indexes

2002-06-01 Thread Chris Hodgson
interface changed somewhat from postgresql 7.1 -> 7.2). And for the record, I'm confident that we would submit a patch for postgresql if something like this did come up. Chris Hodgson Dann Corbit <[EMAIL PROTECTED]> said: > > -Original Message- > > From: Tom Lan

[HACKERS] Unable to upgrade to 7.2

2001-10-20 Thread Chris Bitmead
I just checked out postgresql from CVS, built it and did a pg_dumpall of my 7.1.3 databases. When I try and load the data into 7.2 it gives a bunch of errors like \N command not found I guess they are nulls and it can't recognise them or something. ---(end of broadcast)-

Re: [HACKERS] TOAST and TEXT

2001-10-10 Thread Chris Bitmead
>Chris Bitmead <[EMAIL PROTECTED]> writes: >> ... I don't >> like the old large object implementation, I need to store very large >> numbers of objects and unless this implementation has changed >> in recent times it won't cut it. > >Ha

Re: [HACKERS] TOAST and bytea JAVA

2001-10-09 Thread Chris Bitmead
>Use bytea, its for 0-255, binary data. When your client >library does not support it, then base64 it in client side >and later decode() into place. Thanks, bytea sounds like what I need. Why no documentation on this important data type? Does the Java client library support setting this typ

[HACKERS] TOAST and TEXT

2001-10-09 Thread Chris Bitmead
Hi, Now that postgresql doesn't have field size limits, it seems to me they should be good for storing large blobs, even if it means having to uuencode them to be non-binary or whatever. I don't like the old large object implementation, I need to store very large numbers of objects and unless thi

[HACKERS] Port of 7.1.2 to Lynx RT-OS

2001-09-16 Thread Chris Hakimi
n point me toward the possible causes. Regards, -Chris History of changes: - renamed socket.h, pg_socket.h (to remove conflicts with which the compiler does not differentiate). - Changed 'yylval' in bootscanner.l to 'extern YYSTYPE yylval' to remove conflict with bootparse.c -

[HACKERS] request, if not already available.

2001-08-21 Thread Chris Bowlby
. I don't want to have to connect to the database machine via a different means because it's a step that can be forgotten very easily. If I had the option to be able to create a new pg_hba.conf entry then I could remember to do it right after I create a new database, and a user for it

[HACKERS] Re: hub.org out of disk space

2001-07-20 Thread Chris Bowlby
nd of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > Chris Bowlby, - Web Developer @ Hub.org. [EM

Re: [HACKERS] Question about inheritance

2001-06-05 Thread chris . bitmead
>It's relatively straightforward to allow check constraints to be inherited - >but is it really possible to ever do the same with primary, unique or even >foreign constraints? You would either have to check each index in the hierarchy or else have a single index across the whole hierarchy and

[HACKERS] Permissions problem

2001-05-02 Thread Chris Dunlop
). This is in postgresql-7.0.3, but it's possible this is fixed in a more recent version - can someone try this and see what happens ? Cheers, Chris. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] 7.1 RPMS...

2001-04-14 Thread Chris Bowlby
Where are the 7.1 rpms downloadable from? (even the RC based ones)? Chris Bowlby, - Web Developer @ Hub.org. [EMAIL PROTECTED] www.hub.org 1-902-542-3657

[HACKERS] Missing include files.

2001-04-03 Thread Chris Bowlby
lease candidate 2 has this issue. Chris Bowlby, - Web Developer @ Hub.org. [EMAIL PROTECTED] www.hub.org 1-902-542-3657 - ---(end of broadcast)--

[GENERAL] Client can not connect to socket...

2001-03-20 Thread Chris Bowlby
? Chris Bowlby, - Web Developer @ Hub.org. [EMAIL PROTECTED] www.hub.org 1-902-542-3657 - ---(end of broadcast)--- TIP 1: subscribe and

RE: [HACKERS] low priority postmaster threads?

2001-02-22 Thread Chris Storah
e are in the form of 'select * from [all tables joined together] where x') I will make a couple of changes and test it to see if there are any performance gains in particular cases. The other option is to add another processor :) Chris

[HACKERS] low priority postmaster threads?

2001-02-21 Thread Chris Storah
, and major day long queries at a 'when idle' priority. Cheers, Chris

Re: [GENERAL] Compiling on Win32

2000-12-20 Thread Chris Ian Capon Fiel
try to go to http://208.160.255.143 there's a compiled postgresql server... On Tue, 19 Dec 2000, Luis [UNKNOWN] Magaña wrote: > Hello: > > while compiling in windows 2000 got this error: > > YS.o hash/SUBSYS.o init/SUBSYS.o misc/SUBSYS.o mmgr/SUBSYS.o > sort/SUBSYS.o time/ > SUBSYS.o > ma

[GENERAL] Re: PostgreSQL for Windows 98, 2000, NT

2000-12-14 Thread Chris Ian Capon Fiel
Sorry for the website is not accessble that time but now it can be access at this url http://208.160.255.143 this include an easy installation of PostgreSQL v.7.0.2 for windows 98,2000 and NT. there is a pg guardian that automatically start and setup ur server and many more...:) hope you l

Re: [GENERAL] PostgreSQL v.7.0.2 for Windows 98,2000,NT

2000-12-14 Thread Chris Ian Capon Fiel
Sorry...that url for easy PostgreSQL (windowsm

[HACKERS] Re: [GENERAL] No postgres on Solaris

2000-12-12 Thread Chris Jones
et semsys:seminfo_semmsl=32 These lines are all at the bottom of /etc/system. Chris -- ----- [EMAIL PROTECTED] Chris JonesSRI International, Inc.

Re: [HACKERS] INHERITS doesn't offer enough functionality

2000-10-23 Thread Chris
Marten Feldtmann wrote: > > You'll still have to do 6 queries in postgres because it does not return > > fields in sub-classes. > > Practically this is not such a big problem as one might think. > WHEN you have a persistance framework you tell your framework, > that every attribut is located

Re: [HACKERS] INHERITS doesn't offer enough functionality

2000-10-20 Thread Chris
> The point is: this is classic, but noone does it > like this if your really have a larger hierarchy of > classes. You'll not get any good performance, when > solving an association in your oo > program, because the framework has to query against > each table: 6 tables - 6 queries !!! :-(((

Re: [HACKERS] INHERITS doesn't offer enough functionality

2000-10-19 Thread Chris
Hiroshi Inoue wrote: > > At the end of the day though, the reason is only performance. The > > semantics should be the same no matter whether implemented as multiple > > indexes or not. Performance is much better with one index though.(*) > > > > Is it true ? > How to guarantee the uniqueness us

Re: [HACKERS] INHERITS doesn't offer enough functionality

2000-10-19 Thread Chris
E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C > > "Delight thyself also in the LORD; and he shall give > thee the desires of thine heart." Psalms 37:4 -- Chris Bitmead mailto:[EMAIL PROTECTED]

Re: [HACKERS] INHERITS doesn't offer enough functionality

2000-10-17 Thread Chris
Alfred Perlstein wrote: > Thank you, it's not a big problem that this doesn't happen, but it'd > be nice to see it as an option when creating a table via inheritance. > > What about RULEs? I wouldn't really have a use for that but others > might. Actually it's a reasonably big deal. Apart from

<    1   2   3   4   5   6   >