[GENERAL] Foreign Key for PHP serialized data - possible?

2007-10-08 Thread Dave
e.g. if an id of Oranges changes from '5' to '24', the tb1_column rows will get changed in the above example row to: a:5:{i:0;s:1:"9";i:1;s:2:"24";i:2;s:2:"11";i:3;s:2:"100";i:4;s:2:"10";} Is this possible? Can

Re: [GENERAL] Foreign Key for PHP serialized data - possible?

2007-10-08 Thread Dave
"Hannes Dorbath" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Dave wrote: >> What I'm trying to do is to create a foreign key on tb1_column so that if >> a >> number in tb2_column changes or gets deleted, it cascades to the >&g

[GENERAL] Insert/Update to multiple tables with relations

2007-12-04 Thread Dave
Hi, I need help with designing a set of queries I am running with psql -f reports.sql I have a tb_master with report headers, tb_records table with it's own serial field and foreign key referencing an "id" of tb_master. The third tb_details table has two foreign keys referencing the "id"'s of

[GENERAL] partitioning and postgres,

2008-02-18 Thread dave.
Hi every body, I'm working on a database which have big tables and one of the tables is expected to grow very fast so we need to use partitioning. the problem is that I can't find a solution to do the partitioning automatically, I mean what postgres docs describe at (5.9. Partitioning) is not sui

[GENERAL] Automatic partitioning,

2008-02-18 Thread dave.
Hi, I'm working on a database which have big tables and one of the tables is expected to grow very fast so we need to use partitioning. the problem is that I can't find a solution to do the partitioning automatically, I mean what postgres docs describe at (5.9. Partitioning) is not suitable becau

[GENERAL] How do I measure user disk usage on Postgresql table?

2008-04-18 Thread Dave
Lets say I have a Postgresql table where I store uploaded data for all users, identified by user_id column. Is it possible to run a query to measure the storage a user is consuming? Ideally this would be a SELECT query with WHERE clause on user_id and will only return size of the data field(s),

Re: [GENERAL] How do I measure user disk usage on Postgresql table?

2008-04-20 Thread Dave
"Richard Huxton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Dave wrote: >> Lets say I have a Postgresql table where I store uploaded data for >> all users, identified by user_id column. Is it possible to run a >> query to measure the storag

Re: [GENERAL] enable_sort optimization problem

2005-05-31 Thread dave
tom lane wrote: Why does it think that only 159 of the 132245 rows in outages will have join partners in ipinterface? The actual results look like they all do. It might be worth looking at the pg_stats rows for the join columns to see if there's something odd about the statistics. Here are

[GENERAL] 8.0 and Mandrake 10.1

2005-01-21 Thread Dave
Hi, When I tried to install postgresql 8.0.0 on my Mandrake 10.1 community box, it puked. First it told me I was missing readline, so I compiled that and got over that hump. I tried --with-openssl and again, the configure stopped when it could not find crypt So, I d'loaded the latest openss

[GENERAL] transactions in c api (libpq)?

2004-01-18 Thread Dave
Is it possible to write C code (presumably using libpq) to carry out transactions? I can't seem to find functions in this API which start and end a transaction. If this is not possible, what other programming interfaces will allow me to write transaction code? Thanks ---(

[GENERAL] Where is the reference manual?

2000-07-29 Thread dave
rence manual anywhere. Maybe it has been merged somewhere, but I can't find the info I want, which is teh detailed explanation of the system catalogs. Any ideas? thanks Dave

[GENERAL] problem compiling php for pgsql

2000-07-29 Thread dave
I'd like to try and keep this as much RPM based as possible (i.e. I did think of downloading ALL sources and compiling the lot, but I'd like to avoid that - I mean my pgsql install works fine) many thanks, Dave

[GENERAL] Re: [PHP-INST] problem compiling php for pgsql

