In article <[EMAIL PROTECTED]>,
Sam Mason <[EMAIL PROTECTED]> wrote:
>I'm not quite sure if this would help your use case, but a few editors
>allow you to send blocks of text to other processes. For example, under
>Emacs I can hit Ctrl+C twice and it will grab the current paragraph
>and send it o
In article <[EMAIL PROTECTED]>, Andrus Moor <[EMAIL PROTECTED]> wrote:
>I need to create temporary table with data which is dropped at end of
>transaction.
>
>CREATE TABLE t1 ( c1 INTEGER ) ;
>INSERT INTO t1 VALUES (1);
>CREATE TEMP TABLE t2 AS SELECT * FROM t1 ON COMMIT DROP;
>
>Causes ERROR: sy
i installed mandrake 10 on my pc, and i choose postgresql as db, i installed
it before in windows, but in linux i dont have idea what happends, i
remebered that i should create an user, but in linux the process is auto and
i when i try to connect by pgadmin i dont know user and password =(
i wr
nt on using that
function, but I thought I'd as first if there was a better way.
Thanks.
--
Rick Otten
rottenwindf...@gmail.com
n reference table to either cascade
or stop the delete once I decide which I'd rather do.
Thanks for the help!
On Mon, Jun 22, 2015 at 12:21 PM, Tom Lane wrote:
> Rick Otten writes:
> > Hello pgsql-general,
> > I'd like to set up a foreign key constraint to a foreign tab
this or run
into performance issues.
On Mon, Jun 22, 2015 at 1:06 PM, William Dunn wrote:
> Hello Rick,
>
> As I understand it you are correct. Oracle/DB2/Postgres and I think the
> SQL Standards to not implement constraints against tables on foreign
> servers. Although it wo
Do I need to vacuum after an alter table command?
Does it matter if there is a default or if we accept NULLs for the new
field?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is there a way to identify ldap connections to pgsql 9.3 from log files?
Thanks,
Rick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I was hopping that in a SELECT I could replace the data from the email
column to something else...
maybe email = name_first + name_last? Is that possible?
I can't overwrite the data into that column... that has to be done by
the select (if possible)
SELECT , , ..., name_first || ' ' || name_
other
sequences that are contained in my database and it appears that my
permissions are ok.
Does anyone have any suggestions for any other settings I should verify?
Thanks in advance.
Rick Hackenberg
Business Systems Analyst
PRIMEDIA
Enthusiast Media
6405 Flank Drive
Harrisburg, PA 17112
717-540
I'm developing an application that will be used by several independent
customers. Conceptually, the data from one customer has no relation at
all to another customer. In fact, each customer's data is private, and
you would never combine data from different customers. I'm trying to
decide whe
I've read the earlier threads on whether to store images in the database
or filesystem. I think I understand the pros and cons of each method,
but I have a question on a specific use case.
Let's say I have a web app, and I want to display the images in a web page.
a) if the images are in the
We are looking for a Postgresql Architect/Developer to do some mentoring,
training, knowledge transfer and implementation for a large media outlet in
Los Angeles. Travel is fully funded and the rates are great! Please reply
to [EMAIL PROTECTED] Thank you for your time!!!
Regards,
Ricky G
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care about performance problems, only
things that might break.
---(end of broa
Tom Lane wrote:
Rick Schumeyer <[EMAIL PROTECTED]> writes:
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care
Steve Crawford wrote:
BTW, why not upgrade to the latest version?
Cheers,
Steve
Mostly because its not my server :-) I've suggested that, we'll see.
I appreciate the comments regarding type casting. I'll be sure to look
out for that.
---(end of broadcast)
I think an intro presentation for Oracle developers should include:
-- sqlplus to psql comparison
-- how to setup OS authenticated users in PostgreSQL
-- purpose of pg_hba.conf
-- schemas and search_path.
-- where to find things in the catalog. information_schema or pg_tables
Rick
hundreds of web pages. It won't
help much with the first set of changes, but it will help with
portability later.
Rick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 8/5/2017 6:06 PM, Dan Cooperstock at Software4Nonprofits wrote:
(I wish Postgres had a web-based community board,
rather than just this mailing list with no history available!) I will
post it to Appeon as an actual bug if I get stuck.
Have you looked here?
https://www.postgresql.org/list/
isco group
where the last update/meeting was 2 years ago. Is there such a group in this
area? Thanks.
--
Rick Genter
rick.gen...@gmail.com
Does ‘minute from interval’ only accept string literals?
>
>
>
> Thanks,
>
> Adam
>
>
>
> Adam Bruss
>
> Development Engineer
>
> AWR Corporation/Simulation Technology & Applied Research
>
> 11520 N. Port Washington Rd., Suite 201
>
> Mequon, WI 5
On May 2, 2011, at 10:52 PM, Craig Ringer wrote:
> SSN? What if they don't live in the US or aren't a citizen?
Non-citizens can have SSNs (they have to if they work in the US).
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
u can't update achievement_attempt_id in
the achievement_attempt table if there is an achievement_attempt_actions
record that refers to it since that would break the reference. (Not that you
want to be updating primary key values in the first place...)
--
Rick Genter
rick.gen...@gmail.com
On Thu, 2011-05-05 at 15:05 -0400, jtke...@verizon.net wrote:
> Im trying to connect my WS to a postgresql database (destination) via
> a middle server
> I.e.
> WS > Middle > Database
> server server
> 172.x.2.4 172.x.4.12
>
>
> I can crea
.
>
So your data is denormalized? (The "category" appears in 2 tables?) Don't do
that. Create a view that joins your two tables together instead if you need
a single entity that contains data from multiple sources. Then you won't
have any of the data integrity issues you
sers EXECUTE access to the functions. The functions run
as the user that created them, so they will have direct INSERT/UPDATE/DELETE
access to the tables while your regular users won't.
--
Rick Genter
rick.gen...@gmail.com
lieve that this accomplishes the goal (increasing available drive space)
with a minimum amount of down time. Am I thinking correctly, or have I
missed something?
--
Rick Genter
rick.gen...@gmail.com
#x27;s not the OLTP just a simple OLAP
> where data is fetched and stored in some meaningful format.
>
>
> What are benefits & why we used memcahed?
>
> What are the bottlenecks to meet?
You need to read about memcached. Memcached is not something you "enable&
On May 16, 2011, at 10:31 PM, Adarsh Sharma wrote:
> Rick Genter wrote:
>>
>> On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
>>
>>
>>> Dear all,
>>>
>>> I need to research on Memcache in the next few days.
>>>
>>&
QL30'. Object reference not set to an instance of an object.
(Microsoft.DataWarehouse)'
If I select 'SQL Command' as the Data Access mode, and enter any SQL Command
(eg select * from PostgresTable) and hit the Preview button, the expected data
is returned.
My question is why can it not return t
ate for a "hacker list".
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you can add 360 degrees to a long and get a value that should continue to
work. So, assuming "West" is negative, -175 (175 degrees West) is the same
as -175+360 = 185 (185 degrees East). Then you don't have to worry about
wraparound. If the result is > 180, subtract 360.
--
Rick Genter
rick.gen...@gmail.com
> any difference. If
> I leave out the old alias, it complains about the columns being ambiguous.
> How should the query above be changed to be syntactically correct?
>
> Thanks,
> Andy
>
--
Rick Genter
rick.gen...@gmail.com
is should return a recordset where each row has one column which is the
result of regex_replace() on the corresponding row of table.
--
Rick Genter
rick.gen...@gmail.com
T: PL/Python function "mysum"
-- NOTICE: UNBOUND
-- CONTEXT: PL/Python function "mysum"
mysumagg
--
0
(1 row)
Thanks for any pointers on what I'm missing from the way to handle the
agggregate definition.
--
Rick Harding
@mitechie
http://blog.mitechie.com
On Tue, 14 Jun 2011, Tom Lane wrote:
> Rick Harding writes:
> > CREATE OR REPLACE FUNCTION mysum(curr integer, vals group_data)
> > RETURNS integer
> > AS $$
> > try:
> > curr = curr + vals['weight']
> > except Un
clear.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
a pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
--
Rick Genter
rick.gen...@gmail.com
.4. The semicolon is required.
On Tue, Jun 28, 2011 at 3:53 PM, Rich Shepard wrote:
> On Tue, 28 Jun 2011, Rick Genter wrote:
>
> Silly question, but did you try it with a semicolon after the drop table?
>>
>
> Rick,
>
> See my answer to Andy: that's incorrect sy
> Can anyone suggest a way forward?
>
>From the message I'd say that the drupal user doesn't have access to the
sequence, which is a separate object from the table.
--
Rick Genter
rick.gen...@gmail.com
On Thu, Jul 7, 2011 at 10:26 AM, Dave Coventry wrote:
> Hi Rick,
>
> Thanks for the response.
>
> What is "the sequence"? and how do I grant the privileges needed to
> insert data into the database?
>
> Is it a postgres issue?
>
Yes. I don't know drup
; there are in the other tables.
>
> I am a bit perplexed by what is happening here.
>
> Cheers
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
l.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
mid. (And for 9.2, as I
understand it, q.mid as well, since I believe in 9.2 PostgreSQL will be able to
compute the result strictly from the indexes without hitting the base tables.)
--
Rick Genter
rick.gen...@gmail.com
of this set"). It seems odd that this should work:
-- drop unique index
-- single update statement
-- apply unique index
But just "single update statement" won't.
--
Rick Genter
rick.gen...@gmail.com
restore.exe : pg_restore: implied data-only restore
At line:1 char:2
+ & <<<< 'C:\Program Files (x86)\PostgreSQL\8.4\bin\pg_restore.exe' -v
--use-list=backup.list -U blahblah -p -C backup.db
+ CategoryInfo : NotSpecified: (pg_restore: implied data-only
int is too difficult to express in SQL, and just rely on the
business logic never being wrong. I was hoping that wasn't the case :)
Thanks,
-Rick-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
quot; specified in USING clause does not exist in
left table
I am rather mystified by this, since this field is definitely in the
dnasample table, as the primary key. Nor do not see how to start debugging
such an error. Any suggestions appreciated...
--Rick
--
Sent via pgsql-general mail
throughput, but nothing
indicating that O_SYNC doesn't work.
Can anybody provide me any pointers on this?
Thanks
--Rick
smime.p7s
Description: S/MIME Cryptographic Signature
Definitely believable. It gives me an internal avenue to chase down.
Thanks
--Rick
Alvaro Herrera wrote:
Rick Weber wrote:
While working on tuning my database, I was experimenting with changing
the wal_sync_method to try to find the optimal value. The really odd
thing is when I
erely,
Rick
Details of the code follow:
Here is the basic COPY command, which I run as the postgres user, to import
the CSV files:
COPY allcalls FROM '/data/allcalls-csv/sub3ab' WITH CSV;
Here is what some sample data look like in the files:
3153371867,2008-02-04 16:11:00,1009,1,40
212
Thanks Dim; I was not aware of pgloader. This, and the other suggestions,
have helped a lot; thanks everyone.
--rick
On Mon, Mar 29, 2010 at 7:41 AM, Dimitri Fontaine wrote:
> Rick Casey writes:
>
> > So, I am wondering if there is any to optimize this process? I have been
> usi
2740:FATAL: timeline 2 of the primary does
not match recovery target timeline 1
2011-12-15 12:08:52.323 EST2742:FATAL: timeline 2 of the primary does
not match recovery target timeline 1
... repeated continuously ...
Any thoughts on the above snippets? Am I interpreting the documentation
correctly? Is there any further information needed to debug this?
Thanks,
Rick
xpected in the SR only setup configuration case?
On Sun, Dec 18, 2011 at 9:51 PM, Fujii Masao wrote:
> On Fri, Dec 16, 2011 at 3:59 AM, Rick Pufky wrote:
> > Any thoughts on the above snippets? Am I interpreting the documentation
> > correctly? Is there any further information need
I want to be able to search a list of articles for title words as well as
author names. I understand how to do the title words with the full text
searching. But I'm not sure the best strategy for the names. The full text
parser "parses" the names giving undesirable results.
For example,
select
You can get extra (undesirable) results, depending on the name. For
example, if you are searching for the last name of "Ricks", you will also
find all authors whose first name is "Rick".
I also noticed that the directions for indexing multiple columns don't seem
to be
EXT: PL/pgSQL function "logpedigreesdel" line 4 at assignment
Would *really appreciate* any suggestions! This could help us decide
whether to PostGres for a major project...
thanks --rick
---(end of broadcast)---
TIP 8: explain analyze is your friend
misleading if this
is not the case.
Regards,
Rick
Rick Casey, Research Associate
Institute for Behavioral Genetics
[EMAIL PROTECTED]
303.735.3518
Rick Casey wrote:
Hello all,
I am trying to a simple thing: create a log history of deletes, and
updates; but which I am having trouble getting to work in PG
ig.sql:1: ERROR: OLD.famindid =
Regards,
rick
Tom Lane wrote:
Rick Casey <[EMAIL PROTECTED]> writes:
Here is the code that creates the delete trigger:
create trigger PEDIGREES_hist_del_trig
AFTER DELETE
on PEDIGREES
EXECUTE PROCEDURE logPedigreesDel();
I think you f
I have two related tables, “item”
and “book”. I have defined
a view, “bookview”
that contains fields from item and book.
My goal was to have all
inserts, updates, and deletes performed
on bookview rather than on
the tables directly. I was able
to do this with ON INSERT
and ON UPDAT
test case I can
think of. Any suggestions would be appreciated!
Thanks,
Rick
> I think you have created a statement level trigger (If they existed in
> 7.4.7...) by not including FOR EACH ROW in your create statement. In
> statement level triggers, there is no OLD or NEW.
>
>
I suspected that might be part of the answer.
Would some combination of triggers work instead? I've played
with those too, but without success.
>
> This is an ancient gotcha: as soon as you delete the book row, there is
> no longer any such entry in the bookview view ... and "old.id" is
> effe
I tried that, but I get a "...violates foreign-key constraint" error.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Bruce Momjian
> Sent: Friday, February 25, 2005 6:23 PM
> To: Rick Schumeyer
> Cc: &
# etc for 5 statements.
my %hash = (
'Column Label 1' => $ret1,
'Column Label 2' => $ret2,
#. etc...
);
return \%hash;
}
So, you should read about associative arrays (aka hashes) and references.
Rick
---
Hey, thanks to everyone who replied to my questions: problem solved!
I needed to: 1) do BEFORE DELETE to see the OLD variables, and 2) use a
placeholder in my format string in the RAISE EXCEPTION/NOTICE statement.
Open source newsgroups rock!
--rick
Rick Casey, Research Associate
Institute for
I’m interested in comparing the performance of postgresql
and mysql
on various combinations of user loads and database sizes.
I have seen
a few statements to the effect of “mysql is faster for
small, low use
applications, but postgresql is better for bigger stuff”.
I would like
to run
This will not answer you question, but documents some of the evidence
for you:
http://www.geocities.com/mailsoftware42/db/
Rick Casey, Research Associate
Institute for Behavioral Genetics
[EMAIL PROTECTED]
303.735.3518
Rick Schumeyer wrote:
I’m interested in comparing the performance of
bs real,
snr real,
rvelreal,
cfarsmallint);
COPY data (fid,rid,range,snr,bs,rvel,cfar,x,y,z) FROM
'/home/rick/bed/data/data.dat';
select count(*) from data where fid=2 and rid=6;
select count(*) from data where x > 5000 and x < 5500;
select c
That site produces some sort of php error.
I don't suppose this information is available elsewhere?
> Stop now. I've not looked at your test results, and frankly there is no
> point. As it ships, PG should run fine on a small corner of an old
> laptop. It will not perform well with any sort of se
,rid);
create index fidx on data
(x);
-- COPY a table with 934500
rows
COPY data (fid,rid,range,snr,bs,rvel,cfar,x,y,z)
FROM '/home/rick/bed/data/data.dat';
-- VACUUM
vacuum analyze data;
I’m trying to install the version of tsearch2
distributed with pg 8.0.1. “make” and “make install”
runs with no apparent problems, but “make installcheck” fails.
Looking at the diffs, I would guess that the differences are
inconsequential. But I would like to be sure before proceeding.
Chris Browne wrote:
[EMAIL PROTECTED] ("Uwe C. Schroeder") writes:
On Saturday 08 October 2005 21:07, Chris Browne wrote:
2. The code base was pretty old, pretty creaky, and has a *really*
heavy learning curve.
It was pretty famous as being *really* difficult to build; throw
tog
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation?
MySQL brings to the table an impressive AI interface that knows what you
really meant to do and thus does away with those pesky error messages.
After all, who wants to be told that -00-00 is not a date, or
I have a database in pg 8.0.4 that is encoded as UNICODE. Somehow,
some “strange” characters made it in there. Mostly, several
instances of ‘ (apostrophe) are really some extended character. They
display in a text editor as \222 (or something similar). I’m not
sure how that happened, bu
nd it chugs along great even on a low-end Sempron with 384 MB
RAM. Provides a nice way to get interactive info into a mapping system.
Regards,
Rick
Thanks,
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
Richard Huxton wrote:
Dann Corbit wrote:
I can see plenty of harm and absolutely no return. We are talking about
blank padding before comparison. Do you really want 'Danniel '
considered distinct from 'Danniel ' in a comparison? In real life,
what does that buy you?
100% YES!
If two va
In article <[EMAIL PROTECTED]>,
Welty, Richard <[EMAIL PROTECTED]> wrote:
>crappy disk drives and bad windows file systems, nothing more.
Could even be crappy memory.
--
http://yosemitecampsites.com/
---(end of broadcast)---
TIP 4: Have you search
is taken almost verbatim from the tsearch2
documentation.
Any help is appreciated!
\i
/home/rick/ftp/postgresql-8.1.0/contrib/tsearch2/tsearch2.sql
CREATE TABLE t (a varchar(20),
b varchar(20));
INSERT INTO t (a,b
ong about this?
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Andrew J. Kopciuch
> Sent: Wednesday, November 23, 2005 12:08 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] tsearch2: more than one ind
I hope pg-general is the correct forum for this question…if
not please let me know the correct location.
I have a pg application that uses tsearch2. I would
like to move this application off my local machine and onto a web host
somewhere. I have some questions regarding this:
1)
mandprompt...my initial guess is they do not support
my*** ?
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Friday, September 29, 2006 5:05 PM
To: Rick Schumeyer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg web hosting with tsearch2?
Rick Schumeyer
ic.file (vfs_id, vfs_type,
vfs_path, vfs_name, vfs_modified, vfs_owner, vfs_data) TO stdout;
Thanks,
Rick
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure recently.
If I got an error like this when trying to dump a db from the mangled
data
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful. I think this is a
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful
Ray Stell wrote:
On Thu, 19 Oct 2006 06:14:46 -0600, Rick Gigger wrote:
I think we've got it figure out though. We were able to patch up the
db enough to extract the data with some help from google and old
postings
from Tom.
It would be really great if you put down the specifics of w
Rick Gigger <[EMAIL PROTECTED]> writes:
To make a long story short lets just say that I had a bit of a
hardware failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to say it's totally hosed or is there some
chance of reco
I confess to having once written code that prints something like
"Items # 1 to 10 of 45"
by using select count(*) from t where condition; and select * from t
where condition limit 10 offset x;
I now know this is "bad", I guess because of the count() and the offset.
So what is the preferred way
n OWNER TO rick;
The user 'rick' does not exist on the target system. I've looked at the
help for pg_dump...it looks like specifying "no-owner" will skip these
lines. Are there any side effects I need to be aware of?
The second problem is the statement:
CREATE PROCEDU
I am transferring a database from a system where I am a pg superuser to
one where I am not.
The database uses tsearch2. I am unable to install any of the
functions. For example:
CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
AS '$libdir/tsearch2', 'gtsvector_in'
LANGUAGE c ST
My database locale is en_US, and by default my databases are UTF8.
My application code allows the user to paste text into a box and submit
it to the database. Sometimes the pasted text contains non UTF8
characters, typically the "fancy" forms of quotes and apostrophes. The
database does not
Albe Laurenz wrote:
My database locale is en_US, and by default my databases are UTF8.
My application code allows the user to paste text into a box and
submit
it to the database. Sometimes the pasted text contains non UTF8
characters, typically the "fancy" forms of quotes and apostr
I think this can be done with one SQL statement, but I'm not sure.
I have two tables: table t contains key k, another field f, and a bunch
of other stuff.
In a poor design decision, table tsubset contains a small number of
"pointers" to t. I should have used the k column; instead I used the
Thanks for the suggestion...it needed only one small change:
update tsubset set k = t.k from t where t.f=tsubset.f;
Thanks!
Alban Hertroys wrote:
Rick Schumeyer wrote:
foreach f in tsubset
update tsubset set k=(select k from t, tsubset where t.f=f);
end
Can this be done with one SQL
I am trying to copy a database that uses tsearch2 from pg8.1 to pg8.2.
All I did to install tsearch2 was cd to the contrib/tsearch2 directory,
then make, make install.
I then dumped the database from pg8.1 and used psql -f filename db to
load in into pg8.2.
Attempting a query gives an error
load the result of
running pgdump on the 8.1 database, and ignore the errors?
Oleg Bartunov wrote:
Rick,
did you load tsearch2 itself into your database ?
Oleg
On Thu, 7 Dec 2006, Rick Schumeyer wrote:
I am trying to copy a database that uses tsearch2 from pg8.1 to pg8.2.
All I did to
This may be bad design on my part, but...
I have three tables of interest...Account, Employee, and
AccountEmployeeRelation. There is a many-to-many relationship between
accounts and employees. The join table also contains a column
indicating what role the employee plays on this account.
My
I'm developing a system using Ruby on Rails (with ActiveRecord) and
postgres. (Although I think my question is still relevant for, say,
java with hibernate.)
I have two classes (tables): users and employees. A user is an account
that can logon to the system, while an employee is...umm...an
1 - 100 of 211 matches
Mail list logo
