[GENERAL] Unable to access table named "user"

2009-05-12 Thread Joe Kramer
Hi, I have table named user (lower case) in public schema. I can access it using Pgadmin as SELECT * from "user"; SELECT * from "public.user"; SELECT * FROM public.user; I can't find any way to access this table from Jdbc. Tried to access as public.user, user in single and double quotes, nothing

Re: [GENERAL] Unable to access table named "user"

2009-05-12 Thread Joe Kramer
Don't help either. Jdbc statement: SELECT * from "public"."user" ; Exception: ERROR: relation "public.user" does not exist On Tue, May 12, 2009 at 5:55 PM, Scott Marlowe wrote: > On Tue, May 12, 2009 at 1:26 AM, Joe Kramer wrote: >> Hi, >>

[GENERAL] vacuuming slow

2005-02-22 Thread Joe Maldonado
and fix something I've missed. Thanks all, Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] vacuuming slow

2005-02-22 Thread Joe Maldonado
Tom Lane wrote: Joe Maldonado <[EMAIL PROTECTED]> writes: Can concurrent updates/deletes slow down vacuum when it is progressing ? I mean to ask if vacuum would have to redo or stall its work because of the updates/deletes. Is it even possible that it goes into a long loop while such u

[GENERAL] view/pgpgsql functions bug

2005-02-23 Thread Joe Maldonado
After a create or replace view, the new view definition is not being used by plpgsql functions that use the view. Is this a known bug ? Is there a workaround it ? For instance, selecting from afunc() still returns the old view's results. create table c ( a int ); create or replace view a as select

Re: [GENERAL] Emacs and postgres

2005-02-23 Thread Joe Healy
else has tricks/plugins for emacs users. I have used sql-postgres mode in the past, under both emacs and xemacs. It is quite good. Haven't got it working currently under windows, I think I need to tell it where i have a psql binary. Joe ---(end of broa

Re: [GENERAL] Emacs and postgres

2005-02-23 Thread Joe Healy
Joe Healy wrote: Sean Davis wrote: This is a bit off-topic Does anyone know of an interface between emacs and psql? I currently use it as my default editor and do my share of save and then \i. I just gave pgEdit a try and liked many aspects of it, but I still like Emacs as an editor and

Re: [GENERAL] view/pgpgsql functions bug

2005-02-25 Thread Joe Maldonado
Tom Lane wrote: Joe Maldonado <[EMAIL PROTECTED]> writes: After a create or replace view, the new view definition is not being used by plpgsql functions that use the view. Is this a known bug ? Is there a workaround it ? Start a fresh backend session. The old query plan is pres

Re: [GENERAL] partitionning

2005-03-10 Thread Joe Conway
nheritance for DIY table partitioning on very expensive storage hardware (~$500K), and we'd be dead in the water without it. Joe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] pg_atributes index space question

2005-03-18 Thread Joe Maldonado
Hello, After a VACUUM FULL I saw that pg_attribute tables indexes haven't been deleted as reported by a subsequent vacuum analyze. But the pages corresponding to just the table has been deleted to 196 pages from about 181557 pages. Are all system tables affected by this ? How can we reclaim thi

[GENERAL] truncate/create slowness

2005-03-31 Thread Joe Maldonado
2 pages DETAIL: 114 dead row versions cannot be removed yet. There were 2546542 unused item pointers. 0 pages are entirely empty. CPU 0.32s/0.28u sec elapsed 0.67 sec. INFO: analyzing "pg_catalog.pg_class" INFO: "pg_class": 49182 pages, 1290 rows sampled, 1290 estimated total rows VACUUM -Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] DNN Postgres Data Provider

2005-03-31 Thread Joe Audette
There is a .NET data provider that I know of but its not specific to DNN in any way. It can be used in any .NET project http://gborg.postgresql.org/project/npgsql/projdisplay.php   Best Regards,   Joe AudetteRandy How <[EMAIL PROTECTED]> wrote: Our company is moving toward developi

Re: [GENERAL] plPHP in core?

2005-04-02 Thread Joe Conway
't my problem, so it falls on Joe and Thomas to get up to speed on what I've been doing and do likewise. Is that really a win? So far we've been able to keep up with PostgreSQL changes because a) the interfaces are after all pretty well defined, and b) there is always a long

Re: [GENERAL] array_append not working

2005-04-05 Thread Joe Conway
ou need to assign the result of array_append() to a variable. It doesn't change v_query_array in place. Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTE

