I am going to write an application tht writes big amounts of plain text
into a database.
What kind of data are those? Articles? News/mail messages? Other?
I thought of using the text type for this, but I don't know if it has a
maxlenght, and given that these will be very long texts I
On Sun, 13 May 2001, Louis-David Mitterrand wrote:
* On Thu, May 03, 2001 at 07:45:23PM -0400, Vince Vielhaber wrote:
On Thu, 3 May 2001, Ludwig Meyerhoff wrote:
Hallo!
Maybe this is a bit off-topic, as this problem is more a design-one, but
I wanted to write a web-application
Could u just tell me if it is possible to have a Windows Client and the
Server running on Linux and having Postgres and the two communicate thru
something like the ODBC.
Yes, although it's preferable to use a native library.
Does Postgres have anything for the advanced features like OleDB
I'm partial to the ZEOS Database Explorer myself. I don't have experience
with a multitude of tools, so the best I can offer is that I have no
problems with the latest version :) Actually, I can tell you that it has the
advantage of a native interface (rather than relying on ODBC). And it's
free,
When the name of a sequence auto-generated from a SERIAL type would be
longer than 32 chars, it appears that CREATE TABLE uses a different
name truncation algorithm than DROP SEQUENCE. Example below. Note
the difference between the following:
'process_state_subscripti_id_seq'
Alexander Lohse [EMAIL PROTECTED] writes:
...
INTERSECT
select events.id from events,event_ref,teams,orgs,pers where 1=1 and
(lower(events.head) like '%web%'
or lower(events.search) like '%web%'
or lower(events.ort) like '%web%'
or lower(events.text) like '%web%'
or (events.id =
This is pretty horrid: you are generating a cross product of
events * event_ref * teams * orgs * pers and then selecting rows
multiple times out of that very large set. No wonder you lost
patience even with a small test database. I think you wanted
something like
...
INTERSECT (
select
Alexander Lohse [EMAIL PROTECTED] writes:
Would it also possible to make multiple INTERSECTS?
How do these operate on each other, do I also use parentheses?
Yes, if you don't want to think hard about what the precedence is
(I don't recall either) ...
regards, tom lane
Kinda hard to believe.
I know it, but that's what I am seeing. (to recap, my trigger only
fires on the first insert per connection.)
This will be kind of long, it's a spliced-together version of my psql
client session and the server log. I drop and re-create the procedure
and trigger,
I rebuilt with these changes and am seeing a 30-40% improvement in average performance
for
my high-contention high-volume copy case. I still need to do some more testing, but
this really
seems to help.
Thanks a lot Tom!
Tom Lane wrote:
I have committed some changes into development
This article could be huge for those looking to sell Postgres to
a company. I'm printing out a copy for myself ;)
Open Source Code: A Corporate Building Block (ZDNet)
http://dailynews.yahoo.com/h/zd/20010514/tc/open_source_code_a_corporate_building_block_1.html
Brent
Internet is putting lot of competition fire heat under Microsoft SQL
Server
Your boss will tell you - "Now, that we have high speed internet
connection
why do you need commercial SQL servers?? Simply use your mouse button,
click and
download the open-source Postgresql, InterBase or MySQL "
On Sat, 12 May 2001 13:00:35 -0300, David Stevenson [EMAIL PROTECTED]
wrote:
I am a new user of PostgreSQL and Linux. I have my Linux up and running and
my PostgreSQl semi-configured. I can get into PostgreSQL using super user
on root and then super user into postgres. The problem is when
I'm looking for a way to save jpg's in a postgresql table.
Does anyone know how I can do this?
TIA
Stuart
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
On Mon, 14 May 2001, Andrew Snow wrote:
I note that it still is not possible (v7.1.1) to have a table with a foreign
key check on an inherited column for rows in child tables. Will this ever
be supported, and what is the status of work on this feature?
It will eventually be supported.
Hello,
I want next :
a) add constraint (primary and foreign) in existing table
b) temporary disable constraint and enable later
Is it possible in Postgresql ?
Haris Peco
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1:
Earlier I posted with my problems about the WAL logs eating up all my
diskspace. I tried the solutions offered--checkpoint after a big copy and
shortening the time between flushes. They helped somewhat.
Unfortunately, the problem snow seems to happen when I vacuum-analyze after a
big
On Mon, 14 May 2001, snpe wrote:
Hello,
I want next :
a) add constraint (primary and foreign) in existing table
b) temporary disable constraint and enable later
Is it possible in Postgresql ?
Sort of...
You can add foreign key constraints using ALTER TABLE ADD
On Mon, 14 May 2001, Gregory Wood wrote:
Could u just tell me if it is possible to have a Windows Client and the
Server running on Linux and having Postgres and the two communicate thru
something like the ODBC.
Yes, although it's preferable to use a native library.
Is ODBC that bad?
create table tmp (create_datetimestamp);
#insert into tmp values('2001-04-01 02:29:52');
INSERT 1021715 1
#select * from tmp;
create_data
2035-05-29 01:33:36-05
(1 row)
Before start PostgreSQL on FreeBSD. Set environment variable TZ (time
I am trying to connect to postgres from a cgi script. In order for it to connect to
postgres,
I need to create a new postgres user that matches the Unix owner of my Web files. I
don't get an error on create user, but I cannot find a pg_shadow file. Is the
pg_shadow file supposed to be in my
Please help, I am trying to write an SQL statement but with no success as I am just
starting out with sql.
I have a table with 3 columns: Account# ,OrderType and date
example of data:
Account#brvbar; Ordertype brvbar; Date
1 brvbar; A brvbar; April
1
Hello
I am going to write an application tht writes big amounts of plain text into a
database.
I thought of using the text type for this, but I don't know if it has a maxlenght, and
given that these will be very long texts I started wondered if these would have to be
blobs... but they aren't
Barry Lind [EMAIL PROTECTED] writes:
Given what you say below, I think there is a documentation bug then. In
Section 9.3 of the Administrators Guide it says:
After a checkpoint has been made, any log segments written before the
redo record are removed, so checkpoints are used to free
24 matches
Mail list logo