Re: [GENERAL] a JOIN to a VIEW seems slow

On Monday, October 2, 2017 2:32:34 AM EDT Frank Millman wrote: > From: Frank Millman > Sent: Friday, September 22, 2017 7:34 AM > To: pgsql-general@postgresql.org > Subject: Re: a JOIN to a VIEW seems slow > > On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote: > > On Thu, Sep 21, 2017 at 3:54

Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1

On Sunday, June 25, 2017 11:02:41 PM EDT Alain Toussaint wrote: > > Narrowing down the entire file to a small problem region and posting a > > self-contained example, > > The url here contain the set of xml records from a publication I > worked on many years ago: > >

Re: [GENERAL] Extract from text id other table - PG 9.1

On Tuesday, June 6, 2017 10:32:16 PM EDT Patrick B wrote: > Hi guys, > > I've got tableA with 3 columns. > > id(seriaL) | type(character varying(256)) | string(character varying(256)) > > I have the type/string value stored in another table, and from that i would > like to get the id. > >

Re: [GENERAL] Upgrading postgresql minor version

On Wednesday, May 10, 2017 9:08:16 AM EDT Ron Ben wrote: > Ron, You need to figure out how you can make your email client send something else than base64 encoded HTML with right-aligned text. Your messages are so hard to parse for me I just ignore them, and I assume there's other people

Re: [GENERAL] Postgres connection Monitor

On Thu, Apr 27, 2017 at 6:18 AM, basti wrote: > Hallo, we have a Postgres database Server and around that there are 8 > clients get data from it. > > All servers are the the same datacenter i think (traceroute only 4-5 hops) > > Now we plan to move the server to an

Re: [GENERAL] UDP buffer drops / statistics collector

On Thursday, April 20, 2017 3:38:42 AM EDT Tim Kane wrote: > The pgss_query_texts.stat still wants to live in the default *pg_stat_tmp* > directory, wether by design or not.. but that's a non-issue for me now. A 30 second investigation of the source seems to indicate that that directory is

Re: [GENERAL] Build PostGIS In Windows Using --with-gdalconfig=FILE

On Tuesday, April 11, 2017 5:43:29 AM EDT Osahon Oduware wrote: > Hi, > > I am using Windows 7 OS and I have installed a GDAL with support for MrSID > format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to > point to this new GDAL. > > How do I accomplish this in a Windows OS?

Re: [GENERAL] Fwd: Query parameter types not recognized

On Friday, February 10, 2017 6:46:08 PM EST David G. Johnston wrote: > In short - this is the wrong list (pgsql-j...@postgresql.org is the > appropriate one; or the official GitHub repo) and you need to provide some > working self-contained examples showing exactly what you are doing.​​ > > On

Re: [GENERAL] Slow index scan - Pgsql 9.2

> > Hi guys, > > I've got the following Query: > > WITH > >query_p AS ( > >SELECT CAST(6667176 AS > BIGINT) AS client_id), > > > > > clients AS ( > >SELECT >

Re: [GENERAL] postgres pg_bulkload c filter function in c programming

On Thursday, December 29, 2016 5:10:08 AM EST rajmhn wrote: > Gurus, > > Reading the data from file and loading it using pg_bulkload- C filter. As > per documentation, C filter is much faster than SQL filter. > > I'm new to C. Gone through this documentation. Not clear, how to start. >

Re: [GENERAL] Performance PLV8 vs PLPGSQL

On Wednesday, December 28, 2016 6:02:51 AM EST Mike Sofen wrote: > the natural lashup of plpgsql to postgres (I liked Alban’s term, > “impedance”), is a key aspect. Not to deprive Alban of any of his credit, but the term "impedance mismatch" is at least 25 year old; as far as I know it was

Re: [GENERAL] pg_dump and quoted identifiers

On Thursday, December 15, 2016 5:15:44 PM EST Thomas Kellerer wrote: > Tom Lane schrieb am 15.12.2016 um 16:20: > >> Still doesn't work: > >> -bash-4.1$ pg_dump -d postgres -t "\"Statuses\"" > >> pg_dump: no matching tables were found > > > > Hmm. It might shed some light if you put "echo"

