Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

Marc Balmer m...@msys.ch writes: My SQL is PostgreSQL PostgreSQL really is YeSQL! -- you can check http://yesql.org too -- Dimitri Fontaine06 63 07 10 78 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general

Re: [GENERAL] pg_dump -s dumps data?!

. If that doesn't need any pg_dump stretching I think providing that in 9.2 would be great. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Using Postgresql as application server

land for a long time already, no need to resort to other proprietary architectures here. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Dump a database excluding one table DATA?

. -N can be given more than once to exclude schemas matching any of several patterns. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Using Postgresql as application server

the queue and send emails. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Using Postgresql as application server

database. I am not thinking of implementing as it is It's been around for a long time already: http://asmith.id.au/mod_libpq.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] pgloader hangs with an invalid filename

certainly due to current threading implementation in pgloader, I guess the control thread is still waiting for the load to terminate, which will never happen. It seems to be fixed in current version though. See if you can upgrade. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL

Re: [GENERAL] Adapting existing extensions to use CREATE EXTENSION

, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgloader hangs with an invalid filename

the development now happens at github. http://packages.debian.org/search?keywords=pgloader http://github.com/dimitri/pgloader Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Huge spikes in number of connections doing PARSE

is tied to real active connection, I don't see what it would solve. Still, if you're searching ideas… Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Multiple instances with same version?

://manpages.debian.net/cgi-bin/man.cgi?query=pg_lsclusters http://manpages.debian.net/cgi-bin/man.cgi?query=pg_createcluster Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] converting databases form SQL_ASCII to UTF8

need? For converting, you might be interested into those two blog entries: http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_1.html http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL

Re: [GENERAL] Partitioning an existing table

still can rejigger your data around if you wish. With time based partitioning it's best to wait until the old partition is not the target of INSERTs or UPDATEs any more. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general

Re: [GENERAL] [HACKERS] PostgreSQL Core Team

Thom Brown t...@linux.com writes: Excellent! Magnus is a very valuable contributor to the PostgreSQL community and I think the community can only benefit from this addition to the core team. +1 Congrats, Magnus! -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation

Re: [GENERAL] Finding Errors in .csv Input Data

pgloader yet? http://pgloader.projects.postgresql.org/ http://pgfoundry.org/projects/pgloader/ https://github.com/dimitri/pgloader http://packages.debian.org/sid/pgloader Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via

Re: [GENERAL] Covert database from ASCII to UTF-8

. Those blog articles of mine might be of interest to you: http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_1.html http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et

Re: [GENERAL] FTS and words near one another

in their presentation at pgcon here: http://www.pgcon.org/2009/schedule/events/119.en.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] How to Create Table from CSV

://developer.postgresql.org/pgdocs/postgres/ddl-foreign-data.html http://developer.postgresql.org/pgdocs/postgres/sql-createforeigndatawrapper.html http://developer.postgresql.org/pgdocs/postgres/file-fdw.html Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et

Re: [GENERAL] How to extract a value from a record using attnum or attname?

)..array_upper(keycols, 1) loop select quote_ident(attname) from pg_catalog.pg_attribute where attrelid = tg_relid and attnum = keycols[i]::oid Beware of attisdropped, which I've not fixed in the published URL before (the tapoueh.org one). Regards, -- Dimitri Fontaine http://2ndQuadrant.fr

Re: [GENERAL] How best to load modules?

(branches named extension and upgrade) and try it for yourself, then maybe send a mail about your findings (we call that a review): http://git.postgresql.org/gitweb?p=postgresql-extension.git;a=summary http://wiki.postgresql.org/wiki/Reviewing_a_Patch Regards, -- Dimitri Fontaine http

Re: [GENERAL] Have any tricks not to recreate a standby server to switch to the former primary?

/repmgr http://groups.google.com/group/repmgr Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Updated Latch Patch

, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Full Text Partial Match at begining

AI Rumman rumman...@gmail.com writes: Is it possible to match %text' in Postgresql 9 Full Text. See http://www.sai.msu.su/~megera/wiki/wildspeed -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Can you check in SQL if a fields can be encoded using specified charset

the text can't be converted, but you could have a plpgsql function catching the exception for you and returning false. Won't be very fast, but will do the job. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing

Re: [GENERAL] Adding data from mysql to postgresql periodically

reformat feature, and the mysql to PostgreSQL timestamp that you have to use sometime (depends on the MySQL minor version, if memory serves). Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] finding the other statement causing a sharelock

