hi
i am having postgres version 8.0.0 installed, on my
machine
i created a database and the tables and the stored
procedures for the same
however i get this error, while trying to execute
an insert command, in postgreslog
PL/pgSQL function "insert_patient" line 20 at SQL
statement<2006-
Hi,i have an already running web application with a lot of users. All the connections to the postgresql database are not persistent. I was wondering if it is possible to switch to persistent connection without having problems in my current in production application in order to boost performance ?th
Hi,I have a database (table, stored procedures, accounts,..) on 1 computer.for some reason i need to move this database to another computer but not in the same folder name or on the same HDD.how can i export (and after import) all relative structure and data ?
or maybe a backup of DB is enough ?tha
On Sep 15, 2006, at 2:01 AM, Najib Abi Fadel wrote:
i was searching for a load balancing solution for postgres, I found
some ready to use software like PGCluster, Slony, pgpool and others.
It would really be nice if someone knows which one is the best
taking in consideration that i have an a
On Sep 13, 2006, at 9:46 PM, David Link wrote:
I'm looking at replacing an Oracle database that only has a few
tables, but that is accessed by many programs in the company via
oracle jdbc drivers, oracle odbc drivers and python database
interface.
Is there a way to intercept the calls to t
On Sep 14, 2006, at 4:40 PM, Poul Møller Hansen wrote:
I have some troubles getting Sun Java Studio Creator & Sun Java
Application Server to work with
PostgreSQL.
Trying different syntaxes for the SQL statement (schema or no
schema) in the session bean
I get either the error: "No columns in
On Sep 13, 2006, at 9:05 AM, Michelle Konzack wrote:
Majordomo2 support a nomail option as well ...
I know, since some Mailinglist I am on are migrated to Majordomo2.
Afaik does Mailman not support the "nomail" Option.
BTW, majordomo may not support 'nomail', but it does allow you to add
ad
On Sep 13, 2006, at 10:39 AM, Fabi Avilés wrote:
Hi, I had an application in which I used postgres 7.4, and then
only thing refering to date was:
datestyle = 'ISO,European'
everything else was commented. Now I have had to change the OS and
I've installed postgres 8.1.3, but this config
On Sep 14, 2006, at 11:15 AM, Russ Brown wrote:
We recently upgraded our trac backend from sqlite to postgres, and I
decided to have a little fun and write some reports that delve into
trac's subversion cache, and got stuck with a query optimisation
problem.
Table revision contains 2800+ rows
Ta
On Sep 13, 2006, at 12:13 PM, Andrus wrote:
I use ODBC driver to access PostgresSQL 8.1 servers from Windows 98
computer
from Microsoft Visual FoxPro 9 application.
In a number of client and servers, it is not possible to send data to
server.
PostgreSQL log file shows shows that garbage c
Are you dumping the whole database or just a single table? If it's
the former, try the latter and see if you still get errors.
If pg_dump is not working, maybe some system table is hosed. What
errors are you getting?
If you can get in via psql, log in as a superuser and execute:
COPY mytab
On 22/9/2006 2:14, "Bob Pawley" <[EMAIL PROTECTED]> wrote:
> I am seeking wording for a procedure that will initiate a trigger only after
> another trigger has completed its function. In this case I want to drop a
> table that is created and used by the first trigger.
Sounds like you should use a
Hi!I encounter errors in dumping the database using pg_dump. The database i think is corrupt. It was looking for triggers and stored procedures that are now longer in the database. This is also the reason why I opted to create a program to dump the database.
On 9/22/06, Michael Nolan <[EMAIL PROTE
> select cast((max(substring(test.test from 6 for 4))) as integer) + 1
> FROM test where max(substring(test.test from 11 for 2));
This where clause is just returning a number but not comparing it to
anything. Normally it would be something like WHERE test.test =
max(substring(test.test from 11 f
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Brad Nicholson)
belched out:
> On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
>> > On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
>> >> For a high level corp manager all they ever hear about is MS SQL Server,
>>
I have a table with over 6 million rows in it that I do a dump on every night. It takes less than 2 minutes to create a file that is around 650 MB.Are you maybe dumping this file in 'insert' mode?--Mike Nolan
On 9/21/06, Charles Ambrose <[EMAIL PROTECTED]> wrote:
Hi!
I have a fairly large databas
Hi!
I have a fairly large database tables (say an average of 3Million
to 4Million records). Using the pg_dump utility takes forever to
dump the database tables. As an alternative, I have created a program
that gets all the data from the table and then put it into a text file.
I was also unsucces
I have a field that is varchar(15) type and an example of data I'm working with is (PROJ-0001-06)
I can make these two select statements work but not together.
select cast((max(substring(test.test from 6 for 4))) AS INTEGER) + 1 FROM test;select max(substring(test.test from 11 for 2)) FROM tes
Hi, I have a table with 8M rows and one of the fields is a bit (1024
bits) field. I am trying to dump the bit field for 8M rows to a file:
psql -U cicc3 -A -F " " -t -o pubchem.fp -c "select cid,gfp from
pubchem_compound;
However I get
out of memory for query result
I am surprised since I did
Thank you for Mac OSX Universal support at last ! Now the last PowerPc
application is gone Universal on my Mac.
Pgadmin now 4 times faster as Universal on Intel!
Thanks for your great work!
On 9/14/06, Dave Page wrote:
I'm pleased to announce the first beta version of pgAdmin III v1.6.0 is
ava
Csaba Nagy wrote:
Cons:
- No reliability. On slow days, WAL logs could take a long time to
rotate, so small but important transactions might not be replicated
for a long time.
That's gone with 8.2, it will be possible to stream the last
modificatio
Brandon Aiken wrote:
I know that in
PostgreSQL, there is no performance
difference between character and character varying.
Is there any penalty in
either performance or disk space for
not specifying a length on char and varchar fields? Is it really just
there onl
Am 2006-09-19 21:26:16, schrieb Naz Gassiep:
> The "scratch your own itch" line can only be pushed so far, if it is
> being said by a developer who works on a project that desires to be
> taken seriously by professionals in industry. For minor features, yes,
> perhaps it could be argued that th
I know that in PostgreSQL, there is no performance
difference between character and character varying.
Is there any penalty in either performance or disk space for
not specifying a length on char and varchar fields? Is it really just there only
as a basic check constraint for the log
On Thursday 21 September 2006 12:44 pm, Bob Pawley <[EMAIL PROTECTED]> thus
communicated:
--> I am seeking wording for a procedure that will initiate a trigger only
after another trigger has completed its function. In this case I want to
drop a table that is created and used by the first trigger
On Thu, 2006-09-21 at 17:30 +0200, Bo Lorentsen wrote:
> Hi ...
>
> I have been trying to find a replication to a payment system at the
> company I work, and Slony-I is of cause the first thing that game into
> my attention. But when reading chapter 23.3 in the PG manual, there is
> this commen
I am seeking wording for a procedure that will initiate a
trigger only after another trigger has completed its function. In this case I
want to drop a table that is created and used by the first
trigger.
Could someone point me to documentation?
Bob Pawley
In response to Csaba Nagy <[EMAIL PROTECTED]>:
> > > Cons:
> > - No reliability. On slow days, WAL logs could take a long time to
> > rotate, so small but important transactions might not be replicated
> > for a long time.
>
> That's gone with 8.2, it will be possible to stream the last
> mo
> > Cons:
> - No reliability. On slow days, WAL logs could take a long time to
> rotate, so small but important transactions might not be replicated
> for a long time.
That's gone with 8.2, it will be possible to stream the last
modifications, or force a WAL recycle periodically, whatever fit
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
For a high level corp manager all they ever hear about is MS SQL Server,
Oracle and DB2, and the more it costs the more they think it is what
they need :-)
I think that descr
On Thu, 2006-09-21 at 08:47, Brad Nicholson wrote:
> On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
> > > On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
> > >> For a high level corp manager all they ever hear about is MS SQL Server,
> > >> Oracle and DB2, and the more it c
In response to Bo Lorentsen <[EMAIL PROTECTED]>:
> Hi ...
>
> I have been trying to find a replication to a payment system at the
> company I work, and Slony-I is of cause the first thing that game into
> my attention. But when reading chapter 23.3 in the PG manual, there is
> this comment of
Hi ...
I have been trying to find a replication to a payment system at the
company I work, and Slony-I is of cause the first thing that game into
my attention. But when reading chapter 23.3 in the PG manual, there is
this comment of PITR used as a replication tool.
I also saw the "pgpitrha"
Hi,
I got executing the script;
(creates table on master,slave1,slave2 but
does it matter to have connection to only node1 or all nodes in script,
it did the same thing with connection to only node1 and I tried to connection to
all nodes ?
node 1 admin conninfo = 'dbname=development host=192.168.1
On Wed, 2006-09-20 at 16:29, Johan wrote:
> Hi,
> I encountered a strange problem while trying to solve a bug. I use a
> postgresql 8.x database and a jdbc driver from
> postgresql-8.1dev-400.jdbc3.jar. The following is happening
>
> The table is created like
> create table test (
> field1 int8
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> The docs do hint at how to do it properly:
> "PERFORM create_mv(''cs_session_page_requests_mv'', my_query);"
> but this might be helpful to be pointed out explicitely:
> "PERFORM create_mv(''cs_session_page_requests_mv'', my_query);
> Note that the PE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/21/06 09:28, Bill Moran wrote:
> In response to Brad Nicholson <[EMAIL PROTECTED]>:
>
>> On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto
wrote:
[snip]
> Suing someone is
they need :-)
I think that description is false. At a certain point in the
management hierarchy, the only way anyone has the ability to evaluate
something is on the basis of reputation.
I think that description is false. At a certain point in the management
hierarchy, the only way anyone has t
Bill,Suing someone is not the real reason. It's the excuse given to one'sboss. The real reason is the "Nobody ever got fired for using IBM"
mentality. "Nobody ever got fired for using IBM" - today it is translated to (Oracle|Microsoft)And it may still be true. But it gives you only half the stor
In response to Brad Nicholson <[EMAIL PROTECTED]>:
> On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
> > > On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
> > >> For a high level corp manager all they ever hear about is MS SQL Server,
> > >> Oracle and DB2, and the more it
On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
> > On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
> >> For a high level corp manager all they ever hear about is MS SQL Server,
> >> Oracle and DB2, and the more it costs the more they think it is what
> >> they need :-)
> >
On Thu, Sep 21, 2006 at 02:50:08PM +0200, Marcin Mank wrote:
> With:
>
> perform cmd;
> raise notice ''found (perform): %'', found;
>
> You effectively do:
> select 'select 1 from test where fk_item=1324314' ;
>
>
> Try:
>
> perform 1 from test where fk_item=1324314
Marcin, you saved my da
> gives the result below. It seems inconsistent to me with
> regard to the FOUND variable. I would expect FOUND to always
> be false regardless of whether I use EXECUTE or PERFORM. I
> certainly do not expect it to be true for the third EXECUTE
> even assuming that PERFORM may have a bug. What is i
On Thu, Sep 21, 2006 at 01:32:02PM +0200, Martijn van Oosterhout wrote:
> I beleive that since PERFORM doesn't return anything, it sets the FOUND
> variable to at least indicate whether it did something.
The weird thing is that in the example it sets FOUND to true
even if it did NOT do anything.
On Thu, Sep 21, 2006 at 01:32:02PM +0200, Martijn van Oosterhout wrote:
> > So, what about the PERFORM ? Why does it set FOUND to true?
>
> I beleive that since PERFORM doesn't return anything, it sets the FOUND
> variable to at least indicate whether it did something.
The docs say that it sets
On Thu, Sep 21, 2006 at 01:15:46PM +0200, Karsten Hilbert wrote:
> Assuming EXECUTE does not touch FOUND at all the EXECUTE
> part behaves consistently (namely default FOUND=FALSE at the
> beginning and later whatever it was after the PERFORM).
>
> So, what about the PERFORM ? Why does it set FOU
On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:
> gives the result below. It seems inconsistent to me with
> regard to the FOUND variable. I would expect FOUND to always
> be false regardless of whether I use EXECUTE or PERFORM. I
> certainly do not expect it to be true for the th
On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:
> I am utterly confused now. Running the attached script on Debian:
>
> postgresql:
> Installiert:7.5.21
> Mögliche Pakete:7.5.21
> Versions-Tabelle:
> *** 7.5.21 0
> 990 ftp://ftp.gwdg.de testing/main Packages
>
Hi,
I am utterly confused now. Running the attached script on Debian:
postgresql:
Installiert:7.5.21
Mögliche Pakete:7.5.21
Versions-Tabelle:
*** 7.5.21 0
990 ftp://ftp.gwdg.de testing/main Packages
100 /var/lib/dpkg/status
7.4.7-6sarge3 0
500 ftp://ftp.gwdg.de
Note: this gets way off topic for this list. And the problem was solved
too in a satisfying manner...
And the new subject line will trigger quite a few adult SPAM filters too
;-)
> > The point was that you will never ever be able to cover all the variants
> > existing in the weirdest email client
Brian Maguire schreef:
To all involved in this project,
I justed wanted to let you know how impressed and pleased I have been with postgres over the past 5 years . The timeliness and quality of the releases are always robust and stable. Every release has a very nice mix of admin, performance,
On Wednesday 20 September 2006 09:59 pm, "Brian Maguire"
<[EMAIL PROTECTED]> thus communicated:
--> To all involved in this project,
-->
--> I justed wanted to let you know how impressed and pleased I have been
with postgres over the past 5 years . The timeliness and quality of the
releases ar
Hello there!
Are there any good and recommendable books about PL/PGSQL programming?
Covering new features of PostgreSQL 8.x is no must but would be nice to
have.
Best regards,
Matthias
---(end of broadcast)---
TIP 1: if posting/reading through Usen
53 matches
Mail list logo
