[GENERAL] Prepare a query in linpq?

2004-03-28 Thread Robert Turnbull
How does one use a prepared select statement as outlined in the documents under the prepare statement. I need an example how to convert the plan to cursor so the results can be pulled.   My environment is linpq Version 7.2 Linux X86.   Thanks

[GENERAL] Multiple statements in one prepare / exec

2004-03-28 Thread Robert Turnbull
Can multiple SQL statements be concatenated with separating semicolons, prepared with a single statement, and executed with a single statement? This implies that parameter $1 could be used in statement 2 & 4, ...   My interface is libpq   Thanks Rob

Re: [GENERAL] Table Lock issue

2004-04-16 Thread Robert Treat
ry snapshot inside plpgsql whenever a lock table in exclusive access is issued follows along this line and would seem like one way to help most people get around this problem since it's hard to imagine any real world scenario where one would want to lock a table exclusively and still see ro

[GENERAL] error messages (not valid postgresql link resoucre)

2004-05-09 Thread Robert Morgan
|I'm trying to run a query on a database using php and postgres functions || $row[0]"); } ?> but I get these error messages. I have tested to see if the connection is still alive and it is. || *Warning*: pg_exec(): supplied argument is not a valid PostgreSQL link resource in */var/www/html/Datab

[GENERAL] Upgrade from 7.3.4 to 7.4.2 went wrong

2004-05-16 Thread Robert Fitzpatrick
I get this error after doing the upgrade on FreeBSD 5.2.1: The data directory was initialized by PostgreSQL version 7.3, which is not compatible with this version 7.4.2 Should I just re-initdb and the import my dump file? -- Robert ---(end of broadcast

Re: [GENERAL] shadowing (like IB/Firebird)

2004-04-27 Thread Robert Treat
r; > > > > done by software. > > I recommend they keep clinging. :-) > Should we recommend they submit a patch instead? :-) Seriously though this sounds like it could be an extension of the tablespaces implementation couldn't it? Robert Treat -- Build A Brighter Lamp :

Re: [GENERAL] Postgre and Web Request

2004-04-29 Thread Robert Treat
that the OP is not likely to ever need such a high connection count, there's no reason that PostgreSQL can't support it given you have enough RAM, fast enough disks, and you don't shoot yourself in the foot with FK/Locking issues in the app. Robert Treat -- Build A Brighter Lamp :: L

Re: [GENERAL] [ADMIN] Clustering Postgres

2004-05-26 Thread Robert Treat
style benchmarks on the system, check the archives or the osdl site for more info on getting these up and running. Robert Treat On Monday 24 May 2004 09:59, Greg Spiegelberg wrote: > Robert, > > I am currently evaluating PolyServe Matrix Server which is a clustering > solution incl

[GENERAL] Intalling PHP 4.3.7 with PGSQL support and Heimdal

2004-06-06 Thread Robert Fitzpatrick
o.3 (0x28096000)    libkrb5.so.20 => /usr/local/lib/libkrb5.so.20 (0x280b2000) ...   Anyone know where I can make these changes needed or what to try next?   -- Robert

Re: [GENERAL] The pgreplication project

2004-06-08 Thread Robert Treat
ndows and gui tools up on techdocs. I plan to do that as well, just need to find time to work it into the schedule. Robert Treat On Tue, 2004-06-08 at 08:46, Jan Wieck wrote: > I guess I have to address a slightly broader audience, or do I conclude > from the total lack of interest in this

[GENERAL] clear defunct entries from pg_stat_activity

2004-06-08 Thread Robert Treat
collector daemon. I'm curious if anyone knows if this was fixed in 7.4, and perhaps more importantly if there is a way to clear these entries in 7.3.4. (I was thinking perhaps some entries in the stats tables but didn't find anything...) Robert Treat -- Build A Brighter Lamp :: Li

[GENERAL] Database accesss using plperl

