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
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
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
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.
>
>
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
> --- 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 --
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
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
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
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
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
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
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
[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
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
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
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
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 ,
[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
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
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
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
--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.
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
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
>> 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
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
27 matches
Mail list logo