Hi, how is it with privileges for views and sequences? User other from
owner is set to have full access to DB, this is applied to tables and
functions, but not to views and sequences. I have to specifically give
permission to each view and sequence.
---(end of broadcast)--
version
PostgreSQL 9.2.13 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-11), 64-bit
(1 row)
Thank you
Marek
ver.x86_64 9.2.13-1
PGDG.rhel6 @/postgresql92-server-9.2.
13-1PGDG.rhel6.x86_64
Regards
Marek
-- Původní zpráva --
Od: Tom Lane
Komu: Marek Petr
Datum: 27. 9. 2016 14:55:44
Předmět: Re: [GENERAL] lost synchroniz
Hello,
I'm testing 8.3beta and I think that there is a problem with gist/gin
indexes. The performance of 8.3 is very bad comparing to 8.2. I have a
table with an int[] column indexed using gin (or gist with intarray
module). Table contains about 1.5m rows, int[] length is from 2 to 6
elements.
Marek Lewczuk pisze:
Hello,
I'm testing 8.3beta and I think that there is a problem with gist/gin
indexes. The performance of 8.3 is very bad comparing to 8.2. I have a
table with an int[] column indexed using gin (or gist with intarray
module). Table contains about 1.5m rows, int[] leng
Tom Lane pisze:
I'm wondering if you have an example that doesn't work well with the
gist page-splitting heuristic changes that Teodor put in awhile back.
Those are all in 8.2.5 already, though you might have to REINDEX to
really notice a change if the index was first built with an older
8.2.x re
Hello all,
I'm looking for a C developer that is able to rewrite pl/pgsql functions
to PostgreSQL c functions - because we need better performance we would
like to have all important functions rewritten to c (looking from
pl/pgsql point of view they are not complicated, so I thing that an C
ex
/dane/postgresq/data, and set in .bashrc file of the
postgres user PGDATA variable to /dane/postgresql/data, and maybe to
move configuration files to /etc/postgresql/8.2/main (just as ubuntu
does when installing the database)? Thanks in advance for answers and
hints :-)
Cheers,
On 20 Gru, 16:37, [EMAIL PROTECTED] ("Leonel Nunez") wrote:
> you can leave the instalation as is , and create a tablespace in
> /dane/postgresql and create your databases in the NEW tablespace
>
> take a look at
> :http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html
>
> Leone
Hi,
I'm using composite types within my database and I sometimes need to
modify type either by adding new column or e.g. renaming a column. Of
course I can't do that on existing composite type (actually I can, but
that is quite complicated) so maybe I should use table instead ? With
tables (th
Zdeněk Kotala pisze:
Hello All,
1) What type of names do you prefer?
b) new one with pg_ prefix - pg_createdb, pg_creteuser ...
b
2) How often do you use these tools?
b) one per week
b
3) What name of initdb do you prefer?
c) pg_init
c
4) How do you perform VACUUM?
a) vacuumdb - shell co
Hello,
I have made an upgrade to PG 8.4 and following error was thrown during
execution of some pl/pgsql function:
ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT
CONTEXT: PL/pgSQL function "price_aftertrigger" line 30 at IF
SQL statement "update price set validFrom = $1 , validTo =
2009/7/10 Tom Lane :
> Marek Lewczuk writes:
>> I have made an upgrade to PG 8.4 and following error was thrown during
>> execution of some pl/pgsql function:
>> ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT
>
> Really? Could we see a self-contained example?
for connections that
are in the pool SPI connection was not closed ??
--
Pozdrawiam
Marek Lewczuk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/7/13 Tom Lane :
> No, you're misinterpreting the message. What that code likely means
> is that something is trying to use SPI and finding plpgsql already
> connected. In other words, plpgsql forgets to do a SPI_push() before
> calling something that might try to use SPI re-entrantly. It sh
Hi,
for need of our application we need to get list of tables, that are
used within given SELECT query - we need them in order to track
changes of the data, that may be returned by the query - it is some
kind of caching mechanism, that checks db data modifications. Right
now we create a temporary v
il "commit" and only then the session actually
disconnects?) I'm anxiously assuming that it's not like the next queries after
reconnection will happily be executed outside of a transaction, but I haven't
found much (recent) info on the subject.
Bes
Hi,
On Monday 02 May 2011 16:43:54 Tom Lane wrote:
> Marek Wieckowski writes:
> > If I understand correctly, Tom's reply in:
> > http://archives.postgresql.org/pgsql-general/2007-06/msg01668.php
> > suggests that temp schemas are kept when a session gets disconnected
&
just an idea => it would lead to even less handling
in the client programs (like psql => it would just call PQreconnect() and not
have to issue "begin + create and error").
Best,
~Marek
test=# select * from test1 ;
id | value
+---
1 |11
2 |21
3 |31
On Wednesday 04 May 2011 18:04:16 Tom Lane wrote:
> Marek Wieckowski writes:
> > If there is a script executed in psql there is no easy way to catch that
> > psql has reconnected in the middle of it...
>
> As far as psql goes, it should certainly abandon executing any scri
o work on, then I submit that you have problems you ought to be
> fixing on the server side instead.
Agreed. For your information, it does not happen that often, but when it did
(once in two years...) was scary enough to trigger an investigation.
Tom, thank you very much for your help!
Best,
~M
currently or previously.
Searching through the archives, I have only stumbled upon a post from 2003
about a similar issue
(http://archives.postgresql.org/pgsql-admin/2003-08/msg00239.php) which might
be connected, however, since the reporter gave up quickly, the issue remained
unsolved.
H
e note, obviously, the Windows dump came out alright because it was
from the proper database, not the replicated copy.
Best regards,
Marek Kielar
Dnia 27 lipca 2012 4:46 Adrian Klaver napisał(a):
> On 07/26/2012 04:09 PM, Marek Kielar wrote:
> > Hi,
> >
> > we are using &q
Hi,
Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
> What where the deleted files?
>WAL, Logs, other?
> What type of WAL replication are you doing?
>Streaming, log shipping, etc?
> What are your settings for the WAL replication?
>In particular wal_keep_segments ?
> Is the WAL rep
Hi,
to complement information from the previous message:
Dnia 29 lipca 2012 12:29 Marek Kielar napisał(a):
> Hi,
>
>
> Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
>
> > What where the deleted files?
> >WAL, Logs, other?
>
>
> at this tim
ck;t
virtualxid;3/667499;3/667499;25145;ExclusiveLock;t
relation;11874;1098585/101817;25171;AccessShareLock;t
virtualxid;85/101817;85/101817;25171;ExclusiveLock;t
(4 rows)
We are again approaching slowly the point that the server restart will be
needed. If / when this happens,
since I need to reset the connection almost always, after _any_ timed-out
select(), it is really harmful to my application.
Please, can you tell me, what am I doing wrong?
Thank you very much.
Best regards,
Marek.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
same problem in my
configuration... oh no, is there anybody familiar with this kind of error?
Many thanks,
Marek.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
minutes, couldn't it?
Ordinary telnet or ssh connection will tell me, that I am writing my
characters to TCP line, which has died some time ago.
Thank you for your answers,
Marek.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ction dead.
Well, this is what I wanted to hear. So if I call PQstatus() or PQexec(),
the libpq sends some data to the TCP pipe, and you expect, that my broken
underlying TCP/IP subsystem pretends, that the connection is OK and the
data have been sent. Right?
Thank you very much for your explanat
code with NOTIFY and
select() is all right, then.
Best regards,
Marek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
there are a lot of improvements in hstore, that is planned for PG8.5 -
as far I remember it compiles fine with PG8.4 so is it save to use it
with PG8.4 ?
Thanks.
ML
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
Hello,
there are a lot of improvements in hstore, that is planned for PG8.5 -
as far I remember it compiles fine with PG8.4 so is it save to use it
with PG8.4 ?
Thanks.
ML
--
Pozdrawiam
Marek Lewczuk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
W dniu 2010-02-04 10:46, Marek Lewczuk pisze:
Hello,
there are a lot of improvements in hstore, that is planned for PG8.5 -
as far I remember it compiles fine with PG8.4 so is it save to use it
with PG8.4 ?
Is it SAFE not "is it save"...
ML
--
Sent via pgsql-general mailing l
amp(), '-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
____
Cezariusz Marek mob: +48 608 646 494
Adrian Klaver wrote:
> On Friday, December 30, 2011 6:18:05 am Cezariusz Marek wrote:
>> I need to convert timestamp to a format with a time zone offset, like this:
>> select clock_timestamp()::text;
>> and it returns the following value:
>> "2011-12-30 11:59:0
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
____
Cezariusz Marek mob: +48 608 646 494
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
Cezariusz Marek http://midicat.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
Cezariusz Marekhttp://midicat.net/
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
Cezariusz Marekhttp://midicat.net/
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
____
Cezariusz Marek mob: +48 608 646 494
Cezariusz Marek wrote:
> I need to convert timestamp to a format with a time zone offset, like this:
> [...]
I'm very sorry for multiple posting, those messages were holded because of some
filters,
and now apparently someone ap
2009/2/23 Marek Lewczuk :
> Hello,
> I can't find SQL definition for OVERLAPS operator so I don't know
> whether following expression's result (false) is appropriate
> behaviour:
> select ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps
Hello,
I can't find SQL definition for OVERLAPS operator so I don't know
whether following expression's result (false) is appropriate
behaviour:
select ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps
('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
Can anyone confirm that ? In my under
I was wondering if dropping a table is more efficient in PostgreSQL
8.x in comparison to deleting it's content ?
To put you in the picture - I want to schedule via cron job some daily
data materialization. With the resource I got there are only those two
ways:
1) DROP statement:
a) DROP TABLE tmp
Hello everybody,
we're using postgresql 8.3 for some logging framework.
There are several tables for each day (which are inherited from a common
base), which
- are filled during the day,
- after midnight the indizes are changed to FILLFACTOR=100, and
- the tables get CLUSTERed by the most import
Hello Alvaro,
On Montag, 11. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > A few days before we found the machine much slower, because of the
> > autovacuum processes that were started automatically ["autovacuum: VACUUM
> > ... (to prevent wraparound)"]
On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > we're using postgresql 8.3 for some logging framework.
> >
> > There are several tables for each day (which are inherited from a common
> > base), which
> > - are filled during the day,
> > - after midnight the indizes are changed to FILLFACTOR=1
On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > Do say, do you have any long-running transactions, or "idle"
> > > transactions? Maybe someone opened a terminal somewhere and
On Donnerstag, 14. Mai 2009, Philipp Marek wrote:
> On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> > Philipp Marek wrote:
> > > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > > Do say, do you have any long-running transactions, or "idle"
>
Hi,
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
Thanks in advance.
ML
Christopher Kings-Lynne napisaÅ(a):
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions
Steve - DND napisał(a):
Simple question I'm sure, but how can I get the transaction ID that a query
is currently running in? I can find all kinds of documentation talking about
transaction ids, but nothing about how to get the current one.
You can compile attached function - this will return cu
Tom Lane napisał(a):
Jason Tesser <[EMAIL PROTECTED]> writes:
3. The tools. PgAdmin does some things well but it is lacking the features of
some of the other gui tools.
I'm sure the pgAdmin guys would love having some more help.
What about sqlmanager.net - it the best GUI with number of great
Hello,
I'm implementing db-queries caching system - for this I need to know
each table's modification time (or at least modification counter). I
know that I can make a statement-level trigger, which will update a
table with tables modification times - however this is inefficient if
many insert
Hello,
is there any schedule for final 8.2 release ? As far I remember this
should be around November ? I would like to know that in order to plan
my work.
Thanks in advance.
ML
---(end of broadcast)---
TIP 3: Have you checked our extensive FA
Hello,
I'm trying to update my database to 8.2 version and have some problems
with intarray module. As far I know PG 8.2 contains many features that
are contained within intarray - indexing array fields (using gin),
operators etc. Currently (in PostgreSQL 8.1) I'm using intarray not only
for i
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x420
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x420
Marek Lewczuk pisze:
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc
Tom Lane pisze:
Marek Lewczuk <[EMAIL PROTECTED]> writes:
after suggestions that I should postgres update to the latest (currently
I have 8.2.3) I thought that my problem will be solved. But no, it is
not - postgres still throws warnings:
WARNING: TupleDesc reference leak: Tup
QL.
Best wishes,
Marek
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
omplicated than
simple trigger.
and the current PL/Java works very well. I know C and Java well, and
would be willing to contribute to keeping PL/Java going. I hadn't heard
Great to hear that, please contact with Thomas, lets try to make a
roadmap what need to be done.
Bes
e
pljava ready for 8.3 and continue the development. From windows point of
view this is really great feature to have pljava inside the pgInstaller
(I'm using it on my laptop) so for sure we need to make it ready for 8.3.
Best wishes,
Marek
Thomas Kellerer pisze:
Marek Lewczuk wrote on 23.05.2007 21:37:
I would like to know your opinion about pljava and its future
I have never used Java-in-the-database with any of the DBMS I have used
and I have never understood the reasoning behind it.
My personal opinion is, that it'
hould support 1.6 (I'm using it with pljava without problems -
however I'm not using all new features of Java 6).
Would you like to become committers to the PL/Java project?
You can count on me (only as Java coder or tester).
Regards,
Marek
---(e
ing gin or intarray module) ?
Regards,
Marek
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
7;t vote (unfortunately) :-(
So saying that it's one of the most important features is definitely
wrong. Saying it's important or very important is absolutely not wrong.
You are right, it's very important and I hope that all of us agree with
that statement (may
lp is
needed (in order to have it prepared for 8.3 version) and plan further
development.
Thanks.
Regards,
Marek
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hello,
I would like to ask if my problem with sequence is a proper behavior or
this is a bug (probably not)...
I have a table:
CREATE TABLE "testtable" (
"serialfield" SERIAL,
"someotherfield" TEXT,
PRIMARY KEY("serialfield")
) WITH OIDS;
After creation of this table, sequence "testtable_se
Hello,
I need to use COPY (instead of INSERT) within plperl function. I know
that COPY will work if data will be taken from file - however I need to
use STDIN. I tried this:
spi_exec_query("COPY sometable (field1, field2) FROM
stdin;"."\n"."sometext"."\t"."sometext"."\n"."\.")
But it didn't wor
Goutam Paruchuri wrote:
Why can you not use simple insert statements (sql insert).
Copy is meant to transfer large amount of data from text files to
databases and vice versa.
"Insert" is much slower if there are many (hundreds, thousands) data to
be inserted - and in my case there will be thousand
Hi,
I've made some tests with plperl and I see that when plperl function is
executed for the first time, then it takes much more time. I know that
this is a "shared library" problem - is there a way to preload plperl
every connection or maybe I can build plperl into postgresql source ?
Thanks i
Joe Conway napisaÅ(a):
Marek Lewczuk wrote:
I've made some tests with plperl and I see that when plperl function
is executed for the first time, then it takes much more time. I know
that this is a "shared library" problem - is there a way to preload
plperl every connection or ma
Hello,
is there any way to get current transaction id using plpgsql or sql ?
Thanks in advance for any help.
ML
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" t
Kaloyan Iliev Iliev napisaÅ(a):
Hi
I have the following function:
select int('t'::bool);
ERROR: syntax error at or near "(" at character 11
"int" is reserved for integer type, so you should not use it. However if
you add
namespace before function name "public.int(TRUE)" then it should work.
ML
Michael Fuhr napisaÅ(a):
On Mon, Dec 27, 2004 at 09:52:57AM +0100, Marek Lewczuk wrote:
is there any way to get current transaction id using plpgsql or sql ?
A couple of people have posted suggestions but I'll ask a question:
Why do you want the transaction ID? What problem are you tryi
Joachim Zobel napisaÅ(a):
Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54:
Michael Fuhr napisaÅ(a):
Why do you want the transaction ID? What problem are you trying
to solve?
I've already solved the problem - I found somewhere on the web a very
simple C function, which returns transacti
Hi,
I have a table with many triggers. Now, it can happen that in middle of
execution one of table's triggers there will be unknown error (like
"NEW" is not assigned yet) - is there a way to trace which trigger fired
this error ?
Thanks in advance.
ML
---(end of broadca
fryk napisaÅ(a):
Hi,
How to set such variable after (during?) client connection (PHP)?
I want to use it in view - so view could depends on it:
If I could set client's variable i.e. MY_VAR='hello' then I could do
something like this:
CREATE VIEW my_view AS SELECT * FROM pg_tables WHERE tablename ~*
Hello,
I have a question about IntArray contrib package. The docs says:
"...current implementation provides index support for one-dimensional
array of
int4's - gist__int_ops, suitable for small and medium size of arrays
(used on
default), and gist__intbig_ops for indexing large arrays (we use
s
Hi,
I can't understand how java_reset works - the docs says that "..Since
java does not yet support library versions, the PHP/Java Bridge must be
reset after a new library version has been deployed..." - so in other
words, when we have new version of libraries used by php/java bridge we
can ca
Marek Lewczuk napisał(a):
Hi,
I can't understand how java_reset works - the docs says that "..Since
java does not yet support library versions, the PHP/Java Bridge must be
reset after a new library version has been deployed..." - so in other
words, when we have new version of
I'm looking at "TODO list for PostgreSQL" and "Fix upper()/lower() to
work for multibyte encodings" has no dash (-) -- so it won't be made in
7.5 ?
Another question is about WIN32 native release - currently, all win
users cannot set locales, becouse Cygwin does not support it -- I hope
that it
Kris Jurka wrote:
On Tue, 16 Dec 2003, Marek Lewczuk wrote:
Another question is about WIN32 native release - currently, all win
users cannot set locales, becouse Cygwin does not support it -- I hope
that it will be solved in native release, so UTF-8 should work as well ??
You may be
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
Thanks.
ML
---(end of broadcast)---
TIP
Miso Hlavac wrote:
Hello,
Sorry for just stupid question, but I need use md5 function in 7.4
When I write:
select md5('text');
ERROR: Function md5("unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecast
Tom Lane wrote:
Marek Lewczuk <[EMAIL PROTECTED]> writes:
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
Sure ... just hack
I belive that I have found a bug - or maybe it was done on purpose. Have
a look at this query:
SELECT integer_field FROM bugtable WHERE (CASE WHEN '' <> '' THEN
integer_field = '' ELSE integer_field = 0 END);
Result: ERROR: invalid input syntax for integer: ""
SELECT text_field FROM bugtable W
Alexander Litvinov wrote:
This is normaol behavior.
I belive that I have found a bug - or maybe it was done on purpose. Have
a look at this query:
SELECT integer_field FROM bugtable WHERE (CASE WHEN '' <> '' THEN
integer_field = '' ELSE integer_field = 0 END);
Result: ERROR: invalid input syntax
Richard Huxton wrote:
On Friday 19 December 2003 09:02, Marek Lewczuk wrote:
But until it's evaluated ''<>'' it doesn't know it is false. When building the
CASE expression, it's trying to map types to each elements and notes that ''
is not an
Csaba Nagy wrote:
Because that's a syntax check, which does NOT evaluate any of the
expressions, only the types of them. Even if it will not be executed
ever, it is still wrong, and it should generate an error, because it
means a mistake on your side which potentially could leave to results
you did
Dave Cramer wrote:
connection failed :(
works for me... :-) (poland)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
containing those records but I don't know the
structure of this file.
This is Postgres 7.2.1 on Mandrake 8.1
Marek Nowiński
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hello,
I have a query, which is quite big and there is a huge difference
between execution time in MySQL and PostgreSQL. I think that I have made
all possible steps to increase the speed of the query, but unfortunately
it is still about 100 times slower. I'm out of ideas what to do next,
so ma
Hello,
I've just made successful installation of PostgreSQL 8.0 on Cygwin but I
have some problems with installing tsearch2 contrib module. This is what
make produce:
dict_ispell.o(.text+0x1ec):dict_ispell.c: undefined reference to
`_pg_strcasecmp
'
dict_ispell.o(.text+0x31e):dict_ispell.c: und
hi,
I don't know how insert binary file to table, and how get it from tabel.
Do you now how do it or where I found any info about it ?
In PHP a have function pg_loopen, pg_loread, pg_lowrite...
NETim
[EMAIL PROTECTED]
---(end of broadcast)---
TI
Hello,
I think that there is a bug in plPGSQL - or maybe I don't know something
about this language. Try to create this function
Ok., this is the function created in plPGSQL:
CREATE FUNCTION "public"."test" (text, text) RETURNS text AS'
BEGIN
IF $1 THEN
RETURN $1;
ELSE
RETURN $2;
E
this: http://www.commandprompt.com/entry.lxp?lxpe=260
Best wishes,
Marek L.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hey,
I've searched for MD5 crypting function in PG, but I did not find it.
Anyone knows how to implement this function in PG ?
Best wishes,
Marek L.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
1 - 100 of 122 matches
Mail list logo
