On Fri, Jul 3, 2009 at 10:02 PM, Roseller A. Romanos wrote:
> Hi,
>
> I really have a serious problem with this. I hope you could give me some
> insights on how to possibly solve this problem. I have installed a new copy
> of postgres in my PC using Windows XP OS and I have copy the data folder i
On Sat, Jul 4, 2009 at 12:22 AM, Pavel Stehule wrote:
> 2009/7/4 Scott Marlowe :
>> On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehule
>> wrote:
>>> 2009/7/4 Scott Marlowe :
On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule
wrote:
> 2009/7/4 Roseller A. Romanos :
>> Hi,
>>
>>
2009/7/4 Scott Marlowe :
> On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehule wrote:
>> 2009/7/4 Scott Marlowe :
>>> On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule
>>> wrote:
2009/7/4 Roseller A. Romanos :
> Hi,
>
> I really have a serious problem with this. I hope you could give me
On Sat, Jul 4, 2009 at 12:12 AM, Pavel Stehule wrote:
> 2009/7/4 Scott Marlowe :
>> On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule
>> wrote:
>>> 2009/7/4 Roseller A. Romanos :
Hi,
I really have a serious problem with this. I hope you could give me some
insights on how to poss
2009/7/4 Scott Marlowe :
> On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule wrote:
>> 2009/7/4 Roseller A. Romanos :
>>> Hi,
>>>
>>> I really have a serious problem with this. I hope you could give me some
>>> insights on how to possibly solve this problem. I have installed a new copy
>>> of postgr
On Fri, Jul 3, 2009 at 10:40 PM, Pavel Stehule wrote:
> 2009/7/4 Roseller A. Romanos :
>> Hi,
>>
>> I really have a serious problem with this. I hope you could give me some
>> insights on how to possibly solve this problem. I have installed a new copy
>> of postgres in my PC using Windows XP OS a
2009/7/4 Roseller A. Romanos :
> Hi,
>
> I really have a serious problem with this. I hope you could give me some
> insights on how to possibly solve this problem. I have installed a new copy
> of postgres in my PC using Windows XP OS and I have copy the data folder in
> my previous installation
Hi,
I really have a serious problem with this. I hope you could
give me some insights on how to possibly solve this problem. I have
installed a new copy of postgres in my PC using Windows XP OS and I have copy
the data folder in my previous installation from the
other PC, my problem is that I c
On Fri, Jul 03, 2009 at 05:37:20PM -0700, Reece Hart wrote:
> On Fri, 2009-07-03 at 11:29 -0700, David Fetter wrote:
>
> > I'm missing what you're doing here that foreign keys don't cover.
> > Could you send along your DDL?
>
> No DDL yet... I'm just in the thinking stages. FKs technically would
On Fri, 2009-07-03 at 11:29 -0700, David Fetter wrote:
> I'm missing what you're doing here that foreign keys don't cover.
> Could you send along your DDL?
No DDL yet... I'm just in the thinking stages. FKs technically would do
it, but would become unwieldy. The intention was to have subclasses o
On Thu, 2009-07-02 at 19:19 -0700, Nathan Boley wrote:
> Is an association, for example, an experiment that establishes a
> dependent relationship? So could there be multiple associations
> between variant and phenotype?
Exactly. You might have one group say that allele X "causes" some trait,
whe
Peter Eisentraut wrote:
On Friday 03 July 2009 06:09:37 Scott Bailey wrote:
I'm having trouble installing plpython in 8.4. I tried under Windows
(one click installer from EDB) and under Ubuntu (linux binary). In both
cases I was told:
could not load library 8.4/lib/postgresql/plpython.(so|dll)
In addition to the amount of data that will be captured, you will need
take in to consideration how often each user will be accessing this
data as well as the number of users. For example, if you have 10 users
running the query once an hour every hour of the day, you might get
away with calculati
James B. Byrne wrote:
Hi,
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4; 2615 2200 SCHEMA
public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: cannot
drop
schema public because other objects depend on it
HINT:
i just asked NASA the same question
I'll post the answer back to the list..
Martin Gainty
We can lick gravity, but sometimes the paperwork is overwhelming.
- Wehrner Von Braun
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Joost Kraaijeveld wrote:
Hi,
Hi,
Is it possible to get an overview/the contents of the stopwords list,
dictionary, synonyms or thesaurus using an SQL query, e.g. "SELECT *
from stopwords"?
if I understand correctly, you want to see the content of the
dictionarys. No - you can't see the ent
On Thu, Jul 02, 2009 at 01:54:04PM -0700, Reece Hart wrote:
> This is a question about data modeling with inheritance and a way to
> circumvent the limitation that primary keys are not inherited.
I'm missing what you're doing here that foreign keys don't cover.
Could you send along your DDL?
Just
If it's static (i.e. the planets don't move too much, hah), calculate
and store. No sense in re-calculating it each and every time.
Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549- x4294
> -Original Message-
> From: pgsql-general-o
I have a table which stores the absolute longitude of a planetary position, eg:
MERCURY
---
157.65
SATURN
-
247.65
When 2 planets are a certain distance apart there is an 'aspect', eg. 90 degrees is a
"square" aspect
I wish to record these aspects for different user pr
Actually, since pgsql does not rely on the names but rather the position of the
columns returned to fill the returned table, it would be better to use
something like
CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (rv_id INT8,
rv_test VARCHAR)
AS $$
BEGIN
-- @todo hide pass
Hello,
Le 3/07/09 12:53, Dimitri Fontaine a écrit :
Hi,
Le 3 juil. 09 à 11:44, Jennifer Trey a écrit :
I would like to run a query and group several rows based on a phone
number.
However, the same phone number might have a prefix on occasion, example :
name | phone_number
2009/7/3 Tom Lane :
> Michal Szymanski writes:
>> CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
>> test VARCHAR)
>> AS $$
>> BEGIN
>> -- @todo hide password
>> RETURN QUERY
>> SELECT id ,test
>> FROM bug_table
>> ;
>> END;
>> $$
>> LANGUA
Michal Szymanski writes:
> CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
> test VARCHAR)
> AS $$
> BEGIN
> -- @todo hide password
> RETURN QUERY
> SELECT id ,test
> FROM bug_table
> ;
> END;
> $$
> LANGUAGE plpgsql STRICT SECURITY DEFINER
Hello!
I got into a situation I don't know how the get out ..
First, I could not access to my biggest database in postgre anymore
because it suddenly gave the error (after long time working with no
problems)
ERROR: could not open relation 1663/392281/530087: No such file
or directory
Af
I'written something like this:
CREATE TABLE "bug_table" (
"id" BIGINT NOT NULL,
test VARCHAR,
CONSTRAINT "test_table_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;
INSERT INTO bug_table (id,test) VALUES (1,'test');
select * from bug_table;
CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TAB
unsubscribe-pattern-allmatching LISTNAME ALL
Ing. Raúl Rojas Galván
Administrador de Sistemas
Hi Andreas,
I'm afraid fulltext search won't fit our app here. Our application
tags each record with "source flags", which is a text[] of strings
that describes where the record came from. These flags are already
passed into the application when we store the records. So we can
simply store them a
On 2009-07-02, Michaël Lemaire wrote:
> Richard Huxton wrote:
>
>> Michaël Lemaire wrote:
>> > Hi all.
>> >
>> > I've come across a problem with delete cascade.
>> >
>> > I have three tables A, B and C.
>> > Table B has a foreign key on A with delete cascade.
>> > Table C has a foreign key on B
Hi,
Le 3 juil. 09 à 11:44, Jennifer Trey a écrit :
I would like to run a query and group several rows based on a phone
number.
However, the same phone number might have a prefix on occasion,
example :
name | phone_number
--
james | 123456
james | 00441234556
as you can s
On Fri, Jul 3, 2009 at 8:32 PM, Guy Flaherty wrote:
>
>
> On Fri, Jul 3, 2009 at 7:44 PM, Jennifer Trey wrote:
>
>> Hi,
>>
>> I would like to run a query and group several rows based on a phone
>> number.
>>
>> However, the same phone number might have a prefix on occasion, example :
>>
>> name |
On Fri, Jul 3, 2009 at 7:44 PM, Jennifer Trey wrote:
> Hi,
>
> I would like to run a query and group several rows based on a phone number.
>
> However, the same phone number might have a prefix on occasion, example :
>
> name | phone_number
> --
> james | 123456
> james | 00441
Could someone look into this?
Since I do not believe we should condone this.
This is what I got when I sent a message to the list.
At least, I do not like these personally.
If I was wrong with this, then I apologise up front.
If I need to send these kinds of remarks elsewhere, please provide me
wit
What is the output you are trying to achieve?
> However, the same phone number might have a prefix on occasion, example :
>
> name | phone_number
> --
> james | 123456
> james | 00441234556
> james | 555666
> sarah | 567890
> sarah | 567890
>
> as you can see, the first 2 James
Hi,
I would like to run a query and group several rows based on a phone number.
However, the same phone number might have a prefix on occasion, example :
name | phone_number
--
james | 123456
james | 00441234556
james | 555666
sarah | 567890
sarah | 567890
as you can see, th
Hi,
Is it possible to get an overview/the contents of the stopwords list,
dictionary, synonyms or thesaurus using an SQL query, e.g. "SELECT *
from stopwords"?
Is it possible to add or remove entries from the dictionaries using SQL?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraa
John Cheng schrieb:
---
For some reason, I am seeing a big difference in our real database. I
don't want to just rewrite all of our queries yet. I'm guessing the
data makes a big difference. What would be a good way to examine the
data to figure out what's the best way to write our queri
On Friday 03 July 2009 06:09:37 Scott Bailey wrote:
> I'm having trouble installing plpython in 8.4. I tried under Windows
> (one click installer from EDB) and under Ubuntu (linux binary). In both
> cases I was told:
> could not load library 8.4/lib/postgresql/plpython.(so|dll)
>
> Both systems ha
37 matches
Mail list logo
