On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
You mean what
I realise this is not strictly a Postgresql problem but I wondered if anyone
here was using ha-jdbc. I have tried asking on their mailing list but
apart from two of my questions there has been no traffic for 24 hours
and it appears to be a dead list.
I have a sngle instance of ha-jdbc working
Hi,
I've just had some discussion with colleagues regarding the usage of
hardware or software raid 1/10 for our linux based database servers.
I myself can't see much reason to spend $500 on high end controller
cards for a simple Raid 1.
Any arguments pro or contra would be desirable.
From
i think i make a big misstake by using kill -9 the postmaster .so ,what
should i do when i facing this problem, can someone give advise, cause i
quite new to postgresql.
how to check there is corrupted data in my database?
it there anyway i can do to prevent this error msg come back
again?
Title: RE: [GENERAL] database size grows (even after vacuum (full and analyze))
Ok.
I get the point. I'm using 7.2 because that's the one I got from the original Fedora Core 3 CD's.
I'll upgrade to the most recent.
Thank you all for your support.
jmf
-Original Message-
Hello,Pgcrypto SHA 256/384/512 algorithm don't work on RedHat:
db=# SELECT digest('test', 'sha1');
digest
--
\251J\217\345\314\261\233\246\034L\010s\323\221\351\207\230/\273\323
(1 row)
db=# SELECT digest('test', 'sha256');
Hi Hannes,
Hannes Dorbath a écrit :
Hi,
I've just had some discussion with colleagues regarding the usage of
hardware or software raid 1/10 for our linux based database servers.
I myself can't see much reason to spend $500 on high end controller
cards for a simple Raid 1.
Naa, you can
On 09.05.2006 12:10, Jean-Yves F. Barbier wrote:
Naa, you can find ATA | SATA ctrlrs for about EUR30 !
Sure, just for my colleagues Raid Controller = IPC Vortex, which resides
in that price range.
For bi-core CPUs, it might be true
I've got that from pgsql.performance for multi-way
On 5/9/06, Joe Kramer [EMAIL PROTECTED] wrote:
Fedora core has OpenSSL 0.9.7 installed by default. And it's not possible to
install 0.9.8 because of glibc conflict.
I suspect pgcrypto looks for SHA256 in OpeSSL lib when it should use
built-in.
SHA256 is working fine on Windows but on Redhat it
Thanks, but I need it to work out-of-the-box, with standard installation of RedHat or Gentoo and standard PostgreSQL rpm.
I am developing application with PortgreSQL and I can't tell customer
to Recompile PostgreSQL and see if it works then try to use non-openssl pgcrypto or try to compile
Martijn van Oosterhout wrote:
On Thu, May 04, 2006 at 12:22:01PM +0100, Gavin Hamill wrote:
At a guess rip = return instruction pointer, rsp = return stack point.
The fact that they're all the same seems to rule out hardware.
That's good to hear (in one way... :)
fore starting the
On 5/9/06, Joe Kramer [EMAIL PROTECTED] wrote:
Thanks, but I need it to work out-of-the-box, with standard installation of
RedHat or Gentoo and standard PostgreSQL rpm.
I am developing application with PortgreSQL and I can't tell customer to
Recompile PostgreSQL and see if it works then try to
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Hannes Dorbath wrote:
Hi,
I've just had some discussion with colleagues regarding the usage of
hardware or software raid 1/10 for our linux based database servers.
I myself can't see much reason to spend $500 on high end controller
cards
hello,
I want to correctly sort English, Hebrew, Russian ...
What is the best encoding for this ? ( utf-8 ? )
In the IRC i been told that utf-8 is not the solution and actually there
is no solution to correctly sort many languages.
Is that true ? Will it matter if each language will be
On 5/9/06, Marko Kreen [EMAIL PROTECTED] wrote:
On 5/9/06, Joe Kramer [EMAIL PROTECTED] wrote: Thanks, but I need it to work out-of-the-box, with standard installation of RedHat or Gentoo and standard PostgreSQL rpm.
I am developing application with PortgreSQL and I can't tell customer to
On Tue, 09 May 2006 10:59:20 +0530
N Srinivasa [EMAIL PROTECTED] wrote:
Hi
I downloded postgresql source code, and compile it in windows
platform, can any body plz tell me that how can i debug the
sourcecode in windows platform,
what are the steps are i should go through..
Regards
Hello,
for 4 weeks I have imported (text) data of 50 DVD's from a customer
into my PostgreSQL and now I have a very big problem... The maintable
(called 'timeline' is around 350 GByte in size...
...and searching is the hell!
Since I try to redesign my
You will need to provide more information about the data requirement- such
as column types, what you need to search for, and the actual queries and
execution plans.
Purely as a guess, it seems like you haven't tried partial indexes:
On May 8, 2006, at 11:05 PM, Guido Neitzer wrote:
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access,
ruby on
rails? Why is it your favorite? Which would you
On 5/9/06, Joe Kramer [EMAIL PROTECTED] wrote:
On 5/9/06, Marko Kreen [EMAIL PROTECTED] wrote:
The fact that Fedora pgcrypto is linked with OpenSSL that does not
support SHA256 is not a bug, just a fact.
It's not Fedora only, same problem with Gentoo/portage.
I think it's problem for all
Steve Atkins wrote:
On May 8, 2006, at 11:05 PM, Guido Neitzer wrote:
On 09.05.2006, at 0:33 Uhr, Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which
On Tue, May 09, 2006 at 12:10:32 +0200,
Jean-Yves F. Barbier [EMAIL PROTECTED] wrote:
Naa, you can find ATA | SATA ctrlrs for about EUR30 !
But those are the ones that you would generally be better off not using.
Definitely NOT, however if your server doen't have a heavy load, the
software
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm having trouble with a dump and restore:
$ pg_dump --format=t --schema=babase --data-only --user babase_admin
babase_test | pg_restore --data-only --disable-triggers --user
babase_admin --dbname=babase
Greetings,
I am running postgres 7.4.7 on debian sarge.
I need to run an SQL query and store the results in a file. The format
needs to be comma separated values (CSV), so I can import this later in
Excel.
Any ideas on how to accomplish this?
much appreciated,
Ryan
Karl O. Pinc [EMAIL PROTECTED] writes:
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Um ... it looks to me like you're trying to restore into an existing
table that already has the same data loaded ...
That's what I thought at first, except that I had just created
the db structure with a
On 05/09/2006 10:24:28 AM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Um ... it looks to me like you're trying to restore into an
existing
table that already has the same data loaded ...
I'm not clear on where to start with this.
I have a java application that is trying to dynamically drop a set of
tables. Problem is, when it gets to a particular table and I execute
the drop table foo cascade command from a prepared statement, the
query never returns. It just hangs indefinitely. I presume that it is
waiting on a
Dan Armbrust [EMAIL PROTECTED] writes:
I have a java application that is trying to dynamically drop a set of
tables. Problem is, when it gets to a particular table and I execute
the drop table foo cascade command from a prepared statement, the
query never returns. It just hangs
On Tue, 2006-05-09 at 04:16, Hannes Dorbath wrote:
Hi,
I've just had some discussion with colleagues regarding the usage of
hardware or software raid 1/10 for our linux based database servers.
I myself can't see much reason to spend $500 on high end controller
cards for a simple Raid 1.
On Tue, 09 May 2006 10:58:07 -0400
Ryan Suarez [EMAIL PROTECTED] wrote:
Greetings,
I am running postgres 7.4.7 on debian sarge.
I need to run an SQL query and store the results in a file. The
format needs to be comma separated values (CSV), so I can import this
later in Excel.
Any
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
Hello,
What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql Relocations: (not
relocateable)
Version : 7.3.4 Vendor: Red
Hello All
So I have an old database that is ASCII_SQL encoded. For a variety of reasons
I need to convert the database to UNICODE. I did some googling on this but
have yet to find anything that looked like a viable option, so i thought I'd
post to the group and see what sort of advice might
On 09.05.2006, at 16:31 Uhr, Steve Atkins wrote:
Is that actually true? My understanding was that under the most recent
license changes it was not possible to deploy it to any platform other
than XServe.
Wrong. You are allowed to deploy on any platform you like, but only
Mac OS X Server is
Don't buy those drives. That's unrelated to whether you use hardware
or software RAID.
Sorry that is an extremely misleading statement. SATA RAID is perfectly
acceptable if you have a hardware raid controller with a battery backup
controller.
And dollar for dollar, SCSI will NOT be faster
On Tue, 2006-09-05 at 13:19 +1200, Brent Wood wrote:
On Mon, 8 May 2006, Blair Lowe wrote:
Hi,
I have had this problem for a while, and have not been able to find
anything in the archives or on search engines:
If I want to back up a client's database on our shared web server, I
On 09.05.2006, at 16:52 Uhr, Reid Thompson wrote:
*WebObjects Distribution License
$699 per copy*
WebObjects, the premier web application server used by hundreds of
corporations, is now available for redistribution by web
application developers just like you.
Upon signature by Apple, the
Blair Lowe [EMAIL PROTECTED] writes:
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql Relocations: (not
relocateable)
Version : 7.3.4
A word of advice: if there is any chance that a column (e.g. text) contains
an embedded newline, you will be much better off outputting the data in
simple xml, instead of CSV. This works very well with Excel for import. I
just did a simple program for this recently.
Susan
On Tue, 2006-09-05 at 12:25 -0400, Tom Lane wrote:
Blair Lowe [EMAIL PROTECTED] writes:
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql
Tom Lane wrote:
Blair Lowe [EMAIL PROTECTED] writes:
On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
What version of PostgreSQL is this that you are using? Because it
]# rpm -qi postgresql
Name: postgresql Relocations: (not
relocateable)
Version :
I have a 7.3.4 cluster that just sigsegv'd. I know an
upgrade is desperately needed. In the meantime, does the
following gdb output provide any clues as to what we might
be able to do to nurse it along until we upgrade?
Thanks,
Ed
PostgreSQL 7.3.4 on hppa2.0w-hp-hpux11.00, compiled by GCC gcc
On May 9, 2006, at 8:51 AM, Joshua D. Drake wrote:
(Using SATA drives is always a bit of risk, as some drives are lying
about whether they are caching or not.)
Don't buy those drives. That's unrelated to whether you use hardware
or software RAID.
Sorry that is an extremely misleading
Bruno Wolff III escreveu:
On Mon, May 08, 2006 at 23:10:31 +0900,
kmh496 [EMAIL PROTECTED] wrote:
doesn't that user have to exist since you are using ident method? that
means unix username == postgres username.
do you have a user named maragato_test on the system?
did you create
First, i have no knowledge of anyone that have implemented full
disjunctions(ever) aside
from the theoretical works of my colleagues.
With the exception of a corner case of it, that I believe was a simulation in
96.
(A. Rajaman and J.D. Ullman Integrating information by outerjoins and
hi all,
I try to solve a litle problem, with PostgreSQL 8.1.3 on windows with UTF8.
I read all the documentation related to psql on windows, I turn my cmd.exe encoding to codepage 1252 with the good font.
When I try a connection to my UTF8 database with psql (with my windows
cp1252 terminal) I
Good Day I Just want to ask on how to allow a non-local in PostgreSQL withoutadding it in pg-hba.confI just want to view a desktop application on Web, yes it works, but you need to allow those I.P. addresses that will gonna connect to postgreSQL. What I want is everyone in the net
Each distant database works on its own domain of data. Then no conflict should
happen during updates.
One thing I have not specified is that the distant databases don't handle
global data but only data collected at the local level.
Slony-1 seems not to provide replication from multi-partial
On Mon, 8 May 2006, Blair Lowe wrote:
Hi,
I have had this problem for a while, and have not been able to find
anything in the archives or on search engines:
If I want to back up a client's database on our shared web server, I
would type:
pg_dump database_name
try pgdump -t table
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid controller with a
battery backup controller.
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity
Vivek Khera [EMAIL PROTECTED] writes:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity that you will get with SATA.
Does this hold true still under heavy concurrent-write loads? I'm
preparing yet another
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm having trouble with a dump and restore:
Um ... it looks to me like you're trying to restore into an existing
table that already has the same data loaded ...
Thanks everybody, the problem was in the schemas
Vivek Khera wrote:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid controller with a
battery backup controller.
And dollar for dollar, SCSI will NOT be faster nor have the
I'm trying to generate a query that will handle tags matching in a database.
The simplified structure is
create table contacts (
id serial primary key,
name varchar
);
create table books (
id serial primary key,
name varchar
);
create table tags (
id serial primary key,
name varchar
You're not suggesting that a hardware RAID controller will protect
you against drives that lie about sync, are you?
Of course not, but which drives lie about sync that are SATA? Or more
specifically SATA-II?
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command
On May 9, 2006, at 11:26 AM, Joshua D. Drake wrote:
You're not suggesting that a hardware RAID controller will protect
you against drives that lie about sync, are you?
Of course not, but which drives lie about sync that are SATA? Or
more specifically SATA-II?
SATA-II, none that I'm
Douglas McNaught wrote:
Vivek Khera [EMAIL PROTECTED] writes:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity that you will get with SATA.
Does this hold true still under heavy concurrent-write loads? I'm
leo camalig wrote:
Good Day
I Just want to ask on how to allow a non-local in PostgreSQL
without adding it in
pg-hba.conf
You don't. pg_hba.conf is the place where you can specify who
can connect from where to which database using what authentication
method. Your only alternative to
tagged_type int -- points to the table this tag is tagging
My head exploded right about here. Is the schema written in stone, or
can it change?
What is the use case for this schema? What's it for? What is a tag
about?
Best Regards,
Wayne Conrad
---(end of
On Mon, May 08, 2006 at 18:37:31 -0700,
leo camalig [EMAIL PROTECTED] wrote:
Good Day
I Just want to ask on how to allow a non-local in PostgreSQL without adding
it in
pg-hba.conf
That isn't possible. You need to grant the access using that file.
I just want to view
On Tue, May 09, 2006 at 10:52:32AM -0600, Blair Lowe wrote:
In my test I do not see stuff2 either. The problem here is that I have
sensitive production data, so my tests are hard to read, and not able to
submit here.
You don't need to show any data, just the schema will be enough. An
example
On Mon, May 08, 2006 at 02:10:02PM -0700, robert wrote:
1) Isn't the user 'postgres' pre-configured? Running this seems to
imply so: 'select datname from pg_database;'
datname
---
postgres
This demonstrates a *database* named postgres. Users are in the pg_user
table.
2) Is
On 5/9/06, Marko Kreen [EMAIL PROTECTED] wrote:
On 5/9/06, Joe Kramer [EMAIL PROTECTED] wrote: On 5/9/06, Marko Kreen [EMAIL PROTECTED] wrote: The fact that Fedora pgcrypto is linked with OpenSSL that does not
support SHA256 is not a bug, just a fact. It's not Fedora only, same problem with
On Tue, 2006-05-09 at 12:52, Steve Atkins wrote:
On May 9, 2006, at 8:51 AM, Joshua D. Drake wrote:
(Using SATA drives is always a bit of risk, as some drives are lying
about whether they are caching or not.)
Don't buy those drives. That's unrelated to whether you use hardware
or
Currently the documentation says:
A database that is marked datallowconn = false in pg_database is
assumed to be properly frozen; the automatic warnings and wraparound
protection shutdown do not take such databases into account. Therefore
it's up to you to ensure you've correctly frozen a
Postgresql 8.1.3
Hi,
I'm wondering if there's a problem with pg_dump --create,
or if I'm just missing something.
It does not seem to restore things like:
ALTER DATABASE foo SET DateStyle TO European;
Shouldn't the database that is re-created be like
the database that is being dumped?
For our
The schema can change, but I rather not.
The use case is a web app where you can tag items with tags
(many-2-many). There are multiple items you can tag: contacts,
schedules, lists, etc... And then you can search and categorize by
tags. The standard for this if you look aroung the web is to
beer schreef:
Hello All
So I have an old database that is ASCII_SQL encoded. For a variety
of reasons I need to convert the database to UNICODE. I did some
googling on this but have yet to find anything that looked like a viable
option, so i thought I'd post to the group and see what sort
On May 9, 2006 01:03 pm, jef peeraer [EMAIL PROTECTED] wrote:
well i recently struggled with the same problem. After a lot of trial
and error and reading, it seems that an ascii encoded database can't use
its client encoding capabilities ( set client_encoding to utf8 ).
i think the easist
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm wondering if there's a problem with pg_dump --create,
or if I'm just missing something.
It does not seem to restore things like:
ALTER DATABASE foo SET DateStyle TO European;
Shouldn't the database that is re-created be like
the database that is
It is possible to install postgres on usb driver to run it anywhere???
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it anywhere???
---(end of
broadcast)--- TIP 4: Have you searched our
list archives?
On 05/09/2006 03:47:20 PM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm wondering if there's a problem with pg_dump --create,
or if I'm just missing something.
It does not seem to restore things like:
ALTER DATABASE foo SET DateStyle TO European;
Shouldn't the database that
On 5/9/06, John Purser [EMAIL PROTECTED] wrote:
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it anywhere???
---(end of
broadcast)--- TIP 4: Have you searched
Ed L. [EMAIL PROTECTED] writes:
from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
(gdb) bt
#0 0x12d288 in InitBufferPoolAccess ()
from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
Error accessing memory address 0x0: Invalid argument.
Right offhand I'd imagine that the
A) Possible is a BIG word. So is anywhere. If you could narrow
these two down a bit it might help answer your question.
possible mean how to do it
anywhere mean a pc with a windows os
---(end of broadcast)---
TIP 6: explain analyze is your
On Tue, 9 May 2006 17:06:53 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
On 5/9/06, John Purser [EMAIL PROTECTED] wrote:
On Tue, 9 May 2006 16:54:37 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
It is possible to install postgres on usb driver to run it
anywhere???
Im trying to
On Tue, 9 May 2006 17:10:21 -0400
Rodrigo Cortés [EMAIL PROTECTED] wrote:
A) Possible is a BIG word. So is anywhere. If you could narrow
these two down a bit it might help answer your question.
possible mean how to do it
anywhere mean a pc with a windows os
Tom Lane wrote:
David Link [EMAIL PROTECTED] writes:
The following large EXPLAIN SELECT Statement fails to return, but
continues to take up processing time until it is killed.
[ 52-way join... ]
Am I right in guessing that all the sales_xxx tables are the same size
and have similar
On Tuesday May 9 2006 3:07 pm, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
(gdb) bt
#0 0x12d288 in InitBufferPoolAccess ()
from /opt/pgsql/installs/postgresql-7.3.4/bin/postmaster
Error accessing memory address 0x0:
Is my understanding correct that the following is vulnerable to SQL
injection in psql:
CREATE OR REPLACE FUNCTION fx ( my_var bchar)
RETURNS void AS
$$
BEGIN
INSERT INTO fx VALUES ( my_var ) ;
END;
$$
LANGUAGE 'plpgsql' VOLATILE
Where this is NOT subject to SQL injection:
CREATE OR REPLACE
On 9 May 2006 17:04:31 -0700, Karen Hill [EMAIL PROTECTED] wrote:
Is my understanding correct that the following is vulnerable to SQL
injection in psql:
CREATE OR REPLACE FUNCTION fx ( my_var bchar)
RETURNS void AS
$$
BEGIN
INSERT INTO fx VALUES ( my_var ) ;
END;
$$
LANGUAGE 'plpgsql' VOLATILE
Joshua D. Drake wrote:
Vivek Khera wrote:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
Sorry that is an extremely misleading statement. SATA RAID is
perfectly acceptable if you have a hardware raid controller with a
battery backup controller.
And dollar for dollar, SCSI
Scott Marlowe wrote:
Actually, in the case of the Escalades at least, the answer is yes.
Last year (maybe a bit more) someone was testing an IDE escalade
controller with drives that were known to lie, and it passed the power
plug pull test repeatedly. Apparently, the escalades tell the
On May 8, 2006, at 12:14 PM, Thomas Sondag wrote:
I tried various things with the --set option of psql without
success, like
--set client_encoding=win1252 or --set CLIENT_ENCODING=win1252 or --
set encoding=win1252.
The variables are case sensitive, so it looks like you left out the
beer schreef:
Hello All
So I have an old database that is ASCII_SQL encoded. For a variety of reasons
I need to convert the database to UNICODE. I did some googling on this but
have yet to find anything that looked like a viable option, so i thought I'd
post to the group and see what sort
On May 9, 2006, at 11:26 AM, Joshua D. Drake wrote:
Of course not, but which drives lie about sync that are SATA? Or
more specifically SATA-II?
I don't know the answer to this question, but have you seen this tool?
http://brad.livejournal.com/2116715.html
It attempts to experimentally
I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error at or near ( at character 39
In statement:
CREATE TABLE users (user_ID SERIAL(12), first_name character
varying(40) NOT NULL, last_name character varying(40) NOT NULL, password
character
If you count over 39 characters, you will see the parser is barking at
this:
user_ID SERIAL(12)
^
See:
http://www.postgresql.org/docs/8.1/static/datatype.html#DATATYPE-SERIAL
to find out why your definition is confusing Mr. SQL-parser.
-Original Message-
From: [EMAIL
Adam [EMAIL PROTECTED] writes:
I'm trying to create a table and I'm getting this error:
ERROR: syntax error at or near ( at character 39
In statement:
CREATE TABLE users (user_ID SERIAL(12),
SERIAL doesn't take a parameter.
regards, tom lane
Adam wrote:
I'm trying to create a table and I'm getting this error:
SQL error:
ERROR: syntax error at or near ( at character 39
In statement:
CREATE TABLE users (user_ID SERIAL(12), first_name character
varying(40) NOT NULL, last_name character varying(40) NOT NULL,
On May 10, 2006, at 12:06 AM, Adam wrote:
CREATE TABLE users (user_ID SERIAL(12), first_name character
varying(40) NOT NULL, last_name character varying(40) NOT NULL,
password character varying(16) NOT NULL, email character varying
(100) NOT NULL, privilege integer(2) NOT NULL, PRIMARY KEY
Merlin Moncure [EMAIL PROTECTED] writes:
On 9 May 2006 17:04:31 -0700, Karen Hill [EMAIL PROTECTED] wrote:
Is my understanding correct that the following is vulnerable to SQL
injection in psql:
...
no, IMO this is the safest and best option.
Neither of the options that Karen shows are
Douglas McNaught [EMAIL PROTECTED] writes:
Vivek Khera [EMAIL PROTECTED] writes:
On May 9, 2006, at 11:51 AM, Joshua D. Drake wrote:
And dollar for dollar, SCSI will NOT be faster nor have the hard
drive capacity that you will get with SATA.
Does this hold true still under heavy
Steve Atkins [EMAIL PROTECTED] writes:
On May 9, 2006, at 2:16 AM, Hannes Dorbath wrote:
Hi,
I've just had some discussion with colleagues regarding the usage of
hardware or software raid 1/10 for our linux based database servers.
I myself can't see much reason to spend $500 on
94 matches
Mail list logo