Re: [GENERAL] correlated query as a column and where clause

pg_namespace > where nspname !~* 'pg_' > > > what you are looking for is the having clause Select nspname, count(1) FROM pg_tables where nspname !~* 'pg_' group by nspname having count(1) >10 best wishes Harald -- Harald Armin Massa www.2ndQuadrant.com Post

[GENERAL] PostgreSQL documentation on kindle - best practices?

ad PDF and put on kindle 1-3 and use different conversion tools. So my question: has anyone found a best practice solution to convert the PostgreSQL documentaiton into a kindle-friendly format? Or has even an .azw file downloadable somewhere? Best wishes, Harald -- Harald Armin Mas

Re: [GENERAL] postgresql-9.0 service starting problem

he eventview application and check for entries in the application log. Best wishes Harald -- Harald Armin Massa www.2ndQuadrant.com PostgreSQL Training, Services and Support 2ndQuadrant Deutschland GmbH GF: Harald Armin Massa Amtsgericht Stuttgart, HRB 736399

Re: [GENERAL] Database recovery.

ctory. Check your file systems permissions and allow writing to the data directory for the user your PostgreSQL service runs as. Best wishes HArald -- Harald Armin Massa     www.2ndQuadrant.com PostgreSQL  Training, Services  and Support 2ndQuadrant Deutschland GmbH GF: Harald Armin Massa Amts

Re: [GENERAL] Using copy for WAL archiving on Windows

wishes, Harald -- Harald Armin Massa www.2ndQuadrant.com PostgreSQL Training, Services and Support 2ndQuadrant Deutschland GmbH i.Gr. GF: Harald Armin Massa

Re: [GENERAL] problem updating from form

of the professional service providers at http://www.postgresql.org/support/professional_support (disclaimer: I am with one of them) -- Harald Armin Massa www.2ndQuadrant.com PostgreSQL Training, Services and Support

Re: [GENERAL] Issue while using PostgreSql 8.4.

table"? Because dropping a locked table has to wait until the lock is gone to complete. (esp. if there is an implicit commit in your execute; which may or may not be, depending on your connection-configuration) Harald -- Harald Armin Massa www.2ndQuadrant.com PostgreSQL Training, Services and Support

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

ot;really, really large" in other units, like Gigabytes or Number of rows (with average rowlength in bytes, of course) That is: what table size would you or anybody consider really, really large actually? Harakd -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Str

Re: [GENERAL] postgreSQL & amazon ec2 cloud

way to run a relational database with EC2, as the storage requirements of SQL Server and PostgreSQL are not THAT different. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - LASIK go

[GENERAL] psql: not enogh memory when trying to use utf8 on windows

expected just for changing the code page Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned! -- Sent via pgsql-general mailing li

Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default

of surprising to see > your experience. It did not wrap at all, so that "randomly not wrapping at all" was my kind of failure, wasn't it? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx

Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default

Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default

Germany | German, Germany | =c/pos tgres : postgr es=CTc/postgres (4 Zeilen) Harald On Thu, Feb 19, 2009 at 14:11, Bruce Momjian wrote: > Harald Armin Massa wrote: >> Hello, >> >> testing / using PostgreSQL 8.4, I queried the list of databases via >&

[GENERAL] \l of psql 8.4 looks ... unreadable on 80char default

a result: this basic information command is rather unreadable with only 80chars. is this an effect only with "long name collations"? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - Euro

Re: [GENERAL] Multiple postgres.exe On Processes

efault-view of TaskManager (XP) does NOT show this memory as shared, but as "multiple multi megabyte processes". In other words: the default view of TaskManager gives the impression that shared memory is used by every process. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Mas

Re: [GENERAL] small doubt

UM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

[GENERAL] updateable view: message

stead rule that raises "NOTICE" ... which seems rather hackisch. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned! -- Sent vi

Re: [GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results

o be special provisions made concerning backup and viralscanners. THE MORE hurting problem on Windows7 is the inability to start the postgresql service. There must have been some changes to the service framework / security "security" which prevend the startup... Harald -- GHUM Harald

[GENERAL] Installing PostgreSQL on Windows 7 Beta Build 7000 64bit - first results

PostgreSQL somehow works on Windows 7 64bit; BUT not running as service I would be willing to conduct more tests or try other things or provide logs, please contact me! :) Best wishes Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/

