Re: [GENERAL] plperl exception catching

On Wed, 13 Dec 2006, Tom Lane wrote: Marc Evans <[EMAIL PROTECTED]> writes: Is it accurate for me to believe that there is no way to catch exception within plperl? You do it the same way you trap any other error in perl ... OK, I must be missing something obvious: c3i=> CREATE O

Re: [GENERAL] plperl exception catching

On Wed, 13 Dec 2006, Martijn van Oosterhout wrote: On Wed, Dec 13, 2006 at 05:04:42PM -0500, Tom Lane wrote: Bricklen Anderson <[EMAIL PROTECTED]> writes: Marc Evans wrote: OK, I must be missing something obvious: ERROR: creation of Perl function failed: 'eval "str

[GENERAL] 8.2 server core dump

/wwwmaster.postgresql.org/system/handleform.php but no matter which of my several email addresses I attempted to use, the system always complained "The email address you entered does not appear to be valid." - Marc ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] creating functions with variable argument lists

On Fri, 8 Dec 2006, Tom Lane wrote: Marc Evans <[EMAIL PROTECTED]> writes: I am trying to make use of table partitions. In doing so I would like to use a rule to call a functioning which inserts the data into the proper partition. Basically, you're guaranteeing yourself large

[GENERAL] psql too noisy

any NOTICE lines output about things like "implicit sequence" and "implicit index" are suppressed. I have tried -q and -v VERBOSITY='terse' with no observed effect. Thanks in advance - Marc ---(end of broadcast)--- TIP

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

ents connected to the same DB using three schemas only takes 100 postmasters -- Vlad Using something like pgpool between the web servers and the DB should help with that scaling problem... - Marc ---(end of broadcast)--- TIP 1: if posting/readin

Re: [GENERAL] Clustering & Load Balancing & Replication

d semi-general purpose solution to is cross-data-center HA. As a result we are using very application specific techniques to try to address this, but the longer term maintenance we suspect will be high. How do others deal with this problem? - Marc ---(end of bro

Re: [GENERAL] Clustering & Load Balancing & Replication

On Tue, 26 Dec 2006, Ben wrote: On Dec 26, 2006, at 7:30 AM, Marc Evans wrote: What I have not been able to come up with a good semi-general purpose solution to is cross-data-center HA. Why does log shipping not work for you? Well, it may, but is short, I believe that this comes down to

Re: [GENERAL] printf-like format strings

audit_logs table contains at least these columns: audit_format_id BIGINT NOT NULL, msg_argsTEXT[], The audit_format_id is a reference into an audit_formats_table of sprintf format strings. You could easily simplify this to remove that indirection, if desired. - Marc

Re: [GENERAL] Modifying a foreign key constraint?

Whoops, ALTER TABLE foo ADD FOREIGN KEY (foo_bar_id_fkey) REFERENCES bar(id) ON DELETE CASCADE; should be ALTER TABLE foo ADD FOREIGN KEY (bar_id) REFERENCES bar(id) ON DELETE CASCADE; Sorry! Marc ---(end of broadcast

[GENERAL] Modifying a foreign key constraint?

N KEY (foo_bar_id_fkey) REFERENCES bar(id) ON DELETE CASCADE; Is there a more compact way to do this, perhaps with a single ALTER TABLE command? Thanks! Marc ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Modifying a foreign key constraint?

CASCADE; Doh! That's perfectly fine, of course. I was wondering if there might be something along the lines of an ALTER CONSTRAINT clause, which could change a specific aspect of a constraint without having to re-specify the whole thing. Marc --

[GENERAL] Database performance comparison paper.

Some people may find this interesting reading. http://us.devloop.org.uk/ - Marc ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Triggers inherited?

existing databases. - Marc On Thu, 22 Feb 2007, Bertram Scharpf wrote: Hi, it is very inconvenient for me that triggers aren't inherited: create table watch ( mod timestamp with time zone default '-infinity' not null ); create function update_mod() returns trigger ...

[GENERAL] Is there a shortage of postgresql skilled ops people

nce? Thanks in advance - Marc ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Granting privileges on views to group roles

I am having a hard time here with PostgreSQL 8.2.4... What I want to do is rather simple: I have two login roles, user_A and admin_A, and a group role, group_A. user_A is member of group_A I create a table t_data, owned by admin_A I create a view v_data, owned by admin_A Now I grant SELECT privi

[GENERAL] index and queries using '<' '>'

is much longer with a scan. How can I force the use of this index? -- Marc ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] index and queries using '<' '>'

uite uniform (it's not dependant on the size of the table), I hope that the statistics will evolve in a state that will force the use of the index. thanks -- Marc ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] index and queries using '<' '>'

g right now) less to use the index. Unfortunately I can't use this setting, the query being part of a larger query (joins), and the time gained on this particular index is partially lost on the joins. -- Marc ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] index and queries using '<' '>'

e statistics will evolve in a state that will force the use of the index. thanks -- Marc ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] default_index_tablespace?