2000-07-30 Thread dave
erent app. (I'm sure there are good reasons!) Thanks for your help. Dave

[GENERAL] How to configure pgsql to store chinese?

2000-10-31 Thread Dave
Hi all, I have my pgsql 7.0.2 with such configure --enable-locale --enable-multibyte=EUC_TW and I created a db with "createdb -E EUC_TW testdb, however, I got "¦w" instead of "¦W" in chinese display. any idea? Thanks Dave

[GENERAL] Does column header support multibyte character?

2000-11-01 Thread Dave
Can I use chinese as the column header? Thanks Dave

Re: [GENERAL] ISAM Api for Postgres

2000-05-12 Thread dave
L engine. I wonder what would be involved in writing an ISAM access. I would think that there must be routines in there to traverse the indices and database files and find next index entry and previous index entry. -- Dave Smith Candata Systems Ltd. (416) 493-9020 [EMAIL PROTECTED]

Re: [GENERAL] Problem JDBC, AutoCommit ON and SELECT FOR UPDATE

2015-03-06 Thread Dave Cramer
unfortunately not. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On 6 March 2015 at 11:27, Philippe EMERIAUD wrote: > Hi all, > We have an application based on DB2 database, We are testing this same > application on PostgreSQL database. By default we are in auto

[GENERAL] database split

2015-04-29 Thread Dave Owens
. Of course, I would love to hear about options D) - Z) as well! Thanks in advance for your input. Dave Owens 541-359-2602 TU Corporate Website <http://t.signauxun.com/link?url=http%3A%2F%2Fwww.teamunify.com%2F__corp__%2F&ukey=agxzfnNpZ25hbHNjcnhyGAsSC1VzZXJQcm9maWxlGICAgOCP-IMLDA&

Re: [GENERAL] database split

2015-04-30 Thread Dave Owens
ROMs (I would have to generate all the WHEREs for Jim's option D anyway, the data I am after is only tiny fraction of the original db...) - restore the filtered constraints/triggers Dave Owens 541-359-2602 TU Corporate Website <http://t.signauxun

Re: [GENERAL] Errors using JDBC batchUpdate with plpgsql function

2015-05-04 Thread Dave Cramer
The logs from the server would be useful Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On 4 May 2015 at 07:05, Thomas Kellerer wrote: > Hannes Erven schrieb am 04.05.2015 um 12:31: > > Hi, > > > > > >> String sql = "

Re: [GENERAL] Errors using JDBC batchUpdate with plpgsql function

2015-05-05 Thread Dave Cramer
So we can consider this matter closed ? CallableStatements are necessary because postgres has to use select to call a function. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On 4 May 2015 at 18:06, Nanker Phelge wrote: > The database function does not use out parameters

Re: [GENERAL] Unit tests and foreign key constraints

2015-05-21 Thread Dave Owens
to automate the creation of a complete set of test data... using psql to load a dump, or possibly CREATE DATABASE testdbcopy WITH TEMPLATE testdb. Integration tests can be costly to maintain with little ROI, tread carefully... -Dave

[GENERAL] Inserting from multiple processes?

2015-06-08 Thread Dave Johansen
updating and was hoping to not have to use a custom function. So is there some way to catch the unique_violation exception without creating a function? Or some other solution to this? Thanks, Dave

Re: [GENERAL] Inserting from multiple processes?

2015-06-09 Thread Dave Johansen
On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen wrote: > I'm using Postgres 8.4 on RHEL 6 and I need to support inserting data into > a table from multiple processes with there occasionally being duplicates > from the different processes. Here's a simple example table: > C

[GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)

2015-06-24 Thread Gauthier, Dave
Hi: I'm trying to get a 10,000 ft understanding of the difference in DB access speeds for two different scenarios... Scenario 1: Apps are on linux. PG DB is on linux (different server than apps) Scenario 2: Apps are on linux. MSSql DB is on Windows (obviously a different server) The

Re: [GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)

2015-06-24 Thread Gauthier, Dave
o:a...@squeakycode.net] Sent: Wednesday, June 24, 2015 10:10 AM To: Gauthier, Dave; Postgres General Subject: Re: [GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) On 6/24/2015 8:44 AM, Gauthier, Dave wrote: > Hi: I'm trying to get a 10,000 f

Re: [GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)

2015-06-24 Thread Gauthier, Dave
24, 2015 12:50 PM To: Gauthier, Dave Cc: Postgres General Subject: Re: [GENERAL] DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Hi Dave: On Wed, Jun 24, 2015 at 3:44 PM, Gauthier, Dave wrote: > Hi: I'm trying to get a 10,000 ft understanding of the

Re: [GENERAL] Inserting from multiple processes?

