Andrew Dunstan wrote:
>
> 2 things.
>
> I submitted a patch for this 5 months ago, which is still waiting to be
> merged (hope it hasn't bitrotted in the meantime):
>
> . Allow log lines to include session-level information, like database
> and user
>
> If nobody is working on this I am prepa
Alex J. Avriette wrote:
> On Sun, Jan 04, 2004 at 07:59:02PM -0600, D. Dante Lorenso wrote:
>
> > Anything other than simple, short commands is a waste, IMHO. I can easily
> > remember SHOW DATABASES and SHOW TABLES and DESC , because they
> > reflect
> > my intensions directly and 'make sense'.
UNSUBSCRIBE
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
I wrote:
If nobody is working on this I am prepared to look at it:
. Allow logging of only data definition(DDL), or DDL and modification
statements
Here are some options:
1. change the type of "log_statement" option from boolean to string,
with allowed values of "all, mod, ddl, none" with
Peter Eisentraut wrote:
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 sure how hard it would be.
This should be relatively easy
On Mon, 2004-01-05 at 10:02, Tatsuo Ishii wrote:
> I see following in the doc:
>
> Table 9-21. Template Patterns for Date/Time Formatting
> :
> :
> J Julian Day (days since January 1, 4712 BC)
>
> I think 4712 should be 4713.
template1=# select to_char('1 Jan 4713BC'::date,'J');
to_char
--
there can be same problems with back convering, but its would be only
when select is going out, to cstring form, and all its depend on user,
but this is ok :)
On Mon, 5 Jan 2004, Karel Zak wrote:
> On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
> >
> > ok, bat each time where i want to do
On Mon, 2004-01-05 at 14:49, Oleg Bartunov wrote:
> Hi there,
>
> I'm pleased to present pilot version of http://www.pgsql.ru - search system on
> postgresql related resources. Currently, we have crawled 27 sites,
> new resources are welcome. It has multi-languages interface (russian, english)
> b
Peter Eisentraut wrote:
Keith Bottner wrote:
How integrated is the planner into the database? Put another way, how
hard would it be to separate the planner from the core database in
such a way that it could be easily replaced either during compilation
or even better with a runtime setting?
2 things.
I submitted a patch for this 5 months ago, which is still waiting to be
merged (hope it hasn't bitrotted in the meantime):
. Allow log lines to include session-level information, like database
and user
If nobody is working on this I am prepared to look at it:
. Allow logging of only
Keith Bottner wrote:
> How integrated is the planner into the database? Put another way, how
> hard would it be to separate the planner from the core database in
> such a way that it could be easily replaced either during compilation
> or even better with a runtime setting?
The planner is configur
Title: Message
I have been working
with Postgres for just a short while, however, we are looking to use Postgres
for our next project and I was hoping someone could answer a question for me
regarding the planner to save me some research time.
How integrated is
the planner into the database
Jean-Eric Cuendet wrote:
> - User permissions based on columns? (Ex: User1 has Select on Column
> "CompayName" but User2 has update on column "CompanyName" while User3
> has create new row on table).
Well, I have about half a patch for column privileges lying around, but
I've never had enough mot
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 sure how hard it would be.
This should be relatively easy if you omit OUT param
UNSUBSCRIBE
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On 5 Jan, Tom Lane wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
>> 2) DEVELOP BETTER PLANS FOR "OR GROUP" QUERIES
>
>> Summary: Currently, queries with complex "or group" criteria get devolved by
>> the planner into canonical and-or filters resulting in very poor execution on
>> large data s
> connection failed :(
>
> Dave
I had no problem accessing it - very nice and responsive ! Great job Oleg
and Teodor.
-- Glenn
- Original Message -
From: "Dave Cramer" <[EMAIL PROTECTED]>
To: "Oleg Bartunov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Pgsql Hackers"
<[EMAIL PROTECT
On Jan 2, 2004, at 4:54 PM, Alvaro Herrera wrote:
I think your approach is too ugly. You will have tons of problems the
minute you start thinking about concurrency (unless you want to allow
only a single user accessing the index)
It might be ugly, but it's very fast. Surprisingly fast, actually.
Josh Berkus <[EMAIL PROTECTED]> writes:
> 2) DEVELOP BETTER PLANS FOR "OR GROUP" QUERIES
> Summary: Currently, queries with complex "or group" criteria get devolved by
> the planner into canonical and-or filters resulting in very poor execution on
> large data sets. We should find better ways o
connection failed :(
Dave
On Mon, 2004-01-05 at 09:49, Oleg Bartunov wrote:
> Hi there,
>
> I'm pleased to present pilot version of http://www.pgsql.ru - search system on
> postgresql related resources. Currently, we have crawled 27 sites,
> new resources are welcome. It has multi-languages inter
On Sun, Jan 04, 2004 at 07:59:02PM -0600, D. Dante Lorenso wrote:
> Anything other than simple, short commands is a waste, IMHO. I can easily
> remember SHOW DATABASES and SHOW TABLES and DESC , because they
> reflect
> my intensions directly and 'make sense'.
What makes sense to me in csh does
>>Is it possible to make a composite GiST index? I want to create an
>>index on a txtidx and a timestamp column - is that at all possible?
>
> OK, this is what I'm trying (7.3.4):
>
> create index blah on forums_posts using gist(ftiidx, datetime);
>
> ERROR: data type timestamp with time zone
Hi there,
I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable ar
Adam Witney <[EMAIL PROTECTED]> writes:
> I have one regression failure on 7.4.1, which does not occur with 7.4
>
> [EMAIL PROTECTED] more src/test/regress/regression.diffs
> *** ./expected/random.out Thu Feb 13 05:24:04 2003
> --- ./results/random.outTue Dec 23 20:19:40 2003
> **
when i see the source codes in the bin directory,i find some very interesting codes:cat <\. INSERT INTO pg_description SELECT \ t.objoid, c.oid, t.objsubid, t.description \ FROM tmp_pg_description t, pg_class c WHERE c.relname = t.classname;EOF) \ | "$PGPATH"/postgres $PGSQL_OPT template1 >
I see following in the doc:
Table 9-21. Template Patterns for Date/Time Formatting
:
:
J Julian Day (days since January 1, 4712 BC)
I think 4712 should be 4713.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
>
> 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.
I don't think it will too much faster :-)
BTW, for example the
On Fri, Jan 02, 2004 at 12:21:22PM -0500, Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Another little problem is that plpgsql doesn't really have any mechanism
> >> for invalidating cached stuff at all; it will leak memory like there's
> >> no tomorrow if we star
On Mon, 5 Jan 2004, Christopher Kings-Lynne wrote:
> >>Is it possible to make a composite GiST index? I want to create an
> >>index on a txtidx and a timestamp column - is that at all possible?
>
> OK, this is what I'm trying (7.3.4):
>
> create index blah on forums_posts using gist(ftiidx, datet
On Mon, 5 Jan 2004, Christopher Kings-Lynne wrote:
> Is it possible to make a composite GiST index? I want to create an
> index on a txtidx and a timestamp column - is that at all possible?
you need to install contrib/btree_gist
btw, tsearch2 is much better than tsearch.
Check http://www.sai.ms
ivan <[EMAIL PROTECTED]> writes:
> why there are no operators +-*/ to oid data type ?
Why should there be? Addition on OIDs seems like a meaningless
operation, at least for the intended usage of OIDs (namely as
opaque identifiers).
Yes, I know we have < and >= and similar operators on OID, but t
why there are no operators +-*/ to oid data type ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> OK, this is what I'm trying (7.3.4):
> create index blah on forums_posts using gist(ftiidx, datetime);
> ERROR: data type timestamp with time zone has no default operator class
> for access method "gist"
That's got nothing to do with it being
Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
OK, this is what I'm trying (7.3.4):
create index blah on forums_posts using gist(ftiidx, datetime);
ERROR: data type timestamp with time zone has no default o
34 matches
Mail list logo