[GENERAL] Filesystem options for storing pg_data

2005-04-20 Thread Joe Maldonado
ta to be able to optimize performance and still have some fault tolerance. -Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Migrating MySQL app to postgres?

2005-04-25 Thread Joe Healy
//www.reportlab.org/rl_toolkit.html) very easy to create pdf reports based on queries. Hope this helps, Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] info on strange error messages on postgresql

2005-04-28 Thread Joe Maldonado
are these 2 sets of messages related and second what would cause either or both sets of messages to appear in the log? Appreciate any help :) -Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] info on strange error messages on postgresql

2005-04-29 Thread Joe Maldonado
Tom Lane wrote: >Joe Maldonado <[EMAIL PROTECTED]> writes: > > >>I have these messages on my 7.4.7 database log... >>TopMemoryContext: 87494704 total in 10676 blocks; 179400 free (61 >>chunks); 87315304 used >>TopTransactionContext: 57344 total in 3 bl

Re: [GENERAL] Postgres filling up hard drive with swap files

2005-04-29 Thread Joe Lester
http://archives.postgresql.org/pgsql-general/2004-08/msg00972.php This bug appears to be fixed in Tiger (Mac OS 10.4). That's great, if it's really true. Can anyone confirm? ---(end of broadcast)--- TIP 7: don't forget to increase your free space m

[GENERAL] Changing column data type on an existing table

2005-05-13 Thread Joe Audette
least familiar to me but I am trying to learn. Any help much appreciated. Joe Audette joe_audette [at] yahoo dotcom http://www.joeaudette.com http://www.mojoportal.com ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

Re: [GENERAL] Postgres 8.0.3 Fedora RPMS ?

2005-05-22 Thread Joe Conway
Devrim GUNDUZ wrote: Our FC2 x86_64 bit FC2 packager (Joe Conway) is on a long trip; I'm not sure that we will be able to prepare RPMs for that arch/distro right now :( I got back finally last night, and I'm just now at 9 days behind in reading the list traffic, but I should

Re: [GENERAL] Postgres 8.0.3 Fedora RPMS ?

2005-05-24 Thread Joe Conway
Joe Conway wrote: I got back finally last night, and I'm just now at 9 days behind in reading the list traffic, but I should be able to build x86_64 FC3 RPMs in the next day or two (unless someone has beat me to it). Unfortunately I no longer have an x86_64 FC2 machine available t

Re: [GENERAL] Test for array slice?

2005-06-03 Thread Joe Conway
of a really good way to do that directly in Postgres, but I'd bet (still not sure though) there is a way in R. http://www.r-project.org/index.html If so, you could use PL/R: http://www.joeconway.com/plr/ HTH, Joe ---(end of broadcast)---

Re: [GENERAL] info on strange error messages on postgresql

2005-06-16 Thread Joe Maldonado
k 2005-04-21 22:30:47 [21315] ERROR: current transaction is aborted, commands ignored until end of transac tion block we're suspecting pg_autovacuum as being the culprit but cannot nail it down quite yet. -Joe > > >>followed by about 16GB of the following type of entries... >

[GENERAL] Web application development on Win32, deployment on Linux

2005-06-27 Thread Joe Abbate
t Search capability is based on MySQL's full-text search functionality [SELECT ... WHERE MATCH (...) AGAINST (... IN BOOLEAN MODE)] . PostgreSQL doesn't appear to have something resembling that. I'm curious as to third-party solutions or development plans. Joe

[GENERAL] ERROR: cache lookup failed for relation 438095645

2005-07-06 Thread Joe Markwardt
on that table, and on all the indexes on any tables referenced by foreign keys. OS and Version info below, more info available upon request. Does anyone have any suggestions on how to fix this? Thanks, Joe select version();

Re: [GENERAL] ERROR: cache lookup failed for relation 438095645

2005-07-06 Thread Joe Markwardt
On Wed, 2005-07-06 at 11:20 -0400, Tom Lane wrote: > Joe Markwardt <[EMAIL PROTECTED]> writes: > > I am getting this error "ERROR: cache lookup failed for relation > > 438095645" when i try to run "drop table > > pl_inventory_analyzer_files_table ;&qu

Re: [GENERAL] ERROR: cache lookup failed for relation 438095645

2005-07-06 Thread Joe Markwardt
On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote: > Joe Markwardt <[EMAIL PROTECTED]> writes: > >>> I am getting this error "ERROR: cache lookup failed for relation > >>> 438095645" when i try to run "drop table > >>> pl_invent

