It'd be great if on completion, you can publish the furnished ERD of the catalog structure, and other representation of the planner, optimizer etc.
Luckys.
On 5/22/06, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
Please read the developer's FAQ on our web site. In fact the
s of books you can buy.
HTH-- Richard Huxton Archonet Ltd---(end of broadcast)---TIP 6: explain analyze is your friend
-- regards, Luckys...
r any possible thoughts.---Achilleus---(end of broadcast)---TIP 4: Have you searched our list archives?
http://archives.postgresql.org-- regards, Luckys...
rows where the inner table id is null.
so you'll have select a.id,a.col,b.id,b.col from live a full outer join temp b. similar condition you can place in your where clause. eventually you'll end up in writing 2 sql's one for insert and one for update.
cool,
Luckys.
On 4/11/06, MG &l
a single complex insert/update sql would be always faster compared to having a cursor and manipulating the data.
Again, it depends on what is the logic, and where actually you have the data.
cool.
L.
On 4/11/06, MG <[EMAIL PROTECTED]> wrote:
I can`t use COPY for INSERTs, because I have to manip
x = 'bla' LIMIT 200 (Rows to be fetched)
You can check the LIMIT and OFFSET clause in the SELECT statement.
Again, the user would definately have further filter condition after retrieving 20K records, which you can deal before hand as I mentioned earlier.
thanks,
regards
Surabhi
F
I believe you should restrict number of rows that needs to be returned, or giving a choice to the user, although showing the total count. Even if you display all 20K records, no one is going to see them all, you can even add one more LIKE condition to match the user's criteria.
On 3/22/06, Mic
Firstly, the existence of the Path would be there from previous installation, of which PG thinks data is already present.
Secondly you should have logged in as another user and not administrator, e.g postgres which can be even a part of domain.
Luckys
Data directory error: The specified data
