I have a script running on PHP v4.3.6 (cgi) that hangs forever
in a call to the Postgres pg_get_result() function when and only
when the query length is 65536 or more bytes.
The query is a simple INSERT, of a single ASCII value into a
'text' type field, and works fine for shorter queries.
(As the
Hi group,
I've installed the win32 binary version of the 8.0beta1 using the
PGInstaller (http://pgfoundry.org/projects/pginstaller).
I've also downloaded the source to compile on our linux boxes and that is
fine. The problem I've got now is building binaries of the contrib folder
for win32 - speci
L.S.
Either the docs or I are missing something
While using libpq I noticed that listen/notify calls were being converted to
lowercase. A further look showed that the listen/notify calls seem to be
totally case insensitive:
free4testing=# select version();
ve
Hi,
I am new to the PostgreSQL world, coming from many years in the Oracle
world (Since Oracle 3).
One feature that I am trying to find in the PostgreSQL database is an
equivalent to Oracle's Virtual Private Database functionnality (also
historically known as Fine-Grained Access Control, and some
hallo,
i am using pg7.3.4. i have written a table function in c that tokenizes
a text, returning a setof text. i can use this function either in
constructs like:
select * from tokenize( 'some text that has to be tokenized' );
or in costructs like:
select tokenize( text_field ) from some_tab
Hi all,
I 'm testing postgres 8.0 beta 1 an i have the following problem. I have
a field with value Γιάννης. If i execute the following query it does not
returns any rows.
select * from test where descr ilike '%γιαννης%'
if i change the query to
select * from test where descr ilike '%γιάννης%'
e
sorry, forget this: it was my fault, now the function works also on pg8.
anyway, it is strange that i can do this with c functions and not with
plpgsql ones...
m.
max jacob wrote:
hallo,
i am using pg7.3.4. i have written a table function in c that
tokenizes a text, returning a setof text. i ca
Hiya,
Not had much experience with tiggers under postgres but am liking them so
far.
My problem is this. I am writing an updates system, postgres holds the
master copy of the database, any changes made to this are logged in an
updates table which is monitored by a daemon, which if
Is there a call redirector available that redirects the calls to the
PHP MySql API (mysql_connect etc.) to a Postgre database? This would
be very usefull since a lot of PHP Scripts are coded for MySQL. I
think for most PHP scripts this would work out since the SQL syntax
from PostgreSQL and MySQL a
Thank you very much.
This works:
UPDATE
test
SET
code=T2.code
FROM
test T2
WHERE
test.code=0 AND
test.master=T2.name;
Igor
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Wed, Aug 11, 2004 at 12:02:07PM -0400, Tom Lane wrote:
> Now erServer did work for them, but it required significant amounts of
> tuning and constant babysitting by the DBA. (If Andrew Sullivan is
> paying attention to this thread, he can offer lots of gory details.)
> I can also personally tes
Hi,
I am currently using pgcrypto functions (encrypt(),
decrypt()) on postgresql 7.4.1. There seems to be a problem when ever I try to
insert a string that contains “\\” (2 slashes next to each other”).
it gives an error message saying that it is not a valid entry for type bytea. I
am u
Can someone explain why I would get different results when using "WHERE
x()" v.s. using "WHERE x() = true" for functions that return a
boolean? We have also seen the query optimizer behave differently
between the two uses when using functional indices.
I am using postgres 7.4.2 and here are the
lec wrote:
Scott Marlowe wrote:
On Sun, 2004-08-08 at 19:43, lec wrote:
Hi,
I'm observing the following:
If I commit the following records 1,2,3,4,5,6,7,8,9,10 to the database
and the server hangs, I could lose records 5,6,7,8,9 but record 10 is
there. How is this possible and do anyone know
Hi
this has been puzzling me for a few days now
I have created a function that I want to use in a database to select a
value from a table based on the value passed in.
The table is fairly simple
REATE TABLE public.feeder_next_status
(
status varchar NOT NULL,
previous_status varchar,
next_
[EMAIL PROTECTED] writes:
> Have I done something wrong?
Yes, misspelled the condition name.
> Exception codes are also absent from the 8.0
> documentation (which looks like it needs an upgrade).
One wonders if you've actually read the 8.0 documentation... see
http://developer.postgresql.org/do
that's cool!
one big stumbling block resolved.!
Next I think I would like to look at the remaining exception handling functionality in PL/SQL
One is clearly user defined exceptions.
The PL/SQL documentation says that one must delare user defined exceptions in the DECLARE block
like:
DECLARE
my_exc
On Aug 15, 2004, at 1:57 AM, [EMAIL PROTECTED] wrote:
Instead of porting each of these procedures by hand,
we would like to add exception handling support to pgSQL if possible.
Today is your lucky day! 8.0 adds exceptions to plpgsql!
8.0 however is in beta. But testers are greatly wanted!
I looked
Nikola Milutinovic wrote:
Hi all.
I've managed to get 8.0.0 up and running. Now I'm compiling some
contributed software and I hit a show stopper. Contrib - DBSize
I believe this has been fixed in current cvs (works for me now). You can
try checking out cvs HEAD, wait for beta2, or apply the diff
Hi all.
I've managed to get 8.0.0 up and running. Now I'm compiling some
contributed software and I hit a show stopper. Contrib - DBSize
Papa-Legba:/home/r/root/5.1/postgresql-8.0.0beta1/contrib/dbsize# gmake
; gmake install
sed 's,MODULE_PATHNAME,$libdir/dbsize,g' dbsize.sql.in >dbsize.sql
cc -
20 matches
Mail list logo