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
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
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:
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
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,
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
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
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
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
> -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,
>
>
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
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 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
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
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 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
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' : "
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.
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
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 ??
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
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 :
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
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
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
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
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 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
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 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
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
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
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??
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
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 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, 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
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
39 matches
Mail list logo
