Re: [HACKERS] GUC with units, details

2006-07-26 Thread Bort, Paul
ould be a good idea to use the standard, and that this is an opportunity to do so. Regards, Paul Bort ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [HACKERS] GUC with units, details

2006-07-26 Thread Bort, Paul
Martijn van Oosterhout wrote: > > > > How about this: > > > > INFO: Your setting was converted to IEC standard binary > units. Use KiB, > > MiB, and GiB to avoid this warning. > > That's silly. If you're going to treat KB as 1024 bytes anyway, > complaining about it is just being pedantic. Bu

Re: [HACKERS] Better name/syntax for "online" index creation

2006-07-26 Thread Paul S
Yeah, your probably right. :)     On 7/26/06, Tom Lane <[EMAIL PROTECTED]> wrote: Paul Silveira <[EMAIL PROTECTED]> writes:> If I didn't know anything about PostgreSQL and read a manual about it's > indexing capabilities and read that it had ONLINE reindexing, the fir

Re: [HACKERS] GUC with units, details

2006-07-27 Thread Bort, Paul
Peter Eisentraut wrote: > > I have committed it using the 1024 multiplier, but if you want to > propose changing all uses of kB, MB, and GB in PostgreSQL to > the other > system, now would be the time to do it. > I think it would be a good idea. I know I don't have time to do it for 8.2. I

Re: [HACKERS] GUC with units, details

2006-07-27 Thread Bort, Paul
e should be leading this charge, rather than following. Regards, Paul Bort ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] GUC with units, details

