Re: [GENERAL] Pulling data from a constraint def

Excerpts from Tom Lane's message of vie may 14 00:32:12 -0400 2010: Josh Kupershmidt schmi...@gmail.com writes: On Thu, May 13, 2010 at 8:08 PM, Tom Lane t...@sss.pgh.pa.us wrote: Well, the inability to change the list of values is certainly an unpleasant limitation, but is it so fatal that

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

Excerpts from John Gage's message of sáb may 08 05:06:35 -0400 2010: Is the documentation available anywhere as a single page text file? This would be enormously helpful for searching using regular expressions in Vim, for example, or excerpting pieces for future reference. There's a

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

Excerpts from Alvaro Herrera's message of lun may 10 12:01:22 -0400 2010: 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

Re: [GENERAL] PostgreSQL 9.0 - support for RANGE value PRECEDING window functions

Excerpts from Daniel Scott's message of lun may 10 13:20:06 -0400 2010: Says The value PRECEDING and value FOLLOWING cases are currently only allowed in ROWS mode. However, I have found this post:

Re: [GENERAL] pre-existing shared memory block is still in use after crashes

Excerpts from Dave Vitek's message of jue may 06 10:44:34 -0400 2010: Hi all, Yesterday I ran into two backend crashes and then an autovacuum launcher process crash. The autovacuum log was: LOG: database system is ready to accept connections LOG: autovacuum launcher process (PID 3788)

Re: [GENERAL] pg_class has 3615 rows and 1010Mb in table size

Excerpts from Joshua D. Drake's message of mié may 05 15:37:05 -0400 2010: On Wed, 2010-05-05 at 09:40 -0700, Nikola wrote: I looked at the pg_class table and noticed that its size is 1010Mb and index size is 1137Mb, while the table itself has only 3615 rows in it. I tried vacuuming it,

Re: [GENERAL] GeSHi module for Postgresql?

externally, i.e. not system internal functions. A developer writing plpgsql is certainly a user. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] (psuedo) random serial for PK or at least UNIQUE NOT NULL?

? http://wiki.postgresql.org/wiki/Pseudo_encrypt -- 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] Please help me debug regular segfaults on 8.3.10

the debuginfo package(s). Have you got some external module installed? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] GeSHi module for Postgresql?

pg_get_keywords(); -- 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] Inheritance efficiency

partition by month schemes) are not necessarily the most complex setups out there. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

that? pg_restore is supposed to restore the schema, then data, finally indexes and other stuff. Are you using separate schema/data dumps? If so, don't do that -- it's known to be slower. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command

Re: [GENERAL] Inheritance efficiency

). -- 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] Storing many big files in database- should I do it?

attributes in a table. I've never seen this to be a problem in real life, but if you're talking about having that many large objects, then it will be a problem with toast too. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom

Re: [GENERAL] Start-up script for few clusters: just add water?

? Certainly not. You could add a loop that sets the variables and calls the start code, but it's new code you'd add, not just those lines above. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql

Re: [GENERAL] Postgres stats collector showing high disk I/O

that it can't reset? I'm guessing I should just try to delete the file outright? Err, yeah, pg_stat_reset only resets the stats for the current database. You need to reset for all databases, or alternatively, shut down the server, remove the file, and restart -- Alvaro Herrera

Re: [GENERAL] how to debug the codes in the PostgresMain() from the begining of this function to the for (;;) loop that handles the connection?

() to the for (;;) loop could not be debugged. So anybody know how to debug this part codes? thanks. Try using the -W option to postmaster. That makes the newly forked process sleep for a while, giving you time to attach a debugger to it. -- Alvaro Herrerahttp

Re: [GENERAL] I/O error during autovacuum

, so the problem is certainly not in PostgreSQL. -- 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] Avoiding surrogate keys

bytes to store the 2 chars (4 bytes of overhead), so it would be larger than the int. Not that this invalidates the argument -- just nitpicking here. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql

Re: [GENERAL] Performance impact of hundreds of partitions

exclusion parts. I have a couple of tables split into 100 partitions, and they work extremely well. Keep in mind that 100 is only 8 dozen ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general

Re: [GENERAL] Virtual table with pl/perl?

compliant (no rollbacks). Did you see DBI-Link in pgfoundry.org? -- 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] Database corruption with duplicate tables.

