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
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
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 when
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 clear that
Sam Mason wrote:
On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
Sam Mason s...@samason.me.uk 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, there
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
when there
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
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 transaction triggers
On Mon, Sep 21, 2009 at 12:06 PM, Alvaro Herrera
alvhe...@commandprompt.com 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
On Mon, Sep 21, 2009 at 12:31 PM, Bruce Momjian br...@momjian.us wrote:
Sam Mason wrote:
On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
Sam Mason s...@samason.me.uk wrote:
the deeper problem seems to be that the table was created as:
create table test (a tstdom);
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 to me, that
On Mon, Sep 21, 2009 at 2:17 PM, David Fetter da...@fetter.org 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 da...@fetter.org 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:
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
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, why would we
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
On Mon, Sep 21, 2009 at 3:08 PM, Alvaro Herrera
alvhe...@commandprompt.com 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
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
David Fetter da...@fetter.org 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
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.
21 matches
Mail list logo