Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Would it be an idea to issue a CLUSTER command after the CREATE TABLE
statement in SQL dumps for tables that have an indisclustered index?
Yeah...
snip
A CLUSTER command issued just after table creation, while it's
still
empty, would be
With the old idocs it was possible to create links to the current
version of individual documentation pages without having to
provide a Postgres version number, e.g.:
http://www.PostgreSQL.org/idocs/index.php?kernel-resources.html
which would remain constant over longer periods of time.
See how it's HTMLised the foreign key name? I cannot find how $keyname in
the code is being html escaped. Perhaps it's some weird taint mode thing?
Not to mention when it's unnamed, the code is setup to ignore the
constraint name entirely (line 267).
I worked around it by checking to see
- Move SEQ_MAXVALUE, SEQ_MINVALUE definitions to sequence.h
- Add check in pg_dump to see if the value returned is the max /min
values and replace with NO MAXVALUE, NO MINVALUE.
- Change START and INCREMENT to use START WITH and INCREMENT BY syntax.
This makes it a touch easier to port to other
On 23 Feb 2003, Rod Taylor wrote:
- Move SEQ_MAXVALUE, SEQ_MINVALUE definitions to sequence.h
- Add check in pg_dump to see if the value returned is the max /min
values and replace with NO MAXVALUE, NO MINVALUE.
- Change START and INCREMENT to use START WITH and INCREMENT BY syntax.
Rod Taylor [EMAIL PROTECTED] writes:
ERROR: dependent privileges exist (use CASCADE to revoke them too)
I saw that a couple weeks ago, and then was unable to reproduce it later
Seems to be by design. Create an empty schema with no permissions.
First REVOKE sees lack of permissions, and
hi,
i wanted to know whether in postgresql, asingleprocess can wait on acquiring multiple locks and if can hold
multiple locks at the same time?
thanks
sumairaMSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
I worked around it by checking to see if it equalled 'lt;unnamedgt;' as
well as 'unnamed'. I also have heaps of RI triggers left over after the
addepend run, so I'll investigate why adddepend doesn't pick them up...
Took a quick look, and I don't see anything in DBD-Pg that would do this
type
On Sun, 2003-02-23 at 13:19, Sumaira Ali wrote:
hi,
i wanted to know whether in postgresql, a single process can wait on
acquiring multiple locks and if can hold
multiple locks at the same time?
http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=sql-lock.html
The docs answer
The documentation of to_char() is unclear regarding the meaning of the
various formatting patterns for plus and minus signs:
S negative value with minus sign (uses locale)
MI minus sign in specified position (if number 0)
PL plus sign in specified position (if number 0)
SG
-Original Message-
From: Ian Barwick [mailto:[EMAIL PROTECTED]
Sent: 23 February 2003 10:56
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [HACKERS] Linking to current docs
Would it be possible to modify the new docs to provide
similar functionality? E.g. something
Tom Lane writes:
Hmm. So the real story here is that the permissions set up by initdb
for PUBLIC are actually an illegal state: postgres has granted
permissions to public that it isn't allowed to.
Yes, the way the permissions are initialized in the catalog templates
DATA(insert OID = 11 (
No; directly manipulating the system catalogs in dump scripts is a
crummy idea, because (a) it only works if you're superuser, and (b)
it creates a nasty backwards-compatibility problem if we change the
catalogs involved.
A CLUSTER command issued just after table creation, while it's still
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
A CLUSTER command issued just after table creation, while it's still
empty, would be cheap ... but we don't put the index in place until
we've loaded the data, do we? Darn.
Maybe we should issue it after the CREATE INDEX and ADD CONSTRAINT
Josh Berkus [EMAIL PROTECTED] writes:
- Some other databases support ILIKE and it makes porting easier.
Which other ones? I checked our archives and found that when we were
discussing adding ILIKE, it was claimed that Oracle had it. But I can't
find anything on the net to verify that claim. I
Peter,
Several reasons (because I like lists):
- Some other databases support ILIKE and it makes porting easier.
- For tables and/or subqueries that are too small to need an index, ILIKE is
perfectly acceptable.
- It's also useful for comparing expressions, and is faster to type than
16 matches
Mail list logo