Heyho!
On Sunday 27 June 2010 08.22:09 RP Khare wrote:
> I downloaded PostgreSQL plus advanced server from EnterpriseDB website.
> Should I go with the original community PGSQL edition or EnterpriseDB
> edition?
If you work on a Linux/BSD/... OS distribution with a sane package manager,
I always
On Tue, 2010-06-29 at 09:37 +0200, dario@libero.it wrote:
> Hi guys,
>
> Thanks for taking time to reply.
>
> - Despite what the error message says, the user postgres doesn't have
> administrator privileges (and I don't see why these would change by retyping
> the password).
> - In Control
> I haven't consumed enough caffeine today to recall the details, but
> I think you could have ended up with default expressions like the above
> if the database had been dumped and reloaded from 8.0 or earlier.
> nextval(regclass) was introduced in 8.1 precisely to solve this type
> of problem.
>
On Tue, Jun 29, 2010 at 4:00 PM, sam mulube wrote:
> Alternatively we wondered about partitioning by the server_id foreign
> key, using for example the modulo of the foreign key id. This would
> give us a finite number of partitions (rather than the potentially
> unbounded date option), and would
I am stumped, despite working on this for a week! I am trying to create a
64-bit postgresql 8.4 database server which can retrieve data from various
64-bit Oracle 10gR2 and 11gR2 databases.
- I have a freshly-installed 64-bit Centos 5.5, no firewall, no SELinux.
- I create an oracle user an
Tom Lane wrote:
Adrian Klaver writes:
On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote:
dropdb: could not connect to database postgres: FATAL: database
"postgres" does not exist
Why is it not 'seeing' the database name I'm passing to it? Why is it
trying to drop a database named postgres??
Hi,
we are considering database partitioning as a possible solution to
some performance issues we are having with our database, and we are
trying to decide on a partitioning scheme. We have a moderately write
heavy application (approx 50 inserts per second, with writes
outnumbering reads by roughl
Adrian Klaver writes:
> On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote:
>> dropdb: could not connect to database postgres: FATAL: database
>> "postgres" does not exist
>>
>> Why is it not 'seeing' the database name I'm passing to it? Why is it
>> trying to drop a database named postgres??
>
On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote:
> So running the following command:
>
> dropdb -p 5443 swr
>
> I get:
>
> dropdb: could not connect to database postgres: FATAL: database
> "postgres" does not exist
>
> Why is it not 'seeing' the database name I'm passing to it? Why is it
> tryi
On Tue, Jun 29, 2010 at 4:04 PM, Geoffrey wrote:
> So running the following command:
>
> dropdb -p 5443 swr
>
> I get:
>
> dropdb: could not connect to database postgres: FATAL: database "postgres"
> does not exist
>
> Why is it not 'seeing' the database name I'm passing to it? Why is it
> tryin
So running the following command:
dropdb -p 5443 swr
I get:
dropdb: could not connect to database postgres: FATAL: database
"postgres" does not exist
Why is it not 'seeing' the database name I'm passing to it? Why is it
trying to drop a database named postgres??
--
Until later, Geoffrey
On Tue, Jun 29, 2010 at 9:44 AM, erobles wrote:
> Hi!
>
> I have 3 pc's:
> pc 'A' with postgres 7.2 running
> pc 'B' and 'C' connected to 'A'
>
> if i made the next query on 'B' or 'C' : "select * from detail with
> id=72"; takes too long time to return the data, near of 10 minutes more
On 06/29/2010 10:19 AM, Adrian Klaver wrote:
On Tuesday 29 June 2010 7:47:32 am erobles wrote:
Hi!, thanks for your answer
How many results are being returned for id=72 vs other ids?
the tuples returned for id=72 are 91 (is too short :-( ), for id=71
are 94 for id=10 a
On Tuesday 29 June 2010 7:47:32 am erobles wrote:
>
> Hi!, thanks for your answer
>
> > How many results are being returned for id=72 vs other ids?
>
> the tuples returned for id=72 are 91 (is too short :-( ), for id=71
> are 94 for id=10 are 44.
>
> > How are 'B' and 'C' connecting to 'A'; psq
Hi list !
We have a database in UTF8, from which we have to export text files in
LATIN9 encoding (or WIN1252, which is almostthe same I believe).
Records are entered via MSAccess forms (on psqlodbc-linked tables).
The problem is that some of the characters input by the users have no
equivalen
John R Pierce wrote:
On 06/26/10 11:22 PM, RP Khare wrote:
I downloaded PostgreSQL plus advanced server from EnterpriseDB
website. Should I go with the original community PGSQL edition or
EnterpriseDB edition?
thats entirely up to your preferences and needs.Personally, I think
that the s
Sim Zacks writes:
>> id integer NOT NULL DEFAULT
>> nextval(('public.tblname_id_seq'::text)::regclass)
> Shouldn't this change automatically as well?
It would have changed automatically if the default expression were what
it's supposed to be, namely nextval('sequencename'::regclass). What
you'v
Hi!
I have 3 pc's:
pc 'A' with postgres 7.2 running
pc 'B' and 'C' connected to 'A'
You should upgrade as quickly as possible. 7.2 is ancient. Even 8.1 will
hit end-of-life soon.
We are testing postgres 8.3.11 to detect any problem when we migrate
from 7.2 :
On Tuesday 29 June 2010 7:22:56 am erobles wrote:
> Original Message
> Subject: Re: [GENERAL] Weird trouble with select
> Date: Tue, 29 Jun 2010 09:13:14 -0500
> From: erobles
> Organization: SENSA Control Digital
> To: Joshua Tolley
>
> On 06/29/2
Kelly Burkhart writes:
> The crash left a core file, does the stack trace indicate anything crucial?
> (gdb) where
> #0 0x0068d884 in SearchCatCacheList ()
> #1 0x0001 in ?? ()
> #2 0x00bbcbe0 in ?? ()
> #3 0x7f3b3a86a580 in ?? ()
> #4 0x72ddbea20068dae0 in ??
Original Message
Subject:Re: [GENERAL] Weird trouble with select
Date: Tue, 29 Jun 2010 09:13:14 -0500
From: erobles
Organization: SENSA Control Digital
To: Joshua Tolley
On 06/29/2010 08:59 AM, Joshua Tolley wrote:
On Tue, Jun 29, 2010 at 08:44:35AM -0
Hello,
We had a backend crash this morning. Version is PostgreSQL 8.4.2
running on openSuSE 11.2. This machine is connected via iSCSI to a
Dell Equallogic array. We've been running 8.4.2 since February (I
believe) without issue, although we've recently upgraded this machine
from 24G to 72G RAM.
On Tue, Jun 29, 2010 at 08:44:35AM -0500, erobles wrote:
> Hi!
>
> I have 3 pc's:
> pc 'A' with postgres 7.2 running
> pc 'B' and 'C' connected to 'A'
You should upgrade as quickly as possible. 7.2 is ancient. Even 8.1 will hit
end-of-life soon.
> if i made the next query on 'B' or 'C' : "
On 6/29/2010 4:24 PM, A. Kretschmer wrote:
> In response to Scott Marlowe :
>
>> On Tue, Jun 29, 2010 at 8:20 AM, A. Kretschmer
>> wrote:
>>
>>>
>>> Just for info: works well with 8.4:
>>>
>> Works in 8.3.9 on ubuntu 9.10...
>>
>>
> I think, this is the problem:
> You have cr
Hi!
I have 3 pc's:
pc 'A' with postgres 7.2 running
pc 'B' and 'C' connected to 'A'
if i made the next query on 'B' or 'C' : "select * from detail with
id=72"; takes too long time to return the data, near of 10 minutes
more or less.
if i made the next query on 'B' or 'C' : "sele
On Wed, Jun 23, 2010 at 05:17:13PM -0400, John DeSoi wrote:
> Any chance that the Parrot runtime could be used for PHP and other
> languages? I read that some folks are working on PL/Parrot. I'd really like
> to have PHP and Lisp for PL languages :).
Some folks are definitely working on it. The id
On Tue, Jun 22, 2010 at 07:07:33AM -0400, Geoffrey wrote:
> A couple of questions regarding pgpool:
>
> Is there a problem with using multiple connection pools for the same
> database? Point being, we might want to give a higher number of
> connections to one group of users then another. I ca
In response to Scott Marlowe :
> On Tue, Jun 29, 2010 at 8:20 AM, A. Kretschmer
> wrote:
> >
> >
> > Just for info: works well with 8.4:
>
> Works in 8.3.9 on ubuntu 9.10...
>
I think, this is the problem:
You have created the table first and later the sequence, like this:
test=# create table
On 6/29/2010 3:49 PM, Scott Marlowe wrote:
> On Tue, Jun 29, 2010 at 8:20 AM, A. Kretschmer
> wrote:
>
>> In response to Sim Zacks :
>>
>>> I am using 8.2.17
>>>
>>> I added a new schema and moved tables into it using
>>>
>>> ALTER TABLE tblname SET SCHEMA newschema;
>>>
>>>
>>> This mov
> -Original Message-
> From: dario@libero.it [mailto:dario@libero.it]
> Sent: Tuesday, June 29, 2010 3:38 AM
> To: vibhor.ku...@enterprisedb.com; Igor Neyman
> Cc: pgsql-general@postgresql.org
> Subject: R: Re: [GENERAL] postgres user password: Log on failure
>
> Hi guys,
>
>
Le 29/06/2010 14:40, Sam Mason a écrit :
On Tue, Jun 29, 2010 at 02:24:00PM +0200, Arnaud Lesauvage wrote:
I'd like to generate CSV files from the output of a query.
I can't get the srings in the output to be quoted though. I thought that
this was the default for CSV, and even adding the "QUO
On Tue, Jun 29, 2010 at 8:20 AM, A. Kretschmer
wrote:
> In response to Sim Zacks :
>> I am using 8.2.17
>>
>> I added a new schema and moved tables into it using
>>
>> ALTER TABLE tblname SET SCHEMA newschema;
>>
>>
>> This moves the sequences referred to by the table to the new schema as
>> is sp
On Tue, Jun 29, 2010 at 02:24:00PM +0200, Arnaud Lesauvage wrote:
> I'd like to generate CSV files from the output of a query.
> I can't get the srings in the output to be quoted though. I thought that
> this was the default for CSV, and even adding the "QUOTE" parameter does
> not help :
>
> p
Hi all,
I'd like to generate CSV files from the output of a query.
The files must be generated on the client, so I was planning on using
psql \copy command.
I can't get the srings in the output to be quoted though. I thought that
this was the default for CSV, and even adding the "QUOTE" paramet
In response to Sim Zacks :
> I am using 8.2.17
>
> I added a new schema and moved tables into it using
>
> ALTER TABLE tblname SET SCHEMA newschema;
>
>
> This moves the sequences referred to by the table to the new schema as
> is specified by the manual.
>
> > Associated indexes, constraints,
I am using 8.2.17
I added a new schema and moved tables into it using
ALTER TABLE tblname SET SCHEMA newschema;
This moves the sequences referred to by the table to the new schema as
is specified by the manual.
> Associated indexes, constraints, and sequences owned by table columns
> are moved
On Tue, Jun 29, 2010 at 3:23 PM, Vibhor Kumar wrote:
> On 28/06/10 11:14 PM, raghu ram wrote:
>
>>
>> Hi,
>>
>>
>>
>> We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
>> facing the below error while running the select queries in the application
>> side::
>>
>>
>> ERROR:
Hi guys,
Thanks for taking time to reply.
- Despite what the error message says, the user postgres doesn't have
administrator privileges (and I don't see why these would change by retyping
the password).
- In Control Panel -> Administrative Tools -> Computer Manager -> Users ->
postgres I see
Hi,
I need to rework a custom notification scheme that sends TCP
messages about new/modified/deleted records to an external process.
It's obvious that I am using RegisterXactCallback() to do that.
The problem is with prepared transactions. I get XACT_EVENT_PREPARE
in the XactCallback function, whe
39 matches
Mail list logo
