# - Connection Settings -
#listen_addresses = 'localhost' # what IP address(es) to listen on;
listen_addresses = '*' # comma-separated list of addresses;
# defaults to 'localhost', '*' = all
#port = 5432
max_connections = 200
# note: increasing max_connections costs ~400 bytes of shared memo
In stored procedures I used something like
BEGIN
CREATE TEMPORARY TABLE tmp ...
EXCEPTION
WHEN ... THEN ...
END
See pg error codes for details (I don't remember exactly, but maybe it is a
dumplicate_table or duplicate_object exception).
On 3/25/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"d
Well I got version 8.1.4 here and no option for upgrade... never mind I'll
solve my problem in a different way.
Thanks a lot,
Ben-Nes Yonatan
On 3/25/07, Oleg Bartunov wrote:
What version ?
in CVS HEAD I have
postgres=# select to_tsvector('english', 'bh da') = to_tsvector('english',
'bh da'
Oleg Bartunov writes:
> What version ?
> ...
> I think, it should works in 8.2 also.
A look at the CVS log suggests it should work in 8.1.5 and later.
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is you
What version ?
in CVS HEAD I have
postgres=# select to_tsvector('english', 'bh da') = to_tsvector('english', 'bh
da');
?column?
--
t
(1 row)
I think, it should works in 8.2 also.
Oleg
On Sun, 25 Mar 2007, Yonatan Ben-Nes wrote:
Hi all,
I'm trying to compare between 2 tsvector fi
Webb Sprague wrote:
Hi all,
Take a look at pl/r, http://www.joeconway.com/plr/. This is a interface
to R: http://www.r-project.org/
I'm not familiar with this, but i think, this may be helpful for you.
Shoot -- I should have said that I knew about plr -- supposedly a
great project (maybe the
"dfx" <[EMAIL PROTECTED]> writes:
> how I can check the existance of temporary table?
> I.e. wich query I have to use to know if MY_TEMP_TABLE exists?
As of 8.2 you can do
SELECT ... FROM pg_class
WHERE relname = 'whatever' AND relnamespace = pg_my_temp_schema();
In earlier releases pg_my_tem
Hi all,
Take a look at pl/r, http://www.joeconway.com/plr/. This is a interface
to R: http://www.r-project.org/
I'm not familiar with this, but i think, this may be helpful for you.
Shoot -- I should have said that I knew about plr -- supposedly a
great project (maybe the reason there is no ma
Webb Sprague <[EMAIL PROTECTED]> schrieb:
> Hi all,
>
> This is just a random question/idea (I tried googling, but couldn't
> get an answer quickly):
>
> Has anyone written a library to effect linear algebra types and
> operations through Postgres? E.G., convert a float 2-d array to a
> matrix,
AC_SEARCH_LIBS(com_err, [krb5 'krb5 -ldes -lasn1 -lroken' com_err],
[], [AC_MSG_ERROR([could not find function 'com_err' required for
Kerberos 5])]) AC_SEARCH_LIBS(krb5_sendauth, [krb5
'krb5 -ldes -lasn1 -lroken'], [], [AC_MSG_ERROR([could not find
Hi all,
This is just a random question/idea (I tried googling, but couldn't
get an answer quickly):
Has anyone written a library to effect linear algebra types and
operations through Postgres? E.G., convert a float 2-d array to a
matrix, convert a float 1-d array to a vector, multiply them, tak
Hi all,
I'm trying to compare between 2 tsvector fields and I'm encountering a
problem, for example:
test.com=> SELECT 1 WHERE to_tsvector('default', 'bh da') =
to_tsvector('default', 'bh da');
?column?
--
(0 rows)
There is another way that I can check for equality of 2 tsvector fields
On Mar 24, 2007, at 1:06 PM, Jim Nasby wrote:
On Mar 10, 2007, at 4:33 AM, Erik Jones wrote:
I've seen that I can get the total number of blocks read from disk
over the lifetime of a database via the pg_stat_database view, and
by taking successive readings I can track reads over time. How
Josh/Jim-
a ford truck will last just as long and you can get parts at any auto parts
store in the US
the question is do you STILL have the original air freshener?
M-
---
This e-mail message (including attachments, if any)
Domenico-
Assuming your schema will be pg_temp_1
vi InitialTableDisplayStatements.sql
select * from pg_tables where pg_namespace = 'pg_temp1';
/usr/local/pgsql/bin/psql -f InitialTableDisplayStatements.sql -U username -h
dbname -p Port > db.out
then write a quick java app to parse the db.out c
Gerard Seibert wrote:
> FreeBSD-6.2
> (PostgreSQL) 8.2.3
>
> Occasionally, when booting up, I receive this error message:
>
>
>
> Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database
> system is starting up
>
>
>
> Since it only happens occasionally, I have not been able to figu
FreeBSD-6.2
(PostgreSQL) 8.2.3
Occasionally, when booting up, I receive this error message:
Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database
system is starting up
Since it only happens occasionally, I have not been able to figure out
what is causing it. It will usually, alth
A function to authenticate username/password pairs via PAM.
y_pam_auth( username text, password text ) returns bool
http://www.yellowbank.com/code/PostgreSQL/y_pam/
This obviously requires that you trust the server.
Best.
--
Ron Peterson
https://www.yellowbank.com/
--
Dear Sirs,
how I can check the existance of temporary table?
I.e. wich query I have to use to know if MY_TEMP_TABLE exists?
IF EXISTS(??? query ???) THEN
Thank you in advance
Domenico
---(end of broadcast)---
TIP 1: if posting/reading through Us
19 matches
Mail list logo