Re: [GENERAL] version number between pgdump and server

o a fixed bug in pg_dump. So better one warning more then one warning less, best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - S

Re: [GENERAL] Cannot restart postgresql when increasing max_connections

QL-Data-Directory in subdir pg_log best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned! -- Sent via pgsql-general mailing list

[GENERAL] how can I exclude stuff from template in my dumps?

they can overshaddow REAL error messages within the output. Is there a clever way to exclude them from dumps or restores? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take

Re: [GENERAL] Session variables (how do I pass session data to a function)

COST 100; You can adjust that "0" to NULL or whatever should be the default for your application. In mine I default to 0; with 0 being something like "testuser". best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49

Re: [GENERAL] How to select rows that are the max for each subcategory?

uups, you need to specify the table in the select, so select t.x,t.y,t.z from t join (select x, max(y) as my from t group by x) t1 on (t.x=t1.x and t.y=t1.my) On Thu, Sep 25, 2008 at 20:05, Harald Armin Massa <[EMAIL PROTECTED]> wrote: > select x,y,z > from > t join (sele

Re: [GENERAL] How to select rows that are the max for each subcategory?

he desired query would be > a 3 meenie > b 4 moe > TIA! > Kynnjo > > > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tu

Re: [GENERAL] Autovacuum, too often?

ot;unused" i.e. deleted tuples, which get recycled by your vacuuming. And that with nearly no CPU usage. Sounds fine to me :) Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - EuroPython 2009 will take place in Birmingham - Stay tuned!

Re: [GENERAL] Vacuuming on heavily changed databases

best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pidgeon - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Conditional on Select List

Is there such IF function or do I have to create my own. > > Thank you. > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tune

Re: [GENERAL] PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server:

ling list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython

Re: [GENERAL] Request for Materialized Views

is list. You must try elsewhere first!" best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! -- Sent via pgsql-general

[GENERAL] TrueCrypt -> Forwarded from advocacy

obation) are safe >via a different password. TrueCrypt is really amazing ... and now to my question: who has experience of PostgreSQL database files on TrueCrypt volumes? Speed? Reliability (additional layers between database and harddrive are allways challenging) Harald -- GHUM Harald Mass

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

Micah, psycopg2 has a license extensions which allows basically to use psycopg2 binaries without distributing source code as long as there are no modifications to the psycopg2 C code best wishes Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49

Re: [GENERAL] No Return??

Bob, if pumpnumber not in (1,2) that function does not return anything. > End If; > at this end if it ends so you have to return sth. here > END; Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 f

Re: [GENERAL] Postgresql Conferences/events in Europe?

likely there will also be some talk about PostgreSQL and how great 8.3 is Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! -- Se

Re: [GENERAL] beginner: what permissions required to install on windows 2000+

running the service: a) what user is the service configured to use to log on? b) what policies are in effect on that user? Please be aware that a lot of defaul policies do take away the "LOGON_AS_SERVICE" privilege c) whats within the log files? Harald -- GHUM Harald Massa persuade

Re: [GENERAL] Bug (?) in JDB

attempt an SSL connection. so probably you should use "disable" instead of "false", and "require" or "prefer" instead of true? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 0121

Re: [GENERAL] exporting postgre data

features that I'm aware of, just has a > nice "one stop" interface. > > -- > Bill Moran > http://www.potentialtech.com > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > -- GHUM Hara

Re: [GENERAL] exporting postgre data

HUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ---(end of broadcast)--- TIP 3: Have you checked

[GENERAL] suggested wording improvement in psql

sa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ---(end of broadcast)--- TIP 9: In versions below 8.0, the

Re: [GENERAL] count(*) and bad design was: Experiences with extensibility

do not have MVCC 3) store "record deleted info" in index, so you can answer count() with only scanning the index Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 -

Re: [GENERAL] data transfer/migrate from win to linux

