Robert Deme wrote:
>
> Hello!!
>
> in flagship ( a variant of clipper for unix , http://www.wgs.com/) it is
> an interesting statement "seek eval" ; it scans the index and for every
> position it evaluates a block of code/ function until the function
> return true .
> is in postgresql an interna
How do you locate/create the "libpgtcl.so" in order to run pgaccess under
FreeBSD 4.0 - As far as I can tell, it does not appear to be part of the
pgaccess distribution located under /contrib. This is called by main.tcl as
a required shared library. Thanks.
DLampe -
Marc Britten wrote:
>
> hi again,
>
> i created a trigger on a table for insert or delete, and a function that
> gets created fine.
>
> however when i go to insert something into the table i get
>
> NOTICE: plpgsql: ERROR during compile of create_count_cache near line 2
> ERROR: parse error
Hi,
I would like to use some indexes with functions like substr :
CREATE INDEX IND1 ON T1 ( substr( col1, 1, 5 ) )...
What are the performance of such an index compared to an index on col1...
In which cases will this index be used in a query : Does the where clause
has to match exactly the functi
NEERAJ BANSAL wrote:
>
> Hi,
>
> How do you find that how much storage the data in the database or tables
> is taking in bytes or any other format???
> Is there any command which tells you this???
ls -l /usr/local/pgsql/data/base
As a user with access to this directory, of course. This is ass
On Thu, Jun 15, 2000 at 12:45:52AM +0200, Jan Wieck wrote:
> Believe it or not, but holding pure DB locks over
> "interaction" in an interactive application isn't what you
> really want! The user might go for coffee, and such long time
> locks are not what the
> Warning: PostgresSQL query failed: ERROR: userinfo: Permission denied.
> when I try to connect to a database over the web.
Your web interface is running as a specific user ("nobody"? Something
else??) and this user must be known to Postgres via the createuser
command.
> p.s. Is there any new-u
> and every time the servlets (via web) are accesing to posgres
> database it shows, in the shell, this:
> NOTICE: DateStyle is Postgres with European conventions
Servlets? So are you using JDBC? Some of the interfaces (JDBC is one of
them, afaik) explicitly set the date/time sty
> > > Is it possible to perform a crosstab query in postgres similar the
> > > functionality that MS Access provides?
> > >
> > > I tried building the query in Access (against postgre 6.5.3 using ODBC)
> > > and using the SQL created by Access, but it looks like very non-standard
> > > SQL code an
Hello!!
in flagship ( a variant of clipper for unix , http://www.wgs.com/) it is
an interesting statement "seek eval" ; it scans the index and for every
position it evaluates a block of code/ function until the function
return true .
is in postgresql an internal mechanism or a way to use the ind
With [\200-\377] instead of [\0200-\0377] it works. Sorry.
- R.
I need to select records with description containing chars with highest
bit set but
select * from table where descr ~ '.*ATU[\0200-\0377].*';
fails with error
ERROR: regcomp failed with error invalid character r
I need to select records with description containing chars with highest
bit set but
select * from table where descr ~ '.*ATU[\0200-\0377].*';
fails with error
ERROR: regcomp failed with error invalid character range
Any idea how to work around it? Thanks.
- Robert
P.S. This
I am getting the following error
Warning: PostgresSQL query failed: ERROR: userinfo: Permission denied.
when I try to connect to a database over the web. "userinfo" is the name
of the table I am trying to query. I have tried nearly everything in the
documentation provided to connect and I am
Andrea Aime wrote:
>
> Hi people. I would like to make a query that
> tells me how many distinct values there are
> in a column. Standard count doesn't seems
> to support a count distinct option.
> select distint count(*) of course doens't
> work (distinti clause is applied after the
> result are
Matthias Teege wrote:
>
> Moin,
>
> i have an sql query which works perfect under PostgrSQL
> 6.0 but under 6.5.1 it brings: ERROR: Illegal use of
> aggregates or non-group column in target list.
>
> select T1.id, T1.name, T1.zusatz, T1.kontakt, T1.strasse,
> T1.land, T1.plz, T1.ort, T1.telefax
> Hi people. I would like to make a query that
> tells me how many distinct values there are
> in a column. Standard count doesn't seems
> to support a count distinct option.
> select distint count(*) of course doens't
> work (distinti clause is applied after the
> result are calculated). I've
Hi people. I would like to make a query that
tells me how many distinct values there are
in a column. Standard count doesn't seems
to support a count distinct option.
select distint count(*) of course doens't
work (distinti clause is applied after the
result are calculated). I've tried to define
hi list,
i have restart postgresql with
postmaster -i -o -e &
and every time the servlets (via web) are accesing to posgres
database it shows, in the shell, this:
NOTICE: DateStyle is Postgres with European conventions
thanks
marcos
[EMAIL PROTECTED]
Moin,
i have an sql query which works perfect under PostgrSQL
6.0 but under 6.5.1 it brings: ERROR: Illegal use of
aggregates or non-group column in target list.
select T1.id, T1.name, T1.zusatz, T1.kontakt, T1.strasse,
T1.land, T1.plz, T1.ort, T1.telefax
from debitoren T1, auftrag T2
where T2.
> i have start postgresql doingpostmaster -i &
>
> and this is what i am getting in the shell.
>
> NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
> NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
> NOTICE: DateStyle is Postgres with US (NonEuropean) conve
hi list,
i have start postgresql doingpostmaster -i &
and this is what i am getting in the shell.
NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
NOTICE: DateStyle is Postgres with US (NonEuropean) conventio
Ron Peterson <[EMAIL PROTECTED]> writes:
> > Huh? What is this? Oh, x_id_key somehow survived DROP TABLE.
> > Bummer. Maybe I can use DROP INDEX to drop it?
>
> Close. Try DROP SEQUENCE.
It works, thanks. Are there other things if I need to watch out for
when dropping tables?
Steve Wolfe wrote:
>
>After moving a database to a new machine, I tried a vaccum analyze, and
> get "ERROR: Tuple is too big: size 8180, max size 8140".
>
> I know that there's a limit on the tuple size and all of that - my
> question is: How do I fix it? Vaccum analyze barfs, as does t
23 matches
Mail list logo
