Hi,
This patch adds the following options to pg_dumpall, to be passed to
pg_dump:
-S, --superuser=NAME
-O, --no-owner
-X disable-dollar-quoting, --disable-dollar-quoting
-X disable-triggers, --disable-triggers
Chris
pg_dumpall.txt.gz
Description: GNU Zip compressed data
---
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On Thu, 24 Jun 2004, Tom Lane wrote:
>> 1. We usually leave spaces around brackets in syntax definitions, so
>> I'd go for "... [ argname ] ..." not "... [argname] ..."
> I saw both in that very rule (later there is an [EXTERNAL]) so I guessed
> that
On Thu, 24 Jun 2004, Tom Lane wrote:
> 1. We usually leave spaces around brackets in syntax definitions, so
> I'd go for "... [ argname ] ..." not "... [argname] ..."
I saw both in that very rule (later there is an [EXTERNAL]) so I guessed
that one use what looks best at different places. But co
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> It's not much text, but someone who speaks english might want to look at
> it.
Two trivial comments:
1. We usually leave spaces around brackets in syntax definitions, so
I'd go for "... [ argname ] ..." not "... [argname] ..."
Also, check that the
On Sun, Jun 20, 2004 at 08:49:22PM -0400, Tom Lane wrote:
Regarding GUC, a WIP report:
> Given patches for inval.c and guc.c, I would say that the patch is
> functionally close enough to done that we could commit to including
> it in 7.5 --- the other stuff could be wrapped up post-feature-freeze
It's not much text, but someone who speaks english might want to look at
it.
If it's okay I can commit.
--
/Dennis Björklund
Index: doc/src/sgml/ref/create_function.sgml
===
RCS file: /cvsroot/pgsql-server/doc/src/sgml/ref/create_f
Kris Jurka <[EMAIL PROTECTED]> writes:
>> Possibly the most correct solution is to assign the name "public" to the
>> dummy schema that pg_dump creates internally when talking to a pre-7.3
>> server.
> I was considering that they might want to restore the dump into another
> schema and that would
On Thu, 24 Jun 2004, Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >> When running pg_dump --clean against a server that doesn't have schemas
> >> the namespace is blank and ends up producing a dump full off things like:
> >>
> >> DROP TABLE "".tab;
>
> > Since the p
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> Attached is the updated version of this patch, which now includes proper
> testing for win32 service running. This is tested and verified with
> Claudios service wrapper pg_ctl patch (including the parts I added and
> sent in a short while ago).
Appl
On Wed, 2004-06-23 at 13:57, Bruce Momjian wrote:
> I am sorry to have given Alvaro another idea that didn't work.
No way! Keep having the ideas, please.
I've done some more digging in dead time on all of this and I think
we're on the right course in general by implementing all of this.
...well
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> Here's at least some documentation about these.
Applied.
regards, tom lane
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> Attached is a patch that adds the option --pwfile=3D to initdb.
Applied with minor editorialization (printing the numeric errno isn't
my idea of friendly...)
regards, tom lane
---(end of broadcast)---
Andreas Pflug <[EMAIL PROTECTED]> writes:
> elog.h is included in postgres.h, which is included in many
> src/port/*.c. Many of them are pretty straight, not requiring any
> backend specific stuff, so the attached patch will change postgres.h to
> c.h for most of them.
Applied. I did the sys/t
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
>> Amended patch attached.
>> Claudio
> Been testing this, and found a couple of small issues. Attached is a
> patch that fixes these. (Note - Claudios patch is included in this one,
> since it hasn't been applied yet..)
Applied, but where's the docum
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> When running pg_dump --clean against a server that doesn't have schemas
>> the namespace is blank and ends up producing a dump full off things like:
>>
>> DROP TABLE "".tab;
> Since the person is dumping using 7.5 pg_dump, presumably they wi
When running pg_dump --clean against a server that doesn't have schemas
the namespace is blank and ends up producing a dump full off things like:
DROP TABLE "".tab;
Since the person is dumping using 7.5 pg_dump, presumably they will be
restoring to 7.5, and it should be:
DROP TABLE "public".tab
When running pg_dump --clean against a server that doesn't have schemas
the namespace is blank and ends up producing a dump full off things like:
DROP TABLE "".tab;
The attached patch only includes a schema if one exists. There are
numerous comments about the DROPs needing to be fully qualifie
Attached.
There is no other way at the moment to get the tablespace name of an
object in psql.
We get information for tables, index, sequences and toast tables.
We should probably do this for schemas too...
GavinIndex: src/bin/psql/common.h
==
18 matches
Mail list logo
