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
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 broadcast)---
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 quer
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 co
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 broadcast)
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 diff
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 ide
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 ha
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 addr
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 nam
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 tb
[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 f
>>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
W
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 pro
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 Ana
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 (using
On Wed, 02 Feb 2005 14:48:41 +, Richard Huxton 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 index can be u
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 for
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.
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
http://www.postgresql.org/co
"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 broadc
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
WireSpot wrote:
On Wed, 02 Feb 2005 14:48:41 +, Richard Huxton 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 index can
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
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 th
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 subcla
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. Y
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.
Su
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
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 the
"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. Wh
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 ti
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 ha
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 exception
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: -193468363
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
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
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
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_subscri
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 segm
[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 create
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 lo
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
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 se
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 t
[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 i
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 mirro
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 alwa
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 mirror
[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 broadcast)
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 Enter
Burak B&B 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! http://www.msn.com.tr/
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
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 ve
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] that
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 -0
[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 m
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?
http://arch
Yes I removed the comment...
Tail end of postgresql.conf..
#---
# VERSION/PLATFORM COMPATIBILITY
#---
# - Previous Postgres Versions -
# do not all
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 more
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?
http://archives.postgresql.
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 of
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 Win
> > 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 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
vi
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 i
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
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 reali
-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 that
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 tr
89 matches
Mail list logo
