On Jun 6, 2007, at 21:48 , Chester wrote:
Can you numerically sort a set of integers stored in a char column,
I guess change the cast of the column for the "sort by" process.
That's pretty much what you have to do, I believe.
SELECT *
FROM ints_as_chars
ORDER BY int_as_char;
int_as_char
---
Hi
Just a quick one, I have been around Postgres for a little while and
have never found an answer to this.
Can you numerically sort a set of integers stored in a char column, I
guess change the cast of the column for the "sort by" process.
and, if you can how...Unfortunatly I have no choi
Joshua D. Drake wrote:
Hello,
Is anyone going to try for this? If not I can have our designer do it,
but I would prefer it be a community deal.
We are looking to have new signage for the shows that PostgreSQL
attends. The signage that we have decided on is here:
http://www.displays2go.c
Hi,
I have a table with one column as real[]. Now if I want to make cubes
out of each of these arrays, is there a way in postgre I can do it. I
guess cube operator is not defined for real[] but can I create cubes if
the column was integer[]. If yes please may I know how.
Thanks
Abhang
-
ABHANG RANE <[EMAIL PROTECTED]> writes:
> I have written a function called similarity in postgresql which accepts
> real[] as argument. I then call it by saying
> select * from similarity('{1.232,5., 5.100, 1}');
> I get this error.
> Could not choose a best candidate function. You may
On Wed, 6 Jun 2007, Simon Riggs wrote:
"Unexpected pageaddr" is just one of the ways that recovery can detect
the end of the log, since there isn't ever an "end of log" marker when
we crash. (Normally it would be a checkpoint.)
That's the answer I was hoping for. Thanks!
-
On Wed, 2007-06-06 at 14:11 +0200, Vincenzo Romano wrote:
> On Wednesday 06 June 2007 13:41:12 Oliver Elphick wrote:
> > Any suggestions for improvement?
>
> As far as "running two or more versions of the PGSQL server in the same
> machine", I don't see solutions really different from the current
On Wed, 2007-06-06 at 13:26 -0700, Ben wrote:
> Hey guys, I'm burning in some new hardware and just reached the
> pull-the-plug phase of testing. On restart, I see this:
>
> 2007-06-06 12:04:00 PDT LOG: database system was interrupted at 2007-06-06
> 11:53:56 PDT
> 2007-06-06 12:04:00 PDT LOG:
Hi,
I have written a function called similarity in postgresql which accepts
real[] as argument. I then call it by saying
select * from similarity('{1.232,5., 5.100, 1}');
I get this error.
Could not choose a best candidate function. You may need to add
explicit type casts.
Is it th
Hey guys, I'm burning in some new hardware and just reached the
pull-the-plug phase of testing. On restart, I see this:
2007-06-06 12:04:00 PDT LOG: database system was interrupted at 2007-06-06
11:53:56 PDT
2007-06-06 12:04:00 PDT LOG: checkpoint record is at 24/C29ED068
2007-06-06 12:04:00
On Wed, Jun 06, 2007 at 01:45:43PM -0600, Islam Hegazy wrote:
> output[0] = (char*)palloc(sizeof(int)); //allocate space for a string that
> accepts an integer
No it doesn't, it allocates space for an integer
> output[1] = (char*)palloc(sizeof(double)); //allocate space for a string that
> acce
Hi all
I created a function that returns a set of records. This function returns an
integer and a float as the record fields. I have a problem in this function, it
truncates the output. e.g. 1342 is displayed as 134, 456.46 is displayed as
456. In other words, it displays the first 3 digits onl
As someone who would greatly benefit from this feature, is there
something I can do to help out in development/testing of this feature? I
have a test server I could install a cvs release of pgsql and know my
way around a makefile.
Dave Page wrote:
>
>> --- Original Message ---
>> From:
My fault, I apologize. I did realize my mistake while I was at lunch but
had responses before I could post to fix my error. I can use the
"replace()" function instead.
Thanks,
Woody
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stephan Szabo
Sent:
On Wed, 6 Jun 2007, Woody Woodring wrote:
> I am seeing weirdness using the trim function on a string:
>
> This works as expected:
>
> SELECT 'dhct:bn', trim(leading 'dhct:' from 'dhct:bn');
> ?column? | ltrim
> --+---
> dhct:bn | bn
> (1 row)
>
> However it fails for these cases:
On Wed, Jun 06, 2007 at 12:21:33PM -0400, Woody Woodring wrote:
> I am seeing weirdness using the trim function on a string:
You are missunderstanding the trim function.
> However it fails for these cases:
>
> SELECT 'dhct:dn', trim(leading 'dhct:' from 'dhct:dn');
> ?column? | ltrim
> --
I am seeing weirdness using the trim function on a string:
This works as expected:
SELECT 'dhct:bn', trim(leading 'dhct:' from 'dhct:bn');
?column? | ltrim
--+---
dhct:bn | bn
(1 row)
However it fails for these cases:
SELECT 'dhct:dn', trim(leading 'dhct:' from 'dhct:dn');
?colu
On Wed, Jun 06, 2007 at 04:44:03PM +0100, Richard Huxton wrote:
> I've had a quick look at my copy of DBI.pm (Debian Etch - lives in
> /usr/lib/perl5/DBI.pm)
>
> Around line 1930, we have the error-handling for execute_for_fetch()
>
> else {
> $err_count++;
> my $err = $sth->err;
> push @$
On Jun 5, 10:14 pm, Erwin Brandstetter <[EMAIL PROTECTED]> wrote:
> CREATE OR REPLACE FUNCTION f_concat_comma(text, text)
(...)
> LANGUAGE 'plpgsql' STABLE IMMUTABLE;
There's a typo. Should be:
LANGUAGE 'plpgsql' IMMUTABLE;
Regards
Erwin
---(end of broadcast)--
Bart Degryse wrote:
I tend to exclude reason 1: I've dumped the whole array using a debugger and it
really contains what I return when looping through it.
As far as I can see it's rather reason 2: execute_for_fetch seems to fill the
array incorrectly, that is: it's a valid array, but the last v
I tend to exclude reason 1: I've dumped the whole array using a debugger and it
really contains what I return when looping through it.
As far as I can see it's rather reason 2: execute_for_fetch seems to fill the
array incorrectly, that is: it's a valid array, but the last value added to it
also
rupesh bajaj wrote:
Hi,
Is Like operator can be used to join two relation. If yes what is its use?
And how it is used?
It tests a column for a partial match. So:
'abc' LIKE 'a%' = true
'abc' LIKE 'a_c' = true
'abc' LIKE 'A%' = false
See the manuals for details on other wildcard options and al
Bart Degryse wrote:
Using DBI->err was a leftover from earlier testing. $dbh_pg->err is of course
better. But it doesn't solve the problem.
I'm not sure what you mean with your second remark.
The call to my function ( SELECT dbi_insert3(); ) is one transaction I suppose.
According to the docu
Hello Amit,
Amit Jain schrieb:
> 1. how would i feed this wal files in to my online production database
> so it can take effect in product db.
I don't understand what effect feeding WAL files into a production
database should have. A production database installation keeps all WAL
files it produced
Simon Riggs wrote:
On Tue, 2007-06-05 at 18:39 +0200, Marco Colombo wrote:
I'm asking: what _exactly_ can go wrong?
If a checkpoint occurs while taking the backup then the contents of the
files will be overwritten
^
Data files or WAL segments? My archive command prevents WAL segments
f
Using DBI->err was a leftover from earlier testing. $dbh_pg->err is of course
better. But it doesn't solve the problem.
I'm not sure what you mean with your second remark.
The call to my function ( SELECT dbi_insert3(); ) is one transaction I suppose.
According to the documentation on execute_fo
Greg Smith wrote:
On Tue, 5 Jun 2007, Marco Colombo wrote:
AFAIK, files in pg_xlog are first renamed (and only if and after the
archive_command returned true) and later overwritten to. Never deleted.
No, they get deleted sometimes, too. Not often, but it can happen under
heavy load if more
On Wednesday 06 June 2007 13:41:12 Oliver Elphick wrote:
> Any suggestions for improvement?
As far as "running two or more versions of the PGSQL server in the same
machine", I don't see solutions really different from the current one.
So I would not waste time and resources in designing a (not rea
On Wed, 2007-06-06 at 10:51 +0100, Richard Huxton wrote:
> Hannes Dorbath wrote:
> > Running 2 PG instances is a trivial thing to do. It requires a quick
> > look at the PostgreSQL documentation to find out that:
>
> > But instead people spend their time on going out and ask how to use some
> >
Hi,
Is Like operator can be used to join two relation. If yes what is its use?
And how it is used?
Thanks & Regards,
Rupesh Bajaj
Hi
I need to take hot backup of production databae which size is around 500GB.
since i cannot take full backup dailiy so i am archiving its transaction logs
everyday which is around 2.5 gb daily can anyone suggest me that how would i
restore from these transaction logs. i have following query
Bart Degryse wrote:
I'm writing a function that fetches data in an Oracle database and stores it in
postgresql database.
The fetching from Oracle and the inserting in PostgreSQL both work correctly. I know this because with an empty target table and without an insert trigger the source data ge
On Wed, Jun 06, 2007 at 11:05:00AM +0200, Hannes Dorbath wrote:
> Isn't it funny that stupid wrapper scripts create confusion instead of
> making things easier for users.
>
> Running 2 PG instances is a trivial thing to do. It requires a quick
> look at the PostgreSQL documentation to find out t
I'm writing a function that fetches data in an Oracle database and stores it in
postgresql database.
The fetching from Oracle and the inserting in PostgreSQL both work correctly. I
know this because with an empty target table and without an insert trigger the
source data gets 'copied' perfectl
On Wednesday 06 June 2007 11:05:00 Hannes Dorbath wrote:
> Running 2 PG instances is a trivial thing to do. It requires a quick
> look at the PostgreSQL documentation to find out that:
>
> - The port is defined in postgresql.conf
> - pg_ctl -D defines what cluster to work on
> - The switch for the
Hannes Dorbath wrote:
Running 2 PG instances is a trivial thing to do. It requires a quick
look at the PostgreSQL documentation to find out that:
But instead people spend their time on going out and ask how to use some
poor wrappers, their distribution provides. Probably this has costed
them
On 06.06.2007 09:00, Vincenzo Romano wrote:
(Kubuntu) that provides a nice pg_wrapper
The point is thay I have no clue on ow to choose which instance attach to.
Isn't it funny that stupid wrapper scripts create confusion instead of
making things easier for users.
Running 2 PG instances i
Ugrade to a new kernel would be a very good idea, but you will have to
test the new kernel too.
In my oponion I believe that the reason for your
problem is either the linux kernel or your hardware.
I guess you have to update your kernel because of security bugs too.
Changing the Kernel is maybe e
On Wed, Jun 06, 2007 at 10:57:25AM +0200, Christophe Combet PBIL/IBCP/CNRS
wrote:
> Dear all,
>
>
> With the below transaction we got an out of memory error.
Here's your problem:
> AfterTriggerEvents: 3170885632 total in 397 blocks; 12200 free (384
> chunks); 3170873432 used
You've got som
Dear all,
With the below transaction we got an out of memory error.
BEGIN;
ANALYZE referenceAuthorLnkTemp;
INSERT INTO referenceAuthor (author)
SELECT DISTINCT ON (author) author
FROM referenceAuthorLnkTemp;
ANALYZE referenceAuthor;
UPDATE referenceAuthorLnkTemp
SET
On 6/5/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Greg Smith wrote:
> On Tue, 5 Jun 2007, Paolo Bizzarri wrote:
>
>> On 6/4/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>>> http://lwn.net/Articles/215868/
>>> documents a bug in the 2.6 linux kernel that can result in corrupted
>>> files if ther
> --- Original Message ---
> From: David Gardner <[EMAIL PROTECTED]>
> To: "'Dave Page'" <[EMAIL PROTECTED]>
> Sent: 06/06/07, 00:14:52
> Subject: RE: pl/pgsql debuging, was Re: [GENERAL] debugging C functions
>
> I grabbed the May 10th dev snapshot of pgAdmin3, first a little bit of pra
On Tuesday 05 June 2007 23:55:20 Oliver Elphick wrote:
> On Tue, 2007-06-05 at 23:40 +0200, Vincenzo Romano wrote:
> > Hi all.
> > I need to run both 8.1 and 8.2 at the same time in order to check
> > everything in 8.2 *before* shutting 8.1 down.
> > I need to run both as I only have one machine av
43 matches
Mail list logo