Yeah, I could use that too :) I think that would be good in order to separate users on different disks easily (if this parameter could be set by user too ...) Le Jeudi 01 Décembre 2005 08:32, Alexander M. Pravking a écrit : > PostgreSQL 8.0 brought a great tablespaces feature. However, it's still

[GENERAL] copying a database without dumping it

om dump. Perhaps this will suffice. But I guess it's impossible for a dump to be as fast as a cp. So if a cp would be possible I would favour it. Oh, and did I tell: Everything have to be done tommorow. *sigh* Many thanks Marc ---(end of broad

Re: [GENERAL] copying a database without dumping it

On Donnerstag, Dez 15, 2005, at 12:11 Europe/Berlin, Tino Wildenhain wrote: Marc Brünink schrieb: Hi list, ... Now I'l try a custom dump. Perhaps this will suffice. But I guess it's impossible for a dump to be as fast as a cp. So if a cp would be possible I would favour it. O

Re: [GENERAL] I want to know how to improve the security of postgresql

e but I am prepared to work with any potential users to bring it up to a production release. __ Marc On Thu, 2005-12-29 at 06:48 -0400, [EMAIL PROTECTED] wrote: > Date: Thu, 29 Dec 2005 10:09:01 +0800 > From: "xiapw" <[EMAIL PROTECTED]> > To: > Subject: I want to kn

[GENERAL] Casting issue with aggregated function

select sum(c) from ( select sum(25665800) as c )foo     => 25665800 (numeric) I find the cast form int8 to numeric being strange. Cheers, Marc

Re: [GENERAL] I want to know how to improve the security of postgresql

ave any questions at all. I'd be pleased to help GNUmed. __ Marc On Sat, 2005-12-31 at 16:49 -0400, [EMAIL PROTECTED] wrote: > Date: Sat, 31 Dec 2005 17:18:19 +0100 > From: Karsten Hilbert <[EMAIL PROTECTED]> > To: pgsql-general@postgresql.org > Subject: Re: I want to kno

[GENERAL] bit/integer operations in postgres

If I understand this correctly, I think you want to implement the sort of security that Veil provides. Take a look at http://pgfoundry.org/projects/veil/ The documentation is at http://veil.projects.postgresql.org/curdocs/index.html __ Marc On Sun, 2006-01-01 at 17:02 -0400, littlebutty wrote

[GENERAL] PostgreSQL Arrays and Performance

with the other columns or merely as a pointer to another file? Would it be more efficient to not use an array for this purpose but split the table in two parts? Any help is appreciated! Marc Philipp ---(end of broadcast)--- TIP 1: if posti

Re: [GENERAL] Arrays and Performance

Sorry for the duplicate post! My first post was stalled and my mail server down for a day or so. I will reply to your original posts. Regards, Marc Philipp ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

Re: [GENERAL] Arrays and Performance

No, we don't get deadlock errors, but when running a vacuum and another process writing into the database there progress will stop at some point and nothing happens until one process is being killed. I think we used to vacuum every two nights and did a full vacuum once a week. Regards,

