Re: [GENERAL] FATAL: the database system is starting up

fluxh wrote > I have the same problem. I have a log like patrick keshishian. I have not > a backup. > > I don't know that do. > > Help me please!!! > > Information: > > - Server with RAID1 on SAS HD Hot-plug. > - Ubuntu Server 12.04 x64. > - Postgresql 9.1. > > When I do "psql" PostgreSQL show

Re: [GENERAL] libpq - lack of support to set the fetch size

On Mar 12, 2014, at 5:57 AM, matshyeq wrote: > I don't see why? I can't think of any single SQL tool I've been working with > that didn't have this functionality, really. > The principle I find very simple and useful. > There is defined "fetch row size" parameter (each tool calls give its own

Re: [GENERAL] After paying PG Associate Cert. Exam what's the next step?

On 03/12/2014 04:13 PM, Oscar Calderon wrote: Hi there, have a nice day. Well, as the subject says, today i paid for the right to take the PostgreSQL Associate Certification Exam once in enterprisedb.com website, i received the confirmation email and everything's fine. B

Re: [GENERAL] named queries and the wire protocol

David Welton writes: >> send(State, ?BIND, ["", 0, StatementName, 0, Bin1, Bin2]), >> send(State, ?EXECUTE, ["", 0, <<0:?int32>>]), >> send(State, ?CLOSE, [?PREPARED_STATEMENT, StatementName, 0]), >> send(State, ?SYNC, []), > And then the code above. So it's generating a name itself and then > d

[GENERAL] After paying PG Associate Cert. Exam what's the next step?

Hi there, have a nice day. Well, as the subject says, today i paid for the right to take the PostgreSQL Associate Certification Exam once in enterprisedb.com website, i received the confirmation email and everything's fine. But after that, i don't know what's next, the email that i received is just

Re: [GENERAL] avoiding file system caching of a table

On Mon, Feb 17, 2014 at 7:30 PM, Gabriel Sánchez Martínez < gabrielesanc...@gmail.com> wrote: > > On 02/17/2014 08:45 PM, Jeff Janes wrote: > > On Mon, Feb 17, 2014 at 5:09 PM, "Gabriel E. Sánchez Martínez" < > gabrielesanc...@gmail.com> wrote: > >> >> >> I have read forum postings saying that t

Re: [GENERAL] named queries and the wire protocol

Hi, > David Welton writes: >> Specifically, I'm wondering how this code behaves in the case that the >> Execute runs into trouble: > >> https://github.com/epgsql/epgsql/blob/0e84176be4b54fb712d1cc227a2b91c24b7a66ab/src/pgsql_sock.erl#L199 > > I guess you mean this: Yes > command({equery, Statem

Re: [GENERAL] debugging functions

Hello I don't know any tool that can do what you want. You can write your function as fault tolerant - you can trap errors, and you can print a some messages. That is all what is possible Regards Pavel 2014-03-12 20:29 GMT+01:00 Seb : > Hi, > > I am aware of the edb-debugger that one can use

[GENERAL] debugging functions

Hi, I am aware of the edb-debugger that one can use with pgadmin for debugging functions. However, I am looking for a solution that doesn't involve such additions to the server. I'm using a function in a SELECT query, but it's failing for some rows in a very large table. By using LIMIT and OFFS

Re: [GENERAL] High Level Committers Wanted

On 3/12/2014 8:19 AM, bobJobS wrote: What we need is a meeting/training session with the main contributors to Postgres to help facilitate solutions of some of the Oracle functionality to Postgres. This may be an opportunity to gather Government requirements for additional Postgres releases. The m

Re: [GENERAL] Cannot insert to 'path' field using EclipseLink

On 03/12/2014 11:12 AM, Daryl Foster wrote: I've manually entered some data into table to see if I could successfully pull data from the table using EclipseLink. Now the convertDataValueToObjectValue method in my Converter throws the following exception: java.lang.ClassCastException: org.post

Re: [GENERAL] [JDBC] Cannot insert to 'path' field using EclipseLink

> On Mar 12, 2014, at 10:12 AM, Daryl Foster wrote: > > java.lang.ClassCastException: org.postgresql.geometric.PGpath cannot be cast > to org.postgresql.geometric.PGpath > That's a sure sign of ClassLoader confusion. Make sure there is only one copy of the driver jar in your application or

Re: [GENERAL] Cannot insert to 'path' field using EclipseLink

I've manually entered some data into table to see if I could successfully pull data from the table using EclipseLink. Now the convertDataValueToObjectValue method in my Converter throws the following exception: java.lang.ClassCastException: org.postgresql.geometric.PGpath cannot be cast to org.pos

Re: [GENERAL] High Level Committers Wanted

Understood and I agree. I will check to see how much contact detail I can divulge in an open forum. -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-Level-Committers-Wanted-tp5795695p5795729.html Sent from the PostgreSQL - general mailing list archive at Nabble.com

Re: [GENERAL] High Level Committers Wanted

On 03/12/2014 09:43 AM, bobJobS wrote: Your professional input is greatly appreciated. My guess is you will get more assistance if you are more forthcoming with information. There is also the issue of your email address, *@yahoo.com is sort of generic to be charitable. At the moment all we k

Re: [GENERAL] High Level Committers Wanted

Your professional input is greatly appreciated. -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-Level-Committers-Wanted-tp5795695p5795720.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-ge

Re: [GENERAL] High Level Committers Wanted

Two valid questions. 1. Columbia, Maryland 2. US Government Attending PGCon does make sense, however I was asked specifically to see if I could get someone for an onsite meeting. -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-Level-Committers-Wanted-tp5795695p579

Re: [GENERAL] High Level Committers Wanted

On 03/12/2014 08:48 AM, Gary Chambers wrote: Columbia the country or the District? There's also the river... And South Carolina... Alright, I am going to go with the answer from Magnus: ".. in the Columbia area (any of them).. -- G. -- Adrian Klaver adrian.kla...@aklaver.com -- S

Re: [GENERAL] High Level Committers Wanted

On 3/12/2014 9:49 AM, alexandros_e wrote: It seems like spam to me. Where is the guy's name or credentials? If I would request something, I would sign with my name, government email and telephone. Or it is a 20-day-early April 1 email. -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] High Level Committers Wanted

On 03/12/2014 08:38 AM, David Boreham wrote: On 3/12/2014 9:34 AM, Adrian Klaver wrote: Columbia the country or the District? There's also the river... Yea, and here me living in Washington State. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing lis

Re: [GENERAL] High Level Committers Wanted

It seems like spam to me. Where is the guy's name or credentials? If I would request something, I would sign with my name, government email and telephone. -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-Level-Committers-Wanted-tp5795695p5795703.html Sent from the P

Re: [GENERAL] High Level Committers Wanted

Columbia the country or the District? There's also the river... And South Carolina... -- G. -- 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] High Level Committers Wanted

On 3/12/2014 9:34 AM, Adrian Klaver wrote: Columbia the country or the District? There's also the river... -- 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] High Level Committers Wanted

On 03/12/2014 08:19 AM, bobJobS wrote: I am currently working for the Government and there is a huge push to move our Oracle databases to a FOSS database solution. Right now, PostgreSQL is high on the list. What Government? What we need is a meeting/training session with the main contributor

Re: [GENERAL] High Level Committers Wanted

On Wed, Mar 12, 2014 at 4:19 PM, bobJobS wrote: > I am currently working for the Government and there is a huge push to move > our Oracle databases to a FOSS database solution. Right now, PostgreSQL is > high on the list. > > What we need is a meeting/training session with the main contributors t

Re: [GENERAL] named queries and the wire protocol

David Welton writes: > Specifically, I'm wondering how this code behaves in the case that the > Execute runs into trouble: > https://github.com/epgsql/epgsql/blob/0e84176be4b54fb712d1cc227a2b91c24b7a66ab/src/pgsql_sock.erl#L199 I guess you mean this: command({equery, Statement, Parameters}, Sta

[GENERAL] High Level Committers Wanted

I am currently working for the Government and there is a huge push to move our Oracle databases to a FOSS database solution. Right now, PostgreSQL is high on the list. What we need is a meeting/training session with the main contributors to Postgres to help facilitate solutions of some of the Orac

Re: [GENERAL] libpq - lack of support to set the fetch size

On 03/12/2014 06:05 AM, matshyeq wrote: Don't fully agree with last statement. FETCH is WAY better and more functional than LIMIT. PQsetSingleRowMode() is not meant for partial resultsets, but it can be used if you accept the downsides. Given the 'discretion mode' I'm still not

Re: [GENERAL] Materialized view from PG to Oracle?

2014-03-12 12:00 GMT+09:00 Roy Anderson : > Good day. We are transitioning over one database to Postgres as a test but > retain an Oracle presence. The PG db in question is (it is currently still > running Oracle) feeds a couple other Oracle dbs via materialized view logs > and materialized views.

Re: [GENERAL] libpq - lack of support to set the fetch size

On Wed, Mar 12, 2014 at 9:30 AM, Marko Kreen wrote: > On Tue, Mar 11, 2014 at 12:39:12PM +, matshyeq wrote: > > - when using PQsetSingleRowMode() function - does it give an option to > > define how many rows to cache on client's side (like JDBC setFetchSize() > > does) or leaves it at pqli

Re: [GENERAL] libpq - lack of support to set the fetch size

> > > Well, I don't know what "streamed" exactly means here. > > If server pushes sequentially all the data not asking client if ready > to > > receive then that's what the issue is about. > > This problem is handled in kernel's TCP stack - it will slow down > the connection if userspace does not

[GENERAL] Materialized view from PG to Oracle?

Good day. We are transitioning over one database to Postgres as a test but retain an Oracle presence. The PG db in question is (it is currently still running Oracle) feeds a couple other Oracle dbs via materialized view logs and materialized views. Is it possible to achieve the same MV functionalit

[GENERAL] named queries and the wire protocol

Hello, I sort of volunteered for work on an Erlang Postgres driver, here: https://github.com/epgsql/epgsql And one thing I was looking into was a patch regarding the cleanup of named queries. Specifically, I'm wondering how this code behaves in the case that the Execute runs into trouble: http

Re: [GENERAL] New here: trouble getting postgres 9.3 running as service on windows 8.1

Malik Rumi escribió: Hello list, > I overcame the first errors I got about the TEMP environmental variable > thanks to the info on the wiki. Then I got two warnings after install. 1) > is that the adminpack did not install, and it asked if I was listening on > the port. 2) was that I needed to c