Re: [GENERAL] Query regarding deadlock

On 2016-11-24 9:06 PM, Yogesh Sharma wrote: Dear John, Thanks for your support. I mean to say, the REINDEX calls hourly and insert query executes every minute to update. So, it might be race condition that these queries can call at same time. Why do you need to run REINDEX every hour? That

Re: [GENERAL] import_bytea function

On 2016-10-08 2:36 AM, Stephen Davies wrote: On 07/10/16 19:24, Thomas Kellerer wrote: Stephen Davies schrieb am 07.10.2016 um 10:46: You can store the contents of a file in a bytea using plain JDBC no lo_import() required String sql = "insert into images (id, image_data) values

Re: [GENERAL] Chante domain type - Postgres 9.2

On 2016-09-26 1:15 AM, Gavin Flower wrote: On 26/09/16 17:58, Patrick B wrote: Hi guys, I've got this domain: CREATE DOMAIN public.a_city AS character varying(80) COLLATE pg_catalog."default"; And I need to increase the type from character varying(80) to character

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

gs. > raghu=# > > On Thu, Jun 16, 2016 at 8:51 PM, Jan de Visser <j...@de-visser.net> wrote: > > Please don't top-post. > > > > On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote: > > > hi > > > sir > > > as per above discus

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

Please don't top-post. On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote: > hi > sir > as per above discussion same error repeated even mentioned ip address of > hostname > > ./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly > -allTables dbo > > >

Re: [GENERAL] Changelog version from 8.1.2 to 9.3.6

Please don't top post. On Thursday, June 16, 2016 3:42:53 AM EDT Yogesh Sharma wrote: > Dear David sir/All, > > Thanks for your help. > Just wanted to confirm few things. > > (9.3.5,9.2.9,9.1.14,9.0.18,8.4.22) Fix REASSIGN OWNED to not fail for text > search objects (Álvaro Herrera) > As per

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 9:07:10 PM EDT Alexander Farber wrote: > I only understand a quarter of what you guys are writing, > but to me the JDBC driver throwing SQLException > "A result was returned when none was expected" > when my stored function is declared as "void" with > > CREATE OR

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote: > On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser <j...@de-visser.net> wrote: > > Point is that you're doing a SELECT. A SELECT returns a result, which can > > be > > empty. I would use execute

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote: > On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser <j...@de-visser.net> wrote: > > Point is that you're doing a SELECT. A SELECT returns a result, which can > > be > > empty. I would use execute

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 4:21:47 PM EDT Alexander Farber wrote: > Hello Jan, > > On Wed, Jun 15, 2016 at 4:17 PM, Jan de Visser <j...@de-visser.net> wrote: > > On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote: > > > Now I am trying to call the sam

Re: [GENERAL] Moving from PHP to Java: A result was returned when none was expected.