Re: [GENERAL] PostgreSQL Arrays and Performance

s. But there is not upper bound for their size. Regards, Marc Philipp ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PostgreSQL Arrays and Performance

rapidly increasing > database size. Can you tell me more about free-space map settings? What exactly is the free-space map? The information in the documentation is not very helpful. How can dead tuples leak? Regards, Marc Philipp ---(end of broadcast)--

[GENERAL] Privilege for seeing queries using pg_stat_get_backend_activity

there be a standard privilege that allows this (please say yes)? __ Marc signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Privilege for seeing queries using

ction public.pg_stat_get_backend_activity(integer) returns text as ' begin return pg_catalog.pg_stat_get_backend_activity($1); end; ' language plpgsql security definer; __ Marc On Thu, 2006-01-19 at 12:38 -0500, Tom Lane wrote: > Marc Munro <[EMAIL PROTECTED]> writes: > > I want certa

[GENERAL] altering objects owned by other user

argument set to true. Is this a horrible idea? Thanks. __ Marc signature.asc Description: This is a digitally signed message part

Re: [GENERAL] altering objects owned by other user

Tom, Thanks. Good suggestions, both. I'm going to defer this problem until we are able to upgrade. __ Marc On Mon, 2006-02-13 at 14:18 -0500, Tom Lane wrote: > Marc Munro <[EMAIL PROTECTED]> writes: > > I want to allow a non-superuser to alter objects owned by another user

Re: [GENERAL] [pgsql-general] Daily digest v1.5986 (24 messages)

avoid this sort of complexity if you can. Try reading the documentation though, it may give you some ideas. __ Marc On Sat, 2006-03-04 at 23:45 -0400, [EMAIL PROTECTED] wrote: > Date: 4 Mar 2006 05:08:27 -0800 > From: [EMAIL PROTECTED] > To: pgsql-general@postgresql.org > Su

Re: [GENERAL] Grant Priviliges on column

No, but Veil allows you do it: http://veil.projects.postgresql.org/ Be warned, implementing column or row-level privileges is not trivial. If you are sure you need to do it and want to try Veil, I'll give you what help I can. __ Marc On Fri, 2006-03-17 at 11:50 -0400, [EMAIL PROTECTED]

Re: [GENERAL] Thoughts on a Isolation/Security problem

would probably be based upon being a representative of a specific company or vessel. Taking the Veil approach you will need to modify your apps, only to the extent that they must identify the user on connection. If you are interested in using Veil, I would be pleased to help. __ Marc On Tue, 2006

[GENERAL] Spontaneous character encoding change?

t has been done with that database recently is a failed attempt to upgrade slony from 1.1 to 1.5. This was about 3 days before slony ran in to character set problems. I have looked through the logs and found nothing of interest. Any ideas? This is non-production, on PostgreSQL 8.0.3 __ Marc sig

[GENERAL] Need help with quote escaping in exim for postgresql

e solution, preferably in the bugzilla issue log referenced above. I'll monitor this thread for possible solutions and help, though. Any help would be greatly appreciated. Greetings Marc -- - Marc Haber | &

Re: [GENERAL] Need help with quote escaping in exim for postgresql

On Fri, Jul 07, 2006 at 04:53:14PM +0200, Martijn van Oosterhout wrote: > On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote: > > I am the maintainer of Debian's packages for exim4, a powerful and > > versatile Mail Transfer Agent developed in Cambridge and in wide us

Re: [GENERAL] Need help with quote escaping in exim for postgresql

Hi, On Fri, Jul 07, 2006 at 05:15:11PM +0200, Martijn van Oosterhout wrote: > On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote: > > From what I understand, the correct way would be to use > > PQescapeStringConn, but that function needs an established connection, > &

Re: [GENERAL] Need help with quote escaping in exim for postgresql

