Blake McBride writes:
> I am using PostgreSQL 10.10. I am having trouble incrementing a column for
> reasons I can't see. It's probably some basic SQL thing. Your help is
> appreciated.
> create table my_table (
> listid char(36) not null,
> seq smallint not null,
> item varchar(40
On 11/23/19 3:28 PM, Blake McBride wrote:
Greetings,
I am using PostgreSQL 10.10. I am having trouble incrementing a column
for reasons I can't see. It's probably some basic SQL thing. Your help
is appreciated.
create table my_table (
listid char(36) not null,
seq smallint not nul
Greetings,
I am using PostgreSQL 10.10. I am having trouble incrementing a column for
reasons I can't see. It's probably some basic SQL thing. Your help is
appreciated.
create table my_table (
listid char(36) not null,
seq smallint not null,
item varchar(4096),
primary key (lis
On Sat, Nov 23, 2019 at 10:42 AM Christoph Gößmann
wrote:
> Hi Jeff,
>
> You're right about that point. Let me redefine. I would like to drop all
> tokens which neither are the stemmed or unstemmed version of a known word.
> Would there be the possibility of putting a wordlist as a filter ahead o
"Jason L. Amerson" writes:
> I removed both version of PostgreSQL from Ubuntu. I had to delete some
> files manually. I used the repository to install PostgreSQL and then I
> configured it for remote access and now everything works great! I can
> log in from my Windows computers using pgAdmin. Tha
Adrian Klaver writes:
> Please reply to list also.
> Ccing list.
> On 11/22/19 11:36 PM, aleksey ksenzov wrote:
>> While I understand I can do everything with triggers/functions, for me
>> it looks like a good idea to have possibility to use constants in
>> constraints, so it would be very nice
I removed both version of PostgreSQL from Ubuntu. I had to delete some files
manually. I used the repository to install PostgreSQL and then I configured it
for remote access and now everything works great! I can log in from my Windows
computers using pgAdmin. Thank you to you and everyone else w
On 11/22/19 11:36 PM, aleksey ksenzov wrote:
Please reply to list also.
Ccing list.
We're already on 12.
While I understand I can do everything with triggers/functions, for me
it looks like a good idea to have possibility to use constants in
constraints, so it would be very nice if postgres
Hi Jeff,
You're right about that point. Let me redefine. I would like to drop all tokens
which neither are the stemmed or unstemmed version of a known word. Would there
be the possibility of putting a wordlist as a filter ahead of the stemming? Or
do you know about a good English lexeme list th
On Fri, Nov 22, 2019 at 8:02 AM Christoph Gößmann wrote:
> Hi everybody,
>
> I am trying to get all the lexemes for a text using to_tsvector(). But I
> want only words that english_stem -- the integrated snowball dictionary --
> is able to handle to show up in the final tsvector. Since snowball
>
Thanks Tim.
Jason L. Amerson
-Original Message-
From: Tim Clarke
Sent: Saturday, November 23, 2019 09:32 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: Client Computers
The ODBC drivers are generally very useful.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44
Thanks Ron.
Jason L. Amerson
From: Ron
Sent: Saturday, November 23, 2019 09:38 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: Client Computers
On 11/23/19 4:25 AM, Jason L. Amerson wrote:
Do my Windows 10 computers that will be clients, need PostgreSQL installed to
co
On 11/23/19 4:25 AM, Jason L. Amerson wrote:
Do my Windows 10 computers that will be clients, need PostgreSQL installed
to connect remotely to my server or is pgAdmin or some other client all I
need?
They only need pgAdmin installed if they're going to actually run pgAdmin.
If they're "ju
The ODBC drivers are generally very useful.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 23/11/2019 12:23, Jason L. Amerson wrote:
>
> Thanks
>
> Jason L. Amerson
>
> *From:* Daniel Baktiar
> *Sent:* Saturday, November 23, 2019 07:15 AM
> *To:* Jason L. Amers
On Fri, Nov 22, 2019 at 04:06:14PM -0800, Adrian Klaver wrote:
> On 11/22/19 3:52 PM, stan wrote:
> > A while back I ran into problems caused by security fix related to the
> > search path. I wound up adding a line to. for instance, this function:
> >
> > REATE FUNCTION
> > work_hours
> > (
> >
Thanks
Jason L. Amerson
From: Daniel Baktiar
Sent: Saturday, November 23, 2019 07:15 AM
To: Jason L. Amerson
Cc: PostgreSQL
Subject: Re: Client Computers
Hi Jason,
AFAIK, you just need the pgadmin installed.
Regards,
Daniel
On Sat, Nov 23, 2019 at 6:26 PM Jason L. Am
Hi Jason,
AFAIK, you just need the pgadmin installed.
Regards,
Daniel
On Sat, Nov 23, 2019 at 6:26 PM Jason L. Amerson
wrote:
> Do my Windows 10 computers that will be clients, need PostgreSQL installed
> to connect remotely to my server or is pgAdmin or some other client all I
> need?
>
>
>
>
> On 23 Nov 2019, at 3:24, Martin Mueller
> wrote:
>
> I've moved happily from MySQL to Postgres but miss one really good feature of
> MYSQL: the table of tables that let you use SQL queries to find out metadata
> about your table. Thus looking at the table of tables and sorting it by last
Do my Windows 10 computers that will be clients, need PostgreSQL installed
to connect remotely to my server or is pgAdmin or some other client all I
need?
Jason L. Amerson
19 matches
Mail list logo
