Re: [GENERAL] ERROR: relation "employees" does not exist

2013-03-10 Thread Andreas Kretschmer
Csanyi Pal wrote: > Hi, > > I just installed Postgresql 9.2 on my Debian Wheezy system. > > I want to study and learn about new data type, the range type. > > I'm following the tutorial: > https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf > > but when I run the command: > CR

[GENERAL] ERROR: relation "employees" does not exist

2013-03-10 Thread Csanyi Pal
Hi, I just installed Postgresql 9.2 on my Debian Wheezy system. I want to study and learn about new data type, the range type. I'm following the tutorial: https://wiki.postgresql.org/images/7/73/Range-types-pgopen-2012.pdf but when I run the command: CREATE TABLE employee_schedule ( id serial

Re: [GENERAL] selecting for type cast failures

2013-03-10 Thread Adrian Klaver
On 03/07/2013 08:56 PM, David Johnston wrote: Adrian Klaver-3 wrote My opinion, it would take more time to concoct regexes that cover all the corner cases than to write a script that walks the through the data , finds the problem data and flags them. ISTM that using regular expressions is nece

Re: [GENERAL] table spaces

2013-03-10 Thread Scott Marlowe
On Sun, Mar 10, 2013 at 6:23 AM, Gregg Jaskiewicz wrote: > > > > On 10 March 2013 02:19, Scott Marlowe wrote: >> >> First get a baseline for how things work with just pg_xlog on one >> small set (RAID 1 is often plenty) and RAID-10 on all the rest with >> all the data (i.e. base directory) there.

Re: [GENERAL] table spaces

2013-03-10 Thread Gregg Jaskiewicz
On 10 March 2013 02:19, Scott Marlowe wrote: > > First get a baseline for how things work with just pg_xlog on one > small set (RAID 1 is often plenty) and RAID-10 on all the rest with > all the data (i.e. base directory) there. With a fast HW RAID > controller this is often just about as fast as

Re: [GENERAL] out of memory issue

2013-03-10 Thread Dmitriy Igrishin
04.03.2013 18:25 пользователь "Merlin Moncure" написал: > > On Sun, Mar 3, 2013 at 11:05 AM, G N wrote: > > Hello Friends, > > > > Hope you are all well... > > > > I have a specific issue, where my query fails with below error while trying > > to export data from pgadmin SQL tool. > > > > There