2004-06-16 Thread Robert Fitzpatrick
, UPDATE) using plperl? What are the consequences and things to look out for when running untrusted languages? -- Robert ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Database accesss using plperl

2004-06-17 Thread Robert Fitzpatrick
On Wed, 2004-06-16 at 19:05, Paul Thomas wrote: > On 16/06/2004 21:27 Robert Fitzpatrick wrote: > > I have plperl installed my PostgreSQL 7.4.2 server, but from what I > > understand in chapter 39.3 of the docs, you cannot access the databases > > without DBD::PgSPI. Accord

[GENERAL] Trigger to update records out of memory

2004-06-18 Thread Robert Fitzpatrick
c=# CREATE TRIGGER "new_common_area" BEFORE INSERT OR UPDATE ohc-# ON "public"."tblhudunits" FOR EACH ROW ohc-# EXECUTE PROCEDURE "public"."clear_common_groups"(); CREATE TRIGGER ohc=# update tblhudunits set common_area = 't' where sort_order

Re: [GENERAL] Trigger to update records out of memory

2004-06-18 Thread Robert Fitzpatrick
On Fri, 2004-06-18 at 13:17, Robert Fitzpatrick wrote: > ohc=# CREATE OR REPLACE FUNCTION "public"."clear_common_groups" () > RETURNS trigger AS' > ohc'# BEGIN > ohc'# IF NEW.common_area = ''t'' THEN > ohc&#x

Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Robert Treat
apps but would be frowned upon by most postgresql users. Robert Treat On Fri, 2004-06-18 at 15:00, Duane Lee - EGOVX wrote: > I agree. You could always do a SELECT and if the record was found then > UPDATE otherwise INSERT. A little more effort than MYSQL but again I > don't belie

[GENERAL] SELECT based on function result

2004-07-15 Thread Robert Fitzpatrick
y guidance to how I can return all the positives (or negatvies)? Or do I need to write another function that does that? -- Robert ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining colum

[GENERAL] Using SELECT inside a COPY transaction with PHP

2004-07-21 Thread Robert Fitzpatrick
he point of the first SELECT. -- Robert ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Where are all the users?

2004-08-04 Thread Robert Treat
n I can't create the Key. Have anybody an solution? I think the way you are "supposed to do this" is by using the CURRENT_USER variable to get the current user name for the person connected. If you are stuck on using the system id's you could create your own triggers to

[GENERAL] tracking down foreign key constraint violation error

2004-08-08 Thread Robert Fitzpatrick
blhudunits. Can anyone see something I am missing? -- Robert ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] DELETE and UPDATE in same function with foriegn keys

2004-08-09 Thread Robert Fitzpatrick
ERRABLE INITIALLY DEFERRED, but does not seem to work. Is there a way to do this without having to set my Foreign Key to Update instead of Restrict. That works if I do that. -- Robert ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Sorting varchar w/single digits

2004-08-10 Thread Robert Fitzpatrick
? -- Robert ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] postmaster does not shut down

2004-08-10 Thread Robert Fitzpatrick
thing I've worked on today :( -- Robert ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] idle processes

2004-08-14 Thread Robert Paulsen
t;extraneous" postgres processes) while experimenting with them. With regular non-persistent connections I don't see those long-lived processes. (Aside from the point of your question, it seems to me persistent are somewhat useless since you can't close them when you are done with them

Re: [GENERAL] (S)RPMS for 7.4.4 released.

2004-08-18 Thread Robert Treat
We wont update the website docs at least until the packages are officially announced, and even then might be a few days later. Oh, you'll know it has been officially released when you see Marc post an email to -announce telling everyone. Robert Treat -- Build A

Re: [GENERAL] Postgresql feature

2004-08-19 Thread Robert Treat
acle like task schedular in postgresql. not sure how mature it is but might be worth a look for those interested in this. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: if posting/readin

[GENERAL] unsubscribe

2004-08-26 Thread Robert Deme
unsubscribe

[GENERAL] Updating another table using a trigger

