Re: [GENERAL] warning: libssl.so.4, needed by

On Fri, Aug 29, 2008 at 2:39 PM, J Welcomecert [EMAIL PROTECTED] wrote: make compilation errors removed It looks like you haven't openssl installed on your system, or you didn't provided the right switches for compiling it? Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ http

Re: [GENERAL] Postgresql RPM upgrade (8.2.3 - 8.2.9)

. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- 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] Advice on implementing counters in postgreSQL

On Sat, Aug 2, 2008 at 5:11 PM, David Fetter [EMAIL PROTECTED] wrote: On Sat, Aug 02, 2008 at 09:23:31AM +0200, Marco Bizzarri wrote: Hi all. I need to keep a numer of counters in my application; my counters are currently stored in a table: name | next_value | year The counters must

Re: [GENERAL] Advice on implementing counters in postgreSQL

by the initial UPDATE statement. Yes, I'm considering moving away from serializable; the problem is that I have to explore all the implications of this on my code. Up to now, I wrote considering a serializable level, so I think I should do quite a review to be sure about it. Regards Marco -- Marco

[GENERAL] Advice on implementing counters in postgreSQL

and redone from scratch. Is there a way to avoid this behaviour? maybe with lock to tables? Thanks you all for your attention Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Advice on implementing counters in postgreSQL

Ringer [EMAIL PROTECTED] wrote: Marco Bizzarri wrote: Hi all. I need to keep a numer of counters in my application; my counters are currently stored in a table: name | next_value | year The counters must be progressive numbers with no holes in between them, and they must restart from 1 every

Re: [GENERAL] Advice on implementing counters in postgreSQL

On Sat, Aug 2, 2008 at 11:04 AM, Craig Ringer [EMAIL PROTECTED] wrote: Marco Bizzarri wrote: Thanks for the advice, Craig. I'm on a number of different PostgreSQL versions, ranging from 7.4 to 8.3, so I've to retain, where possible, compatibility with older versions. Is this better

Re: [GENERAL] Temporary Tables and Web Application

to disk/read from disk? You could create a real table on disk, inserting just the primary keys of the table; then, you could join on the main table, to get the real results. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

an mydb_dump_$time.out file empty (of 0 kb) Do you have any idea about what's wrong? Thanks Sorin Hi Sorin, why don't you add a MAILTO=youraddress at the start of your crontab file, so that you can receive a report of the problem? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

of the pg_dump command in the script. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

On Nov 22, 2007 2:53 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote: why don't you add a MAILTO=youraddress at the start of your crontab file, so that you can receive a report of the problem? Note: check that your cron accepts

Re: [GENERAL] computing and updating the size of a table with large objects

and storage: http://www.manitou-mail.org Thanks a lot for the suggestion: I didn't think to use the pg_largeobject: much cleaner, now :-) Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 4: Have you

[GENERAL] computing and updating the size of a table with large objects

descriptor for all the query. Does anyone has any other suggestion? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [GENERAL] permission in the db or in the application?

of the application. If you have time (and money) take a look at Chapter 20 from Agile Database Techniques from Scott Ambler: it examines a number of possibilities which could be worthy to you. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast

Re: [GENERAL] basic SQL request

You wrote articletype instead of articletypes in the first WHERE clause: is this the problem? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [GENERAL] Storing images in PostgreSQL databases (again)

also in how the space is reclaimed, but my PostgreSQL - Fu stops here. Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

On 9/11/06, Purusothaman A [EMAIL PROTECTED] wrote: Hi Marco Bizzarri and Martijn van Oosterhout, Thanks for your valuable reply. I am trying to execute all query from VC++ through CDatabase::ExecuteSQL(sQueryString) function call. ie, via programming, not by manual entering query statements

Re: [GENERAL] Database migration and redesign

dissemination, distribution or copying of this email is prohibited. If you have received this email in error, please notify the sender by replying to this message and deleting this email immediately. -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

: GnuPG v1.4.1 (GNU/Linux) iD8DBQFFBS6LIB7bNG8LQkwRAvI6AJ9OW7cxZiJR0QsEsSOwkYHKkYDZ6gCbBrDA GVPAoBeOhE+2toFa2zNbN3M= =9W8I -END PGP SIGNATURE- -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 1

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

