Gowrishankar L wrote:
Hi All,
I need to make certain changes to cube.c file which comes with cube contrib
( http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/). I am not
sure how to compile it so that I can use those changes in postgresql. Could
you help me?
Well, the full procedu
On 30.10.2007 03:11, Joshua D. Drake wrote:
Ow Mun Heng <[EMAIL PROTECTED]> wrote:
It's not an optimal setup but since I only have 3x500G drives to play
with, I can't build a Raid10
Uhhh RAID 1 is your best bet. You get fault tolerance (mirrored) plus
you get a hot spare (3 drives).
This is
2007/10/26, Patrick TJ McPhee <[EMAIL PROTECTED]>:
> In article <[EMAIL PROTECTED]>, cluster <[EMAIL PROTECTED]> wrote:
> % > How important is true randomness?
> %
> % The goal is an even distribution but currently I have not seen any way
> % to produce any kind of random sampling efficiently. Not
> 2007/10/26, Patrick TJ McPhee <[EMAIL PROTECTED]>:
>> In article <[EMAIL PROTECTED]>, cluster <[EMAIL PROTECTED]>
>> wrote:
>> % > How important is true randomness?
>> %
>> % The goal is an even distribution but currently I have not seen any way
>> % to produce any kind of random sampling effici
Dear all,
What is the correct way to check whether an array is empty?
I have an array which I initialize with '{}' and then do som array_append
under some circonstances. I would like to know whether the array is empty at
the end of the function. I have not found the answer in the help page nor on
Alexis Beuraud wrote:
Dear all,
What is the correct way to check whether an array is empty?
-- Is my array empty now?
IF (myarray isnull) THEN
An empty array isn't null (unknown), it's empty.
Try enquiring about it's size:
SELECT array_dims('{}'::integer[]) is null;
?column?
--
t
2007/10/30, vincent <[EMAIL PROTECTED]>:
> > 2007/10/26, Patrick TJ McPhee <[EMAIL PROTECTED]>:
> >> In article <[EMAIL PROTECTED]>, cluster <[EMAIL PROTECTED]>
> >> wrote:
> >> % > How important is true randomness?
> >> %
> >> % The goal is an even distribution but currently I have not seen any w
2007/10/30, Alexis Beuraud <[EMAIL PROTECTED]>:
> Dear all,
>
> What is the correct way to check whether an array is empty?
> I have an array which I initialize with '{}' and then do som array_append
> under some circonstances. I would like to know whether the array is empty at
> the end of the fun
On 28/10/2007, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> On Sat, 27 Oct 2007, Tom Lane wrote:
>
> > "Catalin Marinas" <[EMAIL PROTECTED]> writes:
> >> Is there an easy way to generate a headline from separate fragments
> >> containing the search words and maybe separated by "..."?
> >
> > Hmm, the
Abandoned wrote:
Hi..
I want to do index in postgresql & python.
My table:
id(int) | id2(int) | w(int) | d(int)
My query:
select id, w where id=x and id2=y (sometimes and d=z)
I have too many insert and select operation on this table.
And which index type can i use ? Btree, Rtree, Gist or Hash
Catalin,
what is your need ? What's wrong with this ?
postgres=# select ts_headline('1 2 3 4 5 3 4 abc abc 2 3 xyz','2'::tsquery,
'StartSel=...,StopSel=...')
;
ts_headline
---
1 ...2... 3 4 5 3 4 abc abc ...2... 3 xyz
Oleg
On Tue, 30 Oc
Oleg Bartunov wrote:
Catalin,
what is your need ? What's wrong with this ?
postgres=# select ts_headline('1 2 3 4 5 3 4 abc abc 2 3
xyz','2'::tsquery, 'StartSel=...,StopSel=...')
;
ts_headline
---
1 ...2... 3 4 5 3 4 abc abc ...2... 3 x
2007/10/30, Jorge Godoy <[EMAIL PROTECTED]>:
> Em Tuesday 23 October 2007 07:17:53 Goboxe escreveu:
> > Hi,
> >
> > What is the equivalent MSSQL 'print' command in pg sproc?
>
> What does the MSSQL 'print' command "prints"?
It prints what you tell it to print :)
Goboxe: The key question is, what
Hi David!
Thanks for the fast reply. So you mean that I might already have created
a connection but am still trying to create the same one again?
>>Check whether the existing one works :)
So how can I test it?
What is the correct way of accessing this data source in a select statement?
Concer
I see a misunderstanding here.
cube contrib is for handling geometrical data.
EFEU package is OLAP - related, that's entirely different topic.
http://www.informit.com/articles/article.aspx?p=24684
2007/10/1, Dimitri Fontaine <[EMAIL PROTECTED]>:
> Hi,
>
> Le Wednesday 26 September 2007 20:58:
Alexis Beuraud wrote:
> What is the correct way to check whether an array is empty?
>
> Here is what I do, in pseudo-code:
>
> -- Is my array empty now?
> IF (myarray isnull) THEN
Try this:
IF array_lower(myarray, 1) IS NULL THEN ... END IF
Yours,
Laurenz Albe
---(end
Am Montag, 29. Oktober 2007 schrieb James Gates:
> Notice that the results don't match the operating system's (either byte
> code or dictionary) sort order for the same locale, or even the C or
> POSIX locales.
Note that none of the sort orders you showed match an actual Swedish
dictionary sort,
On 30/10/2007, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Oleg Bartunov wrote:
> > Catalin,
> >
> > what is your need ? What's wrong with this ?
> >
> > postgres=# select ts_headline('1 2 3 4 5 3 4 abc abc 2 3
> > xyz','2'::tsquery, 'StartSel=...,StopSel=...')
> > ;
> > ts_headline
kamiseq <[EMAIL PROTECTED]> writes:
> select into _id lastval();
> and is that safe operation, can I rely on lastval() that it will
> return value of id that was inserted before?
You want to use currval() with the sequence name.
> can it happened that other user will insert something betwe
Sean Z. wrote:
Hi,
I partitioned a table "events" into 31 tables, based on "day" of
event_time.
I did 3 steps to setup partition, after creating partition tables:
1. Add the constraint to the 31 partition tables like:
ALTER TABLE events_day_1
ADD CONSTRAINT events_day_1_event_time_check C
On 29-Oct-07, at 11:06 PM, Tom Lane wrote:
Brian Wipf <[EMAIL PROTECTED]> writes:
The process I use that leads to the warnings is simple:
I use pg_controldata to determine the current checkpoint WAL location
of the standby server. I ensure I have this WAL file and all newer
WALs. I backup a
On Tue, Oct 30, 2007 at 01:12:41PM +0100, Pit M. wrote:
> Hi David!
>
> Thanks for the fast reply. So you mean that I might already have
> created a connection but am still trying to create the same one
> again?
Yes.
> >>Check whether the existing one works :)
> So how can I test it?
Fire up ps
If your holy grail is the ability of using infomation to drive drawings I
have to ask if you have any idea what that could lead too?
- Design productivity would increase by factors of hundreds - perhaps
thousands.
- Information would be infinitly adaptable.
- Structure that information prope
On Tue, 30 Oct 2007, Catalin Marinas wrote:
On 30/10/2007, Richard Huxton <[EMAIL PROTECTED]> wrote:
Oleg Bartunov wrote:
Catalin,
what is your need ? What's wrong with this ?
postgres=# select ts_headline('1 2 3 4 5 3 4 abc abc 2 3
xyz','2'::tsquery, 'StartSel=...,StopSel=...')
;
Hello,
one of our clients is using pgsql 8.1, and recently the site crashed due
to lack of hard disk space. Upon inspection a file was found :
pgsql.broken.csc (size: > 51 GB)
I cannot find any reference to this file on pgsql site or on google.
What is this file? Is it related to PGSQL? Wha
M Rather <[EMAIL PROTECTED]> writes:
> one of our clients is using pgsql 8.1, and recently the site crashed due
> to lack of hard disk space. Upon inspection a file was found :
> pgsql.broken.csc (size: > 51 GB)
> I cannot find any reference to this file on pgsql site or on google.
> What is t
Tom Lane wrote:
M Rather <[EMAIL PROTECTED]> writes:
one of our clients is using pgsql 8.1, and recently the site crashed due
to lack of hard disk space. Upon inspection a file was found :
pgsql.broken.csc (size: > 51 GB)
I cannot find an
I have the following table in a win32 8.2.2 database: (dumped from pgadmin)
CREATE TABLE email_directory
(
email_directory_id serial NOT NULL,
mailbox_id integer NOT NULL,
path character varying(255) NOT NULL,
marked_for_deletion boolean NOT NULL DEFAULT false,
CONSTRAINT email_directory_pke
This is a nice idea and seems easy to implement. I will try to write
it down and send a patch to the mailing list.
I was also working to add support for phrase search. Currently to
check for phrase you have to match the entire document. It will be
better if a filter like are_words_consecutive(tsve
Howard Cole <[EMAIL PROTECTED]> writes:
> I have the following table in a win32 8.2.2 database: (dumped from pgadmin)
> ...
> What has gone wrong?
You're using a broken release :-(
http://www.postgresql.org/docs/8.2/static/release-8-2-3.html
regards, tom lane
Hi All,
I'm new to this list.
I've set up postgreSQL on windows about 4 times since the first 8.x
series came out. The first time it was 8.0 beta3 IIRC. I believe I've
installed another in the 8.0 series, then a 8.1 then just a couple of
weeks ago 8.2.4. Every time I run into the same prob
> On 10/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
>> ... In tsearch2 we have get_covers() function,
>> which produces all excerpts like:
I had not realized till just now that the 8.3 core version of tsearch
omitted any material feature of contrib/tsearch2. Why was get_covers()
left out?
Hi,
I would like to know how many active connections exist.
Is necessary show the number ip of client.
Please, somebody knows?
Thanks!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/
am Tue, dem 30.10.2007, um 14:51:33 -0300 mailte João Paulo Zavanela folgendes:
> Hi,
>
> I would like to know how many active connections exist.
> Is necessary show the number ip of client.
ask pg_stat_activity
(select * from pg_stat_activity;)
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz
Does anyone have a .vim file that takes dollar quoting into account?
I've tried the one mentioned at
http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
it doesn't appear to understand dollar quotes.
--
Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give you
On Tue, 2007-10-30 at 08:25 -0600, Brian Wipf wrote:
> I'm trying to take a base backup from the standby server in archive
> recovery mode. I don't believe it's possible to connect to it to issue
> pg_start_backup/pg_stop_backup.
>
> http://www.postgresql.org/docs/current/interactive/warm-sta
On Tue, 30 Oct 2007, Tom Lane wrote:
On 10/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
... In tsearch2 we have get_covers() function,
which produces all excerpts like:
I had not realized till just now that the 8.3 core version of tsearch
omitted any material feature of contrib/tsearch2.
Yves Moisan wrote:
Hi All,
I'm new to this list.
I've set up postgreSQL on windows about 4 times since the first 8.x
series came out. The first time it was 8.0 beta3 IIRC. I believe
I've installed another in the 8.0 series, then a 8.1 then just a
couple of weeks ago 8.2.4. Every time I ru
As I have a vested interest in storing AutoCad stuff in PostgreSQL, I
searched for something like this a while ago and I ran across this..
I haven't really had a chance to play with it yet
http://sourceforge.net/projects/dxf2postgis/
I'm personally interested in the idea of versioning for
On 30-Oct-07, at 2:42 PM, Simon Riggs wrote:
It's safest to shutdown the standby first, take a backup then crank it
up again.
It's possible to do it online in the way you suggest, but only when
running with either full_page_writes = on or when making the backup
with
rsync, or another method t
Ilan Volow wrote on 30.10.2007 23:01:
I'm personally interested in the idea of versioning for a drawing.
Instead of storing the entire drawing for each version, one could
theoretically just store the vector additions/changes/deletions that
happen from one revision to the next.
Which could als
I am using md5. OK. thanks for the clue... Now, for the root certificate
anyone? :)
regards,
dotyet
On 10/30/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> "Dot Yet" <[EMAIL PROTECTED]> writes:
> > I am seeing this "Connection reset by peer" message in the
> > postmaster.logfile, but the connec
Thanks Ilan this looks promising.
Bob
- Original Message -
From: Ilan Volow
To: pgsql-general@postgresql.org
Sent: Tuesday, October 30, 2007 3:01 PM
Subject: Re: [GENERAL] PostgreSQL and AutoCad
As I have a vested interest in storing AutoCad stuff in PostgreSQL, I
searc
Hi,
I would like to generate with a request a SQL order like
UPDATE tab1
SET col_a = ?, col_b = ? ...
WHERE pk = ?
for each table of a given schema (in fact what I want is slightly more
complicated but if I can write the above, I will be able to get the rest).
Will anyone be kind enough to sh
On Thu, Oct 25, 2007 at 09:22:02AM -0300, Evandro Andersen wrote:
> In Oracle you can use this:
>
> DELETE FROM A WHERE A1 = 10 ORDER BY A2
>
> There is something in the Postgresql ?
Yes.
DELETE...USING :)
http://www.postgresql.org/docs/current/static/sql-delete.html
Cheers,
David.
--
David
Hi all,
I was trying to create function in postgres, but it returns error mentioning
the language is NOT defined.
The function is as following:
CREATE OR REPLACE FUNCTION test_word_count(TEXT, TEXT) RETURNS INTEGER AS $$
DECLARE
d_word ALIAS FOR $1;
d_phrase ALIAS FOR $2;
BEGIN
IF d_word IS
carter ck wrote:
> Hi all,
>
> I was trying to create function in postgres, but it returns error mentioning
> the language is NOT defined.
>
> The function is as following:
>
> CREATE OR REPLACE FUNCTION test_word_count(TEXT, TEXT) RETURNS INTEGER AS $$
> DECLARE
> d_word ALIAS FOR $1;
> d_phras
On Wed, Oct 31, 2007 at 11:07:36AM +0800, carter ck wrote:
> Hi all,
>
> I was trying to create function in postgres, but it returns error mentioning
> the language is NOT defined.
> ERROR: language "plpgsql" does not exist
> HINT: Use CREATE LANGUAGE to load the language into the database.
>
You can also create the language in template1 and then you'll have it in any
other database you'll create (from template1).
Il Wednesday 31 October 2007 08:21:08 Martijn van Oosterhout ha scritto:
> On Wed, Oct 31, 2007 at 11:07:36AM +0800, carter ck wrote:
> > Hi all,
> >
> > I was trying to c
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
>>> On Wed, Oct 31, 2007 at 4:07 AM, in message
<[EMAIL PROTECTED]>, carter ck
<[EMAIL PRO
50 matches
Mail list logo
