[GENERAL] Interface to posgresql

2007-03-03 Thread makhan
Hi I am trying to connect to the postgresql and make quries usuing my application in c language using the libpq library.can you please tell me how to setup the enviromnet and where to place files so that I can run examples given on the libpq site.( if I use gcc compiler on linux or borland turbo

Re: [GENERAL] Interface to posgresql

2007-03-03 Thread Shane Ambler
makhan wrote: Hi I am trying to connect to the postgresql and make quries usuing my application in c language using the libpq library.can you please tell me how to setup the enviromnet and where to place files so that I can run examples given on the libpq site.( if I use gcc compiler on linux or

Re: [GENERAL] I'd love to know what the rest of this error message is.

2007-03-03 Thread Hannes Dorbath
Bill Moran wrote: It's a shame -- I get the impression that the rest of that error message would help you fix the issue, but I don't remember what you can do about it. Probably something to do with group policy, or some other setting in the security realm. Try CTRL + C while focus on the erro

Re: [GENERAL] I'd love to know what the rest of this error message is.

2007-03-03 Thread Magnus Hagander
Hannes Dorbath wrote: > Bill Moran wrote: >> It's a shame -- I get the impression that the rest of that error message >> would help you fix the issue, but I don't remember what you can do about >> it. Probably something to do with group policy, or some other setting >> in the security realm. > >

Re: [GENERAL] ftell mismatch with expected position

2007-03-03 Thread Magnus Hagander
Bruce Momjian wrote: > Jan Muszynski wrote: >> I found this thread (I'm posting here because I'm not subscribed to >> Hackers) >> http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg85241.html >> >> which seems to be talking about this issue. I'm just wondering what the >> current status

Re: [GENERAL] I'd love to know what the rest of this error messagei s.

2007-03-03 Thread Dave Page
> --- Original Message --- > From: Magnus Hagander <[EMAIL PROTECTED]> > To: Hannes Dorbath <[EMAIL PROTECTED]> > Sent: 03/03/07, 12:09:18 > Subject: Re: [GENERAL] I'd love to know what the rest of this error messageis. > > Hannes Dorbath wrote: > > Bill Moran wrote: > >> It's a shame --

[GENERAL] pg temp tables

2007-03-03 Thread Anton Melser
Hi, I have been going around telling everyone that there is no point using physical tables in postgres for temporary storage within a procedure. Why bother bothering the system with something which is only used in one procedure I said to myself... I have just learnt that with MS Sql Server, this i

Re: [GENERAL] PG Dump 8.2

2007-03-03 Thread Joshua D. Drake
Mikko Partio wrote: > Laurent ROCHE wrote: >> Hi, >> >> Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2, >> from a recommandable place ? >> >> I can not recommend my clients to use 8.2 if there's nobody supporting >> the packages (so just compiling from the source code is not

Re: [GENERAL] US Highschool database in postgres

2007-03-03 Thread mobiledreamers
http://en.wikipedia.org/wiki/Category:Lists_of_schools_in_the_United_States Has one parsed the list of high schools in the USA and stored in postgres or is there an open list of backup files that people can share so they can share their useful backups of useful dbs like list of high schools list o

Re: [GENERAL] supporting 2000 simultaneous connections.

2007-03-03 Thread Shiva Sarna
Hi, Thanks for your reply and help. The web application I am talking about is a Learning Management System. By simultaneous users I mean that all 2000 users should be able to access the application and for example say take a test. We are using JNDI connection pooling. I think we have to now t

Re: [GENERAL] strange behaviour with sub-select and pl/pgSQL

2007-03-03 Thread Martijn van Oosterhout
On Tue, Feb 27, 2007 at 12:15:03PM +0100, Robert Partyka wrote: > Hi, > > I found PostgreSQL have strange behaviour with sub-select and pl/pgSQL, > see the case study at: > http://www.bobson.pl/pgsql/pgsql_sb1.html The PostgreSQL optimiser is pretty smart and will pull up simple sub-selects like

[GENERAL] COPY FROM and multiple null strings

2007-03-03 Thread Angva
Hi, I've run into a little snag in my data loads, and I come seeking advice before I resort to an ugly workaround... I have a function which runs COPY FROM several times. My problem is that my data provider uses symbols to represent nulls - there is a different symbol for each different data type

[GENERAL] Support for idempotent schema changes?

2007-03-03 Thread David Lowe
At our development shop we use many different PostgreSQL databases simultaneously, each corresponding to a specific version of our software. For example, a developer might be working on v1.0 and v1.1 at the same time, while QA is busily testing/verifying version 1.0.3. All application code and S

Re: [GENERAL] How Can I set a non standard date format?

2007-03-03 Thread Joshua D. Drake
[EMAIL PROTECTED] wrote: > Hi All Esteemed Developers, > > I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 > > I want to be able to have dates returned from a query in this format > so that I can use passthrough queries from Access. I know I can use > to_char to format the date anyw

Re: [GENERAL] COPY FROM and multiple null strings

2007-03-03 Thread Joshua D. Drake
Angva wrote: > Hi, > > I've run into a little snag in my data loads, and I come seeking > advice before I resort to an ugly workaround... > > I have a function which runs COPY FROM several times. My problem is > that my data provider uses symbols to represent nulls - there is a > different symbol

[GENERAL] Partition Table

2007-03-03 Thread Martin Gainty
Good Afternoon All- I come from the other DBMS from California where extremely large datasets could be partitioned into separate and distinct partition tables Lets say for example I have Property Table which contains a tera worth of data and to gain performnce in the indexing I *could* partitio

Re: [GENERAL] Partition Table

2007-03-03 Thread Joshua D. Drake
Martin Gainty wrote: > Good Afternoon All- > I come from the other DBMS from California where extremely large datasets > could be partitioned into separate and distinct partition tables > Lets say for example I have Property Table which contains a tera worth of > data and to gain performnce in

Re: [GENERAL] Partition Table

2007-03-03 Thread Martin Gainty
Good Stuff! Thanks Josh! M-- --- This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary ,

Re: [GENERAL] How Can I set a non standard date format?

2007-03-03 Thread Shane Ambler
[EMAIL PROTECTED] wrote: Hi All Esteemed Developers, I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 I want to be able to have dates returned from a query in this format so that I can use passthrough queries from Access. I know I can use to_char to format the date anyway I want, b

Re: [GENERAL] Can I getting a unique ID from a select

2007-03-03 Thread Bruno Wolff III
On Thu, Mar 01, 2007 at 06:16:02 -0800, Timasmith <[EMAIL PROTECTED]> wrote: > I am using hibernate, using a view like a read only table and I need a > primary key each time a select is issued. > > create view myview as > select rownum, t1.field, t2.field > from tableOne t1, tableTwo t2 > where

[GENERAL] Configure can't find com_err on OpenBSD for --with-krb5

2007-03-03 Thread Jim Rosenberg
I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the command ./configure -v --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV I get: checking for library containing com_err... no configure: error: could not find function 'com_err' required for Kerberos 5 This

Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5

2007-03-03 Thread Tom Lane
Jim Rosenberg <[EMAIL PROTECTED]> writes: > I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the > command > ./configure -v --with-openssl --with-krb5 > --with-includes=/usr/include/kerberosV > I get: > checking for library containing com_err... no > configure: error: could not

Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5

2007-03-03 Thread Jim Rosenberg
--On Saturday, March 3, 2007 11:24 PM -0500 Tom Lane <[EMAIL PROTECTED]> wrote: I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the command ./configure -v --with-openssl --with-krb5 --with-includes=/usr/include/kerberosV I get: checking for library containing com_err.

Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5

2007-03-03 Thread Tom Lane
Jim Rosenberg <[EMAIL PROTECTED]> writes: > --On Saturday, March 3, 2007 11:24 PM -0500 Tom Lane <[EMAIL PROTECTED]> > wrote: >> Perhaps you need a --with-libs switch too? > Hmm. libkrb5 is in /usr/lib -- with all the rest of the libs -- not > somewhere special. OK, then the next likely answer

Re: [GENERAL] PG Dump 8.2

2007-03-03 Thread Mikko Partio
Joshua D. Drake wrote: Mikko Partio wrote: Laurent ROCHE wrote: Hi, Does anyone know if Ubuntu 6.10 (LTS) has packages for PostgreSQL 8.2, from a recommandable place ? I can not recommend my clients to use 8.2 if there's nobody supporting the packages (so just compiling from the sourc

Re: [GENERAL] PG Dump 8.2

2007-03-03 Thread Joshua D. Drake
>> To my knowledge there are no 8.2 binaries for Ubuntu LTS. The best you >> could probably get is 8.1 which is a perfectly acceptable and stable >> release. >> >> Sincerely, >> >> Joshua D. Drake > > Well, there are 8.2 binaries for Ubuntu 6.10 [1], but for LTS (6.04) 8.1 > is the latest version

Re: [GENERAL] Support for idempotent schema changes?

2007-03-03 Thread Peter Eisentraut
David Lowe wrote: > So how can I make statements of the form: > * alter table only customers add constraint > a_previously_missed_constraint unique (a, b, c); > > * add column points int4 not null default 0; > idempotent? You just ignore the error if the object already exists. -- Pet