On Oct 28, 2007, at 2:54 PM, Josh Berkus wrote:
I'd actually be curious what incremental changes you could see
making to
PostgreSQL for better in-memory operation. Ideas?
It would be difficult to make PostgreSQL really competitive for in-
memory operation, primarily because a contrary ass
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > Is it possible to use UTF-8 for SGML docs?
>
> No :-(. We've been through this already, see discussions awhile back
> about spelling non-English names correctly. Unless there's a recognized
> HTML entity for the character, you can't use it.
Ok. So
Thanks a lot for the help Matijn. Will check out the rules query.
Best regards,
Sayali
Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
On Tue, Oct 30, 2007 at 07:53:21AM +, sayali k wrote:
> Hello All,
> I am doing a project in DBMS postgresql. I have the folllowing query : in the
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Is it possible to use UTF-8 for SGML docs?
No :-(. We've been through this already, see discussions awhile back
about spelling non-English names correctly. Unless there's a recognized
HTML entity for the character, you can't use it.
"Gevik Babakhani" <[EMAIL PROTECTED]> writes:
>> I think the most likely implementation would involve adding hooks
>> in the parser at places where "unknown column" errors are about to
>> be thrown, so that a function language could check for a match to
>> one of its variable names only after the q
Hi,
Is it possible to use UTF-8 for SGML docs?
I would like to enhance the full text search docs, especially table 12-1,
which includes ASCII and LATIN1 examples only. I find that word,
numword alias etc. allow not only LATIN characters but Asian
ones. This fact is not stated in the doc, and I'm
Joshua D. Drake wrote:
> On Wed, 31 Oct 2007 00:10:27 +0100
> Peter Eisentraut <[EMAIL PROTECTED]> wrote:
>
> > Marc G. Fournier wrote:
> > > Actually, that's why I only put the script in tools, and didn't
> > > modify anything else ... I didn't figure anyone would object to it
> > > being added i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- --On Tuesday, October 30, 2007 16:20:16 -0700 "Joshua D. Drake"
<[EMAIL PROTECTED]> wrote:
> On Wed, 31 Oct 2007 00:10:27 +0100
> Peter Eisentraut <[EMAIL PROTECTED]> wrote:
>
>> Marc G. Fournier wrote:
>> > Actually, that's why I only put the sc
On Wed, 31 Oct 2007 00:10:27 +0100
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Marc G. Fournier wrote:
> > Actually, that's why I only put the script in tools, and didn't
> > modify anything else ... I didn't figure anyone would object to it
> > being added in there, since, unlike the contrib st
Marc G. Fournier wrote:
> Actually, that's why I only put the script in tools, and didn't
> modify anything else ... I didn't figure anyone would object to it
> being added in there, since, unlike the contrib stuff, it isn't
> actually tied anywhere in the build infrastructure :(
Sure, but people
Marc G. Fournier wrote:
> simple script to pull together a very small (<500k) tar file that
> builds *just* libpq ... its not perfect, as it pulls in more files
> then is necessarily required to build, but as it is, it requires one
> simple patch to configure.in in order to work ...
This script is
Thank you Tom.
I think the most likely implementation would involve adding hooks
in the parser at places where "unknown column" errors are about to
be thrown, so that a function language could check for a match to
one of its variable names only after the query-exposed names are
checked.
Would t
Camilo Porto wrote:
> In some tests I have done, I have found these results:
> - Total Time interval which BenchmarkSQL submitted queries = 30 seconds
>
> - sum of executor's duration time during this period of time = 2
> minutes and 36 seconds!! (5x longer than total time)
Are you sure you're
>
> Please test the build at
> http://developer.pgadmin.org/~dpage/postgresql-8.3-beta2-2.zip. It seems
> I forgot to apply Visual Studio SP1 to our shiny new build VM so the
> original build shipped with older runtimes.
>
> D'oh!
>
it works
Thank you
Pavel
---(end of br
Pavel Stehule wrote:
> Hello
>
>
> C:\Program Files\PostgreSQL\8.3-beta2\bin>pgAdmin3.exe
> The system cannot execute the specified program.
>
>
> When I run pgAdmin from menu I got
>
> This applications has failed to start because the application
> configuration is incorrect. Reinstalling the
Pavel Stehule wrote:
> Hello
>
>> Why aren't you asking in the pgadmin forums?
>>
>
> It's true, I am sorry, I havn't access to pgadmin phorum from win :(.
Huh? Your windows based mua can post to pgsql-hackers@postgresql.org but
not [EMAIL PROTECTED] That's even more borked than OE
Regards,
Hello
>
> Why aren't you asking in the pgadmin forums?
>
It's true, I am sorry, I havn't access to pgadmin phorum from win :(.
Pavel
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nom
Pavel Stehule wrote:
Hello
C:\Program Files\PostgreSQL\8.3-beta2\bin>pgAdmin3.exe
The system cannot execute the specified program.
When I run pgAdmin from menu I got
This applications has failed to start because the application
configuration is incorrect. Reinstalling the application may f
Hello
C:\Program Files\PostgreSQL\8.3-beta2\bin>pgAdmin3.exe
The system cannot execute the specified program.
When I run pgAdmin from menu I got
This applications has failed to start because the application
configuration is incorrect. Reinstalling the application may fix this
problem.
Regards
On 10/30/07, Zeugswetter Andreas ADI SD > The background for Quel was,
that when selecting all fields from
> an inheritance hierarchy you got the additional fields of each child.
>
> Thus the field count and types could vary within one cursor.
> Like if you would allow the following:
> select a, b:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- --On Tuesday, October 30, 2007 13:36:45 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> Unfortunately, it isn't usable right now, as it does require a modification
>> to configure.in, which I haven't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- --On Tuesday, October 30, 2007 13:50:16 -0400 Tom Lane <[EMAIL PROTECTED]>
wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> Interesting ... may I inquire what is this for? And why was it applied
>> so late in the cycle, without any previou
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Interesting ... may I inquire what is this for? And why was it applied
> so late in the cycle, without any previous proposal or discussion?
This is an outgrowth of a core discussion that really should've been
taken public before anything was done about
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Unfortunately, it isn't usable right now, as it does require a modification
> to
> configure.in, which I haven't applied, to avoid a link step in ecpg,
> specifically:
Rather than modifying configure (and having to use a nonstandard
configure com
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
My idea is to put functions declaration int pg_xxx.h and structure
declaration in pg_xxx_def.h. I'm not sure if split DATA into separate
header is good idea, but if yes then pg_xxx_data.h should be good name
for it (it seems that pg_dump
Greg Smith <[EMAIL PROTECTED]> writes:
> On Tue, 30 Oct 2007, Alvaro Herrera wrote:
>> It would also be good to make --enable-debug the default.
> The last time I did a build with both --enable-debug and --enable-cassert,
> I was seeing pgbench results that were significantly (around 40% I think)
Greg Smith wrote:
On Tue, 30 Oct 2007, Alvaro Herrera wrote:
It would also be good to make --enable-debug the default.
The last time I did a build with both --enable-debug and
--enable-cassert, I was seeing pgbench results that were significantly
(around 40% I think) slower than without tho
On Tue, 30 Oct 2007 13:00:12 -0400 (EDT)
Greg Smith <[EMAIL PROTECTED]> wrote:
> On Tue, 30 Oct 2007, Alvaro Herrera wrote:
>
> > It would also be good to make --enable-debug the default.
>
> The last time I did a build with both --enable-debug and
> --enable-cassert, I was seeing pgbench result
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> My idea is to put functions declaration int pg_xxx.h and structure
> declaration in pg_xxx_def.h. I'm not sure if split DATA into separate
> header is good idea, but if yes then pg_xxx_data.h should be good name
> for it (it seems that pg_dump needs only
On Tue, 30 Oct 2007, Alvaro Herrera wrote:
It would also be good to make --enable-debug the default.
The last time I did a build with both --enable-debug and --enable-cassert,
I was seeing pgbench results that were significantly (around 40% I think)
slower than without those two. I never ci
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
One solution should be put sugar words into separate header and include
them directly from catalog/*.h files.
Yeah, that would probably be a good idea. It's unlikely that we'll
get away anytime soon from frontend code wanting to includ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- --On Tuesday, October 30, 2007 11:44:12 -0300 Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Marc G. Fournier wrote:
>> Log Message:
>> ---
>>
>> simple script to pull together a very small (<500k) tar file that builds
>> *just* libpq ... it
"Gevik Babakhani" <[EMAIL PROTECTED]> writes:
> Implementation of the name parameter parsing in scan.l/gram.y can be
> achieved by adopting the same mechanism as plpgsql does.
If you do that it will likely be rejected outright, because there's
considerable agreement that plpgsql is wrong/broken on
On Tue, Oct 30, 2007 at 02:31:52PM +0100, Gevik Babakhani wrote:
> Hi all,
>
> I am working a lot with custom procedures/functions which are
> implemented in "language sql". At the moment function parameter refs
> cannot work with parameter names. I would like to try to implement
> this. The actua
2007/10/30, Camilo Porto <[EMAIL PROTECTED]>:
> > > I am simulating only 1 client with the Benchmark. Can 1 Client submit
> > > parallel queries, in single-processor enviroment?
> > If this client uses two connections, you can run two queries in paralell.
> The client uses only 1 connection. I
On Tue, Oct 30, 2007 at 03:24:20PM +0100, Zeugswetter Andreas ADI SD wrote:
> > > I think the cool thing that Josh Berkus wants is
> > >
> > > return query select a, b, c from foo;
> > > return query select d, e, f from bar;
> > >
> >
> > maybe better
> >
> > SELECT a,b FROM foo;
> > SELECT d, e
On Tue, Oct 30, 2007 at 11:33:19AM -0300, Alvaro Herrera wrote:
> James Mansion wrote:
> > Josh Berkus wrote:
> >> Not only would they be generally useful for SP programming, but
> >> multisets would eliminate one of the big hurdles in re-writing
> >> T-SQL stored procedures in PG, and thus make it
On Tue, Oct 30, 2007 at 11:31:12AM -0300, Alvaro Herrera wrote:
> David Fetter wrote:
>
> > AS $$
> > BEGIN
> > OPEN $1 FOR SELECT * FROM foo;
> > RETURN NEXT $1;
> > OPEN $2 FOR SELECT * FROM bar;
> > RETURN NEXT $2;
> > END;
> > $$;
>
> I know it. It is ugly as all hell.
Agree
Marc G. Fournier wrote:
> Log Message:
> ---
>
> simple script to pull together a very small (<500k) tar file that builds
> *just* libpq ... its not perfect, as it pulls in more files then is
> necessarily required to build, but as it is, it requires one simple patch
> to configure.in in
> > I think the cool thing that Josh Berkus wants is
> >
> > return query select a, b, c from foo;
> > return query select d, e, f from bar;
> >
>
> maybe better
>
> SELECT a,b FROM foo;
> SELECT d, e FROM bar;
>
> procedure doesn't need return statement usually
The background for Quel was, th
Tom Lane wrote:
> Just for the record, I'd like to put forward the alternative solution
> of removing support for install-strip.
Seconded.
It would also be good to make --enable-debug the default.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replica
James Mansion wrote:
> Josh Berkus wrote:
>> Not only would they be generally useful for SP programming, but
>> multisets would eliminate one of the big hurdles in re-writing T-SQL
>> stored procedures in PG, and thus make it easier to port from SQL
>> Server. You don't hear a lot of demand for mu
David Fetter wrote:
> AS $$
> BEGIN
> OPEN $1 FOR SELECT * FROM foo;
> RETURN NEXT $1;
> OPEN $2 FOR SELECT * FROM bar;
> RETURN NEXT $2;
> END;
> $$;
I know it. It is ugly as all hell.
--
Alvaro Herrerahttp://www.advogato.org/person/alvherre
"El dÃa qu
On Tue, Oct 30, 2007 at 07:53:21AM +, sayali k wrote:
> Hello All,
> I am doing a project in DBMS postgresql. I have the folllowing query : in
> the function exec_simple_query, in which condition does the
> parsetree_list include more than 1 parsetree_items? How are passed to this
> func
[Camilo Porto]
> Date: Sat, 27 Oct 2007 18:12:28 +0100
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
> CC: pgsql-hackers@postgresql.org
>
> 2007/10/27, Camilo Porto <[EMAIL PROTECTED]>:
>
> > The parallelism happens even if my PC
Hi all,
I am working a lot with custom procedures/functions which are implemented in
"language sql". At the moment function parameter refs cannot work with
parameter names. I would like to try to implement this. The actual TODO item is:
Allow SQL-language functions to reference parameters
On Tue, Oct 30, 2007 at 09:48:24AM +0100, Pavel Stehule wrote:
> 2007/10/30, David Fetter <[EMAIL PROTECTED]>:
> > Based on the example in TFM for PL/PgSQL:
> >
> > BEGIN;
> > CREATE TABLE foo(foo_id SERIAL PRIMARY KEY, foo_text TEXT);
> > CREATE TABLE bar(bar_id SERIAL PRIMARY KEY, bar_text TEXT);
2007/10/30, David Fetter <[EMAIL PROTECTED]>:
> On Mon, Oct 29, 2007 at 07:32:11PM -0300, Alvaro Herrera wrote:
> > Gregory Stark wrote:
> > > "Hannu Krosing" <[EMAIL PROTECTED]> writes:
> > >
> > > > What I was referring to, was a "code cleanup" of libpq several
> > > > years ago, when someone (ma
2007/10/29, Alvaro Herrera <[EMAIL PROTECTED]>:
> Gregory Stark wrote:
> > "Hannu Krosing" <[EMAIL PROTECTED]> writes:
> >
> > > What I was referring to, was a "code cleanup" of libpq several years
> > > ago, when someone (maybe Bruce IIRC) removed ability to accept multiple
> > > recordsets from b
Hello All,
I am doing a project in DBMS postgresql. I have the folllowing query : in the
function exec_simple_query, in which condition does the
parsetree_list include more than 1 parsetree_items? How are passed to this
function from the parser/gram.c?
Thanks a lot for all the help in
50 matches
Mail list logo