[GENERAL] memory problem with refresh materialized view

anyone help me? Thanks in advantage :) Enrico -- PostgreSQL openday Rimini 27-02-2016 <http://www.postgresql.org/about/event/1861/> Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310 http://www.pgtraining.com <http://www.pgtraining.com-> - i...@pg

Re: [GENERAL] Out of Memory

On 01/16/2015 11:22 AM, Enrico Bianchi wrote: https://drive.google.com/file/d/0ByfjZX4TabhocUg2MFJ6a21qS2M/view?usp=sharing Note: due an error in dump script, if you are in Linux/Unix environment, use this command for uncompressing the file: bzip2 -d -c comment_test.dump.bz2 |sed -e 

Re: [GENERAL] Out of Memory

On 01/16/2015 09:58 AM, Enrico Bianchi wrote: I've asked permission for these data I've obtained the permission, here is available a subset of data large enough to replicate the problem (note: you can simply run the query without the where clause): https://drive.google.

Re: [GENERAL] Out of Memory

On 01/16/2015 01:19 AM, John R Pierce wrote: you didn't do EXPLAIN ANALYZE, so your query plan statistics are all estimates. I know, but the EXPLAIN ANALYZE has the same problem of the query Enrico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Out of Memory

x27;comment')->>'created_time')::timestamp without time zone ELSE NULL END AS comment_create_date, CASE substring((field_id ->'comment')::text,1,1) WHEN '{' THEN cast(to_char((field_id ->'comment'->>'created_time')::timestamp without time zone,'MMDD') as numeric) WHEN '[' THEN cast(to_char((jsonb_array_elements(field_id ->'comment')->>'created_time')::timestamp without time zone,'MMDD') as numeric) ELSE NULL END AS comment_created_day, field_id ->> 'pageId' page_id, CASE substring(field_id->>'feedtype',1,1) WHEN 'f' THEN 2 WHEN 'b' THEN 1 ELSE 3 END AS owner_type, 'WALL' comment_type, CASE substring((field_id ->'comment')::text,1,1) WHEN '{' THEN to_char((field_id ->'comment'->>'created_time')::timestamp without time zone,'HH24')::numeric WHEN '[' THEN to_char((jsonb_array_elements(field_id ->'comment')->>'created_time')::timestamp without time zone,'HH24')::numeric ELSE NULL END AS comment_time_slot, CASE substring((field_id ->'comment')::text,1,1) WHEN '{' THEN (field_id ->'comment'->>'like_count')::numeric WHEN '[' THEN (jsonb_array_elements(field_id ->'comment')->>'like_count')::numeric ELSE NULL END AS like_count, 1 as sn_id, 17 AS group_id FROM ecce_stage.fbcomment WHERE field_id ->> 'pageId' in ('110686168966251', '124858950920112', '164913773543444', '190178617688826', '142553345763418') ; Maybe you can generate some artificial data that produces the problem? I've asked permission for these data Enrico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Out of Memory

0 62257732 16888 99646400 0 12 1070 160 21 4 74 0 2 1 0 0 60939172 16888 99646400 0 0 1072 158 21 4 75 0 0 1 0 0 59627188 16888 99646400 0 6 1071 161 21 4 75 0 0 1 0 0 58324692 16888 99646400 0 0 1069 152 21 4 75 0 0 1 0 0 57002732 16888 99646400 0 0 1049 133 21 4 75 0 0 1 0 0 55671200 16888 99646400 0 1 1076 152 21 4 75 0 0 1 0 0 54316064 16896 99646000 0 4 1056 140 21 4 75 0 0 1 0 0 52939020 16896 99646400 0 0 1052 140 22 3 75 0 0 1 0 0 51558644 16896 99646400 0 5 1069 156 21 4 75 0 0 1 0 0 50188544 16896 99646400 0 0 1069 156 21 4 75 0 0 0 0 0 64464804 16896 99647600 0 0 557 269 6 7 88 0 0 Any hint for resolving the problem is appreciated Cheers, Enrico

Re: [GENERAL] Index scan vs indexonly scan method

effective to use the visibility map and pull data directly from the index data. Thank you for your answer Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310 http://www.pgtraining.com

[GENERAL] Index scan vs indexonly scan method

mit is 100 and for the second the limit is 1 it seems a little bit strange...someone can help me to understand why? My develop PostgreSQL version is a 9.4 beta regards, Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 3

Re: [GENERAL] Question on explain

UUID. In any event, it is unlikely the planner would pick a different plan were it to correctly understand the selectivities, so no harm is done. Although it is easy to imagine similar queries where that would not be the case. Cheers, Jeff Thank you very much ;) Enrico -- That's one

[GENERAL] Question on explain

stants as default_statistics_target (integer) and / or from_collapse_limit (integer) join_collapse_limit (integer) but the query plan has been the same. Can anyone help me ? Thanks, Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 - Mob.+39 328 4164

Re: [GENERAL] PostgreSQL Magazine #01 is out !

one. This is very good. > > -- >  Simon Riggs   http://www.2ndQuadrant.com/ >  PostgreSQL Development, 24x7 Support, Training & Services > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http

Re: [GENERAL] wal archiving on a hot-standby server

Hello John, Il giorno 22/nov/2011, alle ore 11.04, John R Pierce ha scritto: > I don't believe that function is immutable, since it depends on the value of > pg_current_xlog_location() which will change over time. oops, I'm afraid you are right! e. -- Sent via pgsql-general mailing list (pgs

Re: [GENERAL] wal archiving on a hot-standby server

This message has been digitally signed by the sender. Re___GENERAL__wal_archiving_on_a_hot_standby_server.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] wal archiving on a hot-standby server

Hello Simon, Il giorno 21/nov/2011, alle ore 15.47, Simon Riggs ha scritto: > On Mon, Nov 21, 2011 at 10:58 AM, Enrico Sirola > wrote: > >> is it possible to archive the WAL files received by a hot-standby server? In >> noticed nothing about this on the pgsql docs. T

[GENERAL] wal archiving on a hot-standby server

. Thanks a lot for your help, Enrico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] weird pg_statistic problem

Hello Tom, Il giorno 11/nov/2011, alle ore 22.05, Tom Lane ha scritto: > Enrico Sirola writes: >> this morning I experienced a weird problem with our pgsql database (9.0.3): >> while performing a simple query, I receive the following error: >> Nov 11 10:24:09 postgre

[GENERAL] weird pg_statistic problem

27;m stuck. How should I proceed? Is it possible to drop/recreate the pg_statistic table? What else could I try? Thanks a lot for your help, Enrico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?

tore, eg. venti. cu -- ------ Enrico Weigelt, metux IT service -- http://www.metux.de/ phone: +49 36207 519931 email: weig...@metux.de mobile: +49 151 27565287 icq: 210169427 skype: nekrad666 -

Re: [GENERAL] ODBC mac os

Thank you very much ;) Enrico 2010/1/29 Dave Page : > On Fri, Jan 29, 2010 at 1:29 PM, Enrico Pirozzi wrote: >> Hi, >> I would like to find an odbc driver for mac os x, >> where I can find it? >> >> Thanks to all > > If you're running the one-

[GENERAL] ODBC mac os

Hi, I would like to find an odbc driver for mac os x, where I can find it? Thanks to all regards, Enrico -- That's one small step for man; one giant leap for mankind -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Records Number

-list archives on this. Thank you for your time Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 Mob.+39 328 4164437 Fax +39 0861 1850310 www.enricopirozzi.info i...@enricopirozzi.info Skype sscotty71 -- Sent via pgsql-gener

[GENERAL] Records Number

field in the pg_class table, but I need this value in real time. Any suggestion? Enrico -- That's one small step for man; one giant leap for mankind Enrico Pirozzi Tel. +39 0861 1855771 Mob.+39 328 4164437 Fax +39 0861 1850310 www.enricopirozzi.info i...@enricopirozzi.info Skype sscotty71

[GENERAL] db_restore and xml data

s there are 'content' xmls which are not 'document' xmls and vice versa, so how do you proceed in this case? It seems that potentially you could be unable to restore from a dump. Thanks for your help, Enrico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

[GENERAL] when to use "execute" in plpgsql?

y, is the official 8.3.5 on centos5/x86_64). The "safe" way to do things (it never breaks) is to pass every statement via executes but we would like to dig on this. What are we missing? Thanks in advance for your help, enrico -- Sent via pgsql-general mailing list (pgsql-general@postg

Re: [GENERAL] returns numbers of record

No I'm looking something else, as I wrote above :) Regards Enrico 2008/12/3 justin <[EMAIL PROTECTED]>: > Select Count(*) from (query) is what i believe you are looking for see > http://www.postgresql.org/docs/8.3/interactive/tutorial-agg.html > > > > Enric

[GENERAL] returns numbers of record

Hi all, does it exists a way to know how many records a query returns? I thought sometime like DECLARE curs1 CURSOR FOR select * from table ; I thought if I can write MOVE LAST Is there any way to return the number of row for select * from table without execute a count(*) ? Thanks :) Enrico

[GENERAL] unsigned int type

Hi all, Is it present on postgresql 8.3.x any implementation of an unsigned int type? Regards, Enrico -- That's one small step for man; one giant leap for mankind www.enricopirozzi.info [EMAIL PROTECTED] Skype sscotty71 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] unable to drop a constraint

Hi Michael, Il giorno 16/lug/08, alle ore 18:21, Michael Glaesemann ha scritto: On 2008-07-16, at 7:18 AM, Enrico Sirola wrote: Hi, I'm using postgresql version 8.3.1 I have two tables, one has a field with a foreign key pointing to the primary key of another table. When I to dro

Re: [GENERAL] unable to drop a constraint

Hello Tom, Il giorno 16/lug/08, alle ore 16:40, Tom Lane ha scritto: Enrico Sirola <[EMAIL PROTECTED]> writes: I have two tables, one has a field with a foreign key pointing to the primary key of another table. When I to drop the first table, I get the following error: test=# drop

[GENERAL] unable to drop a constraint

Hi, I'm using postgresql version 8.3.1 I have two tables, one has a field with a foreign key pointing to the primary key of another table. When I to drop the first table, I get the following error: test=# drop table user; ERROR: "customer_pkey" is an index test=# select * from pg_constra

[GENERAL] best er modeling tool for postgreSQL

well Best regards Enrico Sabbadin [EMAIL PROTECTED] Can you fly that thing ? Not Yet (The Matrix)

[GENERAL] pgbench not setting scale size correctly?

ng or there is a bug somewhere? Thanks for your help, Enrico -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] APEX / HTML DB for PostgreSQL

Il giorno 24/feb/08, alle ore 04:53, justin tocci ha scritto: In its most basic form a great tool would just start as a pl/pgsql or pl/perl function that could be used to call a table and have it output a batch of records to an editable html form or a colored pdf for nice reports. There wo

Re: [GENERAL] Function problem

On Fri, 22 Feb 2008 11:51:01 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Enrico <[EMAIL PROTECTED]> writes: > > the first record has valore=98 and totale=0 for the first time of > > the loop, but my first result of totale is -298 instead of +98. > > Hmm, that&#

[GENERAL] Function problem

; minv.totale = totale; return next minv; end loop; return; [..] So the first record has valore=98 and totale=0 for the first time of the loop, but my first result of totale is -298 instead of +98. Any suggestion? Thanks Regards Enrico -- One small feel for man, one giant ass for mankind

Re: [GENERAL] questions about very large table and partitioning

Il giorno 18/feb/08, alle ore 18:42, Erik Jones ha scritto: On Feb 18, 2008, at 11:23 AM, Enrico Sirola wrote: Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto: 1) PostgreSQL only support partition by inheritance, and rules have to be created for each child table, this

