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.
"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 CON
> 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 st
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 (
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
'jeh
> -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. s
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
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.3&idoc=0&file=sql-lock.html
The docs answer
> I worked around it by checking to see if it equalled '' as
> well as ''. 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 of conve
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?
thanks
sumaira MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
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 permission
On Sun, 2003-02-23 at 00:36, Tom Lane wrote:
> 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
> (and still can't today). I suspect there may be some kind of
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.
- 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
> > 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 , the code is setup to ignore the
> constraint name entirely (line 267).
I worked around it by checking to see
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. Prov
> "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...
> A CLUSTER command issued just after table creation, while it's
still
> empty,
17 matches
Mail list logo