2004-09-15 Thread Robert Fitzpatrick
NEW.assessor_license, inspector_expiration_date = NEW.assessor_expiration_date WHERE inspector_contact_id = NEW.assessor_contact_id; IF NOT FOUND THEN RAISE EXCEPTION ''Could not update inspector''; END IF; END IF; IF (TG_OP = ''DELETE

Re: [GENERAL] Converting varchar() to text

2004-09-16 Thread Robert Treat
new column and then use a view with some coalesce magic to combine the two columns into one. HTH -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: the planner will ignore your desire

[GENERAL] Returning recordsets with functions

2004-09-23 Thread Robert Fitzpatrick
type, but nothing that returns a set. -- Robert ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Returning recordsets with functions

2004-09-23 Thread Robert Fitzpatrick
On Thu, 2004-09-23 at 18:28, Tim Penhey wrote: > Robert Fitzpatrick wrote: > > >Can someone point me to some more information or perhaps show an example > >of returning a recordset from a plpgsql function. I'd like to send an > >argument or arguments to the function

[GENERAL] Returning a list of fields in a composite type

2004-09-24 Thread Robert Fitzpatrick
Is it possible to return the field names of a composite type using a function? Any examples or pointers? -- Robert ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unreg

[GENERAL] query optimizer questions

2001-07-02 Thread Robert Berger
Why do the following three queries use different scan types under 7.1.2? Under 6.5.3 they all used index (and my system ran MUCH faster, since I often use the trailing %) I've done a vacuum analyze. I installed 7.1.2 on RedHat 6.2 using the RPMs. anderson=# explain select value from s_n_grantor

Re: [GENERAL] query optimizer questions

2001-07-02 Thread Robert Berger
Thanks. How do I set the locale? > In 7.1, LIKE optimization (i.e., possibly using an index) has been > disabled unless you are in the C locale because it does not work > correctly. You could set your locale to C and re-initdb to get it to work > again. > > -- > Peter Eisentraut [EMAIL PROTEC

[GENERAL] trigger wont use internal function?

2001-07-23 Thread Robert Treat
/selects using lower(). I have also tried creating my own version of a lower function but it gives me the same message. Am I missing something? This seems like it should be pretty straightforward. tia, robert ---(end of broadcast)--- TIP 1

Re: [GENERAL] Printable report generation

2001-09-14 Thread Robert Sell
Heck as far as that goes you can use access thru odbc and pull up your tables and use accesses report generation. Rob "SMJ" <[EMAIL PROTECTED]> wrote in message Pine.LNX.4.10.10108141753440.260-10@stark">news:Pine.LNX.4.10.10108141753440.260-10@stark... > Hi all, > > I'm currently in the p

[GENERAL] Forcing a query plan

2003-07-02 Thread Robert Wille
ay to give the planner a hint, or reword the query and update so that it executes the way I want? Thanks in advance.   Robert Wille  

Re: [GENERAL] Role Models Wanted

2003-07-29 Thread Robert Treat
://www.sql-ledger.com/ double entry accounting system http://openacs.org/ enterprise level web community system Robert Treat -- PostgreSQL :: The Enterprise Open Source Database ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] surppressing column names in COPY format

2003-07-31 Thread Robert Treat
to suppress column names for COPY only dumps. I also checked the message archives, but the only thing relevant seemed to be the original patch which didn't appear to allow for a way to suppress the column names, am I completely missing something here or did we los

Re: [GENERAL] plPHP -- sort of an announcement.. but not commercial

2003-08-04 Thread Robert Treat
r the weekend, the trigger feature seemed to work, and the complex array example function seemed to work ok, but the basic simple echo example failed. I've subscribed to the mailing lists, so we'll see if I can figure out where I went wrong. Robert Treat -- Build A Brighter L

Re: v7.4 on Windows ... (Was: Re: [GENERAL] v7.4 Beta 1 Bundle ...)

2003-08-09 Thread Robert Treat
On Wed, 2003-08-06 at 09:22, The Hermit Hacker wrote: > On Wed, 6 Aug 2003, Robert Treat wrote: > > > depends on what you mean by any. I believe that the standard tarball > > will compile under windows, but to what extent it will actually run I > > couldn't say. Thi

Re: [GENERAL] v7.4 Beta 1 Bundle Available for Testing ...

2003-08-10 Thread Robert Treat
On Wed, 2003-08-06 at 11:17, scott.marlowe wrote: > On 6 Aug 2003, Robert Treat wrote: > > > On Tue, 2003-08-05 at 20:18, Dann Corbit wrote: > > > > For me, I can only find these directories: > > > ftp://ftp8.us.postgresql.org/pub/pgsql/source/v7.4/ >

[GENERAL] 7.4Beta1 "failed to create socket: Address family not supported byprotocol"

2003-08-14 Thread Robert Creager
I'm receiving the following error during startup: Aug 10 14:11:27 thunder postgres[18613]: [1-1] LOG: failed to create socket: Address family not supported by protocol Aug 10 14:11:27 thunder postgres[18619]: [2-1] LOG: database system was shut down at 2003-08-10 14:11:11 MDT Aug 10 14:11:27

Re: [GENERAL] v7.4 Beta 1 Bundle Available for Testing ...

2003-08-14 Thread Robert Treat
ll compile under windows, but to what extent it will actually run I couldn't say. This release is not intended for native use on windows (that had to be pushed back to 7.5), though it will certainly run via cygwin. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] How to prevent vacuum and reindex from deadlocking.

2003-08-14 Thread Robert Creager
On Sun, 10 Aug 2003 14:50:10 -0600 Robert Creager <[EMAIL PROTECTED]> said something like: > > I'm running 7.4Beta1 with pg_autovacuum. In one of my operations > which is executed frequently, a REINDEX is done after a COPY. Well, > VACUUM's are being executed by

Re: [GENERAL] remove $ from money field

2003-08-14 Thread Robert Treat
eturn $workable ' language 'pltclu'; Robert Treat On Fri, 2003-08-08 at 20:04, Robby Russell wrote: > Should be a simple question. > > When selecting a field that is of type money, how can I remove the $ > when selected? > > example: $10.00 would return as 10.0

Re: [GENERAL] How to prevent vacuum and reindex from deadlocking.

2003-08-14 Thread Robert Creager
On Mon, 11 Aug 2003 10:11:37 -0400 Tom Lane <[EMAIL PROTECTED]> said something like: > Robert Creager <[EMAIL PROTECTED]> writes: > > Opps, if it helps, the log of the deadlock: > > > Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR: deadlock detected > >

Re: [GENERAL] Dreamweaver

2003-08-18 Thread Robert Treat
unsuccessful > so far. > Well, some folks are certainly doing it, check out this blog entry: http://www.redev.org/archives/23.cfm#more Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] native win32 version

2003-08-20 Thread Robert Treat
ever see a recommendation from the development group to run postgresql on windows over a *nix OS for production purposes (even when native win32 comes about, theres just too much lacking in windows) however for development purposes it should be more than fine. Robert Treat -- Build A Brighter Lamp :: Li

Re: [GENERAL] Mail server load

2003-08-20 Thread Robert Treat
;) { > fileinto "INBOX.garbage"; > } > > I can't think of anyone using anything but *maybe* the Approved one in > their Subject, so there shouldn't be too many false positives ... > hopefully hear something from the mj2 guys relatively soon ... Little does Ma

Re: [GENERAL] Stored procedure advice needed

2003-08-22 Thread Robert Treat
This sounds an awful lot like crosstab functionality, Check out the tablefunc module in contrib, I think there is something in there that will help you with this. Robert Treat On Thu, 2003-08-21 at 16:11, Stephan Szabo wrote: > > On Thu, 21 Aug 2003, Egor Shipovalov wrote: > > &g

Re: [GENERAL] pl/tcl trigger question

2003-08-26 Thread Robert Treat
t; something very simple but I don't know TCL (and I'm planning to keep > the serverside programming on pl'pgsql as much as possible). > You'll need a function a bit more complex than this, but to do what your trying to do in the function above the function would be writ

Re: [GENERAL] before trigger problem

2003-08-29 Thread Robert Treat
http://developer.postgresql.org/ftpsite/binary/v7.3.4/RPMS/ Robert Treat On Thu, 2003-08-28 at 11:18, Marie G. Tuite wrote: > Same issue - are there rpms anywhere for 7.3.4? > > Thanks. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTE

Re: [GENERAL] State of Beta 2

2003-09-16 Thread Robert Creager
Once upon a time (Tue, 16 Sep 2003 12:59:37 -0700) "Joshua D. Drake" <[EMAIL PROTECTED]> uttered something amazingly similar to: > If someone is willing to pony up 2000.00 per month for a period of at > least 6 months, I will dedicated one of my programmers to the task. So > if you want it bad e

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Robert Treat
On Wed, 2003-09-24 at 13:50, Jan Wieck wrote: > > > Robert Treat wrote: > > On Tue, 2003-09-23 at 17:49, Christopher Browne wrote: > >> It would be most interesting if the makers of other GPLed software > >> such as Linux were to apply the same rule themselves.

Re: [GENERAL] Divide by zero...

2003-09-30 Thread Robert Creager
When grilled further on (Tue, 30 Sep 2003 09:26:19 -0400), Mike Leahy <[EMAIL PROTECTED]> confessed: > I have a query that calculates various using variables from a survey > database. As with any survey, there are many instantces of null values. I'm > wondering if there is any way to escape th

Re: [GENERAL] LC_COLLATE=C not working

2003-10-03 Thread Robert Wille
> Robert Wille writes: > > > I have tried to do the same on my production server, and when I do the > > initdb, it says that LC_COLLATE is C, but it does not sort the same as > > the test server. Namely, on the test server 'z' < '~' and on the >

Re: [GENERAL] PostgreSQL Beta4 Tag'd and Bundle'd ...

2003-10-06 Thread Robert Treat
he place, and has been since the beginning. Or sign up for -announce and read the weekly news, which gives a summary of each weeks developments* and updates some other ancillary information about the project. * save last week, which seems to have gotten lost in virtual space, but come Wednesday

[GENERAL] Question

2003-10-14 Thread Robert Partyka
Hi, I have question: why such condition: foofield not like '%bar%' where foofield is varchar returns false (or rather even ignore row) on record where foofield is null but returns true on records where foofield is '' (empty string) regards Robert

[GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
I'm using 7.4b4 with domains, and am having a problem with selecting without casting. create domain test_domain as integer check( (value notnull) and (value >= 1) ); create table test_table( field_1 test_domain, field_2 integer ); insert into test_table values( 1, 1 ); insert into test_table valu

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
When grilled further on (Sat, 18 Oct 2003 13:12:41 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > select * from test_table where field_1 = '1'; -- fails > > The last select fails with 'operator is not uniq

Re: [GENERAL] 7.4b4 domain usage and select question

2003-10-18 Thread Robert Creager
When grilled further on (Sat, 18 Oct 2003 15:46:55 -0400), Tom Lane <[EMAIL PROTECTED]> confessed: > Robert Creager <[EMAIL PROTECTED]> writes: > > But, I cannot turn of logging of the duration! It's set to > > log_min_duration_statement = 0, > > -1 turn

[GENERAL] tracking down temp files

2003-11-17 Thread Robert Treat
is there some way to determine the query that creates the file pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently not... anyone know? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [GENERAL] Postgresql vs. MySql - need feature matrix for

2003-11-21 Thread Robert Treat
and let's gloss over whether their implementation is acid compliant) so just be prepared if your going to do it. also, if you do do it, i'd like to see a feature comparison against some more interesting candidates, like oracle or informix Robert Treat On Thu, 2003-11-20 at 11:12, Jeff

Re: [GENERAL] PGSQL on shared hosting

2003-11-21 Thread Robert Treat
nce. Can you send your info to [EMAIL PROTECTED] Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Cron-job for checking up on pg_autovacuum

2003-11-29 Thread Robert Creager
When grilled further on (Tue, 25 Nov 2003 11:19:32 -0500), "Matthew T. O'Connor" <[EMAIL PROTECTED]> confessed: > I know I heard from at least one person who said they were running it > from there inittab with respawn, which seems like overkill. Nah, it works great (it was me). I just had an un

Re: [GENERAL] Misplaced modifier in Postgresql license

2003-12-04 Thread Robert Treat
r they spoke with was... well, this is a family newsgroup so let's just say I don't feel his opinion is very credible. It would have been very easy for them to indemnify themselves had they wanted to, to not even try to sort this out speaks of some other agenda on their part IMHO. Robert

[GENERAL]

2000-06-15 Thread Robert Deme
Hello!! in flagship ( a variant of clipper for unix , http://www.wgs.com/) it is an interesting statement "seek eval" ; it scans the index and for every position it evaluates a block of code/ function until the function return true . is in postgresql an internal mechanism or a way to use the ind

[GENERAL] upgrading postgres

2000-08-31 Thread Robert Kernell
Where can I find step-by-step instructions for upgrading postgres? Bob Kernell Research Scientist AS&M email: [EMAIL PROTECTED]

[GENERAL] persistent db connections/resiliency

2000-10-09 Thread Robert Boyd
I'm tasked with handling database connection failures elegantly--reconnecting after failure. I'm wondering how other people have approached this problem. Should I get connection status before every query, and if bad, attempt reconnect? Any help is appreciated. - Rob

Re: [GENERAL] dump vs dumpall

2000-10-16 Thread Partyka Robert
ing some other mechanism. (E.g., > use the Unix socket with "trust", but change the permissions on the socket > itself.) Try to do it this way: $ export PGUSER=username $ export PGPASSWORD=password $ pg_dumpall > filename Regards Robert "BoBsoN" Partyka BTW... Hello to all on the list ;)

[GENERAL] three things

2000-10-24 Thread Robert Kernell
Hi. 1.) Can someone point me to the Postgres User's Manual online (not Bruce M.'s book)? 2.) Can someone point me to the Postgres FAQ? 3.) What is OID? Thanx a bunch! Bob Kernell Research Scientist Surface Validation Group AS&M, Inc. email: [EMAIL PROTECTED] tel: 757-827-4631