2006-07-27 Thread Bort, Paul
ts. Lynx - The documentation (http://lynx.isc.org/current/lynx2-8-6/lynx_help/Lynx_users_guide.html) consistently uses KiB instead of KB. FreeDOS-32 - Their standards page (http://freedos-32.sourceforge.net/showdoc.php?page=standards) states that they comply with this standard. Regards, Paul Bo

Re: [HACKERS] Better name/syntax for "online" index creation

2006-07-28 Thread Paul Silveira
I really like the CREATE INDEX CONCURRENTLY suggestion that I've seem in this thread. That seems like a good alternative to ONLINE and is very easy to understand. Regards, Paul -- View this message in context: http://www.nabble.com/Better-name-syntax-for-%22online%22-index-cre

[HACKERS] snapshot replication with pg_dump

2006-08-11 Thread Paul Silveira
something like this? Also, does anyone have any comments they'd like to share about this... Thanks in advance, Paul -- View this message in context: http://www.nabble.com/snapshot-replication-with-pg_dump-tf2090351.html#a5761329 Sent from the PostgreSQL - hackers

Re: [HACKERS] snapshot replication with pg_dump

2006-08-21 Thread Paul Silveira
hen pipe that complete thing to the remote server to be executed as a transaction so that users could still read from that able while my command was running. Any ideas??? Thanks in advance, Paul Christopher Browne-4 wrote: > > [EMAIL PROTECTED] (Paul Silveira) writes: >> Doe

Re: [HACKERS] snapshot replication with pg_dump

2006-08-21 Thread Paul Silveira
t I'm not moving data that doesn't need to be moved. The goal is to only shapshot data in tables that has changed. I would like to wrap that in a transaction. -Paul Martijn van Oosterhout wrote: > > On Mon, Aug 21, 2006 at 06:40:22AM -0700, Paul Silveira wrote: >>

Re: [HACKERS] BugTracker (Was: Re: 8.2 features status)

2006-08-22 Thread Bort, Paul
and there's never been a problem. Are the queries optimal? no. The alternative might have been MySQL-only, and that would be worse. I can't really give a fair estimate on performance, because I'm running it on a PIII at 800MHz with several other things as well. But it's fast

Re: [Pgsqlrpms-hackers] [HACKERS] Safer auto-initdb for RPM init

2006-08-25 Thread Bort, Paul
s > that. And we're > trying to defend exactly against the case where someone has > set up a mount > point manually. > It had never occurred to me, but I'm definitely going to start doing it now. So it will be in practice, at least around here. Regar

Re: [HACKERS] Reducing data type space usage

2006-09-15 Thread Bort, Paul
that 127 characters is an OK limit. +1 for Bruce/Tom's idea. Regards, Paul Bort ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

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

2005-03-10 Thread Bort, Paul
Title: RE: [HACKERS] We are not following the spec for HAVING without GROUP BY > Would those of you with access to other DBMSes try this: Results for "Microsoft SQL Server  2000 - 8.00.944 (Intel X86)":     --- (0 row(s) affected)     --- 1 (1

Re: [HACKERS] Raw size

2005-03-10 Thread Bort, Paul
Title: RE: [HACKERS] Raw size > > 990 * 2072 = 2,051,280 Bytes > > BUT after clustering triples according to an index on att1: > > > 142 * 8 * 1024 = 1,163,264 Bytes > > > Is there any compression or what? > varchar means 'character varying'. What varies is the length. So a varchar(1

Re: [HACKERS] RFC: built-in historical query time profiling

2005-03-24 Thread Bort, Paul
Title: RE: [HACKERS] RFC: built-in historical query time profiling > I see your point.  The ugliness of log-parsing beckons. > Maybe it would make sense to use a separate log server machine, where they could be written to a database without impacting production?

Re: [HACKERS] Proposal for background vacuum full/cluster

2005-04-20 Thread Paul Tillotson
Are you thinking of coding this, or just suggesting it for others? I was thinking of coding something like this but found that I didn't understand enough of the internals of how the vacuum command actually works to be able to write this. I'd be willing to devote perhaps a few hours a

Re: [HACKERS] Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords

2005-04-20 Thread Paul Tillotson
hashes. Perhaps for 8.1 a new authentication method, say, "securemd5," ought to be created in which remedies this deficiency? Regards, Paul Tillotson *Interesting mental exercise: if all that your SQL injection allows is to add conditions to a WHERE clause evaluated as superuser,

Re: [HACKERS] Postgres: pg_hba.conf, md5, pg_shadow, encrypted passwords

2005-04-21 Thread Paul Tillotson
Tom Lane wrote: Paul Tillotson <[EMAIL PROTECTED]> writes: Hm? Using md5 is certainly not any *more* dangerous than any of the other possible password-based methods. Maybe I misunderstood, but I thought that others were saying that, if someone gets the contents of pg_shadow, then

Re: [HACKERS] Proposal for background vacuum full/cluster

2005-04-21 Thread Paul Tillotson
could test the idea without writing any code at all. Regards, Paul Tillotson ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Proposal for background vacuum full/cluster

2005-04-21 Thread Paul Tillotson
Jim C. Nasby wrote: On Wed, Apr 20, 2005 at 08:10:23PM -0400, Paul Tillotson wrote: P. S. The last time I thought about it, I decided that the best solution is probably one that works just like vacuum full except that it scans the table in reverse order. It would do something like this

Re: [HACKERS] possible TODO: read-only tables, select from indexes

2005-04-23 Thread Paul Tillotson
2. Simple tables can be much smaller since you don't need most of the HeapTupleHeaderData. What you are talking about is not a "read only" table, it is a "non-MVCC" table. This is a much greater assault on the fundamental semantics of Postgres than it's being painted to be in this thr

Re: [HACKERS] [COMMITTERS] pgsql: Fix NUMERIC modulus to properly

2005-06-06 Thread Paul Tillotson
nge the round_var() to a trunc_var() at the end of the function div_var(). It does not pass, but I think that is because the regression test is expecting that division will round up. (Curiously, the regression test for "numeric" passes, but the regression test for aggregation--sum()

[HACKERS] t_ctid chains

2005-08-18 Thread Paul Tillotson
pages and (b) causing the extra complexity such as the bugs mentioned in VACUUM FULL. So: what are the t_ctid chains good for? If this is too long or too elementary to type, can someone point me to the source code that uses t_ctid chains? Regards, Paul Tillotson ---

[HACKERS] where can I get the HTML docs

2004-03-23 Thread Paul Tillotson
Can anyone show me where to download a zipped tarball of .html files of what exists at the following link? http://www.postgresql.org/docs/7.4/static/index.html Thanks. Paul ---(end of broadcast)--- TIP 2: you can get off all lists at once with

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-03 Thread Paul Ramsey
eware. -- __ / | Paul Ramsey | Refractions Research \_ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

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

2004-04-27 Thread Paul Tillotson
iming for users who had a clue quotient much lower than I, but those attain an excellent balance between too short and simple to be useful and too long and complicated. Paul Tillotson ---(end of broadcast)--- TIP 1: subscribe and unsubscribe comman

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

2004-04-27 Thread Paul Tillotson
pport for NULLS, etc. (2) Upon a casual read of the docs I couldn't figure out how to read any values from the database other than what was passed into the pl{perl|python|php} function. I.e., how do you run a select? What client libraries do you use? Maybe the others just need better d

Re: [HACKERS] Email data type

2004-05-17 Thread Bort, Paul
assigned a block like 123.45.6.0/23. So the network address would be 123.45.6.0, the broadcast address would be 123.45.7.255, and everything in between, including 123.45.6.255 and 123.45.7.0, would be available for your servers. HTH, Paul ---(end of broadcast)--

Re: [HACKERS] SELECT * FROM LIMIT 1; is really slow

2004-05-26 Thread Paul Ramsey
eft over from before the upgrade to GiST? -- __ / | Paul Ramsey | Refractions Research | Email: [EMAIL PROTECTED] | Phone: (250) 885-0632 \_ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Default Locale in initdb

2004-06-02 Thread Paul Ramsey
s a bad idea is that certain features of the database which only work correctly with a locale of "C" will not work by default. This is not new behaviour. (Why are you the only person who posts here who is nameless?) cheers andrew -- __ / | Paul Ramsey | Refractions

Re: [HACKERS] serverlog function

2004-06-07 Thread Bort, Paul
Andreas wrote: > > AFAICS, we have some alternatives: > - try to grab the currently created files/syslog/eventlog. > Seems hard to > do, because we'd depend on additional external tools. > - redirect stderr to a postgresql.conf known file. > Disadvantage: breaks > piping. > - maintain a shared

Re: [HACKERS] Nested xacts: looking for testers and review

2004-06-10 Thread Bort, Paul
ich sub-transactions are show stoppers, and which ones aren't. Or if I'm completely off base, please forgive my intrusion. Paul ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
for $libdir (perhaps it is referencing the $libdir macro instead of the $pkglibdir macro?). So tools like 'createlang' fail, and loading .sql files that reference things like $libdir/libfoo.so also fail. Paul ---(end of broadcast)--- TI

Re: [HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
stgresql endif endif Bruce Momjian wrote: Devrim GUNDUZ wrote: Hi, On Wed, 18 Aug 2004, Paul Ramsey wrote: When installing PgSQL into a non-standard location (like /opt/foo) the configure script decides to install all the contrib libraries and plpglsq into /opt/foo/lib/postgresql. This would be fine,

Re: [HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
MAXPGPATH); canonicalize_path(ret_path); } Bruce Momjian wrote: Devrim GUNDUZ wrote: Hi, On Wed, 18 Aug 2004, Paul Ramsey wrote: When installing PgSQL into a non-standard location (like /opt/foo) the configure script decides to install all the contrib libraries and plpglsq into /opt/foo/lib/postgresql. This wou

Re: [HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
t/8.0/bin/postgresql? --- Paul Ramsey wrote: Check this out! [EMAIL PROTECTED] bin]$ ./pg_config --pkglibdir /home/pramsey/pgtest/8.0/bin/lib/postgresql ^^^ And yet: ./port/pg_config_paths.h:#define PKGLIBDIR "/home/pramsey/pgtest/8

Re: [HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
g_config --pkglibdir", if I started it from any *other* location at all then things would have worked. Paul Tom Lane wrote: Paul Ramsey <[EMAIL PROTECTED]> writes: ... It is the actual binaries that seem to not know where $libdir is supposed to be. Where do they think it is? A useful

Re: [HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
createlang plpgsql test [EMAIL PROTECTED] 8.0]$ Magically, everything now works :) Tom Lane wrote: Paul Ramsey <[EMAIL PROTECTED]> writes: ... It is the actual binaries that seem to not know where $libdir is supposed to be. Where do they think it is? A useful way to check would be to strace t

Re: [HACKERS] $libdir and 8.0

2004-08-18 Thread Paul Ramsey
Thanks Tom, Yes, this is beta1, not the CVS tip, so all is golden. Paul Tom Lane wrote: Paul Ramsey <[EMAIL PROTECTED]> writes: I started the database from "/home/pramsey/pgtest/8.0/bin" using "./pg_ctl start -D /home/pramsey/pgtest/8.0/data" Ah-hah ... and this is 8.0

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-24 Thread Paul Vernon
DBMS'es are just too slow No, I think Anthony is just saying that he doesn't "believe" in science/the scientific method. Or maybe he believes that engineering is not based on scientific knowledge! > >"Think different". Think Engineering, not Mat

[HACKERS] background writer, WAL and snapshot backups

2003-11-28 Thread Paul Tuckfield
I really like the idea of taking a snapshot backup with postgres, using either volume manager or hardware splits in a disk array to get a physical backup. In other, lesser database systems :) the system is structured to prevent problems arising from "split block" writes, meaning that though the da

[HACKERS] plpgsql Integer Concat To String

2003-12-18 Thread Paul Punett
into Table values(IdForEachRun, ..) counter := counter + 1; IdForEachRun := IdSet || counter;(PROBLEM HERE) --Or IdForEachRun := IdSet + counter;(PROBLEM HERE) END LOOP END Language 'plpgsql' Thanks in advance. Paul Puneet ---(end of broadcast)---

[HACKERS] COPY TABLE TO

2003-12-22 Thread Paul Punett
I am developing on C++ with PostGre on windows. I need to port to Linux later. Any suggestions on linking C++ code to PostGre (queries & functions) Thanks Paul ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an a

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Bort, Paul
Please forgive me if this is silly, but if you wanted XML from the server, couldn't you just write a PL/Perl untrusted function that takes a SELECT statement as its parameter, and returns a single scalar containing the XML? - The XML:: modules in Perl help with the XML formatting - DBD::PgSPI could

Re: PostGIS dropgeometrycolumn function (Was: Re: [HACKERS] [7.4]

2004-02-03 Thread Paul Ramsey
ne in the current version. In an idea world though, we would construct the thing as a view, so that when you did a CREATE TABLE that included a geometry type, you would automatically get a row in geometry_columns. That requires a view on system tables though, and that just does not work. :/ Any

Re: PostGIS dropgeometrycolumn function (Was: Re: [HACKERS] [7.4]

2004-02-03 Thread Paul Ramsey
e geometry selectivity stats. Paul On Tuesday, February 3, 2004, at 11:00 AM, Tom Lane wrote: Paul Ramsey <[EMAIL PROTECTED]> writes: In an idea world though, we would construct the thing as a view, so that when you did a CREATE TABLE that included a geometry type, you would automatica

Re: [HACKERS] Multicolumn Indexing using R-Tree

2004-02-03 Thread Paul Ramsey
Try using GiST rtree (examples in contrib), GiST supports multi-key indexes. On Tuesday, February 3, 2004, at 06:56 AM, Marcio Caetano wrote: I'm using PostgreSQL 7.3.2 and I need to create a R-Tree index that uses more than one column in a table. When I run the instruction it appears this messa

[HACKERS] PostGIS Integration

2004-02-03 Thread Paul Ramsey
P. On Tuesday, February 3, 2004, at 12:06 PM, Tom Lane wrote: Paul Ramsey <[EMAIL PROTECTED]> writes: Oh, now I remember. The deal was not views, it was triggers. Oh, okay. You're right, we don't do triggers on system tables. But couldn't you combine a view on the system ta

Re: [HACKERS] Cannot read block error.

2004-02-14 Thread Bort, Paul
> Interesting, when I went to copy my data directory out of the way, I > received this from cp: > > cp: data/base/16976/17840: Result too large > > might be a clue I don't think it's PostgreSQL. I would suggest unmounting the volume and running fsck (or the equivalent for your environment.) I

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

2004-02-27 Thread Bort, Paul
> -Original Message- > From: Greg Stark [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 12:17 AM > To: [EMAIL PROTECTED] > Subject: Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal > [...snip...] > I might suggest again RT. It's open source and has serious commercial > tr

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

2004-02-27 Thread Bort, Paul
> > My apologies, then! I was operating off of the statements > of others, and the > fact that the only RT impelementations I've used were running > on MySQL. So, > questions: > > 1) can you compare/contrast RT vs. BZ vs. Simplified > bug-tracking, like > GForge? I've used Bugzilla for

Re: [HACKERS] [GENERAL] Why does app fail?

2004-02-28 Thread Paul Simpson
>>>> Shridhar Daithankar <[EMAIL PROTECTED]> 25/02/2004 10:31:16 >>>>On Wednesday 25 February 2004 15:38, Paul Simpson wrote:>> Thank you for the advice, unfortunately, that isn't an option, you see I>> didn't write the application and so

Re: [HACKERS] Collaboration Tool Proposal

2004-02-28 Thread Bort, Paul
ibility that it will later turn out to be a free straitjacket. Regards, Paul > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 1:19 PM > To: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Collaboration Tool Proposal &

Re: [HACKERS] [ADMIN] Schema comparisons

2004-02-28 Thread Bort, Paul
Ordering the pg_dump output by name within classes instead of OID sounds good to me, too. Also, something that might be easier for comparing schemata between databases: rather than dumping the database, have you tried using PostgreSQL Autodoc (http://www.rbt.ca/autodoc/) which just outputs the sc

Re: [HACKERS] Avoid MVCC using exclusive lock possible?

2004-03-01 Thread Paul Tillotson
7;$old_table';"); exec("UPDATE pg_class SET relfilenode = $table1node WHERE relname = '$new_table';"); You would of course need to change the relfilenode for all of the toasted columns and indexes as well in the same atomic step, but it seems like this might be more compatib

Re: [HACKERS] [PERFORM] Looking for a tool to "*" pg tables as ERDs

2006-02-23 Thread Bort, Paul
I'll second autodoc. Been using it with Docbook and Dia for over a year with good results. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew Dunstan > Sent: Thursday, February 23, 2006 12:00 PM > To: Markus Schaber > Cc: Ron Peacetree; pgs

[HACKERS] Vacuum dead tuples that are "between" transactions

2006-02-27 Thread Paul Tillotson
e the major difficulty here is that currently a transaction has no way of knowing when another backend's command started to run? Is this too difficult to do or is it a good idea that no one has enough 'round tuits for? Regards, Paul Tillotson ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] plpgsql by default

2006-04-12 Thread Bort, Paul
> > I wonder if Oracle ever recommended disabling PL/SQL (not to > mention MS Transact-SQL)... > Don't know abiout Oracle, but you can't disable Transact-SQL in SQL Server 7.0 or 2000 (don't know about 2003^h5) because Enterprise Manager and sp_help* require it. And +1 for not installing plpgs

Re: [HACKERS] Unresolved Win32 bug reports

2006-04-20 Thread Bort, Paul
Some of the SysInternals tools might be a start. ProcessExplorer provides information about processes: http://www.sysinternals.com/Utilities/ProcessExplorer.html DebugView shows Debugging output (not sure if PG uses this): http://www.sysinternals.com/Utilities/DebugView.html Also, I haven't use

Re: [HACKERS] Google SoC--Idea Request

2006-04-25 Thread Bort, Paul
> > Personally I would much rather see a tuning advisor tool in > more general > > use than just provide small/medium/large config setting files. > > True dat. Maybe the SoC project here is just such a tuning advisor tool? Something that can run pgbench repeatedly, try different settings, and co

Re: [HACKERS] Compression and on-disk sorting

2006-05-16 Thread Bort, Paul
> > Compressed-filesystem extension (like e2compr, and I think either > Fat or NTFS) can do that. > Windows (NT/2000/XP) can compress individual directories and files under NTFS; new files in a compressed directory are compressed by default. So if the 'spill-to-disk' all happened in its own spe

[HACKERS] Latest timezone data in 8.1.4

2006-06-10 Thread Paul Lindner
this the correct way to do this? * Can updating the timezone data be a part of the release checklist? * Finally, is it possible to upgrade a running server with new timezone data? -- Paul Lindner| | | | | | | | | | [EMAIL PROTECTED] pgpaYwDMYHRWb.pgp Description: PGP signature

Re: [HACKERS] Rethinking stats communication mechanisms

2006-06-18 Thread Bort, Paul
he current contents of the counter, but since it's per-back end, I think it would work. Regards, Paul Bort ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Rethinking stats communication mechanisms

2006-06-19 Thread Bort, Paul
aining concern would be the possibility of the reader thrashing because the writer is updating so often that the reader never gets the same counter twice. IIRC, the reader was only sampling, not trying to catch every entry, so that will help. But is it enough? Regards, Paul Bort -

Re: [HACKERS] uuid type for postgres

2005-09-06 Thread Paul Ramsey
Just an FYI: We also ended up rolling our own uuid type, against libuuid. It seems that uuid is a widespread enough concept that implementors *will* be asked to support it, moderately often. We *could* roll our own (were capable), others are not so lucky, and would have to point out the

[HACKERS] Differences in UTF8 between 8.0 and 8.1

2005-10-22 Thread Paul Lindner
ve.com/pgsql-patches@postgresql.org/msg08198/unicode.diff Is there any solution other than scrubbing the entire dataset to conform to the new (8.1) encoding rules? -- Paul Lindner| | | | | | | | | | [EMAIL PROTECTED] pgpkf6ogYMIyZ.pgp Description: PGP signature

Re: [HACKERS] Differences in UTF8 between 8.0 and 8.1

2005-10-23 Thread Paul Lindner
On Sun, Oct 23, 2005 at 05:56:50AM -, Andrew - Supernews wrote: > On 2005-10-22, Paul Lindner <[EMAIL PROTECTED]> wrote: > > I've generated dumps using pg_dump from 8.0 and 8.1. Attempting to > > restore these results in > > > > Invalid UNICODE byte seq

Re: [HACKERS] Differences in UTF8 between 8.0 and 8.1

2005-10-26 Thread Paul Lindner
a pipe between pg_dump and psql. Anyone have any other recommendations? GNU recode might do it, but I'm a bit stymied by the syntax. A quick perl script using Text::Iconv didn't work either. I'm off to look at some other perl modules and will try to create a script so I

Re: [HACKERS] Differences in UTF8 between 8.0 and 8.1

2005-11-01 Thread Paul Lindner
assed through the problem character sequences. I'm still looking for an iconv that doesn't read the entire file into memory. At this point I'm looking to use the split command to process input in 1 line chunks. Sadly that can't be used i

Re: [HACKERS] Upcoming PG re-releases

2005-12-04 Thread Paul Lindner
dump.sql Another possible solution is to use the --inserts flag to pg_dump. When you load the resulting data dump in 8.1 this will result in the problem rows showing up in your error log. -- Paul Lindner| | | | | | | | | | [EMAIL PROTECTED] pgpmSxHGkaqYp.pgp Description: PGP signature

Re: [HACKERS] Upcoming PG re-releases

2005-12-04 Thread Paul Lindner
On Sun, Dec 04, 2005 at 11:34:16AM -0500, Tom Lane wrote: > Paul Lindner <[EMAIL PROTECTED]> writes: > > To convert your pre-8.1 database to 8.1 you may have to remove and/or > > fix the offending characters. One simple way to fix the problem is to > > run your pg_du

[HACKERS] MIN() performance regression 8.0 -> 8.1

2005-12-04 Thread Paul Lindner
--- Aggregate (cost=5524.70..5525.25 rows=1 width=8) -> Index Scan using mm_moo_summary_blog_id on mm_moo_summary (cost=0.00..5519.37 rows=2132 width=8) Index Cond: (moo_summary_b_id = 21522) (3 rows) -- Paul Lindner| | | | | | | | | | [EMAIL PROTECTED] pgpfVJMa8Upnn.pgp Description: PGP signature

Re: [HACKERS] Supporting Encryption in Postgresql

2004-09-09 Thread Paul Tillotson
this be provided by the client and kept in RAM only? Paul Tillotson Murat, For our research project, I need to implement an encryption support for Postgressql. At this current phase, I need to at least support page level encryption In other words, each page that belongs to a certain sensitive

Re: [HACKERS] pg_locks view and user locks

2004-09-13 Thread Paul Tillotson
This is the first I have ever heard "user locks," but I have more than once wanted a lock that would persist beyond the end of a transaction. Do these do that? Paul "Merlin Moncure" <[EMAIL PROTECTED]> writes: ... is there any merit to promoting the user lo

Re: [HACKERS] psql \e broken again

2004-11-15 Thread Bort, Paul
Title: RE: [HACKERS] psql \e broken again From: Peter Eisentraut [mailto:[EMAIL PROTECTED]] > > Is there a Windows port of the command-line cvs tool?  That > would be a > good thing to compare with. > The one that I see most often ( and use here ) is CVSGUI ( http://www.wincvs.org/ ), wh

Re: [HACKERS] psql \e broken again

2004-11-16 Thread Bort, Paul
Title: RE: [HACKERS] psql \e broken again From: Zeugswetter Andreas DAZ SD [mailto:[EMAIL PROTECTED]] > > I am not sure the test is valid, since %EDITOR% was used on > the command line, > which does it's own magic on quotes. Is there a command that > would use the > envvar EDITOR without

Re: [Testperf-general] Re: [HACKERS] ExclusiveLock

2004-11-23 Thread Bort, Paul
Title: RE: [Testperf-general] Re: [HACKERS] ExclusiveLock > The impression I had was that disk drives no longer pay the slightest > attention to interleave specs, because the logical model > implied by the > concept is too far removed from modern reality (on-disk buffering, > variable numbers

Re: [Testperf-general] Re: [HACKERS] ExclusiveLock

2004-11-23 Thread Bort, Paul
Title: RE: [Testperf-general] Re: [HACKERS] ExclusiveLock > From: Doug McNaught [mailto:[EMAIL PROTECTED]] > > "Bort, Paul" <[EMAIL PROTECTED]> writes: > > >    One other thought: How does static RAM compare to disk > speed nowadays? > >    A 1Gb

Re: [Testperf-general] Re: [HACKERS] ExclusiveLock

2004-11-24 Thread Bort, Paul
erstanding of PostgreSQL internals. :-) Maybe I'll get a chance to try the flash drive WAL idea in the next couple of weeks. Need to see if the hardware guys have a spare flash drive I can abuse. Paul

Re: [HACKERS] Call for port reports

2004-12-07 Thread Bort, Paul
Title: RE: [HACKERS] Call for port reports Port report for Gentoo (www.gentoo.org) Linux: No errors. uname -a: Linux imgvmhost 2.4.26-gentoo-r3 #1 Tue Sep 7 14:20:02 EDT 2004 i686 Intel(R) Pentium(R) 4 CPU 2.40GHz GenuineIntel GNU/Linux gcc -v: gcc version 3.3.4 20040623 (Gentoo Linux 3.3.4

[HACKERS] tool for incrementally shrinking bloated tables

2004-12-20 Thread Paul Tillotson
omments? Am I missing some obvious way of accomplishing this goal? Is anyone working on something like this? Paul Tillotson ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [PATCHES] Merge pg_shadow && pg_group -- UNTESTED

2005-01-28 Thread Bort, Paul
Title: RE: [HACKERS] [PATCHES] Merge pg_shadow && pg_group -- UNTESTED > a) start from the user: >    Search for useroid in pg_auth_members.member >    For each returned role, search for that role in member column >    Repeat until all roles the useroid is in have been found >    [Note: This c

Re: [HACKERS] [BUGS] Bug in create operator and/or initdb

2005-01-31 Thread Paul Vixie
> We didn't really want to assume that all platforms are using libbind :-( i think you could have, at the time, since windows wasn't even a gleam in pgsql's eye. even now, libbind would be a dependable universal dependency, since we publish windows binaries. > > the pgsql "fork" of this code did

Re: [HACKERS] [BUGS] Bug in create operator and/or initdb

2005-01-31 Thread Paul Vixie
endif #include "port_before.h" @@ -59,7 +59,7 @@ * Paul Vixie (ISC), June 1996 */ static int -inet_net_pton_ipv4( const char *src, u_char *dst, size_t size) { +inet_net_pton_ipv4(const char *src, u_char *dst, size_t size) { static const char xdigits[] = "0123

Re: [HACKERS] Escaping the ARC patent

2005-02-05 Thread Bort, Paul
Title: RE: [HACKERS] Escaping the ARC patent > > Just an idle thought, but each connection to the DB could add a fixed > amount to some queueing parameter. The amount added to be set > per backend, > and the client could use a SET variable to adjust the > standard amount for > it's own b

Re: [HACKERS] New form of index "persistent reference"

2005-02-10 Thread Bort, Paul
Title: RE: [HACKERS] New form of index "persistent reference" If that ID is the only thing you use to access that data, why not just store it in a flat file with fixed-length records? seek() (or your language's equivalent) is usually fast. If you need to drive that from within PostgreSQL, yo

[HACKERS] Hashable custom types

2014-04-25 Thread Paul Ramsey
t can one be hooked up somewhere else? In an operator? Thanks, P -- Paul Ramsey http://cleverelephant.ca http://postgis.net -- 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] [PROPOSAL] Temporal query processing with range types

2017-10-06 Thread Paul A Jungwirth
built against Postgres 9.0!) I hope we take their contribution seriously, because it would truly move Postgres's temporal support beyond any database on the market. Yours, Paul [1] https://files.ifi.uzh.ch/boehlen/Papers/modf174-dignoes.pdf [2] http://www.zora.uzh.ch/id/eprint/130374/1/Extendin

[HACKERS] about missing xml related functionnalities

2016-11-02 Thread Jean-Paul Jorda
xslt transformation is a very efficient way to achieve that. So, as far as I'm concerned, xslt transformation appears to be a missing fuctionnality in the newer api. Best regards, Jean-Paul -- Jean-Paul JORDA Centre de ressources technologiques Coordinateur de l'équipe des dévelo

Re: [HACKERS] New partitioning - some feedback

2017-07-10 Thread Paul A Jungwirth
re important for partitions not to be so noisy. Paul -- 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] pg_stop_backup(wait_for_archive := true) on standby server

2017-08-05 Thread Paul A Jungwirth
f pg_stop_backup(boolean) allows for inconsistent backups, it does sound like a problem on 9.6 too. Paul -- 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] pg_stop_backup(wait_for_archive := true) on standby server

2017-08-05 Thread Paul A Jungwirth
On Sat, Aug 5, 2017 at 1:28 PM, Paul A Jungwirth wrote: > On Sat, Aug 5, 2017 at 7:51 AM, Robert Haas wrote: >> After refreshing my memory further, I take it back. pg_stop_backup() >> doesn't even have a second argument on v9.6, so back-porting this fix >> to 9.6 is a

Re: [HACKERS] pg_stop_backup(wait_for_archive := true) on standby server

2017-08-05 Thread Paul A Jungwirth
On Sat, Aug 5, 2017 at 6:22 PM, Robert Haas wrote: > On Sat, Aug 5, 2017 at 4:28 PM, Paul A Jungwirth > wrote: >> I don't have an opinion on the urgency of back-porting a fix, but if >> pg_stop_backup(boolean) allows for inconsistent backups, it does sound >> like

Re: [HACKERS] First Aggregate Funtion?

2015-07-20 Thread Paul A Jungwirth
a proposal to add these functions to core Postgres? Yours, Paul -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] GiST support for UUIDs

2015-06-24 Thread Paul A Jungwirth
d go? The btree_gist extension? The uuid-ossp extension? Somewhere else? If anyone has any advice I'd be grateful to hear it. Thanks, Paul -- 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] GiST support for UUIDs

2015-06-25 Thread Paul A Jungwirth
On Thu, Jun 25, 2015 at 8:06 AM, Tom Lane wrote: > Paul A Jungwirth writes: >> I'm interested in adding GiST support for the UUID column type >> . . . . So I'm curious where this change would go? > btree_gist, I'd think Okay, thank you for your answer! I was wo

[HACKERS] tsearch2, gin and @@@ operator?

2007-08-30 Thread Jean-Paul Argudo
Please let me know when to use @@ or @@@ if I may not use allways @@@ in those case, as I can tweak my plpgsql function. Thanks a lot, -- Jean-Paul Argudo www.PostgreSQLFr.org ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Feature request : add REMAP_SCHEMA-like option to pg_restore

2009-08-31 Thread Jean-Paul Argudo
ion to the feature. I must admit too this is a patch I'd like to write too (it would be my very first) but I don't know if my C skills are good enough to do so. Cheers, -- Jean-Paul Argudo www.PostgreSQL.fr www.Dalibo.com -- 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] experimental pg_qcache patch

2002-04-16 Thread Jean-Paul ARGUDO
t to take into consideration those new functialities (Michael?). Be sure to have feedback on this :-) Thanks again for such initiative! I'm going to inform my co-worker (C++ senior) on your patch with the hope he can help you. Cheers, -- Jean-Paul ARGUDOIDEALX

<    1   2   3   4   >