Marco Catunda [EMAIL PROTECTED] writes:
naslog=# explain select * from desconexao where time = '2000-12-01';
NOTICE: QUERY PLAN:
Index Scan using time_idx on desconexao (cost=0.00..20.18 rows=5
width=103)
naslog=# explain select * from desconexao where time
I am trying to create an index on the date_trunc('day', columna) in a table.
When I try to create this index, I get a parse error near the single quote.
Is there a workaround to create this index? I am using v7.0.3 on FreeBSD.
-Nathan Barnett
hi guys
I wish to connect to the database thru a cron job and do some sql queries,,
However i am having problems in connecting to the database thru the shell
script.. I am unable to pass the password..
I have been trying to do the following
#! /bin/sh
psql -h localhost db1 -U foo -c "select
hi guys
how to connect as a different user to a different db using the \connect
command.. I dont see any option for specifing the password or the host to
which i want to connect .
Am i missing something..
Thanx for any suggestions
Anand
Is there any documentation on what can be configured between PostgreSQL and Access?
-Original Message-
From: Jose Soares [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 3:59 AM
To: Siuda Pawe? DI Centrala
Cc: '[EMAIL PROTECTED]'
Subject:Re: Table msysconf
On Thu, 4 Jan 2001, Anand Raman wrote:
hi guys
I wish to connect to the database thru a cron job and do some sql queries,,
However i am having problems in connecting to the database thru the shell
script.. I am unable to pass the password..
I have been trying to do the following
#!
Can I test for an existing table before issuing the "CREATE TABLE" command?
IF EXISTS employees{
DROP TABLE employees
}
CREATE TABLE employees
Can you provide an example of this. I couldn't find this in the manual or
Bruce's book - did I not look hard enough ? :)
- -
* Alvaro Herrera [EMAIL PROTECTED] [010104 13:32]:
On Thu, 4 Jan 2001, Anand Raman wrote:
hi guys
I wish to connect to the database thru a cron job and do some sql queries,,
However i am having problems in connecting to the database thru the shell
script.. I am unable to pass the
Here's my situation: I have the following relation
table A --- table B
1:N
I created the two tables, and a foreign key from A into B. Now I want to
create other tables that inherit from B, but I want that the relation
exists for all of them. For that, I created another
Have a FreeBSD 4.2 box... have created two Virtual machines with the
jail process.
Apache and PHp configure and execute fine, but am having some
configuration and execution problems with pgsql... not sure if I am
missing something or if pgsql just cannot deal with being in the jail
and sharing
Hi!
I wan't to know how often do i have to do this. If i do a lot of
inserts, my SELECTS are very slow, but if I Vacum the table it's
better. do i have to vacum every insert?
Thanks.
--
Uro Gruber
"Anand Raman" wrote:
hi guys
how to connect as a different user to a different db using the \connect
command.. I dont see any option for specifing the password or the host to
which i want to connect .
\connect database user
The password is then prompted for, if appropriate.
You can't
Nelio Alves Pereira Filho wrote:
Here's my situation: I have the following relation
table A --- table B
1:N
I created the two tables, and a foreign key from A into B. Now I want to
create other tables that inherit from B, but I want that the relation
exists
Is it planned to include these features to class inheritance?
Nelio
Oliver Elphick wrote:
Nelio Alves Pereira Filho wrote:
Here's my situation: I have the following relation
table A --- table B
1:N
I created the two tables, and a foreign key from A
hi guys
I am trying to create a shell script which dumps my db to a flat file ..
To dump the database i use the pg_dump command..
I find that irrespective of the fact whether pg_dump managed to connect
to the db or not the return status ($?) is always zero.. This throws the
shell script in a
Yeah,
DROP TABLE employees
CREATE TABLE employees
;-)
Craig
-Original Message-
From: Soma Interesting [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 1:40 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Test for existence of Table
Can I test for an existing table before
On Thu, Jan 04, 2001 at 05:04:50PM -0500, Dave VanAuken wrote:
Have a FreeBSD 4.2 box... have created two Virtual machines with the
jail process.
Apache and PHp configure and execute fine, but am having some
configuration and execution problems with pgsql... not sure if I am
missing
At 12:09 PM 4/01/2001 -0500, you wrote:
No, the times in the database are all GMT. They will get *displayed*
with some particular timezone offset, as determined by the TIMEZONE
SET variable.
You have to set TIMEZONE to your local timezone if you want dates
displayed in something other than the
Hi,
Say I have two applications A and B communicating via a postgresql
database. A sends data for B to work on.
How can I get B to _wait_ for a signal from A before proceeding?
Right now it looks like B has to keep polling regularly. So in order for
things to occur in a timely fashion the
Lincoln Yeoh [EMAIL PROTECTED] writes:
Basically you now can have apps use the database for instant messaging :).
My former company was doing that since Postgres 6.4 or so.
Right now it looks like B has to keep polling regularly.
No, it just has to use select() to wait on the postgres
[GENERAL only -- got MX errors on two of the addressees]
Peter Eisentraut wrote:
jpilley writes:
I do not have a /usr/share/doc/postgresql-* (or equivalent path) :). I
would love to read
the README.rpm file, if the 7.0.3 rpm had left me one!
On my system this file belongs to package
Gordan Bobic wrote:
Here's a crypted password: 00xNyXeahk4NU. I crypted it in perl as
crypt(guessme, salt). So what is guessme?
The point of a one way hash is that it's, well, one way. Pretty much
the only way you're going to figure out what password that encrypted
string
At 10:47 PM 04-01-2001 -0500, you wrote:
Lincoln Yeoh [EMAIL PROTECTED] writes:
Basically LISTEN doesn't wait.
LISTEN has nothing to do with waiting. It merely informs the backend
of your interest in subsequently receiving notices of a particular type.
Perhaps you should think of it as like
On Thu, Jan 04, 2001 at 10:53:12PM -0500, some SMTP stream spewed forth:
Gordan Bobic wrote:
Here's a crypted password: 00xNyXeahk4NU. I crypted it in perl as
crypt(guessme, salt). So what is guessme?
The point of a one way hash is that it's, well, one way. Pretty much
the
Lincoln Yeoh [EMAIL PROTECTED] writes:
Uhoh, since I'm using perl does that mean I have to patch DBI and Pg::DBD?
Couldn't say. I didn't have much trouble setting up a Tcl application
to work smoothly with NOTIFY events, but I've never tried such a thing
in Perl. Any Perl gurus out there who
read the jail man page:
jail.sysvipc_allowed
This MIB entry determines whether or not processes within a jail
have access to System V IPC primitives. In the current jail imple-
mentation, System V primitives share a single namespace across the
host
On Thu, 04 Jan 2001 05:12:25 Anand Raman wrote:
I am trying to create a shell script which dumps my db to a flat file ..
To dump the database i use the pg_dump command..
I find that irrespective of the fact whether pg_dump managed to connect
to the db or not the return status ($?) is always
At 11:27 PM 04-01-2001 -0500, Tom Lane wrote:
Lincoln Yeoh [EMAIL PROTECTED] writes:
Would it be viable idea to add a WAIT command/statement for higher level
access (e.g. "SQL" level access to this feature)?
Strikes me as pretty useless. If you were to PQexec("WAIT foo") then
your
28 matches
Mail list logo
