Re: [GENERAL] psql command line editor

this line: set editing-move vi and it works like a charm. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] psql command line editor

and then started psql No luck. Try reading my first sentence. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] 8.4 rpm packaging problem?

? English FAQ moved to wiki -- it is not even in 8.4.0 tarball. That's why RPM's don't ship it. Huh, but the tarball does not contain the FAQs in other languages either. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] 8.4 rpm packaging problem?

Devrim GÜNDÜZ wrote: On Sun, 2009-08-16 at 18:35 -0400, Alvaro Herrera wrote: Huh, but the tarball does not contain the FAQs in other languages either. See doc/src/FAQ directory in 8.4.0 tarball. Hmm, this is strange -- the directory is not there in CVS ... /me checks CVS history Oh, I

Re: [GENERAL] Generating random unique alphanumeric IDs

Ivan Sergio Borgonovo escribió: Sometimes ago Daniel Verite posted an implementation of a fiestel cipher in plpgsql. It's in the wiki, in the Snippets area. wiki.postgresql.org/wiki/Snippets (pseudo encrypt or something like that I think it's called) -- Alvaro Herrera

Re: [GENERAL] licensing/distribution of DLL's question

of postgres. You can do whatever suits your fancy. It is BSD-licensed. Just don't sue us and we're all set. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] totally different plan when using partitions

' and cell_bsc.nome2=2 Huh, clearly not the same query (you're using the partition directly in the first query) ... Doing two changes at once is not helping your case. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] multiple paramters in aggregate function

? http://svana.org/kleptog/pgsql/taggedtypes.html -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] totally different plan when using partitions

create the tables. Otherwise the planner might get fooled by an empty table index scan in a loop (which is what happens here), thinking that that will take time. I'm not sure I agree with your assessment of the problem. -- Alvaro Herrerahttp

Re: [GENERAL] trouble building pgbench on CentOS 5.3: /usr/bin/ld: cannot find -lpgport

like a makefile bug to me. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Does PERFORM hold a lock?

). -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] Sequence Not created with pg_dump

too? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] parameters in functions and overlap with names of columns

; and/or declare named blocks inside the function, and qualify the variables with the block name. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] character 0xe29986 of encoding UTF8 has no equivalent in LATIN2

- or to simple ignore wrong characters? Perhaps this is useful: http://wiki.postgresql.org/wiki/Strip_accents_from_strings -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] character 0xe29986 of encoding UTF8 has no equivalent in LATIN2

. Changing to a different encoding does not remove any diacritical marks, only change the underlying byte encoding. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

these? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] Problems compiling contribs in Open Solaris

, line 21: cannot find include file: libxml/xmlerror.h xpath.c, line 22: cannot find include file: libxml/parserInternals.h You need to tell configure where to find libxml's headers (--with-includes). -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL

Re: [GENERAL] Calculating the difference between timetz values

but rather 23:32:23.0001 23:32:23.00012. On the border condition that 23:59:59.9 00:00:00.0 (which is obviously ambiguous) we just avoid the question by doing the update always. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company

Re: [GENERAL] synchronous_commit=off doesn't always return immediately

to increase wal_buffers. Did you try that? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] comparing NEW and OLD (any good this way?)

that links to that page and your excellent collection. Agreed, just added one. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Copying only incremental records to another DB..

the default one. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] psql \du [PATCH] extended \du with [+] - was missing

] listar roles (usuarios)\n and it needs to read instead: msgid \\du[+] [PATTERN] list roles (users)\n msgstr \\du[+] [PATRÓN] listar roles (usuarios)\n -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent

Re: [GENERAL] psql \du [PATCH] extended \du with [+] - was missing

Tom Lane wrote: We've never before expected patch submitters to patch the .po files, and in fact I would have thought it would be useless to do so. The masters are not in our CVS. Why is Andreas being told to worry about this? I must admit I don't know :-) -- Alvaro Herrera

Re: [GENERAL] Documentation Improvement suggestions

!). Why not change the official name? Again, it would make googling and naming things easier. This is a taboo topic which has created the largest holy wars I've seen in this project. Please don't raise it. If you're interested, search the archives. -- Alvaro Herrera

Re: Help needed for reading postgres log : RE: [GENERAL] Concurrency issue under very heay loads

a debug entry saying CommitTransaction. You seem to be barking up the wrong tree here. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Autovacuum and pg_stat_reset()

