> regression=# SELECT update_pg_pwd();
> ERROR: getTypeOutputInfo: Cache lookup of type 0 failed
>
> which is not exactly pretty, but it beats a core dump. "SELECT NULL"
> still works.
Maybe the regression test database should have tests for all the built-in
functions?
Chris
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Feel free to wack it around.
Removing the special-case logic in ExecTypeFromTL yields
regression=# SELECT update_pg_pwd();
ERROR: getTypeOutputInfo: Cache lookup of type 0 failed
which is not exactly pretty, but it beats a core dump. "SELECT NULL"
s
Sorry about including the regression test changes in that last patch - just
ignore them.
Since sending in that last patch, I've fixed preproc.y to use 5 instead of 6
as the number of params to concatenate...
Chris
---(end of broadcast)---
TIP 2:
Hi all,
This message didn't seem to go through - am I being blocked by the list
server? Let's see if it does this time...
> -Original Message-
> From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 20 March 2002 1:10 PM
> To: Hackers
> Subject: Help with SET NULL/
On Thu, 2002-03-21 at 00:16, Tom Lane wrote:
> [EMAIL PROTECTED] (Neil Conway) writes:
> >> If we're going to change the structure anyway, let's fix it to be
> >> independent of NAMEDATALEN.
>
> > Sounds good. If we're making other backwards-incompatible changes to
> > pgNotify, one thing that bu
[EMAIL PROTECTED] (Neil Conway) writes:
>> If we're going to change the structure anyway, let's fix it to be
>> independent of NAMEDATALEN.
> Sounds good. If we're making other backwards-incompatible changes to
> pgNotify, one thing that bugs me about the API is the use of "relname"
> to refer to
Neil Conway wrote:
> On Wed, Mar 20, 2002 at 04:10:14PM -0500, Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > The breakage will come when we lengthen NAMEDATALEN, which I plan to
> > > tackle for 7.3. We will need to re-order the NOTIFY structure and put
> > > the NAMEDATALEN
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > If I do this as any user:
> > SELECT update_pg_pwd();
> > it crashes all backends and causes a server-wide restart. Is this
> > acceptable behavior?
>
> There are a number of things we might blame this on, all having to do
> wit
Bruce Momjian <[EMAIL PROTECTED]> writes:
> If I do this as any user:
> SELECT update_pg_pwd();
> it crashes all backends and causes a server-wide restart. Is this
> acceptable behavior?
There are a number of things we might blame this on, all having to do
with the overuse of type OID zero
On Wed, Mar 20, 2002 at 04:10:14PM -0500, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > The breakage will come when we lengthen NAMEDATALEN, which I plan to
> > tackle for 7.3. We will need to re-order the NOTIFY structure and put
> > the NAMEDATALEN string at the end of the str
Does the same thing here.
Sounds like a serious problem to me too.
Greg
On Wed, 2002-03-20 at 20:46, Bruce Momjian wrote:
> If I do this as any user:
>
> SELECT update_pg_pwd();
>
> it crashes all backends and causes a server-wide restart. Is this
> acceptable behavior? I am sure ther
If I do this as any user:
SELECT update_pg_pwd();
it crashes all backends and causes a server-wide restart. Is this
acceptable behavior? I am sure there are other cases too. Isn't it a
problem that we let ordinary users crash the server and cause a restart?
--
Okay. Anyway, the semaphores are apparently used for purposes other than
TAS. That can be made faster too, on platforms which support POSIX
mutexes (shared between processes).
"Robert E. Bruccoleri" wrote:
>
> Dear Igor,
>
> > I am confused to hell. I always thought MIPS does NOT have TAS
> > i
Dear Igor,
> I am confused to hell. I always thought MIPS does NOT have TAS
> instruction ;)
On the SGI platform, there are very high speed implementations of test
and set which allow large number of processes to safely and quickly
access shared memory. SGI has a hardware team that specifies MIP
I am confused to hell. I always thought MIPS does NOT have TAS
instruction ;)
"Robert E. Bruccoleri" wrote:
>
> Dear Igor,
>
> Igor Kovalenko writes:
>
> > Makes me wonder... perhaps now someone will be convinced to take a look
> > at the POSIX IPC patch. On some platforms (not on Linux I am a
Dear Igor,
Igor Kovalenko writes:
> Makes me wonder... perhaps now someone will be convinced to take a look
> at the POSIX IPC patch. On some platforms (not on Linux I am afraid)
> POSIX mutexes might be quite a bit faster than SYSV semaphores.
Yes, but on the SGI platform, the MIPS test_and_se
Tom Lane wrote:
>
> Any thoughts?
>
As we are talking about CAST,
if one CASTs to a domain, SQL99 says we have to check the constraints
and issue a "integrity constraint violation" if appropriate (6.22, GR 21).
--
Fernando Nasser
Red Hat - Toronto E-Mail: [EMAIL PROTE
Tom Lane wrote:
>
> (...) or put a special case into the operator selection rules to reduce
> domains to their basetypes before making the "exact match" test.
By definition,
which I believe should be read as
"A domain is a set of permissible values (of a data type)".
What I am trying to sa
Bruce Momjian <[EMAIL PROTECTED]> writes:
> The breakage will come when we lengthen NAMEDATALEN, which I plan to
> tackle for 7.3. We will need to re-order the NOTIFY structure and put
> the NAMEDATALEN string at the end of the struct so differing namedatalen
> backend/clients will work. If you
Makes me wonder... perhaps now someone will be convinced to take a look
at the POSIX IPC patch. On some platforms (not on Linux I am afraid)
POSIX mutexes might be quite a bit faster than SYSV semaphores.
Luis Alberto Amigo Navarro wrote:
>
> Hi all:
> again on performance, here is an extract fr
I wrote:
> I am thinking that a non-broken approach would involve (1) treating
> a domain as binary-compatible with its base type, and therefore with
> all other domains on the same base type, and (2) allowing a coercion
> function that produces the base type to be used to produce the domain
> typ
Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Tom Lane writes:
> >> Hmm. Looks like we need a wholesale revision of command tags, indeed.
>
> > We would need to do:
>
> > ALTER -> ALTER
> > DROP -> DROP
> > CREATE -> CREATE
> > Those look reasonable, and we already do
Fernando Nasser <[EMAIL PROTECTED]> writes:
> Yes, I am supposed to see if I can fix this and get rid of the "into"
> field in SelectStmt at the same time. Right Tom?
Yeah, we had talked about that ... but I'm not sure it's worth the
trouble. I don't see any clean way for the SELECT grammar rul
D'Arcy J.M. Cain writes:
> Do you have a reference for this? I tried looking for one but the only
> thing I could find was http://www.python.org/doc/1.6/dist/built-dist.html
> which suggests to me that they can be compiled before shipping which of
> course certainly involves moving them. In any
Jasbir D wrote:
> Checkout Firebird as well - which appears to be the other alternative.
>
> http://firebird.sourceforge.net/index.php
>
> q: How does open source affect the costs for companies which use
> Interbase or Firebird as an embedded server?
>
> a: Firebird server and client are
Hi,
I have something that do exactly what you are looking for (and more)
but damned it's perl stuff !
You just have to set your SQL queries into XML files, associate
XSL template to them and run a cgi perl script througth apache (with or
without mod_perl). You can also add perl procedures to pro
* Peter Eisentraut <[EMAIL PROTECTED]> [011106 20:01]:
> D'Arcy J.M. Cain writes:
> > I have a change I would like to discuss. It doesn't change the code
> > base, only the build system. The patches I would like to commit follow
> > this text. The only thing it does is create a config option to
Tom Lane wrote:
>
> > It also seems to me that CREATE TABLE AS should not print "SELECT". I
> > thought Fernando Nasser had fixed that.
>
> No, I think it's still on his to-do list (we didn't like his first
> proposed patch for it).
>
Yes, I am supposed to see if I can fix this and get rid of
> You have to write xmlGetUser() to take in the userid and return the
> xml required for it. I see no advantage to generating the xml in the
> db rather than in the servlet.
As a counterexample, my PKIX extensions defined an "XML" datatype
that could be used to generate XML instead of the standa
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Hmm. Looks like we need a wholesale revision of command tags, indeed.
> We would need to do:
> ALTER -> ALTER
> DROP -> DROP
> CREATE -> CREATE
> Those look reasonable, and we already do that in some cases.
These seem oka
Hi all:
again on performance, here is an extract from an 8 read-only queries, notice
that total time is 179s and it is expending about 80secs only in semaphores
Isn't there any other way to improve ipc-locks?
thanks and regards.
---(end of broadcast)--
Tom Lane writes:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> >> What's standard about it?
>
> > ISO/IEC 9075-2:1999 clause 19.1 general rule 1 c) to be exact. ;-)
>
> Hmm. Looks like we need a wholesale revision of command tags, indeed.
> At least if we want to consider command tags to be t
On Fri, 15 Mar 2002, longjohn wrote:
> Do U know if pgSQL supports XML ?
> 4 example : BROWSER->APACHE JSERV->SERVLET->DB->xsl+xml->HTML
There's some xml stuff in the contrib directory of the PostgreSQL
distribution.
Vince.
--
===
On Tue, Mar 19, 2002 at 08:28:19PM -0500, Neil Conway wrote:
> On Tue, 2002-03-19 at 19:20, F Harvell wrote:
> > I feel that the caching should be SQL transparent. If it is
> > implemented reasonably well, the performance gain should be pretty
> > much universal.
>
> Well, the simple query cache
On Fri, 2002-03-15 at 15:44, longjohn wrote:
> Do U know if pgSQL supports XML ?
> 4 example : BROWSER->APACHE JSERV->SERVLET->DB->xsl+xml->HTML
Not natively, you need extra tier that will do (DB->xml)
> Do U know any open source DB doing that?
Check http://dmoz.org/Computers/Software/Databases
Yury Bokhoncovich <[EMAIL PROTECTED]> writes:
> Does anybody know a reason parse_datestyle_internal always returns TRUE?
Ancient history. Before GUC there were lots more routines and a lot
of control structure in variable.c; the return value of the parse/set
functions was used for something or o
> Is it valid to change a constant in src/include/miscadmin.h?
> -#define USE_POSTGRES_DATES 0
> +#define USE_POSTGRES_DATES 4
Yes, the code should still work and afaik these values are not embedded
anywhere other than in the compiled code so you will stay
self-consistant.
> Does anybody know a reason parse_datestyle_internal always returns TRUE?
It does not. However, if the code has not errored out on elog() calls
beforehand, the routine does return TRUE.
- Thomas
---(end of broadcast)---
TI
Please search the archives and then direct these sorts of questions to the
pgsql-general list. This list relates to the development of PostgreSQL.
Gavin
On Fri, 15 Mar 2002, longjohn wrote:
> Do U know if pgSQL supports XML ?
> 4 example : BROWSER->APACHE JSERV->SERVLET->DB->xsl+xml->HTML
> Do
If it's a servlet calling the database in your example, the below can
be accomplished through the use of procedures which create the XML in
question and return it.
Ie. select xmlGetUser(userid);
You have to write xmlGetUser() to take in the userid and return the
xml required for it. I see no a
I'm inclined to go to that thesis defense. Sounds
quite interesting :)
-s
- Original Message -
From: "MONKIEWICZ Halina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 1:14 PM
Subject: [General] master thesis defence, Xin Shen, Wed. March 2
This is the c code section and sql section that I need for casting Object reference
column
If anyone know there is an internal one is already build, please let me know.
If not I'm just wondering we can put that into the src. This will allow all
object reference column to cast back as oid like
On Fri, 15 Mar 2002, Vadim Mikheev wrote:
> > But sequences should not be under transaction control. Can you
> > safely rollback a sequence? No! The only way to ensure that would
> ...
> > Placing a restriction on an application that says it must treat the values
> > returned from a sequence a
On Fri, 15 Mar 2002, Tom Lane wrote:
> "'Ben Grimm'" <[EMAIL PROTECTED]> writes:
> > When these bugs are fixed there is still the issue of bug #3 that I
> > came across. The one that I work around by resetting log_cnt to 0 when a
> > backend initializes a sequence. It's this third bug that ma
Do U know if pgSQL supports XML ?
4 example : BROWSER->APACHE JSERV->SERVLET->DB->xsl+xml->HTML
Do U know any open source DB doing that?
Thanks a lot
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.o
Hello!
Is it valid to change a constant in src/include/miscadmin.h?
===
@@ -150,10 +150,10 @@
#define MAXTZLEN 10 /* max TZ name len, not counting tr.
null */
-#define USE_POSTGRES_DATES 0
#define USE_ISO_DATES
On Thu, 14 Mar 2002, Tom Lane wrote:
>
> If you do a SELECT nextval() and then use the returned value externally
> *without waiting for a commit acknowledgement*, then I think you are
> risking trouble; there's no guarantee that the WAL record (if one is
> needed) has hit disk yet, and so a crash
On Thu, 14 Mar 2002, Mikheev, Vadim wrote:
> And it's not. But behaviour of application *must* be
> conditional on was transaction committed or not.
>
> What's the problem for application that need nextval() for
> external (out-of-database) purposes to use sequence values
> only after transactio
I don't fully understand the xlog files or WAL records but...
Why isn't the writing of the WAL record based on the CACHE value of the
sequence? If a request to nextval() can't be satisfied by the cache,
the sequence on disk should be updated resulting in a WAL record being
written.
If two sessi
On Thu, 14 Mar 2002, Tom Pfau wrote:
> I don't fully understand the xlog files or WAL records but...
>
> Why isn't the writing of the WAL record based on the CACHE value of the
> sequence? If a request to nextval() can't be satisfied by the cache,
> the sequence on disk should be updated result
Hello!
Does anybody know a reason parse_datestyle_internal always returns TRUE?
--
WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED]
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.
--
postgres is compiled with Mipspro compiler, how may i prepare it for
profiling.
Thanks and regards
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL P
52 matches
Mail list logo