included with PostgreSQL. To avoid challenges, make sure that the PostgreSQL versions on both systems match. best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take

large objects,was: [GENERAL] Restoring 8.0 db to 8.1

eate NEW PostgreSQL databases using Large Objects, now that there is bytea and TOAST? (besides of legacy needs) as much as I read, they take special care in dump/restore; force the use of some special APIs on creating, do not work with Slony Harald -- GHUM Harald Massa persuadere et programmare

Re: [GENERAL] Create Index (Hash) on a Large Table Taking Days...

e read that hash indices are only for some cases I could not match to something that happens in my world; since then I am using default btree and am VERY happy.) Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607

[GENERAL] C-Extenions for PostgreSQL, Call Convention Version 0

version 0 depreciated? Or ist there still value in learning it? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! -

Re: [GENERAL] Deploy postgres - upgrade strategy

ing installation", and that that key does NOT get updated on changes via services.msc, or? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

Re: [GENERAL] HouseKeeping and vacuum Questions

the delta between two vacuums in seconds or minutes, not hours or days. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

Re: [GENERAL] Understanding Aliases

= t2.id AND value=10) <= 3 >) > > select t2.id, count(t4.id) from t2 join t4 using on (t2.id=t4.t2_id) where t2.active and t4.value < 10 group by t2.id having count(t4.id) <= 3 should do the trick without double select, or? Harald -- GHUM Harald Massa persuadere et program

Re: [GENERAL] CPU

experience mainly drawn from windows) Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

Re: [GENERAL] Casting hexadecimal IPs to readable content

database. The problem is that PhpBB stored IPs as > strings, which seem to be more or less encoded. > > In PhpBB, IPs are stored as Hexa: > "54dc0636" > "52e1fcb6" > > How to cast these values to readable content? > Any idea ? This is an important issue f

Re: [GENERAL] Using Postgres as a "embedded" / SQL Lite database on Windows

on-backend - challenges with System Administrators arose from multiple postgres.exe processes running on each server (just starting postgres leads to 5 postgres.exe in taskmanagers process-view; that is correct but unusual for Windows) Best wishes, Harald -- GHUM Harald Massa persuade

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