2015-06-25 Thread Dave Johansen
On Tue, Jun 9, 2015 at 8:38 AM, Dave Johansen wrote: > On Mon, Jun 8, 2015 at 10:15 AM, Dave Johansen > For the sake of documentation, here's the function that I used to > accomplish this: > CREATE FUNCTION insert_test_no_dup(tutc_ TIMESTAMP WITHOUT TIME ZONE, id_ > INT

Re: [GENERAL] Inserting from multiple processes?

2015-06-28 Thread Dave Johansen
On Sat, Jun 27, 2015 at 11:00 AM, Francisco Olarte wrote: > Hi Dave: > > On Fri, Jun 26, 2015 at 2:59 AM, Dave Johansen > wrote: > > > It appears that calling "SELECT insert_test_no_dup('2015-01-01', 1, 1)" > > cause the XID to increment? I'm

Re: [GENERAL] Problem with pl/python procedure connecting to the internet

2015-08-23 Thread Dave Potts
In cases like this I normally restart the progresql under strace/truss etc and then wade through the output, it will normally tell me which process was invoked. On 23/08/15 18:49, Tom Lane wrote: > Igor Sosa Mayor writes: >> Adrian Klaver writes: >>> Or more to the point how where they built? >>

Re: [GENERAL] Postgres Dropped DB have recovered files how to restore

2016-06-06 Thread Dave Cramer
rs. I have no idea if this will work 5) pg_dump everything and reload it into a new db. Let me know how it goes. Dave Cramer da...@postgresintl.com www.postgresintl.com On 6 June 2016 at 16:57, Adrian Klaver wrote: > On 06/04/2016 01:20 PM, lifetronics wrote: > >> This morning I a

Re: [GENERAL] How to retrieve jsonb column through JDBC

2016-08-27 Thread Dave Cramer
Unfortunately JSONB is output in text. So this is the way it is done. Dave Cramer da...@postgresintl.com www.postgresintl.com On 27 August 2016 at 06:39, Alexander Farber wrote: > Hello, > > what do you use to retrieve a jsonb column using JDBC? > > I have tried > >

Re: [GENERAL] Slightly OT.

2007-06-01 Thread Dave Page
ter replication generally is - thats why Slony-2 will almost certainly never exist in the form that it was originally imagined. Although I'm not (and never have been) an Oracle user, I've heard that RAC has it's own issues in this area as well. Regards, Dave

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-05 Thread Dave Page
vid Gardner <[EMAIL PROTECTED]>: > > This post got me thinking, is there a similar procedure for PL/pgSQL > > functions? > > > > No. You can debug PL/pgSQL function via debug plugin API. Currently > exists only one debugger, which can do it - Enterprisedb

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-06 Thread Dave Page
> --- Original Message --- > From: David Gardner <[EMAIL PROTECTED]> > To: "'Dave Page'" <[EMAIL PROTECTED]> > Sent: 06/06/07, 00:14:52 > Subject: RE: pl/pgsql debuging, was Re: [GENERAL] debugging C functions > > I grabbed the May

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-07 Thread Dave Page
lient in the next few days though, so look out for an update to pgAdmin. Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] pgadmin3 1.6.3 problem with geom fields

2007-06-18 Thread Dave Page
;s records! (?) Issue being discussed with Pedro on the pgadmin-support list: http://www.pgadmin.org/archives/pgadmin-support/2007-06/msg00046.php Regards, Dave ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] [pgadmin-support] Problem editing tables (geom columns)

2007-06-21 Thread Dave Page
Pedro Doria Meunier wrote: > (First of all sorry for cross-posting but I feel this is a matter that > interests all recipients) > Thread on pgadmin support: > http://www.pgadmin.org/archives/pgadmin-support/2007-06/msg00046.php > > Hello Dave, Hi Pedro > This behavior (tryi

Re: [GENERAL] How to install Postgresql on MS Vista?

2007-06-22 Thread Dave Page
oose Run As Administrator, change to the installer directory and 'start whatever.msi'). Except the administrator account is disabled by default on Vista. Regards, Dave ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, pleas

Re: [GENERAL] How to install Postgresql on MS Vista?

2007-06-22 Thread Dave Page
D.J. Heap wrote: On 6/22/07, Dave Page <[EMAIL PROTECTED]> wrote: [snip] Except the administrator account is disabled by default on Vista. What do you mean? Exactly what I wrote. By default, the .\Administrator account is disabled on Vista so you cannot login to it, or runas it. It&

Re: [GENERAL] How to install Postgresql on MS Vista?

