> If this communication is in fact intended to be protected by some
> legal privilege, or to remain company confidential, you have
> definitely sent it to the wrong place.
Sadly I don't control my company's email server. They however don't control my
gmail account. I'll switch to that.
eri
On Tue, Oct 14, 2014 at 12:21 AM, Eric Ridge wrote:
> pg_get_indexdef() and pg_dump don't quote the reloption values, making a
> restore (or cut-n-paste of the pg_get_indexdef() output) impossible if the
> reloption value contains non-alphanumerics.
>
> For example, the statement:
>
> #
On Mon, Oct 13, 2014 at 11:21 AM, Eric Ridge wrote:
> PROPRIETARY AND COMPANY CONFIDENTIAL COMMUNICATIONS
> The information contained in this communication is intended only for
> the use of the addressee. Any other use is strictly prohibited.
> Please notify the sender if you have received this me
Hi all!
I've been working on implementing a custom index using the Index Access Method
API and have the need for custom reloptions that are "complex" strings (ie,
also contain non-alphaumerics).
pg_get_indexdef() and pg_dump don't quote the reloption values, making a
restore (or cut-n-paste of
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 13 June 2006 14:42
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" writes:
> > Right, but how
"Dave Page" writes:
> Right, but how can I conditionally join with pg_opclass based on whether
> or not the opclass specified for the column is the default for that
> type?
Check pg_opclass.opcdefault and compare pg_opclass.opcintype to the
index column's datatype (which you'd get from its pg_att
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2006 18:32
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_get_INDEXdef - opclass
>
> "Dave Page" writes:
> >> Fol
"Dave Page" writes:
>> Following a pgAdmin bug report, I noticed that pg_get_viewdef doesn't
>> return the opclass when called for a specific column (in 8.1
>> at least) -
> Bah, I mean pg_get_indexdef of course :-)
This is intentional --- whoever asked for the per-column variant of
the indexd
Bah, I mean pg_get_indexdef of course :-)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 12 June 2006 12:12
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] pg_get_viewdef - opclass
>
> Following a pgAdmin bug report, I n
Should pg_get_indexdef return its TABLESPACE clause?
Already done.
Cool. I'd considered it before when I was coding psql stuff, but then I
forgot to bring it up again on the list...
Chris
---(end of broadcast)---
TIP 8: explain analyze is your fri
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Should pg_get_indexdef return its TABLESPACE clause?
Already done.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTE
Should pg_get_indexdef return its TABLESPACE clause?
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
12 matches
Mail list logo