M> Hi,
M> I'm getting some errors in log file saying "invalid character at
M> position
M> #20..." I know that this is most likely that query is wrong.
M> Is it possible to capture all queries that get send or at least the
M> invalid queries?
M> I'm using postgresql 7.4.3 on Red Hat 9
M> Thanks,
Hello CG,
Monday, February 7, 2005, 10:28:24 PM, you wrote:
C> Return-Path: <[EMAIL PROTECTED]>
C> Delivered-To: [EMAIL PROTECTED]
C> Received: (qmail 15486 invoked from network); 7 Feb 2005 17:36:10 -
C> Received: from svr4.postgresql.org (66.98.251.159)
C> by ns.vpcit.ru with SMTP; 7 Feb
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]
-
Horst Herb wrote:
>
> Where is the misterious "os.h" located that is required when I try to use libpq++
>??? It is not included in the 7.02 packages (neither source nor binary packages).
>There are no problems / error messages when using just libpq.
>
> The other misteriously missing file seem
Hello Marcin,
Once, Tuesday, September 05, 2000, 8:42:59 PM, you wrote:
MM> Hi,
MM> creation of following function works just fine but usage not:):
MM> mtldb=# select mtldb_wykonane(0);
MM> ERROR: unexpected SELECT query in exec_stmt_execsql()
MM> Can You help me find an error?
MM> tia
MM> CRE
Hello All,
I have a database where tables and fields have a names consisting of
cyrillic characters. And I would like to create a trigger on plpgsql,
but when I use cyrillic characters in names of elements of record NEW
or OLD, I am getting an errors. I tried NEW.fieldname_with_cyrillic,
NEW."fie
Hello Len,
Once, Tuesday, June 27, 2000, 4:22:08 AM, you wrote:
LM> While we're on the subject of Access/Postgres, I have a consistent problem
LM> in moving tables between Access and Postgres. Access doesn't seem to want
LM> to export a fixed length character field (i.e., I have a text field th
Hello All,
I am trying to develop web application with postgresql as datastorage,
using zope.
I read in documentation that postgresql is not multithreaded. So, I
understand that I can't use one connection to database for all users
and I must to open new connection for every user.
--
Best regar
Hello All,
I am trying to develop web application with postgresql as datastorage,
using zope.
I read in documentation that postgresql is not multithreaded. So, I
understand that I can't use one connection to database for all users
and I must to open new connection for every user. Am I right? Or m
Hello Marco,
Once, Monday, February 14, 2000, 4:11:25 PM, you wrote:
MG> I'm really a novice on postgresql but i'm using it on a linux server and
MG> i find it really usefull.
MG> Now I'd like to convert from MS Access some tables to use them with
MG> postgresql.
MG> I'm sure must exists a tutor
Hello All,
I am writing the second time about my problem, maybe this time
somebody will answer. The problem is following:
I use a cyrillic characters in the names of tables and fields. When
I use plpgsql function as a trigger I have a record NEW in this
function, and consequently this record has
Hello All,
I have a following problem. I have a tables and fields whith names,
consisting of cyrillic characters and getting an error. When I am
doing the same things but with only english characters, everything ok.
All other things works properly, only pl/pgsql functions. Does anybody
knows how
Hello All,
create function round_mark() returns opaque as '
begin
NEW."" := 1;
return NEW;
end;
' LANGUAGE 'plpgsql';
CREATE
CREATE TRIGGER marks_round_marks BEFORE INSERT OR UPDATE ON "rr"
FOR EACH ROW EXECUTE PROCEDURE round_mark();
CREATE
UPDATE "rr" SET "òò"=1 WHERE "òò" = 1;
NOTICE:
Hello Chris,
Once, Thursday, February 03, 2000, 6:30:26 AM, you wrote:
CB> 1) An imaginary field in every tuple that tells you the class it came
CB> from.
CB> This is useful when you select from table* and want to know which
CB> relation the object actually came from. It wouldn't be stored on di
Hello All,
Does anybody knows where to send bugreport for postgresql? I can't
find this information on postgres site.
Best regards,
Yury ICQ 11831432
mailto:[EMAIL PROTECTED]
Hello Ed,
Once, Friday, January 21, 2000, 11:47:07 PM, you wrote:
EB> I can do a ls /usr/lib/pgsql/plpgsql.so with no problem.
EB> By the way:
EB> 1: I am using Red hat 6.0 with kernel 2.2.52.
EB> 2: What shloud be the rights and the ownership of the plpgsql file and those
EB> of the directories
Hello Richard,
Once, Thursday, January 20, 2000, 3:04:43 PM, you wrote:
RH> - Original Message -
RH> From: Yury Don <[EMAIL PROTECTED]>
RH> To: pgsql-general <[EMAIL PROTECTED]>
RH> Sent: Wednesday, January 19, 2000 11:32 AM
RH> Subject: Re[2]: [GENERAL] Bug o
Hello All,
I ma sorry, I have sent previous uncomplited e-mail accidentally.
I have created the table
CREATE TABLE "tt" (
"cc" int4);
COPY "tt" FROM stdin;
-2112563299
-2111287024
-2110307960
.
2146589610
2146589611
2146589612
\.
About 30 000 records totally
Then I am doing the fo
Hello J.,
Once, Wednesday, January 19, 2000, 4:19:12 PM, you wrote:
>> Hello All,
>>
>> I have the following situation:
>>
>> CREATE TABLE "Contacts" (
>> "Contact" Serial,
>> "StuffTheir" Text,
>> "TheDate" datetime DEFAULT TEXT 'now',
>> "Subj" Text,
Hello All,
I have the following situation:
CREATE TABLE "Contacts" (
"Contact" Serial,
"StuffTheir" Text,
"TheDate" datetime DEFAULT TEXT 'now',
"Subj" Text,
"CustomerId" int4,
"Agent" int4,
"ActionType" int2,
"Done"
Hi All.
Is it possible to create function (preferably in plpgsql) which gets table
name and field name as an arguments and does select something from this
table?
Something like
CREATE FUNCTION "ft"
(text, text)
RETURNS int4
AS '
declare
res int4;
begin
select max($2
Hi All.
Does anywhere exists list of all PostgreSQL functions with description?
Sincerely yours, Yury.
don.web-page.net, ICQ 11831432
Hi All.
Once I asked already on similar subject but haven't got any reply. Try
to formulate my question on other way.
I would like to show table names and field names to users who not
familiar with databases and programming etc. Therefore I need to show
them something understandable. Postgres all
Can somebody send me a compiled module _pgmodule.so version 2.4 for
debian kernel 2.0.36 libc6-2.07u?
Thank you in advance.
Sincerely yours, Yury.
don.web-page.net, ICQ 11831432
24 matches
Mail list logo