[GENERAL] date_trunct() and start of week

this is not accidently changed. I tried changing LC_TIME (American_America) but that still returned Monday as the first day (my understanding is that in the States Sunday is considered the start of the week) Any pointers are appreciated (did I miss it in the manual?) Regards Thomas -- Sent via pgsql

Re: [GENERAL] date_trunct() and start of week

Adrian Klaver, 26.11.2009 23:15: On Thursday 26 November 2009 1:59:05 pm Thomas Kellerer wrote: Hi, while using date_trunc('week', some_date) to get the date of the first day of the week I noticed that it was working as expected: Monday is considered the start of the week. I assume

Re: [GENERAL] using window-functions to get freshest value - how?

Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] using window-functions to get freshest value - how?

to your solution, but I think it's easier to read (personal taste!) but it also could be slightly more efficient. But most probably the optimizer is smart enough... Regards Thomas P.S.: could you please turn off the HTML format for your mails. Especially the SQL statements are very hard to read

[GENERAL] Books

random author calling him-/herself The PostgreSQL Global Development Group? :o) Regards, Thomas

Re: [GENERAL] column does not exist error

title FROM node WHERE type='client'; Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] column does not exist error

Hi, try SELECT title FROM node WHERE type='client'; hth Thomas Dave Coventry schrieb: Tearing my hair out, can anyone see what I'm doing wrong? SELECT title FROM node WHERE type=client; ERROR: column client does not exist LINE 1: SELECT title FROM node WHERE type=client; Yet

Re: [GENERAL] passing parameters to multiple statements

Konstantin Izmailov, 17.11.2009 17:33: This is why they want to use multiple statements Which is not portable as well. Actually the only database I know which permits sending more than one statement in one string is SQL Server... Thomas -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] test data

Willy-Bas Loos, 17.11.2009 12:15: Hi, Is there such a thing as a test dataset for postgresql? Coming from the project i mean. Cheers, WBL Try this: http://pgfoundry.org/projects/dbsamples/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Customize the install directory of the postgres DB

pointing to a directory which is located next to the directory where I unpack the archive. I then use batch files to start and stop the PG server during startup of my (web) application Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

[GENERAL] Windowing functions - future plans

framing clauses) but the explanation did not mention allowing a number instead of UNBOUND for the frame definition. Oracle and DB2 do support this syntax ;) Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Store images on database ou in external files?

Thomas [1] http://www.sql-workbench.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] sudoku in an sql statement

Merlin Moncure wrote on 31.10.2009 14:32: an oracle guy wrote an sql statement that solves a sudoku puzzle...using an oracle specific feature. Still, it's pretty neat, and an absolute gem of lateral thinking.

Re: [GENERAL] Correlated Subquery and calculated column non-functional

() over (partition by manufacturer, brand order by SUM(sales.qtysold * sales.unitprice)) as rank FROM cube_sales.sales INNER JOIN cube_sales.product ON sales.productid = product.productid GROUP BY product.manufacturer, product.brand; (Not tested) Thomas -- Sent via pgsql-general

Re: [GENERAL] Forms generator ?

://www.oncetechnologies.com/newonceradix/index.html Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Query to find contiguous ranges on a column

which might be a problem. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Updating row with updating function, bug or feature?

++--- 1 | t | 2 | t | 2009-09-30 15:27:20.497355+02 (2 rows) ROLLBACK == END OUTPUT == Thanks Regards, Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Updating row with updating function, bug or feature?

On Wed, 2009-09-30 at 10:17 -0400, Tom Lane wrote: Thomas Jacob ja...@internet24.de writes: I've run into some weirdness in PSQL 8.3.8 (Ubuntu 8.04 LTS x86_64 package). When I update a row while using a function result that updates that very same row in the WHERE part of the update

Re: [GENERAL] sync structures

. The output is an XML file that can easily be transformed into the approriate SQL scripts (a sample XSLT for Postgres is available) http://www.sql-workbench.net Description of the WbSchemaDiff command: http://www.sql-workbench.net/manual/wb-commands.html#command-schema-diff Regards Thomas

[GENERAL] Re: The password specified does not meet the local or domain policy during install.

