On 15.07.2007 18:03, angga erwina wrote:
i would like to replicate my dbase over LAN and VPN,could you help me
please,give the tutorial or url that i can follow it step-by-step..especially
about the configuration in admin conninfo...
Read the manual of the VPN software you are planing to use,
On Fri, 2007-07-13 at 06:53 -0400, Robert Treat wrote:
> > Well if you do the popular technique of doing everything through stored
> > procedures (in our case plpgsql functions) then you can have those
> > functions check. I don't like that approach myself though.
> Right. This approach always seem
Hi all.
I've got this error message while running an SQL function:
BEGIN
psql:filtb.sql:1029: ERROR: COMMIT is not allowed in a SQL function
CONTEXT: SQL function "f_relazione" during startup
funzione SQL "f_relazione" istruzione 1
END
Of course, I have no COMMIT command either in t
Vincenzo Romano wrote:
Hi all.
I've got this error message while running an SQL function:
BEGIN
psql:filtb.sql:1029: ERROR: COMMIT is not allowed in a SQL function
CONTEXT: SQL function "f_relazione" during startup
funzione SQL "f_relazione" istruzione 1
END
Of course, I have no C
On Monday 16 July 2007 12:18:23 Richard Huxton wrote:
> Vincenzo Romano wrote:
> > Hi all.
> >
> > I've got this error message while running an SQL function:
> >
> > BEGIN
> > psql:filtb.sql:1029: ERROR: COMMIT is not allowed in a SQL
> > function CONTEXT: SQL function "f_relazione" during s
On Jul 15, 2007, at 7:20 PM, Ragnar wrote:
On sun, 2007-07-15 at 15:35 -0400, Rajarshi Guha wrote:
Hi, is there a built in function that will give me the number of bits
that are set to 1 in a bit string field?
no, but it should be trivial to do with pl/pgsql
Thanks for the pointer
---
Thaks Stefan
On 13 jul, 12:25, [EMAIL PROTECTED] (Stefan Kaltenbrunner)
wrote:
> tabai wrote:
> > Hi
>
> > I know that i can limited the total number of connections in
> > postgresql.conf with max_connections, but... can i limite the max
> > number of connections from an specific IP?
>
> > For e
Hi
i try to populate a database. I dropped all indexes on the target table to
speed up the copy. it works fine.
After this i create the index and it took 10 hours just for one index (primary
key). I have 100.000.000 rows with one PK (int8), two integer data values,
and two FK (int8)
Are ther
Hi,
How can I have my table clustered as records are being insert/updated
(per transaction).
I tried doing so with creating an index using pgAdmin III, and it
generated the following SQL:
CREATE INDEX someindex ON mytable (m2);
ALTER TABLE mytable CLUSTER ON someindex;
Now, above DID NOT cluste
According to PostgreSQL.org TODO:
CLUSTER
* -Make CLUSTER preserve recently-dead tuples per MVCC
requirements
* Automatically maintain clustering on a table
This might require some background daemon to maintain clustering
during periods of low usage. It might also require tables to
Look for it in 8.3:
http://archives.postgresql.org/pgsql-patches/2006-08/msg00124.php
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> Sounds like something you'd want to handle within the application
I believe i will try to follow this path.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Can I have a straw poll on the best way to glue smtp to postgres, is
exim the only option?
Cheers
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi all.
I've got this error message while running an SQL function:
BEGIN
psql:filtb.sql:1029: ERROR: COMMIT is not allowed in a SQL function
CONTEXT: SQL function "f_relazione" during startup
funzione SQL "f_relazione" istruzione 1
END
Of course, I have no COMMIT command either in t
On Saturday 14 July 2007 00:04:08 Jim Nasby wrote:
> On Jul 13, 2007, at 2:11 PM, [EMAIL PROTECTED] wrote:
> > i tried to restore a dump from version 8.1.8 to 8.1.9 and i had in
> > one table
> > a value "1.7383389519587511e-310"
> >
> > i got the following error message:
> >
> > pg_restore: ERROR:
My 8.0.1 database is using ISO_8859_8 encoding. When I select specific fields I
get a warning:
WARNING: ignoring unconvertible ISO_8859_8 character 0x00c2
I now want to upgrade my database to 8.2.4 and change the encoding to UTF-8.
When the restore is done, I get the following errors:
pg_restor
Tom Lane writes:
Shouldn't the "public." be left out?
I'm hesitant to remove the schema spec for fear we'd end up with
underspecified output
in some corner case or other.
Totally understand. How about making it an option?
Just like the --no-owner option. There are options that one may rar
Sébastien Boutté writes:
I try with options : -n public (without -b) but it's always the same,
the dump is huge.
According to the man page that should have done it:
Note: Non-schema objects such as blobs are not dumped when -n is
specified. You can add blobs back to the dump with the
--blo
I wrote a plpython function to have my database send email through an smtp
server.
If that is of interest I can post my function
paddy carroll wrote:
Can I have a straw poll on the best way to glue smtp to postgres, is
exim the only option?
Cheers
---(end of broadcast
Hi all,
Is it possible to take a string (ie: a user's password) and have
postgres encrypt the string before performing the query?
At the moment, I am using postgresql + postfix for email. I need to
save the passwords in clear text in the DB and I don't feel safe doing
that. I'd like to s
On Mon, Jul 16, 2007 at 04:20:22PM +0300, Sim Zacks wrote:
> My 8.0.1 database is using ISO_8859_8 encoding. When I select specific
> fields I get a warning:
> WARNING: ignoring unconvertible ISO_8859_8 character 0x00c2
Did any of the data originate on Windows? Might the data be in
Windows-1255
Janning Vygen <[EMAIL PROTECTED]> writes:
> After this i create the index and it took 10 hours just for one index
> (primary
> key). I have 100.000.000 rows with one PK (int8), two integer data values,
> and two FK (int8)
What PG version is this? We did a fair amount of work on sort speed
for
Michael,
I have been manually debugging and each symbol is different, though they each
give the same error code. For example, in one it was a pound sign, though when
I did an update and put in the pound sign it worked.
Another time it was the degree symbol.
I'm going to look at iconv as that so
On Jul 16, 2007, at 9:26 AM, Francisco Reyes wrote:
I guess the next question is 'what does postgresql considers a blob'?
bytea fields? How about a large text with megabytes worth of data?
bytea and text fields are NOT blobs. they are what you access via
the 'large object' functions.
--
Vivek Khera wrote:
On Jul 16, 2007, at 9:26 AM, Francisco Reyes wrote:
I guess the next question is 'what does postgresql considers a blob'?
bytea fields? How about a large text with megabytes worth of data?
bytea and text fields are NOT blobs. they are what you access via the
'large objec
I have developed a PostgreSQL database c/w a Delphi interface with which to
input data.
I would like to display this data graphically.
Following is a small example of the type of graphic display I am seeking.
Can anyone tell me if Postgres Geo is a suitable vehicle for this application?
If so,
Madison Kelly schrieb:
Hi all,
Is it possible to take a string (ie: a user's password) and have
postgres encrypt the string before performing the query?
At the moment, I am using postgresql + postfix for email. I need to
save the passwords in clear text in the DB and I don't feel safe do
"Mike" <[EMAIL PROTECTED]> writes:
> Look for it in 8.3:
> http://archives.postgresql.org/pgsql-patches/2006-08/msg00124.php
What he's looking for isn't actually included in that todo list. I'm sorry but
nobody has been looking at an online cluster command.
Clustered tables of the type you're i
--- Bob Pawley <[EMAIL PROTECTED]> wrote:
> I have developed a PostgreSQL database c/w a Delphi interface with which to
> input data.
> If so, are there any tools that may assist me in developing this graphic
> interface?
This link seemed enteresting to me.
http://www.netbeans.org/download/f
On Sun, Jul 15, 2007 at 08:53:54AM +0100, paddy carroll wrote:
> Can I have a straw poll on the best way to glue smtp to postgres, is
> exim the only option?
What do you mean, "glue smtp to postgres"? You want to authenticate
from Pg, or store the mail in there, or send mail from the database,
On Fri, 2007-07-13 at 20:06 -0500, Michael Glaesemann wrote:
> On Jul 13, 2007, at 19:10 , Francisco Reyes wrote:
>
> > Alternatively is there any easy way to take all data in one schema
> > and load it into a target DB and a different schema?
>
> You might try using the -n flag with pg_dump, r
Hi all,
I've created a small 2-node (Debian Etch, PgSQL8.1) cluster using a
(shared) DRBD8 partition formatted as ext3 running in Primary/Secondary
mode.
I shut down postgresql-8.1, moved '/etc/postgresql' and
'/etc/postgres-commin' to '/ha/etc' (where '/ha' is the DRBD partitions
mount
Madison Kelly <[EMAIL PROTECTED]> writes:
>I've created a small 2-node (Debian Etch, PgSQL8.1) cluster using a
> (shared) DRBD8 partition formatted as ext3 running in Primary/Secondary
> mode.
>I shut down postgresql-8.1, moved '/etc/postgresql' and
> '/etc/postgres-commin' to '/ha/etc'
store mail , send mail, receive mail, filter mail.
I need a mail firewall for a set of bespoke applications in a secure
environment.
I will probably use postfix
*+++
On 16 Jul 2007, at 17:54, Andrew Sullivan wrote:
On Sun, Jul 15, 2007 at 08:53:54AM +0100, paddy carroll wrote:
Can I have
Hi,
Madison Kelly írta:
Hi all,
I've created a small 2-node (Debian Etch, PgSQL8.1) cluster using a
(shared) DRBD8 partition formatted as ext3 running in
Primary/Secondary mode.
I shut down postgresql-8.1, moved '/etc/postgresql' and
'/etc/postgres-commin' to '/ha/etc' (where '/ha' is
Tom Lane wrote:
I think that's the first actual file access that happens during the
connect sequence (everything before that is done with in-memory caches
in the postmaster). So what I'm wondering is whether you *really* shut
down and restarted the postmaster, or whether you are trying to connec
Zoltan Boszormenyi wrote:
Do you use SELinux?
Look for "avc denied" messages in the logs to see if it's the case.
No, I don't (unless I missed it and Debian Etch uses it by default
now). To be sure, I checked the log files and only say this:
2007-07-16 13:58:03 EDT LOG: incomplete startup
I have data (from an external source) which is in text format as a hex
number (it's actually an IP address, but that's probably not relevant.)
to_hex gets from integer to hex, I can cast a hex constant to integer (ie
x'12a7'31'::int, but how do I get a database column from string/hex to
integer?
Tom Lane wrote:
Madison Kelly <[EMAIL PROTECTED]> writes:
I've created a small 2-node (Debian Etch, PgSQL8.1) cluster using a
(shared) DRBD8 partition formatted as ext3 running in Primary/Secondary
mode.
I shut down postgresql-8.1, moved '/etc/postgresql' and
'/etc/postgres-commin' to
Jeff Davis writes:
Let's say I have a development database, and I want to copy the entire
schema myapp_dev1 to schema myapp_dev2 on the same database. Currently,
it's fairly awkward to do that.
One possible way may be:
Dump the source schema.
Remove references to the schema name in the pg_dump
Madison Kelly <[EMAIL PROTECTED]> writes:
>Over and over again. I tried shutting down postgresql again and got
> this at the shell:
> # /etc/init.d/postgresql-8.1 stop
> Stopping PostgreSQL 8.1 database server: main* pg_ctl: postmaster does
> not shut down
> (does not shutdown gracefully, no
On Mon, 2007-07-16 at 14:58 -0400, Francisco Reyes wrote:
> One possible way may be:
> Dump the source schema.
> Remove references to the schema name in the pg_dump file.
> Change search_path and restore schema.
That's what I currently do. It seems a little flimsy though: there are
too many object
On Jul 16, 2007, at 11:36 AM, Michael Nolan wrote:
I have data (from an external source) which is in text format as a
hex number (it's actually an IP address, but that's probably not
relevant.)
It likely is relevant, as it means it's a 32 bit unsigned integer,
which isn't something postg
Right now, it would be nice if I could get a check constraint to be
deferred. Its a long story. I want a circular constraint. The way
things are set up right now, it would be easy if I could defer my
check constraint. I'm doing a polymorphic relation. One direction
is a simple referenc
Perry Smith <[EMAIL PROTECTED]> writes:
> Right now, it would be nice if I could get a check constraint to be
> deferred.
Possibly you could use a deferred "constraint trigger" and do the check
inside that, but I think you will find there are all sorts of race
conditions in this design.
"Perry Smith" <[EMAIL PROTECTED]> writes:
> Right now, it would be nice if I could get a check constraint to be deferred.
> Its a long story. I want a circular constraint. The way things are set up
> right now, it would be easy if I could defer my check constraint. I'm doing
> a
> polymorphi
I understand that i cannot do a dump of a database without bytea
values.I hope that these feature would be present in next version of
pg_dump as we can store large binary values in these sort of fields
and pg_dump taking a lot of time for dumping the database.
For the moment, I will patch my datab
On Jul 16, 2007, at 3:08 PM, Gregory Stark wrote:
"Perry Smith" <[EMAIL PROTECTED]> writes:
Right now, it would be nice if I could get a check constraint to
be deferred.
Its a long story. I want a circular constraint. The way things
are set up
right now, it would be easy if I could defe
Sébastien Boutté writes:
I understand that i cannot do a dump of a database without bytea
values.
What version of postgresql?
If 8.2 uou can do a copy to with a subselect
copy (select with fields except bytea) to '/somepath';
---(end of broadcast)
paddy carroll writes:
store mail , send mail, receive mail, filter mail.
I need a mail firewall for a set of bespoke applications in a secure
environment.
I will probably use postfix
Postfix works well with Postgresql.
For greylisting Sqlgrey works well with Postgresql.
--
On Jul 16, 2007, at 3:29 PM, Perry Smith wrote:
On Jul 16, 2007, at 3:08 PM, Gregory Stark wrote:
"Perry Smith" <[EMAIL PROTECTED]> writes:
Right now, it would be nice if I could get a check constraint to
be deferred.
Its a long story. I want a circular constraint. The way things
are
Hi,
I have a function like this
CREATE OR REPLACE FUNCTION sp_insert(text, text, text, text)
RETURNS text AS
$BODY$
BEGIN
INSERT INTO tbl(a,b,c,d)
VALUES ($1,$2, $3, $4);
RETURN 'success';
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
I was wondering what would the fu
[EMAIL PROTECTED] (paddy carroll) writes:
> store mail , send mail, receive mail, filter mail.
> I need a mail firewall for a set of bespoke applications in a secure
> environment.
>
> I will probably use postfix
It is possible to configure various parts of postfix (e.g. - aliases
and other such)
"Perry Smith" <[EMAIL PROTECTED]> writes:
> I need to add an element to table A and an element to table B that reference
> each other. The "polymorphic" gunk comes up because table B is not the same
> table each time.
Not that I haven't done similar things in the past but you should think har
I use version 8.2.4 since last week end in my production database.
I don't want to do a per table dump (I have more than 300 tables).
It's not maintainable as the schema evolves regulary.
On 7/16/07, Francisco Reyes <[EMAIL PROTECTED]> wrote:
Sébastien Boutté writes:
> I understand that i cann
On Jul 16, 2007, at 15:55 , Jasbinder Singh Bali wrote:
I was wondering what would the function return if insert fails.
I want it to return 'success' upon a successful insert and
'failure' if
insert fails.
Depends on what you mean by "failed". Do you mean an error was
raised? Then you'l
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> I was wondering what would the function return if insert fails.
It would abort immediately and abort your transaction as well unless something
higher up catches the error.
> I want it to return 'success' upon a successful insert and 'failure
I'm attempting to dump and restore an 8.2.4 database to another (same
architecture) machine also running 8.2.4 with a freshly initialized
database.
I'm using this script to generate the pg_dump file:
#!/bin/sh
DATE=`date +%Y%m%d%H%M%S`
#dump the live wykids database
/usr/local/bin/pg_dumpall
Tom Lane wrote:
> I think this proves my theory --- that all looks like leftover processes
> trying to work in an installation that isn't there anymore. (Except I
> have no idea what the "insecure dependency" bit is about.)
"Insecure dependency" is about Perl tainted mode (which pg_ctlcluster is
Jeff Ross <[EMAIL PROTECTED]> writes:
> When psql begins loading this file, it throws the error:
> psql:/tmp/people.sql:79: ERROR: unrecognized node type: 655
Hmm. Can you try that with \set VERBOSITY verbose so we can determine
where the error is being thrown from?
> The interesting thing is
Tom Lane wrote:
Jeff Ross <[EMAIL PROTECTED]> writes:
When psql begins loading this file, it throws the error:
psql:/tmp/people.sql:79: ERROR: unrecognized node type: 655
Hmm. Can you try that with \set VERBOSITY verbose so we can determine
where the error is being thrown from?
Using t
- Original Message -
From: Jasbinder Singh Bali
To: pgsql-general@postgresql.org
Sent: Monday, July 16, 2007 3:55 PM
Subject: [GENERAL] Capturing return value of a function
I was wondering what would the function return if insert fails.
I want it to return 'success' upon a succes
Tom Lane wrote:
Jeff Ross <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Hmm. Can you try that with \set VERBOSITY verbose so we can determine
where the error is being thrown from?
psql:/tmp/people.sql:79: ERROR: XX000: unrecognized node type: 655
LOCATION: _outValue, outfuncs.c:1707
Hmm [
Tom Lane wrote:
> Janning Vygen <[EMAIL PROTECTED]> writes:
>> After this i create the index and it took 10 hours just for one index
>> (primary
>> key). I have 100.000.000 rows with one PK (int8), two integer data values,
>> and two FK (int8)
>
> What PG version is this? We did a fair amount
Jeff Ross <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hmm [ pokes around a bit... ] Do you perhaps have a higher debug
>> verbosity level on this machine than the others? I can't immediately
>> think of a reason why anything would be trying to print an untransformed
>> NULL constant, but it
Added to TODO:
* Allow multiple indexes to be created concurrently, ideally via a
single heap scan, and have a restore of a pg_dump somehow use it
http://archives.postgresql.org/pgsql-general/2007-05/msg01274.php
---
Bruce Momjian wrote:
Added to TODO:
* Allow multiple indexes to be created concurrently, ideally via a
single heap scan, and have a restore of a pg_dump somehow use it
http://archives.postgresql.org/pgsql-general/2007-05/msg01274.php
Would it not also make sense to use this ability for a
Hi All,
Running into a small issue with a PL/PGSQL function under PostgreSQL
8.0.11...
epassembly=# select version();
version
-
PostgreSQL 8.0.11 on x86_64-unk
Try using it with 'execute' as that might help...
OR:
CREATE TEMP TABLE tblname WITH (OIDS) ON COMMIT DROP AS select * from
someothertbl;
that means the temporary table will be dropped at the end of the current
transaction block.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 7/16/07, C
Matthew T. O'Connor wrote:
> Bruce Momjian wrote:
> > Added to TODO:
> >
> > * Allow multiple indexes to be created concurrently, ideally via a
> > single heap scan, and have a restore of a pg_dump somehow use it
> >
> > http://archives.postgresql.org/pgsql-general/2007-05/msg01274.php
>
>
"Shoaib Mir" <[EMAIL PROTECTED]> writes:
> Try using it with 'execute' as that might help...
In current releases you need EXECUTE, else the thing will try to cache a
query plan using the OID of the first instance of the temp table, and
that won't work for subsequent instances.
> OR:
> CREATE TEMP
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> Matthew T. O'Connor wrote:
>> Bruce Momjian wrote:
>> >
>> > * Allow multiple indexes to be created concurrently, ideally via a
>> > single heap scan, and have a restore of a pg_dump somehow use it
Actually, the sync scan patch ought to make this m
Gregory Stark wrote:
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> > Matthew T. O'Connor wrote:
> >> Bruce Momjian wrote:
> >> >
> >> > * Allow multiple indexes to be created concurrently, ideally via a
> >> > single heap scan, and have a restore of a pg_dump somehow use it
>
> Actually, t
I'm trying to clearly understand how foreign key constraints work. I
still need some help.
The PostgreSQL documentation says:
ROW EXCLUSIVE
Conflicts with the SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and
ACCESS EXCLUSIVE lock
modes.
The commands UPDATE, DELETE, and INSERT acquire this lock
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> They could roll their own a lot easier if you had finished the psql
> concurrent patch.
I did. But you decided you didn't want it.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
Gregory Stark wrote:
>
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> > They could roll their own a lot easier if you had finished the psql
> > concurrent patch.
>
> I did. But you decided you didn't want it.
As far as I know, we asked for a libpq API change and you ignored
multiple requests
Bruce Momjian wrote:
> Gregory Stark wrote:
> >
> > "Bruce Momjian" <[EMAIL PROTECTED]> writes:
> >
> > > They could roll their own a lot easier if you had finished the psql
> > > concurrent patch.
> >
> > I did. But you decided you didn't want it.
>
> As far as I know, we asked for a libpq API
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
>> As far as I know, we asked for a libpq API change and you ignored
>> multiple requests. You want the URLs?
No. One suggestion was made regarding an internal technical issue (polling
versus using select/poll on the sockets). I've long ago made that
"Perry Smith" <[EMAIL PROTECTED]> writes:
> Looking at the documentation above, I would expect the insert into A to get a
> Row exclusive lock for table A. And, I'm guessing it would get an ACCESS
> SHARE lock for table B. But this would not prevent the delete from B from
> happening at the sa
79 matches
Mail list logo