On Wednesday 27 November 2002 06:23, Tom Lane wrote:
> Ian Barwick <[EMAIL PROTECTED]> writes:
> > in 7.3 the following no longer works:
> > template1=> select 0::bool;
> > ERROR: Cannot cast type integer to boolean
>
> Note that
cause the former query works in 7.1.3 and 7.2.1,
but I haven't seen any mention of a change in 7.3 (at
least not in the release notes).
Apologies if this has been discussed to death previously,
but it might be worth mentioning somewhere as a "gotcha".
gression tests is:
| | | null |
| | 0 | zero |
Ian Barwick
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
oin regression test to add ORDER BY in the
> queries Irix differed. Ian, would you retest the CVS version of
> PostgreSQL to see if all the regression tests pass now?
For confirmation: IIRC CVS now requires the latest Bison (1.75)?
(The Irix machine has 1.35).
Ian Barwick
[EM
e the regression.diffs file is here:
http://home.akademie.de/~IBarwick/IRIX_65_regression.diffs
Otherwise no apparent problems and the server started fine.
Ian Barwick
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
no idea whether it's relevant, but maybe you have a problem with
semaphores? See:
http://www.ca.postgresql.org/docs/faq-english.html#3.4
(A lack of available semaphores can also produce the message
"No space left on device.")
Sorry I can't help any further.
Ian Barwick
[EMA
On Tuesday 30 July 2002 00:23, Tom Lane wrote:
> Ian Barwick <[EMAIL PROTECTED]> writes:
> > - Does src/include/postgres_ext.h count as a parser definition file?
>
> No, it doesn't. Your experience sounds like you may have neglected to
> do a full rebuild after alter
#x27;m looking for, so I'm not sure if this
is intended behaviour.
Questions:
- Does src/include/postgres_ext.h count as a parser definition file?
- If not shouldn't the above warning include something like "And
don't even think about changing NAMEDATALEN"?
Apologies
On Wednesday 01 May 2002 06:38, Tom Lane wrote:
> Ian Barwick <[EMAIL PROTECTED]> writes:
> > How can I restrict the query to the schemas in the
> > current search path, i.e. the schema names returned
> > by SELECT current_schemas() ?
>
> Well, this is the issue o
"SELECT bar(1)".
The reason why I posted the question is that I had defined a function
that should have worked, but kept giving me back strange numbers,
so I spent a whole five minutes trying to debug the function before
I realised I was calling it in the wrong way (doh). An error here w
but also this:
func_test=# select bar(1);
bar
---
139059784
(1 row)
What is this number? It often varies from query to query.
Possibly an error-in-disguise because of something to do
with the calling context?
Just curious ;-)
Ian Barwick
---(end of b
>
> See contrib/dblink. The version in cvs HEAD has two that return sets --
> dblink() which returns an int, and dblink_get_pkey() which returns text.
Thanks, now I can see what I was doing wrong
Yours
Ian Barwick
---(end of broadcast)--
On Monday 06 May 2002 18:51, Joe Conway wrote:
(...)
> Request for help:
> -
> So far I've tested with SQL and C functions.
(...)
Can you post an example of a function in C?
(I'm trying out your patch from Friday).
Thanks,
Ian Barwick
---
%%' ESCAPE '$' AND
schema_test->nspname || '.' || relname LIKE 'f%.b%';
schema | object | type | access
++--+
foo| bar| r|
foo2 | bar| r|
(2 rows)
i.e. user "joe" can see which objects e
e got time to work on fixing frontend code, or even helping
> to work out definitional questions like these (...)
Hmm, time for "ask not what your database can do for you but what
you can do for your database". I'm willing to put my keyboard where
my mouth is and take on psql once any outstanding questions are
cleared up, if noone better qualified than me comes
forward and provided someone takes a critical look at anything I do.
Yours
Ian Barwick
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
+
public | abc
foo| abc
foo| xyz
bar| xyz
(4 rows)
How can I restrict the query to the schemas in the
current search path, i.e. the schema names returned
by SELECT current_schemas() ?
Ian Barwick
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
> Ian, do you have another version of this patch ready?
Patch attached (diff against CVS, replacing previous patch).
Ian Barwick
Index: help.c
===
RCS file: /projects/cvsroot/pgsql/src/bin/psql/help.c,v
retrieving revision 1.
101 - 117 of 117 matches
Mail list logo