Re: [GENERAL] Keeping historical record changes w/ triggers - best practices?

are the thoughts regarding best practices in PG? I handle this using middleware outside the db. Past revisions of a record (from any table I want to track) are serialized into a JSON format and stored in a single table. Postgres speaks JSON now, so.. -- Greg Donald -- Sent via pgsql-general mailing

[GENERAL] pgpool2 load balancing not working

transactions all throughout my code :( Still hoping it's a pgpool setup issue, since it's my first time setting it up and all. Thanks. -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaver adrian.kla...@gmail.com wrote: What is the pg_dump command, with options, you are using? My backup shell script contains: /usr/bin/pg_dump cp | bzip2 $FILE -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

.. so now I'm doing it wrong? I'll pass, thanks for all your help guys. It's been a blast. -- Greg Donald -- 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] PostgreSQL 9.1 pg_dump setval() sets wrong value

of the same names in different schemas. I have one schema and one database on that one database server. And like I said, it worked fine until 9.1. If it was any of those reasons you suggest, would I not have experienced the same problem back in 8.4? I would think so. -- Greg Donald -- Sent

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

with 8.4 pg_dump were good to go and now they are not with 9.1 pg_dump. I remain unclear as to what state is actually in the database, or what is being dumped, The whole thing is being dumped. One command /usr/bin/pg_dump cp, that's it, nothing special. -- Greg Donald -- Sent via pgsql

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

have a '1', like this: SELECT pg_catalog.setval('company_id_seq', 1, false); Some do not have a '1', some are actually set correctly. Thanks. -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

back this morning and pulled older backups, from when I was using pg_dump that came with my PostgreSQL 8.4 install. Those backups look fine to me, all the setval() calls are there and correct. So it looks like a problem with the new pg_dump best I can tell. -- Greg Donald -- Sent via pgsql

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

); to fix things up for me on my local setup. -- Greg Donald -- 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] PostgreSQL 9.1 pg_dump setval() sets wrong value

by that particular bug report form. I may try that version tonight, I actually found 9.1.2 packages http://www.openscg.org/se/postgresql/packages.jsp Maybe my fix will be in there. -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

On Wed, Dec 28, 2011 at 1:00 PM, Tom Lane t...@sss.pgh.pa.us wrote: Greg Donald gdon...@gmail.com writes: Are you sure that the sequence is being used to insert those values into the table? When I insert a new row into either of the tables I previously described, the sequence 'Current value

[GENERAL] PostgreSQL 9.1 pg_dump setval() sets wrong value

'sequences are black boxes', but not much else turned up. Surely I don't have to maintain a separate sequence fix-up script to keep with my backups, do I? Thanks. -- Greg Donald -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] [OFFTOPIC] Typo3 + Postgresql anyone?

anyone know of a howto that explains what software I'll need for that, and where to get it? Does anyone here have experience with Typo3+Postgresql that he might want to share? Typo uses migrations, so it should be database agnostic. -- Greg Donald Zend Certified Engineer MySQL Core

[GENERAL] division by zero issue

the error? TIA.. -- Greg Donald http://gdconsultants.com/ http://destiney.com/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] division by zero issue

On Wed, 15 Sep 2004 12:55:24 -0400, Jean-Luc Lachance [EMAIL PROTECTED] wrote: Add : AND count(user_tasks.task_id) 0 in the where clause. I get the error: aggregates not allowed in WHERE clause -- Greg Donald http://gdconsultants.com/ http://destiney.com/ ---(end

Re: [GENERAL] Changed a column type from integer to varchar

? -- Greg Donald http://destiney.com/ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] postgres book

I'm thinking of getting this book and was wondering if anyone had anything bad (or good) to say about it? More than that I'd really like to know what version of Postgres it covers, the sample pages don't seem to say. http://tinyurl.com/5xtpp TIA.. -- Greg Donald http://destiney.com

Re: [GENERAL] import mysql database...

with mySQL to another server running with postgreSQL). Yes PHPBB has postgreSQL support. I found this utility very helpful in a similar situation: http://freshmeat.net/projects/my2pg/ -- Greg Donald ---(end of broadcast)--- TIP 1: subscribe

[GENERAL] syntax legal?

Is it legal syntax to use instead of != in a Postgres query? I didn't see it listed on: http://www.postgresql.org/docs/7.4/static/sql-syntax.html but wanted to ask to make sure. -- Greg Donald ---(end of broadcast)--- TIP 3: if posting

Re: [GENERAL] Gentoo for production DB server?

ACCEPT_KEYWORDS=~x86. I never used the command because I never _wanted_ unstable packages. Seems I got them anyway. -- Greg Donald ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Gentoo for production DB server?

server usage and such, I'd go with Debian. For features, desktop systems, etc., I'd go with Suse. 9.1 is impressive. For security, firewall, or router usage, I'd go with *BSD. -- Greg Donald ---(end of broadcast)--- TIP 2: you can get off all lists