2007-06-22 Thread Dave Page
Joshua D. Drake wrote: BTW, and this is completely off topic but Vista really doesn't seem nearly as bad as all the geeks would make it out to be. It seems a nice evolutionary step ... although it seems a step toward MacOSX ;) Oh it's certainly got nice eye candy, and is quite easy for the new

Re: [GENERAL] How to install Postgresql on MS Vista?

2007-06-22 Thread Dave Page
Joshua D. Drake wrote: Dave Page wrote: Except the administrator account is disabled by default on Vista. Huh? What I am confused about, and I don't pretend in anyway to understand Vista but I just bought my wife a new vista machine and the default user (the one created during setup) w

Re: [GENERAL] Proposed Feature

2007-06-23 Thread Dave Page
> --- Original Message --- > From: Magnus Hagander <[EMAIL PROTECTED]> > To: Naz Gassiep <[EMAIL PROTECTED]> > Sent: 23/06/07, 10:39:01 > Subject: Re: [GENERAL] Proposed Feature > > Naz Gassiep wrote: > > Hey, > > I'm sure that'd be greatly appreciated, most other major servers and >

Re: [GENERAL] AutoVacuum Behaviour Question

2007-06-28 Thread Dave Page
ql.org/docs/8.2/interactive/index.html Those are the only docs/books that have been produced by the PostgreSQL Global Development Group. Regards, Dave ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to c

Re: [GENERAL] Create user

2007-06-29 Thread Dave Page
NOCREATEROLE INHERIT LOGIN; > CREATE ROLE > > is there any option? Remove the -e option. That turns on the SQL echoing. Regards, Dave. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate s

[GENERAL] How does one impolement lists, or arrays, pin pl/pgsql ?

2007-06-29 Thread Gauthier, Dave
How does one implement a simple, general purpose, assignable array (or list) in pl/pgsql? From what I've found/read, it appears that you can declare static, read-only arrays. I'm guessing (and please correct if I'm wrong), PG does not support modifyable arrays. Rather, one might consider definin

Re: [GENERAL] postgressqlnot support inwindows 2000

2007-06-30 Thread Dave Page
reading it errors when the Next Button is clicked on the language dialog, which means msiexec has already run once. Siva; did you extract both msi files from the zip file before running the installer? Regards, Dave ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] postgressqlnot support inwindows 2000

2007-07-02 Thread Dave Page
Magnus Hagander wrote: Yes, but it was not necessarily launched as "msiexec". If the file was just double-clicked on, the path to msiexec will be fetched from the registry and not the system PATH. That's the only explanation I can find. Not being installed on Windows 2000 is possible iirc - but

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Dave Page
Richard Huxton wrote: > Charles Pare wrote: >> Wow, it works great >> Thank's for the quick answer > > 12 minutes? I've seen bug-patches turned around quicker than that by Tom > ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up :-) /D

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-04 Thread Dave Page
Richard Huxton wrote: > Dave Page wrote: >> Richard Huxton wrote: >>> Charles Pare wrote: >>>> Wow, it works great >>>> Thank's for the quick answer >>> 12 minutes? I've seen bug-patches turned around quicker than that by Tom >>

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Dave Page
> > can anyone please figure out what is going wrong. Under what user account is the batch file being run? The pgpass.conf file needs to be under *that* user account, which is not necessarily the one that the postgresql server runs under. Regards, Dave ---(end of

Re: [GENERAL] pgpass.conf

2007-07-10 Thread Dave Page
iently more complex that doing that check is far harder than it is on *nix, and the Application Data directory should be secure anyway (unless you're using FAT32, but then there's no helping you anyway :-) ). Regards, Dave ---(end of broadcast)

[GENERAL] returns setof rec... simple exampe doesn't work

2007-07-12 Thread Gauthier, Dave
I've googled this one and tried everything (except the correct solution of course) until tears are starting to flow. Please help. Complete example below. 7.4.13 on suse-64 x86 create table mytable (mystring varchar, myreal real); insert into mytable (mystring,myreal) values ('abc',1.2

Re: [GENERAL] returns setof rec... simple exampe doesn't work

2007-07-12 Thread Gauthier, Dave
I'll answer my own question... select * from myfunc(); (dumb, dumb, dumb) -dave From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave Sent: Monday, July 09, 2007 4:07 PM To: pgsql-general@postgresql.org Su

