Hi,
i want to know how create relation works and how
the populated relation is stored in the form of pages
and also when a tuple is inserted how page concept
works
in postgress.
S.Nithin.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the b
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> I am afraid the problem are not limited to hash_search(). Any code snippet
> are not proteced by critical section like this:
This is not an issue except if the system might actually try to recover;
which is not the case in the postmaster snippet you me
"Tom Lane" <[EMAIL PROTECTED]> writes
> "Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> > In general, code snippet like this:
>
> > if (hash_search(..., HASH_ENTER, ...) == NULL)
> > action_except_elog__ERROR__;
>
> > are considered unsafe if: (1) the allocation method of the target hash
table
>
"Tom Lane" <[EMAIL PROTECTED]> writes
>
> That should be impossible because drop/create take out locks at the
> table level. Can you provide a reproducible test case?
>
To reproduce it:
Concurrently execute the following sql script serveral times:
("without oids","tablespace testsp" should be op
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> The reason I raise this question is because I corrupted pg_trigger by
> concurrently perform drop/create table (with foreign keys).
That should be impossible because drop/create take out locks at the
table level. Can you provide a reproducible test ca
"Tom Lane" <[EMAIL PROTECTED]> writes
>
> Deletion scans the entries and either deletes the dependent objects or
> raises error. It's not "by hand" particularly, at least not for
> anything outside dependency.c. If you were to write code that deleted
> objects directly without going through the
Neil Conway <[EMAIL PROTECTED]> writes:
> I was rather disappointed, as I wasn't able to find a clean
> way to get around the problem described in the thread above -- e.g.
> in_info_list and query tree mutators:
> http://archives.postgresql.org/pgsql-hackers/2005-03/msg00718.php
> How were you th
Marc G. Fournier wrote:
>
> One concern that was raised off of this list was the steep learning
> curve to start with, to get to the point of beign able to do anything ...
>
> Do we have any 'students' that are already up to speed, enough so that
> they'd be able to accomplish something signifi
The code given to implement lo data-type in contrib/lo takes something
like:
insert into a values( lo_import("/home/postgres/LargeObject"));
What i want to do is .. cover this, that is, i mean i should only pass the
filename to the input function. I hope you got my problem. If you know
what I s
> > Incidentally I havent seen any objections, if there are none should we
> > go ahead and whip up an email to google? Do we want to run this through
> > the foundation? ISTM we would, though I don't know the full extent of
> > what ramifications that would have.
>
> No, the Foundation wasn't
I'm intending to remove the "planner internal" fields of Query
(base_rel_list et al) and put them into a separate struct along
the lines of
typedef struct PlannerInfo
{
NodeTag type;
Query *parse;/* the Query being planned */
List *base_rel_list;/* list
Gevik,
I like your idea. I have already checked it out.
Its treeview is really like MSDN's.
Some comments, ideas:
- it would be better if the treeview was
ordered by name
- the current item in the treeview could be
highlighted
- the gutter should have a constant
width
- it would be ple
On 04/06/2005 22:59:19, Gevik babakhani wrote:
> Dear all,
>
> The PostgreSQL Developer Network's Source Browser (beta1) is ready.
>
> If you got the time to check it for a moment, please do not hesitate to send
Firstly, good that you're asking for comments (I assume as an attempt to
work with
So what would be your suggestion in order to add this functionality?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
Sent: Sunday, June 05, 2005 3:17 AM
To: Gevik Babakhani
Cc: [EMAIL PROTECTED] Org
Subject: Re: [HACKERS] Solution proposal f
14 matches
Mail list logo
