Stephan Szabo wrote:
> However, I don't think you can currently have both the property that you
> will never have a failure to commit after your external action runs and
> that your external action can abort the transaction if the external action
> fails.
Yeah. That's what two-phase commit is for
Hi All,
Does anyone know how to handle complex queries?
For Example, If i want to search for something like:
*(portable battery AND magnetic induction) OR (database management system)*
This is a sample query and user can specify any kind of complex query in
this way. I can't ask user to specify
Le dimanche 1 novembre 2009 à 09:50:29, Gaini Rajeshwar a écrit :
> Hi All,
>
> Does anyone know how to handle complex queries?
>
> For Example, If i want to search for something like:
>
> *(portable battery AND magnetic induction) OR (database management system)*
>
> This is a sample query and
On ons, 2009-10-28 at 14:13 +, Thom Brown wrote:
> > http://developer.postgresql.org/pgdocs/postgres/release-8-5.html
>
> Thanks Adrian. I just wasn't looking hard enough obviously :) That
> list still doesn't appear to be explicit enough though as we have
> "Multiple improvements in contrib
On ons, 2009-10-28 at 05:45 -0700, Xai wrote:
> i want to create a type for an email field but i'm not good with regx
> can some one help me?
I suggest that you make use of an already written module in some
language such as Perl. See
http://wiki.postgresql.org/wiki/Email_address_parsing for an ex
Hi,
I was wondering if there are plans to extend the window framing clause to allow the number of rows in the frame to be specified.
Something like:
ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING
I did find a comment on the TODO list regarding the framing clause ("Implement full support for window
2009/11/1 Peter Eisentraut :
> On ons, 2009-10-28 at 14:13 +, Thom Brown wrote:
>> I'm not really asking for the answer to those questions. I'm pointing
>> out that it isn't clear (at least to me) how to determine what exactly
>> has been fixed in order to test it. This doesn't apply to every
Stuart Adams wrote:
Looking for a forms generator for a web based UI for
entering/modifiying/viewing a table's records.
Any recommendations ???
Thanks,
Stuart
I've been using OpenOffice Base to hack something needed in a hurry. Not
bad with the native SDBC driver on Debian i386, proble
Hello Richard,
Just to keep you informed...
Richard Huxton a écrit :
>> We had a server crash and when restarting postgres it works, except some
>> "Invalid Page Header Error" :
>
> Data corrupted on disk. Either:
> 1. You have bad hardware
> 2. You have disks lying about fsync
> 3. You have fsy
Hi,
I need to choose a way to store image files.
This database will take care of an Add Classifieds website with low ammount
of Ads, maximum of 20 new ads per month.
It is good idea for this kind of website to store image files in the
database?
Another question... How to do inserts by the comma
Hi,
I'm wondering what steps should I do to make *working* backup on PITR
slave.
General rationale is: to reduce amount of work master has to do.
Let's assume we have master server, slave server, and shared
/wal_archive directory.
Postrges on both servers is in the same version, with datadir bei
Andre Lopes wrote on 01.11.2009 15:20:
I need to choose a way to store image files.
This database will take care of an Add Classifieds website with low
ammount of Ads, maximum of 20 new ads per month.
It is good idea for this kind of website to store image files in the
database?
This is a
Thomas Kellerer writes:
> Merlin Moncure wrote on 31.10.2009 14:32:
>> an oracle guy wrote an sql statement that solves a sudoku
>> puzzle...using an oracle specific feature. Still, it's pretty neat,
>> and an absolute gem of lateral thinking.
>>
>> http://technology.amis.nl/blog/6404/oracle-rdb
Hi,
Can someone can explain me why it's run like this with PostgreSQL v8.3.8 ?
base=# select translate('Hervé', 'é', 'e');
translate
---
Herve
(1 row)
base=# select translate('Hervé', 'âàäéèêëïöôùüû', 'aaaioouuu');
translate
---
Hervai
(1 row)
base=# \encoding
SQL_ASCII
On Sun, Nov 01, 2009 at 12:04:32PM +0100, Thomas Kellerer wrote:
> Hi,
>
> I was wondering if there are plans to extend the window framing
> clause to allow the number of rows in the frame to be specified.
>
> Something like:
>
> ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING
>
> I did find a comment on
On Sun, Nov 1, 2009 at 4:56 PM, Hervé Piedvache wrote:
base=# select translate('Hervé', 'é', 'e');
> translate
> ---
> Herve
> (1 row)
>
> base=# select translate('Hervé', 'âàäéèêëïöôùüû', 'aaaioouuu');
> translate
> ---
> Hervai
> (1 row)
>
You are actually doing somethin
Greetings, everyone!
I'm experiencing some troubles using the createlang command to add
plperl to my PostgreSQL installation. When I issue the command
"createlang plperl template1" I receive the following error message:
createlang: language installation failed: ERROR: could not load library
Arjen Nienhuis writes:
> I don't know why it does that though. Maybe it's the server_encoding. What
> does SHOW server_encoding; tell you?
He said SQL_ASCII. translate() will definitely not work nicely with
multibyte characters if it doesn't know they are multibyte :-(
r
John Burski writes:
> createlang: language installation failed: ERROR: could not load library
> "/usr/lib/postgresql/plperl.so": libperl.so: cannot open shared object
> file: No such file or directory
ldd on plperl.so might be informative.
> The "libperl.so" file is located in the
> /usr/lib/
Hi Tom,
Thar's mean I need to convert my database in other enconding ?
Regards,
Le dimanche 01 novembre 2009, Tom Lane a écrit :
> Arjen Nienhuis writes:
> > I don't know why it does that though. Maybe it's the server_encoding.
> > What does SHOW server_encoding; tell you?
>
> He said SQL_ASCI
Hello, this is the first time I post on this list.
I have setup a build environment on Windows 7 32 bits, with Visual Studio
2005. Took me a while to get all the bits and parts working, but I finally
went through it. Only problem, I get 2 LINK errors:
fatal error LINK 1104: cannot open file
'.\Rel
On Mon, Nov 2, 2009 at 12:07 AM, Hervé Piedvache wrote:
> Hi Tom,
>
> Thar's mean I need to convert my database in other enconding ?
>
No you don't. The problem is with the encoding of the query:
test=# \encoding
SQL_ASCII
test=# SELECT convert('Hervé', 'UTF-8', 'LATIN1');
convert
--
H
"Bernard Grosperrin" writes:
> I have setup a build environment on Windows 7 32 bits, with Visual Studio
> 2005. Took me a while to get all the bits and parts working, but I finally
> went through it. Only problem, I get 2 LINK errors:
> fatal error LINK 1104: cannot open file
> '.\Release\utf8_an
On 2/11/2009 11:40 AM, Tom Lane wrote:
> "Bernard Grosperrin" writes:
>> I have setup a build environment on Windows 7 32 bits, with Visual Studio
>> 2005. Took me a while to get all the bits and parts working, but I finally
>> went through it. Only problem, I get 2 LINK errors:
>> fatal error LIN
Craig Ringer writes:
> On 2/11/2009 11:40 AM, Tom Lane wrote:
>> src/backend/utils/mb/conversion_procs/euc_jis_2004_and_shift_jis_2004/euc_jis_2004_and_shift_jis_2004.c
>> We have seen reports of certain versions of "tar" failing to extract
>> this file from the source tarball, probably because it
Hi all
Before I go ahead and try to write a decent quality version: is there
any chance an array_reverse() function (in C) would be accepted into Pg
mainline? If not, I probably won't bother cleaning up my current
awful-hack quality module.
It's a slow operation to perform in SQL or PL/PgSQL even
26 matches
Mail list logo