On Wed, Mar 7, 2012 at 12:33 PM, Carlos Mennens
wrote:
> I'm trying to get the automated backup scripts to work from:
>
> http://wiki.postgresql.org/wiki/Automated_Backup_on_Linux
>
> Currently I'm using PostgreSQL 9.1.3 and have the following three files:
>
> carlos@db1:~/postgresql$ ls -l
> tota
On Wed, Feb 29, 2012 at 12:29 PM, Andy Colson wrote:
> On 2/29/2012 12:28 PM, Andy Colson wrote:
>>
>> On 2/29/2012 11:49 AM, Rich Shepard wrote:
>>>
>>> I'm trying to insert rows into a table, but some date and time columns
>>> are
>>> missing values. In the INSERT INTO ... statements of the .sql
On Fri, Feb 24, 2012 at 7:36 AM, wrote:
> How do I access it. I just did that and when I try and access it with a
>
> ERROR: relation "sessionsetting" does not exist
> LINE 1: select * from "sessionsetting"
> ^
>
> ** Error **
> ERROR: relation "sessionsett
On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton wrote:
> On 24/02/12 13:26, mgo...@isstrucksoftware.net wrote:
>
>> ALL,
>> Using 9.1.2 on Windows 7 X64 for development.
>> I'm trying to create a temporary table used to store session variables
>> CREATE TEMP TABLE iss.sessionsettings
>
>
>> When
Does anyone have any advice regarding the selection of a Python 3
module for PostgreSQL? The modules I've found so far are psycopg2 and
py-postgresql. My skill level with Python is fairly basic.
Thanks,
Andrew
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
On Fri, Oct 9, 2009 at 12:18 PM, Joshua D. Drake wrote:
> On Fri, 2009-10-09 at 09:52 -0700, Tim Bruce - Postgres wrote:
>
>>
>> I would also add that there are a LOT of performance issues with MS
>> Access. For one, in some cases filtering out records with a where clause
>> can be performed on t
On Fri, Oct 9, 2009 at 10:15 AM, Joshua D. Drake wrote:
> On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote:
>> On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure wrote:
>> >
>> > The #1 tool you have at your disposal is the human brain. I
>> > personally think GUI database tools are counter pr
On Wed, May 27, 2009 at 9:19 AM, Gauthier, Dave wrote:
> What is the (is there a) grant command that I can use to create a super
> user without having to specify all the DB objects?
>
> grant all on database foo to thesuper;
>
> and
>
> grant all privileges on database foo to thesuper;
>
> Don’t
On Tue, May 12, 2009 at 7:06 AM, Ow Mun Heng wrote:
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> On Tue, May 12, 2009 at 01:23:14PM +0800, Ow Mun Heng wrote:
> >> | sum of count | sum_of_count_squared | qty | qty < 100 | qty < 500 |
> >>
> >>
>
On Fri, May 8, 2009 at 9:37 AM, George Weaver wrote:
> Andrew Gould in reponse to George Weaver wrote:
>
> Hi Andrew,
>>>
>>
> Hi,
>>>>>
>>>>
> I have a client with a main office and a branch office about 90 miles
>>>>>
On Fri, May 8, 2009 at 9:07 AM, George Weaver - Cleartag Software <
gwea...@cleartagsoftware.com> wrote:
>
> Hi Andrew,
>
> Hi,
>>>
>>
> I have a client with a main office and a branch office about 90 miles
>>> away.
>>>
>>
> They have a server at the main office but it is not a web server.
>>>
On Thu, May 7, 2009 at 10:22 AM, Alvaro Herrera
wrote:
> Dave Page wrote:
> > On Thu, May 7, 2009 at 3:04 AM, Alvaro Herrera
> > wrote:
> > > Joshua D. Drake wrote:
> > >> Hello,
> > >>
> > >> Yeah its not general technical discussion but this little bit of news
> > >> warrants more widely read a
On Wed, May 6, 2009 at 4:53 PM, Joshua D. Drake wrote:
> Hello,
>
> Yeah its not general technical discussion but this little bit of news
> warrants more widely read attention. PgUS (http://www.postgresql.us/)
> received its 501c3 public charity status today. You can view the
> determination lette
On Tue, Apr 21, 2009 at 8:58 PM, Bill Todd wrote:
> Do I have to install anything in addition to the ODBC driver on my PC in
> order to connect to a PostgreSQL server on another PC on my network?
>
> Bill
>
>
That depends on your goals.
You can use database products such as MS Access, Crystal R
On Thu, Feb 26, 2009 at 11:36 AM, Andrew Gould wrote:
> On Thu, Feb 26, 2009 at 11:27 AM, Steve Atkins wrote:
>
>>
>> On Feb 26, 2009, at 7:12 AM, Andrew Gould wrote:
>>
>> Background: ICD-10 is a clinical coding system maintained by the World
>>> Heal
On Thu, Feb 26, 2009 at 11:27 AM, Steve Atkins wrote:
>
> On Feb 26, 2009, at 7:12 AM, Andrew Gould wrote:
>
> Background: ICD-10 is a clinical coding system maintained by the World
>> Health Organization. The system is used in most "advanced" countries.
>>
On Thu, Feb 26, 2009 at 10:06 AM, Richard Huxton wrote:
> Andrew Gould wrote:
> > Problem: I've been trying to find a table of ICD-10 codes to import into
> a
> > database; but the only listings that I can find are in publicly available
> > pdf files. I've tr
ICD-10 codes that is
already "import friendly"?
Thanks,
Andrew Gould
On Thu, Feb 12, 2009 at 5:04 PM, 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 hav
On Thu, Feb 12, 2009 at 2:51 PM, SHARMILA JOTHIRAJAH wrote:
> My data fields contains commas, tabs,'|' etc. So I cant use t hem as
> delimiters..so I need a unique may be non-character to use as a delimiter...
> -Sharmila
>
How are you backing up your data? If your backup method deals appropri
On Wed, Feb 4, 2009 at 6:18 AM, Emilie Laffray wrote:
> Hello,
>
> I am sending this email since I am hitting a snag with postgresql. I
> am currently running the following version of postgresql:
> Postgresql 8.3.5 on Windows XP Pro 32bits
>
> I am getting a crash whenever I try to perform an upda
What are composite types used for? Do they allow you to search multiple
fields for a value more easily?
Thanks,
Andrew
Please disregard. I found an SSL option in the ODBC driver configuration.
On Wed, Dec 17, 2008 at 9:18 AM, Andrew Gould wrote:
> Is anyone using MS Access and SSL to access a PostgreSQL server? If so,
> how did you get MS Access to use SSL?
>
> Thanks,
>
> Andrew
>
Is anyone using MS Access and SSL to access a PostgreSQL server? If so, how
did you get MS Access to use SSL?
Thanks,
Andrew
On Wed, Dec 10, 2008 at 4:04 PM, Joshua D. Drake <[EMAIL PROTECTED]>wrote:
> On Wed, 2008-12-10 at 15:55 -0500, Eric Schwarzenbach wrote:
> > Robert Treat wrote:
> > > On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
> > >
> > >> Greg has a good point. Ubuntu is a bit of a moving target. In
--- Andrew Gould <[EMAIL PROTECTED]> wrote:
> --- Berend Tober <[EMAIL PROTECTED]> wrote:
>
> > Florian G. Pflug wrote:
> > > [EMAIL PROTECTED] wrote:
> > >
> > >> Date and Pascal hate nulls.
> > >
> > > ...the
ormation that
may not be known at the time of data entry. However,
any data field that falls into this category should
not be required to define the relationships between
tables. This is a case where the database design must
reflect the limitations of operational processes.
Andrew Gould
---(end of broadcast)---
TIP 6: explain analyze is your friend
I just finished migrating US county level census data
into a PostgreSQL database; and thought I'd save
others the trouble of doing the same. (I've been
laid-off and am trying to stay busy.) The gzipped,
dump file is approximately 9.5MB.
Is there a place online where people share data? I
thought
--- John Harrold <[EMAIL PROTECTED]> wrote:
>
> so i have two databases 'A' and 'B'. B is alot like
> A except i've
> added alot of stuff to B like cascade on delete. Now
> 'A' is populated
> with data and i want to add the triggers to it. I
> tried inserting the
> contents of A into the schema of
--- Thomas Kellerer <[EMAIL PROTECTED]> wrote:
> Andrew Gould schrieb:
>
> > I have a couple trips coming up; and need
> PostgreSQL
> > to coexist with MS Access on my laptop.
> >
> > Should I go the Cygwin route? Or are we close to
> 7.4
> > an
I have a couple trips coming up; and need PostgreSQL
to coexist with MS Access on my laptop.
Should I go the Cygwin route? Or are we close to 7.4
and the Windows port? (Is it a matter of weeks or
months?)
Thanks,
Andrew Gould
---(end of broadcast
--- Ron Johnson <[EMAIL PROTECTED]> wrote:
> On Sat, 2003-07-19 at 08:31, Andrew Gould wrote:
> > --- Ron Johnson <[EMAIL PROTECTED]> wrote:
> > > On Fri, 2003-07-18 at 19:56, The Hermit Hacker
> > > wrote:
> > > > On Sat, 12 Jul 20
with or without authentification (like
> gmane)?
> >
> > what is gmane?
>
> That big thatch of fur around a GNU Lion???
>
> | Ron Johnson, Jr. Home:
> [EMAIL PROTECTED] |
> | Jefferson, LA USA
Check out:
t;[EMAIL PROTECTED]> 07/18/03
> 10:41AM >>>
> On Friday 18 July 2003 18:11, Andrew Gould wrote:
> > > They match up pretty much as you would expect
> > > int4=>long integer etc. One
> > > thing to watch out for is booleans - come
> through as
> >
space?
I was testing a Linux distro recently and gave /usr
lots of space, forgetting that Linux distros often
install postgresql and mysql to /var/db (or
/var/lib/db -- I forget).
If this is your problem (and you don't want to
reinstall Debian), stop the database server, move the
postgresql directory to a spacious partition, and
create a link to it in the original location.
Best of luck,
Andrew Gould
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
garding #3: What is the proper way to refer to
Unix, Linux, FreeBSD, etc., collectively?)
Have fun,
Andrew Gould
---(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
but the databases were
restored from backup files without any problems.
Dependable backups should _not_ be taken for granted!
Best regards,
Andrew Gould
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
d schema
file. This allows me to recreate the tables, restore
the data, and then recreate indexes and constraints. I
figure if the data does not comply with the
contraints, the dump was bad anyway. (This has yet to
occur.)
I can't help with the sequence field problem; but I
hope you
Are you using advanced authentication in phppgadmin?
Could this be caused when phppgadmin is configured to
have the database superuser connect to template1 to
manage user logins?
Andrew Gould
--- Martin Marques <[EMAIL PROTECTED]> wrote:
> OK, the picture is the latest CVS of phpP
creates a
"null_value" field to account for records without
values for the crosstab. (Initially, I called it
"Null"; but I got nervous about using the word as a
column title.)
Andrew Gould
---(end of broadcast)---
TIP 9: th
cases where MS Access would crash or would
not respond after PostgreSQL was done with its job.
I'm still hopeful for the future; but it's not ready
for any level of production use.
I look forward to seeing the native Windows port of
PostgreSQL. Will performance be comparable to Unix
ve
ating the tables into topics using schemes.
Unfortunately, the resulting data dumps would be huge.
The alternative, pg_dumping individual tables, would
result in a very high number of backup files to
manage.
Is there a way to pg_dump a scheme at a time?
Thanks,
Andrew
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current datetime and the query statement. My thought
was to accomplish this by creating
To update all existing records with empty values:
update table1
set datefield = null;
To insert an empty value into a new record:
insert into table1 (datefield) values (null);
Best of luck,
Andrew Gould
--- kingking <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> How to stor
You're just missing 'group by', and a little
simplicity.
Try this:
select job_num, count(job_num) as frequency
from search_records
group by job_num
order by frequency desc
limit 10;
Have fun,
Andrew Gould
--- Adam <[EMAIL PROTECTED]> wrote:
> I help run a job data
You might also want to look at the SQL command
CLUSTER, which physically reorders the table rows
based upon an existing index.
Andrew Gould
--- Ian Barwick <[EMAIL PROTECTED]> wrote:
> Mike S. Nowostawsky wrote:
>
> > How can one select only a certain number of
>
This kind of sad news is coming all too frequently
now.
I wish you all the best.
Andrew
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
> Effective tomorrow, Great Bridge LLC will cease
> operations. Full
> information can be obtained from:
>
> http://www.greatbridge.com/
>
> Great Brid
ake sure you don't do so in the
> interim :-)
>
> - Original Message -
> From: "Andrew Gould" <[EMAIL PROTECTED]>
> To: "J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Thursday, September 06, 2001 7:51 AM
> Subj
I notice that template0 can't be vacuumed; and that
template1 gets vacuumed but has "no relations" per \d.
What do these databases do?
I have a python script that finds all database names
per 'psql -l', vacuums and analyzes them ('vacuumdb -a
-z'), and then pg_dumps them through gzip into
separa
oops. Too late to use that option; but thanks!
Andrew Gould
--- Justin Clift <[EMAIL PROTECTED]> wrote:
> Hi Andrew,
>
> These functions were indeed created by PgAdmin. It
> seems to create
> tables, functions, triggers and views (maybe rules
> too, not sure) going
&
pgadmin* and am trying to weed out everything created
by PgAdmin.
Thanks,
Andrew Gould
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---
s may have
changed since then.
The online documentation for PostgreSQL has been very
helpful; and the support on this email list is very
good.
I hope this helps,
Andrew Gould
--- Ivan Babikov <[EMAIL PROTECTED]> wrote:
> Hello All!
>
> Maybe this is one of those typical questions,
If orf is not associated with a primary key or unique
index, the possible combinations might well exceed
14,000. For example, if 3 records in yeast1 and 4
records in temp share the same orf value, the query
will update yeast1 12 times (i.e. the 3 yeast1 records
will be updated 4 times each).
Can
I think you have a syntax error in the SELECT
statement. What is RECHNUNG? The only table reference
that I see is t6.
If RECHNUNG is the database, connect to the database
and try:
Select * from t6 where bruttosum = 0034.70
order by nummer desc;
Best of luck,
Andrew Gould
--- Johann
If a data analyst needed to perform analysis (select
statements only, no updates, creates, etc) while
traveling, would it be feasible to put a database on a
DVD? Could PostgreSQL use it? Does the use of oid's
eliminate such possibilities?
Andrew
ic code in your application
that looks specifically for Access tables.
I did this under PostgreSQL 7.0.2. I think it should
still work under 7.1; but can't make any promises.
Best of luck,
Andrew Gould
--- Jüri Fjodorov <[EMAIL PROTECTED]>
wrote:
> hi all!
>
>
>
I use MS Access as a front-end to PostgreSQL. Not
only can I link tables from different PostgreSQL
databases, but I can link tables from different ODBC
compliant database products such as MySQL, MS Access,
PostgreSQL, and Sybase.
I hope this helps,
Andrew Gould
--- Hervé Piedvache <[EM
between data fields.
PostgreSQL doesn't handle this situation. If you have
problems with this part, let me know. There are ways
to fix this problem.
Best of luck,
Andrew Gould
--- S R <[EMAIL PROTECTED]> wrote:
> Hello, please, I need urgent to know if postgresql
> has
>
x Linux, 1 x FreeBSD. My
largest table has 8,591,561 records. There are
advantages to having Access or Excel handle adhoc
report formats and Linux/FreeBSD handle the heavy data
processing. (My 2 cents.)
Andrew Gould
--- Evelio Martinez <[EMAIL PROTECTED]>
wrote:
>
> Hello!
>
>
I don't know what it means; but I kept getting similar
message when accessing a PostgreSQL 7.0.3 table via
ODBC from MS Access. As it was occurring with one
table only, I deleted the link and reattached the
table. This seemed to solve the problem.
I hope this helps,
Andrew Gould
--- S
This algorithm
allows for any combination of text and numeric fields.
Thank you for the suggestion though. I am trying to
learn more about regular expressions.
Andrew Gould
--- Jeff Eckermann <[EMAIL PROTECTED]> wrote:
> Isn't this overkill?
> Something like:
> sed -e
gh, my brain is still a little tired.
Thanks again,
Andrew Gould
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> - Original Message -
> From: "Tom Lane" <[EMAIL PROTECTED]>
> To: "Andrew Gould" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTE
How do you drop a column from a table? I'm using
PostgreSQL 7.0.2.
Thanks,
Andrew Gould
__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
Hi all,
What psql or sql commands can be used to view the
structure of a table?
I've been reading through the documentation online and
can't find the answer.
Thanks,
Andrew Gould
__
Do You Yahoo!?
Send instant messages & get ema
64 matches
Mail list logo