George Woodring wrote: I have found that I have a database problem after receiving the following error from pg_dump: Lack of vacuuming, most likely. What version is this? Did you read previous threads about this problem on the archives? -- Alvaro Herrerahttp

Re: [GENERAL] When is an explicit cast necessary?

how and when. -- 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] solaris tarballs and pl/java

Ozz Nixon escribió: Would this syntax work in PostgreSQL? |INSERT INTO MyTable (FirstCol, SecondCol) VALUES ('First',1), || ('||Second||',2),| | ('||Third||',3),| | ('||Fourth||',4),| | ('||Fifth||',5)|| Yes, it works (without all those funny || though) -- Alvaro Herrera

Re: [GENERAL] solaris tarballs and pl/java

that to compile, it's likely to fall over at run time. Why not just build the complete tree? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] auto vacuum

cron or something. -- 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] auto vacuum

) Alvaro and Bill both suggested scheduling analyzes on a minute-by-minute cron. Would this be no different than automatic analyze? No extra overhead for connection, perhaps? No difference. Autovacuum also uses a connection; the only difference is that it does it internally. -- Alvaro Herrera

Re: [GENERAL] Removing files under pg_clog

large? -- 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] Removing files under pg_clog

later. If they ever see their system crash, it won't be able to recover due to pg_xlog deletion. (Note that pg_xlog is quite different from pg_clog). pg_clog deletion guarantees that they will have problem vacuuming or something. -- Alvaro Herrerahttp://www.advogato.org

Re: [GENERAL] simultaneously reducing both memory usage and runtime for a query

to the ... mailing list need to be under x lines Our mailing lists are set up with a spam filter that's very happy to drop stuff on the floor without warning at first suspicion. It's not an easy thing to fix for reasons that are outside the scope of this mailing list. -- Alvaro Herrera

Re: [GENERAL] Order of Daily VACUUM, CLUSTER, REINDEX

it would be: CLUSTER; ANALYZE; (no vacuum analyze, just analyze). Note that cluster only clusters tables that have been previously clustered. So you still need to vacuum tables that are not clustered. -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] Daylight savings time confusion

timezone as a separate column, if that information is of any value. -- 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] Postgres 8.4 Segfault on xpath

more fully what you're doing here? (hopefully with schema details, sample data and queries) Perhaps there's a memory leak that needs to be plugged. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] unexplained autovacuum to prevent wraparound

the other reloptions. This is a problem particularly for autovacuum reloptions. Itagaki Takahiro -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] REVOKE ... FROM everybody?

given to public is revoked. Grants to other roles are kept. To revoke all grants, you need to list them individually IIRC. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] ERROR: invalid byte sequence for encoding UTF8: 0x93 Error

probably insert the data by declaring SET client_encoding TO 'win1252' at the start of the file. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] unexplained autovacuum to prevent wraparound

the freeze age. You need to set it (and all other values) to -1 instead. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] How to? Timestamp with timezone.

Andre Lopes escribió: Hi, Thanks for the reply's. [code] ALTER DATABASE foo SET timezone TO 'someval' ALTER ROLE bar SET timezone TO 'someval' [/code] I need to alter only the Timezone of the database OR I need also to alter the Role? One of them suffices. -- Alvaro Herrera

Re: [GENERAL] Not all functions in schema pg_catalog are visible

with pg_catalog. I think it's not that they are visible but rather that their names are keywords. So you could also call them by quoting them, e.g. time(timestamp). IIRC there's a view listing all keywords you can use to figure this out. -- Alvaro Herrerahttp

Re: [GENERAL] How to? Timestamp with timezone.

Andre Lopes escribió: It is possible to do this in a shared database server? You can also do ALTER DATABASE foo SET timezone TO 'someval' ALTER ROLE bar SET timezone TO 'someval' -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command

Re: [GENERAL] ERROR: value out of range: underflow

time, sounds fishy. -- 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] pg_buffercache's usage count

it needs. BTW the only reason you don't see buffers having a larger usage is that the counters are capped at that value. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column

of this usage. (Using the SET command, or ALTER ROLE, or ALTER DATABASE). See here http://www.postgresql.org/docs/8.4/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication

Re: [GENERAL] SET Role doesn't work from Security Definer Function...