the password rules you posted apply to your domain and not to your server? You can try to add the user before starting the Postgres installer and verify if adding the user through the usual Windows tools works. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Return 30% of results?

for me. Are you sure you are using Postgrs 8.4? (Windowing functions are not available in earlier versions) Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] invalid byte sequence for encoding

-CONFORMING-STRINGS Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Open source database design tool , alternative to MicroOLDAP

also looks quite promising and a lot more mature than Power*Architect. It's called Open ModelSphere: http://www.modelsphere.org/ Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] Swapped download links for 8.4.1 zip binaries

:) Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] help me please with function

I can not find command in postgres - With ... as You need Postgres 8.4 for that: http://www.postgresql.org/docs/current/static/queries-with.html Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] PosgreSQL Service does not Start In Vista

Inigo Barandiaran, 03.09.2009 14:47: Finally, I installed posgre database out of program Files as Thomas suggested and I gave full privileges to posgre user to data folder and everything works correctly :) Do you know how can I install posgre in program Files in Vista?. I might some users of my

Re: [GENERAL] PosgreSQL Service does not Start In Vista

) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PosgreSQL Service does not Start In Vista

Inigo Barandiaran, 02.09.2009 14:53: Thanks Thomas!. That sounds very interesting. How can I set privileges for writing in data directory for the postgres user account?. Right click on the directory and choose Security. Anything after that is off-topic in this list ;) Or is it very

Re: [GENERAL] GUI to edit a table's content

with edit in a GUI. e.g. with Squirrel or SQL Workbench/J you can run SELECT * FROM my_table and edit the contents of the result directly. Are you talking about something different? Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Select data for current week only

-mm-dd hh:mm:ss . A date column does not have a format :) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Select data for current week only

into the where condition: SELECT * FROM the_table WHERE extract(week from the_date_column) = extract(date from current_date) AND extract(year from the_date_column) = extract(year from current_date); but your solution is definitely more elegant ... Thomas -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Getting the column to a which a sequence belongs.

psql using the -E option didn't show up anything and I couldn't find any hints in the system catalogs documentation. Is this possible at all? As neither psql nor pgAdmin display this information, I suspect it's not. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Getting the column to a which a sequence belongs.

, pg_attribute a WHERE c.relkind = 'S' AND d.objid = c.oid AND d.refobjid= t.oid AND (d.refobjid,d.refobjsubid) = (a.attrelid,a.attnum); Ah great, I didn't realize I could use pg_depend for this. Thanks, works like a charm! This is exactly what I was looking for. Thomas

Re: [GENERAL] GUI to edit a table's content

Gauthier, Dave wrote on 27.08.2009 23:17: Are there any GUI apps out there that can be used to edit (insert, update, delete) table data? SOmething with enough smarts to sniff out constraint violations and report accordingly. Also, ability to eval constraints at commit time inside a

[GENERAL] No download of Windows binaries without registering?

it very much if the download link for the plain PostgreSQL builds from http://www.enterprisedb.com/products/download.do would lead to the download page directly without the registration screen. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] No download of Windows binaries without registering?

that points to the wrong EDB page somewhere? A sorry, I did not follow the link from the Postgres page, but came from http://www.enterprisedb.com/products/download.do Sorry for the confusion, I didn't realise the link from the postgresql.org site bypassed the registration screen. Thomas

Re: [GENERAL] Install from Source On Windows - University of Sydney Research

there is any difference between .cmd and .bat in any of the NT based Windows versions. At least on my WinXP (and earlier with W2K) double-clicking a .bat file always starts cmd.exe *not* command.com Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Getting listed on Community Guide to PostgreSQL GUI Tools

apply here :) As far as dead software, I think you should create a section at the end of the page and move dead projects there. How do I get an account to edit the page? Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

[GENERAL] Getting listed on Community Guide to PostgreSQL GUI Tools

(as a matter of fact I do most of the DBMS independent development agains my local PG database). I have also seen that some of the listed applications don't seem to be active any longer (PGAccess, Xpg, pginhaler). Wouldn't it make sense to clean up a bit there as well? Cheers Thomas -- Sent

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

really need to run an installer and/or create registry entries (for windows). This would then resemble more the Derby network server setup. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