Re: [GENERAL] ERROR: cache lookup failed for relation 438095645

2005-07-07 Thread Joe Markwardt
On Wed, 2005-07-06 at 23:36 -0400, Tom Lane wrote: > Joe Markwardt <[EMAIL PROTECTED]> writes: > > On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote: > >> They appear to be triggers for a foreign-key constraint between > >> pl_inventory_analyzer_files_table and

[GENERAL] gborg down

2005-07-14 Thread Joe Healy
Hi apache test page is showing at 2005-07-15 09:00 AEST. Joe. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] TRUNCATE locking problem

2005-07-18 Thread Joe Maldonado
transactions to finish before truncating the table thus blocking all other operations. Is this what is actually going on or am I missing something else? and is there a way to prevent this condition from happening? Thanks in advance, - Joe Maldonado ---(end of broadcast

Re: [GENERAL] TRUNCATE locking problem

2005-07-18 Thread Joe Maldonado
Thanks...I just wanted to verify that it was the intended behaviour prior to going in and changing code :) - Joe Maldonado Tom Lane wrote: Joe Maldonado <[EMAIL PROTECTED]> writes: It seems that TRUNCATE is first posting a lock on the table and then waiting for other transacti

Re: [GENERAL] TRUNCATE locking problem

2005-07-21 Thread Joe Maldonado
SELECT in the FROM clause which in turn is joining with a view that contains the table which TRUNCATE is being executed against. Is it possible that the SELECT was issues just before the TRUNCATE statement was issues and the view in the sub SELECT was waiting on TRUNCATE's lock?

Re: [GENERAL] TRUNCATE locking problem

2005-07-21 Thread Joe Maldonado
Tom Lane wrote: Joe Maldonado <[EMAIL PROTECTED]> writes: While researching this locking issue I got some of the logs and found that in one of the cases there was a SELECT running for a long time, about 2 hours. This select statement does not usually take more than a few seconds

Re: [GENERAL] Questions about Views, Rules and DBLink

2005-07-31 Thread Joe Conway
tely far removed from the operation your rule is firing for. When it was added (and discussed on the lists) it was also acknowledged that it would not be useful in all situations. However, there was at least one use case where it worked as intended and needed. Joe ---(

[GENERAL] not quite expected behaviour when using IN clause

2005-09-30 Thread Joe Maldonado
ual time=0.002..0.002 rows=0 loops=1) One-Time Filter: NULL::boolean ->  Seq Scan on test  (cost=1.00..10020.38 rows=826 width=0) (never executed)    Filter: (("key")::text <> 'something'::text)  Total runtime: 0.110 ms (6 rows) -- Joe Maldonado

Re: [GENERAL] searching array

2005-10-16 Thread Joe Conway
+--- Bill | {1,1,1,1} | {{meeting,lunch},{training,presentation}} (1 row) Care to provide some more info? What version of Postgres are you using, what is the exact SQL that is failing, and what is the error message you

Re: [GENERAL] searching array

2005-10-17 Thread Joe Conway
mp WHERE 1 >= ALL (pay_by_quarter); You are asking for matches where 1 is greater than or equal to all the elements in the array. In Carol's case 1 is less than all the elements -- hence no match. Joe ---(end of broadcast)--

Re: [GENERAL] PG 8.0.4, Centos and 64 bit

2005-10-17 Thread Joe Conway
ou all the necesarry information. I will have several RHEL 4 servers by early November, and will be building RPMs for them. I'll let you know when I have RPMs ready. Joe ---(end of broadcast)--- TIP 3: Have you checked our extensive

[GENERAL] vacuuming strangeness

2005-10-31 Thread Joe Maldonado
given the aggressive nature of the statement it is not something I want to do on a high transaction db unless I absolutely must. Thanks in advance, -- Joe Maldonado OUPUT: db=# vacuum verbose test_table; INFO:  vacuuming "public.test_table" INFO:  "test_table": removed 13

Re: [GENERAL] Built in function question

2005-11-02 Thread Joe Conway
nt_setting --- /usr/local/pgsql-8.0/data (1 row) Joe ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Array Values and References

2005-11-03 Thread Joe Conway
field types don't exactly match? (i.e. int vs int[]) A trigger perhaps? Joe ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Looping through arrays

