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 a
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 alway
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 a
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 wh
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(, salt). So what is ?
> > >
> > > The point of a one way hash is that it's, well, one way. Pretty much
> > > t
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
Gordan Bobic wrote:
>
> > Here's a crypted password: 00xNyXeahk4NU. I crypted it in perl as
> > crypt(, salt). So what is ?
> >
> > 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 correspon
[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
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 con
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 polli
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
> DROP TABLE employees
Error: ERROR: Relation 'employees' does not exist
And execution halts which is I believe why he wanted to check for the
existence before trying to DROP. I'd love to know if this exists as well...
would come in very handy during development time.
Greg
> Yeah,
>
> DROP
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 som
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 issui
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 sp
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 foreig
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
"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
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
I have a bunch of users on my system, and I would like a way, possibly using
quotas or some such thing, to restrict the size people can make their
databases. I would like it if it were per-user rather than global, so one user
can't mess up everyone. It would be especially nice if I could incorpora
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 th
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 tab
* 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 pas
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 ? :)
- -
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
>
> #!
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
Is it possible to create schemas and generate them into the database
through pgaccess??
What I really wanted to do is a tool where I could model the entities,
creating the tables, indexes, triggers, etc, on the fly..
Thanks in advance
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
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
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 curre
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 postgresql-7.0.2-17, but the
packaging has not changed with 7.0.3. On your system the
Is it possible to create schemas and generate them into the database
through pgaccess??
What I really wanted to do is a tool where I could model the entities,
creating the tables, indexes, triggers, etc, on the fly..
Thanks in advance
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+
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
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 > '2
33 matches
Mail list logo