of our application that we ran on MySQL just for the fun of it, and it failed miserable due to the different locking behaviour between Postgres and MySQL. I would expect similar problems with heavy transactional tests with any embedded engine as well. Thomas -- Sent via pgsql-general mailing

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

settings that it usually provides. Especially max_fsm_pages max_fsm_relations Which Postgres version are you using? IIRC those settings are not longer valid for 8.4 THomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] export csv file on XP

the server is running has read permissions on that file. I think *write* permission is the approriate ;) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pg_stat_activity undocumented?

Hi, is there a reason why pg_stat_activity is not documented in the chapter System Catalogs? Is this not a offical view? Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] pg_stat_activity undocumented?

Magnus Hagander, 30.07.2009 09:24: On Thu, Jul 30, 2009 at 08:37, Thomas Kellererspam_ea...@gmx.net wrote: Hi, is there a reason why pg_stat_activity is not documented in the chapter System Catalogs? Is this not a offical view? It's not a catalog, it's a statistics view. It's documented

Re: [GENERAL] pg_stat_activity undocumented?

in the system catalogs documentation would be helpful. Yes, definitely. At least that's the chapter where I start looking for things like that. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] selecting all columns but one

a select * but omit one? You need to list all columns that you want explicitely. Using SELECT * in a production application is considered bad practice anyway Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] For production: 8.4 or 8.3?

Tory M Blue wrote on 27.07.2009 22:45: And those that have multiple TB's of data, weee another dump and restore upgrade (pt!) Isn't that what pg_migrator is for? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Transitive Closure and CONNECT BY

Robert James wrote on 26.07.2009 21:35: Anything like CONNECT BY? Or any recommended way of querying hiearchial data? Yes, recursive common table expression (since 8.4) http://www.postgresql.org/docs/current/static/queries-with.html Thomas -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Using unnest

is not an array but type anyarray I'm pretty sure I'm overlooking something obvious with regards to the unnest syntax, but what? Thanks Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Using unnest

'{1,2,3}'::text[] Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Copying only incremental records to another DB..

not possible to do an offline-diff) Feel free to contact me if you have any questions (support email address is on the homepage). Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] comparing NEW and OLD (any good this way?)

Pavel Stehule, 23.07.2009 13:45: Hello http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks#Fast_compare_variables_NEW_and_OLD_in_trigger.27s_body regards Pavel Stehule That collection of tips is really nice. Why isn't there a link from the Postgres Wiki to your page? Regards Thomas

Re: [GENERAL] comparing NEW and OLD (any good this way?)

and your excellent collection. Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] COPY command on windows???

Andreas wrote on 17.07.2009 20:06: Hi, I'd like to read a csv file into PG 8.4. COPY relations FROM E'd:\\relations.csv' CSV HEADER; It throws (translated): ERROR: can't open file d:\relations.csv for reading file or directory not found Try COPY relations FROM 'd:/relations.csv' CSV HEADER;

Re: [GENERAL] Error in insert statement

naming scheme to me. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] problem with pg_restore?

://www.pnotepad.org http://www.pspad.com http://notepad-plus.sourceforge.net Commercial (but not expensive) http://www.textpad.com I have edited files with more than 1 characters per line in PNotepad, PSPad and Textpad Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] How to DB export XML File in PostgreSQL?

into a (single?) XML file, or do you want to export XML files that stored in the database? Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Start With... Connect By?

BY, it's really very elegant) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Start With... Connect By?

. Firebird implemented recursive CTEs with Version 2.1 which was released April, 2008, more than a year ago. Which makes it the first OpenSource DBMS to implement them I guess. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Question]

Martie Krukkeland wrote on 13.07.2009 21:11: If you are using Windows: Windows has the build in: Scheduled-Task (this is the Windows-equivelant of the Unix-Cron). It can be found in the Configuration-Screen. Or simply using the at command -- Sent via pgsql-general mailing list

Re: [GENERAL] Sugestion a db modele like mysql workbrench

;-). This is interesing for people needing more options as given in pgAdmin. Do you know something else? Try out Power*Architect: http://www.sqlpower.ca/page/architect Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Will there be an official pg_migrator release?

