Does someone have the Python interface handling large objects
properly? I keep winding up with size 0 objects in PostgreSQL 6.3.2.
Thanx,
Charles Curley wrote:
>
> Ulf Mehlig wrote:
>
> > In my opinion, the regexps are much more powerfull compared to "like
> > '%anything'"-statements; but the regular expression syntax is a little
> > bit weird, and if you have a look in the docs of programs which
> > heavily depend on regexps (per
>
>
> Bob Kruger wrote:
>
> > The second question is that I noticed the ODBC bug (feature?) when linking
> > Postgres to MS Access still exists. This bug occurs when linking a MS
> > Access table to a Postgres table, and identifying more than one field as
> > the unique record identifier. Thi
PostgreSQL 6.3.4 on a Debian GNU/Linux Alpha box is returning dates
far into the future. Has anyone else encountered this?
Sample psql session:
template1=> select 'now'::datetime;
?column?
Thu Dec 16 23:08:02 2134
(1 row)
Might this be a silly 64-bit p
Bob Kruger wrote:
The second question is that I noticed the ODBC bug
(feature?) when linking
Postgres to MS Access still exists. This bug occurs when linking
a MS
Access table to a Postgres table, and identifying more than one field
as
the unique record identifier. This makes Postgres run unt
Ulf Mehlig wrote:
> In my opinion, the regexps are much more powerfull compared to "like
> '%anything'"-statements; but the regular expression syntax is a little
> bit weird, and if you have a look in the docs of programs which
> heavily depend on regexps (perl, grep, emacs, ...) you'll find so
I have 4.1.4. My last compile was flawless other then a few tweaks necessary for
plpgsq. Your not that far yet.
>From what I can see apparent what your problem is.
mkldexport.sh is a script calls nm.
nm is a UNIX utility for extracting external symbols from executables and such.
It lo
Hi,
I am joining two or more tables on the column that has quite a number
of nulls, assuming 'a.key = b.key' to be a valid expression even when
both operands are NULLs. The result set is way smaller that I
expect. Could that be because the two NULLs do not match?
I guess there are two possible
At 19:07 +0200 on 9/11/98, Bob Kruger wrote:
>
> I do have two questions. Firstly, I have one table that is updated from a
> text file. This table also has a serial field that is incremented with
> each new record. Is there a way to use the copy command to have that field
> automatically upda
Wim Ceulemans <[EMAIL PROTECTED]> wrote
> select * from tablex where name ~* 'test';
>
> But this is not quite the same because it also finds for example
> 'tempest', whereas the like search does not find it. So is there a
> postgreSQL operator that does the same as the like %% search but
First off, I would like to take this opportunity to thank everyone who
worked on the new postgres v6.4. I have it up and working here, and most
all appears well.
I do have two questions. Firstly, I have one table that is updated from a
text file. This table also has a serial field th
>
> pg_dump seems to be getting a little confused on ACLs, look at this:
>
> REVOKE ALL on "cat" from PUBLIC;
> GRANT ALL on "nobody" to "nobody";
>
> For everything that has any differing priveleges, it does the same
> grant (which, of course, doesn't work).
What PostgreSQL versio
At 18:08 +0200 on 9/11/98, Memphisto wrote:
> I have the following problem: A Netscape Enterprise web server is running
> on an AIX where I installed a PostgreSQL DBMS. The web server is running
> on 'wwwin' account and it's cgis must have access to PostgreSQL tables.
> My question is that I can
Fuad Abdallah wrote:
I have just compiles postgres-6.4 under irix 6.5.1 with the SGI cc
v7.2.1
> and everything seems to work fine - the regression test works with some
> minor deviations - but i can not delete a database.
> destroydb fails with the following error:
>
> ERROR: typeidTypeRelid:
I have the following problem: A Netscape Enterprise web server is running
on an AIX where I installed a PostgreSQL DBMS. The web server is running
on 'wwwin' account and it's cgis must have access to PostgreSQL tables.
My question is that I can make table so that they can be manipulated from
multi
Hi,
first of all i must say that i have just started reading this list so
please excuse if am off topic.
I have just compiles postgres-6.4 under irix 6.5.1 with the SGI cc v7.2.1
and everything seems to work fine - the regression test works with some
minor deviations - but i can not delete a dat
Does anyone have exeperiences with AIX4.2/postgreSQL 6.3.2?
Now I'm unable to compile it I've got the following error message:
bash-2.01$ gmake
Making postgres.imp
./backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/bin >
postgres.imp
nm: postgres: 0654-200 Cannot open the specified file.
hi!
I'm not shure that syntax you have used is correct, I mean that better is:
select * from tablex where name LIKE '%test%';
or you can also try "~~" operator that is used in Postgres as synonym to
"LIKE":
select * from tablex where name ~~ '%test%';
Regarding your second example:
select * fro
6.4 doesn't seem to get along with FreeBSD 3.0-RELEASE well - if at
all.
In particular, some regression tests failed that I wouldn't expect to
- int8, sanity_check, trigers, misc, alter_table - and trying to
create databases with schema from 6.3.2 causes the backed to exit
unexpectedly.
Yet Free
At 11:30 +0200 on 9/11/98, Wim Ceulemans wrote:
> select * from tablex where name ~* 'test';
>
> But this is not quite the same because it also finds for example 'tempest',
> whereas the like search does not find it. So is there a postgreSQL operator
> that does the same as the like %% search bu
Hi
A 'contains' search in postgreSQL is:
select * from tablex where name = '%test%';
When I want exactly the same but case insensitive, how do I do that? By
searching through the mail archive I came up with:
select * from tablex where name ~* 'test';
But this is not quite the same because it
pg_dump seems to be getting a little confused on ACLs, look at this:
REVOKE ALL on "cat" from PUBLIC;
GRANT ALL on "nobody" to "nobody";
For everything that has any differing priveleges, it does the same
grant (which, of course, doesn't work).
--
SA, beyond.com My gir
22 matches
Mail list logo