Re: [GENERAL] questions about very large table and partitioning

Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto: 1) PostgreSQL only support partition by inheritance, and rules have to be created for each child table, this will result *a lot of* rules if the number of child tables is large. Are there some smart ways to avoid this kind of ma

Re: [GENERAL] Vertical and Horizontal Table Partition

inheritance + triggers probably. there's an example on the pgsql documentation Il giorno 18/feb/08, alle ore 13:18, T.J. Adami ha scritto: I know that using tablespaces I can create a vertical partition by creating two tables with the same primary key wich stores different columns in each tab

Re: [GENERAL] arrays of floating point numbers / linear algebra operations into the DB

I respond myself: Enrico Sirola ha scritto: [...] seems to work). The problem for the code above is that it doesn't work for vectors longer than 1000 elements or so (try it with 2000 and it doesn't work). I guess I should manage the "toasting" machinery in some ways

Re: [GENERAL] arrays of floating point numbers / linear algebra operations into the DB

Hi Webb, Webb Sprague ha scritto: I'm quite proud, this is my first C extension function ;-) I'd gladly post the code if it's ok for the list users. It's more or less 100 lines of code. This approach seems promising... I would definitely like to see it. here it goes: ---

Re: [GENERAL] arrays of floating point numbers / linear algebra operations into the DB