Bruce Momjian wrote on 05.07.2009 02:13: Will there be an official release of it, now that 8.4 is out of the door? Including Windows binaries? Yes, I expect sometime in the next five days. Great, thanks for the info. Thomas -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Will there be an official pg_migrator release?

Hi, the project page of pg_migrator still shows it as a release candidate. Will there be an official release of it, now that 8.4 is out of the door? Including Windows binaries? Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Regex Character-Class

constant that contains a backslash, you must write two backslashes in the statement, assuming escape string syntax is used (see Section 4.1.2.1). Ciao, Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Database schema dumper

-report Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replication

Craig Ringer wrote on 24.06.2009 04:07: Thomas Kellerer wrote: Mike Christensen wrote on 23.06.2009 19:37: Does anyone actually have that (any node can go down and the others still replicate amongst themselves?) I think this is what Oracle promises with their RAC technology. Isn't RAC

Re: [GENERAL] Replication

Mike Christensen wrote on 23.06.2009 19:37: Does anyone actually have that (any node can go down and the others still replicate amongst themselves?) I think this is what Oracle promises with their RAC technology. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] What's wrong with this query?

= some_column; boils down to the same behaviour... Regards Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] What's wrong with this query?

speciality). You need to use select * from test where value != '----' or value is null; Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Data merging problem

into a SQL script) WbDataDiff[2] can compare the contents (data) of two databases and either run the necessary UPDATE/DELETE/INSERT statements directly or write them as SQL scripts. Especially generating the DELETE http://www.sql-workbench.com Thomas [1] http://www.sql-workbench.net/manual

[GENERAL] Re: How to get the size of non fixed-length field from system catalog ?

the information_schema, that is easier: SELECT character_maximum_length FROM information_schema.columns WHERE table_name = 'your_table' AND column_name = 'the_char_column'; http://www.postgresql.org/docs/8.3/static/infoschema-columns.html Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Authenticate via SSPI/GSSAPI on Windows Server

setting up sspi locally (I can't use the server for playground testing). Strange behaviour: now pgAdmin asks me for the password of the user postgres again, although it should actually connect as Thomas. I tried a lot of things, but I can't explain them here as I just did trialerror. None worked. 3

Re: [GENERAL] Please remove me from the list!

to say the same as you until I realised this. :-) They have come through on every other post, however. That's probably because he sent his mail as multipart/alternative; it has a plain text and a html part. Not easy to append the standard footer to such a beast. Ciao, Thomas -- Sent via pgsql

Re: [GENERAL] Can't start service but works from command line

Dejan wrote on 24.05.2009 01:19: Computer which hosted a database crashed, but I managed to save data folder. I copied it to another computer and pointed postgres to that folder (stopping the service first). But, the service cannot start. Progress bar just goes for awhile, and then a pop-up

Re: [GENERAL] do postgresql this job for me ? (firebird user)

concurrent inserts, updates, or deletes on the table Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Get block of N numbers from sequence

Boszormenyi Zoltan schrieb: Thomas Guettler írta: Hi, how can you get N numbers (without holes) from a sequence? # create sequence tmp_seq cache 1000; Hi, alter SEQUENCE ... cache 100 survives a rollback. That's something I like to avoid: foo_esg_modw=# select * from foo_isu_isu_id_seq

Re: [GENERAL] Get block of N numbers from sequence

Thomas Guettler schrieb: Hi, how can you get N numbers (without holes) from a sequence? If sequences could be locked like tables, it would be easy. In old versions of postgres it worked: http://archives.postgresql.org//pgsql-hackers/2001-10/msg00930.php Thomas -- Thomas Guettler

Re: [GENERAL] [Windows] Feedback on PG?

. So when looking for specific feature you need to search several documentation sets which I find very unpleasant. I also have the impression that there is a lot more momentum to the Postgres project than to Firebird. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] [Windows] Feedback on PG?

gives me a basic installation Running initdb to initialize the database and pg_ctl to register the service is extremely easy. A customized installation could be done with a four line batch file :) Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

[GENERAL] Get block of N numbers from sequence

Hi, how can you get N numbers (without holes) from a sequence? Thomas -- Thomas Guettler, http://www.thomas-guettler.de/ E-Mail: guettli (*) thomas-guettler + de -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Get block of N numbers from sequence

