"Jeffrey A. Rhines" wrote:
> It seems i remember seeing somewhere that someone had developed a
> generic web front-end to Postgres. Was this a dream, or has someone
> else seen this, too? If not, would anyone be interested in
> collaborating on a JDBC/Java Servlets - based web front end to
> Po
Are you grabbing a set of rows to work on in an outside app?
You may be able to get a smaller random set with:
select from order by random() limit
But this will pretty much force a sort step [and if you're not limiting the
rows with a where clause, probably a full sequential scan] and could
be
I'm having some issues upgrading our production postgresql, which is at
version 6.4.2, to version 7.0.2. Here's what is happening...
I configure and make the new version of postgres (this is being done on a
separate system from the production for testing purposes). On the
production system I do
At this time check constraints using subqueries is non-functional.
Even if the immediate problem of allowing the subquery in the check
constraint was fixed, the larger problem of the fact that a subquery
check constraint is actually also a constraint on the tables mentioned
in the subquery still
I don't think it's random (well, I'm sure it's not) but you could use LIMIT
to get a smaller number of results...
*shrug* just an idea.
Good luck!
-Mitch
- Original Message -
From: "Nathan Barnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 24, 2000 3:20 PM
Subject:
I am having to perform a large data analysis query fairly frequently and the
execution time is not exceptable, so I was looking at doing a statictical
sample of the data to get fairly accurate results. Is there a way to
perform a query on a set number of random rows instead of the whole dataset?
I would like to know if I can update part of a column. ie
update myfile set substr(direct_key,1,10)='1234567890' where
substr(direct_key,1,10)='0987654321';
This does not work. Is this possible? Or am I looking at this the wrong
way?
--
Dave Smith
Candata Systems Ltd.
(416) 493-9020
[EMAIL PRO
I am running PostgreSQL v 7.0.2 on Linux 2.0.36
I have a table that holds definitions of objects. I have a second table to
hold the instances of these objects ( and the current values)
I would like to insure the instances are valid master object types.
I started using a check constraint on the
Hi,
I have seen DBengine on Freshmeat few weeks ago, perhaps this this what
you
are looking for...
Regards,
Gilles
"Jeffrey A. Rhines" wrote:
> It seems i remember seeing somewhere that someone had developed a
> generic web front-end to Postgres. Was this a dream, or has someone
> else seen
On Mon, 24 Jul 2000, Jeffrey A. Rhines wrote:
> It seems i remember seeing somewhere that someone had developed a
> generic web front-end to Postgres. Was this a dream, or has someone
> else seen this, too? If not, would anyone be interested in
> collaborating on a JDBC/Java Servlets - based we
It seems i remember seeing somewhere that someone had developed a
generic web front-end to Postgres. Was this a dream, or has someone
else seen this, too? If not, would anyone be interested in
collaborating on a JDBC/Java Servlets - based web front end to
Postgres? By the nature of JDBC and ser
Hi Jeffrey,
If you open a form that is bound to a table (or bound to a query that is
bound to a table) that is one database connection. If you then script
database updates from the form
(e.g.:
Dim dbs As Database
Set dbs=CurrentDB
dbs.Execute("UPDATE tbl_blah SET szBlah = 'blah' WHERE nBlahID =
Alan Horn wrote:
...
> The statement I'm using is thus :
>
> my($sth) = $dbh->prepare("insert into maintenance (sno, date, data) values
> ('$sno', '$date', '$tmpstring')");
>
> (all on one line of course...)
>
> My problem is this. $tmpstring may well contain embedded newlines or '
> characters
David George <[EMAIL PROTECTED]> writes:
> Does libpq support multithreaded frontend apps?
libpq is thread-ignorant. You can use it in a multithreaded app,
but it's up to you to ensure that no two threads try to operate on
the same PQconn object at the same time.
regards
Hello All,
Here's a bothersome issue: I've got the most recent versions of
Postgres, ODBC client for Win32, and Access 97. My client can enter new
records fine via a linked table. However, when she goes back to add
data to a column, she gets the following error:
message box title: "Write Conf
On Mon, 24 Jul 2000, Steve Heaven wrote:
>
> We currently use the Pg Perl module to interface our CGI scripts to Postgres.
> What would be the advantages/disadvantages to changing to the more generic
> DBI/DBD-Pg style interface?
I find the DBI/DBD-Pg interface to be *much* cleaner to work in .
On Mon, 24 Jul 2000, Steve Heaven wrote:
> We currently use the Pg Perl module to interface our CGI scripts to Postgres.
> What would be the advantages/disadvantages to changing to the more generic
1)
> DBI/DBD-Pg style in
Moin,
ist there any possibility to get the OID returned by an
insert clause in a plpgsql function? Something like
"select into intAuftragID id from auftrag ..." but only
for insert.
Bis dann
Matthias
Does libpq support multithreaded frontend apps? I was reading in the
beginning of Chapter 2 of the Programmer's Guide that it doesn't. I
have
an application that is portable between NT and Solaris x86 where I need
multithreaded client side access.
Thanks.
--
David George
Systems Engineer
Logic
getTimestamp() has always given us some problems. As you compiled from
source, try getting the current cvs repository. There's a couple of bug
fixes, including the current getTimestamp() fix.
Peter
--
Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Homepage: http://www.rete
We currently use the Pg Perl module to interface our CGI scripts to Postgres.
What would be the advantages/disadvantages to changing to the more generic
DBI/DBD-Pg style interface?
Thanks
Steve
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
htt
Kshipra wrote:
>
> hello all,
> I would like to mention something in this regard.
> I have executed all the commands given here in the same order, but what the
> auther is saying that after insert fails whatever u have inserted rolls back,
> this is not the case .
> as all of us knows Postgre wor
> When I start psql with the command -F $ (or any other saparator) the
> output is still with the separator |.
\f is only being honored when field alignment (\a) is turned off.
Dunno, whether this is intended.
Regards,
Mit freundlichem Gruß,
Holger Klawitter
--
Holger Klawitter
>product (eg. Excel/MSQuery), how have you set up the DSN, did you reboot 17
>times after the install).
Oh, that must be it! I only rebooted 16 times! ;)
Rob Nelson
[EMAIL PROTECTED]
At 14:38 24/07/00 +, Alan Horn wrote:
>
>Hi,
>
>This may actually be more of a limitation with the DBD::Pg perl driver.
>I'm not sure.
>
>Basically I'm using DBD::Pg in a perl script which inserts data into a
>very simple table.
>
>The statement I'm using is thus :
>
>my($sth) = $dbh->prepare(
Well, you will have to escape the single quotes but you shouldn't have to
escape the newlines, I'm inserting some chunks of text that have all sorts
of newline characters and I'm not escaping them, it seems to work fine..
-Mitch
- Original Message -
From: "Alan Horn" <[EMAIL PROTECTED]>
Hi,
This may actually be more of a limitation with the DBD::Pg perl driver.
I'm not sure.
Basically I'm using DBD::Pg in a perl script which inserts data into a
very simple table.
The statement I'm using is thus :
my($sth) = $dbh->prepare("insert into maintenance (sno, date, data) values
('$s
At 16:36 24/07/00 +0530, anuj wrote:
>
>>> This deriver made for Win95.
>>> I am using Win-Nt-Wks-4.0.
>>> Is this possible this due to different OS's ?
>>> Best Regard,
>>> Anuj
>
>>What kind of application do you use and where did you install your ODBC
>DSN?
>
>I don't know , Where I have insta
-Original Message-
From: Alex Bolenok [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 24, 2000 12:09 PM
To: anuj
Cc: pgsql-general
Subject: Re: [GENERAL] how connect visual basic to pgsql?
>> This deriver made for Win95.
>> I am using Win-Nt-Wks-4.0.
>> Is this possible this due to diffe
> hello all,
> I would like to mention something in this regard.
> I have executed all the commands given here in the same order, but what
the
> auther is saying that after insert fails whatever u have inserted rolls
back,
> this is not the case .
> as all of us knows Postgre works in autocommit m
At 08:13 24/07/00 -0400, Robert D. Nelson wrote:
>= Original Message from [EMAIL PROTECTED] (Philip Warner) at 7/22/00 6:45
>am
>>At 10:32 22/07/00 +0530, anuj wrote:
>>>
>>>When I do connectivity then error come - "Provider cannot be found. It may
>>>not be properly installed."
>>>
>>
>>Look
Hello all,
is there a bug in psql (PostgreSQL 7.0.2 on i686-pc-linux-gnu)?
When I start psql with the command -F $ (or any other saparator) the
output is still with the separator |.
When I do a \pset in psql I get the same wrong result.
Example:
test=# \pset fieldsep $
Field separator is '$'.
tes
32 matches
Mail list logo