with updating the unrelated stats in pg_statistic, but it also sends dead/live tuple counts to pgstats which autovacuum relies on.) Can the use of pg_stat_reset() affect performance in any way? Hmm, not sure. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] [PERFORM] Incr/Decr Integer

to wait for another one to update the counter. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Problems with 8.4, FLOAT8PASSBYVAL and x86_64 GNU/Linux

- --includedir-server) I suggest you rewrite your makefile to use PGXS. The problem might be a difference in CFLAGS. It would make the makefile a lot simpler too. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent

Re: [GENERAL] Automatic type conversion

CG wrote: I could add the explicit type casts, but I'd rather find out what the nature of the subtle (or not-so-subtle) difference I've stumbled upon is... It's an intentional change, so adding typecasts is the appropriate solution. -- Alvaro Herrerahttp

Re: [GENERAL] savepoints in 8.3.7 or whatever...

savepoints in a transaction, but you'll probably run into limits before that due to memory constraints (I think each savepoint will use at least 8kB). Anyway I suggest you do RELEASE SAVEPOINT after each insert to ensure resources are released as best as possible. -- Alvaro Herrera

Re: [GENERAL] Ascending / Descending Indexes

be used for both cases. (Unless you want some columns ascending and other columns descending, in which case you need to work extra.) -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql

Re: [GENERAL] Best practices for moving UTF8 databases

database is UTF8... So there should not be invalid data in there. I haven't followed this thread, but older PG versions had less strict checks on UTF8 data, which meant that some invalid data could creep in. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] Custom Class variables

current_setting('iss.one'); -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] uuid_hash declaration

in FreeBSD's libc. If that's the problem, my 2c is that uuid_hash is too generic a name to export and we should change ours. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Postgres 8.4 literal escaping

$$) ELSE regexp_replace($1, E'[^0-9]', '', 'g') END; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via

Re: [GENERAL] UUID datatype question

format is used for output). We convert the first * two formats into the latter format before further processing. */ -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] how drop a role that owns stuff ?

else) and DROP OWNED (drops grants and removes objects owned). Normally you run both in that order. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] BR/

if you see this: LOG: foo bar LOCATION: somewhere line N ERROR: baz qux LOCATION: another line you know what to make of it, and it's not this: LOCATION: somewhere line N ERROR: baz qux -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command

Re: [GENERAL] is autovacuum recommended?

. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] Performance problem with low correlation data

someone explain to me why, after the procedure above,correlation is so low??? Did you run ANALYZE after the procedure above? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Overhead of union versus union all

step, whereas UNION ALL does not need to uniquify its output and thus it can avoid the sort step. Using UNION ALL is recommended wherever possible. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general

Re: [GENERAL] about pg_stat_get_db_xact_commit

it starts and commit a new transaction). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] create a table inside a function

);'; EXECUTE 'ALTER TABLE sw.tmp_import OWNER TO usr_audit'; return false; END IF; Just leave out the EXECUTE and quotes. This example should work without them. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] PG 8.3.7 initdb -E LATIN1 fails on Windows

Abraham, Danny wrote: Hi, Runnning: initdb -E LATIN1 -D . Error: encoding mismatch Right. Try using Win1252 instead of Latin1: initdb -E win1252 ... Or just leave -E out entirely, since it will be picked up by default from the locale setting anyway. -- Alvaro Herrera

Re: [GENERAL] planned recovery from a certain transaction

from a base backup is going to take long for your big tables. Lastly, you could use a filesystem snapshot taken just before the long procedure, to which to revert if you don't like how it went. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication

Re: [GENERAL] WAL and master multi-slave replication

://projects.commandprompt.com/public/pitrtools Mind you, the WAL files are not stored in a database but in raw files. I have never seen anyone advocating the use of a database to store them. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication

Re: [GENERAL] WAL and master multi-slave replication

(so from Postgres' point of view it seems like it was never brought up in the first place). -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] example of aggregate function for product

and is self-contained. Other than that (and the fact that the second one is for averages not multiplication), both examples are technically identical ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql

Re: [GENERAL] How to use PQfn() in libpq library?

statement to define the function call. Then, executing the statement with binary transmission of parameters and results substitutes for a fast-path function call. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] 10 TB database

Truviso does ... -- Alvaro Herrera -- 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] Postgres auditing features

