[postres@kc131-161 /usr/local/opt/Postgres/data/global]# ls -la
total 170
drwx-- 2 postgres dbadmin 512 Oct 15 18:09 .
drwx-- 5 postgres dbadmin 512 Oct 15 18:00 ..
-rw--- 1 postgres dbadmin8192 Oct 15 18:10 1260
-rw--- 1 postgres dbadmin 0 Oct 15 17:59
On 17 Oct 2001, Arcady Genkin wrote:
What I want is an SQL equivallent of \ds command, which will return
a list of all sequences in the current database. I need this for a
periodically run script so that I could keep an eye on all sequences
in the database.
\ds *is* the psql command for
On 17 Oct 2001, Arcady Genkin wrote:
Where does Postgres store information about the sequences? I tried
looking in the tables produced by \dS, but could find no references
to the sequences. :(
Oops, I thought you had made a typo, but I made a thinko. Use the -E
option to generate the SQL
At 16/10/01 14.00, you wrote:
Does the python interface leak memory? We are seeing the process grow
with basically every select. Any suggestions on what's going on? There
are no cycles, and a trivial program (basically a loop around a select)
demonstrates the problem.
This is 7.1.2 on RH7.[01].
On Wed, 2001-10-17 at 16:56, Denis Gasparin wrote:
At 16/10/01 14.00, you wrote:
Does the python interface leak memory? We are seeing the process grow
with basically every select. Any suggestions on what's going on? There
are no cycles, and a trivial program (basically a loop around a select)
I am developing a system to take a generic data structure and store it in a
PostgreSQL database. The data structure contains several entries of the
following:
insert a record into table1
field1 value1
field2 value2
insert a record into table2
field1 value1
field2 value2
Data for different
Stephen Robert Norris [EMAIL PROTECTED] writes:
Actually, it's a bug. I spent most of today with a co-worker looking for
it. There's a Py_DECREF missing in the fetch routine, which makes it
leak the results of every fetch. Who do I send the (one-line) fix to?
pgsql-patches list.
Lamar Owen [EMAIL PROTECTED] writes:
On Tuesday 16 October 2001 02:39 pm, samsom, debra wrote:
I just installed postgresql 7.1.3 on Linux Redhat 7.1. All is well except
Postgresql will not start on Boot. I have added the -o '-i' to the
postgresql.conf and done the chkconfig --add
I've been looking for examples of how to access the back end of
PostgreSQL using the C++ library, but all I've found is 'C' examples.
Can someone point point out where I can get living and breathing
examples of C++.
TIA
--
My Computer's Opinion
~~
if( desire == play_games()
Hello,
Can someone tell me how to work with large objects ?
All I want to do is to store an image into my database and retrieve them
back.
What datatype do I have to use?
What is the sql statement to send a image to the database and how can I
retrieve it back.
I'm using php or VB.
Thanks
On Sat, 13 Oct 2001 17:26:49 +1300, Andrej Falout [EMAIL PROTECTED]
wrote:
Aubit is much more then you asked for, but it will allow you to do this
really easy, and result is C code. See my sig.
Hi Andrej;
Ok, I have downloaded the source tar.gz, I am running RedHat 6.2. What
do I now? Is
Break the SQL code that has been implemented for prior versions??
Bummer ;((.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I added a hash index to a varchar value and when i vacuumed i got the
following error:
Index customer_ha_hash: NUMBER OF INDEX' TUPLES (9176) IS NOT THE SAME AS
HEAP' (9181).
dropping and recreating the index gave me the same error (on this index
only)
dropping the database and reimporting
okay.
i followed the instructions very carefully and get the following error when
i try to run pg_upgrade ..
Cannot find database template1 in ./data/base.
Are you running ./pg_upgrade as the postgres superuser?
i am running as superuser and template1 is not there.
Steve
Steve Brett [EMAIL
On Tue, Oct 16, 2001 at 01:22:45AM -0700, Randal L. Schwartz wrote:
Gaurav == Gaurav Priyolkar [EMAIL PROTECTED] writes:
Gaurav Not feasible, because some functions have dynamically created
Gaurav tables so I need to re-create table at each invocation.
When I hear that, I always think
Mihai Gheorghiu writes:
Therefore, I have to give users permissions to sequences, just to the
extent that they could add records. What is the minimum set of
privileges for this?
You need UPDATE privileges to be able to execute nextval() and currval().
I assume this would include setval() as
Bruce Momjian writes:
Break the SQL code that has been implemented for prior versions??
Bummer ;((.
Yes, but we don't follow the MySQL behavior, which we copied when we
added LIMIT. Seems we should agree with their implementation.
Isn't it much worse to not follow PostgreSQL behaviour
Ashley @ Turton writes:
Is it possible in PostgreSQL to construct a blank record without
specifying a list of fields and values in an INSERT statement (so I
can perform a collection for UPDATEs to populate the blank record)?
INSERT INTO tablename DEFAULT VALUES;
(The default values are
Use psql -E and it will give you the SQL for the backslash commands..
-Mitch
- Original Message -
From: Arcady Genkin [EMAIL PROTECTED]
To: PostgreSQL [EMAIL PROTECTED]
Sent: Wednesday, October 17, 2001 4:35 PM
Subject: [GENERAL] SQL equivallent to \ds in psql
Where does Postgres
apparently this is the fix:
psql -d mydb -c select * from title; before
# Save for after cmp test...
cd /usr/local/pgsql # my install root...
vacuumdb mydb# clean up before moving...
cp -pr
20 matches
Mail list logo