Re: [GENERAL] timestamps, formatting, and internals

Jasen Betts wrote: On 2012-05-29, David Salisbury wrote: On 5/27/12 12:25 AM, Jasen Betts wrote: The query: "show integer_datetimes;" should return 'on' which means timestamps are microsecond precision if it returns 'off' your database was built with floating point timstamps and equality test

Re: [GENERAL] SELECT issue with references to different tables

Hi Alex, I think would be better to reorganise model to awoid NULLs i.e. to includ new table: owners -owner_id -owner_name -ownertype (person/comapny) and have yours person_details table... and comapny_details_table... related 1:1 to owner_id However, solution for your way I think would be:

Re: [GENERAL] Updateable Views or Synonyms.

> > what sorts of operations do synonyms need to support? > truncate? > alter table? > reindex? > I am no expert or anything but I would think they would be like symlinks so yes to all of the above. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

[GENERAL] evaluating subselect for each row

As part of anonymizing some data, I want to do something like: update foo set bar = (select bar2 from fakes order by random() limit 1); But of course, that sets them all to the same value, whereas I want them all different. -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/

[GENERAL] TYPE TABLE OF NUMBER

we are doing mgration activity form oracle to postgresql 9.1 How to convert this type : ORACLE : CREATE OR REPLACE TYPE "NUMBER_ARRAY" IS TABLE OF NUMBER please let me know how we can achive this in postgresql My understanding POSTGRESQL : CREATE TYPE "NUMBER_ARRAY" AS (arr int); Appre

Re: [GENERAL] evaluating subselect for each row

On Jun 3, 2012, at 10:55 AM, Scott Ribe wrote: > As part of anonymizing some data, I want to do something like: > > update foo set bar = (select bar2 from fakes order by random() limit 1); it may or may not be an option, but "update foo set bar=md5(bar)" is a pretty simple way to redact data. -

[GENERAL] RLS & SEpgsql

Hello, I have a question about row level security and SEpgsql. As far as I can tell the current state is that the leaky view problem is solved and some kind of security checking provider (implemented for SElinux) exists. Row level security seems to be an additional step. Is it planned for 9.3dev?

Re: [GENERAL] SELECT issue with references to different tables

Hi Misa, I have such a construct with kind of an auxiliary table that is only there to keep the current status. I made good experiences with it and the overhead of maintaining an additional table for a current status alongside a table for tracking a historical buildup is negligable and works pr

[GENERAL] [postgres no lnger launches

Hi, how do I troubleshoot postgres? It simply won't start any more. I cannot login, not locally nor remotely. I tried a couple of things without success. bash-3.2$ ps -Ac | egrep postgres bash-3.2$ /Library/PostgreSQL/9.1/bin/pg_ctl start -D /Library/PostgreSQL/9.1/data -l postgres.log pg_ctl:

Re: [GENERAL] [postgres no lnger launches

Btw, this is OSX 10.7. Am 04.06.2012 um 00:39 schrieb Alexander Reichstadt: > Hi, > > how do I troubleshoot postgres? It simply won't start any more. I cannot > login, not locally nor remotely. I tried a couple of things without success. > > bash-3.2$ ps -Ac | egrep postgres > bash-3.2$ /Libr

Re: [GENERAL] [postgres no lnger launches

Alexander Reichstadt writes: >> So sure enough that process claimed to might be starting does not end up >> being a process. Where do I look for what's actually going on? In the postmaster log ... >> This is the log output: >> 04.06.12 00:26:29,792 com.edb.launchd.postgresql-9.1:If the

[Solved] Re: [GENERAL] [postgres no lnger launches

I found the issue, I changed the connection amount. I changed it back now. Alex Am 04.06.2012 um 00:39 schrieb Alexander Reichstadt: > Hi, > > how do I troubleshoot postgres? It simply won't start any more. I cannot > login, not locally nor remotely. I tried a couple of things without success.

Re: [GENERAL] [postgres no lnger launches

Thanks, Tom, I messed it up myself, see my other post. Am 04.06.2012 um 01:16 schrieb Tom Lane: > Alexander Reichstadt writes: >>> So sure enough that process claimed to might be starting does not end up >>> being a process. Where do I look for what's actually going on? > > In the postmaster l

Re: [GENERAL] TYPE TABLE OF NUMBER

On Fri, Jun 1, 2012 at 9:18 PM, utsav wrote: > we are doing mgration activity form oracle to postgresql 9.1 > > How to convert this type : > > ORACLE : > > CREATE OR REPLACE TYPE "NUMBER_ARRAY" IS TABLE OF NUMBER > > please let me know how we can achive this in postgresql > > > My understanding

Re: [GENERAL] Question: How do you manage version control?

> -Ursprungligt meddelande- > Från: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] För Ralf Schuchardt > Skickat: den 1 juni 2012 18:24 > Till: pgsql-general > Ämne: Re: [GENERAL] Question: How do you manage version control? I was using a very simplisti