Hi!
I tried to write a recursive SELECT, that would do the concatination, but a
problem appeared:
can't make a {1,2,3} from {{1,2,3}}.
Here are some experiments:
---
postgres=# select array[array[1,2,3
On 29/04/10 11:02, Andreas wrote:
Hi,
I've got an 8.4.3 Unicode DB that accidentally holds a few records with
characters that can't be converted to Latin1 or 9 for output to CSV.
I'd just need a way to check if a collumn contains values that CAN NOT
be converted from Utf8 to Latin1 to select al
Hi,
I've got an 8.4.3 Unicode DB that accidentally holds a few records with
characters that can't be converted to Latin1 or 9 for output to CSV.
I'd just need a way to check if a collumn contains values that CAN NOT
be converted from Utf8 to Latin1 to select all those affected records.
I tr
On 29/04/2010 10:04 AM, Greg Smith wrote:
Jaime Rodriguez wrote:
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
[snip]
If most connections are read-only, there are a few ways to design a
cluster of sy
Jaime Rodriguez wrote:
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
In order to support 4000 true simultaneous requests, you'd need 4000
processor cores available. What you probably mean here is t
On Wed, Apr 28, 2010 at 8:08 PM, Jaime Rodriguez
wrote:
> hi,
> Today is my first day looking at PostgreSQL
> I am looking to migrate a MS SQL DB to PostgreSQL :) :)
> My customer requires that DBMS shall support 4000 simultaneous requests
and that requests come from the fantasy of some one or ar
Jaime Rodriguez wrote:
hi,
Today is my first day looking at PostgreSQL
I am looking to migrate a MS SQL DB to PostgreSQL :) :)
My customer requires that DBMS shall support 4000 simultaneous requests
thats a lot of connections and processes.
4000 concurrent queries will be generating a massiv
Piotr Kublicki wrote:
We're thinking about installing Postgres on a virtual machine (RedHat 5
64-bits), however not sure how many CPUs can be wisely assigned, without
wasting of resources.
The database will use as many cores as you have available, so long as
you have multiple simultaneous quer
hi,
Today is my first day looking at PostgreSQL
I am looking to migrate a MS SQL DB to PostgreSQL :) :)
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
>From what I have read, PostgreSQL has really good p
Muy bueno, felicitaciones!
Guido Barosio
2010/4/28 Ing. Yunior Mesa Reyes :
> Saludos,
>
> Ya está online todo lo referente al PGday Latinoamericano 2011. No te lo
> pierdas...
>
> La dirección es : http://postgresql.uci.cu/news/19
>
>
> Saludos,
> Ing.Yunior Mesa Reyes
> Postgre-SQL Empresarial.
Jorge Arevalo writes:
> My doubt is if I'm doing things right getting all the stuff I need (an
> array) in the first call, pointing user_fctx to this array and
> accessing myStructsArray[call_cntr] in each successive call, until
> myStructsArray + call_cntr == NULL (last array element?).
Sounds r
On Wed, Apr 28, 2010 at 1:39 PM, wrote:
> Good afternoon:
>
> I would like to insert some (1 or more) values from multiple rows of one
> table into an array in another table. Here's the scenario:
>
> --table to house data provided by a third party
> CREATE TABLE raw_foo (
> rf_id serial P
On Wed, Apr 28, 2010 at 7:00 PM, Tom Lane wrote:
> Jorge Arevalo writes:
>> I'm writing a SRF following the example from
>> http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (section
>> 34.9.10). In the example, in the code executed in first call, we get
>> the number of tuples to be re
Good afternoon:
I would like to insert some (1 or more) values from multiple rows of one
table into an array in another table. Here's the scenario:
--table to house data provided by a third party
CREATE TABLE raw_foo (
rf_id serial PRIMARY KEY,
cde character varying(4),
nb
On Wed, Apr 28, 2010 at 6:30 AM, Craig Ringer
wrote:
> On 28/04/10 20:20, Scott Marlowe wrote:
>
>> I was definitely referring to active connections.
>
> Sure - and I didn't mean to sound like I was trying to correct you.
> Sorry if I did. Just trying to add a little more info.
No offense taken a
Saludos,
Ya está online todo lo referente al PGday Latinoamericano 2011 . No te lo
pierdas...
La dirección es : http://postgresql.uci.cu/news/19
Saludos,
Ing.Yunior Mesa Reyes
Postgre-SQL Empresarial. DATEC
Universidad de las Ciencias Informáticas.Ciudad de la Habana. Cuba.
«"Se tu e
On Wed, Apr 28, 2010 at 5:15 AM, Piotr Kublicki wrote:
> Sorry to be a royal pain, but I cannot find it anywhere in the
> documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
> We're thinking about installing Postgres on a virtual machine (RedHat 5
> 64-bits), however not sure ho
Scott Marlowe wrote:
On Wed, Apr 28, 2010 at 3:15 AM, Piotr Kublicki wrote:
Dears,
Sorry to be a royal pain, but I cannot find it anywhere in the
documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
We're thinking about installing Postgres on a virtual machine (RedHat 5
64
Jorge Arevalo writes:
> I'm writing a SRF following the example from
> http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (section
> 34.9.10). In the example, in the code executed in first call, we get
> the number of tuples to be returned, and no more. Then, in each call,
> a new tuple i
only one namespace allowed by a authid at pg_namespace table? for in the
function:
static void recomputeNamespacePath(void){
...
if (strcmp(curname, "$user") == 0)
{
/* $user --- substitute namespace matching user name, if any */
HeapTupletuple;
tupl
Hello,
I'm writing a SRF following the example from
http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (section
34.9.10). In the example, in the code executed in first call, we get
the number of tuples to be returned, and no more. Then, in each call,
a new tuple is allocated and returned,
On 2010-04-22, Brian Peschel wrote:
>
> On 04/22/2010 10:12 AM, Ben Chobot wrote:
>> On Apr 21, 2010, at 1:41 PM, Brian Peschel wrote:
>>
>>
>>> I have a replication problem I am hoping someone has come across before and
>>> can provide a few ideas.
>>>
>>> I am looking at a configuration of
On Tue, Apr 27, 2010 at 6:42 AM, wrote:
> I am putting up a new server on version 8.4.3. I copied pg_hba.conf
> from a running 8.3.6 system, changing only the public IP address for the
> local machine.
>
> I get the error:
> FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres"
Merci!
Pete
From: Guillaume Lelarge
To: Piotr Kublicki , pgsql-general
Date: 28/04/2010 15:04
Subject:Re: [GENERAL] Start-up script for few clusters: just add water?
Le 28/04/2010 14:05, Piotr Kublicki a écrit :
> Hi Guillaume,
>
> Excellent point:
>
>> Suppose
Vincenzo Romano writes:
> 2010/4/28 Mathieu Rozieres :
>> Le 27/04/2010 21:34, Howe, Jeffrey a écrit :
>> Due to increase in phishing attacks, we are currently working to improve on
>> the security of all Email Accounts as we periodically review certain
> It sounds either like phishing or like an
Le 28/04/2010 14:05, Piotr Kublicki a écrit :
> Hi Guillaume,
>
> Excellent point:
>
>> Suppose I have a second cluster. I'll have to do this :
>>
> cd /etc/init.d
> cp postgresql postgresql2
> cd /etc/sysconfig/pgsql
> cp postgresql postgresql2
> $EDITOR postgresql2
>
> In $EDITOR, I'll change
On Tue, Apr 27, 2010 at 11:32 PM, Greg Smith wrote:
> What do you mean by an instance failure here? The actual EC2 image getting
> corrupted so that it won't boot anymore, or just the instance going down
> badly?
The instance going down, badly. The last time it happened, what logs
I was able to
On 28/04/10 20:20, Scott Marlowe wrote:
> I was definitely referring to active connections.
Sure - and I didn't mean to sound like I was trying to correct you.
Sorry if I did. Just trying to add a little more info.
--
Craig Ringer
Tech-related writing: http://soapyfrogs.blogspot.com/
--
Sen
On Wed, Apr 28, 2010 at 6:14 AM, Craig Ringer
wrote:
> On 28/04/10 18:25, Scott Marlowe wrote:
>> On Wed, Apr 28, 2010 at 3:15 AM, Piotr Kublicki
>> wrote:
>>>
>>> Dears,
>>>
>>> Sorry to be a royal pain, but I cannot find it anywhere in the
>>> documentation: how many threads/CPU cores Postgres
On 28/04/10 18:25, Scott Marlowe wrote:
> On Wed, Apr 28, 2010 at 3:15 AM, Piotr Kublicki
> wrote:
>>
>> Dears,
>>
>> Sorry to be a royal pain, but I cannot find it anywhere in the
>> documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
>> We're thinking about installing Postgre
Hi Guillaume,
Excellent point:
> Suppose I have a second cluster. I'll have to do this :
>
cd /etc/init.d
cp postgresql postgresql2
cd /etc/sysconfig/pgsql
cp postgresql postgresql2
$EDITOR postgresql2
In $EDITOR, I'll change the different environment values I want. For
example:
>PGPORT=5567
>P
On Wed, 2010-04-28 at 13:34 +0200, Ognjen Blagojevic wrote:
>
> How can I check if SSL is enabled in Postgres releases hosted at YUM
> repository [1]?
Yes, they are enabled.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpm
Hi,
How can I check if SSL is enabled in Postgres releases hosted at YUM
repository [1]?
-Ognjen
[1] http://yum.pgsqlrpms.org/reporpms/repoview/pgdg-centos.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
On Wed, Apr 28, 2010 at 3:15 AM, Piotr Kublicki wrote:
>
> Dears,
>
> Sorry to be a royal pain, but I cannot find it anywhere in the
> documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
> We're thinking about installing Postgres on a virtual machine (RedHat 5
> 64-bits), howeve
Thanks a lot Alban. That was simple!
On Sat, Apr 24, 2010 at 10:15 PM, Alban Hertroys <
dal...@solfertje.student.utwente.nl> wrote:
> > If I remove the braces from (\$1, \$2, \$3) then it gives below error.
> >
> > my $query = (< > INSERT INTO changelogtest(id, txid, txtime)
> > SELECT \$1,
On 28/04/10 17:15, Piotr Kublicki wrote:
>
>
>
> Dears,
>
> Sorry to be a royal pain, but I cannot find it anywhere in the
> documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
> We're thinking about installing Postgres on a virtual machine (RedHat 5
> 64-bits), however not s
2010/4/28 Mathieu Rozieres :
> Le 27/04/2010 21:34, Howe, Jeffrey a écrit :
>
>
> Due to increase in phishing attacks, we are currently working to improve on
> the security of all Email Accounts as we periodically review certain
It sounds either like phishing or like an automated response due to
s
Dears,
Sorry to be a royal pain, but I cannot find it anywhere in the
documentation: how many threads/CPU cores Postgres v. 8.4 can utilise?
We're thinking about installing Postgres on a virtual machine (RedHat 5
64-bits), however not sure how many CPUs can be wisely assigned, without
wasting of
Le 27/04/2010 21:34, Howe, Jeffrey a écrit :
>
> Due to increase in phishing attacks, we are currently working to
> improve on the security of all Email Accounts as we periodically
> review certain accounts which are vulnerable to Unauthorised Access.
> We have noticed some unusual invalid login
On Wed, Apr 28, 2010 at 09:18, Dave Page wrote:
> On Wed, Apr 28, 2010 at 8:11 AM, Chris Velevitch
> wrote:
>> On Wed, Apr 28, 2010 at 14:36, Greg Smith wrote:
>>> Chris Velevitch wrote:
I was just checking
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy and
I ge
On Wed, Apr 28, 2010 at 8:11 AM, Chris Velevitch
wrote:
> On Wed, Apr 28, 2010 at 14:36, Greg Smith wrote:
>> Chris Velevitch wrote:
>>> I was just checking
>>> http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy and
>>> I get a connection time out.
>>> Is the site down?
>>
>> I'm n
On Wed, Apr 28, 2010 at 14:36, Greg Smith wrote:
> Chris Velevitch wrote:
>> I was just checking
>> http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy and
>> I get a connection time out.
>> Is the site down?
>
> I'm not sure if it's down or not, but I haven't been able to reach it f
42 matches
Mail list logo
