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

the field will be set to "zero". But does zero refer to a Monday or a Sunday? 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] 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 a

[GENERAL] date_trunct() and start of week

ure 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 Th

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

(SELECT max(letztespeicherung) FROM rfmitzeit r2 WHERE r2.id_bf = r1.id_bf) Not really different 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

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

over (partition by id_bf) FROM rfmitzeit 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] Books

a compilation of the online manuals, done by some random author calling him-/herself "The PostgreSQL Global Development Group"? :o) Regards, Thomas

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 l

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

Re: [GENERAL] column does not exist error

iteral: SELECT 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] 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 subsc

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

p the archive, run initdb 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

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

ALUES (42, {$blobfile=c:/temp/postgres.gif}); Regards 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

[GENERAL] Windowing functions - future plans

t for window 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 subscrip

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. http://technology.amis.nl/blog/6404/oracle-rdbms-11gr2-solving-a-sudoku-using-recursiv

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

ld * sales.unitprice) as turnover, rank() 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 te

Re: [GENERAL] Forms generator ?

for http://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

plan with a self join and a subselect), but it does sort the whole table 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

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

On Wed, 2009-09-30 at 10:17 -0400, Tom Lane wrote: > Thomas Jacob 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&qu

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

ck -- t (1 row) UPDATE 1 id | locked | accessed ++--- 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.

Re: [GENERAL] sync structures

n two databases. 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

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

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?

; 0.3 Works 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

time-config-compatible.html#GUC-STANDARD-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/

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

[GENERAL] Swapped download links for 8.4.1 zip binaries

7;ll get the windows 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] 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?

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

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

ar users (for a good reason) 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] GUI to edit a table's content

mean 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

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 transactio

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

ass t, 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

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

27;s "owned" by a column. So far "debugging" 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.

Re: [GENERAL] Select data for current week only

d the year 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 mail

Re: [GENERAL] Select data for current week only

with the format -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] No download of Windows binaries without registering?

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. T

[GENERAL] No download of Windows binaries without registering?

age. I would appreciate 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-genera

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

7;t really 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 su

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

on monster command.com . I don't think 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 mailin

[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

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

thing". We have e.g. unit test for one 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. Th

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

x27;t 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/

Re: [GENERAL] export csv file on XP

blem - check that the user as which 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

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] pg_stat_activity undocumented?

e a remark 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.postgres

Re: [GENERAL] pg_stat_activity undocumented?

Magnus Hagander, 30.07.2009 09:24: On Thu, Jul 30, 2009 at 08:37, Thomas Kellerer 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.

[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.postgresq

Re: [GENERAL] selecting all columns but one

do 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:

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: http://www.pos

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

Re: [GENERAL] Using unnest

, when I supply a literal like '{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

[GENERAL] Using unnest

#x27;; gives me the error argument declared "anyarray" 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 chang

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

#x27;s 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.postgresq

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

that page 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] 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 T

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 HEAD

Re: [GENERAL] Error in insert statement

hen doing normal DML. Out of curiosity: why do you prefix the table with "tbl"? Don't you know it's a table? Sounds like a strange 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] How to DB export XML File in PostgreSQL?

nto 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] problem with pg_restore?

and free: http://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

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 (pgsql-ge

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

em as well. 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 su

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

h the ANSI standard had adopted the CONNECT 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] Sugestion a db modele like mysql workbrench

ndows ;-). 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 sub

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

ckslash (\) already has a special meaning in PostgreSQL string literals. To write a pattern 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 (

Re: [GENERAL] Database schema dumper

mands.html#command-schema-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

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?

he_table WHERE some_column = 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?

mparison with a NULL value always returns false (and that is not a Postgres 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

be transformed 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-workb

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

x27;t find details on how to decode it. Use 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

[GENERAL] Authenticate via SSPI/GSSAPI on Windows Server

nd I tried 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 her

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

through on the OP's emailI was poised 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 ea

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

locks that prevent 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] 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 t

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

simply extract which 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

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

lowly. 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@postgresq

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

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 t

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 incremen

[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] 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 su

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

Re: [GENERAL] XML -> PG ?

; 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) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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] windows service

Where P4 is the name of the 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 ma

Re: [GENERAL] Possible to prevent transaction abort?

t;problem sits 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. T

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

k 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

Re: [GENERAL] Possible to prevent transaction abort?

the JDBC list, to see 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] Possible to prevent transaction abort?

nt 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 -- Sen

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

er 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-ge

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 l

Re: [GENERAL] Error installing Postgres

ed PG 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

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] Yet another "drop table vs delete" question

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] select distinct, index not used

# select version(); version 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 writes: >> why does the statement

Re: [GENERAL] Looking for advice on database encryption

'm being asked about ;) 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

is (prepared statements, sanitizing and cleaning any user 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

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