/explicit-locking.html#ADVISORY-LOCKS http://www.postgresql.org/docs/8.3/static/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Need magic to clean strings from unconvertible UTF8

the source files before importing them? Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Cloning database without dump/restore

wouldn't expect it to be fast though. -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Group by and limit

functions! Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_get_procdef ?

, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how to get the height of index tree?

for btree, but I guess it would be very useful. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Replication

are not canceled at the time you flick the switch to have your standby a master. The ongoing read-only traffic is not affected. That's hot. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] index in desc order

, but that how to model that is still unclear and undone in the cost estimations. You will have to crawl the pgsql-performance list yourself, though… Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Visualize GiST Index

Oleg Bartunov o...@sai.msu.su writes: We never expected gevel will be used by users :-) It's very very useful when developing custom GiST indexes! -- dim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Good candidate query for window syntax?

Ketema Harris ket...@gmail.com writes: My goal is: To find the maximum number of concurrent rows over an arbitrary interval. My guess is that the following would help you: http://wiki.postgresql.org/wiki/Range_aggregation -- dim -- Sent via pgsql-general mailing list

Re: [GENERAL] table - sequence dependent informatio

Peter Geoghegan peter.geoghega...@gmail.com writes: On 31 August 2010 18:02, akp geek akpg...@gmail.com wrote: Hi all -         Is there a way I can tell table - sequence dependent information.  which sequences are being used by which table? thanks for the help Take a look at the post

Re: [GENERAL] PostgreSQL and distributed transactions

Jayadevan M jayadevan.maym...@ibsplc.com writes: But the initial setup for the client is done by 'Admin' and in that work-flow, we need distributed transactions. The transaction will start from the 'Admin server, do some inserts on the 'Client' server and then either rollback or commit on

Re: [GENERAL] Converting BYTEA from/to BIGINT

Vincenzo Romano vincenzo.rom...@notorand.it writes: Now, why doing this? I am using a plain SEQUENCE to create a (kind of) session ID. That is simple but predictable. The idea is to use this function in conjunction with encrypt (from pgcrypto) and the blowfish algorithm to make that sequence

Re: [GENERAL] Integral PG DB replication

Gauthier, Dave dave.gauth...@intel.com writes: Will DB replication be integral in v9? If so, when (approx) will that be out? Integral meaning all the cluster at a time, yes. You can help have it out sooner by testing it and reporting your findings. I think the goals are to have 9.0.0 out by

Re: [GENERAL] No PL/PHP ? Any reason?

Joshua D. Drake j...@commandprompt.com writes: Any chance that the Parrot runtime could be used for PHP and other languages? I read that some folks are working on PL/Parrot. I'd really like to have PHP and Lisp for PL languages :). http://plscheme.projects.postgresql.org/ Not exactly

Re: [GENERAL] copy/duplicate database schemas

Merlin Moncure mmonc...@gmail.com writes: On Wed, Jun 23, 2010 at 3:21 PM, Jamie Kahgee jamie.kah...@gmail.com wrote: I have an application in a schema and now i need to create other schemas b/c the app needs to support different languages,  is there an easy way to copy an entire schema to a

Re: [GENERAL] High Availability with Postgres

John R Pierce pie...@hogranch.com writes: yeah. generally when money is involved in the transactions, you gotta stick to the 'no committed data lost ever'. there's plenty of other use cases for that too. Well, it's a cost/benefit/risk evaluation you have to make. It'd be bad news that the

Re: [GENERAL] libpython - cannot open shared object file

Tom Wilcox hungry...@gmail.com writes: Next problem: $libdir/fuzzystrmatch: No such file or directory. I guess I need to install the /share stuff separately.. Looks like apt-get install postgresql-contrib-8.4 should do the trick.

Re: [GENERAL] What type of index should I use?

Mike Christensen m...@kitchenpc.com writes: I have a varying(200) text column that I need to be able to do lookups on very fast (WHERE col = 'foo') Btree is what to use here. GIN covers cases where you index arrays. I estimate the table will hold around 5,000 rows, never any more. It

Re: [GENERAL] High Availability with Postgres