Hi Webb, Joe, Martijn Webb Sprague ha scritto: On Feb 1, 2008 2:31 AM, Enrico Sirola <[EMAIL PROTECTED]> wrote: Hello, I'd like to perform linear algebra operations on float4/8 arrays Having avoided a bunch of real work wondering about linear algebra and PG, did you consi

Re: [GENERAL] arrays of floating point numbers / linear algebra operations into the DB

Hi Joe, I don't know if the speed will meet your needs, but you might test to see if PL/R will work for you: http://www.joeconway.com/plr/ You could use pg.spi.exec() from within the R procedure to grab the arrays, do all of your processing inside R (which uses whatever BLAS you've set

Re: [GENERAL] arrays of floating point numbers / linear algebra operations into the DB

Hi Colin, Il giorno 01/feb/08, alle ore 15:22, Colin Wetherbee ha scritto: I'm not sure about the internals of PostgreSQL (eg. the Datum object(?) you mention), but if you're just scaling vectors, consecutive memory addresses shouldn't be absolutely necessary. Add and multiply operations

[GENERAL] arrays of floating point numbers / linear algebra operations into the DB

Hello, I'd like to perform linear algebra operations on float4/8 arrays. These tasks are tipically carried on using ad hoc optimized libraries (e.g. BLAS). In order to do this, I studied a bit how arrays are stored internally by the DB: from what I understood, arrays are basically a vector