this to the FAQ http://wiki.postgresql.org/wiki/FAQ#Is_there_a_way_to_leave_an_audit_trail_of_database_operations.3F ... he says, hoping that it'll help generate interest in getting the FAQ updated ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company

Re: [GENERAL] type cast in index

' specification, which will cause it to be turned into a plain timestamp (without tz). -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] aliases for sequences and other DB objects?

for my_sequence; select nextval('my_sequence_alias'); No. What would this be used for? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] lc_messages 8.3.7

) -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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 can I manually alter the statistics for a column?

(If this is 8.3 you have to consider sync_seqscan as well) -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] pg_dump table space

the SET. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] I can't drop a user if I don't drop his grants beforehand??????????????????

Nico Sabbi wrote: Alvaro Herrera ha scritto: I'm not speaking of object ownership, but of GRANTs. As Tom says, it's a known limitation. Did you try REASSIGN OWNED and/or DROP OWNED? No, I didn't because the tables weren't owned by the user I wanted to drop, but by another one. DROP

Re: [GENERAL] Bloated Table

the big problem is that it relies on pg_class.relpages and reltuples which are only accurate just after VACUUM, only a sample-based estimate just after ANALYZE, and wrong at any other time (assuming the table has any movement). -- Alvaro Herrerahttp

Re: [GENERAL] Bloated Table

every minute ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Need beginning and ending date value for a particular week in the year

something similar in the Wiki: http://wiki.postgresql.org/wiki/Date_and_Time_dimensions -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] 8.3: timestamp subtraction

Havasvölgyi Ottó escribió: I mean the Win32 distribution on the PgSql site. I always used that. If you want to find out whether a particular build used floating point or integer datetimes, issue SHOW integer_datetimes. If it says off, then it's floating point. -- Alvaro Herrera

Re: [GENERAL] I can't drop a user if I don't drop his grants beforehand??????????????????

and/or DROP OWNED? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] Aggregate Function to return most common value for a column

to http://wiki.postgresql.org/wiki/Snippets , that would be great. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] array/function question

Joshua Berry escribió: Please forgive the lack of grace. I'd love tips on how to improve this! Tip: follow Pavel's suggestion. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via

Re: [GENERAL] array/function question

... -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 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] pg_dump and 2gb limit on windows and version 8.1.3

or newer with the server (8.1.3). Yes -- pg_dump is backwards compatible; it will be able to dump the database just fine. Note, however, that the dump is not guaranteed to be restorable in the 8.1 server. I think you should upgrade to 8.1.17 which likely contains the fix as well. -- Alvaro

Re: [GENERAL] array/function question

,f,f,t,f} (1 fila) -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Commit visibility guarantees

committed), a new query always gets a fresh one. (Old snapshots are also used for stuff like cursors that remain open, but that's not the case here.) -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER

Philipp Marek wrote: On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote: we're using postgresql 8.3 for some logging framework. There are several tables for each day (which are inherited from a common base), which - are filled during the day, - after midnight the indizes

Re: [GENERAL] Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER

at pg_stat_activity. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] Could not open file pg_clog/....

and analyze calls, but never finished it. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Could not open file pg_clog/....

Alvaro Herrera wrote: Markus Wollny wrote: magazine=# vacuum analyze pcaction.article; PANIC: corrupted item pointer: 5 server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request

Re: [GENERAL] Btree indizes, FILLFACTOR, vacuum_freeze_min_age and CLUSTER

the CLUSTER call, hoping that this would solve our transaction ID wraparound problem. REINDEX? What are you doing REINDEX for? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list

Re: [GENERAL] limit-offset different result sets with same query

BY clause that actually specifies the order well enough :) Yeah, we went over this on the spanish list, turned out that I couldn't remember about syncscan :-) -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql

Re: [GENERAL] Power outage and funny chars in the logs

be fsync'ed. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] PgUS 501c3 Public Charity

Dave Page wrote: On Thu, May 7, 2009 at 3:04 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Joshua D. Drake wrote: Hello, Yeah its not general technical discussion but this little bit of news warrants more widely read attention. PgUS (http://www.postgresql.us/) received its

Re: [GENERAL] PgUS 501c3 Public Charity

like Pg is unlikely to fly very far.) I'll ask PgUS later to fund my possible flight to Cuba for a Pg summer school. Oh wait a minute ... Hey, but I forgot -- congratulations on the 501(c)3 status! -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] how to select temp table

