Matt Friedman wrote:
>
> I have it and have found it very useful.
I think charachter about Functions and Triggers too small.
Server-side functions are very impotant for check input information and
integrity of database.
Best regards,
Mik
On Tue, Feb 13, 2001 at 09:52:21AM -0500, Tom Lane wrote:
> DaVinci <[EMAIL PROTECTED]> writes:
> > procedencia int2 references procedencia,
> > línea int2 references línea,
> > empresa int2 references empresa,
>
> Depending on the data values you are working wit
Hi!
Does anybody have chrach-me (mysql) results for PostgreSQL 7.1beta, because
in dont have module DBI for perl so i can't run it. I wan't to
comprebe to version 7.0 to see the difference.
--
lp,
Uro mailto:[EMAIL PROTECTED]
DaVinci wrote:
> On Tue, Feb 13, 2001 at 09:52:21AM -0500, Tom Lane wrote:
> > DaVinci <[EMAIL PROTECTED]> writes:
> > > procedenciaint2 references procedencia,
> > > línea int2 references línea,
> > > empresaint2 references empresa,
> >
> > Depending on the data v
Bruce Momjian wrote:
> I am not sure how many people have looked at my book on Amazon.com, but
> I have received my first negative book review:
>
>
>http://www.amazon.com/exec/obidos/ASIN/0201703319/o/qid%3D976592762/sr%3D8-1/ref%3Daps%5Fsr%5Fb%5F1%5F3/104-0116316-8891907
>
> I guess everyone i
On Wed, Feb 14, 2001 at 06:34:01AM -0500, Jan Wieck wrote:
> DaVinci wrote:
> > Problem is with referential integrity like you say. But I don't understand
> > well reason. Interlocks should appear only when values of referenced tables
> > are changed, added or removed, shouldn't they?. But that
I got the book when it was first made availiable, and its been a damn good
reference, though I do admit it doesn't go into using Large Objects well
enough. as for installation, the INSTALL file pretty much explains what
needs to be done. All in all its one of my most frequently used references.
=)
Hi all!
May I use function with parameters with triggers?
When I try it I have error: "Can't find function ..".
Is it normal?
Postre can't find my function. Why?
create function mytest(text) returns opaque as '
declare
parma1 like as $1;
begin
return NEW;
end;
' languag
Hello,
My name is Mourad. I have just started to use
Postgres.
I seen that postgres support variable-length multi-dimensional arrays, whit
built-in type or user-defined type.
I want know if Postgres permits the use of
set, list, and bag concepts.
Mourad,
I solved this problem by execute a SQL statement below after JDBC
connection.
SET TIME ZONE 'GMT';
--Raymond
begin:vcard
n:Chui;Raymond
tel;fax:(301)713-0963
tel;work:(301)713-0624 Ext. 168
x-mozilla-html:TRUE
url:http://members.xoom.com/rchui/
org:NWS, NOAA
version:2.1
email;internet:[EMAIL
Actually, you should take a look in the documentation. It specifically
states that the maximum size for any tuple is 8k (unless compiled
otherwise). If you want to store something larger, consider using the large
objects feature.
Dan
Bodoni Endre wrote:
> I have a little trouble with my Postgre
It is in the list archives several times.
All you need is to use some basic SQL.
select * from mytable where upper('my criteria') = upper(mytable.info);
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "David Reid"
> I still not understand what all compare, ... compare full
> dymamic/modular
> PostgreSQL with static features (types, functions ..) in MySQL?
>
> The MySQL must be always faster - if not - MySQL developers
> are greenhorns -
> but it isn't feasible.
>
> May be compare availability for so
On Wed, 14 Feb 2001, Bruce Momjian wrote:
> I am not sure how many people have looked at my book on Amazon.com, but
> I have received my first negative book review:
>
>
>http://www.amazon.com/exec/obidos/ASIN/0201703319/o/qid%3D976592762/sr%3D8-1/ref%3Daps%5Fsr%5Fb%5F1%5F3/104-0116316-8891907
Tom Lane wrote:
> Antonis Antoniou <[EMAIL PROTECTED]> writes:
> > I get the following message:
> > Backend sent D message without prior T
>
> > Does anyone knows about this message? I am expecting to retrieve
> > 2818510 records and am using PostgreSQL 7.1beta4.
>
> IIRC, this is a fairly comm
I'm trying to do a pg_dumpall & receive this error message:
ERROR: cannot create tmp_pg_shadow
ERROR: COPY command failed. Class tmp_pg_shadow does not exist.
ERROR: Relation 'tmp_pg_shadow' does not exist
I'm running postgres 6.5.2. Does anybody have any insight as to why
this is occuring?
In the app we are developing the concept of an address will occur very
often on many tables (vendor, clients, employees, etc.) so we are
looking to avoid code duplication by centralizing the addresses in one
table. However I once read on one of the pgsql- lists that one could use
a table name as
Antonis Antoniou <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> IIRC, this is a fairly common symptom of the frontend app running out
>> of memory --- libpq loses sync with what the backend is sending, and
>> it doesn't handle that very gracefully.
> This is strange because the machine has 1GB
Robert Dege <[EMAIL PROTECTED]> writes:
> I'm trying to do a pg_dumpall & receive this error message:
> ERROR: cannot create tmp_pg_shadow
Is it possible there is a physical file tmp_pg_shadow in your database
directory? If so, try removing it.
BTW, I'd recommend an update to 7.0.3 at your ear
I am attempting to upgrade to 7.0.3 -- hence the dumpall command.
There was a zero size file in template1 that was causing the problem.
Thanks for the help.
<>
Thanks
-Rob
> Robert Dege <[EMAIL PROTECTED]> writes:
> > I'm trying to do a pg_dumpall & receive this error message:
> > ERROR: ca
had so software instability on the news server the past couple of days,
the developers exorcised the demons and all appears to be well right now
*cross fingers*
On Tue, 13 Feb 2001, PM wrote:
> I haven't been able to connect to news.postgresql.org for a few days now. I
> can ping the address..
Title: RE: [GENERAL] using tables as types in other tables
I went over this ground about six months ago, and the bottom line is: until somebody picks this up and sorts out the code (which suffers from bitrot) it's not going to work like you described (believe me, I tried). Put the addresses i
DaVinci wrote:
> On Wed, Feb 14, 2001 at 06:34:01AM -0500, Jan Wieck wrote:
> > The problem is, that a referential integrity constraint needs
> > to ensure that from the moment the constraint got checked
> > until your INSERT got made persistent (COMMIT), nobody else
> > has
"Mark Alliban" <[EMAIL PROTECTED]> writes:
> pq_recvbuf: unexpected EOF on client connection
> Server process (pid 2087) exited with status 139 at Tue Feb 13 15:38:08 2001
> Terminating any active server processes...
> Server processes were terminated at Tue Feb 13 15:38:08 2001
> Reinitializing s
What's wrong with this function? The syntax is supposed to be right,
isn't it?
Create function UsaTablaTemporal()
RETURNS integer
AS '
BEGIN
SELECT p.apellidos, p.nombres, u.username
INTO TEMP TABLE mitabla
FROM persona p, usuario u
WHERE p.idpersona = u.idusuario
Alfonso Peniche <[EMAIL PROTECTED]> writes:
> What's wrong with this function? The syntax is supposed to be right,
> isn't it?
No, it isn't right, not for plpgsql. SELECT INTO means something
different to plpgsql than it does in normal Postgres SQL.
regards, tom lane
Hi
use it if u absolutly need it.. Using a function on a column name
doesnt use the index associated with that column,.. So exercise this
option with some amount of thinking..
Anand
On Wed, Feb 14, 2001 at 11:39:47AM -0500, Adam Lang wrote:
>It is in the list archives several times.
>
>All you ne
hi Endre
U can go upto 32 k on 7.0.x and there is no such limit on 7.1
Try to upgrade..
Regards
Anand
On Tue, Feb 13, 2001 at 04:11:59PM -0500, Bodoni Endre wrote:
>I have a little trouble with my PostgreSQL 6.5.1. I use a table with
>text character type.
>When I try to insert about 1 characte
Indexes *can* and *will* be used if you create the appropiate
functional indexes, i.e:
CREATE INDEX idx_table_field_upper ON table(upper(field));
SELECT field FROM table WHERE upper(field) LIKE upper('some string');
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toled
Hi,
What is the max query size for 7.1?
For 6.5.x it's about 16383 bytes.
The reason why I'm wondering is because I'm thinking of using 7.1's TOAST
to insert large amounts of text into a table (e.g. > 1MB). And I'd like to
confirm that it's possible using the usual database interfaces and met
I have a table, contacts, with two fields, id (int), contactid (int).
I have another table, users, with a bunch of fields, but one important
one, id (SERIAL), which is the table key.
I needed to test my database setup (and software) with 1.5 million users,
each of whom will have (on average), 10
Hello,
I have a pgsql db (v.6.5.3) with some tables.
On my pc1 I have created a MS access front end (with ODBC) with these
tables linked.
When I start the MS access front end from my pc2 (same ODBC
driver/setup) I get access denied while trying to open the linked
tables. I can link the tables ag
32 matches
Mail list logo