Re: [GENERAL] Oracle Analytical Functions

Hi Adam, Il giorno 31/gen/08, alle ore 16:13, Adam Rich ha scritto: I'm trying to replicate the use of Oracle's 'lag' and 'over partition by' analytical functions in my query. I have a table (all_client_times) such as: and I would like to create a new view that takes the first table and calcul

Re: [GENERAL] Oracle Analytical Functions

Hi Willem, Il giorno 30/gen/08, alle ore 22:15, Willem Buitendyk ha scritto: I'm trying to replicate the use of Oracle's 'lag' and 'over partition by' analytical functions in my query. I have a table (all_client_times) such as: client_id, datetime 122, 2007-05-01 12:00:00 122, 2007-05-01

[GENERAL] on delete rules returned rowcount

Hi, short summary of the problem follows :) I'm writing an on delete rule for a view and I need to set the status message (DELETE XXX) for number of deleted tuples. Is it possible? A brief, working use case follows: I have a view restricting the access to a table, as the following: create

Re: [GENERAL] pgsql constraints and temporal tables

Hi Tom! Tom Lane ha scritto: > Enrico Sirola <[EMAIL PROTECTED]> writes: >> However, I'm facing a problem I'm not able to solve with postgresql: >> usually updating or deleting time-varying data means to temporary >> violate a constraint in a transaction b

[GENERAL] pgsql constraints and temporal tables

teresting and electronic copies are available for free) and is willing to help. If interested, I can post an example here... Thanks, Enrico ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] index organized tables use case

Hello, I'm thinking about migrating from another DBMS to postgresql. I have an almost working proof of concept, but still have some doubts about the following use case. I have a table like the following CREATE TABLE test ( code character varying(32) NOT NULL, tag integer NOT NULL, value dou

[GENERAL] 8.3, a few questions

Dear all, I'd like to use the upcoming release 8.3 for my next project. When is it expected to be finalized? My deadline is 2nd quarter 2008, do you think there is a chance for me to use it? A second question (more technical). Is it possible to put an index on an xpath expression of an XML ty

Re: [GENERAL] COPY to/from non-local file

ys of the postgresql system user and you are done. You can transfer files without the need for a password, and it's perfectly scriptable I hope it helps, Enrico Sirola [EMAIL PROTECTED]

[GENERAL] copying indexes and f.keys from a template table

g. using a placeholder for the table name) or maybe one could use the information on Primary/foreign keys and indexes present also in the system tables so I guess one should be able to use it to build the PK/FKs and indexes on the partition tables. Any advice? Thanks in advance, Enrico Sir

Re: [GENERAL] table partitioning pl/pgsql helpers

ts of copy from). Thanks for the advices, Enrico Sirola [EMAIL PROTECTED]