Re: [GENERAL] [NOVICE] Skipping numbers in a sequence.

2000-11-24 Thread Robert Boyd
Try a dump of your database using pg_dump. 4294967296 is the maxval if I remember correctly. 32 bit integers are a good thing. Your question still holds, what is the condition of overflow after maxval has been reached. Typically, you want to use a sequence like this for a unique opaque indent

Re: [GENERAL] one ask

2000-11-28 Thread Partyka Robert
> > any can explain me why I get every error and notice errors twice ? > > How did you start the postmaster? > > It looks like you might have the postmaster's stderr pointed at your > terminal, which would mean that its attempts to write to a logfile > will end up on your screen --- along with t

[GENERAL] win32 version of PG7.0.x?

2000-11-28 Thread Partyka Robert
Is there anywhere on net builded version of PG7.0.x for Windows ? regards BoBsoN

Re: [GENERAL] PHP and PostgreSQL

2001-01-06 Thread Partyka Robert
it is not good practice to use errors as exit code for loops. Feel free to disagree ; regards Robert > Hi! > > I have some questions about coding in php with postgre. > > Here is my code > > $qu = pg_exec ($db_conn, "SELECT * FROM clients ORDER BY username"

[GENERAL] Re: GUI Interfaces

2001-02-05 Thread robert gravsjo
There is kpsql and kpsqlman in kde. Haven't used them very much, but they seem pretty nice. regards, robert gravsjo wrote: > Are there any other GUI Interfaces with PostgreSQL other then Pgaccess? > > Thanks > > >

[GENERAL] tmp_pg_shadow

2001-02-14 Thread Robert Dege
I'm trying to do a pg_dumpall & receive this error message: ERROR: cannot create tmp_pg_shadow ERROR: COPY command failed. Class tmp_pg_shadow does not exist. ERROR: Relation 'tmp_pg_shadow' does not exist I'm running postgres 6.5.2. Does anybody have any insight as to why this is occuring?

[GENERAL] Re: tmp_pg_shadow

2001-02-14 Thread Robert Dege
I am attempting to upgrade to 7.0.3 -- hence the dumpall command. There was a zero size file in template1 that was causing the problem. Thanks for the help. <> Thanks -Rob > Robert Dege <[EMAIL PROTECTED]> writes: > > I'm trying to do a pg_dumpall & receive

[GENERAL] copying tables

2001-02-23 Thread Robert Kernell
Hi. I am trying to copy tables. I want to copy a table in one database to a table in another database. The tables are identical. Here is to code and the error when using DBI. Can I just use postgresQL somehow? Thank you. Table= fs648 +--+

[GENERAL] System Tables

2001-03-14 Thread Robert Korteweg
the website (it is missing a lot of columns)? thanks in advance Robert Korteweg The Netherlands ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] cast bit to boolean?