vice-0x0-3e7$).""" it is exactly as suspected ... just starting the service allocates that heap Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilniu

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

t;" Postgres is definitely NOT started as LocalSystem account; so using a "logical not" on Microsofts Words that could indicate the reason why our service-backends consume that memory? Add to this that MS SQL runs as LocalSystem; and as much as I know also Oracle. Is this a p

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

for user32.dll or shell32.dll? Wasn't the point of shared dlls to be shared? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius,

Re: [GENERAL] Abbreviation list

Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! ---(end of broadcast)--- TIP 5: don't forget to increas

Re: [GENERAL] Suggestions for Remote Procedure Calls from PG, please?

nvoke a web > service on the other box... > Does anyone else invoke a process on a remote server? How do you do it? -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in V

Re: [GENERAL] Upper and Lower-cased Database names?

blic.cars; > ERROR: cross-database references are not implemented: "mytest.public.cars > " > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished

be "I link with my software, so that there is only ONE application". Is my understaning of "embedded" wrong or oldschool? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroP

Re: [GENERAL] Question on INDEX and SQL - stalling my database?

for the edge of your seat? > Check out tonight's top picks on Yahoo! TV. > http://tv.yahoo.com/ > > -------(end of broadcast)--- > TIP 6: explain analyze is your friend > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

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

er a view, > and allow you to set the comment and default value for each. -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

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

n pgadmin to view it :) ) My question is: - is this a legal usage of COMMENT, or could this "vanish" in later releases? (within COMMENTs documentation there is only mentionedcolumn .) Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielbe

Re: [GENERAL] Tunning PostgreSQL performance for views on Windows

ts/Tidbits/perf.html those performance-recommendations are primarly based on Unix-Systems (Linux, BSD, Solaris). Especially shared buffers have totally different effects on win32. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49

Re: [GENERAL] Using C# to create stored procedures

sable for more then one language. (Not that I want to embrace that platform) Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] Tracking disk writes? (again)

Erik, for solaris I think dtrace can be of help: http://www.opensolaris.org/os/community/dtrace/ PostgreSQL 8.2 introduced dtrace-ability. From what I read it is specifically created to do this kind of measurement. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa

Re: [GENERAL] Tracking disk writes? (again)

programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] capacity of tables

One table. If you need to split, you can allways do that via inheritance & constraint exclusion, thereby creating table partitioning. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-1369

Re: [GENERAL] Installing PostgreSQL under Cpanel

your search command was wrong; or you do not have access to that directory. (second one is very unlikely as root) best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only

Re: [GENERAL] Installing PostgreSQL under Cpanel

er you learned the hard way how to make cpanel do what you want, document your steps and send it to the list. Thanks for trying PostgreSQL, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the

Re: [GENERAL] Installing PostgreSQL under Cpanel

Erick, psql -U postgres should help. I hope you remembered the password you gave to the database superuser while installing... best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

ld -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

uld be curious why it does , but usually I am happy that it does:) Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

enabled on the server; and the security implications of that setting have to be considered before :) best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than

Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?

understand then text output. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords. ---(end of broadcast)--- TIP

Re: FW: [GENERAL] Male/female

able and native replication for " The Girl That Every Man Secretly Wishes He Was Married To!" Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords. -

Re: [GENERAL] IS it a good practice to use SERIAL as Primary Key?

Ron, > In the "real world" there is no such thing as a primary key. At least not > over time. Not enough people understand the concept of a primary key to > make those things existent in the real world. There are lots of numbers. Credit card numbers, account numbers sales ticket numbers, etc,

Re: [GENERAL] PostgreSQL doesn't accept connections when Windows

r redirection assumed) whats in that ? Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] PostgreSQL doesn't accept connections when Windows Server is rebooted

from the postgreSQL service refill the login information. That does reset the LOGON_AS_SERVICE privilege. Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] IS it a good practice to use SERIAL as Primary Key?

such thing as a primary key. At least not over time. Not enough people understand the concept of a primary key to make those things existent in the real world. So we take an artificially primary key - and most reliable way is to create it yourself. Harald -- GHUM Harald Massa persuadere et programma

Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

Ritesh, what you are trying to do sound very similiar to dabo: http://dabodev.com/ Maybe have a look at it first? best wishes Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more

Re: [GENERAL] starting postgres on windows

hth Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] indexes

r key to connect the tables. best wishes harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - Python: the only language with more web frameworks than keywords.

Re: [GENERAL] plpython

KM,Can someone hint on resources for using plpython for writing stored procedures ? I have gone thru official docs for  8.1.5 for plpythonu but its not in detail/with examples.CREATE OR REPLACE FUNCTION myfunc(text)  RETURNS text AS$BODY$eingabe=args[0]hello = "Good Morning %s" % (eingabe,) return

Re: [GENERAL] SQL injection in a ~ or LIKE statement

psycopg2 supports parameters which are escaped properly.adding: Judging from the mails of  Frederico, developer of psycopg2, he was also in the "early notify circle" of the 8.13->8.14 escaping improvement. So, if done correctly the DB API way, all escaping with psycopg2 is fine.Harald-- GHUM Haral

Re: [GENERAL] 8.2beta1 installation fails

Andrus,did you make sure you used the /console mode of remote desktop?On 10/24/06, Andrus <[EMAIL PROTECTED] > wrote:I ran msi installation package downloaded from postgresql.org from remotedesktop.I selected Estonian locale, UTF-8 database encoding.it is a known limitation that installtion via re

Re: [GENERAL] Upgrade 7.4 to 8.1 or 8.2?

John,No I cannot risk live data...please read closely: Ron wrot "Can you risk your app on beta software?" .. There is allways a risk included in basing an application on beta software, as programming interfaces may change.BUT:My experience is: you can trust your data to PostgreSQL. The elephant nev

Re: [GENERAL] why not kill -9 postmaster

>> If your server is changing the data file on disk and you pull the power > cord, what chance do you expect of reading that data file again?1.  That's what we have WAL for.  The only thing that can really killyou is the use of non-battery-backed write cache. Just for information: I had to suffer n

Re: [GENERAL] Can we convert from Postgres to Oracle !!???

. economically: not enough information to give a fitting answer. But if you need a high cash burn rate to attract certain kinds of investors, Oracle will propably make that easier. Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart

Re: [GENERAL] Fast backup/restore

Gandald,have a look athttp://momjian.us/main/writings/pgsql/administration.pdfpage 44ffThere are descriptions how to do database-backups at the speed of raw file system operations. Harald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607-P

Re: [GENERAL] Partitioning vs. View of a UNION ALL

Ron,Even though using a view means that it would have to be recreatedeach period as the oldest table is dropped, please keep in mind: views are not really "created" ... also the command is named "create view"VIEWS, at least in PostgreSQL (and Oracle) are nothing else then "macros" for Queries - th

Re: [GENERAL] postgresql.conf shared buffers

Jim, list,from your link:ttp://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html I quote:"""As a rule of thumb, observe shared memory usage of PostgreSQL with tools like ipcs and determine the setting. Remember that this is only half the story. You also need to set effective_ca