On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote: > I am the maintainer of Debian's packages for exim4, a powerful and > versatile Mail Transfer Agent developed in Cambridge and in wide use > throughout the Free Software Community (http://www.exim.org/). > > One of

[GENERAL] Something blocking in libpq_gettext?

=0xf7ce0074 "execute lock_games ( '100' )") at SQLInterface.cpp:138 Can anyone offer any solutions, suggestions, fixes? We cannot reproduce this at will, but are willing to provide more information when next it occurs. __ Marc signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Something blocking in libpq_gettext?

her information would be helpful? __ Marc signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Something blocking in libpq_gettext?

blem. We'll let you know when we have more. Thanks for the quick response. __ Marc signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Something blocking in libpq_gettext?

On Fri, 2006-08-25 at 15:43 -0400, Tom Lane wrote: > Marc Munro <[EMAIL PROTECTED]> writes: > > As near as we can tell, it looks like libpq blocked inside poll inside > > libpq_gettext. > > > #0 0xe405 in __kernel_vsyscall () > > #1 0x005a31d4 in pol

Re: [GENERAL] postgres array quoting

rray_upper}; my $i = 1; my @args; while ($i <= $nArgs) { $msg = spi_exec_query("SELECT msg_args[$i] FROM logs WHERE id = $id",1); push(@args,$msg->{rows}[0]->{msg_args}); $i++; } return sprintf $fmt,@args; $$ LANGUAGE plperl; - Marc ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] database replication

s assume a POP in the EU, US and JP). I am aware of bizgress, though am concerned that it doesn't really address the wide-area replication issue. It does address the HA aspect within a single POP quite nicely though. How do you deal with this, commerical or OSS? Thanks in advance for sugge

Re: [GENERAL] how many record versions

On Mon, 24 May 2004, David Garamond wrote: > Manfred Koizar wrote: > > You mean InnoDB cannot handle the load? > > Perhaps it's more appropriate to say that the disk becomes the bottleneck. Was this attempting to do each update in a separate transaction? If so, that is certainly expected, with w

[GENERAL] enumeration datatype in postgresql?

Is there an enumeration datatype in postgresql like the enum in mysql? Cheers, Marc ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] compiling the examples

4Szw.o(.text+0x28a): undefined reference to `PQclear' /tmp/ccAN4Szw.o(.text+0x296): undefined reference to `PQfinish' collect2: ld returned 1 exit status make: *** [testlibpq] Error 1 -- Best regards, Marc. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] compiling the examples

Tom Lane wrote: Marc Cuypers <[EMAIL PROTECTED]> writes: How do i make the examples in postgresql-7.3.3/src/test/examples/? "make" works for me, assuming that I'm doing it in a built directory tree. [ looks at 7.3 branch... ] Hm, it looks like there's a mista

[GENERAL] pg_dump error: cache lookup failed

Hi, I have a PostgreSQL 6.5.3 database server working flawlessly under Red Hat 6.1 However, when I try to use the pg_dump utility, I get this error: #pg_dump myDatabase > backup.db getTypes(): SELECT failed. Explanation from backend: 'ERROR: cache lookup for userid 201 failed __

Re: [GENERAL] Size Limit

One quick and dirty way could be to create symbolic links from files in pgsql/data/base to an equivalent folder on your respective disks. On Tue, 13 Jun 2000, Byron Joseph Bacaltos wrote: > Sir, > > I am currently using ingres and would like to migrate to postgres. > However the problem is that

RE: [GENERAL] Trigger with delete

2 things one, you need to enable plpgsql as a lang see http://www.postgresql.org/docs/programmer/xplang.htm#XPLANG-TITLE for details two , triggers need to call functions that return 'opaque'. so after delete add return NEW; -Original Message- From: Matthias Teege [mailto:[EMAIL PROTE

follow up RE: [GENERAL] Trigger with delete

you need to enable plpgsql AND use it as the lang of your function so LANGUAGE 'plpgsql'; thanks -Original Message----- From: Marc Britten Sent: Tuesday, June 20, 2000 10:11 AM To: 'Matthias Teege'; [EMAIL PROTECTED] Subject: RE: [GENERAL] Trigger with delete 2 thin

