Re: [GENERAL] pgAdmin on Mac connecting to Postgres 9 on Linux - SSL/timeout issue

> > Anyone run into this before? Thanks! I don't know about pgAdmin or SSL, but I have heard that routers and switches can have a timeout limit: "the idle time after which an established connection of any protocol closes". http://search.gmane.org/?query=router+timeou

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

assword to connect to the database server as that 'postgres' user. --Basil Bourque On Feb 13, 2011, at 10:46, Sachin Srivastava wrote: > The postgres account created on your OS is locked account (without any > password) for security reasons. The password asked during installation i

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

nally posted that you are upgrading from Postgres 8.4.x to Postgres 9.0.x. I can't speak to that. But I can say: in upgrading between minor versions of 9.0.x, the 'postgres' user's password definitely does *not* change. --Basil Bourque -- Sent via pgsql-general mailing li

Re: [GENERAL] Call for design: PostgreSQL mugs

ded see the elephant head and "PostgreSQL". The right-handed see "The world's most advanced open source database.". --Basil Bourque

[GENERAL] UUID can be written to row when passed as parameter/argument to a PL/pgSQL function. Feature or bug?

128121E76570'); Note the success of this workaround. My blog post on this issue: http://crafted-software.blogspot.com/2011/04/passing-uuid-value-to-function-in.html --Basil Bourque -- 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] UUID can be written to row when passed as parameter/argument to a PL/pgSQL function. Feature or bug?

Whoops… Typo in the Subject line. Should have been "UUID cannot" rather than "UUID can". UUID cannot be written to row when passed as parameter/argument to a PL/pgSQL function. Feature or bug? ^^^ --Basil Bourque -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] UUID can be written to row when passed as parameter/argument to a PL/pgSQL function. Feature or bug?

Thanks for the suggestion of casting the hex string to uuid. That works. I tried the standard syntax using "CAST": VALUES ( CAST( $1 AS uuid) ) --Basil Bourque > How about: > CREATE OR REPLACE FUNCTION public.uuid_write_(character varying) > RETURNS boolean > LANGUAGE

[GENERAL] Can a nested function determine it is being called within a trigger?

tell if it is being run in a trigger? Trigger --> Function_A --> Function_B --Basil Bourque -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)

ta types by querying the meta-data tables (pg_attribute, pg_class, pg_type). But I cannot get "NEW." || colNameVar to be interpreted. Perhaps there is a better approach. If anyone is curious, my source code is pasted below. --Basil Bourque CREATE OR REPLACE FUNCTION

Re: [GENERAL] SSDs with Postgresql?

. An internal board with flash saves on all three, compared to a RAID made of either discs or SSDs. --Basil Bourque -- 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] "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records)

SQL interpreter. Brilliant! It works, and it seems to be fast enough, at least for my needs. I'll share my current code & table structure below. Caveat: This code has not yet been thoroughly tested, nor has it been deployed. I only finalized it today. --Basil Bourque [A] I'm

[GENERAL] Installing "uuid-ossp" library in Postgres 9.1. (new Extension feature)

post on this topic: http://crafted-software.blogspot.com/2011/10/extensions-in-postgres.html To install this library in versions of Postgres before 9.1: http://crafted-software.blogspot.com/2011/10/using-uuid-library-in-postgres.html --Basil Bourque -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] is there a function in postgresql that can be used for retrieving deleted rows

Another idea: On some tables in some databases, I never delete records. I have a boolean column that marks if a row is in the imaginary garbage can, and thereafter ignored in all queries. Any true deletes can therefore trigger a "Red Alert". --Basil Bourque -- Sent via pgsql-general

Re: [GENERAL] Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6

d & Write | +--+-+ |daemon|Read only| +--+-+ | everyone |Read only| +--+-+ /Library/PostgreSQL/9.1/data +--+-+ | postgres | Read & Write | +--+-----+

[GENERAL] Cannot find installers for 9.2 Beta

ones, but I don’t see any. Can someone point me in the right direction? —Basil Bourque -- 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] Cannot find installers for 9.2 Beta

FYI… Link for documentation: http://www.postgresql.org/docs/9.2/static/index.html Thanks for the links in the other messages of this thread. Worked for me. —Basil Bourque -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http