Tom Lane <[EMAIL PROTECTED]> writes:
> LRU etc have nothing to do with this. The majority of trips into the
> buffer manager are for ReadBuffer/ReleaseBuffer. What we need is to
> figure a way for those operations to use finer-grain locks so they don't
> contend so much.
I reimplemented much of
Hi,
I was wondering if I have a function that returns a record datatype, and I call it using the as keyword to specify the table structure, can I return a different structure than the one specified?
Say I call select * from xy ('abc', 'def') as (samplea char, sampleb char) for a function
D. Dante Lorenso wrote:
> > When I started with PostgreSQL and MySQL, MySQL was far easier
> > to use
>
> I started with MySQL and it WAS easier to use. It was easier because
> the manual essentially reads:
>
>-- we didn't implement anything complicated that's why
>-- we are fast.
>
> T
Michael Gill said:
> Hello,
>
> I've tried asking this question elsewhere and have not received a
> satisfactory response.
>
> I want to restrict users of my packaged database from directly
> accessing the data or reading the schema. I would provide access to
> the read-only data through function
Dave Cramer said:
> Can you explain what you mean by this?
>
> On Fri, 2004-01-02 at 20:21, Andrew Dunstan wrote:
>> Will we need to address this TODO item:
>>
>> . Add capability to create and call PROCEDURES
>>
>> before proceding to do PL/Java? It would add to the usefulness
>> greatly, I sho
Hi Vishal,
usage of floating poing arithmetic is a taboo in financial calculations.
This what the decimal type has been created for. Never ever use float.
Ciao, Toni
Sai Hertz And Control Systems wrote:
Dear all ,
I would like to share my concerns about the IEEE 754 specification and
floatin
I try to execute Postgres on Linux. It is blocked
in execution. When I traced through, I found out that
it is blocked on invoking a malloc( ). Any help? Thank you
in advance.
Shuqing
---(end of broadcast)---
TIP 5: Have you checked our extensive F
"Ollie Clark <[EMAIL PROTECTED]>" wrote in
comp.databases.postgresql.hackers:
[sNip]
> which is different from previous versions and different to MySQL and SQL
> Server. Is this a bug, or can you turn this behaviour off? It's breaking
> a lot of our applications!
Could you clarify which
in preproc.y:2021:
opt_revoke_grant_option: GRANT OPTION FOR
$$ = make_str("with grant option");
should be:
$$ = make_str("grant option for");
I get the lastest CVS version.
---(end of broadcast)---
TIP 9: the planner will ignore y
Hello,
Has anybody had such problem - I tested Mammoth PostgreSQL for Windows and I
did not like that it completely killed my cygwin, did not allow console
commands to the database, etc., and then I uninstalled it.
Since then the cygwin refused to operate properly.
>From Command Prompt I was tol
Barry,
Ok, so if we drop this limitation then we leave it up to the architect
to manage the caching problem themselves.
The class loader issue is interesting, this would mean that each object
static or otherwise would not be able to overwrite others data.
--dc--
On Wed, 2003-12-31 at 19:34, Barr
Can I chip in? I've had a look in the past at the way various databases
perform this. Most just go and read the data, though Informix does seem
to keep a permanent record of the number of rows in a table...which
probably adds overhead you don't really want.
Select count(*) could be evaluated again
Hello,
I've tried asking this question elsewhere and have not received a
satisfactory response.
I want to restrict users of my packaged database from directly accessing
the data or reading the schema. I would provide access to the read-only
data through functions (which works well in PG). I fi
El Sáb 27 Dic 2003 16:08, Nailah Ogeer escribió:
> How do you connect to postgres if it is running on a different machine. I
> am looking for a telnet command in place of postmaster -D data
Depends on what you want to do.
One way arounf would be:
1) Edit the pg_hba.conf where the PG server is run
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
On Sat, 3 Jan 2004, Kurt Roeckx wrote:
> On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote:
> >
> > but what about default st
Can you explain what you mean by this?
Dave
On Fri, 2004-01-02 at 20:21, Andrew Dunstan wrote:
> Will we need to address this TODO item:
>
> . Add capability to create and call PROCEDURES
>
> before proceding to do PL/Java? It would add to the usefulness greatly,
> I should think. I'm not sur
On Sat, 3 Jan 2004, Christopher Kings-Lynne wrote:
> > I think one way of attacking the problem would be using the existing
> > nbtree by allowing it to store the five btrees. First read the README
> > in the nbtree dir, and then poke at the metapage's only structure. You
> > will see that it ha
On Sat, Jan 03, 2004 at 02:49:23PM +0800, Christopher Kings-Lynne wrote:
> >I think one way of attacking the problem would be using the existing
> >nbtree by allowing it to store the five btrees.
>
> Why not write it using the GiST interface - that is after all the entire
> point of GiST...
Well
On Sat, Jan 03, 2004 at 09:25:14AM +0100, ivan wrote:
>
> but what about default style ?
> first time when i saw DateStyle i thought that i can use it like C/C++
> function strftime. I would be not bad idea to have custom data style :)
Use to_char() function to put it in any format you want.
Ku
but what about default style ?
first time when i saw DateStyle i thought that i can use it like C/C++
function strftime. I would be not bad idea to have custom data style :)
On Fri, 2 Jan 2004, Christopher Kings-Lynne wrote:
> Create table with type TIMESTAMP(0)
>
> Chris
>
> ivan wrote:
>
> >
>
20 matches
Mail list logo
