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 fre
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 b
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#¦ Ordertype ¦ Date
1 ¦ A ¦ April
1 ¦ B ¦ May
1
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
> > 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 environmen
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?
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
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 delete.
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: su
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. Th
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 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 w
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 "
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
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 sourc
> 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, the
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 la
>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 (
>
>sele
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 (ev
> 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_
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,
> 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 in
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
> 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 s
24 matches
Mail list logo