r_length select (val) from txt;
select *, length (val) val is null, (val ~ 'x') from txt;
Thank you.
Claudio Oliveira
http://www.msisolucoes.com.br
> From: br...@momjian.us
> Subject: Re: [BUGS] BUG #6177: Size field type TEXT
> To: kevin.gritt...@wicourts.gov
>
The following bug has been logged online:
Bug reference: 6177
Logged by: Claudio Oliveira
Email address: claudio...@hotmail.com
PostgreSQL version: 9.1rc1
Operating system: Windows 7
Description:Size field type TEXT
Details:
Hello,
Use version 8.4 and have no
On Thu, 2010-06-03 at 13:11 -0500, Kevin Grittner wrote:
> Based on what I've heard so far, I wouldn't entirely
>
> rule out some sort of bloat being a factor, either.
>
> -Kevin
Index/table bloat is the first thing I suspected, and both table and
indices look all the right size. Knowing how
On Thu, 2010-06-03 at 13:42 -0400, Tom Lane wrote:
> Claudio Freire writes:
> > What I did do is analyze server load during the events, and as I
> > suspected, disk activity during the "deadlocks" seems to suggest a
> > vacuuming taking place. Although t
On Fri, 2010-04-30 at 11:50 -0400, Tom Lane wrote:
> "Kevin Grittner" writes:
> > Eliminating null columns and mangling column headers for length, I
> > get this:
>
> > locktype| tranid | virtualx | pid | mode | gr
> > transactionid | 39773877 | 63/15761 | 11157 | ShareLock
On Fri, 2010-04-30 at 12:32 -0400, Tom Lane wrote:
> "Kevin Grittner" writes:
> > Claudio Freire wrote:
> >> I know it doesn't look like a deadlock from where you're standing,
> >> but it does so from where I am.
>
> > It's possible
On Fri, 2010-04-30 at 11:14 -0500, Kevin Grittner wrote:
> Claudio Freire wrote:
>
> > I know it doesn't look like a deadlock from where you're standing,
> > but it does so from where I am.
>
> It's possible that you're filtering out the informatio
On Fri, 2010-04-30 at 11:50 -0400, Tom Lane wrote:
> "Kevin Grittner" writes:
> > Eliminating null columns and mangling column headers for length, I
> > get this:
>
> > locktype| tranid | virtualx | pid | mode | gr
> > transactionid | 39773877 | 63/15761 | 11157 | ShareLock
On Fri, 2010-04-30 at 08:47 -0500, Kevin Grittner wrote:
> Peter Eisentraut wrote:
>
> > This is not a deadlock.
>
> Agreed.
>
> > It's just two locks on the same table
>
> Not as I read it.
>
> > (and maybe a bit more readable formatting).
>
> Eliminating null columns and mangling co
The following bug has been logged online:
Bug reference: 5443
Logged by: Claudio
Email address: clau...@livra.com
PostgreSQL version: 8.3.7
Operating system: CentOS
Description:Undetected deadlock situation
Details:
During a massive update of a table A, a single
The following bug has been logged online:
Bug reference: 4176
Logged by: claudio furukawa
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: windows xp sp2
Description:process
Details:
PostgreSQL is in many process.
There are 6 process
8/msg00482.php
Cheers,
Claudio
---
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
http://www.memetrics.com/emailpolicy.html";>http://www.memetrics.com/em
ailpolicy.html
--
ql-7.4.3.tar.gz from the ftp site.
>
And that's where you went wrong. PostgreSQL for win32 in source form is
(currently) only in cvs head.
Download source from cvs, or download the binaries referred to in the above
link.
Cheers,
Claudio
---
Certain disclaimers and policies apply to al
POSTGRESQL BUG REPORT TEMPLATE
Your name : Claudio Sartori
Your email address
and then I'll say Cygwin gets the blame...
Sounds reasonable. I'd also like to get confirmation from another cygwin
user too... any takers?
Cheers,
Claudio
Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies s
ction.
Absolutely. Certainly possible to imagine some form of race condition in
cygipc being responsible, but I'm only guessing from the symptoms (not from
any knowledge of the implementation of either postgres or cygwin/ipc).
Cheers,
Claudio
Certain disclaimers and policies apply to a
$ createlang --pglib=/usr/local/pgsql/lib plpgsql template1
ERROR: Load of file /usr/local/pgsql/lib/plpgsql.so failed: ld.so.1:
/usr/local/pgsql/bin/postmaster: errore fatale:libgcc_s.so.1: impossibile
aprire: File o directory non trovati
createlang: language installation failed
$
17 matches
Mail list logo