2005-11-04 Thread Joe Conway
; return; end; $$ language plpgsql; regression=# select testfoo_func(id) from testfoo; testfoo_func -- (2 rows) regression=# select * from testfoo_det; id | elem +-- 1 | AA 1 | BB 1 | CC 1 | DD 2 | EE 2 | FF 2 | GG 2 | HH (8 rows) HTH, Joe ---

Re: [GENERAL] Aggregates, group, and order by

2005-11-07 Thread Joe Conway
bar_id | array_accum +- 1 | {alpha,bravo,charlie,delta} 2 | {A,B,C,D} (2 rows) HTH, Joe ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Detect Locked Row Without Blocking

2005-11-08 Thread Joe Lester
Is there a recommended "postgres way" to determine if a certain row is locked... without blocking? In my custom postgres client app I'd like to be able to determine if another user is "modifying" a given record. If so, I would present a dialog to the user such as "Record Locked. Sam Smith is a

Re: [GENERAL] Detect Locked Row Without Blocking

2005-11-08 Thread Joe Lester
ck would help any in this circumstance... and I don't want to resort to table locks for performance reasons. On Nov 8, 2005, at 10:14 AM, Tom Lane wrote: Joe Lester <[EMAIL PROTECTED]> writes: In my custom postgres client app I'd like to be able to determine if another user is &

Re: [GENERAL] Multi-parameter aggregates.

2005-11-21 Thread Joe Conway
Berend Tober wrote: I'm stuck on not knowing how to define a aggregate that takes more that one variable as its argument This is currently unsupported. Joe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] How to trim Bytea fields

2005-11-22 Thread Joe Conway
ld that work for you? select trim('\\000'::bytea from '\\00012\\00034\\000\\000'::bytea); btrim -- 12\00034 (1 row) Joe ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Set Returning Function (Pipelining)

2005-11-22 Thread Joe Conway
r than 7.3). My question is now wether the result is returned linewise in an newer version I'm afraid not. But are you sure you need pipelining? Joe ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] pgAdmin III v1.6 Beta 1 Released

2006-09-21 Thread Joe Kramer
Thank you for Mac OSX Universal support at last ! Now the last PowerPc application is gone Universal on my Mac. Pgadmin now 4 times faster as Universal on Intel! Thanks for your great work! On 9/14/06, Dave Page wrote: I'm pleased to announce the first beta version of pgAdmin III v1.6.0 is ava

Re: [GENERAL] Dead Lock problem with 8.1.3

2006-09-26 Thread Joe Conway
ing veraid = 2 and veraid = 34 might help. While the query is running, how much CPU is the process consuming, and what does vmstat show for disk and swap I/O? Joe ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore yo

Re: [GENERAL] Dead Lock problem with 8.1.3

2006-09-27 Thread Joe Conway
nning, how much CPU is the process consuming, and what does vmstat show for disk and swap I/O? ~80% CPU power. Disk usage is not noticable. Can you attach with a debugger and see exactly what's going on? If not we'd need that self contained test case to rep

[GENERAL] Is it possible to return custom type as proper ROW?