Re: [GENERAL] PGInstaller Project

2007-07-22 Thread Dave Page
nstaller certainly isn't dead - it's the installer for the official windows binary releases of PostgreSQL. Regards, Dave ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] European users mailing list

2007-07-28 Thread Dave Page
, advocacy and other topics relevant to our work in Europe. To subscribe, send the word 'subscribe' to [EMAIL PROTECTED] To unsubscribe, send the word 'unsubscribe' Apologies for the delay in setting this up - the list is there now, archives will be sorted early next w

Re: [GENERAL] [pgsql-advocacy] European users mailing list

2007-07-29 Thread Dave Page
> --- Original Message --- > From: Peter Eisentraut <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: 29/07/07, 14:37:57 > Subject: Re: [pgsql-advocacy] European users mailing list > > Dave Page wrote: > > As discussed at the first meeting

Re: [GENERAL] [pgsql-advocacy] European users mailing list

2007-07-30 Thread Dave Page
Joshua D. Drake wrote: > Peter Eisentraut wrote: >> Dave Page wrote: >>> As discussed at the first meeting of what will become the European >>> PostgreSQL Users Group after pgDay in Prato, we now have a mailing >>> list setup at [EMAIL PROTECTED] >>> &g

Re: [GENERAL] psql 8.2 client vs pg 8.1 server problem

2007-07-31 Thread Dave Page
mlink it to psql81 or something if necessary). psql doesn't make any promises about backward compatibility - for that, you'll need to use something like pgAdmin (even that may need to be pointed at the older versions of pg_dump etc if you're going to run backups from the work

[GENERAL] continue in plpgsql 7.4

2007-07-31 Thread Gauthier, Dave
How does one effectively doa "continue" in plpgsql v7.4? I believe "continue" is supported in v8, but not 7. At any rate, "continue" gets flagged as a syntax error in the code I'm trying. Lacking "continue", what would you suggest? Thanks -dave

[GENERAL] how do i get num of recs inserted/deleted/updated in plpgsql

2007-08-01 Thread Gauthier, Dave
Looking to capture the total number of records affected with insert/delete/update from within a plpgsql (v7.4 on linux). Would be nice to have this in an integer. Thanks -dave

Re: [GENERAL] how do i get num of recs inserted/deleted/updated in plpgsql

2007-08-01 Thread Gauthier, Dave
Perhaps rowcnt integer; ... get diagnostics rowcnt := row_count; ??? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave Sent: Wednesday, August 01, 2007 12:05 PM To: pgsql-general@postgresql.org Subject: [GENERAL] how

[GENERAL] want to drop corrupt db

2007-08-02 Thread Gauthier, Dave
If the DB is trashed, how can I just delete it and start from scratch? Thanks -dave

Re: [GENERAL] pgTray - win32 tray tool for monitoring PostgreSQL service

2007-08-02 Thread Dave Page
. > > When you do the installer, please make sure it's compatible with > stackbuilder (http://pgfoundry.org/projects/stackbuilder) so it can use > the new easy-to-install method on windows. There is a setup kit in the stackbuilder CVS which makes it a snap to build a compatibl

Re: [GENERAL] Postgres service startup

2007-08-06 Thread Dave Page
ons? This has been fixed for 8.2.5 and 8.3: http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_ctl/pg_ctl.c?rev=1.74.2.1;content-type=text%2Fx-cvsweb-markup In the meantime, can you delay yoour app startup, per haps by sleeping for a few seconds in a batch file? Regards, Dave.

Re: [GENERAL] Comment for column in view - "legal" or just working?

2007-08-08 Thread Dave Page
; > and the command suceeded. Using \d+ in psql also shows me that comment > (also I find no option within pgadmin to view it :) ) You can in 1.8 - that will show a collection of columns under a view, and allow you to set the comment and default value for each.

[GENERAL] Running a query from the OS CLI

2007-08-08 Thread Gauthier, Dave
If I have a DB called "foo" ...and... I want to run "select name from table_a where name like 'john%'" ...and... I want no table header "NAME" in the output ...and... I want to do this as a one-liner from the linux command line ...and... I don't want to have to deal with intermediate files

Re: [GENERAL] Running a query from the OS CLI

