[SQL] BINARY and BINARY VARYING datatypes in PostgreSQL
I know that BIT and BIT VARYING types were deleted from SQL:2003 and there are "old new" BINARY, BINARY VARYING in SQL:2008. I have two question: 1) Are these types technically the same (I mean implementation things) ? 2) Is PostgreSQL aim to support BINARY, BINARY VARYING in 9.1 and leave BIT and BIT VARYING for backward compability (for example as aliases) ? "PostgreSQL supports most of the major features of SQL:2008. Out of 179 mandatory features required for full Core conformance, PostgreSQL conforms to at least 160. In addition, there is a long list of supported optional features. It might be worth noting that at the time of writing, no current version of any database management system claims full conformance to Core SQL:2008." from: http://developer.postgresql.org/pgdocs/postgres/features.html Regards, Grzegorz Szpetkowski -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] getting PSQLException Can't infer the SQL type to use with Native Query call
In trying to call a postgresql 8.4 stored function I am passing a class as well as a List (I have to save a master record as well as the detail records). This is being done with a native query using EclipseLink 2.1. However, I am getting back a message for the first item: PSQLException: Can't infer the SQL type to use for an instance of com.hwcs.veri.shared.dto.MyClass. Use setObject() with an explicit Types value to specify the type to use. I am calling the query setting up the parameter with: query.setParameter( 1, myClass ); The receiving stored function has the following: FUNCTION perform_schema.saveInfo( newrecboolean, myClass , myDtl [] ) I am unclear how to setup the pass fromm eclipselink to postgresql. Does anyone have any suggestions or can point to docs which speak to this specifically? Thanks -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] FATAL: invalid cache id: 19
Good morning !! How can I solve this problem : FATAL: invalid cache id: 19 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT LOG: startup process (PID 7444) exited with exit code 1 2011-05-01 21:28:32 CDT LOG: aborting startup due to startup process failure 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 22:53:11 CDT LOG: database system was shut down at 2011-05-01 20:18:46 CDT I tray to find the archive *pg_internal.init and clear this .*but I couldn find it. thnks
Re: [SQL] FATAL: invalid cache id: 19
manuel antonio ochoa writes: > How can I solve this problem : > FATAL: invalid cache id: 19 There was a bug with that symptom in 9.0.0 and 9.0.1 ... if you're running one of those versions, update. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] getting PSQLException Can't infer the SQL type to use with Native Query call
Steven Dahlin writes: > In trying to call a postgresql 8.4 stored function I am passing a > class as well as a List (I have to save a master record as well as the > detail records). This is being done with a native query using > EclipseLink 2.1. However, I am getting back a message for the first > item: > PSQLException: Can't infer the SQL type to use for an instance of > com.hwcs.veri.shared.dto.MyClass. Use setObject() with an explicit > Types value to specify the type to use. That looks like a complaint from JDBC, so possibly you'd have better luck asking on pgsql-jdbc. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] PLpgSQL variables persistance between several functions calls
Hello everybody ! I want to know if I could share PLpgSQL variables between different functions and within different calls just using memory (not tables or other methods). If it is really possible ? Thanks in advance, Chuck
Re: [SQL] PLpgSQL variables persistance between several functions calls
Hello no, it's not possible Regards Pavel Stehule 2011/5/2 Charles N. Charotti : > Hello everybody ! > > I want to know if I could share PLpgSQL variables between different > functions and within different calls just using memory (not tables or other > methods). > > If it is really possible ? > > Thanks in advance, > > Chuck > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