2001-05-03 Thread Robert Hentosh
On Thu, May 03, 2001 at 05:25:14PM -0400, Vivek Khera wrote: > How might one case a BIT to a BOOLEAN? For example, I want to return > rows which have non-zero bit representation for, say, (sel_a & b'0011'). > That is, rows with the first or second bit set. > > I tried an explicit CAST, and just

[GENERAL] 'now' is the future

1998-11-09 Thread Robert Church
PostgreSQL 6.3.4 on a Debian GNU/Linux Alpha box is returning dates far into the future. Has anyone else encountered this? Sample psql session: template1=> select 'now'::datetime; ?column? Thu Dec 16 23:08:02 2134 (1 row) Might this be a silly 64-bit p

[GENERAL] Is there something special to do to pull 6.1 db.out files into 6.4.1 ?

1998-12-27 Thread Robert Chalmers
Hi, well, finally have it all running together, but can't get my old 6.1 data into 6.4.1 now. I did a pg_dumpall -z > db.out in 6.1 and its created the file with all the data in it, but the appropriate psql -e template1 < db.out falls over. Massive error messages, although it actually creates th

[GENERAL] Found solution to reloading dumped 6.1 -> 6.4

1998-12-27 Thread Robert Chalmers
The 6.1 db.out has a line in it that looks like this; CREATE TABLE categories (category varchar(30)) archive = none; If I remove the " archive = none" bit, then all works ok. Excellent. bob -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au