Re: [GENERAL] [HACKERS] table partitioning pl/pgsql helpers

Il giorno 02/giu/07, alle ore 00:53, Jim Nasby ha scritto: Dropping -hackers; that list is for development of the database engine itself. ok, sorry e. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://w

[GENERAL] table partitioning pl/pgsql helpers

child_table_name is not a table name. If, on the other side, I dynamically create the query like in execute 'insert into ' || child_table_name || ' values (NEW.*)'; it complains because NEW in the execution context is unknown. This should be a rather common problem... Isn't it? Is there a canonical way to solve it? Maybe there's a trivial answer, but I have no plpgsql programming experience. Thanks a lot in advance, Enrico Sirola [EMAIL PROTECTED]

Re: [GENERAL] Index Scanning

On Wed, 03 Jan 2007 12:21:31 + Richard Huxton wrote: > Don't forget to cc the list Ok thanks :) > > If you issue "set enable_seqscan = off" before the query that should > force it to use the indexes first. What does that plan show you? I try and then I post t

[GENERAL] Index Scanning

an I do to have two ind. scan? Thanks in advantage. Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi --

Re: [GENERAL] Stripping kernel FreeBSD - postgres

> processors if you have them (a single CPU with hyperthreading most likely > will > not run as fast under an SMP kernel). Done > As far as any other tweeking, follow the directions here and don't do anything > http://www.freebsd.org/doc/en_US.ISO8859-1/books/arch-handbook/v

Re: [GENERAL] Stripping kernel FreeBSD - postgres

> http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html > Hi Bill I already read your link and it is not specific for Postgres, I'm searching for a more specific document. Regards, Enrico -- If Bill Gates had a penny for everytime Windows crashed,he&#x

[GENERAL] Stripping kernel FreeBSD - postgres

HI, I wish I optimize a kernel FreeBSD 6.1 on a server with only postgres installed. Where can I have any info about? Thanks in advantage. Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROT

Re: [GENERAL] can't start postgresql

ta". of course if want to use /usr/pgsql/bin/initdb -D /usr/pgsql/data directory /usr/pgsql/data must be empty and user postgres must be the owner, but I don't understand, what is your problem? Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billiona

Re: [GENERAL] can't start postgresql