Re: [GENERAL] Restart after poweroutage

Jon,For what it is worth, I created a FC5 VMware installation and loaded mydatabase data into it.  I simulated a bunch of power outages by telling VMware to power off the vm.  Is this a good simulation of a poweroutage, or is there something inherently flawed about using a VM to testthis?It is inhe

Re: [GENERAL] postgresql rising

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

Re: [GENERAL] postgresql rising

Alvaro,I wonder if we could replace the elephant logo with a female elephant logo.  That could work wonders ... among the elephant community at least.  Are there many elephants among decision makers? Asking google:http://www.google.de/search?q=teach%20an%20elephant%20to%20dance&ie=UTF-8&oe=UTF-8&hl

[GENERAL] Limits of arrays

I found a rather strange but working method to compare the contents of two tables in different databases: select 'otformularfeld' as which, md5(array_to_string(array( select md5(id_pkff||id_formular||id_formfeld||id_bf) from otformularfeld where quarant=0 order by id_pkff ),'')) So:  -  basically

Re: [GENERAL] [pgadmin-support] pgAdmin III v1.6 Beta 1 Released

Wow!This really looks good. I especially like the subtile but helpfull improvements to the Query-Window --- that braces-matching really helps!Also the fine change to "finish" on the maintaince-OK button is a very nice solution. As pgadmin is distributed with PostgreSQL on Win32, maybe a slogan lik

Re: [GENERAL] Large database design advice

Joe,with a normal "serial", without "big", you can have 9.223.372.036.854.775.807 records individually numbered. - Few tables but number of objects is tens-hundreds of thousands.- less than 100 queries per second.so you are talking about 10*100*1000=100 in words one million records? That is not

Re: [GENERAL] UUID as primary key

Vance,nice that it was of help.(When going from Java to the database, for example, it's easiest to compose the value directly into the SQL query rather thanusing a parameter.)  This seems quite viable.Please allow me to recommend to you to NOT go this seemingly easy way. I went there myself (but di

[GENERAL] PostgreSQL getting slower over time, restart of service cures the problem

Operating System: Windows 2003 ServerPostgreSQL 8.1.4 from the official installerAfter starting the service, a series of big queries runs blazingly fast ... for around 2 days. Then they get slower by day. After 3-4 days, the postgresql.exe processes have grown to around 120Megabyte "Memory Usage" a

Re: [GENERAL] Weird join result

Peter,This returns 1280 rows, none of which are have a NULL value for sum. This surprised me at first as I thought the WHERE clause should apply before theOUTER JOIN but apparently not. I then tried the following:what gives you the impression that WHERE clauses should be applied before the JOINs ?

Re: [GENERAL] Is it possible (postgresql/mysql)

Louis,there may be an a unimportant performance penality for varchar, because of filling up and whatever. But the real reason: as much as I researched, NOBODY stated that varchar2 would be faster or better; but it limits the length. And I spend to much time in working around fixed field lengths in

  1   2   >