---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
You can't delete from a full disk :)No, really: database systems need space for logging, WAL, whatever.And even with delete PostgreSQL will free no single byte, as deleting is done with marking the row as deleted. Read up on multi version concurrency why this has to be that way.
To reclaim space:
so how much space should be
free so that i am able to delete
i have a hard disk of size 130
G.
thanks,
regards
Surabhi
From: Harald Armin Massa
[mailto:[EMAIL PROTECTED]Sent: Thu 7/20/2006 12:16
PMTo: surabhi.ahujaCc:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] psql seems to
Hi,
I am new to postgres sql and have a problem with an
sql statement which I hope you can help me with.
I want to do some calculation on the result of a
query.
I have a table tb_test which contains a timestamp
column my_timestamp.
My sql statement should display my_timestamp as 00,
20, 40
Thor Tall [EMAIL PROTECTED] schrieb:
Hi,
I am new to postgres sql and have a problem with an
sql statement which I hope you can help me with.
I want to do some calculation on the result of a
query.
I have a table tb_test which contains a timestamp
column my_timestamp.
My sql
On Wed, Jul 19, 2006 at 06:06:08PM -0400, Eric Faulhaber wrote:
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote:
OK, but now that this feature has been removed in 8.1.4, how is this
supposed to be handled, given that we don't control what string
Hi All,
the following takes about 2 seconds to run:
select route,not_in_route2(route) from ksanrt
limit 5,
but if i limit it to anything greater than 5 it takes forever to come
back. Forever as in I always cancel the query.
Any reasons why?
On 7/19/06, Rhys Stewart [EMAIL PROTECTED] wrote:
Brian,
Those are very interesting ideas. Thanks. I've been playing around with
pg_dump. Modifying it to selectively dump/restore tables and columns is
pretty easy. But as you say, changing the data content within the data
buffers to reflect varying column values, changed column types, and new
PyPgExplorer is a pure python application that allows the
user to browse and modify Postgresql Databases. Features
include:
o A Scripts menu that makes access to your favorite SQL
scripts only a click away.
o On unix and Mac systems, if psql is detected in a
standard location, then access
On Thu, 2006-07-20 at 12:48 +0530, surabhi.ahuja wrote:
so how much space should be free so that i am able to delete
i have a hard disk of size 130 G.
thanks,
regards
Surabhi
__
If you are trying to delete the
On Thu, 2006-07-20 at 11:57 +0200, Andreas Kretschmer wrote:
Thor Tall [EMAIL PROTECTED] schrieb:
Hi,
I am new to postgres sql and have a problem with an
sql statement which I hope you can help me with.
I want to do some calculation on the result of a
query.
I have a table
Hi, Can anyone please tell me how do I call a stored procedure using ECPG??A code snippet would really be handy..Thanks,~Jas
I'm trying to test the 8.1 backport of the 8.2 GIN index and tsearch2
functionality.
The patch is applied successfully (to 8.1.4, on OS X 10.4.7 w/ xcode
2.3), the build and install goes well, stop start of postmaster is
done, but initializing tsearch2 fails:
psql -U postgres minitest
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 06:06:08PM -0400, Eric Faulhaber wrote:
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote:
OK, but now that this feature has been removed in 8.1.4, how is this
supposed to be handled, given that
On Thu, Jul 20, 2006 at 12:07:54PM -0400, Eric Faulhaber wrote:
Well, there's a really nasty workaround: create a cast from bytea to
text which doesn't change the value. This will get your data into the
database without any encoding checks at all. Ofcourse, you're then
responsible for any
Hello, pgsql-general.
Is it possible to create not only executable version of pg_dump and
pg_restore, but also libraries (.so, .dll) so developers can use them
freely the same as libpq client library?
I suppose it would be very usefull. For me it's for sure.
--
With best wishes,
Pavel
Hi,I have the follwing ECPG code.-#include stdio.hEXEC SQL INCLUDE sqlca;int main (){ EXEC SQL BEGIN DECLARE SECTION;
char movie_type[20]; char *movie_title=NULL; char query_string[256]; EXEC SQL END DECLARE SECTION; EXEC SQL
Martijn van Oosterhout wrote:
On Thu, Jul 20, 2006 at 12:07:54PM -0400, Eric Faulhaber wrote:
Well, there's a really nasty workaround: create a cast from bytea to
text which doesn't change the value. This will get your data into the
database without any encoding checks at all. Ofcourse, you're
Hi,
We have a couple of tables (40,000 and 600,000 rows each) that I am
trying to build an index on an integer column.
When I issue the create index foo_index on foo(id); command in
psql it just does not return. I've waited over half an hour for the
smaller table.
The same command
Hi List !
I would like to know if it is possible to find out the datatypes in the
resultset of a query or a set returning
function without actually executing them ?
I know there is something like that in MS SQL Server where you can use
the SET FMTONLY option and only
get the column
Thanks. Haven't VACUUMed ever. (Sloppy housekeeping:-)
Will do so and let you know if it helped.
There seems to have been some other problem too. I had to just now
forcefully shut down the postmaster and re-start it as it was
beginning to block on other requests as well.
If I Ctl-C the
No, this is a brand new index, so no drops.
On Jul 20, 2006, at 2:03 PM, Ian Harding wrote:
On 7/20/06, Claire McLister [EMAIL PROTECTED] wrote:
Hi,
We have a couple of tables (40,000 and 600,000 rows each) that I am
trying to build an index on an integer column.
When I issue the create
=?ISO-8859-1?Q?Dan_Str=F6mberg?= [EMAIL PROTECTED] writes:
I would like to know if it is possible to find out the datatypes in the
resultset of a query or a set returning
function without actually executing them ?
You could always do SELECT ...whatever ... LIMIT 0. Also, at the
protocol
Claire McLister [EMAIL PROTECTED] writes:
We have a couple of tables (40,000 and 600,000 rows each) that I am
trying to build an index on an integer column.
When I issue the create index foo_index on foo(id); command in
psql it just does not return. I've waited over half an hour for
Jasbinder Bali wrote:
Hi,
Can anyone please tell me how do I call a stored procedure using ECPG??
A code snippet would really be handy..
I don't know about ECPG, but doing select myfunc(); should work I guess..
greetings, Florian Pflug
---(end of
Dan Strömberg wrote:
Hi List !
I would like to know if it is possible to find out the datatypes in
the resultset of a query or a set returning
function without actually executing them ?
Well for result sets of queries on tables there is always the
pg_attribute catalog table.
See:
I have a table with a field called id that is a serial field and
pkey. I would like to set the the sequence to start at 1 and
increase sequentially from there but I can't seem to get that to
work. any suggestions are greatly appreciated.
I am using version 7.4.7
Greg
On Thu, Jul 20, 2006 at 09:32:56PM -0400, Greg Philpott wrote:
I have a table with a field called id that is a serial field and
pkey. I would like to set the the sequence to start at 1 and
increase sequentially from there but I can't seem to get that to
work. any suggestions are
Hi,
I'm using ECPG in my C code and I want to display the result of a simple select statement.
If i write something like
EXEC SQL select* from abc ; (which as of now is not working)
wouldn't this display the result staright away or its always mandatory to use a cursor and then do printf() for
Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE ;
But it doesn't work. I don't think I am specifying the field
correctly. the schema is public, the table is users, the field is id.
Thanks,
Greg
On 20-Jul-06, at 10:49 PM, Michael Fuhr wrote:
On Thu, Jul
On Thu, Jul 20, 2006 at 11:35:51PM -0400, Greg Philpott wrote:
Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE ;
But it doesn't work. I don't think I am specifying the field
correctly. the schema is public, the table is users, the field is id.
ALTER
Thanks Michael that did the trick!
Greg
On 21-Jul-06, at 12:05 AM, Michael Fuhr wrote:
On Thu, Jul 20, 2006 at 11:35:51PM -0400, Greg Philpott wrote:
Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE ;
But it doesn't work. I don't think I am specifying the
32 matches
Mail list logo