On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote: > Now I am trying to call the same function through JDBC driver 9.4.1208.jre7: > > private static final String SQL_SKIP_GAME = > "SELECT words_skip_game(?, ?)"; > > try (PreparedStatement st = >

Re: [GENERAL] postgresql embedded mode

On Monday, May 23, 2016 1:17:13 PM EDT Albe Laurenz wrote: > David G. Johnston wrote: > > > On Mon, May 23, 2016 at 6:54 AM, aluka raju > > wrote: > > >> As given in the FAQ's that postgresql cannot be embedded > >>

Re: [GENERAL] postgresql-9.5.3 compilation on Solaris SPARC

On Friday, May 20, 2016 3:14:54 PM EDT Venkata Balaji N wrote: > Hi, > > "make" command is generating the following error while compiling > postgresql-9.5.3 on Solaris SPARC. > > I tried compiling 9.2 and 9.3, works fine. This is only happening on 9.5. ... snip ... > > Regards, > Venkata B N

Re: [GENERAL] Ascii Elephant for text based protocols - Final

On Tuesday, May 17, 2016 9:41:51 AM EDT Bryan Nuse wrote: > On 05/17/2016 08:25 AM, Victor Yegorov wrote: > > I had a bit of fun with this SQL version and came up with this query: > > > > WITH src(s) AS ( > > > > VALUES > > > >

Re: [GENERAL] index on ILIKE/LIKE - PostgreSQL 9.2

On Wed, May 11, 2016 at 10:03 PM, Lucas Possamai wrote: > >>> >> Trying redoing the query with CTE as below: >> >> WITH ja_jobs as >> (SELECT DISTINCT title >> FROM ja_jobs >> WHERE clientid = 31239 AND time_job > 1457826264 >> ) >> SELECT title >> FROM

Re: [GENERAL] Add relcreated (timestamp) column to pg_class catalog to record the time an object was created

On Thursday, April 21, 2016 12:55:00 PM EDT Melvin Davidson wrote: > WHY am I being vilified for making a simple request? How is it that > developers proceed with other enhancements, yet so much negative attention > is being given to my request because of unjustified fear that something bad > will

Re: [GENERAL] $foo $bar is BAD

On Friday, April 15, 2016 8:13:56 PM EDT Melvin Davidson wrote: > *Thanks for the sympathetic feedback John. I understand people are > reluctant to change. It was just my intent to enlighten others as to the > true background behind it.* > *So if it's not about to change, then I'll just have to

Re: [GENERAL] Crypt change in 9.4.5

On Friday, March 18, 2016 1:18:01 PM EDT ando...@aule.net wrote: > Hi, > > After upgrading to PostgreSQL 9.4.6, our test system gave error messages > like: > > ERROR: invalid salt > > The cause of these errors is statements like: > > WHERE password = crypt('secret', 'secret') > >

Re: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

On March 8, 2016 03:00:14 PM da...@andl.org wrote: > At the moment I have two pressing problems. > > One is the start-up phase: getting the Andl runtime stoked up, load its > catalog, set up its execution environment (including its own type system), > ready for business. That process in Postgres

Re: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

On March 8, 2016 11:35:00 AM da...@andl.org wrote: > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce > > this stuff you're loading from the database once, that's just data about > your language plugin's configuration, or is it user

Re: [GENERAL] Does a call to a language handler provide a context/session, and somewhere to keep session data?

On March 8, 2016 12:18:08 AM da...@andl.org wrote: > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce > > > > Yes, I was aware of GD and SD. My question is about what facilities Postgres > provides for implementing such a thing.

Re: [GENERAL] Charging for PostgreSQL

[offtopic alert] On 2016-01-06 12:46 PM, James Keener wrote: How does one "start a new thread"? 'New Message' in your favourite email client. 'pgsql-general@postgresql.org' in the 'To' box. I wasn't aware that changing the subject wouldn't be enough. I tried :/ Check the raw source of the

Re: [GENERAL] Old source code needed

On 2015-11-27 4:31 AM, NTPT wrote: Thanx for help, I grab the source code that match old cluster fs backup. However: Should it run fine compiled with recent gcc 4.9.3 ? You realize how old 9.0 is, right? And you understand how nonsensical your question is? How can you guarantee that

Re: [GENERAL] Old source code needed

On 2015-11-27 9:44 AM, Adrian Klaver wrote: You realize how old 9.0 is, right? And you understand how nonsensical your question is? How can you guarantee that code compiles properly on a compiler which is released years after you write the code? To me nonsensical would be trying to compile

Re: [GENERAL] Ubuntu installed postgresql password failure

On September 14, 2015 07:22:58 AM Martín Marqués wrote: > I would recommend using psql's \password meta- command instead of ALTER > USER to change a password, as to avoid having the password stamped in > the logs. You learn something new every day :-) jan

Re: [GENERAL] Ubuntu installed postgresql password failure

On September 14, 2015 07:22:58 AM Martín Marqués wrote: > I would recommend using psql's \password meta- command instead of ALTER > USER to change a password, as to avoid having the password stamped in > the logs. You learn something new every day :-) jan

Re: [GENERAL] Ubuntu installed postgresql password failure

On September 13, 2015 03:57:51 PM Dale Seaburg wrote: > I have reached my wit's end. lol I installed postgresql (9.3.9) and > pgadmin3 with the Ubuntu Software Center. When using pgadmin or psql, I > get an error "password authentication failed for user "postgres" ". > Ubuntu (14.04.3). > > I

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote: On 2015-07-05 15:13 Jan de Visser j...@de-visser.net wrote: You could set up a whole new server with a different $PGDATA on a different port. I (and the user) don't want to setup anything - that is the point. Well, you don't have

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On July 5, 2015 08:58:17 PM c.bu...@posteo.jp wrote: On 2015-07-05 15:11 Charles Clavadetscher clavadetsc...@swisspug.org wrote: I am not really an expert, but from your description I guess that you assume an existing PostgreSQL installation on your customers' server. The application is

Re: [GENERAL] Ubuntu 14.04 LTS install problem

On July 1, 2015 07:39:59 AM Urs Berner wrote: I installed Ubuntu 14.04 LTS apg-get update ... apt-get upgrade ... and looked at www.postgresql.org/download/linux/ubuntu then added apt repository /etc/apt/sources.list.d/pgdg.list When I try apt-get install postgresql-9.4 error:

Re: [GENERAL] Ubuntu 14.04 LTS install problem

On July 1, 2015 02:51:37 PM Urs G. Berner wrote: Am 01.07.15 um 14:08 schrieb Jan de Visser: On July 1, 2015 07:39:59 AM Urs Berner wrote: . . I would uninstall the stock (Ubuntu) version before installing the pgdg version. There is no postgresql at all installed - nor can I install

Re: [GENERAL] use null or 0 in foreign key column, to mean no value?

On June 26, 2015 11:59:05 PM Robert Nikander wrote: Hi, (Maybe my subject line should be: `is not distinct from` and indexes.) In Postgres 9.4, I’ve got a table of ‘items’ that references a table ‘colors’. Not all items have colors, so I created a nullable column in items like:

Re: [GENERAL] Database designpattern - product feature

On June 3, 2015 02:04:28 PM Roxanne Reid-Bennett wrote: I think you should evaluate your unease with having to update the database on release (potentially many times) carefully for what it is and why you have it. [I'm not saying it is invalid - just know why you have it] Because no matter

Re: [GENERAL] advocating LTS release and feature-train release cycles

On June 2, 2015 03:16:53 PM Zenaan Harkness wrote: On 6/2/15, Jan de Visser j...@de-visser.net wrote: On June 1, 2015 11:11:37 PM Arthur Silva wrote: In my opinion a twice a year schedule would be good. The LTS would be every 2 or 4 releases. Keeping 2 LTS versions supported at all

Re: [GENERAL] advocating LTS release and feature-train release cycles

On June 1, 2015 11:11:37 PM Arthur Silva wrote: In my opinion a twice a year schedule would be good. The LTS would be every 2 or 4 releases. Keeping 2 LTS versions supported at all moments. Maybe this should be reposted to the hackers list? Pretty sure this would be shot down pretty quick.

Re: [GENERAL] Replacing uuid-ossp with uuid-freebsd

On May 25, 2015 04:17:32 PM Piotr Gasidło wrote: test_uuid=# drop extension uuid-ossp; ERROR: cannot drop extension uuid-ossp because other objects depend on it DETAIL: default for table test column id depends on function uuid_generate_v4() HINT: Use DROP ... CASCADE to drop the dependent

Re: [GENERAL] PG and undo logging

On May 23, 2015 01:48:11 PM David G. Johnston wrote: On Sat, May 23, 2015 at 1:34 PM, Ravi Krishna sravikrish...@gmail.com wrote: Is it true that PG does not log undo information, only redo. If true, then how does it bring a database back to consistent state during crash recovery. Just

Re: [GENERAL] date with month and year

On May 21, 2015 11:56:52 AM Steve Crawford wrote: The article does also display a couple attitudes that I feel are especially rampant in the web-development community. The first is that web developers shouldn't become educated about the capabilities of a database but rather use the database as

Re: [GENERAL] Allowing postgresql to accept 0xff syntax for data types that it makes sense for?

On May 21, 2015 06:04:37 PM Brown, Joseph E. wrote: Unsubscribe pgsql-general This doesn't work. See the footer of the posts to the mailing list.

Re: [GENERAL] plpgsql functions organisation

On May 4, 2015 02:32:14 PM Yves Dorfsman wrote: As for performance concerns, in 99% of cases code maintainability is going to be way more important than performance microoptimization. If you're *that* concerned about performance than plpgsql probably isn't the right answer anyway. Isn't

Re: [GENERAL] Working with Array of Composite Type

On March 28, 2015 06:18:49 PM Alex Magnum wrote: Hello, I am struggling with finding the right way to deal with arrays of composite types. Bellow is an example of the general setup where I defined an image type to describe the image properties. A user can have mulitple images stored. The

Re: [GENERAL] Building JSON objects

On March 27, 2015 01:12:52 PM Eli Murray wrote: ERROR: syntax error at or near json_build_object LINE 1: insert into json(data) json_build_object(SELECT DISTINCT dep... You may want to review the syntax of the INSERT command, i.e. this doesn't have anything to do with JSON: INSERT INTO foo (

Re: [GENERAL] Building JSON objects

On March 27, 2015 11:38:42 AM David G. Johnston wrote: On Fri, Mar 27, 2015 at 11:31 AM, Jan de Visser j...@de-visser.net wrote: On March 27, 2015 01:12:52 PM Eli Murray wrote: ERROR: syntax error at or near json_build_object LINE 1: insert into json(data) json_build_object(SELECT

Re: [GENERAL] Autovacuum query

On March 25, 2015 09:31:24 PM David G. Johnston wrote: On Wed, Mar 25, 2015 at 8:58 PM, Mitu Verma mitu.ve...@ericsson.com wrote: Correcting the subject ​And this is why it is considered good form to do compose new message instead of replying to an existing one. Injecting your new topic

Re: [GENERAL] PostgreSQL-related legal question

On March 12, 2015 06:43:40 AM Gavin Flower wrote: Bill cannot comment, but it might be along the lines of assigning all intellectual property rights, or something of that ilk. In that case, it might give the company ownership of stuff he may have contributed (or intends to contribute) to

Re: [GENERAL] Application written in pure pgsql, good idea?

On March 1, 2015 09:45:24 AM inspector morse wrote: This is just for fun/research, I don't need a web framework because PHP is actually picking up the incoming requests and sending it to a pgsql stored function. The pgsql will concatenate all the html that is required for the page and send it

Re: [GENERAL] Application written in pure pgsql, good idea?

On February 28, 2015 03:39:06 PM inspector morse wrote: Is it a good idea to write a simple application (consisting of just data entry interfaces) in pure pgsql? Basically, we would have each page has a stored function in postgresql that is called by php+apache (the http get/post values

Re: [GENERAL] Monitoring query plan cache

On December 21, 2014 04:08:43 PM Andomar wrote: It is not always easy to tell the query type (function, prepared or ad-hoc.) We use Python in mod_wsgi with psycopg2. The code shows ad-hoc SQL, but who knows what the many layers between Python and the database do. psycopg2 sends the SQL you

Re: [GENERAL] how to use transaction isolation

On 4/10/08, Gong [EMAIL PROTECTED] wrote: In the java code below, I set the transaction isolation to serialization. public class IsolationTest { private static String select = select * from tmp where url = 'aaa'; public static void main(String[] args) throws Exception{

Re: [GENERAL] how to use transaction isolation

On 4/10/08, Gong [EMAIL PROTECTED] wrote: In the java code below, I set the transaction isolation to serialization. public class IsolationTest { private static String select = select * from tmp where url = 'aaa'; public static void main(String[] args) throws Exception{

[GENERAL] transactionid lock type?

by the two transactions are done late in the process, but this lock happens almost immediately after the second tx starts... Comments? jan -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad

[GENERAL] transactionid lock type?

by the two transactions are done late in the process, but this lock happens almost immediately after the second tx starts... Comments? jan -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad

Re: [GENERAL] postgresql startup

On 12/8/07, Charles [EMAIL PROTECTED] wrote: I am using Ubuntu 7.10. When trying to use Postgresql 8.2 I get the following errors: [EMAIL PROTECTED]:~# su -c postgres bash: postgres: command not found Ignoring an error and just charging on seems quite dangerous to me, especially when being

Re: [GENERAL] Using generate_series to create a unique ID in a query?

On 11/14/07, Tom Lane [EMAIL PROTECTED] wrote: hubert depesz lubaczewski [EMAIL PROTECTED] writes: On Mon, Nov 12, 2007 at 03:11:50PM -0800, Sarah Dougherty wrote: To recap with an example, the query below works fine, but how do I add a series to it? generate_series will not help with

Re: [GENERAL] Using generate_series to create a unique ID in a query?

On 11/14/07, Tom Lane [EMAIL PROTECTED] wrote: Jan de Visser [EMAIL PROTECTED] writes: Any reason why this couldn't appear in the core of some future version? You didn't read to the end of my post ;-). If a rownum() function like this didn't have any gotchas, I'd be in favor of putting

Re: [GENERAL] 8.3b1 in production?

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast

Re: [GENERAL] Automating Backup Restore

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] pg_dump (8.1.9) does not output copy statements

On Thursday 27 September 2007 00:38:15 Tom Lane wrote: Jan de Visser [EMAIL PROTECTED] writes: In my world two identical pilot errors within a short timeframe are indicat= ive=20 of a bad interface. Yeah, it's inconsistent.  How many people's dump scripts do you want to break to make

Re: [GENERAL] pg_dump (8.1.9) does not output copy statements

, that is). jan -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast

Re: [GENERAL] Transactional DDL

On Wednesday 15 August 2007 1:58:07 am Harpreet Dhaliwal wrote: So you mean to say something like this as far as oracle is concerned: BEGIN DDL 1 (commits right after its execution) DDL 2 (commits right after its execution) END That means there's no concept of putting DDL

Re: [GENERAL] 8.2.4 signal 11 with large transaction

On Friday 20 July 2007 12:51:47 Tom Lane wrote: Can someone make a reproducer that uses PQexecParams? Does JDBC apply? jan -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu

Re: [GENERAL] Looking for help regarding getting the latest inserted sequence value.

/8.2/interactive/functions-sequence.html). jan -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu

Re: [GENERAL] Transactions through JDBC

subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu

Re: [GENERAL] Transactions through JDBC

transactions on my own. Makes sense. I will change as you told me! Thanks! jan -- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu

Re: [GENERAL] oracle to postgresql conversion

On Thursday 08 March 2007 11:40:21 am Kevin Hunter wrote: I do not know what the setting 'sqlbl' does in Oracle. SET SQLBLANKLINES ON makes sqlplus not choke on empty lines in your input. Don't get me started. jan -- -- Jan de

Re: [GENERAL] postgresql vs mysql

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end

Re: [GENERAL] Anything I can do to speed up this query?

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

Re: [GENERAL] uConnect Voip

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore

Re: [GENERAL] top predicate

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast)--- TIP 5

Re: [GENERAL] posgresql server connection

configuration parameter tcpip_socket can you help me??!! thanks and regards FC4 comes with pgsql 8.0. AFAIK tcpip_socket is 7.x. On 8.x you set listen_addresses to the interface you want to listen on or '*' for all. jan -- -- Jan de Visser

Re: [GENERAL] Problem with Transaction

On Wednesday 08 March 2006 11:59, Eduardo Muñoz wrote:             statement.setObject(2, null);             statement.setObject(3, null); You need to use setNull( 2, Types.WHATEVER ). -- -- Jan de Visser                     [EMAIL

[GENERAL] Exception: An I/O error occured while sending to the backend

-- -- Jan de Visser                     [EMAIL PROTECTED]                 Baruk Khazad! Khazad ai-menu! -- ---(end of broadcast)--- TIP 6: explain