>I see nothing tricky in your CRUDdy procedures. I would think porting
>the sql-generator would be pretty straight forward. "Except for the
>names and a few other changes, the story's the same one.": read the
>system catalogues and generate your procs-cum-functions. Your jdbc
>interactions should
We use some SQLserver databases that have stored procedures for all
C.R.U.D. functions so the same code is used no matter what language the
developer is working in. The procedures are built by a master package that
reads the table structures and creates the CRUD procedures. Then we modify
the CRUD
>> add-apt-repository ppa:pitti/postgresql
> sudo apt-get install pgadmin3
>--
>Adrian Klaver
That did it. Thanks!
Margaret
"This e-mail message and any attachment(s) are for the sole use of the intended
recipient(s) and may contain company proprietary, privileged or confidential
information.
Correction on the commands I quoted. The first one should have been for the repository.>And you need PostgreSQL libpq to use pgAdmin. That's all you need.
>Guillaume
Since I cannot use the Ubuntu repository what is the package name for the postgresql 9 library?
If I take the postgresql-9.0 out of t
>And you need PostgreSQL libpq to use pgAdmin. That's all you need.>GuillaumeSince I cannot use the Ubuntu repository what is the package name for the postgresql 9 library?If I take the postgresql-9.0 out of the install command on the link I sent and run the commands belowsudo apt-get install postg
Using these instructions http://wiki.flexive.org/confluence/display/FX/Postgres+9.x+installation+in+Ubuntu?focusedCommentId=4915206#comment-4915206
I am trying to install current pgadmin3 1.12 on an ubuntu lucid client. Using the instructions above I have an Ubuntu 10.4 Postgresql 9 server up and
>> FATAL: Ident authentication failed for user "engineering">>that says it right there. your LOCAL authentication type is set to >IDENT in your pg_hba.conf file.>That was it. I have updated my install documentation. Thank you, Margaret "This e-mail message and any attachment(s) are for the sole u
After a year I have restarted work on a project using Postgresql. The database I created was in Postgresql 8.2.5. I updated my database server from Ubuntu 7.10 to 10.4 (lucid) and installed Postgresql 9.0.2 The Postgresql install went fine and the restore from my previous pg_dumpall went fine but
Using Postgresql 8.2.11 on Ubuntu 7.10.I am writing a J2EE project but do not want user specific schemas because this application sits on a production floor and any production employee can walk to a workstation and access the database to punch work time. I know that the public schema is not suppose
I have a legacy DOS application that I am rewriting with Postgresql as the back-end. The system was written in Foxpro2.6 for DOS and uses xBase tables. The new database is set up and running on an Ubuntu server. The programs have been completed that migrate the data to the Postgresql database. Now
I am trying to use postgresql-autodoc. The autodoc finds all the Perl
modules and compiles but when I go to /usr/local/bin and run
postgresql_autodoc like this
postgresql_autodoc -f owl -d owl -u postgres --password=''
I get a message that says
Use of uninitialized value in numeric lt (<)
>Andrew Sullivan <[EMAIL PROTECTED]> wrote on 09/19/2007 10:12:26 AM:
> It wouldn't, but your old data still need to be dumped and restored;
> and without a running 8.1, that won't help you. Unless you mean that
> you'd install 8.2.x and load from a backup.
>
Thank you for your help. I wasn't ab
>"Andrew J. Kopciuch" <[EMAIL PROTECTED]> wrote on 09/19/2007 08:31:08 PM:
> Or just run the dump through psql.
> psql -U postgres -d template1 -f /tmp/$(date +%F)owl.sql
Thank you this worked.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
*** ***
Margaret Gillon, IS De
I have a backup file from Postgresql 8.1.4. When I try to use 8.2.5
pg_restore the restore doesn't recognize the archive format. The archive
file was made with the command below. Is there a way to get 8.2.5 to
recognize the file, or a way to run the file as a script from a different
program lik
> This suggsts your init script is broken. You ought to be able to
> test whether postgres will run properly by setting PGDATA correctly,
> and then running /path/to/pg8.x/bin/pg_ctl start. Whether postgres
> will run is not exactly the same question as whether your init script
> is correct.
The
>>On Tue, Sep 18, 2007 at 03:06:32PM -0700, [EMAIL PROTECTED]
wrote:
>> account and the system's knowledge of the posgresql 8.1.4 software.
The
>> system will no longer run 8.1.4 even when I go to the /bin/ to run the
>> commands. The data is still present and so is the 8.1.4 software. I
rema
I had two versions of postgresql running on a Redhat 9 server. Today I
shut down the 7.3.4 version and uninstalled it using the RPM's.
Unfortunately, as far as I can tell, this deleted the postgres user
account and the system's knowledge of the posgresql 8.1.4 software. The
system will no long
> Date: 21 Mar 2007 00:29:33 -0700
> From: "filippo" <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Subject: Re: shell script to SQL statement: `pg_dump | psql -U`
> Message-ID: <[EMAIL PROTECTED]>
>
> On 20 Mar, 16:47, [EMAIL PROTECTED] (Tom Lane) wrote:
> > "filippo" <[EMAIL PROTECTED]
>Date: Wed, 14 Mar 2007 20:39:17 +0100
>From: Magnus Hagander <[EMAIL PROTECTED]>
>To: George Weaver <[EMAIL PROTECTED]>
>Cc: pgsql-general
>Subject: Re: DST problem on Windows Server
>Message-ID: <[EMAIL PROTECTED]>
>George Weaver wrote:
> A client has PostgreSQL 8.2.1 installed on a Windows 2000
Kenneth Downs <[EMAIL PROTECTED]> wrote on 03/06/2007 05:48:05 AM:
> [EMAIL PROTECTED] wrote:
>
> Postgresql 8.1.4 on Redhat 9
>
> I have a table which stores M:M relationships. I can't put foreign
> keys to the parents of this table because the relationships being
> stored go to several tab
Postgresql 8.1.4 on Redhat 9
I have a table which stores M:M relationships. I can't put foreign keys to
the parents of this table because the relationships being stored go to
several tables. This was done so that only two fields have to be searched
in order for all relationships to be found for
> Date: Thu, 01 Mar 2007 10:06:44 +0900
> From: Paul Lambert <[EMAIL PROTECTED]>
> To: "Joshua D. Drake" <[EMAIL PROTECTED]>
> Cc: pgsql-general@postgresql.org
> Subject: Re: PG periodic Error on W2K
> Message-ID: <[EMAIL PROTECTED]>
>
>
> I propound to all my sincerest of apologies for installin
I need to convert my database to UTF8. Is there a way to do a SELECT ...
INSERT from the old database table to the new one? Would the INSERT
correct data errors between the two data types? I only have 10 tables and
the biggest has < 8000 rows.
Running Version 8.1.4 on Redhat 9
*** *** *** ***
>Alvaro Herrera <[EMAIL PROTECTED]> wrote on 02/08/2007 02:51:52
PM:
> > [EMAIL PROTECTED] wrote:
> > Using PGADMINIII I added a column of this type to my database but when
I
> > try to update it I get an error.
> >
> > column:
> > ALTER TABLE datatype ADD COLUMN charflag "char"[];
>
> You add
>Alvaro Herrera <[EMAIL PROTECTED]> wrote on 02/08/2007 01:58:20
PM:
> The "char" type (including quotes) is a very different animal from all
> those character types the manual you quote is talking about. "char" is
> a single byte, while varchar(1) and all the rest are a single character,
> meani
>Jim Nasby <[EMAIL PROTECTED]> wrote on 02/08/2007 12:12:00 PM:
> Also, I suggest using "char" instead of just char. "char" is a
> special data type that's limited to storing a single character; the
> advantage is that it's much smaller and faster than a char.
>
> If you do end up back at using
>Richard Huxton wrote on 02/07/2007 01:33:05 AM:
> [EMAIL PROTECTED] wrote:
> > I am wondering what the limit is on the number of joins in a View or a
> > Select.
> >
> > Background: I have many tables with similar flags such as Active,
> > Inactive, High, Medium, Low. I am storing the flags
>Richard Huxton wrote on 02/07/2007 01:33:05 AM:
> [EMAIL PROTECTED] wrote:
> > I am wondering what the limit is on the number of joins in a View or a
> > Select.
> >
> > Background: I have many tables with similar flags such as Active,
> > Inactive, High, Medium, Low. I am storing the flags i
I am wondering what the limit is on the number of joins in a View or a
Select.
Background: I have many tables with similar flags such as Active,
Inactive, High, Medium, Low. I am storing the flags in a flag table and
then putting an int4 foreign key to the flag in the data tables. Some data
ta
I think the ODBC pass through engine has
been enchaned in newer versions of foxpro because many companies are moving
to SQLserver backends. At recent VFP conferences there are sessions devoted
entirely to this subject.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** **
I have not had problems with integers
but I am using a VFP class for SQL server backends that was written by
someone else. Best thing is to try it yourself. If you need support sign
up for the psql-general list. They're a good resource and have subscribers
from all platforms.
*** *** *** *** ***
Hi Mike,
I have been using Visual FoxPro with
Postgresql for two years. Currently my front end is Visual Foxpro 9. I
do not have the Postgresql on a Windows server, I am on a Linux server
that is running RedHat 9. I upgraded my Postgresql two months ago and I
am on version 8.1.4. My clients conn
>Scott Marlowe <[EMAIL PROTECTED]>
wrote on 08/07/2006 12:18:17 PM:
>
> Just FYI, text and varchar are, internally, pretty
much the same types.
> varchar has an optional precision setting as in varchar(200) while
text
> does not allow one.
>
> All the text ops are written for text types, so varc
>"Uwe C. Schroeder" <[EMAIL PROTECTED]>
wrote on 08/07/2006 11:30:28 AM:
> Well, you cast all those fields to be concatenated to text. Why should
the db
> make a varchar out of that? I seriously doubt that 7.x made a varchar
of that
> - but then, 7.2 is very very old.
> So either cast your field
"Uwe C. Schroeder" <[EMAIL PROTECTED]>
wrote on 08/07/2006 11:30:28 AM:
> Well, you cast all those fields to be concatenated to text. Why should
the db
> make a varchar out of that? I seriously doubt that 7.x made a varchar
of that
> - but then, 7.2 is very very old.
> So either cast your field
Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote
on 08/07/2006 11:41:52 AM:
> SELECT b.ltname, ((c.refullname::text || d.enname::text) ||
> f.evname::text)::varchar AS evlinkname1,
>
This worked, thank you.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
Margaret Gill
>Rodrigo Gonzalez <[EMAIL PROTECTED]> wrote
on 08/07/2006 11:36:28 AM:
> Really, I dont see the 3 varchar fields concatenated to a new field.
>
> But do this
>
> (varchar1||varchar2||varchar3||newfield)::varchar
>
> Best regards
>
This is the concatenate statement
> > SELECT b.ltname, (c
Last week I upgraded to postgresql 8.1.4
(YEAH!) In my database I have a view which concatenates three varchar
fields to a new field. With postgresql 7.2.3 the field resulting from the
concatenation was a varchar, with postgresql 8.1.4 the new field is a text
field. This is affecting all kinds of
Great, Thanks!
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
This e-mail message and any attachment(s) are for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential in
It needed /bin in the path. Works fine
this way.
/usr/local/pgsql/bin/pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql
owl
Thank you again for your help.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles
> Your confirmation is correct with one slight
technical exception:
> specifying the port doesn't technically cause the system to know
> which version of postgres to use.
>
> In my previous post, I forgot to mention a related note: the version
> of pg_dump that you're using matters slightly. pg
"Thomas F. O'Connell" <[EMAIL PROTECTED]>
wrote on 08/02/2006 02:04:35 PM:
> You'll need to specify the non-default port explicitly in your
> pg_dump command in order to back up the postmaster running on 55432.
>
> E.g., pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql
owl
>
> By d
Yesterday a consultant upgraded me from 7.3.4
to 8.1.4 on a RedHat 9 server. To make sure everything was okay we left
the server so that both versions of Postgresql load. 7.3.4 loads on the
default port of 5432 and 8.1.4 loads on port 55432 . My database was moved
into the new version so both the
> On Wed, 2006-07-19 at 09:01 -0700, [EMAIL PROTECTED]
wrote:
> > I have a junction table that is recording relationships between
two
> > records in another table. Is there a way that I can create a
> > constraint so that the values are not repeated in any order?
I want to
> > make sure that rows
Hi Richard and list,
Thanks for the reply. On the constraint
what I am trying to create is a constraint that would not let me create
a row with fkey1 = 4 and fkey2 = 10 if I already had a row that had fkey1
= 10 and fkey2 = 4. The constraint needs to check the combination
of values in any order.
I have a junction table that is recording
relationships between two records in another table. Is there a way that
I can create a constraint so that the values are not repeated in any order?
I want to make sure that rows such as 2 and 4 in the example below cannot
happen. This is a very small table
>Tom Lane <[EMAIL PROTECTED]> wrote on 04/06/2006
11:33:57 AM:
> [EMAIL PROTECTED] writes:
> > CREATE UNIQUE INDEX resource_refullname
> > ON resource USING btree (redtid, (upper(refullname)
text_ops));
>
> You need something newer than PG 7.3 to do that. 7.3 can't handle
> functional indexe
I am on version 7.3. I have been able
to build a case insensitive index to keep the refullname column unique
with the following:
CREATE UNIQUE INDEX resource_refullname
ON resource USING btree
(upper(refullname) text_ops);
However I have a table where I want
to allow a duplicate refullname
Thanks to everyone who answered my question
so quickly.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
- Forwarded by Margaret
Gillon/CLA/Chromalloy on 04/04/2006 12:52 PM -
"Stock, Stuart" <[EM
Hi Tom,
You wrote "Unfortunately Red Hat's backwards-compatibility
policy forbids dropping
new major PG releases into old RHEL branches". So that means I cannot
upgrade to Postgresql 8.x on a RedHat9 server? Currently I am using Postgresql
7.3 but was planning on upgrading before I put the databa
Publisher Whil Hentzen has been publishing
Visual FoxPro books for many years. Whil mentors developers who want to
move from Windows to open-source platforms. He has published several books
to help users and administrators transition to Linux. Whil has also fought
with Microsoft about developers r
>Martijn van Oosterhout
wrote on 02/01/2006 11:00:50 AM:
> On Wed, Feb 01, 2006 at 08:44:01AM -0800, [EMAIL PROTECTED]
wrote:
> > I have a view which I use to populate list boxes on several input
screens
> > in Visual FoxPro for Windows. In the view I concatenate three
varchar
> > columns to m
I have a view which I use to populate
list boxes on several input screens in Visual FoxPro for Windows. In the
view I concatenate three varchar columns to make a new column. The concatenation
works fine but the resulting column is a text column, which becomes a memo
field in Visual FoxPro. Memos d
>Martijn van Oosterhout
wrote on 01/25/2006 10:20:40 AM:
> On Wed, Jan 25, 2006 at 09:55:58AM -0800, [EMAIL PROTECTED]
wrote:
>
> Parhaps something like:
>
> CHECK((CASE WHEN evenid1 IS NOT NULL THEN 1 ELSE 0 END) +
> (CASE WHEN evenid2 IS NOT NULL THEN 1 ELSE 0
END) +
> (CASE WHEN
>Michael Fuhr <[EMAIL PROTECTED]> wrote on 01/25/2006
10:25:38 AM:
> In 8.1, and in earlier versions if you create a cast from boolean
> to integer, you could do this:
>
> ALTER TABLE event
> ADD CONSTRAINT two_nulls_1 CHECK (
> (evenid1 IS NOT NULL)::int +
> (evevid1 IS NOT NULL)::int +
> (evrei
>Michael Fuhr
wrote:
> ALTER TABLE event
> ADD CONSTRAINT two_nulls_1 CHECK (evenid1 IS NULL) AND (evevid1
IS
> NULL)) OR ((evevid1 IS NULL) AND (evreid1 IS NULL))) OR ((evenid1
IS NULL)
> AND (evreid1 IS NULL;
>
>Is there a requirement that exactly one column
be NOT NULL? If so
>then
Richard,
I have taken your suggestion and changed
the values to NULL for the empty foreign keys. Thank you for the constraint.
I modified it to check for NULL and it works great.
ALTER TABLE event
ADD CONSTRAINT two_nulls_1 CHECK
(evenid1 IS NULL) AND (evevid1 IS NULL)) OR ((evevid1 IS NUL
I have a table that I am using to hold
keys for M:M relationships. I have six fields that can hold the
keys and I do this because I validate the key with a foreign key constraint.
Fields evevid1, evevid2 hold keys from the event table, evreid1, evreid2
hold keys from the resource table, etc. The
There is an ODBC problem with Visual
Foxpro 9. According to a Visual FoxPro maillist:
Since VFP caches a common statement handle that it
reuses, it has to call SQLFreeStmt(SQL_UNBIND) and SQLFreeStmt(SQL_RESET_PARAMS)
to make sure the cached statement handle is in a cleared state before reusing
Alejandro,
I cannot build the list of errors because I am on
another project right now that is rush. I will trace and post the error(s)
as soon as I can.
Margaret.
> 2006/1/3, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>
> >"Alejandro D. Burne" <[EMAIL PROTECTED]>
wrote on
> 01/01/2006 04:37:10 PM:
>
>
> > 2005/12/30, [EMAIL PROTECTED] < [EMAIL PROTECTED]>:
>
> >
> > I am writing an application in Visual Foxpro 9 (running
on Windows
> > 2000) but I get
I am writing an application in Visual
Foxpro 9 (running on Windows 2000) but I get errors when VFP9 tries
to write data to my Postgresql server (Linux Redhat 9). I know the syntax
on the insert statement is good because I can run the statement in pgAdmin
and the row is created without problems. I
I know that there are some Visual FoxPro
developers on this list who use PostgreSQl as their back-end. My question
to them is...
VFP will run in WINE up to VFP version
8. But the people I talk to that are doing this are using VFP's native
tables. Does anyone know if it's possible to run VFP8 in W
> [EMAIL PROTECTED] wrote:
> > Is there a similar command in Postgresql so that the client
application
> > can find out if there's an unresolved transaction before it starts a
new
> > one?
>
> See PQtransactionStatus() in libpq; if you're using a different language
> interface, it should provide s
I am trying to adapt a class to Postgresql that was written for SQLServer.
As an error check the class counts open transactions to make sure all
previous transactions have been completed. In SQLServer there is a command
@@TRANCOUNT which tells how many transactions are open on the server for
the
I posted the message below on 1/15/05 and haven't received a reply yet.
Should I be asking this question on a different list?
Thank you.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
- Forwarded by Ma
I need to create a shell script for cron.daily to run that will do pg_dump
for my database. I am using Redhat 9 and Postgresql v7.3.4. Currently when
I run the dump manually the command I use is
#pg_dump -u -C -D -f /tmp/owl.sql owl
What should the command look like using ~/.pgpass ?
My other q
> El 12/01/2005 4:40 PM, [EMAIL PROTECTED] en su mensaje
escribio:
> > I just downloaded and installed the lastest PGADMIN III, but I didnt'
get a
> > new ODBC driver. The only file in the download was pgadmin3.msi.
> >
> > The driver I have is ODBC version 7.03.02.00 dated 10-22-2003. That is
the
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
Josué Maldonado <[EMAIL PROTECTED]> wrote on 01/12/2005 01:50:07 PM:
> El 12/01/2005 3:38 PM, [EMAIL PROTECTED] en su mensaje
escribio:
>
> > I am using updatable cursors. I set up the cursor and set the cursor
> > properties to updateab
Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:36:34 PM:
> On Wed, 2005-01-12 at 15:28, [EMAIL PROTECTED] wrote:
> > Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:06:30
PM:
> >
> > > On Wed, 2005-01-12 at 14:59, [EMAIL PROTECTED] wrote:
> > > > I am using ODBC to move Visual
Josué Maldonado <[EMAIL PROTECTED]> wrote on 01/12/2005 01:14:39 PM:
> Hello,
>
> El 12/01/2005 2:59 PM, [EMAIL PROTECTED] en su mensaje
escribio:
> > I am using ODBC to move Visual FoxPro7 tables (windows 2000 client)
into
> > Postgresql 7.x on a Redhat Linux server. All is working well except f
Scott Marlowe <[EMAIL PROTECTED]> wrote on 01/12/2005 01:06:30 PM:
> On Wed, 2005-01-12 at 14:59, [EMAIL PROTECTED] wrote:
> > I am using ODBC to move Visual FoxPro7 tables (windows 2000 client)
into
> > Postgresql 7.x on a Redhat Linux server. All is working well except for
> > Memo fields, whic
I am using ODBC to move Visual FoxPro7 tables (windows 2000 client) into
Postgresql 7.x on a Redhat Linux server. All is working well except for
Memo fields, which are Text fields in PostgreSql. I query the Postgresql
table and get a cursor, update the cursor with the data, and send it back.
The co
Thanks, Ragnar,
You are right in what is happening. The code was supposed to be sending ''
but it is sending NULL instead. I see now -- in PostgreSQL to look for any
record without the 'X' I have to use a combined condition because a NULL is
not included in a != statement.
select count(*) from re
I have a small table in which I have a Character(1) field called reengine.
The field either has an "X" or is empty. This field does not have NULL
values. There are 27 records in the table, 25 are marked with an 'X' in
reengine.
I am querying the table from pgadmin v1.1.0 for windows.
When I write
75 matches
Mail list logo