2006-10-11 Thread Joe Kramer
Pgsql 8.1.4. I want return custom type from function as row, not as values in brackets (1,2). I have following type and function: CREATE TYPE new_item_return_type AS (item_id bigint, last_update timestamp without time zone); CREATE OR REPLACE FUNCTION new_item( new_title int8, new_user_id

[GENERAL] timestamp as primary key?

2006-10-19 Thread Joe Kramer
Hello, I have table for online chat system that keep messages sent between users. CREATE TABLE chat_message ( message_time timestamp without time zone NOT NULL DEFAULT now(), message_body text, user_id_from bigint, user_id_to bigint, CONSTRAINT chat_message_pkey PRIMARY KEY (message_time) )

Re: [GENERAL] R and postgres

2006-11-07 Thread Joe Conway
t projects. What is the Right Thing for a guy who wants R to talk to postgresql? I think you want this: http://bioconductor.org/packages/1.9/bioc/html/RdbiPgSQL.html The bioconductor project is now maintaining RdbiPgSQL. I think many people also use RODBC to connect R with Postg

Re: [GENERAL] R and postgres

2006-11-07 Thread Joe Conway
Reece Hart wrote: On Tue, 2006-11-07 at 00:22 -0800, Joe Conway wrote: I think you want this: http://bioconductor.org/packages/1.9/bioc/html/RdbiPgSQL.html The bioconductor project is now maintaining RdbiPgSQL. I think many people also use RODBC to connect R with Postgres. I almost sent you

Re: [GENERAL] connectby usage question

2006-11-15 Thread Joe Conway
need to write another function to do this? There is no support for this in connectby, but I imagine it wouldn't be too hard to hack connectby to do it for you. Probably much easier to do that than try to add it with another function. Joe ---(end of broa

Re: [GENERAL] Any form of connection-level "session variable" ?

2007-01-04 Thread Joe Conway
shion, use this: http://www.joeconway.com/sessfunc.tar.gz http://www.onlamp.com/pub/a/onlamp/2004/06/28/postgresql_extensions.html HTH, Joe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Array constructor requires one argument

2007-01-09 Thread Joe Conway
cussion on this topic: http://archives.postgresql.org/pgsql-hackers/2003-06/msg01195.php Unless we can convince ourselves that array-of-UNKNOWN is not dangerous, I don't think this is easily solved. Joe ---(end of broadcast)--- TIP 9: In ver

[GENERAL] Automated backups for PG running on Windows Server?

2007-02-18 Thread Vacuum Joe
Quick question: I have installed PG 8.2.x on a customer's system and we will be storing a lot of critical data on it. It needs to be backed up maybe twice a day. It's very easy to back data up with the pgadmin tool (great tool btw) but we need an automated solution that we can configure. This

Re: [GENERAL] How to force planner to use GiST index?

2007-03-07 Thread Joe Healy
mp;& (inside bounding box) is able to use the gist index, whilst the exact contains is not able to. Hope that helps, Joe ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Matrix (linear algebra) operations and types in PG?

2007-03-25 Thread Joe Conway
, I tried to contact the author to see if he'd be willing to allow me to pull out just the stuff I need and release it under a BSD license along with my code, but he did not reply. Joe ---(end of broadcast)--- TIP 4: Have you s

Re: [GENERAL] Interpolation of environment variables in SQL at runtime?

2004-10-31 Thread Joe Conway
Use it like this: select value from plr_environ() where name = 'MANPATH'; value ------- /usr/local/pgsql-dev/man: (1 row) Joe ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

Re: [GENERAL] MD5 for PostgreSQL 7.3.4

2004-11-03 Thread Joe Conway
Tk421 wrote: I'm looking for a function that returns a md5 encryption for postgreSQL 7.3.4 I've found that this function exists on version 7.4, but I have had problems installing it on my Windows XP with Cygwin, so I need to found it for version 7.3 See contrib/pgcrypt

Re: [GENERAL] MD5 for PostgreSQL 7.3.4

2004-11-03 Thread Joe Conway
ype is here the algorithm to use. E.g. 'md5', 'sha1', ... Returns binary hash." Joe ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] VACUUMING questions...

2004-11-04 Thread Joe Maldonado
Hello all, I have a few somewhat simple questions Does the postmaster vacuum it's internal (pg_*) tables? if not what is the best way to vacuum them without having to vacuum the entire db? and how often is this recommended to be done? Thanks, -Joe ---(e

[GENERAL] rc1 fedora core rpms

2004-12-03 Thread Joe Conway
As promised, I've posted 8.0.0rc1 rpms here: http://www.joeconway.com/postgresql-8.0.0rc/ Again note that these are not "official" PGDG rpms, just my own home brew. In addition to the change of Postgres itself from beta5 to rc1, I updated jdbc to latest beta (pg8

Re: [GENERAL] How can I expand serialized BLOBs into pseudo columns

2004-12-04 Thread Joe Conway
val1, (expandobj(obj)).val2, * from mytable; val1 | val2 | id | obj --+--++- x| y| 1 | x,y (1 row) HTH, Joe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] [ADMIN] plperl loading

2004-12-13 Thread Joe Conway
into postgresql source ? See: http://www.postgresql.org/docs/current/static/runtime-config.html and search for "preload_libraries" HTH, Joe ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if y

Re: [GENERAL] Join on virtual table

2004-12-11 Thread Joe Conway
5 | 3 6 | 0 (6 rows) BTW, as of 8.0.0, generate_series() is built in. HTH, Joe ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Merging Data from Multiple DB

2005-01-03 Thread Joe Conway
e sequence, lookup the local unique identifier from the table defined in #1, and pass them both to the function defined in #2. 4. Use nextrowid('seq_name') to generate your primary keys. HTH, Joe ---(end of broadcast)--- TIP 9: the planner wil