John R Pierce pie...@hogranch.com writes: failure modes can include things like failing fans (which will be detected, resulting in a server shutdown if too many fail), power supply failure (redundant PSUs, but I've seen the power combining circuitry fail). Any of these sorts of failures

Re: [GENERAL] Hot Standby switchover

Hi, Shoaib Mir shoaib...@gmail.com writes: Now Hot-Standby is setup like this... A -- B  A -- C Now if I will like to do a switch so as to make B the new master and have my replication look like this: B -- C  B -- A Where are the steps I need for doing so? First, you need a common

Re: [GENERAL] High Availability with Postgres

John R Pierce pie...@hogranch.com writes: Two DB servers will be using a common external storage (with raid). This is also one of the only postgres HA configurations that won't lose /any/ committed transactions on a failure. Most all PITR/WAL replication/Slony/etc configs, the standby

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

sunpeng blueva...@gmail.com writes: hi,i write a function in postgresql source code, how to register this function? See src/include/catalog/pg_proc.h But you should *really* consider making it a loadable module. That's the way it makes sense for any code you want to add in the server unless

Re: [GENERAL] Monitoring activities of PostgreSQL

Allan Kamau kamaual...@gmail.com writes: How can I monitor the actual DB activities during such times so I may better understand what the situation truly is. I have seen some users on this list posting some complex log/outputs, this are the kind of outputs I would like to capture and view.

Re: [GENERAL] Is there a way to backup Postgres via SQL commands?

Frank Church voi...@googlemail.com writes: Are there SQL commands that can do a backup over a client connection, rather than from the command line like pgsql etc? That's pg_dump ? By that I mean some kind of SELECT commands that can retrieve the database's content as SQL commands that can be

Re: [GENERAL] Cognitive dissonance

Dave Coventry dgcoven...@gmail.com writes: Formatted text, whether PDF, HTML or (heaven forbid!) Word Documents, is easier to read than unformatted plain text, and those of us without the OP's very admirable proficiency in vi remain at the mercy of the various readers and their associated

Re: [GENERAL] Random Weighted Result Ordering

Eliot Gable egable+pgsql-gene...@gmail.com writes: I have a set of results that I am selecting from a set of tables which I want to return in a random weighted order for each priority group returned. Each row has a priority column and a weight column. I sort by the priority column with 1

Re: [GENERAL] pgbouncer

Mario Ignacio Rodríguez Cortés ignacio.cor...@inegi.org.mx writes: Well, i have a question if you know about this, i have a webserver in a server and i have a database server, the question is: where should I install the pgbouncer? in webserver, in database server or is the same? whats your

Re: [GENERAL] libreadline and Debian 5 - not missing just badly named

J. Bagg j.b...@kent.ac.uk writes: I've just had the common problem with not finding the readline library while compiling/linking 8.4.4 on a new linux (Debian 5 - lenny). Tried: apt-get build-dep postgresql-8.4 That command will install all what you need to compile your own PostgreSQL. Some

Re: [GENERAL] INSERTing lots of data

but it seems multiprocessing is easier to use when you want to port existing threaded code. Thanks Greg! -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Documentation availability as a single page of text

Alvaro Herrera alvhe...@alvh.no-ip.org writes: There's a texinfo output that could perhaps be useful. Try make postgres.info in the doc/src/sgml directory; while it's tagged experimental and outputs a boatload of warnings, it does work for me and the text it produces is plain enough. It's

Re: [GENERAL] PostgreSQL vs. Microsoft SQL server

Merlin Moncure mmonc...@gmail.com writes: On Sat, May 1, 2010 at 2:47 PM, Thomas Løcke thomas.granv...@gmail.com wrote: Anybody know of any recent comparisons made between the two? I'm in the process of buying a new telephony related software suite, if you are writing stuff in C/C++,

Re: [GENERAL] Fuzzy string matching of product names

Leif Biberg Kristensen l...@solumslekt.org writes: On Monday 5. April 2010 22.00.41 Peter Geoghegan wrote: similar they sound. How can that actually be applied to get the functionality that I've described? I've got a similar problem in my 18th century research, when clerks usually took

Re: [GENERAL] optimizing import of large CSV file into partitioned table?

Rick Casey caseyr...@gmail.com writes: So, I am wondering if there is any to optimize this process? I have been using Postgres for several years, but have never had to partition or optimize it for files of this size until now.  Any comments or suggestions would be most welcomed from this

Re: [GENERAL] pgreplay log file replayer released

Albe Laurenz laurenz.a...@wien.gv.at writes: It seems that Tsung currently only supports basic queries, but I assume that this can be improved. In fact from the time when PostgreSQL support was added, some more Erlang drivers have appeared and some of them covers the entire protocol. So it

Re: [GENERAL] stopping processes, preventing connections

Scott Marlowe scott.marl...@gmail.com writes: It was a few posts back, but our discussion point was minor point upgrades and the fact that OP was running 8.3.1 and not sure there were updates to 8.3.9 (or latest) out there for debian. I'm quite sure debian has 8.3.9 out by now. Yes:

Re: [GENERAL] pgreplay log file replayer released

Greg Stark gsst...@mit.edu writes: Do you have a multi-threaded model that tracks which transactions each query belonged to and runs them concurrently like they were in the original setup? That's what I've been looking for. Tsung does that and has been doing it for… quite some time. It even

Re: [GENERAL] Postgres 8.4 Segfault on xpath

Frank jansen jan...@fumarium.de writes: I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib directory, tried Debians 8.4 backport package with the 8.4 contrib package and all do the same: Segfault and terminated by Signal 11 :-( Try 8.4.3, which has some XML crash

Re: [GENERAL] make available C extensions to others

Ivan Sergio Borgonovo m...@webthatworks.it writes: I've finished to write an extension to manipulate tsvectors and tsquery in C. I think it could be useful for someone else and I think I may take advantage at someone else looking at the code too. What would be the right place where to

Re: [GENERAL] accessing the words in a full text index

Massa, Harald Armin c...@ghum.de writes: I want to provide a suggest word as you type feature in an application (like google suggest).  All the documents are - of course - stored within a PostgreSQL database, within TEXT columns. See pg_trgm.

Re: [GENERAL] What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?

Wang, Mary Y mary.y.w...@boeing.com writes: Because the current value is 6818, during the restore process, it complained about duplicate key value violates unique constraint bug_pkey, because the value of bug_pk_seq for a insert has been already been used. So what is the best way to resolve

Re: [GENERAL] One solution for Packages in Postgre

venkatra...@tcs.com writes: I am new to Postgre. We are migrating an oracle db to postgre. In oracle we have used so many packages. As per my understanding, there is no oracle package like functionality in postgre. I was just trying to find some way to migrate ocale packages to postgre. This

Re: [GENERAL] Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion

Tom Lane t...@sss.pgh.pa.us writes: Peter Geoghegan peter.geoghega...@gmail.com writes: Aren't my requirements sufficiently common to justify developing a mechanism to report progress back to client applications during batch operations and the like? Have you experimented with RAISE NOTICE?

Re: [GENERAL] COPY FROM wish list

Scott Bailey arta...@comcast.net writes: PgFoundry has http://pgfoundry.org/projects/pgloader/ It is a step in the right direction but definitely not as powerful as sql*loader. Yeah, it's only offering what I needed and what I've been requested to add. So far there's support for INFORMIX

Re: [GENERAL] using new Hstore in PG8.4

Marek Lewczuk ma...@lewczuk.com writes: there are a lot of improvements in hstore, that is planned for PG8.5 - as far I remember it compiles fine with PG8.4 so is it save to use it with PG8.4 ? See hstore-new, which delivers the same code to be found in 9.0 as a module against 8.3 and 8.4.

Re: [GENERAL] Questions on PostGreSQL Authentication mechanism...

Alvaro Herrera alvhe...@commandprompt.com writes: For example, perhaps there could be a new pair of functions pg_read_hba_file/pg_write_hba_file that would work even if the files are placed in other directories, but they (Debian) would need to propose it. I don't remember they had to provide

Re: [GENERAL] more docs on extending postgres in C

Ivan Sergio Borgonovo m...@webthatworks.it writes: - installing postgresql-server-dev-[version] - apt-get source postgresql-server-dev-[version] - copy from there a contrib dir in my ~ (or wherever you prefer) - export USE_PGXS=1; make Don't forget apt-get build-dep postgresql-[version] I

Re: [GENERAL] more docs on extending postgres in C

Ivan Sergio Borgonovo m...@webthatworks.it writes: I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. Maybe this will help: http://wiki.postgresql.org/wiki/Image:Prato_2008_prefix.pdf http://github.com/dimitri/prefix

Re: [GENERAL] C: extending text search: from where to start

Ivan Sergio Borgonovo m...@webthatworks.it writes: Any other resource that will help me to write my own contrib? You could try out the following, but it deals a lot with GiST specifics… http://wiki.postgresql.org/wiki/Image:Prato_2008_prefix.pdf Regards, -- dim -- Sent via pgsql-general

Re: [GENERAL] Is there a messaging system for Postresql

Romeliz Valenciano Jr. jedi_kny...@yahoo.com writes: We're evaluating Postgresql for a possible transition from MS SqlServer. We have 100s of MS Sql servers and one way of replicating data changes is to use MQ Series Queue management system, some servers who were recently changed to Sql 2005

Re: [GENERAL] C: extending text search: from where to start

Ivan Sergio Borgonovo m...@webthatworks.it writes: I'd appreciate any pointer that will quickly put me on the right track. I'd guess you begin here: http://wiki.postgresql.org/wiki/Developer_FAQ -- dim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Avoid transaction abot if/when constraint violated

Gauthier, Dave dave.gauth...@intel.com writes: I have a long list of records I want to insert into a table in such a way as I can trap and report any/all constraint violations before rolling back (or opting to commit). Unfortunately, after I hit the first constraint violation, it aborts the

Re: [GENERAL] Pre-calculate hash join

war...@warrenandrachel.com writes: When joining two large tables [common in warehousing], a hash join is commonly selected. Calculating hash values for the merge phase is CPU intensive. Is there any way to pre-calculate value hashes to save that time? Would it even grant any performance to

Re: [GENERAL] replication from multiple master servers to a single read-only slave

Omar Mehmood omarmehm...@yahoo.com writes: I really don't want to use separate schemas for each master to logically partition the data. I ensure that the data on each master will not clash with each other (in terms of any DB level contraints such as PK), so I'd much prefer they all reside in

Re: [GENERAL] dynamic insert in plpgsql

Grzegorz Jaśkiewicz gryz...@gmail.com writes: Is there any nice way to do something like that in plpgsql: EXECUTE 'INSERT INTO '||partition_table_name||' VALUES'||(NEW.*)||''; See http://wiki.postgresql.org/wiki/PL/pgSQL_Dynamic_Triggers -- dim -- Sent via pgsql-general mailing list

Re: [GENERAL] PostgreSQL Write Performance

Greg Smith g...@2ndquadrant.com writes: If you're OK with the possibility of losing a measurement in the case of a system crash Then I'd say use synchronous_commit = off for the transactions doing that, trading durability (the 'D' of ACID) against write performances. That requires 8.3 at least,

Re: [GENERAL] PostgreSQL Write Performance

Tim Uckun timuc...@gmail.com writes: Is there a command like COPY which will insert the data but skip all triggers and optionally integrity checks. pg_bulkload does that AFAIK. http://pgbulkload.projects.postgresql.org/ Regards, -- dim -- Sent via pgsql-general mailing list

Re: [GENERAL] converting tables to XML and back

shulkae shul...@gmail.com writes: Another requirement is to convert the stored XML file back to the original tables. This helps us to clone a system. I was thinking to use Perl XML Simple module to generate XML files. What about using pg_dump and pg_restore for the cloning, or maybe a

Re: [GENERAL] Visual DATA editor for PostgreSQL?

Dmitry Koterov dmi...@koterov.ru writes: Is there a GUI utility to visually edit Postgres DATA (not a database schema!), which allows at least: - insert/update rows using screen windowed forms (possibly ugly auto-generated forms, but - still forms) - insert foreign key references by

Re: [GENERAL] pg_dump excluding tables content but not table schema

Ivan Sergio Borgonovo m...@webthatworks.it writes: It seems that you have to actually restore the 2 backup separately. pg_restore -1 -d mydb nearly_full.bak pg_restore -1 -d mydb schema_only.bak I can't think of any other way to restore both in one transaction unless I backup in plain

Re: [GENERAL] Extracting SQL from logs in a usable format

Le 21 déc. 2009 à 15:24, Chris Ernst a écrit : Ouch! You're right. And that's would be a deal killer for me. About 90% of the traffic is prepared queries that are run over and over with different parameters. The driver project and code are now there it seems: http://frihjul.net/pgsql

Re: [GENERAL] Extracting SQL from logs in a usable format

Le 19 déc. 2009 à 16:20, Chris Ernst a écrit : Hmm.. That does look very interesting. The only thing that concerns me is where it says it supports Basic Queries (Extended queries not yet supported). I'm not sure what is meant by Extended queries. Any idea? I think it refers to the Extended

Re: [GENERAL] Table Partitioning Advice Request

Vincenzo Romano vincenzo.rom...@notorand.it writes: Is there any performance study for the trigger-based implementation? Consider that if you use RULE to partition, when you DROP a partition the INSERTs are locked out because the query depends on the table being droped. That alone could lead

Re: [GENERAL] Justifying a PG over MySQL approach to a project

Gauthier, Dave dave.gauth...@intel.com writes: I am more concerned with getting a robust DB replication system up and running. Bucardo looks pretty good, but I've just started looking at the options. Any suggestions? Master Slave replication? Meaning no writes on the sister site. If yes,

Re: [GENERAL] How to remove non-UTF values from a table?

Phoenix Kiula phoenix.ki...@gmail.com writes: Is there any SQL possibility to find these columns and replace them with utf-8 equivalents using some postgresql commands? Couldn't find anything in the Strings functions (chapter 9 of manual). I've bookmarked this for later:

Re: [HACKERS] [GENERAL] Installing PL/pgSQL by default

Hi, Le 11 déc. 2009 à 01:43, Bruce Momjian a écrit : Would you be up for writing the extension facility? Uh, well, I need to help with the patch commit process at this point --- if I find I have extra time, I could do it. I will keep this in mind. If you ever find the time to do it, that

Re: [HACKERS] [GENERAL] Installing PL/pgSQL by default

Tom Lane t...@sss.pgh.pa.us writes: It's not impossible that we'll have to tweak pg_dump a bit; it's never had to deal with languages that shouldn't be dumped ... Ah, the best would be to have extensions maybe. Then you could do this in initdb, filling in template0: CREATE EXTENSION plpgsql

Re: [HACKERS] [GENERAL] Installing PL/pgSQL by default

Tom Lane t...@sss.pgh.pa.us writes: Right, just like every other thing that's pre-installed. If a particular installation wishes to let individual DB owners control this, the superuser can drop plpgsql from template1. It's not apparent to me why we need to allow non-superusers to override

Re: [HACKERS] [GENERAL] Installing PL/pgSQL by default

Tom Lane t...@sss.pgh.pa.us writes: Why not? If they really want to prohibit use of a feature the upstream project has decided should be standard, that's their privilege. Well, I guess they could also automate their database creation to fix the privileges and assign the ownership of the

Re: [GENERAL] pgsql 'prefix' error

Hi, Dimitri Fontaine dfonta...@hi-media.com writes: Can you test with this version and maybe better data set? [...] Of course changing that will discard any btree containing a prefix_range column, so that's going to be 1.1.0 if workable. http://github.com/dimitri/prefix http://github.com

Re: [GENERAL] pgsql 'prefix' error

Hi, Bino Oetomo b...@indoakses-online.com writes: ERROR: duplicate key value violates unique constraint myrecords_pkey CONTEXT: COPY myrecords, line 2: 12 I think I should add the following code comment to the documentation, if not already done: /* * We invent a prefix_range ordering for

Re: [GENERAL] pgsql 'prefix'

Hi, Le 23 nov. 2009 à 17:04, Harald Fuchs a écrit : SELECT id, record FROM myrecords WHERE record @ '127' ORDER BY length(record::text) DESC LIMIT 1; In prefix 1.0.0 you can say ORDER BY length(record) DESC directly... -- Dimitri Fontaine PostgreSQL DBA, Architecte -- Sent via pgsql

Re: [GENERAL] schema proxying virtual database

Rajesh Kumar Mallah mallah.raj...@gmail.com writes: my question is , is it a feasible idea to have some special kind of database in the postgresql cluster that mimics a schema of an existsing database. Try abusing pgbouncer to this effect. Configure several pgbouncer databases pointing to the

Re: [GENERAL] [Q] optmizing postgres for 'single client' / many small queries

Hi, Tom Lane t...@sss.pgh.pa.us writes: Just out of curiosity, does anyone know of any ORM anywhere that doesn't suck? They seem to be uniformly awful, at least in terms of their interfaces to SQL databases. If there were some we could recommend, maybe people would be less stuck with these

Re: [GENERAL] PL/Perl 64-bit and sending emails

Hi, Steve Atkins st...@blighty.com writes: On Sep 3, 2009, at 11:30 AM, Mark Lubratt wrote: Or, does someone know of another way to get the backend to send an email? Have a queue table in the database you put your emails into and an external process that polls the table, sends the email

  1   2   >