the error. Shouldn't it be the other way around? The normal function calls the security-definer one. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Sorting performance vs. MySQL

is the table, and have you vacuumed it? Did you analyze it? What Pg version is this? -- 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] Sorting performance vs. MySQL

metarelcloud_transactionlog order by transactionid; You're reading the whole table. This is unlikely to fly very far. I suggest you try some query that's actually going to be used in the real world. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company

Re: [GENERAL] Doubts about oid

CURRENT OF the cursor Another scenario is when we want to delete duplicate records in a table. You can use the ctid system column for this. This column represents the physical position of the row in the table, so it changes in many situations, for example during an UPDATE. -- Alvaro Herrera

Re: [GENERAL] Setting a table to be ignored by autovacuum

Chris Barnes escribió: Right you are, I'm due to upgrade end of month on this system. Here I was thinking 8.4. Sorry for the spam. You can INSERT INTO pg_autovacuum VALUES ('schema.table'::regclass, false, -1, -1, ...); in previous versions. -- Alvaro Herrera

Re: [GENERAL] Persistent identifiers for Postgres users

don't have any way to know that one of them is dropped. -- 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] Postgres physical directory structure meaning

system catalogs. Not terribly critical, but you need to do quite some work in order to make the system work again without them. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql

Re: [GENERAL] relacl parsing method?

Josip Rodin wrote: Hi, I want to find out whether a user has a select privilege on a particular database. You're probably better off using the has_foo_privilege family of functions, e.g., has_table_privilege(). -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] Check what a transaction did in the past

, everything there is to know, except the queries it did in the past. Is there any way to check this? Turn on log_statements and check the log. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent

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

thingies of all kinds. The amount of effort is not insignificant, which is probably why nothing has gotten done yet ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Set the permissions while creating database, schema, and tables

dipti shah escribió: That's I know but I was wondering if there is anyway to do it while creating itself. No. You can wrap the CREATE and the GRANT/REVOKE into a transaction so that the object doesn't appear to users until permissions have been fixed. -- Alvaro Herrera

Re: [GENERAL] Truncate and delete adds wal logs for slave to process.

the fact that a truncate happened. In order to be able to roll it back, the underlying file is kept around until transaction commit. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql

Re: [GENERAL] SSL connection lost after long-lasting copy command

-02-09 10:47:17 CST LOG: unexpected EOF on client connection ---cut here---end Try the advice here: http://archives.postgresql.org/message-id/41ee6009-a3e0-4c3a-8a83-bb39d934b...@mac.com -- Alvaro Herrerahttp

Re: [GENERAL] SSL connection lost after long-lasting copy command

into the table, after psql re-established connection with the server. Reading through the thread Alvaro suggested, I cannot see what could be done about this. Any clarification would be appreciated. Err, remove the renegotiation code from the server. -- Alvaro Herrera

Re: [GENERAL] SSL connection lost after long-lasting copy command

Seb escribió: On Tue, 9 Feb 2010 14:44:23 -0300, Alvaro Herrera alvhe...@commandprompt.com wrote: [...] Err, remove the renegotiation code from the server. Oh I meant something from a user's point of view, not hacking the source code. If there's not a user option, I don't mind

Re: [GENERAL] Multiple buffer cache?

a buffer. Such a buffer would have its usage count typically higher than a buffer only used for regular queries. To make this work we'd probably need a slightly larger value of BM_MAX_USAGE_COUNT, I think. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] weird bug in rebuilding RPMs

configure options. We # append postgresql to some of them, if the string does not already # contain pgsql or postgres, in order to avoid directory clutter. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql

Re: [GENERAL] Performance Tuning - Any easy things that I can do ?

Gauthier, Dave escribió: analyze? Does the empirical data the optimizer use develop good queries get updated with/after a restore? Not automatically, you have to invoke it manually. (In recent releases, autovacuum would do it, but 7.1 didn't have it). -- Alvaro Herrera

Re: [GENERAL] Why lots of temp schemas are being created

to tell the database to clean them up itself? It does, unless one of them gets a very high backend ID that's not reused. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general

Re: [GENERAL] Why lots of temp schemas are being created

. -- 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] Questions on PostGreSQL Authentication mechanism...

