Matt first thanks for the reply,
I have check the log and it says
Relation »msysconf« existiert nicht (that it doesn’t exist.
I know that there is a setting in the pgAdmin to postgre create the table if it
not there.
But I cannot find it , do you have any idea?
Annita
-Ursprüngliche
On Sun, Sep 20, 2009 at 10:00:01PM -0400, Alvaro Herrera wrote:
> There's a definitional problem here however. When should we call the
> destructor? My impression is that it should happen when the calling
> query terminates, not when the backend shuts down. I'm sure this will
> cause other issue
The following bug has been logged online:
Bug reference: 5070
Logged by: Cedric Berger
Email address: ced...@berger.to
PostgreSQL version: 8.4.1
Operating system: Mac OS X, 10.6.1
Description:Drop cascade fails on 8.4
Details:
I've a schema with actually 409 tables
Hi,
I've a schema with actually 409 tables.
I've made a default installation of postgresql on the mac
(Installer version Version 8.4.1-1 from enterprise db).
Unfortunately, since I upgraded from 8.3, I cannot drop
these kind of schema anymore:
postgres=# drop schema hard_12 cascade
postgres-#
"Cedric Berger" writes:
> I've a schema with actually 409 tables.
> I've made a default installation of postgresql on the mac
> (Installer version Version 8.4.1-1 from enterprise db).
> Unfortunately, since I upgraded from 8.3, I cannot drop
> these kind of schema anymore:
> postgres=# drop sch
On Mon, Sep 21, 2009 at 11:05:43AM +0100, Tim Bunce wrote:
> On Sun, Sep 20, 2009 at 10:00:01PM -0400, Alvaro Herrera wrote:
> > There's a definitional problem here however. When should we call the
> > destructor? My impression is that it should happen when the calling
> > query terminates, not w
David Fetter escribió:
> Taken literally, that would mean, "the last action before the backend
> exits," but at least to me, that sounds troubling for the same reasons
> that "end of transaction" triggers do. What happens when there are
> two different END blocks in a session?
The manual is clea
Sam Mason wrote:
> On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
> > Sam Mason wrote:
> > > the deeper problem seems to be that the table was created as:
> > >
> > > create table test (a tstdom);
> > >
> > > and not as:
> > >
> > > create table test (a tstdom not null);
>
Cedric Berger wrote:
> postgres=# drop schema hard_12 cascade
> postgres-# ;
> WARNING: out of shared memory
> ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
>
> I've tried to double max_locks_per_transaction, double the values
> of SHMMAX/SHMALL
On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
> David Fetter escribió:
>
> > Taken literally, that would mean, "the last action before the
> > backend exits," but at least to me, that sounds troubling for the
> > same reasons that "end of transaction" triggers do. What happens
>
Hi,
I posted the following message to the General list a while ago. I am
still not able to run postgres at all.
I am trying to install Postgres 8.4. I had 8.3 installed. Because I
didn't have any important data, to make it easier I removed 8.3, the data
directory, removed the Postgres windows u
David Fetter escribió:
> On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
> > David Fetter escribió:
> >
> > > Taken literally, that would mean, "the last action before the
> > > backend exits," but at least to me, that sounds troubling for the
> > > same reasons that "end of transa
On Mon, Sep 21, 2009 at 12:06 PM, Alvaro Herrera
wrote:
> David Fetter escribió:
>
>> Taken literally, that would mean, "the last action before the backend
>> exits," but at least to me, that sounds troubling for the same reasons
>> that "end of transaction" triggers do. What happens when there a
On Mon, Sep 21, 2009 at 12:31 PM, Bruce Momjian wrote:
> Sam Mason wrote:
>> On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
>> > Sam Mason wrote:
>> > > the deeper problem seems to be that the table was created as:
>> > >
>> > > create table test (a tstdom);
>> > >
>> > > and n
On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
> David Fetter escribió:
> > On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
> > > David Fetter escribió:
> > >
> > > > Taken literally, that would mean, "the last action before the
> > > > backend exits," but at least
On Mon, Sep 21, 2009 at 2:17 PM, David Fetter wrote:
> On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
>> David Fetter escribió:
>> > On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
>> > > David Fetter escribió:
>> > >
>> > > > Taken literally, that would mean, "the
On Mon, Sep 21, 2009 at 02:28:11PM -0400, Robert Haas wrote:
> On Mon, Sep 21, 2009 at 2:17 PM, David Fetter wrote:
> > On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
> >> David Fetter escribió:
> >> > On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
> >> > > David
On 09/21/2009 08:31 PM, Christine Penner wrote:
Hi,
I posted the following message to the General list a while ago. I am
still not able to run postgres at all.
I am trying to install Postgres 8.4. I had 8.3 installed. Because
I didn't have any important data, to make it easier I remo
David Fetter escribió:
> On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
> > The fine manual saith
> >
> > You may have multiple "END" blocks within a file--they will
> > execute in reverse order of definition; that is: last in, first
> > out (LIFO).
> >
> > But then,
At 11:57 AM 21/09/2009, you wrote:
What error you get when you run initdb?? (Also what exact command you run?)
The first time I just double clicked on the file initdb.exe. Just now
I tried to run it through the command prompt and go this, this is the
same stuff that was in the log file in the
On Mon, Sep 21, 2009 at 3:08 PM, Alvaro Herrera
wrote:
> David Fetter escribió:
>> On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote:
>
>> > The fine manual saith
>> >
>> > You may have multiple "END" blocks within a file--they will
>> > execute in reverse order of definition;
I think the msysconf error is not related to your issue:
http://archives.postgresql.org/pgadmin-support/2002-01/msg00035.php
Can you query data from the data source using MS Excel?
Matt
Annita Veneti wrote:
Matt first thanks for the reply,
I have check the log and it says
Relation »msy
David Fetter writes:
> On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote:
>>> With connection poolers, backends can last quite awhile. Is it OK
>>> for the END block to run hours after the rest of the code?
>>
>> This is an interesting point -- should END blocks be called on
>> DISC
The following bug has been logged online:
Bug reference: 5071
Logged by:
Email address: alexander.o...@koeln.de
PostgreSQL version: 8.3.7
Operating system: Debian Lenny 64Bit
Description:abbrev() bug with IPv6
Details:
I have a Database to store IPV6 addresses.
Fie
24 matches
Mail list logo