schema (or wherever you have created the function): select * from testtable;-- refers to temp set search_path to 'public', 'pg_temp'; select * from testtable;-- refers to non-temp -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company

Re: [GENERAL] PgUS 501c3 Public Charity

/determination_letter Just curious: is PostgreSQL as a project withdrawing from SPI? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] recover corrupt DB?

in the vicinity? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Tracking down a deadlock

WHERE as the UPDATE as the first thing in your transaction. That way it is much less likely to deadlock with itself. (This assumes that the set of tuples to update doesn't change, which holds true everytime if your transaction has isolation level serializable). -- Alvaro Herrera

Re: [GENERAL] triggers and execute...

could try is getting the column names and types from the catalogs to build the insert statement. That way you don't have to list each column separately, and you don't need to fiddle with whether each value needs quotes or not. -- Alvaro Herrerahttp

Re: [GENERAL] SPI_ERROR_TRANSACTION [PostgreSQL 8.3]

be reached. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] Restore Crashes Postgres

. I think you really need to solve this crash; it should normally never happen. (Postgres can be configured so that the log ends up in the Windows event log, by setting log_destination=eventlog in postgresql.conf. If you haven't set that up, it's probably ending up in a file somewhere). -- Alvaro

Re: [GENERAL] find column OID types with information schema?

for attributes can be found in pg_attribute.atttypid. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] status of pl/php

better. It is still considered beta, but I think it's reasonably stable. Some things need to be reworked, such as handling of arrays. Otherwise it should work. Most of the problems with it seem to come from having to compile PHP than PL/php specific. -- Alvaro Herrera

Re: [GENERAL] PostgreSQL Object-Oriented Database?

. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- 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] need help for PostgreSQL consistency check mechanism

Chen, Dongdong (GE Healthcare) escribió: When the OS starts up, it wants to detect whether there is data loss in PostgreSQL from last shutdown, is there a method provided? Why would the OS want to do that? -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] need help for PostgreSQL consistency check mechanism

it when an exception was raised. It was a very effective way to detect corrupted toast entries, which is the most visible way in which data is corrupted. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] Can't use any with SQL functions

BTW is there a reason the error messages say plpgsql functions cannot ... instead of PL/pgSQL functions cannot ...? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general

Re: [GENERAL] delete duplicates takes too long

, fecha_llamada, duracion) where processed = 2; -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] pg_lsclusters error after pg_dropcluster

} in getpwuid at /usr/bin/pg_lsclusters line 28 Please report to Debian -- they are the ones that write these programs. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list

Re: [GENERAL] need help for PostgreSQL consistency check mechanism

. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 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] From 8.1 to 8.3

, we're too lazy to summarise them for you ... (Luckily for everybody, Bruce and Tom were NOT lazy enough to write them in the first place.) The meat of what you need to know is in the 8.2.0 and 8.3.0 notes, the incompatibilities section anyhow. -- Alvaro Herrerahttp

Re: [GENERAL] trouble with to_char('L')

Mikko escribió: On Wed, Apr 22, 2009 at 2:13 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Ouch ... I thought that was the way that Windows designated UTF8 locales, but maybe I am wrong. Ok, now I found out that Windows doesn't support locales with encoding using more than two

Re: [GENERAL] This is my first template

there in ISO meetings. My guess is that you're doing date arithmetic wrong somewhere. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] trouble with to_char('L')

. Does it work if you set lc_numeric and lc_monetary to Finnish_Finland.65001 instead? Those should match the server_encoding. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql

Re: [GENERAL] Yet another drop table vs delete question

background work. Try TRUNCATE. That leaves the less garbage behind and takes the less time. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

for manipulation then export to MonetDB? That's the April 1st news though ... the real news is here http://wiki.openstreetmap.org/wiki/OSM_Protocol_Version_0.6#Database_improvements -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting

Re: [GENERAL] trouble with to_char('L')

Mikko escribió: On Tue, Apr 21, 2009 at 8:13 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Maybe the problem here is that the chosen locales are not UTF8.  Does it work if you set lc_numeric and lc_monetary to Finnish_Finland.65001 instead?  Those should match the server_encoding

<    2   3   4   5   6   7   8   9   10   11   >