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;
Thanks, impatient me, did not reboot, did now, works!
Thank you
Am 19.01.2013 um 17:52 schrieb Tom Lane:
> Alexander Reichstadt writes:
>> I never had any problems to install postgres 9.1, now I do with 9.2. This is
>> the enterprise installer for Mac OS X. I tried to install and am getting th
Alejandro Carrillo wrote:
> 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?
Please give a high-level description of what you are trying to
accomplish and why. I didn't find it at all clear from your sample
function,
-Kevin
--
Sen
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] not(t_xmax = 0)
>
>Alej
Alejandro Carrillo wrote:
> De: Kevin Grittner
>> Please give a high-level description of what you are trying to
>> accomplish and why.
> I try to do a function that let know which rows are deleted in a
> table using the xmax !=0
That's not something you're going to have much luck with by using
"Kevin Grittner" writes:
> Alejandro Carrillo wrote:
>> I try to do a function that let know which rows are deleted in a
>> table using the xmax !=0
> That's not something you're going to have much luck with by using
> plpgsql to try to parse heap pages.
No, because xmax being nonzero doesn't pr
On 1/18/13, Steve Crawford wrote:
> On 01/18/2013 09:31 AM, Robert James wrote:
>> I'd like to better understand TIMESTAMP WITH TIME ZONE.
>>
>> My understanding is that, contrary to what the name sounds like, the
>> time zone is never stored. It simply stores a UTC timestamp,
>> identical to wha
On 01/20/2013 04:28 PM, Robert James wrote:
I'm confused. If I make sure to use UTC, isn't timestamp without time
zone identical, then? If not, what is the difference?
When you tag a date/time using WITH TIME ZONE you are telling Postgres
you care about time zones for that field:
http://
On 01/20/2013 04:28 PM, Robert James wrote:
On 1/18/13, Steve Crawford wrote:
I'm confused. If I make sure to use UTC, isn't timestamp without time
zone identical, then? If not, what is the difference?
Realized my previous explanation could be better. The primary difference
is that when
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 enero de 2013 15:30
>A
On 01/21/2013 02:37 AM, Robert Haas wrote:
> On Sat, Jan 19, 2013 at 11:58 AM, Pavel Stehule
> wrote:
>> We introduced VARIADIC "any" function. Motivation for this kind of
>> function was bypassing postgresql's coerce rules - and own rules
>> implementation for requested functionality. Some built
On Sun, Jan 20, 2013 at 7:15 PM, Craig Ringer wrote:
>
> FWIW, I find PostgreSQL's type casting rules excessively strict and very
> painful, especially when working via query generation layers and ORMs
> with pseudo-text data types like "xml" and "json". I'd rather work with
> direct SQL, but tha
Hello,
Greetings !
I am new to postgres and recently got migrated from oracle. I am using
postgresql 9.2 version.
I am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas with
1 lakh rows in each schema. Could take the data dump using pg_dump and it takes
around 40 minutes. I
Le 2013-01-20 à 20:04, Adrian Klaver a écrit :
> On 01/20/2013 04:28 PM, Robert James wrote:
>> On 1/18/13, Steve Crawford wrote:
>>
>> I'm confused. If I make sure to use UTC, isn't timestamp without time
>> zone identical, then? If not, what is the difference?
>>
>
> Realized my previous e
Le 2013-01-20 à 23:10, bhanu udaya a écrit :
> I am new to postgres and recently got migrated from oracle. I am using
> postgresql 9.2 version.
Welcome, and good choice for the version.
> I am trying to restore 9.5G database (1GB dumpfile) which has 500 schemas
> with 1 lakh rows in each sche
On 01/20/2013 08:12 PM, François Beausoleil wrote:
Le 2013-01-20 à 20:04, Adrian Klaver a écrit :
On 01/20/2013 04:28 PM, Robert James wrote:
On 1/18/13, Steve Crawford wrote:
I'm confused. If I make sure to use UTC, isn't timestamp without time
zone identical, then? If not, what is the di
Hello,Greetings !Thank you for the prompt reply. I have changed the settings
as listed below:> > shared_buffers = 1024MB
> > work_mem = 512MB
> > maintenance_work_mem = 512MB
> > wal_buffers = 100MB> fsync = off # ONLY DURING INITIAL DATA LOAD!
> checkpoint_segments = 128 # large value, such
Hi all
There's a patch to fix PL/Python build support under Cygwin on Windows
in the queue for this commitfest. If there's anyone here who's a Cygwin
fan, now would be a great time to do some testing:
* Grab the patch
* Verify that it applies cleanly
* Verify that it builds cleanly with Cygwin ma
On Jan 21, 2013 7:17 AM, "bhanu udaya" wrote:
>
>
> Hello,
> Greetings !
> Thank you for the prompt reply. I have changed the settings as listed
below:
> > > shared_buffers = 1024MB
> > > work_mem = 512MB
> > > maintenance_work_mem = 512MB
> > > wal_buffers = 100MB
> > fsync = off # ONLY DURING I
Hi all
Anybody here who has particular interest in or skill with SELinux is
invited (begged?) to help test KaiGai Kohei's patches for enhancing
PostgreSQL's SELinux/SEPostgreSQL support. These changes are proposed
for 9.3, but have had relatively little interest from patch reviewers
and are in dan
20 matches
Mail list logo