[GENERAL] Cannot insert to 'path' field using EclipseLink

I have a java app running in JBoss that uses EclipseLink to persist to a Postgres database. I've added a field with a 'path' datatype to one of the tables but I keep getting the following exception when I try to insert data: org.postgresql.util.PSQLException: Can't infer the SQL type to use for an

Re: [GENERAL] libpq - lack of support to set the fetch size

On Wed, Mar 12, 2014 at 10:57:03AM +, matshyeq wrote: > On Wed, Mar 12, 2014 at 9:30 AM, Marko Kreen wrote: > > This option would not make sense as you are not "fetching" anything, > > full resultset is being streamed from server over TCP connection. > > Well, I don't know what "streamed" exa

Re: [GENERAL] libpq - lack of support to set the fetch size

On Tue, Mar 11, 2014 at 12:39:12PM +, matshyeq wrote: > - when using PQsetSingleRowMode() function - does it give an option to > define how many rows to cache on client's side (like JDBC setFetchSize() > does) or leaves it at pqlib's discretion? This option would not make sense as you are not

Re: [GENERAL] Plan rows - 1 or many

On 2014-03-12 09:28, Albe Laurenz wrote: Peter Mogensen wrote: I have an application where I would really like to be able to look at en SQL query and answer the question: "Is this query capable of returning more than 1 row?" Can I conclude that when plan_rows is 1 then there will never be mo

Re: [GENERAL] Plan rows - 1 or many

Peter Mogensen wrote: > I have an application where I would really like to be able to look at en > SQL query and answer the question: > > "Is this query capable of returning more than 1 row?" > Can I conclude that when plan_rows is 1 then there will never be more > than 1 row returned by the quer

[GENERAL] Plan rows - 1 or many

Hi, I have an application where I would really like to be able to look at en SQL query and answer the question: "Is this query capable of returning more than 1 row?" So basically, queries are divided into 2 categories. Those that look up a single row (if it exists) and those who return a (po