/etc/postgresql/8.4/main/pg_hba.conf; Probably pg_read_file(): select pg_read_file('pg_hba.conf', 0, 8192); Note that pg_read_file only allows paths relative to $PGDATA, which is what you get from SHOW data_directory; -- Alvaro Herrerahttp://www.CommandPrompt.com

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

Tim Bruce - Postgres escribió: On Tue, February 2, 2010 08:23, Alvaro Herrera wrote: Probably pg_read_file(): select pg_read_file('pg_hba.conf', 0, 8192); Note that pg_read_file only allows paths relative to $PGDATA, which is what you get from SHOW data_directory; Since

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

Joshua D. Drake escribió: On Tue, 2010-02-02 at 16:09 -0300, Alvaro Herrera wrote: Tim Bruce - Postgres escribió: On Tue, February 2, 2010 08:23, Alvaro Herrera wrote: Probably pg_read_file(): select pg_read_file('pg_hba.conf', 0, 8192); Note that pg_read_file only

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

this: SHOW hba_file; -- 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] Log full of: statement_timeout out of the valid range.

anywhere. It could be once per connection or once per query, if Danny is using some middle layer that injects a SET statement_timeout TO nnn for every query. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql

Re: [GENERAL] \dt+ sizes don't include TOAST data

. It would be a bit slower, but the normal case of using the same server version would be fast. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Rows missing from table despite FK constraint

to be using the foo.4 file. -- 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] WAL archiving is stuck on an old file that was deleted -- how to get it going again? (8.4.2)

by creating a dummy file with that name in pg_xlog, but keep in mind that the archive is now completely useless and unrecoverable. Sorry. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing

Re: [GENERAL] Looking for advice on working with revisions

that instead of adding stored procedures as you suggest, add a new relation that sits between releases_rev and releases_lang (say release_msg). Then you don't translate a revision -- you translate a message, to which many revisions can be pointing. -- Alvaro Herrerahttp

Re: [GENERAL] access computed field of RECORD variable

this with plpgsql. There are some limited possibilities with EXECUTE 'foo bar $1 baz' USING rec where the $1 is expanded with the record. However the best thing you can do is use a different PL, probably PL/Perl. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] Save MySQL? HA

to MySQL, not your program, so your program is protected from GPL's viral nature. -- 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] Innotop for postgresl

people use Munin and Zabbix successfully. You can probably find scripts/modules by searching around. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] cross-database time extract?

as an identifier. When you write time (no quotes) you are invoking the reserved keyword. The double quotes strip the reservedness and it's treated like an ordinary keyword. When you write pg_catalog.time this is parsed as an identifier too because keywords cannot be schema-qualified. -- Alvaro

Re: [GENERAL] pg_dump ERROR, usename postgres duplicated

Gastón Quiroga wrote: Thank You Tom: I'll Try to make an update, but the 2 fields are equals row by row, how could I make a difference in the WHERE statement? Use the ctid hidden system field. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] memory usage of group by select

enable_hashagg = off. If that works, good -- the real solution is different. Maybe you need to ANALYZE more, or increase the size of the stats bin for this column. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc

Re: [GENERAL] Why grantor is owner in this case?

easily? Maybe he's referring to this discussion: http://archives.postgresql.org/message-id/1176775180.4152.97.camel%40dogma.v10.wvs Note that on archives.pg.org it is truncated and continues here: http://archives.postgresql.org/message-id/20070503225044.gk4...@alvh.no-ip.org -- Alvaro Herrera

Re: [GENERAL] PL/Perl Performance Problems

tables don't grow as at night a cleanup job removes about the same amount of historical data (older about 40 days). Its kind of the same behavior and i don't really see where the swapping fits in. Are you running vacuum of some sort on this table regularly? -- Alvaro Herrera

Re: [GENERAL] getaddrinfo.c error

know they do for me when I cvs-update and configure itself has changed. -- 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] Dependency tracking tool

this object depends Greg Stark published an example query here http://www.pgcon.org/2009/schedule/events/181.en.html -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general

Re: [GENERAL] PIVOT tables and crosstab

Pavel Stehule escribió: 2009/12/11 Alvaro Herrera alvhe...@commandprompt.com: I think the standard spelling of this feature is GROUPING SETS along with syntactical sugar CUBE and ROLLUP.  There was a patch for this posted some time ago but it doesn't look like it has moved forward lately

Re: [GENERAL] PIVOT tables and crosstab

