[GENERAL] ERROR: invalid value "????" for "YYYY"

2013-10-08 Thread Brian Wong
I'm posting this question to pgsql-general. Hopefully someone can share some insights with me. I have a bunch of tables in the database and in a separate schema. The tables' names are in this format: ???_???_???_MMDD where the last 8 characters

Re: [GENERAL] ERROR: invalid value "????" for "YYYY"

2013-10-08 Thread Brian Wong
hema to be the one that I want. So those internal pg_* views shouldn't even show up in the query. Brian On Tue, Oct 8, 2013 at 1:50 PM, Brian Wong wrote: > I'm posting this question to > pgsql-general<http://www.postgresql.org/list/pgsql-general/>. > Hopefully someone

Re: [GENERAL] ERROR: invalid value "????" for "YYYY"

2013-10-09 Thread Brian Wong
extra data that's showing up is being added to the resultset cuz without the additional where clause, the result set did not contain any of those rows like pg_statistics/etc. Brian On Tue, Oct 8, 2013 at 4:10 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On 10/08/2

[GENERAL] ERROR: out of memory DETAIL: Failed on request of size ???

2013-11-18 Thread Brian Wong
We'd like to seek out your expertise on postgresql regarding this error that we're getting in an analytical database. Some specs: proc: Intel Xeon X5650 @ 2.67Ghz dual procs 6-core, hyperthreading on. memory: 48GB OS: Oracle Enterprise Linux 6.3postgresql version: 9.1.9 shared_buffers: 18GB We'

Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size ???

2013-11-22 Thread Brian Wong
load whatsoever. Unfortunately, the error doesn't say what kinda memory ran out. --- Original Message --- From: "bricklen" Sent: November 18, 2013 7:25 PM To: "Brian Wong" Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] ERROR: out of memory DETAIL: Failed on reque

Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size ???

2013-11-28 Thread Brian Wong
> Date: Fri, 22 Nov 2013 20:11:47 +0100 > Subject: Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size > ??? > From: t...@fuzzy.cz > To: bwon...@hotmail.com > CC: brick...@gmail.com; pgsql-general@postgresql.org > > On 19 Listopad 2013, 5:30, Brian Wong w

[GENERAL] DELETE with JOIN syntax

2005-07-27 Thread Brian Wong
I am currently migrating from MySQL to PostgreSQL and I have found that some queries do not work. For instance, DELETE t1 FROM t1 LEFT JOIN t2 USING (column_id) WHERE t2.column_id IS NULL; works in MySQL. This works as expected even though the MySQL documentation does not mention the option of ha

Re: [GENERAL] DELETE with JOIN syntax

2005-07-27 Thread Brian Wong
On 7/27/05, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > I think the where t2.column_id is null where column_id is the joining > column makes this a form of not exists, so maybe: > > DELETE FROM t1 WHERE NOT EXISTS (SELECT 1 FROM t2 WHERE t2.column_id = > t1.columnid); > > This looks good. Tha

Re: [GENERAL] how to select

2005-07-29 Thread Brian Wong
On 7/29/05, Jonathan Villa <[EMAIL PROTECTED]> wrote: > now I want to select > #select someColumn from testtable > > I get nothing... no output, nothing... Try terminating the statement with ';'? ---(end of broadcast)--- TIP 5: don't forget to incr

Re: [GENERAL] newbie - postgresql or mysql

2005-08-31 Thread Brian Wong
On 8/31/05, Frank <[EMAIL PROTECTED]> wrote: > I wanted to convert some apps over to use postgresql and cannot find > a good tool to import and auto create the tables. > MySQL syntax is not compatible with postgresql. > I get: > ERROR: syntax error at or near "`" at character 14 > from the MySQL o

Re: [GENERAL] ldap auth problem

2007-02-09 Thread Brian Wong
On 1/2/07, Ing. Dan Horáček <[EMAIL PROTECTED]> wrote: Hi, I've just installed postgres 8.2.0-1 for win32 and wanted to try out the built-in LDAP support(with Openldap and Novell eDirectory). The following LDAP authentication was added to "pg_hba.conf" : Openldap: host all al