[GENERAL] boolean isn't boolean?

and i have to check for $myarray[3] == 't' if i want to check for a true value? why? i just need to know that there was some actual logic behind this. thanks, marc britten

[GENERAL] pg_dump error

Hello, with pg_dump testdb > db.out there is an errorline getTypes(): SELECT failed. Explanation from backend: 'ERROR: cache lookup for userid 201 failed any Idea marc

Re: [GENERAL] Some advanced database features, are they present in PostgreSQL

On Tue, 10 Oct 2000, Peter Eisentraut wrote: > Will be in 7.1. [ ... ] > Something like this has recently been announced as add-on from PostgreSQL, [ ... ] > That has been available for quite a while. [ ... ] So, those are very good news. Thanks, and keep the good work.

[GENERAL] CREATE FUNCTION LANGUAGE C

Hi, CREATE FUNCTION LANGUAGE C (and maybe others) allow to load shared libraries. However the path can be specified arbitrarily by the user. Is that a way for a user X to gain the UID rights of the user running the postmaster ?

Re: [GENERAL] True ACID under linux (no fsync)?

On 31 Oct 2000, Gary Howland wrote: > Just a quickie - I heard that linux does not have a working fsync() call At least the manpage for fsync says that it does. The implementation: /* .. finally sync the buffers to disk */ dev = inode->i_dev; return sync_buffers(dev, 1)

Re: [GENERAL] Some problem on the data base server !

On Mon, 20 Nov 2000, Mickaël Jouanne wrote: > We had a database server on Mysql and we move to postgres last month. Not enough. You need to specify the exact version, and also the version of your operating system. Let's assume Linux. > 'load average: 3.23' or some times higher than that. Who i

Re: [GENERAL] Can PostGreSQL handle 100 user database?

On Thu, 30 Nov 2000, The Hermit Hacker wrote: > Note that this is a Linux limitation ... and even then, I'm not quite sure > how accurate that is anymore ... the *BSDs have supported >2gb file > systems for ages now, and, since IBM supports Linux, I'd be shocked if > there was a 2GB limit on memo

Re: [GENERAL] Help me for "DBI->connect failed: Sorry, too many clients already."

On Tue, 19 Dec 2000, Joseph wrote: > $dbh=DBI->connect("dbi:Pg:dbname=$dbname",$dbusername,$dbpassword) or die "can I would assume that if you never disconnect and are running under mod_perl, you will have problems.

[GENERAL] MD5 use in PL/Perl

I'd like to be able to only store the database of usernames and passwrods here locally as a md5 hash. (in case the black hats come to visitI'd like to make life hard for them) Using AuthPG, I should be able to create a SQL call to postgresbut there is no native md5 hashing function. In

Re: [GENERAL] Problem with inheritance

On Fri, 26 Jan 2001, Alfonso Peniche wrote: > user > | >-- >|| > student employee Why not store the common data between student and employee in user, and then store the additional data for student and employee in the relation itsel

Re: [GENERAL] Re: Problem with inheritance

On Fri, 26 Jan 2001, Alfonso Peniche wrote: > I like the idea, there's just one problem, a user can be both a student and an > employee... - If the guy is an user only, then just fill the user template - If the guy is a student, add a tuple to the is_student relation. - If the guy is an employee

[GENERAL] Search engine doesn't work

