The only thing that I can offer is that it works from inside psql as user
postgre but NOT from invoking postgres using -f filename from the commas line
as user postgre. I have to admit that I did not use -U as OS user postgres, but
that shouldn't be necessary with a stock gnarled_conf file.
Th
Not needed if you are logged in as user postgres in your OS when you enter
psql.
At least, with the hba_conf file the way it is stock.
But a good point, though. I wonder if I would then have to know the DATABASE
password for postgres if I wasn't user postgres in the OS?
Dennis Gearon
lan text dump. I don't have huge databases yet, so to make it easier to
go
between versions, I use a text backup.
Hope that answers your questions.
Dennis Gearon
Never, ever approach a computer saying or even thinking "I will just do this
quickly."
_
It turns out that I had made the export from psql, a text based export.
So I read that it was actually needing to be imported using '\i
filename_in_local_directory'
Dennis Gearon
Never, ever approach a computer saying or even thinking "I will just do this
quickly."
ql -d database_name
-f the_file.sql
I get errors on \N and various other problems. I've tried dividing the file up
into:
table creation
one 'copy' of a table at a time.
One, a 35 mbyte seems to have errors on semi colons.
Dennis Gearon
Never, ever approach a computer saying or even t
st tested, theory based
practices. They just make the tech world a better place with some of the most
reliable, best supported OSS out there.' And you guys and gals ARE that
description.
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mis
arehousing/map reducing arena before I'd
consider THAT. And there's 'flavors' of Postgres that will do that, anyway.
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from
, but never explicitly
says that's how it's stored. Nor does it use one of the nice, blue headered
tables for UUID (or ENUM) showing storage and other attributes as it does for
numeric, character,boolean, date/time, binary, monetary, geometric, or network
types.
Dennis Gearon
Si
Good catch! The article is:
http://www.informit.com/articles/printerfriendly.aspx?p=25862
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
idea to learn from others’ mistakes, so you do not have to make them
ef-498e87a3e4b3
fa597e9c-ae35-461e-b15f-498e87a3e4b7
f3c46abf-a6b0-4c9c-b22d-498e87a3e4bb
fc868307-d1b1-4253-91d7-498e87a3e4bf
b79679a9-4359-42a1-bf46-498e87a3e4c3
d91bf8cb-e3be-4446-be73-498e87a3e4c7
bec9e0a1-cd85-4f0c-b35b-498e87a3e4cc
0e0ea724-e145-4932-b0df-498e87a3e4d0
30ab3e05-26e3-44af-a82f-498e87a3
that database types are conservative by nature, almost as much as
accountants. But a little change is good now and then ;-)
Dennis Gearon
From: Guillaume Lelarge
To: r...@iol.ie
Cc: Elliot Chance , pgsql-general@postgresql.org
Subject: Re: The first dedicated PostgreSQL forum
Message-ID
NULL;
END;
' LANGUAGE plpgsql;
Wouldn't something like this need row-locking (SELECT for UPDATE) in order to
serialize the execution of all triggers?
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better
r,
(Love postgres otherwise). Is this still true?
Is there any architectural way to speed it up? I'd actually like to run it
every 2-60 seconds to update a counter on a page for the marketing guy, (which
for once, is me :-)
Dennis Gearon
Signature Warning
It is alwa
GCC gcc-4.4.real (Ubuntu
4.4.3-4ubuntu5) 4.4.3, 64-bit
Dennis Gearon
Signature Warning
It is always a good idea to learn from your own mistakes. It is usually a
better idea to learn from others’ mistakes, so you do not have to make them
yourself. from '
Thanks for the start. I'll start on it.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--- On Tue, 10/5/10, Craig Ringer wrote:
> From: Craig Rin
KUDOS, I almost never need to write the postgres group . . . because it just
works. It's only using postgres that I ever even read the digest that I
receive.
Soon I will have to write more to get performance tips. You guys are great on
this list and seem to always have answers, Thx.
ions and billlions' of records, Mwah Ha Ha
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--- On Sun, 9/12/10, Craig Ringer wrote:
> From: Craig Ringer
&g
I'm trying to import from a postgres database (which will work in parallel) to
a ElasticSearch databse (JSON input).
Is there anyway to get JSON output from postgres?
(googled, found only 'planner' output does this)
Dennis Gearon
Signature Warning
EARTH has
mal title' at
query time.
Would this be very expensive processor timewise?
I might just feed the whole long title in and have the display properties of
the browser truncate it.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Ho
es withi postgres to them.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
Dennis Gearon
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
collation, and then put any language that I want in it. Then make different
indexes using differnt collations. So when I get a user's locality and
langauge, I search for the closest index, and specifiy it when doing text based
searches.
Is this possible?
Dennis Gearon
Signature Warning
-
for the geographical location of the datum.
But the process you described went one further than I knew, the output in the
local tz. Thanks for that.
> Dennis Gearon
> wrote:
> >
> > I've got an application brewing that gathers the
> following data:
> > locati
timestamp
>with timezone (i.e. it's stored in absolute time (in seconds) relative to GMT)
Any easier way to do this?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yer
ing of SQL injection, anyone seen this site?
http://sqlmap.sourceforge.net/demo.html
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--- On Sun, 5/30/10, Tom Lane wrot
e for bulk purposes, to be input via the
command line, is Postgres vulnerable to SQL injection from that?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Se
d
statement(to avoid SQL injection), transaction without shuttling any
information back and forth between the database and the calling script?
Thanks in advance.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowde
for those walking up to a new server and who want to know the same information:
shell script invoked by:
script_filename database user
#!/bin/sh
psql -c "show INTEGER_DATETIMES;" -d $1 -U $2 -W
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherw
is there anyway with a running instance of postgres to find out if it was
compiled with:
BIGINT
vs
DOUBLE PRECISION
timestamps?
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Lau
Yep bad scraping from one site to another. Probably encoding.
Thanks for telling me what (should) have been obvious about the two INs. The
gobbledy gook was bad encoding between the two web pages.
select
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise
class where relkind IN IN (‘r’, ‘v’, ‘S’);
and that doesn't work either.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Sent via pgsql-general mailing lis
one table at a time, it works just
fine. Is this a known issue, feature, or I am doing something wrong? I thought
that doing a database recovery using a copy version of a dump would be a no
brainer, it would happen all in one transaction?
Dennis Gearon
Signature Warning
EARTH
Mon, Nov 30, 2009 at 9:02 PM, Dennis Gearon
Dennis Gearon
Merlin Moncure wrote:
Just make sure that when you inspect the record, do so: a. in a
transaction (preferably a brief one) and b. WITH UPDATE until your
operation completes. That way if two operations collide one will wait
for the ot
?
Thanks in advance. I RTFMed and Googled, but did not see the answer.
Dennis Gearon
Signature Warning
EARTH has a Right To Life,
otherwise we all die.
Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php
--
Sent via pgsql-general mailing list (pg
cally empty.
no other fancy stuff like functions/views/installed languages/blah,blah
running on Ubuntu latptop
I don't know if I have log files set up or where they'd be.
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivia
SILY 2 months worth of research and experiments in order to come to
the solution that I am using. In order to share that with the Open Source
world, I am posting my blog address to the related newsgroups that I'm on.
http://php-rest-i18n.blogspot.com/
Comment, save yourself some research
90726012447.gq5...@samason.me.uk>
On Sat, Jul 25, 2009 at 11:12:15AM -0700, Dennis Gearon wrote:
> If I receive a form via POST or PUT with with mulitple variables,
> files, application/json, others, is there anywhere in the environment
> to test he mime type of each variable
"blob_value": NULL
}
-103832778631715
Content-Disposition: form-data; name="blob_value"; filename="previous.png"
Content-Type: image/png
PNG
-----103832778631715
Dennis Gearon
Signature Warning
---
Thanks Bricklen
Dennis Gearon
--- On Tue, 7/21/09, bricklen wrote:
> From: bricklen
> Subject: Re: [GENERAL] commercial adaptation of postgres
> To: "Dennis Gearon"
> Cc: pgsql-general@postgresql.org
> Date: Tuesday, July 21, 2009, 7:33 AM
> Greenplum uses a modi
ng like that on the commercial page of the posgres site.
Does anyone know what it is out there in enterprise commercially modified
postgres servers? (on 64 bit machines, preferably)
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo
n't have that in the '/usr/share/zoneinfo/US'
directory. My bad.
I just have to read more on how to get it out relative to a different time
zone than it went in. I'll find it.
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivi
raphical location of the SUBMITTER.
> From: Adrian Klaver
> Subject: Re: [GENERAL] timestamp with time zone tutorial
Dennis Gearon wrote:
> > None of the examples of converting a string
> to_timestamp() show using a
> > time zone input as an input.Does it allow full length
rom: Adrian Klaver
> Subject: Re: [GENERAL] timestamp with time zone tutorial
> To: "Dennis Gearon"
> Cc: pgsql-general@postgresql.org
> Date: Sunday, July 19, 2009, 5:15 PM
> On Sunday 19 July 2009 4:56:09 pm
> Dennis Gearon wrote:
> > I read it better, and
I read it better, and it makes more sense now.
But,
I'd like it to show how to insert:
'strings' - which it does
timestampz value -->using to_timestampz(...)
integers::timestampz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
:
(1) Post a good description.
(2) Post a link to a good description.
(3) Give input to me so that I can write a good tutorial to post on
the postgres site?
TIA,
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President E
I wish that I didn't have to say this, but that is over my head at this point.
I see this HUGE, steep mountain ahead of me and a little sign in front of it
saying, "Learning Curve, start here."
:-)
Dennis Gearon
Signature Warning
EARTH has a Right To Lif
store the first data.
Dennis Gearon
--- On Sun, 7/12/09, Brent Wood wrote:
> From: Brent Wood
> Subject: Re: [GENERAL] indexes on float8 vs integer
> To: gear...@sbcglobal.net
> Cc: pgsql-general@postgresql.org
> Date: Sunday, July 12, 2009, 1:52 PM
> Hi Dennis,
>
> Is t
ogle mapes provides.
I am expecting this table to be very huge. Hey, I want to be the next 'portal'
:-)
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo Morales
# The right to life: "The right for no ecosyste
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo Morales
# The right to life: "The right for no ecosystem to be eliminated by the
irresponsible acts of human beings."
# The right of biosystems to regenerate
sults.
What are the tradeoffs in storage space, indexed query speed of the DATE and
TIME formats, and speed of the math for the various for the combinations of
DATE and TIME that would be possible to derive timestamps from?
Dennis Gearon
Signature Warning
EARTH has a Right To Li
I could have just as easily described it as a table of SERIALS, one per row,
instead of per column.
:0)
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo Morales
# The right to life: "The right for no ecosystem to be eliminat
)
);
CREATE UNIQUE INDEX IDX_One_Group_Row_Only ON
singletons_for_last_grp_mbr_id_issued (group_id);
ALTER TABLE singletons_for_last_grp_mbr_id_issued
ADD CONSTRAINT group_singletons_for_last_grp_mbr_id_issued
FOREIGN KEY (group_id) REFERENCES group (group_id)
Dennis Gearon
Signature Warning
But a way to set a database to absolutely be strongly sql injection proof.
Comments?
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo Morales
# The right to life: "The right for no ecosystem to be eliminated by the
irresponsib
The site seems to be down Tom.
Tom Lane wrote:
I don't see any indexable operator there at all. You might care to read
http://developer.postgresql.org/docs/postgres/xindex.html
which describes the behaviors Postgres indexes have.
regards, tom lane
-
But it is possible to use multiple indexes on dates, and that is why the one at the
bottom works, right?
Would a single index get used for
SELECT appointment
FROM the_table
WHERE 0 <> (date_mask && date_range);
Tom Lane wrote:
No, an index can be used for one or the other. Since we don't yet ha
Great Idea! When I get that far, I will try it.
Gaetano Mendola wrote:
For partion in some way I don't mean only split it in more tables. You
can use some available tools in postgres and continue to see this table
as one but implemented behind the scenes with more tables.
One usefull and impressiv
Is the following example a good, and correct one, for using a functional
index? (the 'flip_bits' function would have to be written, and for the
correct size of bit(N) ):
I think I came up with a better way to search through some dates. It
would use a functional index. I am trying to see if a
in, however.
Joshua D. Drake wrote:
Dennis Gearon wrote:
Google probably is much bigger, and on mainframes, and probably Oracle
or DB2.
Google uses a Linux cluster and there database is HUGE. I do not know
which database
they use. I bet they built their own specifically for what they do
Google probably is much bigger, and on mainframes, and probably Oracle or DB2.
But the table I am worried about is the one sized >= 3.6 GIGA records.
Tino Wildenhain wrote:
Hi,
Am Do, den 21.10.2004 schrieb Dennis Gearon um 1:30:
I am designing something that may be the size of yahoo, google, e
My question is it possible to speed up a query doing preselects? What I'm working on
could end up being a very large dataset. I hope to have 100-1000 queries per second
(0r more?), and if very large tables are joined with very large tables, I imagine that
the memory would be get very full, overf
I am designing something that may be the size of yahoo, google, ebay, etc.
Just ONE many to many table could possibly have the following
characteristics:
3,600,000,000 records
each record is 9 fields of INT4/DATE
Other tables will have about 5 million records of about the same size.
There a
cc me please:
I can't find in the HTML documentation the max length of a bit string.
Anyone know where it is?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEma
Steven Klassen wrote:
* Dennis Gearon <[EMAIL PROTECTED]> [2004-10-12 08:13:07 -0700]:
turn off autocommit
Per connection.
start transaction
commit transaction
They're statements themselves that change the state of the
connection. You start a transaction, run your querie
please cc me
If I am using some server side langauge to access Postgres - php,
python, perl, asp, if I make a connection, do the following actions
affect the connection, or the individual query that contains them:
turn off autocommit
start transaction
commit transaction
SET schema
--
Bruno Wolff III wrote:
On Thu, Oct 07, 2004 at 22:35:50 -0600,
Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote:
About regular views, how does that speed things up, other than the initial
SQL interpretation of the view not needing to b
Michael Fuhr wrote:
On Thu, Oct 07, 2004 at 09:08:18PM -0700, Dennis Gearon wrote:
About regular views, how does that speed things up, other than the initial
SQL interpretation of the view not needing to be done?
I didn't mean to imply that views would speed things up -- I was
merely sugge
Michael Fuhr wrote:
On Thu, Oct 07, 2004 at 10:07:47AM -0700, Dennis Gearon wrote:
If I want to set up a dbase with normalized tables for inserts,and a
flattened table for selects, am i going in the right direction for
speeding up a busy site?
Are you familiar with views? If so, is there a
If I want to set up a dbase with normalized tables for inserts,and a
flattened table for selects, am i going in the right direction for
speeding up a busy site?
Also, if some of you are also doing this, how and how often do you do
the SELECT from the normalized tables to the flattened table?
An
Use a post trigger function, ON UPDATE, INSERT which essentially has
this in it:
if ( ISNULL(new.a) AND ISNULL(new.b) ){ RAISE NOTICE "blah blah"; }
I work with PHP a lot, just a little plpgsql, so, the grammar may be
wrong above.
Ben <[EMAIL PROTECTED]> wrote:
If I have have the table:
create
please cc me as I am on digetst:
What is the storage format of 'date'? Is it like a timestamp?
I want to know in order to choose representations in a table that will
receive LOTS of reads with a WHERE clause that chooses dates, and TIMES,
past a supplied reference
The postgres engine saves the function bodies, at least, without removing the carriage
returns.
Could it be changed to report the LINE within the function body that has the problem,
based on the carriage return?
I don't have an editor that counts characters within a document, but even if I did,
I just read release notes for 7.4 where it said:( in plpgsql)
allows declaration of record type without %ROWTYPE
So, before that, there was no way to have a record returned of arbitrary
fields from a User Defined Function?
---(end of broadcast)--
Is this the correct way to return values in a record from a UDF in 7.4.+ ?
Is it ok to modify the arguments as in 'arg_int'?
-- return type should be RECORD
--
CREATE OR REPLACE FUNCTION test_function( int )
RETURNS RECORD AS '
DECLARE
arg_int ALIAS FOR $1;
var_record_out
WOW, that is the most comprehensive, 'nearing to commercial capability' update of
Postgres (and any OTHER OSS project) that I've seen in all my readings about and
dealings with Postgres. I would be VERY surprised if Postgres doesn't win some major
awards (and accounts) now that this has happened
I don't seem to see my messages in the digest. Is this a mail setting? I thought that
only blockable in the single message mode.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
please CC me.
Are the UDF/functions/procedures written by users available in all schemas in a DB?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
IIRC, psql (and the createuser shell script and such) treat it as if you
had double quoted its argument because of the way shells handle quotes
which would necessitate something like '"FOO"&#
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password 'password'
I
length
characters
character set (?)
for user names?
one underscore and a short name.
Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user
another name that does not work is 'H1q2W3e4R5_web_user'.
It seems to not like many alternations between numbers and letters.
Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'ps
er, so the system is
finding it, I just can't authenticate into it.
Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user&#x
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password 'password'
I CANNOT connect using 'psql', I get authentication error.
-
ANYONE have any ideas why?
---
Please CC me.
When I connect to a database from PHP script called from the web via Apache, running on the same
machine as the DB, that's server name "localhost", right?
I can't seem to get a php script to connect with the same parameters that I can use
using telnet and 'psql'.
--
Bruno Wolff III wrote:
On Wed, Jun 30, 2004 at 18:23:08 -0500,
[EMAIL PROTECTED] wrote:
What do other sites with mondo databases do?
There have been comments from people using storage systems that they
can freeze the storage system and get a consistant snap shot of the
file system. This can be u
Tom Lane wrote:
Dennis Gearon <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
The indexes on the shared system tables (eg, pg_database) are the only
issue here. One possible solution is to require that no locale-aware
datatypes ever be used in these indexes. I think right now this is true
b
Tom Lane wrote:
Chris Gamache <[EMAIL PROTECTED]> writes:
~>=~
~<=~
~<>~
~<~
~=~
~>~
They aren't familiar to me, but I can tell that they are text comparison
operators. The details of what and how they compare is a mystery to me!
Those are the non-locale-aware operators that Peter added to suppo
So, do you guys ever get together physically with a white board?
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
John Sidney-Woollett wrote:
For what it's worth, we have a unicode 7.4.1 database which gives us the
sorting and searching behaviour that we expect (with the exception of
the upper and lower functions). We access the data via jdbc so we don't
have to deal with encoding issues per se as the drive
Richard Huxton wrote:
Dennis Gearon wrote:
If I've read everything right, in order to get:
multiple languages on a site
with the functionality of ALL of:
REGEX
LIKE
Correctly sorted text
A site would have to:
create a cluster for every language needed
run a sep
e.
Tatsuo Ishii wrote:
On Wed, 23 Jun 2004, Dennis Gearon wrote:
This is what has to be eventually done:(as sybase, and probably others do it)
http://www.ianywhere.com/whitepapers/unicode.html
Actually, what probably has to be eventually done is what's in the SQL
spec.
Which is AFAICS basic
AFAIK, every database uses some sort of 'large object interface'. Surely
you could still move between DBs even using BLOB fields?
"Sailer, Denis (YBUSA-CDR)" <[EMAIL PROTECTED]> wrote:
There was a posting in the mailing list archives that I can't find
anymore. The web site right now is present
H..,
There was a post running about using C_LOCALE is the only way to use
LIKE, and I put something similar to the below in comment to it. It
never showed up on the list. Oh well.
If I wanted a multinational database capable of many langauges,and
wanted the most functionality of sor
please CC me, I am on digest
-
I have the following code from an application that is 'mysql_centric'. I
want to make it generic across all databases, if it's possible,
especially postgres :-)
mysql version:
INSERT INTO calendar_setting SET setting='colorEvent',
<>How about using phpPgAdmin? Or something like that?
Also, is there a SQL statement that will return all the possible
privileges? Use that in a subselect and then grant WHERE?
Chris Ochs <[EMAIL PROTECTED]> wrote:
Is there a shortcut to grant all privileges on a schema and it's objects to
a use
Stephan Szabo wrote:
On Sun, 16 May 2004, Dennis Gearon wrote:
CC me please.
How do I set up a one to many relationship in Postgres, (any DB for that
matter.)
I.E., if a delete or update of a child table causes a row in the parent
table to no longer refer to any rows in the child table, to
Peter Eisentraut wrote:
Dennis Gearon wrote:
How do I set up a one to many relationship in Postgres, (any DB for
that matter.)
Read about foreign keys:
http://www.postgresql.org/docs/7.4/static/ddl-constraints.html#DDL-CONSTRAINTS-FK
That only takes care of if the PARENT is deleted
Given:
CREATE TABLE Usrs(
usr_id SERIAL NOT NULL PRIMARY KEY,
usr VARCHAR(64) NOT NULL UNIQUE
);
CREATE TABLE Emails(
email_id SERIAL NOT NULL PRIMARY KEY,
email VARCHAR(128) NOT NULL UNIQUE
);
CREATE TABLE EmailTypes(
email_type_id SERIAL NOT NULL PRIMARY KEY,
ema
Thanks for all the answers everybody, but I need to know also an answer
to the other question:
Does the bytea make its own files automatically for large objects?
Also, how about backups with tables having bytea columns.?
Jonathan Bartlett wrote:
Also, if I wanted to put a *.pdf file in a bytea
I forgot, please CC me, I am on digest.
Dennis Gearon wrote:
when bytea, text, and varchar(no limit entered) columns are used, do
they ALWAYS use an extra table/file? Or do they only do it after a
certain size of input?
Also, if I wanted to put a *.pdf file in a bytea column, what
functions do
when bytea, text, and varchar(no limit entered) columns are used, do
they ALWAYS use an extra table/file? Or do they only do it after a
certain size of input?
Also, if I wanted to put a *.pdf file in a bytea column, what functions
do I use to escape any characters in it?
--
1 - 100 of 212 matches
Mail list logo
