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
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/
FreeBSD-6.2
(PostgreSQL) 8.2.3
Occasionally, when booting up, I receive this error message:
quote
Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database
system is starting up
end quote
Since it only happens occasionally, I have not been able to figure out
what is causing it. It
Gerard Seibert wrote:
FreeBSD-6.2
(PostgreSQL) 8.2.3
Occasionally, when booting up, I receive this error message:
quote
Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database
system is starting up
end quote
Since it only happens occasionally, I have not been able to
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
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)
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
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
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,
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
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, convert
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
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
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
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
Oleg Bartunov oleg@sai.msu.su 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
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 oleg@sai.msu.su wrote:
What version ?
in CVS HEAD I have
postgres=# select to_tsvector('english', 'bh da') =
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:
dfx
# - 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
19 matches
Mail list logo