Hi, I wanted to try in the archives how to store a md5sum best in a database (origin is 16 bytes binary, if I don't get a good answer I will use ASCII like the output of the md5sum UNIX command since this is easy to debug). I got this error: Not Found The requested URL /mhonarc/pgsql-general/se

Re: [GENERAL] Re: Slowdown problem when writing 1.7million records

> Server (v6.2), I am accessing the files using JDBC from a Windows 2000 PC. I don't use Microsoft software, nor Java, but a few general suggestions for you: - you may want to create the INDEX at the end (using CREATE INDEX) in one operation - you may want to run your requests in trans

[GENERAL] Determine Time in other Time Zone

it. Does anyone know have an idea how I can solve this problem? Would anyone else be able to use this functionality? Marc Wrubleski Sorex Software Inc. Calgary, Alberta, Canada 1 (403) 371-7598 ---(end of broadcast)--- TIP 1: subscribe and u

[GENERAL] update tables in remote db using trigger

Hi all, I would like to do something like the following in a trigger: update tablename on otherdbhost set field1 = new.field1 where keyfield = new.keyfield; Is this a pipe dream using Postgres or is there some way to perform such a feat? Thanks. Marc Wrubleski

Re: [GENERAL] update tables in remote db using trigger

calls per second without bringing the system to it's knees? Marc Rod Taylor wrote: > Simplest way I know of is to write a C function which fires off a > shell script which in turn executes psql with appropriate parameters. > The C function can pass it individual variables, or the

Re: [GENERAL] Why Size Of Data Backed Up Varies Significantly In SQL 6.5?

On Thu, 26 Apr 2001, Wendy wrote: > I backed up a database at night and noted the size to be about over 300MB. Backuped with pg_dump, or dumped the raw database files ? In the latter case you want to stop the PostgreSQL server first. > The following morning, I again backed up the same database

[GENERAL] ER diagrams

Hi, do you know of a tool which could be used to easily generate entity-relationship diagrams (with integrity constraints, etc), in LaTeX for example ? This is a bit unlinked with PostgreSQL but I hope you won't hit me :) Thank you. ---(end of broadcast)---

Re: [GENERAL] COPY INTO and the SERIAL data type

On Thu, 10 May 2001, Jonathan Sand wrote: > I want to use the COPY command to read a bunch of data files. These > files don't contain an id, so I want to use the SERIAL data type to > auto-number the generated rows. COPY complains. Destination table: CREATE TABLE destination (id SERIAL, truc

Re: [GENERAL] debian packages for Postgresql 7.1 or higher ?

On Wed, 16 May 2001, Alex wrote: > Are there any debian packages for Postgresql 7.1 or higher for Potato? > I've tried to get the src-deb from unstable (7.1.1) but it won't compile > under potato, not unless I upgrade the perl packages as well, which is not > my idea. http://people.debian.org/~e

[GENERAL] Kylix dbexpress driver ?

I have read somewhere that a driver for kylix and postgresql was in development. When will it be released ? Thanks. -m- ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAI

[GENERAL] How to have a autoincrement field?

essen = Egenberger Marc[EMAIL PROTECTED] Leimbachstr. 56Tel 01/4802800 8041 ZuerichFax 01/4802801 =

[GENERAL] Still the problem with the autoincrement field

s', 'Rheinhalter Claudio', 'flexibilitaet', 'gutes Team'); I get a: ERROR: pg_atoi: error in "Maurer": can't parse "Maurer" How do I add data, so that the id field is autoincremented? -- mit freundlichen Gruessen = Eggenberger Marc[EMAIL PROTECTED] Leimbachstr. 56Tel 01/4802800 8041 ZuerichFax 01/4802801 =

[GENERAL] Problem with \copy

rn on something like "debugging mode" so that I get more infos than just "broken pipe"? -- mit freundlichen Gruessen = Inside Electronic Online www.ieo.ch Eggenberger Marc[EMAIL PROTECTED] Leimbachstr. 56Tel 01/480

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

provides functionality that Oracle *doesn't* have, right? Marc G. Fournier [EMAIL PROTECTED] Systems Administrator, Acadia University "These are my opinions, which are not necessarily shared by my employer"

[GENERAL] attribute level rules not supported?

ted What am I doing wrong? I've read and re-read chapter 8 - rules from the postgresql programmer's guide, but I can't see why this rule doesn't work. Any suggestions would be appreciated. Marc

[GENERAL] pg_dump: couldn't find the template1 database.

abase. Thanks in advance, Marc

[GENERAL] another questoin about COPY

like to double-check with the mailing list. Thanks, Marc

[GENERAL] max row size

datatype and make sure the total size is <5k or use a varchar(5120)? Marc

Re: [GENERAL] upgrade postgreSQL

pg_database; remove one of the two template1 tables by using the oid. Good luck, Marc On Wed, 26 Jan 2000, Matthias Zehnder wrote: > I got the file <<.patch>> and tried to upgrade postgres > sous FreeBSD with the command patch from the version 6.5.2 to > the version 6.5.3 but i

[GENERAL] reverse sorting

like: select email from table1, table2 where table1.oid=table2.id order by table2.reverse_domain; I'm not sure if keeping a secondary table is worthwhile, I will only be executing this query about 50 times per day. Let me know if there's a better way, Marc Tardif

[GENERAL] ERROR: heap_delete: (am)invalid tid

done something wrong? Marc Tardif

Re: [GENERAL] max query length

I think there is no maximum on the actual query length, but there is a limit on the max row size. If I remember correctly, there is an 8k limit to the contents of an entire row. If you need more than that, either split your data across multiple rows are use the blob data type. Marc On Fri, 4

Re: [GENERAL] using ID as a key

esql using triggers. An example of this is available in the contrib/spi directory, look for refint.* Marc On Fri, 4 Feb 2000, sheila bel wrote: > Hi, > > I'm new to data base design so please bare with me if my > question is so basic.. > I'm designing a database,

[GENERAL] splitting tables into db's

between each database. This can obviously cause a problem, so are there any recommended ways to have a form of load balancing with postgresql? Marc

Re: [GENERAL] advice on indexing email

Regarding your first suggestion, I cannot use a trigger since the actual email contents will not be inserted in the database because of the 8K limit on text fields. Instead, I will be keeping the messages as a seperate file and only keep the pathname in the database. As for your second suggestion

Re: [GENERAL] refint.sql

Those are all the files you need. First, run gmake in contrib/spi and you'll notice two more files are created: refint.so refint.sql Also, take note that referential integrity on postgresql 6.5.3 works by using triggers. So you must first CREATE FUNCTION which is detailed in refint.sql which, in

[GENERAL] Using array_agg in pgr_kdisjkstrpath() error

::integer[]  as id from n2) AND '{28411,25582}' Thanks Marc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Using array_agg in pgr_kdisjkstrpath()