hubert depesz lubaczewski schrieb: On Tue, May 19, 2009 at 01:45:17PM +0200, Thomas Guettler wrote: how can you get N numbers (without holes) from a sequence? alter sequence XXX increment by 1000; select nextval('XXX'); alter sequence XXX increment by 1; If other processes run nextval

Re: [GENERAL] postgresql on windows98

Craig Ringer, 14.05.2009 14:31: You really, really, REALLY don't want to run the server on win98. That should be: You really, really, REALLY don't want to run Win98 :) SCNR Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Cannot login for short period of time

Hi, check your hardware (especially harddrive) for errors. regards Thomas Henry schrieb: Greets, Pg: 8.3.7 I'm trying to diagnose why I cannot login to Pg on occasion. The psql command will just hang (so I cannot get in to see what it's doing) and a telnet into 5432 will give

Re: [GENERAL] Postgres: Transaction Connections

- as with any other sensible RDBMS - you can *not* turn them off. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] XML - PG ?

('SUE','CARPENTER'); insert into jobs (job_name,salary) values (CARPENTER,25.50); insert into jobs (job_name,salary) values (PLUMBER,28.75); You could use XSLT to tranform the XML into the approriate SQL Statements. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] windows service

. However, I can not get the sc command to accept the above string on the command line. Any help would be much appreciated. If the service is already registered with the name P4, you can start it using net start P4 Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] How to begin to debug FATAL: invalid frontend message type 77 error messages?

the Postgres protocol? The connects seem to occur quite regularly every 11 seconds... You might want to configure the log output format to include the IP address/host name of the creator of these messages (log_line_prefix in postgresql.conf, %h). Or use a packet sniffer like wireshark. Ciao, Thomas

Re: [GENERAL] Possible to prevent transaction abort?

between keyboard and chair. My import program had an additional parameter which was needed to enable the savepoint. If that is set, the results are comparable to your test program (and reproducable). So my fast results were not using savepoints. Sorry for the confusion. Thomas -- Sent via

Re: [GENERAL] Possible to prevent transaction abort?

to the one when not using a savepoint (less than a second which could well be caused by other things in the system). I tested this locally so no real network traffic involved, which might change the timing as more stuff is sent over to the server when using the savepoint. Thomas -- Sent via

Re: [GENERAL] Possible to prevent transaction abort?

if this is a driver issue Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Sequence Incrementing by 2 insted of 1

of both before and after triggers that do various bits of business logic as well as some rewrite rules to track field changes. Using 8.3.0. Can anyone think of a reason why? My first guess would be rolled back transactions Thomas -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Yet another drop table vs delete question

with truncate? does it remove everything so that vacuum has almost no work to do or is it approximately as much work either way? regards thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Error installing Postgres

as I recall the .exe is the EnterpriseDB One-Click-Installer. The pginstaller always comes as a zip file Christine: what kind of installer did you use for the initial installation? Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Error installing Postgres

because I recommended it, downloaded the one-click installer because that was the one on the download page Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Error installing Postgres

Bruce Momjian wrote on 22.04.2009 20:26: Yes, I can confirm I think pg_migrator will work for 8.3-8.4 upgrades; I start testing this week. This is pretty good news, cool. Will there be Windows binaries for the pg_migrator once that 8.4 ships? Thomas -- Sent via pgsql-general mailing list

Re: [GENERAL] select distinct, index not used

PostgreSQL 8.2.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.2.1 (SUSE Linux) (1 Zeile) Tom Lane schrieb: Thomas Guettler h...@tbz-pariv.de writes: why does the statement take so long? The column 'lieferant' is indexed. But a sequential scan gets

[GENERAL] select distinct, index not used

-- PostgreSQL 8.2.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease) (SUSE Linux) (1 Zeile) -- Thomas Guettler, http://www.thomas-guettler.de/ E-Mail

Re: [GENERAL] Looking for advice on database encryption

by far not an expert, but my naive attempt would be to store the the database files in an encrypted filesystem. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Looking for advice on database encryption

input, maybe even control the access to the data by stored procedures which can add an additional layer of security) I agree with Kenneth: you need to be more precise on which scenario you have to deal with. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

<    5   6   7   8   9   10   11   12   13   14   >