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:
---(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
i am using postgresql 8.0.0
my disk is 100% full
i have a database called x
i do the following
psql x
delete from table;
nothing happens
i try to see the top output
i see the following
1768 sdc
25 0 41860 32m 30m R 99.7 0.8 11:29.35
postmasteri also saw this appearing
On 7/19/06, Pratik Shukla <[EMAIL PROTECTED]> wrote:
I have created a DB1 with several tables. Now i need to create another DB2
with a linked table from DB1. So if there is a table_X in DB1, is there a
way to import that table_X into DB2 so that any changes made to table_X in
DB1 will also apply
I wrote:
> Reece Hart <[EMAIL PROTECTED]> writes:
>> After a system crash, postgresql 8.1.4 restarted but reported that I
>> have an apparent wraparound:
>> 2006-07-13 14:03:40 PDT [10092] LOG: could not truncate directory
>> "pg_multixact/offsets": apparent wraparound
>> 2006-07-13 14:03:40 PDT
I saw the same behavior with Functions and Procedures. At first, I could not tell what made one go into the Function folder and one go into the Procedure one. The one thing that clearly distinguishes a Procedure (to be placed into the Procedures folder in PgAdminIII) is if you include an OUT para
> On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED]
wrote:
> > I have a junction table that is recording relationships between
two
> > records in another table. Is there a way that I can create a
> > constraint so that the values are not repeated in any order?
I want to
> > make sure that rows
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 data
>> we're handed? How does psql deal with it?
>
> Well,
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 data
> we're handed? How does psql deal with it?
Well, bytea handles null like it always has.
On Wed, Jul 19, 2006 at 05:13:04PM -0400, Tom Lane wrote:
> Given the lack of "memcoll", that proposal isn't going to fly ...
> at least not until we replace all the locale support code with something
> else (that hopefully will be null-clean).
Yeah, ICU would give us that, but it won't magically
Hi Tom, Joe
After compiling the C-source files
# gcc -fpic -c bitvg.c
# gcc -shared -o bitvg.so bitvg.o
the pg_restore created the function.
It is Suse 9.x and PG 8.1.4
Thanks
Conni
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmast
Tom Lane wrote:
> Martijn van Oosterhout writes:
>> The fact is that if you're using binary format paramaters and output
>> you can put embedded nulls into strings and get them back out.
>
> Not any more ;-)
>
OK, but now that this "feature" has been removed in 8.1.4, how is this
supposed to be
Joe Conway <[EMAIL PROTECTED]> writes:
> Could it be an SELinux issue?
I'd really expect the strerror result to be something about 'permission
denied' rather than 'file not found', if that were the problem...
regards, tom lane
---(end of broadcast)
Martijn van Oosterhout writes:
> The fact is that if you're using binary format paramaters and output
> you can put embedded nulls into strings and get them back out.
Not any more ;-)
> By changing a
> few strcmps to memcmps you can get sane behaviour for sorting a several
> other operations.
G
Cornelia Boenigk wrote:
Hi Joe
> Try:
> su postgres
> cd /home/database/pgdata/cobis/bitvg
Succeeds, ls -la shows all files in that directory and can open them
with less.
Kind of odd, particularly given your reply to Tom's question in a nearby
post. Could it be an SELinux issue?
Jo
On Wed, Jul 19, 2006 at 10:03:34AM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Looking at the code it doesn't appear that there are too many places
> > that are problematic.
>
> Really?
>
> The killer problem is that all datatype I/O goes through C strings.
> Fixing this therefor
19 Jul 2006 10:59:10 -0700, Léo Matos <[EMAIL PROTECTED]>:
Olá senhores, boa tarde.
Estou com o seguinte problema...cadastrei em lote alguns dados nas
tabelas do meu bd, só que as seqüências não foram atualizadas,
todas elas se encontram com valor atual igual a 1, gerando erros quando
eu vou cad
Hi Tom
> You should try "ldd" or local equivalent on bitvg.so to check
> whether all its dependencies can be found.
output:
ldd /home/database/pgdata/cobis/bitvg/bitvg.so
statically linked
Regards
Conni
---(end of broadcast)---
TIP 9: In
I have created a DB1 with several tables. Now i need to create another DB2 with
a linked table
from DB1. So if there is a table_X in DB1, is there a way to import that
table_X into DB2 so that
any changes made to table_X in DB1 will also apply to DB2?
table_X has references to other tables in D
Merlin Moncure wrote:
there are differences. PostgreSQL only really supports functions and
on the lists they are used interchangably. on the -hacker list about
a year back there was a good discussion about implementing true SP and
why they would be needed.
mainly, SP are not externally transact
Hi
Is it possible to merge the postgre.msi into a visual studio 2005 setup msi.
I am hoping to combine both rather then have to seperate files.
Thanks in advance for any advise
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello,
I have created a DB1 with several tables. Now i need to create another DB2 with a linked table from DB1. So if there is a table_X in DB1, is there a way to import that table_X into DB2 so that any changes made to table_X in DB1 will also apply to DB2?
table_X has references to other tabl
Olá senhores, boa tarde.
Estou com o seguinte problema...cadastrei em lote alguns dados nas
tabelas do meu bd, só que as seqüências não foram atualizadas,
todas elas se encontram com valor atual igual a 1, gerando erros quando
eu vou cadastrar alguma informação.
Primeiro gostaria de saber se exis
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
Perhaps your own incoming spam filtering is dropping the messages?
Hmm, I checked the spam filter folder, to no avail.
Hi Joe
> Try:
> su postgres
> cd /home/database/pgdata/cobis/bitvg
Succeeds, ls -la shows all files in that directory and can open them
with less.
Regards
Conni
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On 7/19/06, Anastasios Hatzis <[EMAIL PROTECTED]> wrote:
Hi,
I'm diving more into depth of the features outside the typical table
stuff, which I usually need.
I wrote a trigger that fires a function written in PL/Python, both works
fine so far.
But as I browsed my database via pgAdmin3 I recog
Cornelia Boenigk <[EMAIL PROTECTED]> writes:
> in english: /home/database/pgdata/cobis/bitvg/bitvg.so: cannot open
> shared object: file not found
> The file does exist in the path /home/database/pgdata/cobis/bitvg/:
The "file not found" might be coming from the dynamic loader trying to
load som
Title: Message
PostgreSQL is a database engine. You use it
from a Java application just like you would any other DBMS. The JDBC
driver for it can be found here: http://jdbc.postgresql.org/
--Guy Rouillier
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED] wrote:
> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a
> constraint so that the values are not repeated in any order? I want to
> make sure that rows such as 2 a
On Wed, 19 Jul 2006 [EMAIL PROTECTED] wrote:
> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a constraint so
> that the values are not repeated in any order?
I think the following does what you need, though my "f
Cornelia Boenigk wrote:
The file does exist in the path /home/database/pgdata/cobis/bitvg/:
-rwxr-xr-x 1 root root 133 Jul 19 13:13 bitvg.c
-rwxr-xr-x 1 root root 782 Jul 19 13:13 bitvg.o
-rwxr-xr-x 1 root root 3198 Jul 19 13:13 bitvg.so
What do I miss?
Does the postgres user have acce
Hi all
Trying to create a function I get the following:
codex=# CREATE FUNCTION "bitvg" (integer,integer) RETURNS integer AS
'/home/database/pgdata/cobis/bitvg/bitvg.so', 'bitvg' LANGUAGE 'C';
ERROR: could not load library
"/home/database/pgdata/cobis/bitvg/bitvg.so":
/home/database/pgdata/c
Hi Richard and list,
Thanks for the reply. On the constraint
what I am trying to create is a constraint that would not let me create
a row with fkey1 = 4 and fkey2 = 10 if I already had a row that had fkey1
= 10 and fkey2 = 4. The constraint needs to check the combination
of values in any order.
deepak pal wrote:
> hi,
>can anydody tell me what steps nee to configure postgres for java
> application.plz give me link frm where i got driver for it.
>
> --
> Deepak Pal
> Software Developer
> Wicenet ltd.
> Pune(M.H )
Deepak,
JDBC drivers and docs are provided separately. See:
htt
> I have a junction table that is recording relationships between two
> records in another table. Is there a way that I can create a constraint so
> that the values are not repeated in any order? I want to make sure that
> rows such as 2 and 4 in the example below cannot happen. This is a very
I have a junction table that is recording
relationships between two records in another table. Is there a way that
I can create a constraint so that the values are not repeated in any order?
I want to make sure that rows such as 2 and 4 in the example below cannot
happen. This is a very small table
Hi,
I'm diving more into depth of the features outside the typical table
stuff, which I usually need.
I wrote a trigger that fires a function written in PL/Python, both works
fine so far.
But as I browsed my database via pgAdmin3 I recognized that there is
also 'Procedures' under 'public'
well i started by creating a table with the data i needed, instead of
working on the big tablethat helped a whole lot.
thanks.
On 7/18/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote:
> i created a function and it takes a long time to
Kevin Murphy <[EMAIL PROTECTED]> writes:
> Yesterday I sent two messages to pgsql-general@postgresql.org, and
> neither one posted, as far as I can tell.
Why do you think that?
http://archives.postgresql.org/pgsql-general/2006-07/msg00660.php
http://archives.postgresql.org/pgsql-general/2006-07/
On 7/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
Both are in my pgsql-general maildir, message ids:
[EMAIL PROTECTED] [EMAIL PROTECTED]
I find those as well.
regards,
Robin
---(end of broadcast)---
TIP 3: Have you checked our e
# [EMAIL PROTECTED] / 2006-07-19 09:50:05 -0400:
> Yesterday I sent two messages to pgsql-general@postgresql.org, and
> neither one posted, as far as I can tell.
>
> "Please explain the gin index" - 7/18/06 10:44 AM EDT
>
> "number of distinct values in tsearch2 gist index" - 7/18/06 1:24 PM EDT
Martijn van Oosterhout writes:
> Looking at the code it doesn't appear that there are too many places
> that are problematic.
Really?
The killer problem is that all datatype I/O goes through C strings.
Fixing this therefore would require breaking every user-defined
datatype on the planet.
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
"Please explain the gin index" - 7/18/06 10:44 AM EDT
"number of distinct values in tsearch2 gist index" - 7/18/06 1:24 PM EDT
This has also happened to me on numerous previous occasion
On 19/07/2006, at 10:03 PM, Christian Rengstl wrote:
So here's the master table including the rules:
entry_no int8 NOT NULL DEFAULT nextval('public.master_seq'::regclass),
pid varchar(15) NOT NULL,
val_1 varchar(1),
val_2 varchar(1),
chr int2 NOT NULL,
aendat timestamp DEFAULT now(),
On Wed, Jul 19, 2006 at 03:23:08PM +0200, DANTE Alexandra wrote:
> Thank you Martijn for your answer !
> I use the 8.1.3 release of PostgreSQL.
You'll be fine...
> Will it be sensible to launch an ANALYZE after the VACUUM to update
> statistics ?
Or do both at the same time (VACUUM ANALYZE).
H
Thank you Martijn for your answer !
I use the 8.1.3 release of PostgreSQL.
Will it be sensible to launch an ANALYZE after the VACUUM to update
statistics ?
Regards,
Alexandra
Martijn van Oosterhout wrote:
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:
Imagine you have a
Volkan YAZICI wrote:
On Jul 19 10:40, Timothy Smith wrote:
Volkan YAZICI wrote:
On Jul 19 10:02, Timothy Smith wrote:
cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
""",(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near "
On Wed, Jul 19, 2006 at 03:03:43PM +0200, DANTE Alexandra wrote:
> Imagine you have a database on which a lot of transactions are done
> daily : the tables will contain a lot of dead tuples and the B-tree
> index too.
>
> If I do a VACUUM on this database, will the B-tree index be scanned,
> sp
Hello List,
Sorry to send an other e-mail on this subject but it is become a little
bit vague for me.
Imagine you have a database on which a lot of transactions are done
daily : the tables will contain a lot of dead tuples and the B-tree
index too.
If I do a VACUUM on this database, will the
On Jul 19 10:40, Timothy Smith wrote:
> Volkan YAZICI wrote:
> >On Jul 19 10:02, Timothy Smith wrote:
> >
> >>cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
> >>""",(StaffUserName,NewPassword,StaffGroup))
> >>
> >>produces this error
> >>
> >>ERROR: syntax error at or near "'bob.smi
On Jul 19 10:02, Timothy Smith wrote:
> cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
> """,(StaffUserName,NewPassword,StaffGroup))
>
> produces this error
>
> ERROR: syntax error at or near "'bob.smith'" at character 13
IIRC, per Python DB-API PEP, the DB adapter you use try to e
So here's the master table including the rules:
entry_no int8 NOT NULL DEFAULT nextval('public.master_seq'::regclass),
pid varchar(15) NOT NULL,
val_1 varchar(1),
val_2 varchar(1),
chr int2 NOT NULL,
aendat timestamp DEFAULT now(),
aennam varchar(8),
CONSTRAINT "PK_ENTRY" PRIMARY KE
this is really newb of me but i can't manage to make a script to create
users.
cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
""",(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near "'bob.smith'" at character 13
is it because i need to dou
On 19/07/2006, at 8:49 PM, Christian Rengstl wrote:
Obviously it had something to do with the rule, because now
everything finished within 20 minutes. the problem is just that i
don't really want to give up the inheritance design. is there a way
to maintain the inheritance that doesn't caus
Obviously it had something to do with the rule, because now everything finished
within 20 minutes. the problem is just that i don't really want to give up the
inheritance design. is there a way to maintain the inheritance that doesn't
cause this huge performance problem?
Q <[EMAIL PROTECTED]> w
On Tue, Jul 18, 2006 at 08:03:51PM -0400, Eric Faulhaber wrote:
> > It's not a defect ... or at least, it doesn't make sense to change it
> > unless you are willing to go through the entire system to make it able
> > to store null bytes in text. We've looked at that in the past and
> > always conc
hi,
can anydody tell me what steps nee to configure postgres for java application.plz give me link frm where i got driver for it. -- Deepak PalSoftware DeveloperWicenet ltd.Pune(M.H
)
Well, i'll try that, but honestly i don't think it's the rule as the rule is
really simple: it's just one simple integer comparison...
Q <[EMAIL PROTECTED]> wrote on 07/19/06 11:54 am:
> On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
>
>> The analyze is from the exact query and i dropped th
On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
The analyze is from the exact query and i dropped the indexes
before the insert as well without imrpvement. The target table is
as well completely empty and the insert is supposed to write, in
this case, more or less 8 million lines in the
The analyze is from the exact query and i dropped the indexes before the insert
as well without imrpvement. The target table is as well completely empty and
the insert is supposed to write, in this case, more or less 8 million lines in
the table. There is a rule though, because i have inheritanc
The thing is that in the text file there is a column that is something like
xyz_12 and in the table i just need the integer part of it that's what the
query is used for. The problem though is not really in the select part, because
running the select part on 8 million lines takes about 3 minutes,
61 matches
Mail list logo