-- 0 (1 row) (you closed the file). commit ; COMMIT In this way, you created a new large object, and stored a string of 4 bytes inside of it. Regards Marco On 9/11/06, Purusothaman A [EMAIL PROTECTED] wrote: Thanks Martijn van Oosterhout and Marco Bizzarri. But, according to syntax of client

Re: [GENERAL] Consulta

analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. MailScanner agradece a transtec Computers por su apoyo. -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 4

Re: [GENERAL] logic/db question

...) of a top level item? i had done this awhile ago.. but can't recall how i did it.. thanks ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end

[GENERAL] Clustering and backup with large objects

, rather than availability. Thanks for your attention. Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Fwd: [GENERAL] Long term database archival

-- Forwarded message -- From: Marco Bizzarri [EMAIL PROTECTED] Date: Jul 12, 2006 9:03 PM Subject: Re: [GENERAL] Long term database archival To: Karl O. Pinc [EMAIL PROTECTED] Long term archival of electronic data is a BIG problem in the archivist community. I remember, a few

Re: [GENERAL] Dumping in LATIN1 and restoring in UTF-8

On 7/6/06, Tino Wildenhain [EMAIL PROTECTED] wrote: Marco Bizzarri schrieb: Hi all. Here is my use case: I've an application which uses PostgreSQL as backend. Up to now, the database was encoded in SQL_ASCII or LATIN1. Now, we need to migrate to UTF-8. What we tried, was to: 1) dump

Re: [GENERAL] Dumping in LATIN1 and restoring in UTF-8

understand postgresql in later release became much more picky about encoding. (The changing of the client_enccoding setting in the backup is only needed in the case when you had data in the wrong encoding - like SQLAscii filled with latin-1 or something) Ok, thanks! Regards Marco -- Marco

[GENERAL] Dumping in LATIN1 and restoring in UTF-8

it worked for us, I wonder if there is any other way to accomplish the same result, at least to specify the encoding for the restore. Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0

[GENERAL] Documentation of the Front End/Back End Protocol for Large Objects

in client (libpq, I suppose)? Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Documentation of the Front End/Back End Protocol for Large Objects

Hi Tom. Thanks for your suggestion, this was my choice, after I was unable to find any reference. On 6/23/06, Tom Lane [EMAIL PROTECTED] wrote: Marco Bizzarri [EMAIL PROTECTED] writes: I would like to study the protocol for large object operations (lo_read, lo_write,...) between the front

Re: [GENERAL] Changing encoding of a database

Hi Tomi. Thanks for your answer, I was not aware of such a tool. The next question at this point is (of course): what is the problem if I have blob? Should I recode them as well? Regards Marco On 6/20/06, Tomi NA [EMAIL PROTECTED] wrote: On 6/19/06, Marco Bizzarri [EMAIL PROTECTED] wrote: I

[GENERAL] Changing encoding of a database

I all. We've PostgreSQL database, with SQL_ASCII or LATIN1 encoding. We would like to migrate them to UNICODE. Is there some contributed/available script, or this is something we should do at hand? Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com

Re: [GENERAL] MySQL insert() and instr() equiv

there is an answer in the list archives somewhere but my first few searches brought up nothing useful. --markc ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Marco

[GENERAL] Questions about the use of largeobject functions from inside SQL

Hi all. We have a setup with Zope and a remote Postgresql server. We're storing blobs in largeobject files. What we need to do is to be able to do the transfer of blobs between Zope and postgres. I thought it was possible to use lo_* functions, by creating a largeobject, and then sending the

Re: [GENERAL] Certifications in military environment

Jeff Eckermann wrote: --- Marco Bizzarri [EMAIL PROTECTED] wrote: Hi all. I would like to know if postgresql has any certification for the military environment. There are no official certifications, nor are there likely to be. But certifications may be offered by individual companies, like Red

[GENERAL] Certifications in military environment

Hi all. I would like to know if postgresql has any certification for the military environment. If possible, please answer me directly (I'm not on this mailing list). Otherwise, I will read from the web interface. Regards Marco ---(end of