[GENERAL] Is there a script for cleanly shutting down

1998-12-28 Thread Robert Chalmers
Just wondering if there is a script anywhere for cleanly shutting down the postmaster. thanks Bob -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au World Music Radio. phone:61-7-49440357 - fax:61-7-49512832 icq#11

[GENERAL] null as a value

1998-07-16 Thread Robert Campbell
How can I select columns with null values. select * from employee where the_date = null; This will not work. Any suggestions ? -- Deterset Electronics Robert Campbell 7500 Loganberry

Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL

1999-01-18 Thread Robert Chalmers
here might be some sample code for a shopping cart using pgsql as the database and php3? Thanks for any info, especialy on getting msaccess and postgresql working together. Robert Valerio Santinelli wrote: > First of all.. thanks to everybody for helping me out witht the > "sequence&qu

[GENERAL] What is happening here? ODBC. r+w on one, r only on other

1999-01-20 Thread Robert Chalmers
I have two databases here, and I can read both with Access. However, I can only write to one with Access, the second one, although it appears to be set up the same - I think - I can't write to it to add records. Access shows the [Insert Record] field as greyd out? Any clues anyone? ta bob -- ht

[GENERAL] RE: ODBC question on R+w and +r only. solved

1999-01-20 Thread Robert Chalmers
Hmmm. Just gave all permisions to user, and created a NEW table database in Access, and it imported the new permissions. It seems that Access imports the permissions, and then doesn't let you chang them, even when they have been changed in the pgsql system. not a bad idea I usppose. Now to work