Re: [GENERAL] Global/persistent variables

2005-01-06 Thread Joe Conway
u might be able to fake it with some C functions. See: http://www.joeconway.com/myfunc.tgz Look at myfunc_setvar(), myfunc_getvar(), and myfunc_rmvar(). HTH, Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [GENERAL] Global/persistent variables

2005-01-08 Thread Joe Conway
e end of the session. For arrays, it shouldn't be too terribly difficult to extent the code to handle them. Joe ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Function for retreiving datatype

2005-01-10 Thread Joe Conway
2. $0 is initialized to null and can be modified by the function, so it can be used to hold the return value if desired, though that is not required. $0 can also be given an alias." http://www.postgresql.org/docs/7.4/interactive/plpgsql-declarations.html#PLPGSQL-DECLARATION-ALIASES Joe * search t

Re: [GENERAL] Réf. : [GENERAL] Debugging

2005-01-13 Thread Joe Conway
[EMAIL PROTECTED] wrote: Aren't there any way to debug server programming functions (whatever the language) ?? What's wrong with gdb? Joe ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index sc

Re: [GENERAL] Windows 2000 Slower Than Windows XP

2005-01-22 Thread Joe Audette
try putting an entry in the hosts file on the slow machine to resolve the name of the db machine and see if that helps. I'm no expert on Postgre SQL so maybe there is a driver difference or something that others on the list would know better. Hope that helps, Joe --- Quinton Lawson &l

Re: [GENERAL] question about porting least and greatest from oracle

2005-01-29 Thread Joe Conway
://archives.postgresql.org/pgsql-general/2004-08/msg01017.php HTH, Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to

Re: [GENERAL] Postgresql and Macintosh

2005-02-09 Thread Joe Lester
onths ago, but it has not seen any activity yet. Joe On Feb 9, 2005, at 1:35 AM, John DeSoi wrote: On Feb 9, 2005, at 10:39 AM, renato.barrios wrote: Please tell me if Postgresql runns in an iMac. Sure, assuming your iMac is running OS X. You'll need to install Apple's free developer t

Re: [Pgsqlrpms-hackers] Re: [GENERAL] DBlink documentation

2005-12-17 Thread Joe Conway
e docs back into the README if that's what you want, but I split it up in the first place because it was getting very long. Joe ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] MDX support in postgresql

2005-12-31 Thread Joe Conway
e.net/ It should work with Postgres (as well as other JDBC datasources). Microsoft is purportedly pushing MDX as a standard. Here's a discussion of the MDX language: http://mondrian.sourceforge.net/mdx.html HTH, Joe ---(end of broadcast)

Re: [GENERAL] PostgreSQL Arrays and Performance

2006-01-03 Thread Joe Conway
inserting new rows, you should probably rethink your data model. Would it be more efficient to not use an array for this purpose but split the table in two parts? I think so. Joe ---(end of broadcast)--- TIP 1: if posting/reading through Usenet

Re: [Pgsqlrpms-hackers] Re: [GENERAL] DBlink documentation

2006-01-03 Thread Joe Conway
Tom Lane wrote: Joe Conway <[EMAIL PROTECTED]> writes: I'm happy to lump all the docs back into the README if that's what you want, but I split it up in the first place because it was getting very long. No, I'm not really proposing that we force all contrib modules

Re: [GENERAL] Drop database/create database broken in 7.4?

2006-01-05 Thread Joe Conway
what might be happening? I'm at a loss. Sounds like those two tables were created in the template database at some point. HTH, Joe ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Suse Linux 10.0

2006-01-05 Thread Joe Audette
I installed from rpms after adding some sources to YaST based on this article http://www.thejemreport.com/mambo/content/view/178/42/ Not sure its the absolute latest version of postgres. Hope it helps, Joe joe_audette [at] yahoo dotcom http://www.joeaudette.com http://www.mojoportal.com

Re: [GENERAL] Arrays and Performance

2006-01-06 Thread Joe Conway
-01/msg00104.php http://archives.postgresql.org/pgsql-general/2006-01/msg00108.php Did you not receive those replies? Joe ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Seeking comments on schema design and data integrity

2006-02-12 Thread Joe Conway
http://www.xtoss.org/ HTH, Joe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] psql is slow and it does not take much resources