with syntactical sugar CUBE and ROLLUP. There was a patch for this posted some time ago but it doesn't look like it has moved forward lately. Barring GROUPING SETS, it is very unlikely that crosstab or pivot are going to make it into the core. -- Alvaro Herrera

Re: [GENERAL] Installing PL/pgSQL by default

is had with schema public... It seems to me that the solution to both problems is to be able to run some script after database creation to fix permissions of such things. This was proposed eons ago by Fabien Coelho IIRC but rejected because no way to implement it was found. -- Alvaro Herrera

Re: [GENERAL] pg_attribute.attnum - wrong column ordinal?

like: row_number() over (partition by T.schemaname,T.viewname order by attnum) as ORDINAL_POSITION Should we recast the attributes and columns views in information_schema? I notice they still use attnum. -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [Bacula-users] [GENERAL] Catastrophic changes to PostgreSQL 8.4

not using ru_RU.UTF-8, cn_CN.UTF-8, etc as their locales. Why mix charsets? On my own desktop computer, I switched from Latin1 to UTF8 some two years ago, and I still have a mixture of file name encodings. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] Books

could donate money through SPI. -- 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

Re: [GENERAL] How to get RTREE performance from GIST index?

in the creating process' private memory area. -- 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] What is the correct way to extract values from an int8 array in SPI?

Boszormenyi Zoltan wrote: Hi, I am using this code on 8.4/8.5, which works on 64-bit, but segfaults on 32-bit Linux: I'm not sure but perhaps this patch could help you. It may be a bit outdated. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL

Re: [GENERAL] Cache lookup error

in http://www.postgresql.org/docs/8.3/static/catalogs.html I was thinking it was a reference inside a function or similar. I'm guessing compiled plpgsql is opaque? That doesn't persist across a restart, though. -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] [pgeu-general] pgday.eu

Devrim GÜNDÜZ escribió: On Thu, 2009-11-12 at 08:41 +, Dave Page wrote: (whose idea was it to have Cognac after beer, red wine and scotch anyway?) **Perfect** idea -- but it was not me ;) Maybe JD? -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] PostgreSQL 8.3.8 on AIX5.3 : compilation failed

. Actually it's in the 8.3 CVS branch too. A 8.3 snapshot should work fine. -- 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] What to install to be able to build docs on Arch Linux?

Peter Eisentraut wrote: On mån, 2009-11-09 at 19:49 -0300, Alvaro Herrera wrote: hubert depesz lubaczewski wrote: = pacman -Ql docbook-sgml docbook-sgml /usr/ docbook-sgml /usr/share/ docbook-sgml /usr/share/sgml/ docbook-sgml /usr/share/sgml/docbook-sgml-4.2/ docbook-sgml

Re: [HACKERS] [GENERAL] PostgreSQL 8.3.8 on AIX5.3 : compilation failed

Tom Lane wrote: In most of the other cases the #include is done in an associated .y file, but there is none in psql. Anyone have a thought which of psql's .c files would be the most appropriate host? mainloop.c? -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] What to install to be able to build docs on Arch Linux?

/catalog You probably need DOCBOOKSTYLE=/usr/share/sgml/docbook-sgml-4.2 ./configure [ other options ] -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] [pgsql-es-ayuda] Ayuda con NOTIFY en C

PostgreSQL para hacer esto?? Ya hay varios sistemas de replicación implementados, ¿los estudiaste antes de intentar implementar uno tú mismo? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: [GENERAL] Search system catalog for mystery type

mdx_core.audit_impt RENAME TO __audit_impt; Or any other char for that matter -- you picked the only one that would cause a problem. Even a space should be fine: ALTER TABLE mdx_core.audit_impt RENAME TO audit_impt; (Not sure I can recommend this though) -- Alvaro Herrera

Re: [GENERAL] Why are there pg_dump errors in my Apache httpd error_log ? (Postgres 8.3.7 on CentOS 5)

Aleksey Tsalolikhin escribió: Hi. I just found pg_dump errors in my Apache httpd log and am really confused. Has anybody seen this before? Somebody may have tried to abuse some PHP script or similar? -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [GENERAL] Absolute value of intervals

. Not the first time this happens, see http://www.amazon.com/Batman-Long-Halloween-Jeph-Loeb/dp/1563894696 -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

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