[GENERAL] Someone was asking about MEMO fields and sizes?

1999-01-20 Thread Robert Chalmers
This ability to use ODBC with access is pure magic! I created a database on the Access machine, and in that I created a table, with a memo field. I exported the table to the postgres database. I looked at the structure of the table in pgsql, and the memo filed is type TEXT of var length. As it sa

[GENERAL] auto increment?

1999-01-23 Thread Robert Williams
How do I set up a column as auto increment? I have looked everywhere for the postgres equivalent ROWID as in Oracle. -- Robert Williams [EMAIL PROTECTED] Jarob Consulting [EMAIL PROTECTED] Provo, Utah [EMAIL PROTECTED] begin:vcard n:Williams;Robert x-mozilla

Re: [GENERAL] auto increment?

1999-01-23 Thread Robert Williams
he user code to > explicitly assign its values. > > See CREATE_SEQUENCE in the doc. > > - Original Message - > From: Robert Williams <[EMAIL PROTECTED]> > To: Postgres <[EMAIL PROTECTED]> > Sent: Saturday, January 23, 1999 4:11 PM > Subject: [GENERAL]

[GENERAL] Linking databases

1999-03-20 Thread Robert McArthur
Hello All, Is there any way to access tables in one database from another database on the Postgresql server? Thanks, Rob McArthur