::integer[] as id from n2) AND '{28411,25582}' Thanks Marc-André Marc-André Goderre Analyste en informatique [LOGO-FINAL-1_Mini.png] Courriel: magode...@cgq.qc.ca<mailto:magode...@cgq.qc.ca> Tel.: (418) 698-5995 poste 1628 Téléc.: (418) 698-4108 Cégep de Chicoutimi, 534 rue Jacques-C

[GENERAL] function returning a merge of the same query executed X time

ber() over() as id, sum(cost) as total_cost,sum(length) as total_length,json_agg(row_to_json(r)) as data from (select * from cm_get_loop_route_4(2, 10, -73.597070, 45.544083))r)q return next jsona end loop; return jsona; Marc -- Sent via pgsql-general mailing l

Re: [GENERAL] function returning a merge of the same query executed X time

cm_get_loop_route_4(2, 10, -73.597070, 45.544083))r)q CROSS JOIN generate_series(1, 3) the quey is executed only 1 time. Thanks Marc De : gwinkl...@gmail.com [mailto:gwinkl...@gmail.com] De la part de Geoff Winkless Envoyé : 22 avril 2015 11:22 À : Marc-André Goderre Cc : 'pgsql-general@postgresql.org&#x

[GENERAL] Invalid memory alloc

142645362  pgr_createtopology   FAIL (1 row) The server has a 10Gb of shared_buffer. Do you thing this quantity of memory allowed should normaly be enough to process the data? Thanks Marc -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

<    1   2   3   4   5   6   7   8   >