Re: [GENERAL] Call for design: PostgreSQL mugs

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

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

[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] Problem installing PostgreSQL 9.0 via Macports on OS X Server 10.6

| +--+-+ | everyone |Read only| +--+-+ /Library/PostgreSQL/9.1/data +--+-+ | postgres | Read Write | +--+-+ | everyone |No Access| +--+-+ --Basil Bourque -- Sent

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

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 mailing list (pgsql-general@postgresql.org) To make changes to your

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

-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@postgresql.org) To make changes to your

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

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 working on a greenfield project, where: • I've built every table

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

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 table_make_history_() RETURNS trigger AS $BODY$ DECLARE metadata_record RECORD; /* http://www.postgresql.org/docs/current

Re: [GENERAL] SSDs with Postgresql?

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

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

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] UUID can be written to row when passed as parameter/argument to a PL/pgSQL function. Feature or bug?

-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-general@postgresql.org

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 plpgsql AS $function

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

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

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

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 is your database superuser password (used to connect to database

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

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+timeoutgroup=gmane.comp.lang.inug-4d.tech --Basil Bourque -- Sent via pgsql