2007-08-08 Thread Gauthier, Dave
Yes, that works. The actual sql executes a stored function that returns a set of records. Output to the CLI looks great !!! Thanks to all !!! -dave -Original Message- From: Michael Glaesemann [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:43 PM To: Gauthier, Dave Cc

Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-13 Thread Dave Page
an example of. I am guessing that one would > save the routine off to a .sql file, then call via \i? Just enter the SQL to execute in the textbox on the step dialog, e.g. SELECT my_proc(); Regards, Dave ---(end of broadcast)--- TIP 3: Have you

Re: [GENERAL] Running a stored procedure via pgagent, need an examp le

2007-08-16 Thread Dave Page
ning the pgagent schema. - The user account that pgAgent runs under doesn't have trust access to the database, or a suitable pgpass file to give it the password. You can also enable debugging on the pgAgent command line which should give more info about whats going on. Regar

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-23 Thread Dave Page
Tony Caduto wrote: > Other than that I would say PG kicks butt. You're just realising that? :-) > If there is any interest I could also add MySQL 5.0 to the mix as the > third column. I'd be interested to see that. Regards, Dave -

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-23 Thread Dave Page
ti-threaded architecture as a feature - on Windows it's a little more efficient of course, but the multi-process architecture is arguably far more robust, and certainly used to be more portable (I'm not sure that's still the case for platforms we actually care about). Regards, Dave.

Re: [GENERAL] reporting tools

2007-08-23 Thread Gauthier, Dave
ad-hoc". THe output is just tabular. But you can export to lots of different formats. Just a thought. http://www.dbqwikedit.com/ -dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Kellerer Sent: Thursday, August 23, 2007 10:07 AM To: p

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-24 Thread Dave Page
dows as a result are backend startup time and shared memory access speed - both of which are significantly slower than on *nix. Regards, Dave ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-24 Thread Dave Page
ticular OS)". Yeah - but I'm not sure thats necessarily something that should have a place on a bullet point comparison. Regards, Dave ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-25 Thread Dave Page
ers so should go on the community docs section of the website, not the wiki. Regards, Dave ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-27 Thread Dave Page
databases > for commercial use. > SQL Server CE is also free for commercial use iirc. Regards, Dave ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-27 Thread Dave Page
> --- Original Message --- > From: "Stephen Ince" <[EMAIL PROTECTED]> > To: "Dave Page" <[EMAIL PROTECTED]> > Sent: 27/08/07, 21:30:06 > Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished > > Dave, >

Re: [GENERAL] pgsql Windows installer fixed registry key

2007-08-27 Thread Dave Page
ndom > everytime > it installs (probably something MSI choses). No it's not random. It uses the product ID which only changes between major versions (ie. 8.2 - 8.3) or between distros (eg. pgInstaller vs. EnterpriseDB Postgres). Regards, Dave ---(end of

Re: [GENERAL] Windows Download

2007-08-28 Thread Dave Page
. At the moment, > whichever 'national flag' I select from the Postgres site, I am > redirected to the Kent University page which doesn't exist. I cannot reproduce that - I get redirected to whichever mirror I click on. Anyone else? Thanks for the report, and sorry for an

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

2007-08-28 Thread Dave Page
d from the applications > installer. > > MY idea of an embedded database would be "I link with my > software, so that there is only ONE application". > > Is my understaning of "embedded" wrong or oldschool? SQL CE != SQL Express SQL C

