I compiled 8.0.1 on linux with --with-debug only, and it seemed to
work. I had also compiled 8.0.1 on Netbsd with the same configure
option. I removed the tsearch trigger from the table and I had no
problem. I tried using to_tsvector directly and the server crashed.
PostgreSQL stand-alone backend
Julian Scarfe [EMAIL PROTECTED] writes:
Does the planner realise that
the intersection, Query 6, will still return 150 rows, or does it assume
independence of the filters in some way and estimate
20,000*(150/20,000)*(396/20,000)?
From: Tom Lane [EMAIL PROTECTED]
It assumes independence of the
Is there a way to access environment variables from psql? I can't find
any documentation on how to do this:
leif= \! echo $IMPORTDIR
/home/leif/slekta/import/scripts
leif= \i $IMPORTDIR/test.sql
$IMPORTDIR/test.sql: No such file or directory
leif= \i $(IMPORTDIR)/test.sql
$(IMPORTDIR)/test.sql:
hello,
is there some simple way, how to do this???
I need to create user 'diplo' with no database create and no add users
privileges...
createuser -A -D -P -E -U root diplo
after that I create database 'diplo';
I need to import ltree into database 'diplo' with user diplo, but I
can't add
On Sat, 9 Apr 2005, Michal Hlavac wrote:
hello,
is there some simple way, how to do this???
I need to create user 'diplo' with no database create and no add users
privileges...
createuser -A -D -P -E -U root diplo
after that I create database 'diplo';
I need to import ltree into database 'diplo'
Oleg Bartunov wrote:
so, what's the problem ? psql diplo ltree.sql
ok, I can add ltree via superuser, but I must grant access for user
diplo to every function...
it is possible to do that easier?
---(end of broadcast)---
TIP 7: don't forget to
Probably the problem has to do with not finding the underlying
language's DLL (eg, python.dll).
Do I need to install a particular version of python then? Is
there any
further documentation that can help me with this?
Darn if I know. If the installer documentation doesn't tell you,
I'd
On Sat, 9 Apr 2005, Michal Hlavac wrote:
Oleg Bartunov wrote:
so, what's the problem ? psql diplo ltree.sql
ok, I can add ltree via superuser, but I must grant access for user
diplo to every function...
it is possible to do that easier?
Did you try what I recommend you ? It should works
On Saturday 09 April 2005 13:59, Leif B. Kristensen wrote:
Is there a way to access environment variables from psql?
After scrutinizing the psql documentation at
http://www.postgresql.org/docs/8.0/static/app-psql.html, I found that
this actually works:
leif= \set importdir `echo $IMPORTDIR`
I was wondering if there is some way I'm missing to get the table and
column information from a cursor. If I fetch from a cursor, the table
OID and column number values are 0 in the row description. If I execute
the same query directly without a cursor, the row description has the
correct
On Sat, Apr 09, 2005 at 15:19:58 +0200,
Michal Hlavac [EMAIL PROTECTED] wrote:
Oleg Bartunov wrote:
so, what's the problem ? psql diplo ltree.sql
ok, I can add ltree via superuser, but I must grant access for user
diplo to every function...
it is possible to do that easier?
Functions
Magnus Hagander schrieb:
Probably the problem has to do with not finding the underlying
language's DLL (eg, python.dll).
Do I need to install a particular version of python then? Is
there any
further documentation that can help me with this?
Darn if I know. If the
Oleg Bartunov oleg@sai.msu.su writes:
On Sat, 9 Apr 2005, Michal Hlavac wrote:
ok, I can add ltree via superuser, but I must grant access for user
diplo to every function...
Did you try what I recommend you ? It should works
Dunno about ltree, but I have found that the default installation
Ok, I have a stupid-simple table:
create table files (
id serial unique not null,
mime varchar not null,
name varchar not null
);
Idea being that I can save values from a file upload into a table, and use
throughout my application. This gives me a central repository to look for
files
Leif B. Kristensen writes:
So, the problem is solved, sort of. It may also be prudent to save the
old pwd and return there when the work is done:
leif= \set olddir `echo $PWD`
leif= \set importdir `echo $IMPORTDIR`
leif= \cd :importdir
leif= \i test.sql
leif= \cd :olddir
You can
All
Though I understand the MinGW environment is recommended for compiling
all of PostGreSQL on Windows, one can (as stated in the documentation)
use MSVC to compile just the essential client stuff (psql, libpq.dll,
libpq.lib).
This is just a note to observe that the same is possible without
What is the general consensus on using table inheritance? I know it's there,
but is it good, bad, or just dependent on how it's used? I need to track
creation/update information for a large number of tables in my current DB. I
was just going to create a table with the template of fields I was
On Apr 9, 2005 10:55 PM, Steve - DND [EMAIL PROTECTED] wrote:What is the general consensus on using table inheritance? I know it's there,but is it good, bad, or just dependent on how it's used? I need to trackcreation/update information for a large number of tables in my current DB. Iwas just
Sibtay Abbas wrote:
Hello all
Can we check whether a cursor is OPEN or not in plpgsql.
Like in oracle you can check a CURSOR'S state with CURSOR_VAR%ISOPEN
No, but we do have a TODO item:
o Allow pooled connections to list all open WITH HOLD cursors
--
Bruce Momjian
19 matches
Mail list logo