Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-27 Thread Rene Pijlman
On Tue, 23 Oct 2001 17:16:06 +0200, you wrote: >CREATE OR DROP VIEW Is this for real? If I were a database server I would say to the client "please make up your mind" :-) Regards, René Pijlman <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: s

Re: [HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Rene Pijlman
On Sat, 6 Oct 2001 14:14:23 -0500, you wrote: >If I try: >cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login >I get a time out Same here an hour ago, but it seems to be fixed now. Regards, René Pijlman <[EMAIL PROTECTED]> ---(end of broadcast)--- T

Re: [HACKERS] [Fwd: Re: JDBC update wont, plz help.]

2001-09-27 Thread Rene Pijlman
On Wed, 26 Sep 2001 19:23:26 -0700, you wrote: >Itried everywhere can't get JDBC to update. The right place for this question is the [EMAIL PROTECTED] mailing list. I think you have a better chance of getting help when you post a brief description of the problem, instead of the full history

Re: [HACKERS] querying system catalogs to extract foreign keys

2001-09-14 Thread Rene Pijlman
On 13 Sep 2001 22:56:16 -0700, you wrote: >I tried to use the getImportedKeys and getExportedKeys of >java.sql.DatabaseMetadata... But it didnt give any expected >results... This is probably a limitation or bug in the JDBC driver. Please post details of your problem on [EMAIL PROTECTED] E.g. w

[HACKERS] Timezones and time/timestamp values in FE/BE protocol

2001-09-09 Thread Rene Pijlman
I'm working on a problem in the JDBC driver that's related to timezones. How does PostgreSQL handle timezones in the FE/BE protocol exactly? When a client sends a time or timestamp value to the server via the FE/BE protocol, should that be: 1) a value in the client's timezone? 2) a value in the

Re: [HACKERS] [JDBC] NULLs and sort order

2001-09-09 Thread Rene Pijlman
On Sun, 9 Sep 2001 15:25:17 +0200 (CEST), you wrote: >That is correct. Thanks. >> Would it be useful to add this information to the documentation, >> e.g. the documentation of ORDER BY in SELECT? > >Most likely. I'll post it on the docs list. Regards, René Pijlman <[EMAIL PROTECTED]>

[HACKERS] NULLs and sort order

2001-09-09 Thread Rene Pijlman
The JDBC driver's test suite currently fails on DatabaseMetaData methods that provide information about NULLs and sort order. I've looked through the documentation, but couldn't find anything about it. The JDBC driver returns different values, depending on the backend version (<7.2 vs. >= 7.2), s

Re: [HACKERS] [JDBC] Troubles using German Umlauts with JDBC

2001-09-04 Thread Rene Pijlman
[forwarding to pgsql-hackers and Bruce as Todo list maintainer, see comment below] [insert with JDBC converts Latin-1 umlaut to ?] On 04 Sep 2001 09:54:27 -0400, Dave Cramer wrote: >You have to set the encoding when you make the connection. > >Properties props = new Properties(); >props.put("user

Re: [HACKERS] Multiple semicolon separated statements and autocommit

2001-08-31 Thread Rene Pijlman
On 30 Aug 2001 21:35:42 -0400, you wrote: >"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: >> Are you sure? I thought all that autocommit meant was that a statement that >> is not enclosed within a begin/commit is automatically committed after it is >> run. So, in the this case all three q

Re: [HACKERS] Multiple semicolon separated statements and autocommit

2001-08-30 Thread Rene Pijlman
On Thu, 30 Aug 2001 19:56:53 +0200 (CEST), you wrote: >Rene Pijlman writes: >> If autocommit is _enabled_ and S1;S2;S3 is send to the database, >> what exactly is the behaviour of the backend? For example, what >> happens if S1 succeeds, S2 fails and S3 would succeed? >

[HACKERS] Multiple semicolon separated statements and autocommit

2001-08-30 Thread Rene Pijlman
We're discussing an implementation of JDBC's Statement.executeBatch() on the pgsql-jdbc list. The idea is to send multiple semicolon separated statements in one call to the backend. The purpose of this feature is of course a performance improvement, since it executes multiple (non-select) statemen

Re: [HACKERS] Toast, Text, blob bytea Huh?

2001-08-23 Thread Rene Pijlman
On Thu, 23 Aug 2001 13:47:01 -0400, you wrote: >1. I cant get a clear answer on what kind of data type to use for my large >text string? TEXT, ???, ??? or something about TOAST >I have seen in the e-mail archive but cant find any documentaion? TOAST is not a data type, but a project that extende

Re: [HACKERS] Re: [JDBC] New backend functions? [was Re: JDBC changes for 7.2... some questions...]

2001-08-23 Thread Rene Pijlman
On Thu, 23 Aug 2001 14:44:19 -0400, you wrote: >Ned Wolpert <[EMAIL PROTECTED]> writes: >> Should the backend support the function getLastInsertedOID()? > >seems doable and reasonable to me: whenever an OID is returned >to the client in an INSERT or UPDATE command result, also stash it in >a stati

[HACKERS] Re: [JDBC] JDBC pg_description update needed for CVS tip

2001-08-12 Thread Rene Pijlman
On Fri, 10 Aug 2001 16:08:50 -0400, you wrote: >The problem is in DatabaseMetaData.java (same code in both jdbc1 and >jdbc2, looks like). It does direct access to pg_description that isn't >right anymore. In getTables, instead of > > java.sql.ResultSet dr = connection.ExecSQL("select descr

[HACKERS] Re: Vim!

2001-08-06 Thread Rene Pijlman
Grant wrote: >Is it at all possible to use vim to interact with psql to >provide input? Why are you asking this on hackers? Please read http://www.postgresql.org/devel-corner/ ("YOU MUST TRY ELSEWHERE FIRST") Yes, psql can call vim. Its in the user documentation. You may want to read that too.