[GENERAL] "PostgreSQL in the cloud" now up on media.postgresql.org

Greetings, The video from the May 12, 2009 SFPUG meeting, "BIRT & PostgreSQL," is now available for viewing or download from the media.postgresql.org server: http://media.postgresql.org/sfpug/sfpug-birt-20090512.mov Thanks, -- Xof -- Sent via pgsql-general mailing list (pgsql-general@po

Re: [GENERAL] Best way to monitor, control, or rewrite data definition commands?

On May 14, 2009, at 2:38 PM, Turner, Ian wrote: Thanks everyone for the many responses to this question. Asynchronous schema updates may be how we'll have to proceed, but we'd really like to avoid that. Instead, I'm currently studying the possibility of a my_create_table() function that acce

Re: [GENERAL] work_mem greater than 2GB issue

> HashAggregate doesn't have any ability to spill to disk.  The planner > will not select a HashAggregate if it thinks the required hash table > would be larger than work_mem.  What you've evidently got here is a > misestimate of the required hash table size, which most likely is > stemming from a

Re: [GENERAL] easy entry forms on a pg database

Scott Mead wrote: On Fri, May 15, 2009 at 1:11 PM, Raphael Bauduin > wrote: Hi, Are there any tool/libs to easily and rapidly generate web-based entry forms for tables in a postgresql database? I used this once for a quick project: http://www.sqlmae

Re: [GENERAL] how do you get there from here?

Alban Hertroys wrote: > IIRC you had an initially deferred foreign key constraint? Do you > absolutely need that to be initially deferred, or deferrable even? > Because that's what's causing your problem, not the foreign key > constraint itself. Ok. That's from the automagickally-generated SQL fro

Re: [GENERAL] easy entry forms on a pg database

Raphael, not shrinkwrapped, but have a look at http://www.trirand.com/blog/ jquery Grid Plugin. With some backend programming (Python, PHP...) you will have a table quick; forms are created "automagic" from that table; formatters etc. are definable. Are there any tool/libs to easily and rapidly

Re: [GENERAL] easy entry forms on a pg database

On Fri, May 15, 2009 at 1:11 PM, Raphael Bauduin wrote: > Hi, > > Are there any tool/libs to easily and rapidly generate web-based entry > forms for tables in a postgresql database? > I used this once for a quick project: http://www.sqlmaestro.com/products/postgresql/phpgenerator/ --Scott

[GENERAL] easy entry forms on a pg database

Hi, Are there any tool/libs to easily and rapidly generate web-based entry forms for tables in a postgresql database? Thanks Raphaël PS: In my search I've found PHP DB Form creator (http://sourceforge.net/projects/phpdbform/) but last realease is 5 years old. I also know of ERW, which doesn't s

Re: [GENERAL] Error in pgAdminIII

Arnold, Sandra wrote: I am getting the following error in pgAdminIII. I receive the error when I double click on a table under a schema that I own. First I can't find any documentation on what this error means. Always handy to have a copy of the source and a text search tool, even if you

[GENERAL] Error in pgAdminIII

I am getting the following error in pgAdminIII. I receive the error when I double click on a table under a schema that I own. First I can't find any documentation on what this error means. Second, my PostgreSQL account is a superuser account. An error has occurred: ERROR: could not open r

Re: [GENERAL] drop table but file still exists

On Fri, 2009-05-15 at 09:09 +0200, Luca Ferrari wrote: > I'm just curious to know why after a drop table the disk file is emptied but > still existent. What is the reason why the file is not deleted immediately? To avoid various problems the files are removed after the next checkpoint. -- Si

Re: [GENERAL] drop table but file still exists

Luca Ferrari writes: > I'm just curious to know why after a drop table the disk file is emptied but > still existent. What is the reason why the file is not deleted immediately? It's protecting against some obscure race condition involving reassignment of the relfilenode number to a new table.

Re: [GENERAL] how do you get there from here?

On May 13, 2009, at 8:48 PM, Michael P. Soulier wrote: Can someone suggest a better way that doesn't hit this "pending trigger" issue while in a transaction? IIRC you had an initially deferred foreign key constraint? Do you absolutely need that to be initially deferred, or deferrable even

Re: [GENERAL] Where is pg_dump?

On 14/05/2009 23:26, Dave Page wrote: > On Thu, May 14, 2009 at 11:21 PM, Raymond O'Donnell wrote: >> I don't think the Windows binaries are available for separate download >> (which is a great pity IMHO - 'twould be very handy betimes). > > They are: > http://wwwmaster.postgresql.org/download/m

[GENERAL] PostgreSQL service not starting / reattach shared memory - found some hints in logs..

Hello, I had some spurious effects of the PostgreSQL-Service not starting on windows. The usual fix was to "reboot", or even simpler: net start pgsql-8.3 TODAY it happened on my machine, so I had more access to track down some logs. And so I want to share some of them, the course of events: Wi

[GENERAL] drop table but file still exists

Hi, I'm just curious to know why after a drop table the disk file is emptied but still existent. What is the reason why the file is not deleted immediately? Thanks, Luca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postg