Search Discussions

55 discussions - 493 posts

  • Is it an expected behavior? postgres=# CREATE TABLE t1 (a int, b int); CREATE TABLE postgres=# CREATE TABLE t2 (b int, c int); CREATE TABLE postgres=# CREATE TABLE t3 (d int) inherits (t1, t2); ...
    KaiGai KoheiKaiGai Kohei
    Nov 4, 2009 at 6:36 am
    Feb 2, 2010 at 11:41 pm
  • We had a discussion back in July about our maintenance policy and the upshot of that discussion was that there were relatively few objections to dropping support for 7.4 - I believe Andrew Dunstan ...
    Robert HaasRobert Haas
    Nov 3, 2009 at 2:01 pm
    Nov 4, 2009 at 2:36 am
  • I'm planning to work on typed tables support. The idea is that you create a table out of a composite type (as opposed to the other way around, which is currently done automatically). CREATE TYPE ...
    Peter EisentrautPeter Eisentraut
    Nov 5, 2009 at 5:25 pm
    Jan 12, 2010 at 5:59 pm
  • This brings up a concern I have --- that the number of patch committers/managers is decreasing while our patch volume is increasing. Consider that Heikki is working mostly on Hot Standby and ...
    Bruce MomjianBruce Momjian
    Nov 11, 2009 at 5:06 am
    Nov 12, 2009 at 11:05 am
  • The next CommitFest is scheduled to start in a week. So far, it doesn't look too bad, though a lot could change between now and then. I would personally prefer not to be involved in the management of ...
    Robert HaasRobert Haas
    Nov 9, 2009 at 1:52 am
    Nov 12, 2009 at 11:55 am
  • Hi, Attached is a patch for a new listen/notify implementation. In a few words, the patch reimplements listen/notify as an slru-based queue which works similar to the sinval structure. Essentially it ...
    Joachim WielandJoachim Wieland
    Nov 11, 2009 at 9:31 pm
    Nov 12, 2009 at 1:25 pm
  • I believe we had consensus that plpgsql should offer the following three behaviors when a name in a SQL query could refer to either a plpgsql variable or a column from a table of the query: * prefer ...
    Tom LaneTom Lane
    Nov 6, 2009 at 8:21 pm
    Nov 9, 2009 at 4:00 pm
  • A customer of ours recently hit a problem where after an autovacuum was cancelled on a table, the app started getting the message in $subject: ERROR: could not read block 6 of relation ...
    Alvaro HerreraAlvaro Herrera
    Nov 4, 2009 at 6:34 pm
    Nov 10, 2009 at 7:27 pm
  • I'm not sure if it can be finished until the start of the next CF, but I've been working on $subject. This work intends to extend current limited frame types of window functions such like below; - ...
    Hitoshi HaradaHitoshi Harada
    Nov 9, 2009 at 9:40 am
    Nov 9, 2009 at 6:06 pm
  • I think I just ran smack dab into this bug on 8.3.8 (RPM: postgresql-8.3.8-1.fc10.i386). I had a query that wasn't coming out very well with the default settings so I raised the collapse limits and ...
    Robert HaasRobert Haas
    Nov 9, 2009 at 3:18 pm
    Nov 9, 2009 at 6:43 pm
  • I've been trying to make pl/perl support 8.5's inline functions, with the attached patch. The basics seem to be there, with at least one notable exception, namely that plperl functions can do stuff ...
    Joshua TolleyJoshua Tolley
    Nov 5, 2009 at 10:37 pm
    Nov 9, 2009 at 4:08 pm
  • I just run across an issue with ALTER TABLE and inheritance (i don't know wether this is of the same kind of issue KaiGai reported today, so i keep it on a separate thread). Consider the following ...
    Bernd HelmleBernd Helmle
    Nov 4, 2009 at 2:40 pm
    Sep 14, 2010 at 10:49 pm
  • Hi, While working on writeable CTEs, I noticed I have to special-case the output of a Query node frequently because in INSERT/UPDATE/DELETE query targetList is the target list which is used for ...
    Marko TiikkajaMarko Tiikkaja
    Nov 10, 2009 at 10:30 am
    Nov 10, 2009 at 4:20 pm
  • According to http://developer.postgresql.org/pgdocs/postgres/plpgsql-declarations.html#PLPGSQL-DECLARATION-RENAMING-VARS the RENAME declaration in plpgsql has been known broken since PG 7.3. Nobody ...
    Tom LaneTom Lane
    Nov 5, 2009 at 1:34 am
    Nov 5, 2009 at 4:22 pm
  • Hi, Recently, the development of SR is not progressing because of the indecision on whether walreceiver should be a subprocess of the startup process (i.e., a stand-alone program), or of postmaster. ...
    Fujii MasaoFujii Masao
    Nov 2, 2009 at 10:26 am
    Nov 5, 2009 at 12:23 am
  • Hi, Should the standby also have to follow the WAL rule during recovery? The current patch doesn't care about the write order of the data page and WAL in the standby. So, after both servers fail, ...
    Fujii MasaoFujii Masao
    Nov 12, 2009 at 2:31 am
    Nov 12, 2009 at 12:56 pm
  • So I was testing the next step of plpgsql modification, namely actually letting the parser hooks do something, and it promptly blew up in trigger functions, like so: + ERROR: OLD used in query that ...
    Tom LaneTom Lane
    Nov 5, 2009 at 9:33 pm
    Nov 8, 2009 at 5:33 pm
  • Attached is the latest and greatest patch against CVS head, taken from the hs-riggs branch in my git repository. These two TODO items I listed earlier have now been fixed: ...
    Heikki LinnakangasHeikki Linnakangas
    Nov 10, 2009 at 6:37 pm
    Nov 11, 2009 at 1:30 pm
  • Hi, When a crash occurs before calling pg_stop_backup(), the subsequent crash recovery causes the FATAL error and outputs the following HINT message. If you are not restoring from a backup, try ...
    Fujii MasaoFujii Masao
    Nov 2, 2009 at 6:52 am
    Nov 4, 2009 at 1:58 am
  • One of the interesting properties of Oracle-compatible variable references in plpgsql is that the set of variables referenced by a given query could change during a forced replan. For example, ...
    Tom LaneTom Lane
    Nov 2, 2009 at 4:31 pm
    Nov 2, 2009 at 8:40 pm
  • Hi, While playing around/evaluating tsearch I notices that to_tsvector is obscenely slow for some files. After some profiling I found that this is due using a seperate TSParser in ...
    Andres FreundAndres Freund
    Nov 1, 2009 at 3:20 pm
    Dec 10, 2009 at 11:10 pm
  • Here is a patch to support arrays in PL/Python as parameters and return values. It converts an array parameter to a Python "list", and converts a Python "sequence" return value back to an array. I ...
    Peter EisentrautPeter Eisentraut
    Nov 4, 2009 at 2:02 pm
    Dec 10, 2009 at 8:45 pm
  • I CC: this to the hackers list as it seems to be an old problem that was never fixed. See at the bottom. Alexandra Roy wrote: I forgot to answer your question concerning the benefits of a 64-bit ...
    Albe LaurenzAlbe Laurenz
    Nov 10, 2009 at 11:26 am
    Nov 11, 2009 at 11:16 am
  • Quoth the comments in nodeAgg.c: * We don't currently implement DISTINCT aggs for aggs having more * than one argument. This isn't required for anything in the SQL * spec, but really it ought to be ...
    Andrew GierthAndrew Gierth
    Nov 12, 2009 at 1:28 am
    Nov 12, 2009 at 5:23 am
  • Hi all, I have extracted the partitioning option for COPY (removed the error logging part) from the previous patch. The documentation and test suite sample are provided as well. More details are on ...
    Emmanuel CecchetEmmanuel Cecchet
    Nov 11, 2009 at 3:51 pm
    Nov 12, 2009 at 1:19 am
  • Hi there, I downloaded the latest postgresql code via cvs on a FreeBSD 7.2 system. When I try to run autoconf on the source it tells me that I need autoconf-2.63. However the freeBSD ports only has ...
    Nov 6, 2009 at 3:20 am
    Nov 6, 2009 at 7:57 pm
  • Hello We have been using for years and without problems local ident autentification in the database for our user postgres. These are the values that we have been using until version 8.3: pg_hba.conf: ...
    Rafael MartinezRafael Martinez
    Nov 5, 2009 at 1:49 pm
    Nov 5, 2009 at 3:21 pm
  • Hi all, It looks like Postgres has a restriction in DISTINCT ON queries where the DISTINCT ON expressions must match the left side of the ORDER BY list. The issue is that if a DISTINCT ON ... has ...
    Emmanuel CecchetEmmanuel Cecchet
    Nov 4, 2009 at 3:17 am
    Nov 4, 2009 at 1:41 pm
  • I have completed the open issues (that I'm aware of) for operator exclusion constraints: http://archives.postgresql.org/message-id/1257101600.27737.159.camel@jdavis I'd now like to propose an ...
    Jeff DavisJeff Davis
    Nov 2, 2009 at 12:01 am
    Nov 2, 2009 at 4:35 am
  • Tom's recent work to fix the (TG_OP = 'INSERT' and NEW.foo ...) problem reminded me of another PL/pgsql annoyance: create table foo (a integer); create or replace function broken() returns trigger as ...
    Robert HaasRobert Haas
    Nov 5, 2009 at 9:35 pm
    Nov 6, 2009 at 1:10 am
  • Attached is a draft patch for the next step in my project of reimplementing plpgsql's parsing. This makes the recently added parser hooks accessible for callers that are using SPI (like plpgsql) and ...
    Tom LaneTom Lane
    Nov 4, 2009 at 4:27 pm
    Nov 4, 2009 at 8:50 pm
  • Hi guys, I hacked PostgreSQL 8.4.1 libpq and added a new function to specify resultFormat for individual result columns. Are you interested in a patch? ...
    Ivo RaisrIvo Raisr
    Nov 2, 2009 at 11:00 am
    Nov 2, 2009 at 4:11 pm
  • Is it at all reasonable to try to create some mechanism so that exceptions (elog) that are caught and not rethrown do not end up in the log? For example, when you write code that does something like ...
    Peter EisentrautPeter Eisentraut
    Nov 11, 2009 at 9:25 pm
    Nov 12, 2009 at 1:57 pm
  • I encountered the following log in 8.4.1 and HEAD. The deadlock occured on the same object (relation 17498 of database 17497). Is it reasonable? ERROR: deadlock detected DETAIL: Process 6313 waits ...
    Itagaki TakahiroItagaki Takahiro
    Nov 11, 2009 at 3:02 am
    Nov 12, 2009 at 12:09 am
  • Hello, we use a value -1 as two values: a) unknown typmod, b) unknown location. Can we substitute it by some better identifier? Maybe: UnknownTmod, UnknownLoc ... UnspecTmd, UnspecLoc??? Regards ...
    Pavel StehulePavel Stehule
    Nov 5, 2009 at 10:17 pm
    Nov 6, 2009 at 5:18 am
  • Hi, Sorry for this late reply. On Wed, Aug 19, 2009 at 6:45 PM, Heikki Linnakangas wrote: No. In my test (v8.3.7 on Win), an immediate shutdown was able to kill postmaster, but not pg_standby and the ...
    Fujii MasaoFujii Masao
    Nov 4, 2009 at 10:40 am
    Nov 5, 2009 at 4:29 am
  • Hmm. It strikes me that the names seen by tar include "postgresql-x.y.z/". The only file paths that approach 100 characters on that basis as of 8.4.1 are ...
    Tom LaneTom Lane
    Nov 2, 2009 at 5:54 pm
    Nov 2, 2009 at 7:43 pm
  • Found this a couple of weeks back and just re-tested against head: CREATE TEXT SEARCH DICTIONARY with an empty thesaurus file will crasch the backend. To reproduce: $ echo "" $(pg_config ...
    Robert GravsjöRobert Gravsjö
    Nov 30, 2009 at 3:41 pm
    Dec 1, 2009 at 5:58 pm
  • Hello community, Second time after migration 8.3.7 -- 8.4.1 I was caught by this problem. Migration was 8 days ago. (note, I never seen such situation on 8.3) Environment: PostgreSQL 8.4.1 + patch ...
    Sergey KonoplevSergey Konoplev
    Nov 11, 2009 at 5:50 pm
    Nov 12, 2009 at 1:42 am
  • While reading through the patch for what must be the 100th time by now, it occurred to me that this comment in heap_xlog_freeze: + /* + * Freezing tuples does not require conflict processing + */ is ...
    Heikki LinnakangasHeikki Linnakangas
    Nov 11, 2009 at 10:35 am
    Nov 11, 2009 at 3:11 pm
  • Hi, I was using auto_explain to log plans (with analyze option on) from queries that take more than 500ms, something i found i little odd is that the duration says 779ms but actual time says 269ms ...
    Jaime CasanovaJaime Casanova
    Nov 11, 2009 at 6:08 am
    Nov 11, 2009 at 2:47 pm
  • Hello, I would suggest the inclusion an option to create the database accent-insensitive, without need to use functions that in some cases it's slow to return the result. Example: select name from ...
    Nov 10, 2009 at 10:15 am
    Nov 10, 2009 at 1:23 pm
  • I'm working on partitioning syntax, amd encountered a dependency issue. When we define partition, also create an implicit CHECK constraint. The constraint should be kept until the pg_inherits entry ...
    Itagaki TakahiroItagaki Takahiro
    Nov 10, 2009 at 7:22 am
    Nov 10, 2009 at 7:50 am
  • Me & Simon got talking about the difficulty of doing parallel pg_dump, where when you open multiple connections you must somehow ensure that all the connections use the same snapshot so that you get ...
    Heikki LinnakangasHeikki Linnakangas
    Nov 7, 2009 at 10:37 am
    Nov 7, 2009 at 11:47 am
  • This is some oddness about the use of double quotes when defining operators in postgres 8.3. It seems that the operator name in the create operator clause cannot be quoted, but in the commutator, or ...
    Marc MunroMarc Munro
    Nov 6, 2009 at 11:29 pm
    Nov 7, 2009 at 1:14 am
  • Thank you very much! -----邮件原件----- 发件人: Robert Haas 发送时间: 2009年12月1日 1:37 收件人: 张中 抄送: pgsql-hackers@postgresql.org 主题: Re: [HACKERS] is isolation level 'Serializable' in pg not same as ...
    Nov 30, 2009 at 11:25 pm
    Nov 30, 2009 at 11:25 pm
  • Hi, While checking some other code I used valgrind and noticed, as I had before, that XLogInsert showed accesses to unitialized data. After some searching and playing around I found the source of ...
    Andres FreundAndres Freund
    Nov 7, 2009 at 12:33 pm
    Nov 7, 2009 at 12:33 pm
  • There is some code in the core parser to support the syntax UPDATE/DELETE ... WHERE CURRENT OF $n where $n is a parameter symbol. This was put in to support plpgsql, with the expectation that $n ...
    Tom LaneTom Lane
    Nov 6, 2009 at 7:48 pm
    Nov 6, 2009 at 7:48 pm
  • The attached patch makes the basic cutover from inserting plpgsql variables into SQL expressions by textual substitution, to handling them via parser hooks. Currently I only have the pre_columnref ...
    Tom LaneTom Lane
    Nov 6, 2009 at 3:31 pm
    Nov 6, 2009 at 3:31 pm
  • An update on pg_comparator as an efficient way to do master-slave replication. I have been using it for 2 years on a "products" table that has grown from 12,000 rows to 24,000 rows. There are 3 ...
    Erik AronestyErik Aronesty
    Nov 5, 2009 at 3:48 pm
    Nov 5, 2009 at 3:48 pm
Group Navigation
period‹ prev | Nov 2009 | next ›
Group Overview
grouppgsql-hackers @

82 users for November 2009

Tom Lane: 87 posts Robert Haas: 45 posts Alvaro Herrera: 30 posts Jeff Davis: 27 posts Simon Riggs: 24 posts Peter Eisentraut: 18 posts Heikki Linnakangas: 17 posts Bruce Momjian: 13 posts Josh Berkus: 13 posts Fujii Masao: 12 posts Itagaki Takahiro: 12 posts Andrew Dunstan: 11 posts David E. Wheeler: 11 posts Pavel Stehule: 11 posts Greg Stark: 9 posts Andres Freund: 8 posts Andrew Chernow: 8 posts Andrew Gierth: 6 posts Dimitri Fontaine: 6 posts Marko Tiikkaja: 6 posts
show more