Thanks for your help. But still, do you think there could be a way to
alter the dblink_current_query() function so that it could return the
right query? Or should I try to build the query in a function and send
it through dblink instead of dblink_current_query()?
I've also been told that oracle
Hello,
I have a strange delete behaviour in my postgres 8.0.3 database:
If I try a
delete
from t_node
where node_doc_id = XX;
from inside a plpgsql function
on this table:
CREATE TABLE t_node (
node_global_id int4 DEFAULT nextval('seq_node') NOT NULL ,
node_doc_id
post the description of the t_node and t_document tables for more informationOn 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]
> wrote:Hello,I have a strange delete behaviour in my postgres 8.0.3 database:
If I try adelete from t_node where node_doc_id = XX;from inside a plpgsql functionon th
Sorry to ask this again, but I seem to have misplaced the original
discussion and can't find it in the archives--could someone point me to the
thread on functions to batch alter privileges on all tables (or a subset) in
a database?
Thanks,
Sean
---(end of broadcast)--
Gnanavel S wrote:
> post the description of the t_node and t_document tables for more
> information
>
> On 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]> wrote:
>
>>Hello,
>>
>>I have a strange delete behaviour in my postgres 8.0.3 database:
>>
>>If I try a
>>
>>delete
>>from t_node
>>where node_doc
Post the result of
\d t_node t_documentOn 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]> wrote:
Gnanavel S wrote:> post the description of the t_node and t_document tables for more> information>> On 8/1/05, Renzo Kottmann <[EMAIL PROTECTED]> wrote:>
>>Hello,I have a strange delete behaviour in my
On Mon, Aug 01, 2005 at 01:57:32PM +0200, Renzo Kottmann wrote:
> If I try a
>
> delete
> from t_node
> where node_doc_id = XX;
>
> from inside a plpgsql function
> ...
> The deletion does not finish after several minutes and the CPU is
> running at 100% all the time unless I stop po
> On Mon, Aug 01, 2005 at 01:57:32PM +0200, Renzo Kottmann wrote:
>> If I try a
>>
>> delete
>> from t_node
>> where node_doc_id = XX;
>>
>> from inside a plpgsql function
>> ...
>> The deletion does not finish after several minutes and the CPU is
>> running at 100% all the time unless
Hi Sean,
On Aug 1, 2005, at 8:40 AM, Sean Davis wrote:
Sorry to ask this again, but I seem to have misplaced the original
discussion and can't find it in the archives--could someone point
me to the
thread on functions to batch alter privileges on all tables (or a
subset) in
a database?
Y
"Renzo Kottmann" <[EMAIL PROTECTED]> writes:
> "t_annotation_ann_startnode_id_fkey" FOREIGN KEY (ann_startnode_id)
> REFERENCES t_node(node_global_id) MATCH FULL
> "t_annotation_ann_endnode_id_fkey" FOREIGN KEY (ann_endnode_id)
> REFERENCES t_node(node_global_id) MATCH FULL
You need indexe
On Mon, Aug 01, 2005 at 04:02:14PM +0200, Renzo Kottmann wrote:
> > Do other tables have foreign key references to t_node? If so, are
> > there indexes on those tables' foreign key columns? How many records
> > are in t_node and any tables that reference it? Do you keep the
> > tables vacuumed a
Sean Davis wrote:
> Sorry to ask this again, but I seem to have misplaced the original
> discussion and can't find it in the archives--could someone point me to the
> thread on functions to batch alter privileges on all tables (or a subset) in
> a database?
On a somewhat related note, is revoking
Sorry, that I didn't explain my problem very clearly.
Anyway, here is the deal:
I'm the admin for the database, so, I've all the privileges of updating,
deletion, and reviewing and et.
When I tried to select based on the bemsid condition, TWO ROWS returned:
select * from users where bemsid=949
Hi all,
I am sorry for a stupid easy question, but I'am PostgreSQL novice.
Our development team has encountered problem with trying to install and
maintain cluster (pgcluster) on our production database. So they have
decided to switch the entire solution to MySql database.
a) have you got any goo
Wang, Mary Y wrote:
Sorry, that I didn't explain my problem very clearly.
Anyway, here is the deal:
I'm the admin for the database, so, I've all the privileges of updating,
deletion, and reviewing and et.
When I tried to select based on the bemsid condition, TWO ROWS returned:
select * from
So should we ask to take over the sql2pg project on pgfoundry and move
the existing scripts over there, as well as the migration guide?
On Sun, Jul 31, 2005 at 10:51:06PM -0700, Chris Travers wrote:
> Hi;
>
> I have just posted a MySQL to PostgreSQL migration guide at
> http://www.metatrontech.c
On Mon, Aug 01, 2005 at 06:44:50PM +0200, [EMAIL PROTECTED] wrote:
> Hi all,
> I am sorry for a stupid easy question, but I'am PostgreSQL novice.
> Our development team has encountered problem with trying to install and
> maintain cluster (pgcluster) on our production database. So they have
> dec
Can the client application be modified? It seems like it might
need to be, since if it is expecting its connection to be open whenever
it's running, the server killing the connection might lead it to
crash.
- IanOn 8/1/05, Len Walter <[EMAIL PROTECTED]> wrote:
Hi,I'm looking to solve a problem
On Mon, 2005-08-01 at 11:44, [EMAIL PROTECTED] wrote:
> Hi all,
> I am sorry for a stupid easy question, but I'am PostgreSQL novice.
> Our development team has encountered problem with trying to install and
> maintain cluster (pgcluster) on our production database. So they have
> decided to switc
Am Montag, den 01.08.2005, 18:44 +0200 schrieb [EMAIL PROTECTED]:
> Hi all,
> I am sorry for a stupid easy question, but I'am PostgreSQL novice.
> Our development team has encountered problem with trying to install and
> maintain cluster (pgcluster) on our production database. So they have
> deci
Richard,
Thank you so MUCH. I was able to delete the record by using the OID
method that you mentioned in (2).
Thanks again.
Mary Wang
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 9:44 AM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-g
Hello,
I'm unable to drop a recently created tablespace (the partition on which the
tablespace relies on, run out of space - postgresql seems to have a problem,
now):
template1=# drop tablespace disk1;
ERROR: tablespace "disk1" is not empty
Huh? Okay...lets dig into...
template1=# select
On Mon, Aug 01, 2005 at 09:28:07PM +0200, Oliver Siegmar wrote:
>
> template1=# select * from pg_tablespace_databases(594611987);
> pg_tablespace_databases
> -
> 595675173
> (1 row)
>
> Aha...so there seems to be a database associated to this tablespace - lets
> see
>
What happend with pgmonitor?
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-
Martín Marqués | Programador, DBA
Centro de Telemática| Administrador
Universidad Nacional
del Litoral
Hello,
I have an old binary RPM distribution of Postgres (7.1.2), and I am
trying to switch from the proprietary interface to the ODBC interface so
that I can upgrade my servers to a more up-to-date version. In trying
to get the ODBC installed on my test system, I've run into the problem
tha
i want to list non-system tables with psql and get the following error. any
alternatives? Thanks.
EPost-# \dt
ERROR: invalid byte sequence for encoding "UNICODE": 0xed
my database used UNICODE as the encoding. and the OS is win2k pro wich
simplified chinese
as default language.
--
On Mon, Aug 01, 2005 at 05:18:58PM -0500, Laura Vance wrote:
> In trying to get the ODBC installed on my test system, I've run
> into the problem that I need to know if my binary distribution of
> PostgreSQL was configured with the --enable-odbc option, and I can't
> seem to find out how to do that
Michael Fuhr wrote:
On Mon, Aug 01, 2005 at 05:18:58PM -0500, Laura Vance wrote:
In trying to get the ODBC installed on my test system, I've run
into the problem that I need to know if my binary distribution of
PostgreSQL was configured with the --enable-odbc option, and I can't
seem to find
El Lun 01 Ago 2005 20:13, Laura Vance escribió:
>
> I've tried other configuration test programs, but none of them seem to
> connect properly.
>
> Is there some incompatibility with this version of iodbc and postgresql
> 7.1.2?
Sorry, I happen to recall that you wanted this to upgrade the PG s
On Monday 01 August 2005 13:52, Scott Marlowe wrote:
> On Mon, 2005-08-01 at 11:44, [EMAIL PROTECTED] wrote:
> > Hi all,
> > I am sorry for a stupid easy question, but I'am PostgreSQL novice.
> > Our development team has encountered problem with trying to install and
> > maintain cluster (pgcluster
Martín Marqués wrote:
El Lun 01 Ago 2005 20:13, Laura Vance escribió:
I've tried other configuration test programs, but none of them seem to
connect properly.
Is there some incompatibility with this version of iodbc and postgresql
7.1.2?
Sorry, I happen to recall that you wanted th
Laura Vance <[EMAIL PROTECTED]> writes:
> Now I have to upgrade to Fedora Core 4, which uses a much higher version
> of PostgreSQL. Unfortunately the Pg.pm support is gone (it's wrapped by
> DBI/DBD, which wasn't that hard to convert my apps, and they work except
> for some inconsistent errors
Hi,
A generated a big SQL script (about 20 Mb), and fed it to psql. I was very
surprised that within a minute psql became quite slow. There were areas,
where less than 10 row were inserted in a second.
This is on a WinXP machine with local server 8.0.3, and only I use it.
Looking at the log fi
Hi, Does anyone have any experience to see the messaege below?
%pg_ctl start
postmaster starting
LOG: could not bind IPv6 socket:
HINT: Is another postmaster already running on port 5432? If not, wait a few
seconds and retry.
We don't use IPv6. Also, DB seems to be alright.
I hope it doesn't h
Hello,
I’m potentially having a strange performance
problem. I have a BIG table: ~100M, ~1KB rows. I do a SELECT
count(*) from it (I know it will be slow) and as I watch procinfo on my DB
server I see a huge amount of write activity. Thus,
1) Why does
this statement gener
=?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> I know it would be faster with COPY, but this is extremly slow, and the
> bottleneck is psql.
> What is the problem?
Hmm, does the Windows port have readline support, and if so does adding
the "-n" switch to the psql invocation f
[EMAIL PROTECTED] writes:
> Hi, Does anyone have any experience to see the messaege below?
> %pg_ctl start
> postmaster starting
> LOG: could not bind IPv6 socket:
> HINT: Is another postmaster already running on port 5432? If not, wait a few
> seconds and retry.
Hmm, it's pretty odd that there
"Logan Bowers" <[EMAIL PROTECTED]> writes:
> I'm potentially having a strange performance problem. I have a BIG
> table: ~100M, ~1KB rows. I do a SELECT count(*) from it (I know it will
> be slow) and as I watch procinfo on my DB server I see a huge amount of
> write activity. Thus,
> 1)
I'm trying to do a full text search for URL's stored in a table.
SELECT *,headline(description,q), rank(vectors,q) FROM bb_item,
to_tsquery('http://www.yahoo.com') AS q WHERE vectors @@ q ORDER BY
rank(vectors,q) DESC LIMIT 10 OFFSET 0
I get a general syntax error. I know it;s the colon in th
"Logan Bowers" <[EMAIL PROTECTED]> writes:
> I'm potentially having a strange performance problem. I have a BIG table:
> ~100M, ~1KB rows. I do a SELECT count(*) from it (I know it will be slow)
> and as I watch procinfo on my DB server I see a huge amount of write
> activity. Thus,
The only t
On Mon, Aug 01, 2005 at 08:32:17PM -0400, Tom Lane wrote:
> Laura Vance <[EMAIL PROTECTED]> writes:
> > Now I have to upgrade to Fedora Core 4, which uses a much higher version
> > of PostgreSQL. Unfortunately the Pg.pm support is gone (it's wrapped by
> > DBI/DBD, which wasn't that hard to conv
On Aug 1, 2005, at 4:33 PM, Robert Treat wrote:
On Monday 01 August 2005 13:52, Scott Marlowe wrote:
On Mon, 2005-08-01 at 11:44, [EMAIL PROTECTED] wrote:
Hi all,
I am sorry for a stupid easy question, but I'am PostgreSQL novice.
Our development team has encountered problem with trying to
Dear pgsql-general moderators,
I sent this post out over the weekend.
Is there a reason why it is not getting posted to the list?
Many thanks for your assistance. I really need some advice on this
issue from people with experience using both inheritance mechanisms
in PostgreSQL.
Cheers,
On Monday 01 August 2005 22:15, Michael Fuhr wrote:
> On Mon, Aug 01, 2005 at 09:28:07PM +0200, Oliver Siegmar wrote:
> > template1=# select * from pg_tablespace_databases(594611987);
> > pg_tablespace_databases
> > -
> > 595675173
> > (1 row)
> >
> > Aha...so there seems
Wang, Mary Y wrote:
Richard,
Thank you so MUCH. I was able to delete the record by using the OID
method that you mentioned in (2).
Well, if the column I mentioned in (1) is integer/bigint, then you'll
want to do (3) as well and reindex.
--
Richard Huxton
Archonet Ltd
--
Please help me!!!
Howto insert images file from Visual basic 6 into postgreSQL database server
For information :
my database server : Fedora Core 2
my client : Win XP Pro SP #2 with visual basic 6.
thanks be4.
Yahoo! Mail for Mobile
Take Yahoo! Mail with you! Check email on your mobile pho
46 matches
Mail list logo
