[GENERAL] Postgres 8.2 database recovery Could not create relation Invalid Argument

2009-07-27 Thread Justin Alston
Novice here :). I have PostgreSQL 8.2 installed on a single board computer running Windows XP Embedded on a Compact Flash drive - 2 databases with no more than 2000 ro. After 10 power cycles spaced 6 mins apart, I noticed the postgres.exe processes no longer running. I located log file (see below)

Re: [GENERAL] Best practices for moving UTF8 databases

2009-07-22 Thread Justin Pasher
procedure that searches for invalid characters was posted a few years back that attempts to find the invalid characters. http://archives.postgresql.org/pgsql-hackers/2005-12/msg00511.php http://svana.org/kleptog/pgsql/utf8_verify.sql -- Justin Pasher -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Justin Graf
mailto:db.subscripti...@shepherdhill.biz at 07-05-2009 07:14:49 AM -- Quoting justin jus...@emproshunts.com: CHM has not been packaged for as long as i know of with PgAdmin.. Justin, Are you sure? Windows help file CHM has been the default help file that pgAdmin opens when you click

Re: [GENERAL] Pls help

2009-07-04 Thread justin
Scott Marlowe wrote: On Fri, Jul 3, 2009 at 10:02 PM, Roseller A. Romanosdon2_...@yahoo.com wrote: Note that this could be a permissions problem. All the files need to belong to whatever user postgres runs as. If the destination PG install successfully started before there will be no

Re: [GENERAL] Documentation - PgAdmin

2009-07-04 Thread justin
db.subscripti...@shepherdhill.biz wrote: Hi, Congratulations on the release of version 8.4. I am surprised that pgAdmin's help link is now directed to the documentation website of postgresql. The embedded help CHM was not packaged with it. This implies that anytime one needs

Re: [GENERAL] 64 Bit ODBC Drivers for windows

2009-06-29 Thread Justin Graf
use the .net provider http://npgsql.projects.postgresql.org/ I'm not sure of a 64bit build. although a 32bit version should run on 64 bit windows without any problems. Message from mailto:drewtimm...@gmail.com Andrew Timmins drewtimm...@gmail.com at 06-29-2009 05:36:58 PM -- Is

Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function

2009-06-28 Thread Justin
APseudoUtopia wrote: thread, then logs out (intending to read all the other forum threads at some point in the future when they log in again). If I used a VIEW, it would automatically consider all those unread forum posts to be read when the user logs out. That wouldn't work. What if

Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function

2009-06-27 Thread justin
APseudoUtopia wrote: Hey list, I have a query which allows users to "Catch up" on read posts on the forum. It works by either updating or inserting the "last post read" number from every forum thread into the readposts table (for that userid and threadid combination, of course). Here's the

Re: Fwd: [GENERAL] Date math

2009-06-27 Thread Justin
Adam Rich wrote: Guy Flaherty wrote: You could use the extract() function to calculate the day of year of the person's birthdate and then check if this number is within today's day of year and range of days you want to check for, for example, today's day of year + 30 days to be within a

Re: [GENERAL] Please suggest me on my table design (indexes!)

