I use odbc in a windows environment.
No complaints, can do inserts, select, updates, joins, execute stored
procedures
with little fuss...more than fast enough for my purposes.
There are some issues with 32/64 bit odbc depending on your relative
OS..as far as installing the correct odbc version. T
Good evening,
I'm curious about a way to ask the following question of my vendors
table.
psuedo1 "select all vendors which exist in BUR and EBC and SNJ"
and
psuedo2 "select all vendors which DO NOT exist in all three show rooms
The data is from a Sage accounting system which I pull out and plac
had access to the very
best conversations
and technical discussions from my fellow decorated contributors.
The coc sounds like a Washington politics play, but as long as the best
still engage
in this forum, I could care less. The list serves its purpose without
overhead...a rare
resource in today's flood of incoherent technical chatter.
Happy New Year!
Bret Stern
President
Machine Management
Maybe Trump should write this
ot;, he'll step down.
>
> THE END
>
>
> Thanks,
> Regina
>
In that vein..Being the insensitive MF that I am, I don't care what Tom
says. Toms value (in the list) is his commitment to
the project and (for me) the last word on most topics..even if he is a
liberal sob.
Feel the love,
Bret Stern
>
>
have used an int...and...
why the f%$ckl did you use a godda$%m int you dumb son-of-a-bitchare
the same thing to me,
but the latter clearly could have cost lives.
So for those of us who cannot be offended (no offense). no COC needed.
Cheers (no offense)
Bret Stern (no offense)
ps. If yo
On this track (possibly unrelated)...can a view be used as part of the
multi table update
Just curious
On Wed, 2016-01-27 at 14:48 -0500, Don Parris wrote:
> I have several tables related to people and their contact information,
> and want db users to be able to add or update a given person and
I'm thinking about picking up a new windows phone, and
would like to connect to a postgresql server from the
phone.
Anyone have some how-to links.
I've done some initial Google searches, and found some
leads, but hoping to draw on some experience in the group.
Regards,
Bret Stern
The first value seems more suspect, should be "490015496GW". Mixing
numeric and string values is best enclosed in quotes.
"Golders Green, Golders Green, stop GW" is normal if you want the
entire string between the quotes to arrive in a single column (with
the comma).
On Sat, 2013-02-16 at 17
s.
UPDATE employees SET sales_count = sales_count + 1 WHERE id =
(SELECT sales_person FROM accounts WHERE name = 'Acme Corporation');
Many thanks
Bret Stern
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
> Regards,
>
> Justin Tocci
> Programmer
> www.workflowproducts.com
> 7813 Harwood Road
> North Richland Hills, TX 76180
> phone 817-503-9545
> skype justintocci
>
> On May 13, 2013, at 3:23 PM, Bret Stern
> wrote:
>
> > PG 8.4
> >
> > H
I'll throw in.
If tab delimited is available, perhaps that option will work
better...or..
use Access to find the violations of the quote comma delimited
assumptions, then
export from Access an import
Bret
On Wed, 2017-03-08 at 08:36 -0800, Karl Czajkowski wrote:
> I believe that in its fully g
Goal is to return all vendors which exist in all three companies
I think I got lucky figuring this out. Is there an obviously better way?
combined_item_master looks like this:
company_code character varying(10) NOT NULL,
primary_vendor_no character varying(7)
..more fields
data looks like this:
'psuedo
Can you create stored procedures that are built from parameters as
below, or does this defeat the pre-compiled purpose of an SP?
create function item_exists (tbl character varying, col character
varying, col_val character varying)
DECLARE
x integer;
PERFORM col FROM tbl
WHERE co
On Mon, 2013-09-02 at 18:20 -0700, Adrian Klaver wrote:
> On 09/02/2013 06:06 PM, Bret Stern wrote:
> > 'psuedo
> >
> > Can you create stored procedures that are built from parameters as
> > below, or does this defeat the pre-compiled purpose of an SP?
> >
PostgreSQL - (the worlds database)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, 2013-09-17 at 08:32 -0400, Adam C Falkenberg wrote:
> Good Morning,
>
> I had a question about using ODBC with large objects. When I query
> the pg_largeobject table and return data to an ADO recordset, I can
> only get the first 255 bytes even though the record contains 2048
> bytes of
I have an inventory transaction table with several fields,
specifically:
part_no
trans_type
trans_qty
part_no | trans_type | trans_qty
abc REC 5000(receipt)
abc REC 400 (receipt)
abc SHP 1000(shipment)
abc ALL 1000(all
n trans_type='REC' then trans_qty when trans_type = 'SHP'
> then -trans_qty else 0) as on_hand
>
> but i'm courise about if something is allocated and then it shipped,
> will you delete the record or allocation?
>
>
>
>
> On 9/23/2013 1
Think I'll just do an UPDATE which changes the ALLOCATED
transaction to a SHIP transaction and uses the current
Ship Date/Time
On Tue, 2013-09-24 at 07:38 -0700, Bret Stern wrote:
> Support at it's finest.
> Thinking maybe ALLOCATED transactions zero out
> when the allocated
n a large set of inventory
> transactions for query current totals
>
> -
>
>
>
>
> Think I'll just do an UPDATE which changes the ALLOCATED
> transaction to a SHIP transaction and uses the current
> Ship Date/Time
>
> On Tue, 2013-09-24 at
On Wed, 2013-09-25 at 07:46 -0700, Chris Travers wrote:
>
>
>
> On Wed, Sep 25, 2013 at 7:27 AM, DDT <410845...@qq.com> wrote:
> By the way, you can try to save the current totals to another
> table.
> update it through triggers when the inventory transactions
> c
I'm amazed how complete pgAdmin, postgreSQL, all the interface options,
and this forum works.
It's time to reflect. I feel like donating.
(Maybe I'll feel the same about our politicians someday) Nnn!
Is https://www.postgresql.us/donate the place to donate?
--
Sent via pgsql-general ma
With a brief look at the last 15 years of programming for the web, your
comments are a little harsh. Only a short time ago perl and cgi
was the rage.
I've been programming for 30 years...and still have clients who use
Lotus 123 (MS-DOS) based. It's a big world out there, and lots of
solutionsf
My interpretation of "Forms these days are written in HTML" means
most interfaces are web front ends to the cloud. Not a GUI framework.
On Fri, 2013-10-11 at 14:47 +0200, Wolfgang Keller wrote:
> > Forms these days are written in HTML.
>
> Only by clueless/careless morons.
>
> HTML has never bee
Agreed.
On Fri, 2013-10-11 at 09:06 -0700, Steve Atkins wrote:
> On Oct 11, 2013, at 8:57 AM, Bret Stern
> wrote:
>
> > My interpretation of "Forms these days are written in HTML" means
> > most interfaces are web front ends to the cloud. Not a GUI framework.
>
Are you calling the perl from apache (assuming yes)..? Does the web
user have the rights to execute the perl code?
Try disabling SELinux..
You'll get it..
On Fri, 2014-01-24 at 09:35 -0800, Susan Cassidy wrote:
> I've already checked that. It is enabled. I am running Scientific
> Linux.
>
>
>
specific setting
would be the next step.
On Fri, 2014-01-24 at 11:55 -0800, Susan Cassidy wrote:
> I don't actually know what SELinux is. What else will happen if I
> (find out how to) disable it?
>
>
> Susan
>
>
>
> On Fri, Jan 24, 2014 at 9:47 AM, Bret Stern
>
You checked pg_hba_conf for host 10.68.73.6?
Is there a matching log entry for the rejection?
On Wed, 2014-02-05 at 09:21 -0200, Edson Richter wrote:
> Dear all, I need your advise. Found a tricky situation.
>
> Without any changes in the configuration files, a **local** connection
> to a local
This is a kick *ss forum. I must say.
On Fri, 2014-02-28 at 14:17 -0800, Steve Atkins wrote:
> On Feb 28, 2014, at 2:04 PM, George Weaver wrote:
>
> > Hi list,
> >
> > I'm stumped.
> >
> > I am trying to use Regexp_Replace to replace ordinal suffixes in addresses
> > (eg have '126th' want
FYI,
Pretty sure Apache Office Base has native support to open Access.mdb
files on a linux box
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Any opinions/comments on using SSD drives with postgresql?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Care to share the SSD hardware you're using?
I've used none to date, and have some critical data I would like
to put on a development server to test with.
Regards,
Bret Stern
On Wed, 2014-04-02 at 15:31 -0500, Shaun Thomas wrote:
> On 04/02/2014 02:50 PM, Brent Wood wrote:
>
On Thu, 2014-04-03 at 12:32 -0700, David Rees wrote:
> On Thu, Apr 3, 2014 at 12:13 PM, Merlin Moncure wrote:
> > On Wed, Apr 2, 2014 at 2:37 PM, Bret Stern
> > wrote:
> >> Any opinions/comments on using SSD drives with postgresql?
> >
> > Here's a singl
Is this list suited for coding questions?
I'm using VS2008, connecting to postgresql with libpq and
have some initial questions.
Regards
Bret Stern
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
Got a new fancy pants Dell T3500 Windows 7 Ultimate 64 bit machine.
PostgreSql 9.1
Trying to port a 32-bit XP libpq console app with Codeblocks.
Seems like the libpq.lib isn't linking quite right as the PQ_Connectdb,
PQstatus etc lib functions are reported as undefined.
Anyone out there get Win
On Sat, 2012-09-08 at 21:24 +0200, Andreas Kretschmer wrote:
> Joel Hoffman wrote:
>
> > More concisely, you can compare directly against all values of the array:
> >
> > # create table i (i int[] check (0 <= ALL(i) AND 1023 >= ALL(i)));
> > # insert into i values (ARRAY[0,1,2,3,1023]);
> > # in
create a ramdrive
On Wed, 2012-10-10 at 14:27 +0100, Seref Arikan wrote:
> Hi Merlin,
> Thanks for the response. At the moment, the main function is creating
> two temp tables that drops on commit, and python functions fills
> these. Not too bad, but I'd like to push these temp tables to ram,
> w
Sounds like a file sharing issue. In other words..writing to the same
file at the same time...from two separate pg_dump streams.
Perhaps adding a time var to the file name call below
and see if the error goes away.
On Sat, 2012-11-10 at 08:03 -0600, Tefft, Michael J wrote:
> We have several Post
Is it possible through ODBC to connect to a PostgreSql
server and query for the available databases?
When our application upgrades, we typically create a
new database. I want to design a form which allows
the user to select the old database, which then
migrates data to the new (currently connected
Works perfect. I'll trap and show only our databases to the user.
all thanks
On Wed, 2012-03-07 at 21:00 +0100, Szymon Guz wrote:
> On 7 March 2012 20:36, Bret Stern
> wrote:
> Is it possible through ODBC to connect to a PostgreSql
> server and query for the av
immediately.
Can it be used with VB?
or
Should I use LibPQ?
Any suggestions welcome.
If this is the wrong list for these questions, let me know?
Bret Stern
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
trying to update a varchar numeric string column
by converting it to int, adding a numeric value and insert it back
as a varchar
Having trouble with cast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpr
On Mon, 2012-03-12 at 17:39 -0700, Bosco Rama wrote:
> Bret Stern wrote:
> >
> > trying to update a varchar numeric string column
> > by converting it to int, adding a numeric value and insert it back
> > as a varchar
> >
> > Having trouble with cast
&
I felt pretty good about my server until I read this.
On Wed, 2012-03-14 at 00:24 -0700, John R Pierce wrote:
> On 03/13/12 8:41 PM, Carson Gross wrote:
> > Does anyone have a reasonable guess as to the inserts per second
> > postgres is capable of these days on middle-of-the-road hardware? Any
Perhaps a RAM DISK could be considered in the equation
On Thu, 2012-03-15 at 16:30 +0100, Albe Laurenz wrote:
> Richard Harley wrote:
> > Very simple question - does pg_dump/dumpall hit the server in terms
> of database performance? We
> > currently do nightly backups and I want to move to ho
VoltDB maybe
- Original Message -
On 06:31 AM 03/23/2012 Frank Lanitz wrote:
Am 23.03.2012 14:23, schrieb Adrian Klaver:
> I would say either they got the numbers wrong or someone is pulling
> your leg. That rate is not going to happen.
Maybe twitter or facebook all in all...
Cheers,
F
On Mon, 2012-03-26 at 16:16 -0700, John R Pierce wrote:
> On 03/26/12 4:05 PM, Tim Uckun wrote:
> > Is there a way to backup a database or a cluster though a database
> > connection? I mean I want to write some code that connects to the
> > database remotely and then issues a backup command like i
On Thu, 2012-03-29 at 14:49 -0500, Andy Colson wrote:
> On 3/29/2012 2:10 PM, Rich Shepard wrote:
> > I'm storing vector map attribute data in postgres tables and somehow
> > managed to create two databases (of similar names) rather than one. I want
> > to combine the two.
> >
> > For tables that e
On Mon, 2012-04-09 at 09:03 +, Jasen Betts wrote:
> On 2012-03-09, Bret Stern wrote:
> > We have a concrete batching application composed of two parts.
> > 1. The Monitor.
> > The Monitor cycles every 60 seconds, and looks into a Postgresql table
> > for jobs t
ication is
distributed.
Is there a list which discusses this, or should I test the waters
here when the time comes?
Bret Stern
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
51 matches
Mail list logo