[GENERAL] Definitive list of new types in 6.5 needed

1999-06-25 Thread Robert Chalmers
Is there a definitive list of types in 6.5 ? Not just the new ones, but all types? Or do I just wade through the documentation as usual - assuming that the latest docs are indeed the latest docs :-) cheers bc --- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive! 4QIR Quantum

[GENERAL] hard limit on result handles reached

1999-09-15 Thread Robert Wagner
Hello all, Ran into this while regression testing my app. Does anybody know if this is a physical limitation of postgress, or is this a parameter to the database that I can change? Kinda limits the database's usefulness in the real world... On the 128th query, this is the error I get... up unt

Re: [GENERAL] Postgres restart problems

1999-12-15 Thread Robert Davis
I remember having to do the same thing on a aix oracle installation. I wrote a little shell script that did it for me. bob "Differentiated Software Solutions Pvt. Ltd." wrote: > Hi, > > We have a postgres db which has been crashing about 5 times a day. It must > be failrly apparent given my oth

[GENERAL] How do I change port for the postmaster?

1999-12-15 Thread Robert Wagner
I'm attempting to run two different postmasters on two different HP-UX servers, servicing two different apps. The only commonality is that I'm on one terminal. The first starts up OK. When I attempt to start the postmaster on the other server, I get the error, FATAL: StreamServerPort: bind() f

[GENERAL] Question on timestamp in psql

2000-01-11 Thread Robert Rothe
When I type the following at the psql prompt: select timestamp('now'); ...I always get december 31, 1999. If I use 'now' as the rvalue to a SET, or within an INSERT, it returns the correct date. Is this a known problem? I'm running 6.5.2-1. Thanks, Rob

Re: [GENERAL] how to use pg-connect ?

2000-01-26 Thread Robert Wagner
(bcc: Robert Wagner/SIAC) Subject: [GENERAL] how to use pg-connect ? Hello, I'd like to know if there is a way to use pg_connect() with a different host than « localhost ». I tried to put an IP address or a server name but it didn't work. Has anybody ever used

<    5   6   7   8   9   10   11   12   >