Re: [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

2007-09-07 Thread Dave Page
ll or is this an unreasonable conclusion? Npgsql is very much alive and kicking - you're just looking at the old website. Try: http://pgfoundry.org/projects/npgsql/ Regards, Dave ---(end of broadcast)--- TIP 5: don't forget to increase

Re: [GENERAL] replacing Access/ Approach etc

2007-09-08 Thread Dave Page
r a admin account just fine. > Is there a way to achieve this, on gnu/linux? Run under any account other than root. How the db is configured to start at boot is distro-dependent though so you'll need to figure that out and disable it to only run your own instsnce. Regards, Dave -

[GENERAL] tradeoffs for multi-schema or multi-db

2007-09-18 Thread Gauthier, Dave
ing dbs in that form? Thanks for any advise/help. -dave

Re: [GENERAL] Version 8.2.5 for Windows doesn't startup normally after upgrading from 8.2.4

2007-09-19 Thread Dave Page
. To fix this, either: - Modify the registry key (having taken a backup first of course) with the pg_ctl command line, removing the -w option. - Recreate the postgres database, and ensure it's accessible. Regards, Dave. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] OK, when 8.3 is coming?

2007-09-29 Thread Dave Page
rly next week if all goes to plan. Regards, Dave ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Upgrading PG

2007-10-01 Thread Gauthier, Dave
I'm going to move from v7.4.13 to v8.2.0 (suse-64). I have 2 pre-existing DBs. Do I need to "convert" or port them to v8 in any way after I start up with a v8 postmaster? Thanks -dave

Re: [GENERAL] good sql tutorial

2007-10-04 Thread Dave Page
nly the OP can really say if the pain potential is low enough to justify the time savings. Regards, Dave ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTEC

Re: [GENERAL] Guideline on use of temporary tables

2007-10-15 Thread Gauthier, Dave
Question regarding temp tables If I (user=joe) attach and run something that uses a temp table, then I (user=joe again) attach again in another session, will there be 2 distinct temp tables? Or does one user get one temp table per DB? -Original Message- From: [EMAIL PROTECTED] [mail

Re: [GENERAL] pgadmin's pgagent job scheduler

2007-10-16 Thread Dave Page
ent, connecting to the server, to show the available/scheduled jobs. > (I've already selected the File->options->pgagent jobs options) Make sure you use the same database for the initial connection from pgAdmin (the Maintenance DB on the server dialogue) on the remote machine as pgage

Re: [GENERAL] pgadmin's pgagent job scheduler

2007-10-16 Thread Dave Page
CRANT EXECUTE ON FUNCTION pgagent.pga_exception_trigger() TO role; And then grant the desired update/delete/select/insert permissions on the tables: pgagent.pga_jobagent pgagent.pga_jobclass pgagent.pga_job pgagent.pga_jobstep pgagent.pga_schedule pgagent.pga_exception pgagent.pga_joblog pgagent.pga_jobsteplog Regards, Dave ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pgadmin's pgagent job scheduler

2007-10-16 Thread Dave Page
ection string to use the operator role, and run the daemon under a similarly non-privileged user account. You'll also need to make sure you've granted appropriate permissions on the schema to allow the operator role to update rows etc (which happens when a job is run to set the next runtime)

Re: [GENERAL] looking for some real world performance numbers

2007-10-21 Thread Dave Cramer
esql is doing in the wild under pressure. If anyone cares to throw some out I would really appreciate it. I've got a client doing 18M page views/ day and postgresql isn't really sweating. Dave Chris ---(end of broadcast)--- TIP 1:

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Magnus Hagander wrote: > Another followup. Been working with Dave on and off today (well, him mostly > on to be honest, me a bit more on and off), and it seems that both our > repros clearly blame the desktop heap, and nothing else. Please use the > desktop heap tool and see if it bre

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Dave Page wrote: > So, we seem to be hitting two limits here - the desktop heap, and > something else which is cluster-specific. Investigation continues... In further info, I've been testing this with the 8.3b1 release build that we put out with pgInstaller, and a build with a

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
ns running as a service having used 97.2 of desktop heap (vs. 45 connections max with 8.3). So we have a pretty serious regression in 8.3. Of course, that still doesn't tally up with what you're seeing on Win2k3. I'll test on there tomorrow. Regards, Dave

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Trevor Talbot wrote: > I wrote: > > [ desktop heap usage ] > >> It could be that there's a significant difference between XP and 2003 >> in how that's handled though. I do have an XP SP2 machine here with >> 512MB RAM, and I'll try tests on it as soon as I can free up what it's >> currently occu

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Magnus Hagander wrote: > Could you try a build without SSPI? It should be as simple as removing > the #define ENABLE_SSPI 1 from port/win32.h. I don't think you need to > touch the linker lines at all, actually, so try without first. Nope, doesn't help - still using around 9.7KB per connection. Ju

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Dave Page wrote: > So the only other changes I can think of that might affect things are > the VC++ build or the shared memory changes, though I can't see why they > would cause problems offhand. I'll go try a mingw build... mingw build of stock 8.3b1, no configure optio

Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit

2007-10-22 Thread Dave Page
Magnus Hagander wrote: > Yeah, it could be that the newer MSVCRT files do something we don't > like.. Other than that, did we upgrade to a different version of some of > our dependents? Most of them - but my test build is without any of them: our $config = { asserts=>1, # --en

  1   2   3   4   5   6   7   8   9   10   >