1. Is it documented anywhere that an apostrophe / single quote is bad news
inside of a C-style /* */ comment? I just found out the hard way.
Seems to be OK inside of the one line -- comment.
2. How does one view column comments created with COMMENT ON COLUMN?
TIA.
Brian E. Pangburn
Hello all,
How would I setup a sequence that would reflect, for example, abc-0001?
Hello all,
Is it at all possible to create a table on the fly from a CSV file?
d-coding the
SELECT statement, and get the same errors.
This sounds like a total Catch-22 to me, which must mean I'm doing
something wrong. Help!
Thanks in advance!
Brian Troxell
[EMAIL PROTECTED]
Brian Troxell wrote:
> I'm getting an error when forming SELECT statements using the new 7.1
> EXECUTE command. The error states, simply, that there was an unexpected
> SELECT within the EXECUTE command.
>
> Which leads me to ask: can I actually form SELECT statements us
to be doing?
Thanks in advance.
-Brian Troxell
[EMAIL PROTECTED]
Okay now I am an Idoit. How do I tell what is used for the carriage
return? I know how to make the replacement I just can not tell they
characters used.
At 11:52 AM 12/18/00 -0500, Brett W. McCoy wrote:
>On Mon, 18 Dec 2000, Brian C. Doyle wrote:
>
> > I have a file that I
Hello all,
I have a file that I am trying to import/copy into a table. The problem
that I am having is that there are carriage returns through out the
document. These carriage returns should be copied into the column it
belongs to yet during the
copy table from '/home/location/file.ext' usin
that
the pg_connect from the pgsql module (ext/pgsql) is being executed, it's
just not finding the PQconnectdb function from the libpq.so library.
> Travis
> Brian Edginton ([EMAIL PROTECTED]) wrote:
>>
>>
>> I'm trying to use the php/postgresql interfa
Larry Rosenman <[EMAIL PROTECTED]> wrote:
> And, is the postmaster started with -i?
Yup.
Larry Rosenman <[EMAIL PROTECTED]> wrote:
> And, is the postmaster started with -i?
Yup
more immediate solution out
there for you. ;)
-Brian
>Date: Fri, 14 Apr 2000 16:29:23 +1000 (EST)
>From: Matthew Arnison <[EMAIL PROTECTED]>
>To: Ed Loehr <[EMAIL PROTECTED]>
>cc: [EMAIL PROTECTED], Rabble-Rouser <[EMAIL PROTECTED]>, Manse
Jacobi <[EMAIL PROTEC
Forget my last posting - sorry - I'm being stupid .fs size is, of course 4 Tb
I am constructing a large ( by some standards) database where the largest table
threatens to be about 6-10 Gb on a Linux system. I understand that postgresql
splits the tables into manageable chunks & I have no problem with that as a
workround for the 2 GB fs limit
.. My question concerns the
nitely got something wierd going on, like those
mixed libraries.
Thanks for any hints or tips.
Brian Curnow
On Thu, 13 May 1999, Brett W. McCoy wrote:
> On Thu, 13 May 1999, Brian wrote:
>
> > Would something like this be appropriate?
> >
> > /usr/bin/postmaster -B 256 -i -S -D/var/lib/pgsql -o -F -B 256 -S 1024
> >
> > or should -B just be in their once? in th
ming field "insertid" was the one being updated by the sequence, but
that doenst seem to work.
>
> -----Original Message-
> From: Brian [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 14, 1999 2:59 PM
> To: [EMAIL PROTECTED]
>
I have a sequence in a table that increments upon insert. After doing the
insert, is their a way (function maybe?) to get the sequences value
without having to do another select?
Brian
-
Brian Feeny (BF304) [EMAIL PROTECTED]
318-222
t;);
$sth->execute;
$insertid = $sth->{'idnum'};
I would think that last line should be able to retreive it from the
statment handle, but it doesn't work.
Is the only way, to do *another* select after I insert and get the data?
I would hope after doing the insert, since I h
quot; for each and every table, and that can be
alot of tables! Any ideas? Should this be working?
Brian
--
Brian Feeny (BF304) | ShreveNet Inc. - Premium Internet Service Provider
Network Administrator | Shreveport,
HP or anything
like that. So I am really just looking for the thumbs up that all I have
to do is a dump all.
Anyone note any good performance increase from 6.3.1 to 6.3.2?
--
Brian Feeny (BF304) | ShreveNet Inc. - Pr
he entire field have to be updated?
Once again, field name "desc" data is "The red car", can I make it say
"The red car with blue lights"? Or do I have to update the entire field.
Brian
--
Bria
to it, It could
be 100% restored?
Brian
--
Brian Feeny (BF304) | ShreveNet Inc. - Premium Internet Service Provider
Network Administrator | Shreveport, Louisiana - http://www.shreve.net/
[EMAIL PROTECTED] | Web Ho
o use Postgres. One of the reasons we beleive boardtown
doesn't support Postgres at this time is because of a few features SQL
server has over Postgres, and they would have to work around those.
Brian
>
> Bruce Tong | Got me an office; I'm there late at night.
;
>
/-- [EMAIL PROTECTED] -\
| Brian Feeny| USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN &
Is there a difference in doing:
foo int PRIMARY KEY
and
CREATE INDEX idx1 on table (foo);
does both do the same thing (create an index)? is one faster or preffered
over the other?
/-- [EMAIL PROTECTED] -\
| Brian Feeny
maintain that many different copies of one program.
Thank you for your help,
Brian
/-- [EMAIL PROTECTED] -----\
| Brian Feeny| USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting,
bles, or do you have to do
like:
CREATE INDEX on forum idx1 (datestamp);
CREATE INDEX on forum idx2 (id);
CREATE INDEX on forum idx3 (thread);
If so, then how would you say "primary"? I know some databases such as
mSQL did away with "PRIMARY KEY", and you just make indices instea
Check the host-based access. In the file pgsql/data/pg_hba.conf you may
need to
add a line like this:
host all 198.168.0.12 255.255.255.0 trust
But replace 198.168.0.12 with your client IP.
Good luck!
Brian Schaffner <[EMAIL PROTECTED]>
Independent Software Cont
501 - 529 of 529 matches
Mail list logo