2006-05-03 Thread Joe Healy
stdin;" -h %s' % (dbname, user, table, host), "w") for a in f: unpackline = a[:-1].split(delimiter) easting, northing, elevation = unpackline process.write("SRID=%s;POINT(%s %s)\t%s\n" %( SRID, easting, northing, elevation))

[GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-05-09 Thread Joe Kramer
Hello,Pgcrypto SHA 256/384/512 algorithm don't work on RedHat: db=# SELECT digest('test', 'sha1');     digest --  \251J\217\345\314\261\233\246\034L\010s\323\221\351\207\230/\273\323 (1 row) db=# SELECT

Re: [GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-05-09 Thread Joe Kramer
to compile openSSL 0.9.8." Pgcrypto depends on OpenSSL 0.9.8. And 0.9.8 is not "Stable" in RedHat and Gentoo. So you need to recompile pgcrypto/openssl anyway if you want to use it. Can I report this in PostgreSQL bug system? Regards.On 5/9/06, Marko Kreen <[EMAIL PROTECTED]&g

Re: [GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-05-09 Thread Joe Kramer
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote: On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> Thanks, but I need it to work out-of-the-box, with standard installation of> RedHat or Gentoo and standard PostgreSQL rpm. >>  I am developing application with PortgreSQL a

Re: [GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-05-09 Thread Joe Kramer
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote: On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:> > The fact that Fedora pgcrypto is linked with OpenSSL that does not > > support SHA256 is not a bug, just a f

Re: [GENERAL] GUI Interface

2006-05-19 Thread Joe Kramer
We've been using EMS PostgreSQL admin.Pros:It has great visual tools for building views. Like in Enterprise manager or MS Access. pgAdmin don't have that.Great import/export abilities. PGAdmin don't have much flexibility. Cons:Too bad it don't support UNICODE and not known if it will.Problems with

[GENERAL] Best practice to grant all privileges on all bjects in database?

2006-05-19 Thread Joe Kramer
Hello, I need to grant all privileges on all objects in database. Without using SUPERUSER. It's strange that GRANT ALL PRIVILEGES ON DATABASE is useless, it don't grant privileges on tables. I've found out this "best practice", (more like ugly workaround): select 'grant all on '||schemaname||'

Re: [GENERAL] Best practice to grant all privileges on all bjects in database?

2006-05-22 Thread Joe Kramer
/20/06, John DeSoi <[EMAIL PROTECTED]> wrote: You can find some helpful grant scripts here: http://pgedit.com/tip/postgresql/access_control_functions On 5/19/06, Joe Kramer <[EMAIL PROTECTED]> wrote: > Hello, > > I need to grant all privileges on all objects in data

Re: [GENERAL] Free 1000 Rupee bank note

2006-05-29 Thread Joe Kramer
What the hell is Rupees? On 5/29/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote: Hi there, Help me by taking this survey. We can both get 1000 Rupees! Click here: http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2 ---(end of broadcast)--

Re: [GENERAL] What is the point of create or replace view command

2006-06-04 Thread Joe Conway
replace view v1 with a different WHERE clause create or replace view v1 as select * from t1 where 1 = 2; HTH, Joe ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] pgcrypto sha256/384/512 don't work on Redhat. Please help!

2006-06-07 Thread Joe Kramer
If it was commited to HEAD, it will appear in 8.1.5, right? On 5/30/06, Bruce Momjian wrote: Patch applied to CVS HEAD and 8.1.X. Thanks. --- Marko Kreen wrote: > On 5/9/06, Joe Kramer <[EMAIL PROTECTED]&

Re: [GENERAL] Dynamic loading of C functions: Badly stuck

2006-06-21 Thread Joe Conway
de/pgsql/server/test_func": No such file or directory Should 'usr/include/pgsql/server/test_func' actually be '/usr/include/pgsql/server/test_func'? Note the leading '/' HTH, Joe ---(end of broadcast)--- TIP 9: I

Re: [GENERAL] Dynamic loading of C functions: Badly stuck

2006-06-21 Thread Joe Conway
What does ls -l /usr/include/pgsql/server/test.so show? Does the postgres user (or whomever postgres is running as) have the ability to read the file? Joe ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] aggregate of bitstrings

2006-06-22 Thread Joe Conway
avior of strict functions.) In any case the final function has the option of returning a null value. For example, the final function for avg returns null when it sees there were zero input rows." HTH, Joe ---(end of broadcast)--- TIP 5: don&

<    1   2   3   4   5   6   >