hi,
delphi to postgresql database connect commands and source code free download
. Please.
Tanks.
Burak BÝTÝKÇÝ
_
Yagmura yakalanmamak için sadece semsiyenize degil, MSN hava durumuna
güvenin! http://www.msn.com.tr/havadurumu/
On Tue, Feb 01, 2005 at 10:32:15PM -0800, William Yu wrote:
Tom Lane wrote:
William Yu [EMAIL PROTECTED] writes:
Doing a ps -ef | grep postgres, I will see something like:
root 17034 1 0 21:41 ?00:00:00 gdb -q -x /dev/stdin
postgres 9131
postgres 9131 2712 0 20:31
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
anyone any ideas
---(end of
It sounds like a php issue to me more than anythong else. Perhaps PHP's
garbage collection doesn't free the space fast enough?
However, I was looking at the PG source a little to see if it looked
like it was copying the query, and it appears that pqPutMsgBytes (in
fe-misc.c) copies the entire
On Wed, 02 Feb 2005 09:59:30 +, mike wrote:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
anyone any ideas
An idea: You have -values in your work_email column, i.e. work_email
values consisting
mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
anyone any ideas
A blank is never a NULL:
SELECT '' IS NULL;
?column?
Is there a newline or carriage return in the blank emails?
Sean
On Feb 2, 2005, at 4:59 AM, mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email
mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
anyone any ideas
---(end of
mike wrote:
Try this:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL;
Or if there are also blanks among those e-mail addresses:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL AND tb_contacts.work_email != '';
no
On Wed, 2005-02-02 at 11:31 +0100, Troels Arvin wrote:
On Wed, 02 Feb 2005 09:59:30 +, mike wrote:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
anyone any ideas
An idea: You have
On Wed, Feb 02, 2005 at 09:59:30AM +, mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
Maybe you have some
On Wed, 2005-02-02 at 11:26 +0100, Alban Hertroys wrote:
mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email '';
However I get loads of blank email addresses coming up
I have a table with about 200.000 entries. Among other things, it
contains an integer field I use as a timestamp, and a variable
character field I use for user names. Certain queries are taking too
long IMO. I'm trying this on both 7.4 and 8.0.
If I do a direct comparison (using =) on the user
Try:
SELECT first_name,'['||work_email||']' FROM tb_contacts WHERE
tb_contacts.work_email '';
Maybe you have spaces?
On Wed, Feb 02, 2005 at 09:59:30AM +, mike wrote:
I have the following query (I have removed all nulls from the field as
test)
SELECT first_name,work_email FROM
[snip]
Or if there are also blanks among those e-mail addresses:
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email IS NOT NULL AND tb_contacts.work_email != '';
The tb_contacts.work_email IS NOT NULL clause is superfluous, the
other condition will evaluate to false
anyone any ideas
If yes you should you have to use.
SELECT first_name,work_email FROM tb_contacts WHERE
tb_contacts.work_email ''
AND
tb_contacts.work_email IS NOT NULL;
See what happens with
SELECT first_name, work_email, LENGTH(COALESCE(work_email, ''))
FROM tb_contacts
WHERE
Did you try something like:
select first_name, work_email
FROM tb_contacts
WHERE tb_contacts.work_email !~ '^\\s$';
If this works, then you may want to do something like:
update tb_contacts set work_email=NULL where work_email ~ '^\\s$';
to clean the data and then use a trigger to do the same
I had thought that the Creation of the Index would do something
equivalent to Analyze. I tried Analyze Verbose and it improved
the scanner's ability to predict when an index would be useful.
Last week, I asked about visualizing B-tree coverage. I think
I meant Can I see the histograms that
WireSpot wrote:
I have a table with about 200.000 entries. Among other things, it
contains an integer field I use as a timestamp, and a variable
character field I use for user names. Certain queries are taking too
long IMO. I'm trying this on both 7.4 and 8.0.
If I do a direct comparison
On Wed, 02 Feb 2005 14:48:41 +, Richard Huxton dev@archonet.com wrote:
Think about it, you'd need an index that ordered use_name so that
(john_doe, Ajohn_doe, Zjohn_doe1234) were all next to each other.
If you anchor the search (LIKE 'john_doe%') and are using the C locale
then an
Greetings,
I've got a pesky J2EE based app that is using PostgreSQL-7.4.x on the
backend. Lately i've been getting a disturbing large number of
PostgreSQL out of memory exceptions on the J2EE side when running
queries that have some huge joins in them. I've tried increasing the
sort_mem value
On Wed, Feb 02, 2005 at 06:51:13AM -0800, TJ O'Donnell wrote:
I had thought that the Creation of the Index would do something
equivalent to Analyze. I tried Analyze Verbose and it improved
the scanner's ability to predict when an index would be useful.
Create index creates an index, analyze
Thomas F.O'Connell [EMAIL PROTECTED] writes:
The linking table is a pure linking table. It has a user_id and a
group_id, each a foreign key. The user_id ties to the appropriate
subclass user table. The group_id ties to the groups table, which is
not part of an inheritance hierarchy. A
Hi.
There should exist a news-server at:
news://news.postgresql.org/
but I can't connect to it.
It seems does it does not exist.
Even the name can't get resolved.
Is there a new one out there or isn't there one now ?
Cu,
Andreas
PS:
Btw, it got the news-servr from
TJ O'Donnell [EMAIL PROTECTED] writes:
Last week, I asked about visualizing B-tree coverage. I think
I meant Can I see the histograms that Analyze creates?
Are they available anywhere?
See pg_stats
regards, tom lane
---(end of
Hi there:
Postgresql 8.0.0, FreeBSD 5.3
test= select case 0 when 0 then null else 1/0 end as test;
ERROR: division by zero
test= select case when 0=0 then null else 1/0 end as test;
test
--
(1 row)
test=
Postgresql 7.4.5, FreeBSD 5.3
test = select case 0 when 0 then null else 1/0 end
WireSpot wrote:
On Wed, 02 Feb 2005 14:48:41 +, Richard Huxton dev@archonet.com wrote:
Think about it, you'd need an index that ordered use_name so that
(john_doe, Ajohn_doe, Zjohn_doe1234) were all next to each other.
If you anchor the search (LIKE 'john_doe%') and are using the C locale
Hello All,
Does anybody have a live cluster with 2 or more computers running
PostgreSQL, connected to single database on shared storage or to
replicated database with load balancing between them?
--
Best regards,
Yury mailto:[EMAIL PROTECTED]
Jeff Davis [EMAIL PROTECTED] writes:
Developers: am I mistaken about libpq copying the entire query before
sending it to the backend? Is there a reason that libpq wouldn't just
send it along to the backend?
That's a feature, not a bug. libpq marshals whole messages before
sending them so that
Just connected to it from here ... is this still providing to be a problem
for you?
On Wed, 2 Feb 2005 [EMAIL PROTECTED] wrote:
Hi.
There should exist a news-server at:
news://news.postgresql.org/
but I can't connect to it.
It seems does it does not exist.
Even the name can't get resolved.
Is
Doubtful, because users never share groups, so even though the groups
table is not part of an inheritance hierarchy, there shouldn't be any
overlap between foreign keys in the users1_groups table and the
users2_groups table in the groups table.
users1_groups links all users in the users1
I have a question about whether or not I need to do locking to a pg
table being accessed from a php application.
Let's say two users select rows from the table and display them in
their browser. User A clicks on row 1 to edit it. Since this is php,
so far it just selects the current values from
Yury Don wrote:
Hello All,
Does anybody have a live cluster with 2 or more computers running
PostgreSQL, connected to single database on shared storage or to
replicated database with load balancing between them?
No, because you can't share the same database files between two
independent servers.
Maybe other whitspace or non-printable-character.
Try:
SELECT first_name, '[' || work_email || ']', ASCII(work_email) FROM tb_contacts WHERE
tb_contacts.work_email '';
mike wrote:
On Wed, 2005-02-02 at 11:31 +0100, Troels Arvin wrote:
On Wed, 02 Feb 2005 09:59:30 +, mike
Lonni J Friedman [EMAIL PROTECTED] writes:
I've got a pesky J2EE based app that is using PostgreSQL-7.4.x on the
backend. Lately i've been getting a disturbing large number of
PostgreSQL out of memory exceptions on the J2EE side when running
queries that have some huge joins in them.
Such an
Vlad [EMAIL PROTECTED] writes:
Postgresql 8.0.0, FreeBSD 5.3
test= select case 0 when 0 then null else 1/0 end as test;
ERROR: division by zero
Hmm ... unexpected side effect of the change to avoid evaluating the
test-expression multiple times. This used to be transformed into
this at parse
Hi all,
I recently came across some apparent corruption in one of our databases around
a month ago.
version: postgresql 8 (originally 8r3, now at 8.0.1), debian box
The messages that we were originally getting in our syslog were about invalid
page headers. After
googling around, then dumping the
Rick Schumeyer wrote:
I have a question about whether or not I need to do locking to a pg
table being accessed from a php application.
Let's say two users select rows from the table and display them in
their browser. User A clicks on row 1 to edit it. Since this is php,
so far it just selects
Rick Schumeyer [EMAIL PROTECTED] writes:
In the meantime, when User B looks at his web page, there will still
be an 'edit' link for row 1. I'm pretty sure that I don't want User B
to try to edit the row, but as far as I understand the default postgres
locking will not prevent this. When user
Tatsuo Ishii wrote:
Pgpool 2.5b2 supports master slave mode which can cope with
master/slave replication softwares such as Slony-I. In this mode
pgpool sends non SELECT queries to master only. SELECTs are load
balanced by pgpool.
Other features of 2.5b2 include:
- ability to add timestamp
On Wed, 2005-02-02 at 10:07, Rick Schumeyer wrote:
I have a question about whether or not I need to do locking to a pg
table being accessed from a php application.
Let's say two users select rows from the table and display them in
their browser. User A clicks on row 1 to edit it. Since
Bricklen Anderson [EMAIL PROTECTED] writes:
Feb 1 11:17:50 dev94 postgres[4959]: [472-1] 2005-02-01 11:17:50 PST ERROR:
xlog flush request
972/FC932854 is not satisfied --- flushed only to 73/86D2640
Hmm, have you perhaps played any games with pg_resetxlog in this database?
I would have
On Wed, 02 Feb 2005 11:17:59 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Lonni J Friedman [EMAIL PROTECTED] writes:
I've got a pesky J2EE based app that is using PostgreSQL-7.4.x on the
backend. Lately i've been getting a disturbing large number of
PostgreSQL out of memory exceptions on the
Lonni J Friedman [EMAIL PROTECTED] writes:
Although, looking in the log postgresql is generating, I'm seeing the
following at the same time as that OOM above so it certainly looks
like the DB is barfing:
OK, then it's a backend issue not a client-side issue.
HashBatchContext: -1934683632
Tom Lane wrote:
Bricklen Anderson [EMAIL PROTECTED] writes:
Feb 1 11:17:50 dev94 postgres[4959]: [472-1] 2005-02-01 11:17:50 PST ERROR:
xlog flush request
972/FC932854 is not satisfied --- flushed only to 73/86D2640
Hmm, have you perhaps played any games with pg_resetxlog in this database?
I
On Wed, 02 Feb 2005 12:13:59 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Lonni J Friedman [EMAIL PROTECTED] writes:
Although, looking in the log postgresql is generating, I'm seeing the
following at the same time as that OOM above so it certainly looks
like the DB is barfing:
OK, then it's
On two different machines I've built pg 7.4 --with-python.
When I createlang plpythonu db I get this error:
createlang: language installation failed: ERROR: could not load library
/usr/local/pgsql/lib/plpython.so: /usr/local/pgsql/lib/plpython.so: undefined
symbol: PyDict_Copy
PyDict_Copy is
Lonni J Friedman [EMAIL PROTECTED] writes:
On Wed, 02 Feb 2005 12:13:59 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Hmm, looks like a hash join ran out of memory. What PG version is this
again, and what do you have sort_mem set to? Can you show an EXPLAIN
for the query that is failing like
PG=7.4.5
I guess I never noticed this during vacuum verbose before, but is it common
for the index to be 2 to 3 times the number of rows in a table? I've tried
reindexing and then dropping and readding them. Still the same number of
rows.
Indexes are all btree
mdc_oz=# select count(*) from
On Wed, 02 Feb 2005 12:58:49 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Lonni J Friedman [EMAIL PROTECTED] writes:
On Wed, 02 Feb 2005 12:13:59 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Hmm, looks like a hash join ran out of memory. What PG version is this
again, and what do you have sort_mem
One thing that is curious, though, is that when the AccessShareLock is
acquired by the stored procedure on an unrelated linking table, there
is also an AccessShareLock acquired on the primary key of the groups
table. The latter lock is understandable, but why would the procedure
need any locks
Lonni J Friedman [EMAIL PROTECTED] writes:
I'm afraid i'm not clear on what i'm supposed to be checking here.
Which conditions should I be looking at? thanks.
Well, for instance,
- Hash (cost=108.96..108.96 rows=28 width=24)
- Index Scan using mntr_subscr_usrevt on mntr_subscription
Bricklen Anderson [EMAIL PROTECTED] writes:
Tom Lane wrote:
I would have suggested that maybe this represented on-disk data
corruption, but the appearance of two different but not-too-far-apart
WAL offsets in two different pages suggests that indeed the end of WAL
was up around segment 972 or
[EMAIL PROTECTED] (elein) writes:
When I createlang plpythonu db I get this error:
createlang: language installation failed: ERROR: could not load library
/usr/local/pgsql/lib/plpython.so: /usr/local/pgsql/lib/plpython.so:
undefined symbol: PyDict_Copy
build --with-python and createlang
Patrick Hatcher [EMAIL PROTECTED] writes:
I guess I never noticed this during vacuum verbose before, but is it common
for the index to be 2 to 3 times the number of rows in a table?
Hm? Your vacuum output shows exactly 2757 rows in the table and in each
index, so I'm unclear what you are
On Wed, 02 Feb 2005 13:23:11 -0500, Tom Lane [EMAIL PROTECTED] wrote:
Lonni J Friedman [EMAIL PROTECTED] writes:
I'm afraid i'm not clear on what i'm supposed to be checking here.
Which conditions should I be looking at? thanks.
Well, for instance,
- Hash (cost=108.96..108.96
Debian--works (mine)
Fedora--doesn't work (not mine)
RedHat--doesn't work (not mine)
Is it possible that there is a problem with glibc?
If so, what does one do about that?
--elein
On Wed, Feb 02, 2005 at 01:25:03PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (elein) writes:
When I createlang
Tom Lane wrote:
Bricklen Anderson [EMAIL PROTECTED] writes:
Tom Lane wrote:
I would have suggested that maybe this represented on-disk data
corruption, but the appearance of two different but not-too-far-apart
WAL offsets in two different pages suggests that indeed the end of WAL
was up around
Lonni J Friedman [EMAIL PROTECTED] writes:
OK, i think i see what you're requesting. How's this:
What about field_value, does it in fact have circa 3 rows?
These tables are surely nowhere near big enough to bloat a hash table to
upwards of 2Gb, as your log shows happened. I'm thinking
[EMAIL PROTECTED] (elein) writes:
Debian--works (mine)
Fedora--doesn't work (not mine)
RedHat--doesn't work (not mine)
[ blink ] plpython works for me on Fedora Core 3, using
python-2.3.4-11. Anyone else see a problem with it?
regards, tom lane
I have a database that logs website requests, and I'm trying to get
all unique visitors within the last 1 minute, 5 minutes and 10
minutes. I have a table that I have the schema for below that incude
a field remote_ip.
When I perform the query with the filter, and the query without, the
results
Fedora as listed below is really, RedHat Enterprice Linux ES 2.1
I'm not sure about the second failing system.
--elein
On Wed, Feb 02, 2005 at 10:32:06AM -0800, elein wrote:
Debian--works (mine)
Fedora--doesn't work (not mine)
RedHat--doesn't work (not mine)
Is it possible that there is a
Marc G. Fournier wrote:
In order to address a potential security hole recently identified with
the LOAD option, the PostgreSQL Global Development Group is
announcing the release of new versions of PostgreSQL going back to the
7.2.x version.
As always, these releases are available on all
On Wed, 2 Feb 2005, Andrey V. Semyonov wrote:
Marc G. Fournier wrote:
In order to address a potential security hole recently identified with the
LOAD option, the PostgreSQL Global Development Group is announcing the
release of new versions of PostgreSQL going back to the 7.2.x version.
As
Marc G. Fournier wrote:
In order to address a potential security hole recently identified with
the LOAD option, the PostgreSQL Global Development Group is announcing
the release of new versions of PostgreSQL going back to the 7.2.x version.
As always, these releases are available on all
[EMAIL PROTECTED] (elein) writes:
Fedora as listed below is really, RedHat Enterprice Linux ES 2.1
ES 2.1 is pretty old; I'd not be at all surprised if it has a very
obsolete python version.
regards, tom lane
---(end of
Alex Turner [EMAIL PROTECTED] writes:
- Seq Scan on weblog_entry (cost=0.00..940.85 rows=4452 width=40)
Filter: ((request_time)::text ((('now'::text)::time(6) with
time zone - '00:01:00'::interval))::text)
This explain plain seems to me to be saying that it's casting the
On Wed, 2 Feb 2005, Geoffrey wrote:
Marc G. Fournier wrote:
In order to address a potential security hole recently identified with the
LOAD option, the PostgreSQL Global Development Group is announcing the
release of new versions of PostgreSQL going back to the 7.2.x version.
As always, these
It did have an old python and we updated it to
python 2.1 and the problem still occurs.
Is there a documented minimum python version required?
--elein
On Wed, Feb 02, 2005 at 04:16:03PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (elein) writes:
Fedora as listed below is really, RedHat
Burak BB wrote:
hi,
delphi to postgresql database connect commands and source code free
download . Please.
Tanks.
Burak BÝTÝKÇÝ
_
Yagmura yakalanmamak için sadece semsiyenize degil, MSN hava durumuna
güvenin!
On Wed, 2005-02-02 at 16:26, elein wrote:
It did have an old python and we updated it to
python 2.1 and the problem still occurs.
Is there a documented minimum python version required?
--elein
On Wed, Feb 02, 2005 at 04:16:03PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] (elein) writes:
Marc G. Fournier wrote:
On Wed, 2 Feb 2005, Geoffrey wrote:
Marc G. Fournier wrote:
In order to address a potential security hole recently identified
with the LOAD option, the PostgreSQL Global Development Group is
announcing the release of new versions of PostgreSQL going back to
the 7.2.x
Installation of a new version of python (2.1) did the trick.
The apparent failure of 2.1 was because 1.x remains on the
system and I had to convince configure to ignore it.
(PYTHON=python2)
Thank you all.
--elein
On Wed, Feb 02, 2005 at 05:01:21PM -0600, Scott Marlowe wrote:
On Wed, 2005-02-02
I'm writing a 2 dimensional array INTEGER[3][] that holds data that i need to
parse through to check for zeros. The user will insert into this array one row
at a time, when i insert the first row into this array it works fine but when i
check array_dims it gives me [1:3] not the [1:3][1:1]
Yes - I am a complete idiot:
The query is indeed completely wrong, it should be current_timestamp
not current_time. I finaly figured this out after staring at the
screen for twenty minutes trying to figure out what was going wrong.
DOH!
Alex Turner
NetEconomist
On Wed, 02 Feb 2005 16:14:58
[EMAIL PROTECTED] writes:
I'm writing a 2 dimensional array INTEGER[3][] that holds data that i
need to parse through to check for zeros. The user will insert into
this array one row at a time, when i insert the first row into this
array it works fine but when i check array_dims it gives me
Thanks for the reply.
I can do a select of some basic tables, but I was looking for some
scanner sort of thing.
I am not running with the disabled sync.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Yes I removed the comment...
Tail end of postgresql.conf..
#---
# VERSION/PLATFORM COMPATIBILITY
#---
# - Previous Postgres Versions -
# do not
Hi!
As an ultra-short introduction, I am the primary Debian developer for
PostgreSQL packages.
Our current packages became pretty hard to maintain; in particular
automatic upgrades to new major versions have always been a pain and
fail very often. There are also many requests for supporting
Actually it's only the views that have this problem. The funcitons have kept
the original table name which is now the name of the view.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
I merged 2 tables into 1 table and created a view for each of the tables so
as not to break existing applications. I renamed the old tables with the
_old suffix in case there was a problem so I could verify against the old
data.
The problem is that all the views and functions switched the name
WebEditor has support for PHP and several databases, including support
for ODBC and JDBC. Has anyone used it with PostgreSQL via ODBC? If
so, do you recommend it?
WebEditor is a Windows product; and current versions do not support
PostgreSQL natively. Now that PostgreSQL is available for
There should exist a news-server at: news://news.postgresql.org/
but I can't connect to it.
It seems does it does not exist.
Even the name can't get resolved.
Just connected to it from here ... is this still providing to
be a problem
for you?
O, NOW I start thinking. :-(
I think
I read the following thread from Nov 2002 on the impossibilities of
modifying a view and I was wondering if anything had changed in this regard
since then?
http://archives.postgresql.org/pgsql-hackers/2002-11/msg00609.php
Basically I want to remove a column from a table. The column is used in a
From: Tatsuo Ishii [EMAIL PROTECTED]
Pgpool 2.5b2 supports master slave mode which can cope with
master/slave replication softwares such as Slony-I. In this mode
pgpool sends non SELECT queries to master only. SELECTs are load
balanced by pgpool.
Sounds good!
Does it attempt any
HI
I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do
psql=# select * from foo_seq;
sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled
I have output set to go to a file with \o. Now I want to process a file
with \i. With ECHO set to all, I would like the statement to be echoed
in the file before the output, but instead it comes to the screen
(standard output). Is there some setting or trick I missed to
accomplish this? I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Maybe it's to late for me to think correctly (actually I'm sure of that). I'm
going to ask anyways.
I have a table like
id int4
user_id int4
photo varchar
image_type char(1)
where image_type is either G or X
What I want to do is have ONE query
On Tue, Feb 01, 2005 at 02:27:37PM -0800, Si Chen wrote:
You are right. The transactions are idle--when I do a ps auxw on my
database server, I see idle in transaction. Is this what you
meant, and would the steps you talked about with pg_stat_activity help
me track down the
89 matches
Mail list logo