On Wed, Feb 20, 2013 at 2:34 PM, Nathan Boley wrote:
> I'm trying to store exons that must fit within a chromosome, but the
> chromosomes all have different lengths, so I want a check constraint
> so that location is contained within CHR_RANGE where CHR_RANGE is
> taken from the chromosomes table.
On Feb 20, 2013, at 5:42 PM, Adrian Klaver wrote:
> On 02/19/2013 07:04 PM, NiRE wrote:
>> All of a sudden my macbook pro force quit and when I restarted it it is
>> run by user PostgreSQL user - i do not know the password and cannot
>> change it. I cannot find out online how to fix this back. A
On Wed, Feb 20, 2013 at 9:31 AM, Christian Schröder wrote:
> after some investigation it seems that the error has to do with a domain
> type that we have defined in our database. We have defined the following
> helper functions:
>
...
>
> CREATE DOMAIN isin AS char(12) CHECK (isin_ok(value));
Co
On Mon, Feb 18, 2013 at 3:59 PM, komunca wrote:
> Just to say it in another way: Is there a way to dynamically add database to
> PgBouncer
Yes it is possible to do. You need to add the following to the
[databases] section in your pgbouncer config file.
* = host=localhost
>From the pgbouncer doc
On 02/19/2013 07:04 PM, NiRE wrote:
All of a sudden my macbook pro force quit and when I restarted it it is
run by user PostgreSQL user - i do not know the password and cannot
change it. I cannot find out online how to fix this back. Any help would
be much appreciated and also as soon as possible
Is it possible to use PgBouncer in this scenario:
User comes to my WA, and opens new account. In that case I create a new
database for that user.
I noticed that in PgBouncer config file I have to set a database line, so
I'm confused Is there any way to deal with this problem?
Just to say it in
All of a sudden my macbook pro force quit and when I restarted it it is run
by user PostgreSQL user - i do not know the password and cannot change it.
I cannot find out online how to fix this back. Any help would be much
appreciated and also as soon as possible. Thank you.
Erin
On 19/02/13 22:05, Jan Strube wrote:
we have a Java daemon that´s repeatedly calling a Perl function inside
our database (version 9.1.8). The function is called about 200 times per
second. While the Java program is running you can watch the memory usage
of the postmaster grow continuously until a
On Feb 20, 2013, at 17:51, ChoonSoo Park wrote:
> Sorry,
>
> It's not ordered by value. It's not sorted list unfortunately. It can be
> '{100, 120, 102, 130, 104}'.
Are you saying it's an unordered list for which the order matters? That seems a
bit peculiar.
What would probably work is to sp
>Moving the exclusion operation up a level seems to do the trick:
>
>testdb=# BEGIN ;
>BEGIN
>testdb=*# update tableA set f2 = (select array_agg(X.id) from (select f1,
>unnest(f2) id from tablea where f1 = 1) x WHERE x.id != 101) where f1=1;
>UPDATE 1 testdb=*# SELECT * from tablea ;
> f1 |
On 19.02.2013 12:41, Tom Lane wrote:
Jan Strube writes:
we have a Java daemon that´s repeatedly calling a Perl function inside
our database (version 9.1.8). The function is called about 200 times per
second. While the Java program is running you can watch the memory usage
of the postmaster gro
2013/2/21 Russell Keane
>
>
>
> >>Sorry,
>
> >>
>
> >>It's not ordered by value. It's not sorted list unfortunately. It can be
> >>'{100, 120, 102, 130, 104}'.
>
> >>
>
> >>Do you have other suggestion?
>
> >>
>
> >>Thank you,
>
> >>Choon Park
>
> >
>
> >This should work:
>
> >update a set f2 = (
It works!
Thank you,
Choon Park
On Wed, Feb 20, 2013 at 12:06 PM, Russell Keane wrote:
> ** **
>
> >>Sorry,
>
> >>** **
>
> >>It's not ordered by value. It's not sorted list unfortunately. It can
> be '{100, 120, 102, 130, 104}'.
>
> >>** **
>
> >>Do you have other suggestion?
>
> >>
>>Sorry,
>>
>>It's not ordered by value. It's not sorted list unfortunately. It can be
>>'{100, 120, 102, 130, 104}'.
>>
>>Do you have other suggestion?
>>
>>Thank you,
>>Choon Park
>
>This should work:
>update a set f2 = (select array_agg(X.id) from (select f1, unnest(f2) id from
>a where f1 =
>Sorry,
>
>It's not ordered by value. It's not sorted list unfortunately. It can be
>'{100, 120, 102, 130, 104}'.
>
>Do you have other suggestion?
>
>Thank you,
>Choon Park
This should work:
update a set f2 = (select array_agg(X.id) from (select f1, unnest(f2) id from a
where f1 = 1 except sele
Sorry,
It's not ordered by value. It's not sorted list unfortunately. It can be
'{100, 120, 102, 130, 104}'.
Do you have other suggestion?
Thank you,
Choon Park
On Wed, Feb 20, 2013 at 11:47 AM, Ian Lawrence Barwick wrote:
> 2013/2/21 ChoonSoo Park
> >
> > Hello Gurus,
> >
> > Table A has int
2013/2/21 ChoonSoo Park
>
> Hello Gurus,
>
> Table A has integer[] column. I need to delete specific integer value from
> that column.
>
> f1 | f2
> 1 {100, 101, 102, 103}
> 2 {200, 300, 400}
>
> I want to remove 101 from f2 and also preserve the order.
>
> f1 |
Hello Gurus,
Table A has integer[] column. I need to delete specific integer value from
that column.
f1 | f2
1 {100, 101, 102, 103}
2 {200, 300, 400}
I want to remove 101 from f2 and also preserve the order.
f1 | f2
1 {100, 102, 103}
2 {20
Le mardi 19 février 2013 à 12:05 +0100, Jan Strube a écrit :
> Hi,
>
> we have a Java daemon that´s repeatedly calling a Perl function inside
> our database (version 9.1.8). The function is called about 200 times per
> second. While the Java program is running you can watch the memory usage
> o
19 matches
Mail list logo
