[GENERAL] Tablespace limit feature

Hi, Can PostgreSQL's tablespace limit space in MB? Or exists another way to limit space in a table of a tablespace?? Thanks and Regards

Re: [GENERAL] Tablespace limit feature

, "Stephen Frost" a écrit : > > * Alejandro Carrillo (faster...@yahoo.es) wrote: > > Can PostgreSQL's tablespace limit space in MB? Or exists another way to > > limit space in a table of a tablespace?? > > You can set up quotas on the underlying filesystem, but

Re: [GENERAL] Tablespace limit feature

But This feature is very necessary to control the amount space expensed by a postgresql user or tablespace. This feature could be used in PostgreSQL Sharing Hosting, see: Shared Database Hosting - PostgreSQL wiki |   | |   |   |   |   |   | | Shared Database Hosting - PostgreSQL wikiThe objecti

[GENERAL] not(t_xmax = 0)

Hi, I need to filter xid != 0. I tried this "not(t_xmax = 0)" but I dont sure that this work ok How I do it? Create or replace function obtener_info_reg(tabla varchar, buscareliminado boolean, curs refcursor) returns void as $$ declare query_string varchar; strwhere varchar; strsql varchar;

Re: [GENERAL] not(t_xmax = 0)

I try to do a function that let know which rows are deleted in a table using the xmax !=0 > > De: Kevin Grittner >Para: Alejandro Carrillo ; pgsql-general@postgresql.org >Enviado: Domingo 20 de enero de 2013 12:19 >Asunto: Re: [GENERAL]

Re: [GENERAL] not(t_xmax = 0)

this function didn't work to know if a row can surely dead? http://doxygen.postgresql.org/tqual_8c_source.html#l01236 > > De: Tom Lane >Para: Kevin Grittner >CC: Alejandro Carrillo ; pgsql-general@postgresql.org >Enviado: Domingo 20 de

[GENERAL] PostgreSQL Portable for Linux

Good morning / afternoon / night, I already updated the PostgreSQL Portable for Linux Debian and him flawors. Tested on Debian Jessie and Ubuntu 17.4. Its a 7z file.https://sourceforge.net/projects/pgsqlportable/files/9.6/pgsql%209.6x64.7z/download Please look the description of the project to r

[GENERAL] Support for Alert

Hi, PostgreSQL have a way to put alerts about number of connections, tablespace used, etc like the DBMS_SERVER_ALERT package of Oracle? Thanks you

Re: [GENERAL] [pgsql-es-ayuda] como exportar separado por comas una tabla grande

http://www.postgresql.org/docs/current/static/sql-copy.html > > De: Hellmuth Vargas >Para: Lista Postgres ES ; >pgsql-general@postgresql.org >Enviado: Miércoles 24 de octubre de 2012 12:22 >Asunto: [pgsql-es-ayuda] como exportar separado por comas una tabla gr

[GENERAL] Read recover rows

Hi, 1) Anybody knows how to create a table using a table file? It isn't a fdw, is a file that compose the table in postgresql and get with the pg_relation_filepath function. Ex:    select pg_relation_filepath('pg_proc');   2) Anybody knows a JDBC or a multiplatform code that let read the delete

Re: [GENERAL] Read recover rows

Hi, 1) Isn't a script. The file is a table file get using the function pg_relation_filepath: select pg_relation_filepath('pg_proc'); 2) :( help! > > De: Adrian Klaver >Para: Alejandro Carrillo >CC: "pgsql-general@postgres

Re: [GENERAL] Read recover rows

? > > De: Adrian Klaver >Para: Alejandro Carrillo >CC: "pgsql-general@postgresql.org" >Enviado: Jueves 13 de diciembre de 2012 18:23 >Asunto: Re: [GENERAL] Read recover rows > >On 12/13/2012 03:14 PM, Alejandro Carrillo wrote: >> Hi, >> >> 1) Is

Re: [GENERAL] Read recover rows

Are you trying to recover a table by copying in a table from somewhere else? Yes because I can't modify the original file > > De: Adrian Klaver >Para: Alejandro Carrillo >CC: "pgsql-general@postgresql.org" >Enviado: Jueves

Re: [GENERAL] Read recover rows

But pg_dirty_read only runs in Linux. It doesnt run in windows. > > De: Alvaro Herrera >Para: Alejandro Carrillo >CC: "pgsql-general@postgresql.org" >Enviado: Jueves 13 de diciembre de 2012 21:51 >Asunto: Re: [GENERAL] Rea

Re: [GENERAL] logger table

Did you use pg_audit? https://github.com/jcasanov/pg_audit > > De: Philipp Kraus >Para: pgsql-general@postgresql.org >Enviado: Domingo 23 de diciembre de 2012 22:01 >Asunto: [GENERAL] logger table > >Hello, > >I need some ideas for creating a PG based logger.

[GENERAL] pg_dirtyread doesnt work

Hi, After of very tried to compile this PostgreSQL C function for Windows, I compile that (with VS C++ 2008), but the function get a error when try to read a deleted row. The example: CREATE FUNCTION pg_dirtyread(oid) RETURNS setof record AS E'$libdir/pg_dirtyread', 'pg_finfo_pg_dirtyread' LANG

Re: [GENERAL] pg_dirtyread doesnt work

Anybody knows why could be happening: ERROR:  invalid memory alloc request size 1850015748 Thanks > > De: Alejandro Carrillo >Para: "pgsql-general@postgresql.org" >Enviado: Jueves 27 de diciembre de 2012 16:17 >Asunto: [GENERAL]

Re: [GENERAL] pg_dirtyread doesnt work

So I going to say, Alvaro. The table structure should not create a table with TOAST > > De: Alvaro Herrera >Para: Phil Sorber >CC: Alejandro Carrillo ; "pgsql-general@postgresql.org" > >Enviado: Viernes 28 de diciembre de 2012