On Sat, 28 Jun 2003, Joe Conway wrote:
> > Do I need to do something to get new language files?
>
> causing me problems. Did a "cvs add" get missed somewhere, or am I doing
> something wrong?
Yes, a couple of cvs add was forgotten.
Peter made an update with the comment "Merge PO file updates f
On Wed, 25 Jun 2003, Robert Treat wrote:
> Seems like we should also allow for a windows specific distribution of libpq
> as well.
I thought that the win32 stuff was being included as part of the base
distribution? IF so, wouldn't such already be included in any
libpq.tar.gz we created? Is ther
ftp://ftp.kame.net/pub/kame/misc/
has IPv6 datatype patch (makes "inet" type handle both IPv4 and IPv6)
for 7.3.2. let me know how i can proceed/help.
itojun
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
[EMAIL PROTECTED] wrote:
> > I tried to implement LRU-2 awhile ago, and got discouraged when I
> > couldn't see any performance improvement. But I was using pgbench as
> > the test case, and failed to think about its lack of seqscans.
>
> Yes , lru-2 will behave like LRU under 'normal' load. it w
Hi
Can someone give me the email ID of Jan Wieck who has written that
code in ruleutils.c? It is urgent.
Sumit
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's d
I'm not subscribed to this list, so please CC me on replies.
I wanted to know when table partitioning was supposed to be completed. I
was under the impression that work had been done about 5 months ago or
more and that all that was needed was testing. Could someone please
advise?
We're looking at
On Tue, 24 Jun 2003 10:27:09 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> I tried to implement LRU-2 awhile ago, and got discouraged when I
> couldn't see any performance improvement. But I was using pgbench as
> the test case, and failed to think about its lack of seqscans.
How about cache hit
> Well, correct solution is to implement tablespaces on which objects like
> databases, tables and indexes can be put.
I've not looked at the SQL standard, but it seems to me like the order
should be:
Databases
Tablespaces
Schemas
Objects (tables, indexes, functions, etc.)
A
How come you didn't get a "No such function with those arguments" error that I always
get when I do that?
planning=# create function oops (integer) returns int language pltcl as '
planning'# elog NOTICE "blah"
planning'# ';
CREATE FUNCTION
planning=# select oops (cast('duh' as varchar));
ERROR:
My solution did not involve tablespaces, but was more of a quick solution
to make it easier for admins to do _some_ sort of physical configuration.
The idea is that the developer could do something like
'create alternate location ALTERNATE_LOCATION_NAME for
DATABASE_OBJECT_NAME at "/PATH/TO/PHYSI
On Tue, 24 Jun 2003, Tom Lane wrote:
> Yutaka tanida <[EMAIL PROTECTED]> writes:
> > [EMAIL PROTECTED] wrote:
> >> does pgbench test with relatively large sequential scans?
>
> > Probably no.
>
> pgbench tries to avoid any seqscans at all, I believe, so it wouldn't be
> very useful for testing
A minor feature request:
PostgreSQL supports ISO-8601 week numbers with the syntax EXTRACT(WEEK FROM
timestamp) or TO_CHAR(timestamp,'IW'). There is, however, no easy way to
extract the year corresponding to the week number.
Since ISO weeks may overlap year boundaries, this makes the week number
Tatsuo Ishii wrote:
>
> > > > I reported bug #943 (I found in 7.3.2) and you checked in some change against
> > > > integer overflow.
> > > > Now I upgraded to 7.3.3 and I'm not happy with this.
> > > > The exact error as I described is fixed, but I found new errors in conversion
> > > > UTF-8 <
On Tue, 24 Jun 2003 [EMAIL PROTECTED] wrote:
> I was researching on cache replacement strategy as well. 2Q has one
> disadvantage see this exellent paper:
> http://www.almaden.ibm.com/cs/people/dmodha/#ARC see the paper
> "ARC: A Self-Tuning, Low Overhead Replacement Cache" for theory and "One
> U
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The cited error message appears when loading the attached file (a cut-down
> version of a local development version of the information schema)
I've been able to reduce the problem to this test case:
drop view x1;
CREATE VIEW x1 AS
SELECT 1
F
Peter Eisentraut wrote:
It doesn't say anything specifically about multidimensional arrays, but
the grammar clearly allows declaring arrays of arrays.
::=
|
|
|
|
::=
::=
Carlos Guzman Alvarez wrote:
Hello:
>You must send either Flush or Sync after the Parse to force the backend
>to emit its response to Parse. The assumption is that in many cases
>you'll be sending Parse as part of a batch of commands, and the backend
>should batch its responses to minimize t
Tom Lane wrote:
"Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
I'm implementing the 3.0 protocol version in Npgsql, a .Net Data
provider for postgresql.
I stopped in the first message: Parse :(
I send the parse message but I don't receive the ParseComplete or the
ErrorResponse. My code
Joe Conway wrote:
FWIW, I find that if I remove "hr" and "tr" from this line in
/opt/src/pgsql/src/backend/nls.mk, everything goes fine:
AVAIL_LANGUAGES := cs de es hu ru sv zh_CN zh_TW
Do I need to do something to get new language files?
Replying to myself again ;-)
I was a bit too quick to sa
Joe Conway wrote:
Hmmm, I just updated to cvs tip (so I could try this), did `configure`,
`make clean`, and `make all` and I'm getting this failure:
make[2]: Leaving directory `/opt/src/pgsql/src/port'
make -C backend all
make[2]: Entering directory `/opt/src/pgsql/src/backend'
msgfmt -o po/cs.mo
Tom Lane wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out what users are in what
groups.
As of a few minutes
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Btw., it would be really nice if some limited form of this could get done,
> so I could finish the information schema views pertaining to group
> privileges. I'd just need a way to find out what users are in what
> groups.
As of a few minutes ago,
S
Bruce Momjian wrote:
OK, added to TODO:
Modify pg_get_triggerdef() to take a boolean to pretty-print,
and use that as part of pg_dump along with psql
Andreas, can you work on this? I like the idea of removing extra
parens, and merging it into the existing code rather than into co
Another way is to put a little shim between the fifo and psql. Here's one I
quickly whipped up in perl (code stolen shamelessly from the perl man
pages). To run in background, invoke thus
( perl myperlfile myfifo | psql gatabase ) &
The only wrinkle I found was that I had to send the \q twice to
Peter Eisentraut wrote:
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out what users are in what
groups. If unnest() would work for locally constant arguments, I
Tom Lane writes:
> Where is the build log for that build kept now? My bookmark is
> http://developer.postgresql.org/docs/postgres/buildlog.html
> but that doesn't seem to work.
Well, I did the first build manually so the build log wasn't saved, and
the next build will only happen when something
I wrote:
> * Using an array as a table source using UNNEST, something like:
>
> select * from unnest(test.b);
Btw., it would be really nice if some limited form of this could get done,
so I could finish the information schema views pertaining to group
privileges. I'd just need a way to find out
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> The documentation build on developer.postgresql.org is working again.
Good.
Where is the build log for that build kept now? My bookmark is
http://developer.postgresql.org/docs/postgres/buildlog.html
but that doesn't seem to work.
The documentation build on developer.postgresql.org is working again.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere"
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> On the last seven lines of the file I've marked a part that, when removed,
> makes the problem disappear, which might give a hint. Besides that, I'm
> clueless.
Looks like I must have broken this as a side-effect of IN-subselect
optimizations --- 7.3
On Sat, Jun 28, 2003 at 01:25:12AM -0400, Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >>> Will I destroy things if I execute
> >>> update pg_proc set probin = '/usr/lib/pgsql/plpgsql.so' where proname =
> >>> 'plpgsql_call_handler';
> >>
> >> Nope ... that's what I'd p
Rod Taylor writes:
> Attached is a 7.2.4 dump (loads without error) and a 7.4 dump (loads
> with error).
OK, pg_dump wasn't taking into account that earlier versions didn't have
grant options. I'll fix it.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)-
Darko Prenosil writes:
> Can anyone send a "Hint" to translators, so they can start on time to finish
> the work before final 7.4 release ? There is no point to start translating
> now, because as You said, to much messages will be changed in next two
> weeks. Simple message to HACKERS would be en
The cited error message appears when loading the attached file (a cut-down
version of a local development version of the information schema) and then
running
select * from problem_schema.element_types;
On the last seven lines of the file I've marked a part that, when removed,
makes the problem di
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am seeing this assembler warning using gcc version 2.95.3 20010315:
> > {standard input}:332: Warning: using `%si' instead of `%esi' due to `w' uffix
> > {standard input}:332: Warning: using `%ax' instead of `%eax' due to `w' suffi
On Sat, 28 Jun 2003, Jan Wieck wrote:
> Bruce Momjian wrote:
> > See my recent commit of src/tools/pgtest. It might be a good start.
>
> I was wondering if some existing framework, like from the Apache Xalan
> package, would be a better point to start from? I hate to say it, Bruce,
> but you try
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Here's another example of domain casting not working right:
> create domain foo as varchar;
> select cast(x.y as foo) from (select 'foo') as x(y);
> ERROR: coerce_type: no conversion function from "unknown" to foo
Not the domain's fault. You get the
Joe Conway writes:
> I don't see anything about multidimensional arrays at all. I take it
> this is SQL99 (ISO/IEC 9075-2:1999 (E))? Can you point to a more
> specific paragraph?
It doesn't say anything specifically about multidimensional arrays, but
the grammar clearly allows declaring arrays of
Here's another example of domain casting not working right:
create domain foo as varchar;
select cast(x.y as foo) from (select 'foo') as x(y);
ERROR: coerce_type: no conversion function from "unknown" to foo
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)
Bruce Momjian wrote:
See my recent commit of src/tools/pgtest. It might be a good start.
I was wondering if some existing framework, like from the Apache Xalan
package, would be a better point to start from? I hate to say it, Bruce,
but you try to reinvent the wheel by starting with a sled.
Jan
Hello:
>You must send either Flush or Sync after the Parse to force the backend
>to emit its response to Parse. The assumption is that in many cases
>you'll be sending Parse as part of a batch of commands, and the backend
>should batch its responses to minimize the number of network packets
>sent
41 matches
Mail list logo