2009-06-23 Thread justin
DaNieL wrote: Hi guys, im tryin to optimize a simple table, suited for contain users. So, my table at the moment is: - CREATE TABLE contacts( id BIGSERIAL PRIMARY KEY NOT NULL UNIQUE, company_id BIGINT, code varchar(10), company_name varchar(120), name varchar(120), surname

Re: [GENERAL] postgresql-8.3.7 unexpected connection closures

2009-06-19 Thread justin
Craig Ringer wrote: On Fri, 2009-06-19 at 01:03 -0400, Tom Lane wrote: I see lots of questions here that seem to be related to (a) virus scanner interference and (b) installation/reinstallation. Lots of the reinstall issues seem to be with people who don't really understand NT users,

Re: [GENERAL] postgresql-8.3.7 unexpected connection closures

2009-06-19 Thread justin
Pavel Stehule wrote: 2009/6/19 Leif B. Kristensen l...@solumslekt.org: nobody needs Windows. But Postgres has only one reputation. Problems on windows are PostgreSQL's problem too. And there are some native windows firms that starts develop with Postgres. And this people expecting

Re: [GENERAL] used for large media files

2009-06-17 Thread justin
Steve Atkins wrote: On Jun 17, 2009, at 8:43 AM, Mike Kay wrote: Now that's an interesting way of doing this I never thought about before. Using a fileserver though, how would I categorize and index the files? I was planning on using multiple databases to hold the data - one for each

[GENERAL] ruby connect

2009-06-01 Thread Justin Carrera
Hi, I'm trying to connect ruby to postgres on ubuntu and the only link I found that has the library is down. Does anyone have the postgres library for ruby? Or direct me to it?

Re: [GENERAL] Adding automatic backup of a DB

2009-05-04 Thread justin
Moe wrote: Hi, How can I add automatic backup easily? Is it possible with pgadmin ? Also, I would like to know whether those options (Blobs(checked), OIDS, Insert Commands, Disable Quoting is for) .. as it is now, it works great without them. Thanks in advance /

Re: [GENERAL] Rounding problems

2009-05-03 Thread Justin
Paolo Saudin wrote: Hi, I have a problem with a query wich simple aggregate values. In the sample below I have two values, 1.3 and 1.4. Rounding their average with one decimals, should give 1.4. The first query with - cast( tables_seb.tbl_arvier_chamencon.id_1 AS

Re: [GENERAL] keeping track of function execution

2009-05-03 Thread justin
Wojtek wrote: Hi, I have a question on transactions/isolation levels/etc... In my PL/pgSQL function main loop goes through inventory list of active devices, for each one executing processing applicable for given device, like: FOR i in --i is %rowtype select device_id as device_id, type

Re: [GENERAL] Number Conversion Function

2009-04-13 Thread justin
Tino Wildenhain wrote: justin wrote: I disagree the database is the wrong place, there are cases it makes sense. Which cases would that be? Regards Tino Report engines that don't have this ability . I use for check writing. To come think, I don't know of UI framework or report

[GENERAL] Querying a Large Partitioned DB

2009-04-10 Thread Justin Funk
and suggestions about how to speed this up? It seems like a smart query planner would understand the rules and know that it should search in the last partitions first, since it is ordering by device reported time. Thanks! justin

Re: [GENERAL] Internationalization

2009-04-10 Thread Justin
Pedro Doria Meunier wrote: Hi all, I'm wondering how to internationalize contents of a table, short of having a column for each language string ... Anyone with some experience to share? :) Regards, Pedro Doria Meunier How about parent child table layout. The child table has one record for

Re: [GENERAL] Is it possible for PostgreSQL to support mmddyyyy date format?

2009-04-08 Thread Justin
This is from the link 1/8/1999 January 8 in MDY mode; August 1 in DMY mode 1/18/1999 January 18 in MDY mode; rejected in other modes 01/02/03 January 2, 2003 in MDY mode; February 1, 2003 in DMY mode; February 3, 2001 in YMD

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-07 Thread justin
Steve Crawford wrote: Did I miss the exciting conclusion or did this drift silently off radar? it was pretty well split between the options. tabled for another time. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Number Conversion Function

2009-04-07 Thread justin
Tom Lane wrote: Tino Wildenhain t...@living-examples.com writes: I would not recommend to do this within the database. Thats typical a job for your presentation layer. ... but having said that, I think the "money" datatype has a function for this. Whether that's of

Re: [GENERAL] strange behavior of plpgsql function

2009-04-04 Thread Justin
I think i may be the way the function is being called?? if you are doing Select fnvs.docrelatedassociatedetails() it will not return any records, it needs to be Select * From fnvs.docrelatedassociatedetails() c k wrote: Hi all, I am facing a small but strange problem when using a plpgsql

[GENERAL] Retain PREPARE or connect trigger

2009-04-01 Thread Justin Funk
. Or is there another option like PREPARE that persists? Thanks for your help. Justin Funk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Retain PREPARE or CONNECT TRIGGER

2009-04-01 Thread Justin Funk
. Or is there another option like PREPARE that persists? Thanks for your help. Justin Funk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-01 Thread justin
Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark st...@enterprisedb.com wrote: On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason s...@samason.me.uk wrote: string_to_array('',',')::INT[] = invalid

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-01 Thread justin
If someone can show me a real world example this logic simplifies the code and has more uses I'll bite I just presently can't see how this works better. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-01 Thread Justin
Martin Gainty wrote: Split strings into array elements using provided delimiter string_to_array('xx~^~yy~^~zz', '~^~') output: {xx,yy,zz} http://www.postgresql.org/docs/8.3/interactive/functions-array.html Sorry thats not the question i'm asking. We are debating if it makes

Re: [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
Sam Mason wrote: I'd expect 3,2,1 and 1. That's also a disingenuous example; what would you expect back from: select count_elements(string_to_array('butter,,milk',',')) I think the semantics you want is what you'd get from: array_filter_blanks(string_to_array($1,$2)) where I defined

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
Sam Mason wrote: string_to_array('',',')::INT[] = invalid input syntax for integer: Which you don't get at the moment; although you do currently get it in other common cases such as: string_to_array('1,',',')::INT[] If you want backwards compatible behaviour you could always bung a

Re: [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
Greg Stark wrote: On Tue, Mar 31, 2009 at 5:48 PM, justin jus...@emproshunts.com wrote: But consider this fails also select string_to_array('1, , 3', ',' )::int[] = ERROR: invalid input syntax for integer: " " yet this works select string_to_array('1, 2, 3'

Re: [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
This thread being cross posted has made it a bit confusing Greg Stark wrote: Nobody has ever suggested filtering out empty elements or dealing specially with spaces or anything else like that. If you're talking about that then you've missed the original question. "Does anyone want

Re: [GENERAL] PL/PGSQL arithmetic errors

2009-03-30 Thread Justin
Just because a result is unexpected does not mean its an incorrect result. No postgresql follows the order of operations as expected. Now looking at the 2 For loops the First does not have a where clause and the Second has a Where not null this could be the cause of the problem. Another

Re: [GENERAL] string_to_array with empty input

2009-03-30 Thread Justin
Tom Lane wrote: I agree this seems less than consistent though, especially seeing that you *don't* get a null for a zero-length separator, which if anything is a more poorly defined case. I doubt it'd be a good idea to back-patch a change for this, but I could see altering the definition for

[GENERAL] Partitioned tabled not using indexes for full text search

2009-03-27 Thread Justin Funk
I have a table that is partitioned on a daily basis. Full text searches used to be respectably fast with large tables (40 million + records) but insert speed would slow down. So I went with a partitioned approach. But now, it doesn't seem like the indexes are being used. Any idea why it would

Re: [GENERAL] Garbage Collecting

2009-03-23 Thread justin
Joshua Berry wrote: I'm a postgresql newbie that's inherited eight production servers running Postgresql 8.2.5 as the backend. I have many questions covering topics such as administration of the database (upgrading, maintaining conf files, etc), improving the schema of the system (many tables

Re: [GENERAL] Running Postgresl in a virual machine

2009-03-17 Thread justin
Richard Sickler wrote: Hello, I am creating a small web app that uses Postgres. The number of hits/day will be small, maybe a 1000 pages/day. I'm planning on running this in a virtual machine, (Windows Server 2008 with the virtual machine hosting Postgres running Windows Server 2003 R2

Re: [GENERAL] [ask] Return Query

2009-03-15 Thread Justin
ataherster wrote: hai all, i'm trying create function like this CREATE OR REPLACE FUNCTION penjualan(idcb integer) RETURNS SETOF penjualan AS but this function is not work with this error : ERROR: structure of query does not match function result type CONTEXT: PL/pgSQL function penjualan

Re: [GENERAL] nulls

2009-03-12 Thread justin
Both ways will work. Setting the superseded_after to a far off future will work but will have to set to a real date when it actual does become superseded. The same is true for nulls It boils down to how you and the users want to look at the data. To me to get the all the records that has

Re: [GENERAL] mdf

2009-03-09 Thread justin
There are a couple of tools that will open an MDF file buy you have to pay for them http://www.sqldatabaserepair.com/ http://www.mssqldatabaserecovery.com/ Another option is you need to learn how the MSSQL server is setup, and what version. Get your hands on that Version of SQL install it

[GENERAL] Get IP addresses from tsvectors

2009-03-09 Thread Justin Funk
'n29c3q08020087':1 'kgan...@iastate.edu':4 into IP_ADDRESSES - 65.110.236.113 10.10.94.126 Thanks for the help... Justin Funk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] foxpro, odbc, data types and unnecessary convertions

2009-02-26 Thread Justin
Fernando Moreno wrote: Hi all, I'm using visual foxpro 9 -not my decision- for a client application. Statements are writen as the typical sql string and sent through ODBC. i like foxpro it has its quirks as do all languages. Only concern if this is a new app Foxpro has been killed by

Re: [GENERAL] foxpro, odbc, data types and unnecessary convertions

2009-02-26 Thread justin
Completely forgot take a look at Cursor Adapter Class, also any cursor in foxpro can be made be updateable with CURSORSETPROP( ) function removing the problem of writing Update's and Inserts Fernando Moreno wrote: Hi all, I'm using visual foxpro 9 -not my decision- for a client

[GENERAL] Postgres SRPMs for RHEL

2009-02-25 Thread Justin Pasher
Is there a reason why the source RPMs for PG 8.1.16 on RHEL don't show up here? http://www.postgresql.org/ftp/binary/v8.1.16/linux/srpms/redhat/rhel-4-i386/ If I cycle through the versions, the last version in the 8.1 branch I can find with source RPMs is 8.1.14. -- Justin Pasher -- Sent

Re: [GENERAL] Postgres SRPMs for RHEL

2009-02-25 Thread Justin Pasher
Joshua D. Drake wrote: On Wed, 2009-02-25 at 12:10 -0600, Justin Pasher wrote: Is there a reason why the source RPMs for PG 8.1.16 on RHEL don't show up here? http://www.postgresql.org/ftp/binary/v8.1.16/linux/srpms/redhat/rhel-4-i386/ If I cycle through the versions, the last version

Re: [GENERAL] Postgres SRPMs for RHEL

2009-02-25 Thread Justin Pasher
Devrim GÜNDÜZ wrote: On Wed, 2009-02-25 at 12:10 -0600, Justin Pasher wrote: Is there a reason why the source RPMs for PG 8.1.16 on RHEL don't show up here? http://www.postgresql.org/ftp/binary/v8.1.16/linux/srpms/redhat/rhel-4-i386/ 'cause I was a bit lazy to sync srpms from main

Re: [GENERAL] Remote Connection

2009-02-12 Thread justin
Bob Pawley wrote: Hi I've been operating on localhost successfully for some time. I am now attempting to access a Postgresql 8.3 database installed on one of my other computers conneted through a router. Is this possible? My first attempts have been with

[GENERAL] Continual increase of age(datfrozenxid) for template0

2009-02-10 Thread Justin Pasher
. Thanks. -- Justin Pasher -- 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] How do I turn on query logger?

2009-02-06 Thread justin
Jennifer Trey wrote: I am new to postgreSQL and I am running queries from JAVA and would like to see what queries are being run. How can I achieve that ? I am running PostgreSQL 8.3 on Windows and like using pgAdmin to do most things. Open PG admin from the menu bar Tools-Server Status-

Re: [GENERAL] debugging plpgsql functions

2009-02-04 Thread justin
Chris wrote: Hi all, I have a few plpgsql functions to debug to see why they are slow. They consist of a bunch of sql statements using new.* / old.* variables (ie not using EXECUTE, the sql is being called directly). Is there a way to capture the actual sql that's being executed with

Re: [GENERAL] calculating elapsed times between timestamps

2009-02-02 Thread justin
rhubbell wrote: (posted on novice too, no idea what difference is between lists) I have been trying to do this and have been unsuccessful so far. I have a table: perf: timestamp = timestamp with time zone timeelapsed = numeric bobble = text timeelapsed records are the time elapsed

[GENERAL] compiling libpq.lb into qsqlpsql.dll

2009-01-27 Thread justin
Hello all. I have a problem and tech support at troll tech has been unable to help me resolve. I am trying to compile libpq.lib from postgresql 8.3.5 into QT's version 4.4.3 qsqlpsql.dll. using Visual Studio 2008 Built libpq.lib and libpq.dll with no problesm using nmake. Now comes time to

Re: [GENERAL] performance advice needed: join vs explicit subselect

2009-01-27 Thread justin
Karsten Hilbert wrote: Hello all, maybe some general advice can be had on this: table test_results modified_by integer foreign key staff(pk), intended_reviewer integer foreign key staff(pk), actual_reviewer integer foreign key staff(pk) (this table will contain

Re: [GENERAL] performance advice needed: join vs explicit subselect

2009-01-27 Thread justin
typo sorry justin wrote: Karsten Hilbert wrote: Hello all, maybe some general advice can be had on this: table test_results modified_by integer foreign key staff(pk), intended_reviewer integer foreign key staff(pk), actual_reviewer integer foreign key staff(pk) (this table

Re: [GENERAL] Rollback of Query Cancellation

2009-01-27 Thread justin
Abdul Rahman wrote: Dear All, Yesterday I canceled a running query because it was taking long time (more than 12 minutes) to delete lots of records. Today when I executed the same query it hardly took few seconds to finish. It clearly explores that PostgreSQL does not perform rollback

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-17 Thread Justin Pasher
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Saturday, January 17, 2009 9:50 AM To: Alvaro Herrera Cc: Justin Pasher; pgsql-general@postgresql.org Subject: Re: [GENERAL] Autovacuum daemon terminated by signal 11 Alvaro Herrera alvhe...@commandprompt.com

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-16 Thread Justin Pasher
(in particular that must have happened to AutoVacMain). In any case, it's very hard to see how MemoryContextAlloc would dump core unless the method pointer of the context it was pointed to was clobbered. So I'm pretty sure that's what happened, and now we must work backwards to how it happened, Justin, it's

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-16 Thread Justin Pasher
Tom Lane wrote: Justin Pasher just...@newmediagateway.com writes: I recompiled from the Debian source package and added --enable-cassert (--enable-debug was already there). I replaced the Debian standard packages with the recompiled versions and started up the cluster. Now it is hitting

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-16 Thread Justin Pasher
in autovac_start () at autovacuum.c:174 #13 0x081b7f78 in ServerLoop () at postmaster.c:1269 #14 0x081b8bad in PostmasterMain (argc=3, argv=0x836b508) at postmaster.c:943 #15 0x08175609 in main (argc=3, argv=0x836b508) at main.c:265 Justin Pasher -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-15 Thread Justin Pasher
Richard Huxton wrote: Justin Pasher wrote: Hello, I have a server running PostgreSQL 8.1.15-0etch1 (Debian etch) that was recently put into production. Last week a developer started having a problem with his psql connection being terminated every couple of minutes when he was running

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-15 Thread Justin Pasher
Tom Lane wrote: Justin Pasher just...@newmediagateway.com writes: Richard Huxton wrote: Segmentation fault - probably a bug or bad RAM. It's a relatively new machine, but that's obviously a possibility with any hardware. I haven't seen any other programs experiencing problems

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-15 Thread Justin Pasher
Tom Lane wrote: Having debug symbols would be more useful, but unless the binary is totally stripped, a backtrace might provide enough info without that. Try it and see if you get any function names in the trace, or only numbers. (BTW, does Debian have anything comparable to Red Hat's debuginfo

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-15 Thread Justin Pasher
(in particular that must have happened to AutoVacMain). In any case, it's very hard to see how MemoryContextAlloc would dump core unless the method pointer of the context it was pointed to was clobbered. So I'm pretty sure that's what happened, and now we must work backwards to how it happened, Justin, it's

[GENERAL] Autovacuum daemon terminated by signal 11

2009-01-14 Thread Justin Pasher
to ensure that age(datfrozenxid) stays low, but I'd like to understand what would be causing this. Justin Pasher -- 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] [PGSQL 8.3.5] Use of a partial indexes

2008-12-30 Thread justin
Reg Me Please wrote: Only one question remains in my mind: why the planner is not using the partial index? The partial index is covering 2 predicates out of the 3 used in the where condition. Actually there is a boolean flag (to exclude disabled rows), a timestamp (for row age) and an int8

Re: [GENERAL] need some help with pl-pgsql

2008-12-24 Thread justin
justin wrote: Adrian Klaver wrote: - justin jus...@emproshunts.com wrote: So it appears that something is causing _wipvalue to get set to NULL somewhere else in the code. Now when running the failing select statement manually works is because the modified record is still

[GENERAL] need some help with pl-pgsql

2008-12-23 Thread justin
have a function written in pgsql it runs just fine, except its doing something really stupid. The function runs just fine till this select statement Select (wo_wipvalue/wo_qtyord) into _TotalCost from wo where wo_id = pWoid ; This goes to the work order header table

Re: [GENERAL] need some help with pl-pgsql

2008-12-23 Thread justin
Adrian Klaver wrote: On Tuesday 23 December 2008 1:04:49 pm justin wrote: have a function written in pgsql it runs just fine, except its doing something really stupid. The function runs just fine till this select statement Select (wo_wipvalue/wo_qtyord) into _TotalCost

Re: [GENERAL] need some help with pl-pgsql

2008-12-23 Thread justin
Adrian Klaver wrote: On Tuesday 23 December 2008 3:36:46 pm Adrian Klaver wrote: Hmmm. A couple of suggestions while I ponder this more. For clarity sake decide on a case scheme. I start getting twitchy when I see pwoid and pWoid refer to the same thing. This depends on case folding being

Re: [GENERAL] need some help with pl-pgsql

2008-12-23 Thread justin
Adrian Klaver wrote: - justin jus...@emproshunts.com wrote: Adrian Klaver wrote: Would help to see the whole function. Also make sure you did not name one of the variables the same as a column name, this will confuse plpgsql. Are you using the same value for wo_id in the function

Re: [GENERAL] Syntax error with select statement

2008-12-17 Thread justin
aravind chandu wrote: Hello, I have problem with select statement in c++ program I am using pqxx library to connect to postgresql database.My query is result R(T.exec( select * from dbtable where username = ' +user+ ' and password = ' +st+ ' )); here st is in

[GENERAL] Eweek-Sun-Monty-MySQL

2008-12-04 Thread justin
Eweek Article above is article on eweek discussing Monty's blog on the poor shape MySql 5.1 is in

Re: [GENERAL] returns numbers of record

2008-12-02 Thread justin
Select Count(*) from (query) is what i believe you are looking for see http://www.postgresql.org/docs/8.3/interactive/tutorial-agg.html Enrico Pirozzi wrote: Hi all, does it exists a way to know how many records a query returns? I thought sometime like DECLARE curs1 CURSOR FOR select *

Re: [GENERAL] Monty on MySQL 5.1: Oops, we did it again

2008-12-01 Thread justin
Geoffrey wrote: Grzegorz Jaśkiewicz wrote: On Mon, Dec 1, 2008 at 8:00 PM, Steve Crawford [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html All interesting, but especially the part about

Re: [GENERAL] Favorite Tom Lane quotes

2008-12-01 Thread justin
Tom Lane wrote: Scott Marlowe [EMAIL PROTECTED] writes: We really need a favorite Tom Lane quotes thread. Mine is (roughly): We don't support that, but you're free to try it, you just get to keep both pieces if it breaks. Hate to disillusion you, but that's a standard

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
salman Sheikh wrote: Hi freinds, i wanted to add my all tables once in MFC application, i have a databank,which has 11 tables and i want to add them all togather.  After Adding all tables, it shows me always this errors by debugging.

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
in postgresql? In MS access i can add table once without any problem. sheikh Von: "justin" [EMAIL PROTECTED] Gesendet: 02.11.08 01:23:15 An: salman Sheikh <[EMAIL PROTECTED]> CC: pgsql-general@postgresql.org,

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
database.But if i add 2 or more tables togather,then it shows this error, i dont know why? sheikh Von: "justin" [EMAIL PROTECTED] Gesendet: 02.11.08 01:48:04 An: [EMAIL PROTECTED] Betreff: Re: [GENERAL] Error in Adding All Tables

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
the Select statement is change the Joining argument salman Sheikh wrote: Hi Justin thanks for helping me, But can i ask u ,have u ever worked with Visual C++ 2005.It does every thing automatically,u just click on the button it will generats all classes, for example View class, document class Set

Re: [GENERAL] Error in Adding All Tables

2008-11-01 Thread justin
http://www.postgresql.org/docs/8.3/interactive/libpq.html there more work involved. salman Sheikh wrote: HI justin actually i am newbie in this field,thatwhy i dont have much knowledge it. Now i understand the problem,but i am using MFC classes,as i told u it generates automatically, do u

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

2008-10-29 Thread justin
小波 顾 wrote: Data Compression MSSQL 2008 technots . Your results depend on your workload, database, and hardware Sounds cool but i wonder what real world results are?? For IO bound systems lots of pluses but for CPU bound workloads it would suck

Re: [GENERAL] Group BY and Chart of Accounts

2008-10-29 Thread justin
); -- WaGathoni wrote: Justin was recommending a solution to the Chart of Accounts Problem posted by jamhitz: MQUOTE One has you chart of Accounts Create table coa ( coa_id serial not null, parent_id int not null default 0, doIhaveChildren boolean default false account_name

Re: [GENERAL] Shopping cart

2008-10-22 Thread justin
Andrus wrote: Thomas, http://www.satchmoproject.com/ But it is written in python. Not PHP or C#. Thank you. Unfortunately for me it seems that learning another language, Python + Django to support shopping cart is too much. Where to find Visual FoxPro, PHP or C#/mod_mono scripts for

Re: [GENERAL] Chart of Accounts]

2008-10-16 Thread justin
James Hitz wrote: As I said earlier, I am quite green with PGSQL, so please bear with me when I ask Stupid questions... --- On Mon, 13/10/08, justin [EMAIL PROTECTED] wrote: I just redid the accounting side of an application we have access to source code, so been here and done

Re: [GENERAL] Chart of Accounts

2008-10-14 Thread justin
revenge :-). Isak Hansen wrote: On Mon, Oct 13, 2008 at 2:57 AM, justin [EMAIL PROTECTED] wrote: [...] Also you want to split out the debit and credits instead of using one column. Example one column accounting table to track values entered how do you handle Crediting a Credit Account Type

Re: [GENERAL] Chart of Accounts

2008-10-13 Thread justin
Gregory Stark wrote: justin [EMAIL PROTECTED] writes: special note do not use only 2 decimal points in the accounting tables. If your application uses 10 decimal places somewhere then every table in the database that has decimals needs to have the same precision. Nothing is more

Re: [GENERAL] Chart of Accounts

2008-10-13 Thread justin
Craig Bennett wrote: If you want to take a particular system out to extra digits, it's probably good to record the rounding error as a separate component of the transaction (that is, if you want everything to balance out perfectly). I think you have two different problems here. On the

Re: [GENERAL] Chart of Accounts

2008-10-13 Thread justin
and an in house accountant to make sure i get all the debits and credits correct Jeff Williams wrote: Hi Justin I like your method. A question I am in the process of developing an piece of auction software. How would you handle all the bidders and vendors so they all come from a table

Re: [GENERAL] Chart of Accounts

2008-10-12 Thread justin
You are making this far to complicated. I just redid the accounting side of an application we have access to source code, so been here and done this. If i was not for the rest of the application i would have completely redone the accounting table layout something like this 3 Accounting

Re: [GENERAL] localhost (windows) performance

2008-10-07 Thread justin
johnf wrote: I have a friend I asked to load postgres 8.3 on his XP machine. He then tested a python script which accesses several tables and discovered that it retrieves data very slowly. It takes about 20 seconds to retrieve the data - on localhost. However, using a remote connection to a

[GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

2008-09-25 Thread Justin Yao
Hi, In PostgreSQL 7.x, I can use SQL: select datname, oid from pg_database to find out the numeric directory name under $PGDATA/base for each database. But it doesn't work for PostgreSQL 8.3. Is there any way I can do it for 8.3? Thanks, -- Justin Yao -- Sent via pgsql-general mailing list

Re: [GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

2008-09-25 Thread Justin Yao
nothing special, just curious about it. I suppose it should be able to be located by SQL. Justin Tino Wildenhain wrote: Hi, Justin Yao wrote: Hi, In PostgreSQL 7.x, I can use SQL: select datname, oid from pg_database to find out the numeric directory name under $PGDATA/base for each

Re: [GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

2008-09-25 Thread Justin Yao
flatfile_update_trigger() Tablespace: pg_global I didn't find the Column oid, I take granted to think it may not work, but I didn't issue a command to have a try. Really sorry about that. But the question is, why there's no column named oid and it still works? Thanks, Justin Tom Lane wrote

Re: [GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

2008-09-25 Thread Justin Yao
thanks so much! Tom Lane wrote: Justin Yao [EMAIL PROTECTED] writes: But the question is, why there's no column named oid and it still works? \d doesn't show system columns. http://www.postgresql.org/docs/8.3/static/ddl-system-columns.html regards, tom lane

Re: [GENERAL] Automated Backup On Windows

2008-09-09 Thread justin
Greg Smith wrote: On Mon, 8 Sep 2008, justin wrote: I would have added it to the postgresqldocs.org webstie but can't create an account for my self.Tried following theses instructions http://www.postgresqldocs.org/wiki/Automated_Backup_on_Windows but never could get it to work

Re: [GENERAL] Automated Backup On Windows

2008-09-09 Thread justin
Dave Page wrote: On Tue, Sep 9, 2008 at 1:32 PM, justin [EMAIL PROTECTED] wrote: Greg Smith wrote: On Mon, 8 Sep 2008, justin wrote: I would have added it to the postgresqldocs.org webstie but can't create an account for my self.Tried following theses instructions http

Re: [GENERAL] Automated Backup On Windows

2008-09-09 Thread justin
how does this page look to you guys/gals. I have never added anything to a WIKI before so any comments?? I left the original author stuff untouched my edit is appended to the top -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Automated Backup On Windows

2008-09-09 Thread justin
sorry forgot the link http://wiki.postgresql.org/wiki/Automated_Backup_on_Windows justin wrote: how does this page look to you guys/gals. I have never added anything to a WIKI before so any comments?? I left the original author stuff untouched my edit is appended to the top -- Sent via

Re: [GENERAL] Automated Backup On Windows

2008-09-09 Thread justin
Please use subsections to separate both methods. How about adding the page to the Windows category? I just fixed both those. Justin, you might want to look at how I reformatted that to get an idea what the usual style is like. Also, people who write whole articles or large sections

<    1   2   3   4   >