I'm adding a new index in pg, but I find this.
Duplicate OIDs detected:
Duplicate OIDs detected:
357
357
found 1 duplicate OID(s) in catalog data
found 1 duplicate OID(s) in catalog data
what sql should I run to find one?
7;t interest me, it gives me
nothing,https://files.slack.com/files-pri/T0FS7GCKS-F048MD5BTME/quzk_6bk0sug60__f_0wh2l.png
jack...@gmail.com
typedef enum SetOperation
{
SETOP_NONE = 0,
SETOP_UNION,
SETOP_INTERSECT,
SETOP_EXCEPT
} SetOperation;
jack...@gmail.com
> On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote:
>
>
>
> typedef enum SetOperation
> {
> SETOP_NONE = 0,
> SETOP_UNION,
> SETOP_INTERSECT,
> SETOP_EXCEPT
> } SetOperation;
> jack...@gmail.com
Please use just text.
What ‘diale
lt
* node), regardless of the context of the VALUES list. It's up to parse
* analysis to reject that where not valid.
*/
List*valuesLists; /* untransformed list of expression lists */
I need to understand what this is used for?
jack...@gmail.com
d pg_proc.dat for my index. And I add codes
in contrib and backend/access/myindex_name, is there any other places I need to
add some infos? Who can help me?
jack...@gmail.com
d pg_proc.dat for my index. And I add codes
in contrib and backend/access/myindex_name, is there any other places I need to
add some infos? Who can help me?
jack...@gmail.com
On 2022-10-29 19:19:28 +0800, jack...@gmail.com wrote:
> I'm trying to add a new index, but when I finish it, I use “ create index
> xxx_index on t1 using xxx(a); ”,it gives me access method "my_index" does not
> exist
> And I don't know where this message is fr
Hi,
On Sat, Oct 29, 2022 at 08:15:54PM +0800, jack...@gmail.com wrote:
> On 2022-10-29 19:19:28 +0800, jack...@gmail.com wrote:
> > I'm trying to add a new index, but when I finish it, I use “ create index
> > xxx_index on t1 using xxx(a); ”,it gives me access method &quo
"access method xxx does not exist", you suggest
me add new
Am Index in contrib, But I need to modify gist to spb, so that's not my
require. And I need to know
add those in pg_proc.dat and pg_am.dat, if it won't create access method for
spb, what else I need to
do?
--
jack...@gmail.com
"access method xxx does not exist", you suggest
me add new
Am Index in contrib, But I need to modify gist to spb, so that's not my
require. And I need to know
add those in pg_proc.dat and pg_am.dat, if it won't create access method for
spb, what else I need to
do?
--
jack...@gmail.com
"jack...@gmail.com" writes:
> When I add
> "{ oid => '6015', oid_symbol => 'SPB_AM_OID',
> descr => 'SPB index access method',
> amname => 'spb', amhandler => 'spbhandler', amtype => 'i'
thanks for your advice, I realize my problems, can you give me some materials
like some study routine for pg-internal?
--
jack...@gmail.com
>"jack...@gmail.com" writes:
>> When I add
>> "{ oid => '6015', oid_symbol =
jack...@gmail.com
--
here is the codes for pg16.
static relopt_string stringRelOpts[] =
{
/* list terminator */
{{NULL}}
};
And I add my string type arguments here, it can't work well.
When I debug, it comes to func allocateReloptStruc
jack...@gmail.com
--
Hello, I'm trying to modify pg codes for my personal project. And after I
finish modify planner, I get this.
postgres=# create table tt(a int);
CREATE TABLE
postgres=# \d tt
ERROR: btree index keys must be ordered by attribute
the patches are below
jacktby(at)gmail(dot)com
--
Hello, I'm trying to modify pg codes for my personal project. And after I
finish modify planner, I get this.
postgres=# create table tt(a int);
CREATE TABLE
postgres=# \d tt
ERROR: btree index keys must be ordered by attribute
here are the patches of my mo
jack...@gmail.com
--
I can't understand the hash_bytes() func in src/backend/access/hash/hashfunc.c,
it's published by a paper or others?
Can you give me some materials to study it in depth?
do I need to change?
------
jack...@gmail.com
>On 2023-Jan-30, jack...@gmail.com wrote:
>
>> For example, I use "insert into t values(1)"; and I 'll get a tupleTableSlot,
>>
>> And Now I want to get the real data , that's 1, and then use elog() func
>> to print it. Could
I need to create a new operator like '<->' and its syntax is that text1 <->
text2,
for the usage like this: 'a' <-> 'b' = 'a1b1', so how could I realize this one?
Can you give me some exmaples.
--
jack...@gmail.com
Hi, I'm trying to construct a new tuple type, that's not heaptuple,
When I get a tupleTableSlot, I will get data info from it and the I
will constuct a new tuple, and now I need to put it into a physical
page, how should I do?
--
jack...@gmail.com
ht is that these three bit can have only one to be set 1 at
most.
3. t_cid is a combo CID? what's a CID? give me an example please.
--
jack...@gmail.com
tains *committed* transactions between xmin and xmax.
*
* note: all ids in xip[] satisfy xmin <= xip[i] < xmax
*/
TransactionId *xip;
I can't understand the historic MVCC snapshots? can you give me a scenario
to describe this?
jack...@gmail.com
w it solve this
one? please give me a code example,thanks.
jack...@gmail.com
24 matches
Mail list logo