On Tue, 14 Nov 2006 02:23:39 +0200 Igor Shevchenko <[EMAIL PROTECTED]> wrote: Try with: > [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data Bye Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look,

Re: [GENERAL] Datum problem

Thanks for your answeres. -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi ---(end of broadcast)-

[GENERAL] Which DatumGet ?

In my table I have a field myfied defined by myfield numeric(20,5); Which kind of DatumGet macro I have to use? Regards, Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now ...oh look, he already is [EMAIL PROTECTED] - Skype:ssco

Re: [GENERAL] Database Mirroring Solution

On Fri, 10 Nov 2006 13:42:14 +0200 Gideon <[EMAIL PROTECTED]> wrote: > We basicaly need to run a database servers in 2 different > towns. I suppose you can't use an HA solution. :( Regards Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a mu

Re: [GENERAL] Database Mirroring Solution

On Fri, 10 Nov 2006 13:24:18 +0200 Gideon <[EMAIL PROTECTED]> wrote: > Is anyone aware of any mirroring > solutions for > postgres ? Have yoy tried HeartBeat + DRBD for an HA solution? Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a mult

Re: [GENERAL] Linux vs. FreeBSD

now, but in my work I've seen that postgres with freeBSD is more faster than postgres and Linux, I used postgres with ext2 and ext3 filesystem. Postgres was written under BSD systems and under BSD filesystem. Regards, Enrico -- If Bill Gates had a penny for everytime Windows crashed,he&#x

Re: [GENERAL] Linux vs. FreeBSD

ffer better performace over the other when running > postgresql? > I had best performance on FreeBSD with his file system. Look at this link. http://www.postgresql.org/files/documentation/books/aw_pgsql/hw_performance/node11.html Bye Enrico -- If Bill Gates had a penny for everytime Windows

[GENERAL] Datum problem

Z. VEND. "",,PZ,32,1,20,""1 "","" "","""",N,,0,-67.0,-23.0,,N,N)",150) So postgresql outputs with a tuple, instead of an integer value as I wish. Can anyone helps me? Thanks in advant

[GENERAL] Need Help w/ Timestamps

it. E.g.: Windows Timestamp: 2006-09-08 15:25:42.332 Linux Timestamp: 2006-09-09 21:25:06.947069 Is there any way (even somehow through the ODBC driver) to restrict the timestamp accuracy to "M$ Win" accuracy? Thanks for your help! -Enrico ---(end of

[GENERAL] PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure

, for several reasons. Has anyone an idea on how or any pointer into the right direction to accomplish the above task? Thanks already in advance! -Enrico ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] faking writable views as tables

pg_class dangerous in any way ? cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED]

Re: [GENERAL] Foreign key to a view (UNION of two or more tables),

apping answer texts <-> ids. cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519

Re: [GENERAL] rule as on insert to view with multiple fk referencing the same table

also INSTEAD. (bacause writing to a shadow table is useless ?). cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.d

Re: [GENERAL] REFERENCES error message complaint, suggestion

s even worse since mysqldump's output does it exactly the wrong way: identifiers in '' and string constants in "" ... cu -- ----- Enrico Weigelt== metux IT services phone: +49 36207 519931

[GENERAL] something more about my question about performance

ow if it is possible, to improve performance, to make users access to different postgres servers, making access, for example, the user1 to the db1 on the server1, the user2 to db2 on the server2 and so on. If it possible, how can I do that? Thank you. Best. Enrico Mangano Netsoftware Division __

[GENERAL] Improve performance

Hello, i have one postgresql server (7.0) where several users access. Is there any way to improve performance for: i) accesses of different users at different dbs ii) accesses of different users at the same db Thanks.

[ADMIN]

Hello, i have one postgresql server (7.0) where several users access. Is there any way to improve performance for: i) accesses of different users at different dbs ii) accesses of different users at the same db Thanks.

[GENERAL] postgres length limitation query

Hello, is there any limit in the length of a query? What postgres does if I give it a query that is bigger? Thanks.

[GENERAL] Automatic Addslashes

I do copy tmp from '/home/algobit/product.txt tmp ia a table with one record (line varchar(255)) in product.txt I have many line as: 2;"100";"Parmigiano Reggiano";"Parmigiano Reggiano stagionato 2 anni";4;"parmigiano4.jpg";2;"Fette 1 Kg";0.18;1;1.00;"true" Then with "select * from tmp" the re

[GENERAL] MS-ACCESS -> PGSQL

I have a customer that works on a MDB database. There is a simple way to port data in the PGSQL database in his site (i use php) ?

[GENERAL] comunication between dbs

Hi, i'm searching for documentation about instruments that postgresql offers about distribution of databases on different machines and comunications beetwen the dbs.   Thank you.   Enrico Mangano   NETHOUSE S.r.l.Cso Re Umberto I, 57 - 10128 Torino - ITALYTel. +39-011-581.581 - Fax +3

[GENERAL] JDBC DRIVER

I 'm triyng to use JDBC driver with PostgreSQL, but I don't see the Indexes of the tables. Why ?

[GENERAL] CAST

Hi, how I have to change the next query ?   da_kg=Numeric a_kg =Numeric   cusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg < 3.5) and (a_kg >= 3.5));ERROR:  Unable to identify an operator '<' for types 'numeric' and 'float8'    You will have to retype this query using an explicit cast

[GENERAL] No Reload

t ALL tag and javascript but if (With Explorer) I request the url the browser reload the last visited. Enrico

[GENERAL]

Hi, Scuse me for the  OT. I'm interesting to obtain an effect like with ALT= in the image tag, but in a link like link There is a solution in Javascript ? Thanks, Enrico

[GENERAL] OT-Jscript

gg_quant(form_quant)\">   Why there isn't problem if I press Enter and with Tab I have Property or method not supported.   Thanks,     Enrico

[GENERAL] JDBC

Scuse me I am interesting in a COMPILED debugged version of JDBC driver for 7.02 (driver for J 1.2,1.2 and1.3). Thanks,     Enrico

[GENERAL] Driver

I'm searching for the SOURCES of JDBC DRIVER (for 7.02), precompiled driver have a bug. Thanks, Enrico

[GENERAL] JDBC

his who can suggest a fix?  Does anyoneknow if this is due to Jbuilder, the postgresql.Driver, or perhaps abad configuration?  Thanks. ENRICO

[GENERAL] test3

Scuse me, this is a test.

[GENERAL] test

prova

[GENERAL] Test

This is a test