Bruce Momjian [EMAIL PROTECTED] writes:
Should we set the datestyle at the top of pg_dump files like we do with
encoding and other settings? Seems we should.
That was dealt with quite a while back.
regards, tom lane
---(end of
Stephen Frost [EMAIL PROTECTED] writes:
c)
merge into T1 USING VALUES (1,2,4);
I'm not happy with the implied use of the primary key. a) some tables can have
two effective primary keys, even if only one is explicitly declared as such.
and b) some update/inserts are done with where clauses
Hello,
We are able to compile without issue but it won't start. The exact same
config works perfectly with 7.3.6. Here is the output:
$ /usr/local/pgsql/bin/postmaster -D
data
DEBUG: /usr/local/pgsql/bin/postmaster: PostmasterMain: initial
environ dump:
DEBUG:
We've had a backend crash with sig 11 during connection. My guess is
there's something up with (maybe) the IPv6 support on AIX. I seem to
recall something similar recently, but I can't find the post in the
archives. Suggestions?
oxrslive=# SELECT version();
Joshua D. Drake wrote:
We are able to compile without issue but it won't start. The exact
same config works perfectly with 7.3.6.
Yes, this is known and being discussed on the pgsql-cygwin list. Maybe
you can review the last few postings and help out.
---(end of
Hi All,
I've got an issue that I've been trying to track down some results to.
I've noticed that on a recent PostgreSQL server that I've been working
on has a few relations that do not exist:
select relname, relnamespace, reltype from pg_class where relname ~*
'sql_';
relname
Chris Bowlby [EMAIL PROTECTED] writes:
I've got an issue that I've been trying to track down some results to.
I've noticed that on a recent PostgreSQL server that I've been working
on has a few relations that do not exist:
select relname, relnamespace, reltype from pg_class where relname ~*
On Thu, Apr 15, 2004 at 01:07:33PM -0400, Andrew Sullivan wrote:
We've had a backend crash with sig 11 during connection.
By the way, I failed to mention, but sig 11 is segfault on AIX.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
---(end of
On Thu, 2004-04-15 at 14:34, Chris Bowlby wrote:
Hi All,
I've got an issue that I've been trying to track down some results to.
I've noticed that on a recent PostgreSQL server that I've been working
on has a few relations that do not exist:
I suggest you read up on the information_schema.
* Greg Stark ([EMAIL PROTECTED]) wrote:
Stephen Frost [EMAIL PROTECTED] writes:
c)
merge into T1 USING VALUES (1,2,4);
I'm not happy with the implied use of the primary key. a) some tables can have
two effective primary keys, even if only one is explicitly declared as such.
and b)
Chris Bowlby [EMAIL PROTECTED] writes:
These tables are in the pg_class table, but no where on any PostgreSQL
server that I've been able to look at have these tables been created.
You're probably forgetting to specify the schema name.
information_schema isn't in the default search path ...
Simon Riggs wrote:
Very much agreed. PGDATA is important, lets keep it, please.
To me it's not so much whether or not PGDATA is kept around for the
system as a whole so much as how it's used.
In the general case, scripts are used to start the postmaster. So using
PGDATA even if the postmaster
Andrew Sullivan [EMAIL PROTECTED] writes:
We've had a backend crash with sig 11 during connection. My guess is
there's something up with (maybe) the IPv6 support on AIX.
(gdb) bt
#0 0xd01d7778 in memmove () from /usr/lib/libc.a(shr.o)
#1 0xd0326e1c in getaddrinfo2 () from
Kevin Brown [EMAIL PROTECTED] writes:
The goal here is simply to make it obvious to a system administrator where
the PG data directory that a given postmaster is using resides.
Why would it not be sufficient to add a read-only GUC variable that
tells that? Connect to the postmaster and do show
El Mié 14 Abr 2004 22:22, Christopher Kings-Lynne escribió:
... on projects.postgresql.org, or similar.They really aren't doing
any good in /contrib.
I've already set up a category conversion tools on pgFoundry, and my
idea was one project per target system.
I reckon that by far
15 matches
Mail list logo
